[Home] [Help]
2451:
2452: begin
2453: SELECT 'Y'
2454: INTO l_hr_exists
2455: FROM DUAL
2456: WHERE EXISTS
2457: (SELECT mog.object_id
2458: FROM mtl_object_genealogy mog
2459: WHERE mog.object_id = l_gen_object_id
2484:
2485: begin
2486: SELECT 'Y'
2487: INTO l_routes_exists
2488: FROM DUAL
2489: WHERE EXISTS
2490: (SELECT mena.network_association_id
2491: FROM mtl_eam_network_assets mena
2492: WHERE mena.maintenance_object_type = 3
2508: -- WORK REQUEST AND WORK ORDER CHECK
2509: begin
2510: SELECT 'Y'
2511: INTO l_wo_exists
2512: FROM DUAL
2513: WHERE EXISTS
2514: (SELECT wdj.wip_entity_id
2515: FROM wip_discrete_jobs wdj
2516: WHERE wdj.status_type not in (4, 5, 7, 12)
2538: -- check open Service Reqests
2539: begin
2540: SELECT 'Y'
2541: into l_sr_exists
2542: from dual
2543: where exists
2544: (
2545: select cia.incident_id from cs_incidents_vl_sec cia,CS_INCIDENT_STATUSES_VL cis
2546: where cia.customer_product_id = l_instance_id
3168: if (l_gen_obj_exists = 'Y') then
3169: begin
3170: SELECT 'Y'
3171: INTO l_hr_exists
3172: FROM DUAL
3173: WHERE EXISTS
3174: (SELECT mog.object_id
3175: FROM mtl_object_genealogy mog
3176: WHERE mog.object_id = l_gen_object_id
3202: -- ROUTES CHECK
3203: begin
3204: SELECT 'Y'
3205: INTO l_routes_exists
3206: FROM DUAL
3207: WHERE EXISTS
3208: (SELECT mena.network_association_id
3209: FROM mtl_eam_network_assets mena
3210: WHERE mena.maintenance_object_type =3
3228: -- WORK REQUEST AND WORK ORDER CHECK
3229: begin
3230: SELECT 'Y'
3231: INTO l_wo_exists
3232: FROM DUAL
3233: WHERE EXISTS
3234: (SELECT wdj.wip_entity_id
3235: FROM wip_discrete_jobs wdj
3236: WHERE wdj.status_type not in (4, 5, 7, 12)
3375: if (p_operation_seq_num is null AND p_resource_seq_num is null) then
3376: update wip_operation_resource_usage
3377: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3378: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3379: where wip_entity_id in (select p_wip_entity_id from dual
3380: union
3381: select child_object_id from wip_sched_relationships
3382: where relationship_type = 1
3383: start with parent_object_id = p_wip_entity_id
3387: elsif (p_operation_seq_num is not null AND p_resource_seq_num is null) then
3388: update wip_operation_resource_usage
3389: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3390: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3391: where wip_entity_id in (select p_wip_entity_id from dual
3392: union
3393: select child_object_id from wip_sched_relationships
3394: where relationship_type = 1
3395: start with parent_object_id = p_wip_entity_id
3399: else
3400: update wip_operation_resource_usage
3401: set start_date = decode(p_delta, null, p_start, start_date + p_delta),
3402: completion_date = decode(p_delta, null, p_end, completion_date + p_delta)
3403: where wip_entity_id in (select p_wip_entity_id from dual
3404: union
3405: select child_object_id from wip_sched_relationships
3406: where relationship_type = 1
3407: start with parent_object_id = p_wip_entity_id