APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_SUB_OPERATION_RESOURCES

Line 456: from wip_sub_operation_resources

452: select 1
453: into l_replace_res
454: from dual
455: where exists (select 1
456: from wip_sub_operation_resources
457: where wip_entity_id = p_wip_entity_id
458: and operation_seq_num = cur_row.operation_seq_num
459: and substitute_group_num = cur_row.substitute_group_num
460: and nvl(replacement_group_num,0) = nvl(cur_row.replacement_group_num,0));

Line 746: DELETE FROM WIP_SUB_OPERATION_RESOURCES

742: cur_row.resource_seq_num,
743: p_err_code,
744: p_err_msg);
745:
746: DELETE FROM WIP_SUB_OPERATION_RESOURCES
747: WHERE wip_entity_id = p_wip_entity_id
748: AND organization_id = p_organization_id
749: AND operation_seq_num = cur_row.operation_seq_num
750: AND resource_seq_num = cur_row.resource_seq_num

Line 807: INSERT INTO WIP_SUB_OPERATION_RESOURCES(

803: p_wip_entity_id,
804: p_organization_id) LOOP
805:
806: /* insert into table */
807: INSERT INTO WIP_SUB_OPERATION_RESOURCES(
808: wip_entity_id,
809: organization_id,
810: operation_seq_num,
811: resource_seq_num,

Line 958: UPDATE WIP_SUB_OPERATION_RESOURCES

954: p_organization_id) LOOP
955:
956: /* update the table */
957: /** Fix for bug 2438722 - correct attribute cols updated **/
958: UPDATE WIP_SUB_OPERATION_RESOURCES
959: SET resource_id = cur_row.resource_id_new,
960: usage_rate_or_amount = cur_row.usage_rate_or_amount,
961: last_update_date = sysdate,/*BUG 6721823*/
962: /*FP BUG 13406111 :BUG 12814417 @Start */