APPS.QPR_SPECIAL_ETL dependencies on FND_DATE

Line 364: date_from := fnd_date.canonical_to_date(p_from_date);

360: end handle_pto_items;
361:
362: /* main method begins*/
363: begin
364: date_from := fnd_date.canonical_to_date(p_from_date);
365: date_to := fnd_date.canonical_to_date(p_to_date);
366:
367: l_sql:= ' select ord_level_value, booked_date, cos_level_value, unit_cost, '||
368: ' unit_list_price, top_model_line_id, link_to_line_id, item_type_code, '||

Line 365: date_to := fnd_date.canonical_to_date(p_to_date);

361:
362: /* main method begins*/
363: begin
364: date_from := fnd_date.canonical_to_date(p_from_date);
365: date_to := fnd_date.canonical_to_date(p_to_date);
366:
367: l_sql:= ' select ord_level_value, booked_date, cos_level_value, unit_cost, '||
368: ' unit_list_price, top_model_line_id, link_to_line_id, item_type_code, '||
369: ' inventory_item_id, component_code, ato_line_id , order_quantity' ||

Line 765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));

761: l_request_id number := FND_GLOBAL.conc_request_id;
762:
763: begin
764:
765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));
766: date_to := fnd_date.canonical_to_date(nvl(p_to_date, p_to_trx_date));
767: date_from_trx := fnd_date.canonical_to_date(p_from_trx_date);
768: date_to_trx := fnd_date.canonical_to_date(p_to_trx_date);
769:

Line 766: date_to := fnd_date.canonical_to_date(nvl(p_to_date, p_to_trx_date));

762:
763: begin
764:
765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));
766: date_to := fnd_date.canonical_to_date(nvl(p_to_date, p_to_trx_date));
767: date_from_trx := fnd_date.canonical_to_date(p_from_trx_date);
768: date_to_trx := fnd_date.canonical_to_date(p_to_trx_date);
769:
770: ----- Collect Data ---

Line 767: date_from_trx := fnd_date.canonical_to_date(p_from_trx_date);

763: begin
764:
765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));
766: date_to := fnd_date.canonical_to_date(nvl(p_to_date, p_to_trx_date));
767: date_from_trx := fnd_date.canonical_to_date(p_from_trx_date);
768: date_to_trx := fnd_date.canonical_to_date(p_to_trx_date);
769:
770: ----- Collect Data ---
771: l_sql:= ' SELECT '||

Line 768: date_to_trx := fnd_date.canonical_to_date(p_to_trx_date);

764:
765: date_from := fnd_date.canonical_to_date(nvl(p_from_date, p_from_trx_date));
766: date_to := fnd_date.canonical_to_date(nvl(p_to_date, p_to_trx_date));
767: date_from_trx := fnd_date.canonical_to_date(p_from_trx_date);
768: date_to_trx := fnd_date.canonical_to_date(p_to_trx_date);
769:
770: ----- Collect Data ---
771: l_sql:= ' SELECT '||
772: ' CUSTOMER_TRX_LINE_ID, TRX_TYP_NAME, SOLD_TO_CUSTOMER_ID,'||

Line 1143: date_from date := fnd_date.canonical_to_date(p_from_date);

1139: l_pocket_price number;
1140: l_pocket_price_rev number;
1141: lctr pls_integer;
1142: lrows number := 1000;
1143: date_from date := fnd_date.canonical_to_date(p_from_date);
1144: date_to date := fnd_date.canonical_to_date(p_to_date);
1145:
1146: type sales_rec is record(MEASURE_VALUE_ID num_type,
1147: MEASURE1 num_type,

Line 1144: date_to date := fnd_date.canonical_to_date(p_to_date);

1140: l_pocket_price_rev number;
1141: lctr pls_integer;
1142: lrows number := 1000;
1143: date_from date := fnd_date.canonical_to_date(p_from_date);
1144: date_to date := fnd_date.canonical_to_date(p_to_date);
1145:
1146: type sales_rec is record(MEASURE_VALUE_ID num_type,
1147: MEASURE1 num_type,
1148: MEASURE2 num_type,

Line 1310: date_from := fnd_date.canonical_to_date(p_from_date);

1306: date_from date;
1307: date_to date;
1308:
1309: begin
1310: date_from := fnd_date.canonical_to_date(p_from_date);
1311: date_to := fnd_date.canonical_to_date(p_to_date);
1312:
1313: open c_measures(date_from, date_to);
1314: loop

Line 1311: date_to := fnd_date.canonical_to_date(p_to_date);

1307: date_to date;
1308:
1309: begin
1310: date_from := fnd_date.canonical_to_date(p_from_date);
1311: date_to := fnd_date.canonical_to_date(p_to_date);
1312:
1313: open c_measures(date_from, date_to);
1314: loop
1315: fetch c_measures bulk collect into t_meas_val_id, t_cus, t_geo, t_org,