DBA Data[Home] [Help]

APPS.MSC_CRP_HORIZONTAL_PLAN dependencies on MSC_CAPACITY_PLANS

Line 1315: SELECT msc_capacity_plans_s.nextval

1311: -- --------------------------
1312: -- initialize query id
1313: -- --------------------------
1314: g_error_stmt := 'Debug - initialize - 10';
1315: SELECT msc_capacity_plans_s.nextval
1316: INTO g_query_id
1317: FROM dual;
1318:
1319: -- --------------------------------------------------------

Line 2146: INSERT INTO msc_capacity_plans(

2142: g_error_stmt := 'Debug - flush_crp_plan - 10';
2143: FOR v_loop IN 1..g_num_of_buckets LOOP
2144:
2145: g_error_stmt := 'Debug - flush_crp_plan - 30 - loop'||to_char(v_loop);
2146: INSERT INTO msc_capacity_plans(
2147: query_id,
2148: last_update_date,
2149: last_updated_by,
2150: creation_date,