APPS.WIP_JOB_DTLS_SUBSTITUTIONS dependencies on WIP_SUB_OPERATION_RESOURCES

Line 451: from wip_sub_operation_resources

447: select 1
448: into l_replace_res
449: from dual
450: where exists (select 1
451: from wip_sub_operation_resources
452: where wip_entity_id = p_wip_entity_id
453: and operation_seq_num = cur_row.operation_seq_num
454: and substitute_group_num = cur_row.substitute_group_num
455: and replacement_group_num = cur_row.replacement_group_num);

Line 747: DELETE FROM WIP_SUB_OPERATION_RESOURCES

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

Line 808: INSERT INTO WIP_SUB_OPERATION_RESOURCES(

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

Line 959: UPDATE WIP_SUB_OPERATION_RESOURCES

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