APPS.WIP_EXPLODE_PHANTOM_RTGS dependencies on WIP_OPERATION_RESOURCES

Line 649: FROM WIP_OPERATION_RESOURCES

645: * of the MAX function
646: * -------------------------------------------------------------*/
647: SELECT max(resource_seq_num)
648: INTO x_max_resc_seq_num
649: FROM WIP_OPERATION_RESOURCES
650: WHERE wip_entity_id = p_wip_entity_id
651: and organization_id = p_org_id
652: and NVL(repetitive_schedule_id, -1) =
653: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)

Line 667: FROM WIP_OPERATION_RESOURCES

663: program_application_id, program_id, program_update_date
664: INTO x_last_update_date, x_last_updated_by, x_creation_date,
665: x_created_by, x_last_update_login, x_request_id,
666: x_program_application_id, x_program_id, x_program_update_date
667: FROM WIP_OPERATION_RESOURCES
668: WHERE wip_entity_id = p_wip_entity_id
669: and organization_id = p_org_id
670: and NVL(repetitive_schedule_id, -1) =
671: DECODE(p_entity_type, WIP_CONSTANTS.REPETITIVE, p_sched_id,-1)

Line 703: * information to WIP_OPERATION_RESOURCES *

699: AND operation_seq_num = p_op_seq_num;
700:
701: /* --------------------------------------------------------- *
702: * GO through the cursor. Populate phantom resources *
703: * information to WIP_OPERATION_RESOURCES *
704: * ----------------------------------------------------------*/
705:
706: FOR cur_resc IN phan_resc_cursor(p_rtg_rev_date) LOOP
707:

Line 727: INSERT INTO WIP_OPERATION_RESOURCES(

723: FETCH phan_comp_qty into x_comp_qty,x_yield_factor ;
724: CLOSE phan_comp_qty ;
725:
726: /* insert phantom resources */
727: INSERT INTO WIP_OPERATION_RESOURCES(
728: wip_entity_id,
729: operation_seq_num,
730: resource_seq_num,
731: organization_id,