eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_OP_RESOURCES_UTILITIES dependencies on WIP_OPERATION_RESOURCES

Line 13: FROM WIP_OPERATION_RESOURCES

9: res_count NUMBER := 0;
10: subres_count NUMBER := 0;
11: cursor discrete_check is
12: SELECT count(*)
13: FROM WIP_OPERATION_RESOURCES
14: WHERE ORGANIZATION_ID = X_Organization_Id
15: AND WIP_ENTITY_ID = X_Wip_Entity_Id
16: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
17: AND RESOURCE_SEQ_NUM = X_Resource_Seq_Num;

Line 27: FROM WIP_OPERATION_RESOURCES

23: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
24: AND RESOURCE_SEQ_NUM = X_Resource_Seq_Num;
25: cursor repetitive_check is
26: SELECT count(*)
27: FROM WIP_OPERATION_RESOURCES
28: WHERE ORGANIZATION_ID = X_Organization_Id
29: AND WIP_ENTITY_ID = X_Wip_Entity_Id
30: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
31: AND RESOURCE_SEQ_NUM = X_Resource_Seq_Num

Line 63: FROM WIP_OPERATION_RESOURCES

59: X_Repetitive_Schedule_Id NUMBER) IS
60: res_count NUMBER := 0;
61: cursor discrete_check is
62: SELECT count(*)
63: FROM WIP_OPERATION_RESOURCES
64: WHERE ORGANIZATION_ID = X_Organization_Id
65: AND WIP_ENTITY_ID = X_Wip_Entity_Id
66: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
67: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num

Line 71: FROM WIP_OPERATION_RESOURCES

67: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num
68: AND AUTOCHARGE_TYPE = 4;
69: cursor repetitive_check is
70: SELECT count(*)
71: FROM WIP_OPERATION_RESOURCES
72: WHERE ORGANIZATION_ID = X_Organization_Id
73: AND WIP_ENTITY_ID = X_Wip_Entity_Id
74: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
75: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num

Line 103: FROM WIP_OPERATION_RESOURCES

99: X_Repetitive_Schedule_Id NUMBER) IS
100: res_count NUMBER := 0;
101: cursor discrete_check is
102: SELECT count(*)
103: FROM WIP_OPERATION_RESOURCES
104: WHERE ORGANIZATION_ID = X_Organization_Id
105: AND WIP_ENTITY_ID = X_Wip_Entity_Id
106: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
107: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num

Line 111: FROM WIP_OPERATION_RESOURCES

107: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num
108: AND SCHEDULED_FLAG = 3;
109: cursor repetitive_check is
110: SELECT count(*)
111: FROM WIP_OPERATION_RESOURCES
112: WHERE ORGANIZATION_ID = X_Organization_Id
113: AND WIP_ENTITY_ID = X_Wip_Entity_Id
114: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
115: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num

Line 143: FROM WIP_OPERATION_RESOURCES

139: X_Repetitive_Schedule_Id NUMBER) IS
140: res_count NUMBER := 0;
141: cursor discrete_check is
142: SELECT count(*)
143: FROM WIP_OPERATION_RESOURCES
144: WHERE ORGANIZATION_ID = X_Organization_Id
145: AND WIP_ENTITY_ID = X_Wip_Entity_Id
146: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
147: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num

Line 151: FROM WIP_OPERATION_RESOURCES

147: AND RESOURCE_SEQ_NUM <> X_Resource_Seq_Num
148: AND SCHEDULED_FLAG = 4;
149: cursor repetitive_check is
150: SELECT count(*)
151: FROM WIP_OPERATION_RESOURCES
152: WHERE ORGANIZATION_ID = X_Organization_Id
153: AND WIP_ENTITY_ID = X_Wip_Entity_Id
154: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
155: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num

Line 249: UPDATE wip_operation_resources

245: X_First_Unit_Start_Date DATE,
246: X_Last_Unit_Completion_Date DATE) IS
247: BEGIN
248: IF X_Repetitive_Schedule_Id is NULL THEN
249: UPDATE wip_operation_resources
250: SET start_date = X_First_Unit_Start_Date,
251: completion_date = X_Last_Unit_Completion_Date
252: WHERE wip_entity_id = X_Wip_Entity_Id
253: AND organization_id = X_Organization_Id

Line 257: UPDATE wip_operation_resources

253: AND organization_id = X_Organization_Id
254: AND operation_seq_num = X_Operation_Seq_Num
255: AND resource_seq_num = X_Resource_Seq_Num;
256: ELSE
257: UPDATE wip_operation_resources
258: SET start_date = X_First_Unit_Start_Date,
259: completion_date = X_Last_Unit_Completion_Date
260: WHERE wip_entity_id = X_Wip_Entity_Id
261: AND organization_id = X_Organization_Id

Line 294: from wip_operation_resources wor

290: delete from wip_sub_operation_resources wsor
291: where wip_entity_id = p_wip_entity_id
292: and nvl(repetitive_schedule_id, -1) = nvl(p_schedule_id, -1)
293: and not exists (select 1
294: from wip_operation_resources wor
295: where wor.wip_entity_id = p_wip_entity_id
296: and nvl(wor.repetitive_schedule_id, -1) = nvl(p_schedule_id, -1)
297: and wor.operation_seq_num = wsor.operation_seq_num
298: and wor.substitute_group_num = wsor.substitute_group_num);

Line 323: from wip_operation_resources

319: schedule_seq_num,
320: substitute_group_num,
321: scheduled_flag,
322: parent_resource_seq /* added for bug 4747951 */
323: from wip_operation_resources
324: where wip_entity_id = p_wip_entity_id
325: and nvl(repetitive_schedule_id,-1) = nvl(p_schedule_id,-1)
326: and operation_seq_num = p_op_seq_num
327: union

Line 422: from wip_operation_resources

418: select operation_seq_num,
419: resource_seq_num,
420: start_date,
421: completion_date
422: from wip_operation_resources
423: where wip_entity_id = p_wip_entity_id
424: and organization_id = p_org_id;
425:
426: Begin