DBA Data[Home] [Help]

APPS.GR_XML_REPORTS dependencies on FND_DATE

Line 25: p_from_date := fnd_date.canonical_to_date(p_from_date_sent);

21: l_xml_query VARCHAR2 (32000);
22: l_queryctx DBMS_XMLGEN.ctxhandle;
23: l_xml_result CLOB;
24: BEGIN
25: p_from_date := fnd_date.canonical_to_date(p_from_date_sent);
26: p_to_date := fnd_date.canonical_to_date(p_to_date_sent);
27:
28: l_xml_query :=
29: ' SELECT organization_code '

Line 26: p_to_date := fnd_date.canonical_to_date(p_to_date_sent);

22: l_queryctx DBMS_XMLGEN.ctxhandle;
23: l_xml_result CLOB;
24: BEGIN
25: p_from_date := fnd_date.canonical_to_date(p_from_date_sent);
26: p_to_date := fnd_date.canonical_to_date(p_to_date_sent);
27:
28: l_xml_query :=
29: ' SELECT organization_code '
30: || ' , SYSDATE report_date '