DBA Data[Home] [Help]

APPS.GMP_HORIZONTAL_PDR_PKG dependencies on GMP_HORIZONTAL_PDR_GTMP

Line 1536: INSERT INTO gmp_horizontal_pdr_gtmp

1532:
1533: FOR loop_counter IN 1..g_num_of_buckets LOOP
1534: IF var_dates(loop_counter) < G_day_bckt_cutoff_dt THEN
1535:
1536: INSERT INTO gmp_horizontal_pdr_gtmp
1537: (
1538: organization_id,
1539: inventory_item_id,
1540: bucket_date,

Line 1645: INSERT INTO gmp_horizontal_pdr_gtmp

1641:
1642: IF curr_week_start_date <> next_week_start_date THEN
1643: week_change_flag := TRUE;
1644:
1645: INSERT INTO gmp_horizontal_pdr_gtmp
1646: (
1647: organization_id,
1648: inventory_item_id,
1649: bucket_date,

Line 1800: INSERT INTO gmp_horizontal_pdr_gtmp

1796:
1797: IF curr_period_start_date <> next_period_start_date THEN
1798: period_change_flag := TRUE;
1799:
1800: INSERT INTO gmp_horizontal_pdr_gtmp
1801: (
1802: organization_id,
1803: inventory_item_id,
1804: bucket_date,

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

2767:
2768: g_error_stmt := 'Debug - populate_horizontal_plan - 50';
2769: CLOSE mrp_snapshot_activity;
2770:
2771: -- INSERT INTO temp_gmp_horizontal_pdr_gtmp SELECT * FROM gmp_horizontal_pdr_gtmp;
2772:
2773: EXCEPTION
2774:
2775: WHEN OTHERS THEN