DBA Data[Home] [Help]

APPS.GMP_HORIZONTAL_PDR_PKG dependencies on GMP_HORIZONTAL_PDR_GTMP

Line 1557: INSERT INTO gmp_horizontal_pdr_gtmp

1553:
1554: FOR loop_counter IN 1..g_num_of_buckets LOOP
1555: IF var_dates(loop_counter) < G_day_bckt_cutoff_dt THEN
1556:
1557: INSERT INTO gmp_horizontal_pdr_gtmp
1558: (
1559: organization_id,
1560: inventory_item_id,
1561: bucket_date,

Line 1677: INSERT INTO gmp_horizontal_pdr_gtmp

1673: IF var_dates(loop_counter) < G_week_bckt_cutoff_dt THEN
1674: week_change_flag := TRUE;
1675: END IF;
1676:
1677: INSERT INTO gmp_horizontal_pdr_gtmp
1678: (
1679: organization_id,
1680: inventory_item_id,
1681: bucket_date,

Line 1839: INSERT INTO gmp_horizontal_pdr_gtmp

1835:
1836: IF curr_period_start_date <> next_period_start_date THEN
1837: period_change_flag := TRUE;
1838:
1839: INSERT INTO gmp_horizontal_pdr_gtmp
1840: (
1841: organization_id,
1842: inventory_item_id,
1843: bucket_date,

Line 2914: -- INSERT INTO temp_gmp_horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;

2910:
2911: g_error_stmt := 'Debug - populate_horizontal_plan - 50';
2912: CLOSE mrp_snapshot_activity;
2913:
2914: -- INSERT INTO temp_gmp_horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
2915:
2916: EXCEPTION
2917:
2918: WHEN OTHERS THEN