APPS.WIP_SUB_OP_RESOURCES_PKG dependencies on WIP_OPERATION_RESOURCES

Line 812: FROM WIP_OPERATION_RESOURCES

808: l_pending_clocks VARCHAR2(1); --Bug#4715338
809:
810: CURSOR res IS
811: SELECT resource_seq_num
812: FROM WIP_OPERATION_RESOURCES
813: WHERE
814: wip_entity_id = l_Wip_Entity_Id and
815: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
816: operation_seq_num = l_Operation_Seq_Num and

Line 844: FROM wip_operation_resources

840: end if;
841: end if;
842:
843: SELECT COUNT(*) into l_replacement_groups_exist
844: FROM wip_operation_resources
845: WHERE wip_entity_id = l_Wip_Entity_Id and
846: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
847: operation_seq_num = l_Operation_Seq_Num and
848: substitute_group_num = l_Substitute_Group_Num and

Line 993: FROM WIP_OPERATION_RESOURCES

989: schedule_seq_num,
990: substitute_group_num,
991: nvl(replacement_group_num, 0),
992: setup_id
993: FROM WIP_OPERATION_RESOURCES
994: WHERE
995: wip_entity_id = l_Wip_Entity_Id and
996: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
997: operation_seq_num = l_Operation_Seq_Num and

Line 1006: -- Deleting from wip_operation_resources and resource_usage

1002: ROLLBACK to start_point;
1003: Raise NO_DATA_FOUND;
1004: end if;
1005:
1006: -- Deleting from wip_operation_resources and resource_usage
1007: -- and resource_instances
1008:
1009: FOR res_rec IN res LOOP
1010:

Line 1011: DELETE FROM WIP_OPERATION_RESOURCES

1007: -- and resource_instances
1008:
1009: FOR res_rec IN res LOOP
1010:
1011: DELETE FROM WIP_OPERATION_RESOURCES
1012: WHERE
1013: wip_entity_id = l_Wip_Entity_Id and
1014: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
1015: operation_seq_num = l_Operation_Seq_Num and

Line 1024: DELETE FROM WIP_OPERATION_RESOURCES

1020: Raise NO_DATA_FOUND;
1021: end if;
1022:
1023: -- delete all setup resources
1024: DELETE FROM WIP_OPERATION_RESOURCES
1025: WHERE
1026: wip_entity_id = l_Wip_Entity_Id and
1027: NVL(repetitive_schedule_id, -1) = NVL(l_Repetitive_Sched_Id, -1) and
1028: operation_seq_num = l_Operation_Seq_Num and

Line 1048: INSERT INTO WIP_OPERATION_RESOURCES(

1044: END LOOP;
1045:
1046:
1047:
1048: INSERT INTO WIP_OPERATION_RESOURCES(
1049: wip_entity_id,
1050: operation_seq_num,
1051: resource_seq_num,
1052: organization_id,

Line 1263: from wip_operation_resources wor

1259: -- Cursor SQL Modified for bug 5235559.
1260: cursor primary_res is
1261: select wor.applied_resource_units,
1262: wor.resource_seq_num
1263: from wip_operation_resources wor
1264: where wor.organization_id = p_org_id
1265: and wor.wip_entity_id = p_wip_entity_id
1266: and wor.operation_seq_num = p_op_seq
1267: and wor.substitute_group_num = decode(wor.parent_resource_seq,NULL,p_sub_group,wor.substitute_group_num)

Line 1270: from wip_operation_resources wor1

1266: and wor.operation_seq_num = p_op_seq
1267: and wor.substitute_group_num = decode(wor.parent_resource_seq,NULL,p_sub_group,wor.substitute_group_num)
1268: and (wor.parent_resource_seq is null or wor.parent_resource_seq in
1269: (select wor.resource_seq_num
1270: from wip_operation_resources wor1
1271: where wor1.organization_id = p_org_id
1272: and wor1.wip_entity_id = p_wip_entity_id
1273: and wor1.operation_seq_num = p_op_seq
1274: and wor1.substitute_group_num = p_sub_group));