1424:
1425:
1426: -- =============================================================================
1427: -- Name: flush_crp_plan
1428: -- Desc: It inserts the date for 1 dept/res or line into CRP_CAPACITY_PLANS
1429: -- =============================================================================
1430: PROCEDURE flush_crp_plan(
1431: p_org_id NUMBER,
1432: p_dept_id NUMBER,
1475: g_error_stmt := 'Debug - flush_crp_plan - 10';
1476: FOR v_loop IN 1..NUM_OF_TYPES LOOP
1477:
1478: g_error_stmt := 'Debug - flush_crp_plan - 30 - loop'||to_char(v_loop);
1479: INSERT INTO crp_capacity_plans(
1480: query_id,
1481: last_update_date,
1482: last_updated_by,
1483: creation_date,