HTMLレポートの日付フォーマットが正しくないため、エラーが発生しましたORA-01861:文字とフォーマット文字列が一致しません
2759 ワード
PROCEDURE MAIN(ERRBUF OUT VARCHAR2,
RETCODE OUT VARCHAR2,
P_CUSTOMER_ID IN VARCHAR2,
P_PERSON_ID IN VARCHAR2,
P_MAKER_ID IN VARCHAR2,
P_START_DATE IN VARCHAR2, --
P_END_DATE IN VARCHAR2 --
) IS
l_contract_date_from DATE; --
l_contract_date_to DATE; --
BEGIN
RETCODE := '0';
l_contract_date_from := trunc(fnd_conc_date.string_to_date(P_START_DATE));--
l_contract_date_to := trunc(fnd_conc_date.string_to_date(P_END_DATE));--
OUTPUT_DATA_HTML(P_CUSTOMER_ID,
P_PERSON_ID,
P_MAKER_ID,
l_contract_date_from, --
l_contract_date_to --
);
END;
PROCEDURE output_data_html(P_CUSTOMER_ID IN VARCHAR2,
P_PERSON_ID IN VARCHAR2,
P_MAKER_ID IN VARCHAR2,
P_START_DATE IN DATE, --
P_END_DATE IN DATE --
) IS
BEGIN
SELECT *
FROM OE_ORDER_HEADERS_ALL OOH
WHERE (p_start_date IS NULL OR trunc(ooh.ordered_date) >= p_start_date)
AND (p_end_date IS NULL OR trunc(ooh.ordered_date) <= p_end_date);
END;
-- FND_STANDARD_DATE