[Home] [Help]
2450:
2451: begin
2452: SELECT 'Y'
2453: INTO l_hr_exists
2454: FROM DUAL
2455: WHERE EXISTS
2456: (SELECT mog.object_id
2457: FROM mtl_object_genealogy mog
2458: WHERE mog.object_id = l_gen_object_id
2483:
2484: begin
2485: SELECT 'Y'
2486: INTO l_routes_exists
2487: FROM DUAL
2488: WHERE EXISTS
2489: (SELECT mena.network_association_id
2490: FROM mtl_eam_network_assets mena
2491: WHERE mena.maintenance_object_type = 3
2507: -- WORK REQUEST AND WORK ORDER CHECK
2508: begin
2509: SELECT 'Y'
2510: INTO l_wo_exists
2511: FROM DUAL
2512: WHERE EXISTS
2513: (SELECT wdj.wip_entity_id
2514: FROM wip_discrete_jobs wdj
2515: WHERE wdj.status_type not in (4, 5, 7, 12)
2537: -- check open Service Reqests
2538: begin
2539: SELECT 'Y'
2540: into l_sr_exists
2541: from dual
2542: where exists
2543: (
2544: select cia.incident_id from cs_incidents_vl_sec cia,CS_INCIDENT_STATUSES_VL cis
2545: where cia.customer_product_id = l_instance_id
3028: if (l_gen_obj_exists = 'Y') then
3029: begin
3030: SELECT 'Y'
3031: INTO l_hr_exists
3032: FROM DUAL
3033: WHERE EXISTS
3034: (SELECT mog.object_id
3035: FROM mtl_object_genealogy mog
3036: WHERE mog.object_id = l_gen_object_id
3062: -- ROUTES CHECK
3063: begin
3064: SELECT 'Y'
3065: INTO l_routes_exists
3066: FROM DUAL
3067: WHERE EXISTS
3068: (SELECT mena.network_association_id
3069: FROM mtl_eam_network_assets mena
3070: WHERE mena.maintenance_object_type =3
3086: -- WORK REQUEST AND WORK ORDER CHECK
3087: begin
3088: SELECT 'Y'
3089: INTO l_wo_exists
3090: FROM DUAL
3091: WHERE EXISTS
3092: (SELECT wdj.wip_entity_id
3093: FROM wip_discrete_jobs wdj
3094: WHERE wdj.status_type not in (4, 5, 7, 12)
3231: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3232: update wip_operation_resource_usage
3233: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3234: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3235: where wip_entity_id in (select p_wip_entity_id from dual
3236: union
3237: select child_object_id from wip_sched_relationships
3238: where relationship_type = 1
3239: start with parent_object_id = p_wip_entity_id
3243: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3244: update wip_operation_resource_usage
3245: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3246: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3247: where wip_entity_id in (select p_wip_entity_id from dual
3248: union
3249: select child_object_id from wip_sched_relationships
3250: where relationship_type = 1
3251: start with parent_object_id = p_wip_entity_id
3255: else
3256: update wip_operation_resource_usage
3257: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3258: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3259: where wip_entity_id in (select p_wip_entity_id from dual
3260: union
3261: select child_object_id from wip_sched_relationships
3262: where relationship_type = 1
3263: start with parent_object_id = p_wip_entity_id