APPS.AHL_UMP_BOM_PVT dependencies on AHL_UMP_RESOURCE_REQMNTS

Line 793: INSERT INTO AHL_UMP_RESOURCE_REQMNTS(MAINTENANCE_REQMNT_ID,

789: G_DEBUG_LINE_NUM := l_debug_module||': '||7050;
790: --Bulk Exception handling added by debadey for bug 13080499
791: BEGIN
792: FORALL x IN p_x_consolidated_res_tbl.FIRST..p_x_consolidated_res_tbl.LAST SAVE EXCEPTIONS
793: INSERT INTO AHL_UMP_RESOURCE_REQMNTS(MAINTENANCE_REQMNT_ID,
794: OBJECT_TYPE,
795: SIMULATION_PLAN_ID,
796: OPERATING_ORG_ID,
797: BOM_RESOURCE_ID,

Line 2690: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

2686:
2687: IF (l_plan_id IS NOT NULL)
2688: THEN
2689: G_DEBUG_LINE_NUM := l_debug_module||': '||12;
2690: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
2691: WHERE maintenance_reqmnt_id IN
2692: (SELECT maintenance_reqmnt_id
2693: FROM AHL_UMP_MAINT_REQMNTS
2694: WHERE object_type = 'UE'

Line 3050: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

3046:
3047: IF (l_plan_id_tbl(i) IS NOT NULL)
3048: THEN
3049: G_DEBUG_LINE_NUM := l_debug_module||': '||282;
3050: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
3051: WHERE maintenance_reqmnt_id IN
3052: (SELECT maintenance_reqmnt_id
3053: FROM AHL_UMP_MAINT_REQMNTS
3054: WHERE object_type = 'SIM'

Line 3235: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

3231:
3232: IF (l_plan_id_tbl(i) IS NOT NULL)
3233: THEN
3234: G_DEBUG_LINE_NUM := l_debug_module||': '||382;
3235: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
3236: WHERE maintenance_reqmnt_id IN
3237: (SELECT maintenance_reqmnt_id
3238: FROM AHL_UMP_MAINT_REQMNTS
3239: WHERE object_type = 'SIM'

Line 3364: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

3360: /*----- Process all MR based UE for PRIMARY plan------*/
3361: -- Process all applicable MRs beloging to primary plan UE
3362: /* Bug 13096151 - Remove all UE, resource and material for the plan from the bom tables */
3363: G_DEBUG_LINE_NUM := l_debug_module||': '||471;
3364: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
3365: WHERE maintenance_reqmnt_id IN
3366: (SELECT maintenance_reqmnt_id
3367: FROM AHL_UMP_MAINT_REQMNTS
3368: WHERE object_type = 'UE'

Line 3639: DELETE FROM AHL_UMP_RESOURCE_REQMNTS

3635: G_DEBUG_LINE_NUM := l_debug_module||': '||690;
3636: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Start processing specific Simulation Plans UE for the plan '||l_plan_id );
3637: /* Bug 13096151 - Remove all UE, resource and material for the plan from the bom tables */
3638: G_DEBUG_LINE_NUM := l_debug_module||': '||692;
3639: DELETE FROM AHL_UMP_RESOURCE_REQMNTS
3640: WHERE maintenance_reqmnt_id IN
3641: (SELECT maintenance_reqmnt_id
3642: FROM AHL_UMP_MAINT_REQMNTS
3643: WHERE object_type = 'SIM'