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);
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);
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.
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;
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
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