DBA Data[Home] [Help]

APPS.OE_CUSTACCEPTREP_PVT dependencies on FND_DATE

Line 1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);

1283: oe_debug_pub.add( 'OEXCARR: Starting Generate_ReportData procedure') ;
1284: END IF;
1285:
1286: --myerrams, Bug: 5214119. Converting the VARCHAR2 variables to DATE variables.
1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);
1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);

Line 1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);

1284: END IF;
1285:
1286: --myerrams, Bug: 5214119. Converting the VARCHAR2 variables to DATE variables.
1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);
1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);
1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);

Line 1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);

1285:
1286: --myerrams, Bug: 5214119. Converting the VARCHAR2 variables to DATE variables.
1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);
1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);
1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);
1293: --myerrams, Bug: 5214119. end.

Line 1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);

1286: --myerrams, Bug: 5214119. Converting the VARCHAR2 variables to DATE variables.
1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);
1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);
1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);
1293: --myerrams, Bug: 5214119. end.
1294: g_org_id := MO_GLOBAL.get_current_org_id;

Line 1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);

1287: g_order_date_low := fnd_date.canonical_to_date(p_order_date_low);
1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);
1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);
1293: --myerrams, Bug: 5214119. end.
1294: g_org_id := MO_GLOBAL.get_current_org_id;
1295: BEGIN

Line 1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);

1288: g_order_date_high := fnd_date.canonical_to_date(p_order_date_high);
1289: g_fulfill_date_low := fnd_date.canonical_to_date(p_fulfill_date_low);
1290: g_fulfill_date_high := fnd_date.canonical_to_date(p_fulfill_date_high);
1291: g_accepted_date_low := fnd_date.canonical_to_date(p_accepted_date_low);
1292: g_accepted_date_high := fnd_date.canonical_to_date(p_accepted_date_high);
1293: --myerrams, Bug: 5214119. end.
1294: g_org_id := MO_GLOBAL.get_current_org_id;
1295: BEGIN
1296: SELECT name