APPS.AHL_UMP_BOM_PVT dependencies on AHL_UMP_MAINT_REQMNTS

Line 750: INSERT INTO AHL_UMP_MAINT_REQMNTS(MAINTENANCE_REQMNT_ID,

746:
747: -- Insert records for the root UE now
748: -- Log
749: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Inserting record for UE '||p_ump_maint_rec.UNIT_EFFECTIVITY_ID);
750: INSERT INTO AHL_UMP_MAINT_REQMNTS(MAINTENANCE_REQMNT_ID,
751: OBJECT_TYPE,
752: SIMULATION_PLAN_ID,
753: OPERATING_ORG_ID,
754: DUE_DATE,

Line 2693: FROM AHL_UMP_MAINT_REQMNTS

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'
2695: AND simulation_plan_id = l_plan_id);
2696:
2697:

Line 2703: FROM AHL_UMP_MAINT_REQMNTS

2699: G_DEBUG_LINE_NUM := l_debug_module||': '||14;
2700: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
2701: WHERE maintenance_reqmnt_id IN
2702: (SELECT maintenance_reqmnt_id
2703: FROM AHL_UMP_MAINT_REQMNTS
2704: WHERE object_type = 'UE'
2705: AND simulation_plan_id = l_plan_id);
2706:
2707:

Line 2709: DELETE FROM AHL_UMP_MAINT_REQMNTS

2705: AND simulation_plan_id = l_plan_id);
2706:
2707:
2708: G_DEBUG_LINE_NUM := l_debug_module||': '||16;
2709: DELETE FROM AHL_UMP_MAINT_REQMNTS
2710: WHERE object_type = 'UE'
2711: AND simulation_plan_id = l_plan_id;
2712:
2713: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' deleted bom ue with l_plan_id = '||l_plan_id);

Line 3053: FROM AHL_UMP_MAINT_REQMNTS

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'
3055: AND simulation_plan_id = l_plan_id_tbl(i));
3056:
3057: G_DEBUG_LINE_NUM := l_debug_module||': '||284;

Line 3061: FROM AHL_UMP_MAINT_REQMNTS

3057: G_DEBUG_LINE_NUM := l_debug_module||': '||284;
3058: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3059: WHERE maintenance_reqmnt_id IN
3060: (SELECT maintenance_reqmnt_id
3061: FROM AHL_UMP_MAINT_REQMNTS
3062: WHERE object_type = 'SIM'
3063: AND simulation_plan_id = l_plan_id_tbl(i));
3064:
3065: G_DEBUG_LINE_NUM := l_debug_module||': '||286;

Line 3066: DELETE FROM AHL_UMP_MAINT_REQMNTS

3062: WHERE object_type = 'SIM'
3063: AND simulation_plan_id = l_plan_id_tbl(i));
3064:
3065: G_DEBUG_LINE_NUM := l_debug_module||': '||286;
3066: DELETE FROM AHL_UMP_MAINT_REQMNTS
3067: WHERE object_type = 'SIM'
3068: AND simulation_plan_id = l_plan_id_tbl(i);
3069:
3070: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' deleted ump bom for l_plan_id = '||l_plan_id_tbl(i));

Line 3238: FROM AHL_UMP_MAINT_REQMNTS

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'
3240: AND simulation_plan_id = l_plan_id_tbl(i));
3241:
3242:

Line 3248: FROM AHL_UMP_MAINT_REQMNTS

3244: G_DEBUG_LINE_NUM := l_debug_module||': '||384;
3245: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3246: WHERE maintenance_reqmnt_id IN
3247: (SELECT maintenance_reqmnt_id
3248: FROM AHL_UMP_MAINT_REQMNTS
3249: WHERE object_type = 'SIM'
3250: AND simulation_plan_id = l_plan_id_tbl(i));
3251:
3252:

Line 3254: DELETE FROM AHL_UMP_MAINT_REQMNTS

3250: AND simulation_plan_id = l_plan_id_tbl(i));
3251:
3252:
3253: G_DEBUG_LINE_NUM := l_debug_module||': '||386;
3254: DELETE FROM AHL_UMP_MAINT_REQMNTS
3255: WHERE object_type = 'SIM'
3256: AND simulation_plan_id = l_plan_id_tbl(i);
3257:
3258: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' BOM UE deleted for plan id = '||l_plan_id_tbl(i));

Line 3367: FROM AHL_UMP_MAINT_REQMNTS

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'
3369: AND simulation_plan_id = l_plan_id);
3370:
3371: G_DEBUG_LINE_NUM := l_debug_module||': '||472;

Line 3375: FROM AHL_UMP_MAINT_REQMNTS

3371: G_DEBUG_LINE_NUM := l_debug_module||': '||472;
3372: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3373: WHERE maintenance_reqmnt_id IN
3374: (SELECT maintenance_reqmnt_id
3375: FROM AHL_UMP_MAINT_REQMNTS
3376: WHERE object_type = 'UE'
3377: AND simulation_plan_id = l_plan_id);
3378:
3379: G_DEBUG_LINE_NUM := l_debug_module||': '||476;

Line 3380: DELETE FROM AHL_UMP_MAINT_REQMNTS

3376: WHERE object_type = 'UE'
3377: AND simulation_plan_id = l_plan_id);
3378:
3379: G_DEBUG_LINE_NUM := l_debug_module||': '||476;
3380: DELETE FROM AHL_UMP_MAINT_REQMNTS
3381: WHERE object_type = 'UE'
3382: AND simulation_plan_id = l_plan_id;
3383:
3384: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' Deleted BOM for the primary plan with plan id '||l_plan_id);

Line 3642: FROM AHL_UMP_MAINT_REQMNTS

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'
3644: AND simulation_plan_id = l_plan_id);
3645:
3646:

Line 3651: FROM AHL_UMP_MAINT_REQMNTS

3647: G_DEBUG_LINE_NUM := l_debug_module||': '||694;
3648: DELETE FROM AHL_UMP_MATERIAL_REQMNTS
3649: WHERE maintenance_reqmnt_id IN
3650: (SELECT maintenance_reqmnt_id
3651: FROM AHL_UMP_MAINT_REQMNTS
3652: WHERE object_type = 'SIM'
3653: AND simulation_plan_id = l_plan_id);
3654:
3655:

Line 3657: DELETE FROM AHL_UMP_MAINT_REQMNTS

3653: AND simulation_plan_id = l_plan_id);
3654:
3655:
3656: G_DEBUG_LINE_NUM := l_debug_module||': '||696;
3657: DELETE FROM AHL_UMP_MAINT_REQMNTS
3658: WHERE object_type = 'SIM'
3659: AND simulation_plan_id = l_plan_id;
3660: FND_FILE.put_line(FND_FILE.log, G_DEBUG_LINE_NUM||' BOM UE deleted for plan id = '||l_plan_id);
3661: G_DEBUG_LINE_NUM := l_debug_module||': '||698;