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_OPERATIONS_UTILITIES dependencies on WIP_OPERATIONS

Line 1: PACKAGE BODY WIP_OPERATIONS_UTILITIES AS

1: PACKAGE BODY WIP_OPERATIONS_UTILITIES AS
2: /* $Header: wipoputb.pls 120.3.12020000.4 2013/03/01 07:27:35 akuppa ship $ */
3:
4: PROCEDURE Check_Unique(X_Wip_Entity_Id NUMBER,
5: X_Organization_Id NUMBER,

Line 11: FROM WIP_OPERATIONS

7: X_Repetitive_Schedule_Id NUMBER) IS
8: ops_count NUMBER := 0;
9: cursor discrete_check is
10: SELECT count(*)
11: FROM WIP_OPERATIONS
12: WHERE ORGANIZATION_ID = X_Organization_Id
13: AND WIP_ENTITY_ID = X_Wip_Entity_Id
14: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num;
15: cursor repetitive_check is

Line 17: FROM WIP_OPERATIONS

13: AND WIP_ENTITY_ID = X_Wip_Entity_Id
14: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num;
15: cursor repetitive_check is
16: SELECT count(*)
17: FROM WIP_OPERATIONS
18: WHERE ORGANIZATION_ID = X_Organization_Id
19: AND WIP_ENTITY_ID = X_Wip_Entity_Id
20: AND OPERATION_SEQ_NUM = X_Operation_Seq_Num
21: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id;

Line 128: from wip_operations

124: return NUMBER IS
125: opseq NUMBER;
126: cursor disc_op is
127: select max(operation_seq_num)
128: from wip_operations
129: where wip_entity_id = X_Wip_Entity_Id
130: and organization_id = X_Organization_Id
131: and operation_seq_num < X_Operation_Seq_Num;
132: cursor rep_op is

Line 134: from wip_operations

130: and organization_id = X_Organization_Id
131: and operation_seq_num < X_Operation_Seq_Num;
132: cursor rep_op is
133: select max(operation_seq_num)
134: from wip_operations
135: where wip_entity_id = X_Wip_Entity_Id
136: and organization_id = X_Organization_Id
137: and operation_seq_num < X_Operation_Seq_Num
138: and repetitive_schedule_id = X_Repetitive_Schedule_Id;

Line 164: from wip_operations

160: BEGIN
161: IF X_Repetitive_Schedule_Id IS NULL THEN
162: select max(operation_seq_num)
163: into X_Prev_Op_Seq
164: from wip_operations
165: where wip_entity_id = X_Wip_Entity_Id
166: and organization_id = X_Organization_Id
167: and operation_seq_num < X_Operation_Seq_Num;
168: select min(operation_seq_num)

Line 170: from wip_operations

166: and organization_id = X_Organization_Id
167: and operation_seq_num < X_Operation_Seq_Num;
168: select min(operation_seq_num)
169: into X_Next_Op_Seq
170: from wip_operations
171: where wip_entity_id = X_Wip_Entity_Id
172: and organization_id = X_Organization_Id
173: and operation_seq_num > X_Operation_Seq_Num;
174: ELSE

Line 177: from wip_operations

173: and operation_seq_num > X_Operation_Seq_Num;
174: ELSE
175: select max(operation_seq_num)
176: into X_Prev_Op_Seq
177: from wip_operations
178: where wip_entity_id = X_Wip_Entity_Id
179: and organization_id = X_Organization_Id
180: and operation_seq_num < X_Operation_Seq_Num
181: and repetitive_schedule_id = X_Repetitive_Schedule_Id;

Line 184: from wip_operations

180: and operation_seq_num < X_Operation_Seq_Num
181: and repetitive_schedule_id = X_Repetitive_Schedule_Id;
182: select min(operation_seq_num)
183: into X_Next_Op_Seq
184: from wip_operations
185: where wip_entity_id = X_Wip_Entity_Id
186: and organization_id = X_Organization_Id
187: and operation_seq_num > X_Operation_Seq_Num
188: and repetitive_schedule_id = X_Repetitive_Schedule_Id;

Line 231: update wip_operations

227: X_Prev_Op_Seq NUMBER,
228: X_Repetitive_Schedule_Id NUMBER) IS
229: BEGIN
230: IF X_Repetitive_Schedule_Id IS NULL then
231: update wip_operations
232: set previous_operation_seq_num = X_Prev_Op_Seq
233: where wip_entity_id = X_Wip_Entity_Id
234: and organization_id = X_Organization_Id
235: and operation_seq_num = X_Operation_Seq_Num;

Line 237: update wip_operations

233: where wip_entity_id = X_Wip_Entity_Id
234: and organization_id = X_Organization_Id
235: and operation_seq_num = X_Operation_Seq_Num;
236: ELSE
237: update wip_operations
238: set previous_operation_seq_num = X_Prev_Op_Seq
239: where wip_entity_id = X_Wip_Entity_Id
240: and organization_id = X_Organization_Id
241: and repetitive_schedule_id = X_Repetitive_Schedule_Id

Line 253: update wip_operations

249: X_Next_Op_Seq NUMBER,
250: X_Repetitive_Schedule_Id NUMBER) IS
251: BEGIN
252: IF X_Repetitive_Schedule_Id IS NULL then
253: update wip_operations
254: set next_operation_seq_num = X_Next_Op_Seq
255: where wip_entity_id = X_Wip_Entity_Id
256: and organization_id = X_Organization_Id
257: and operation_seq_num = X_Operation_Seq_Num;

Line 259: update wip_operations

255: where wip_entity_id = X_Wip_Entity_Id
256: and organization_id = X_Organization_Id
257: and operation_seq_num = X_Operation_Seq_Num;
258: ELSE
259: update wip_operations
260: set next_operation_seq_num = X_Next_Op_Seq
261: where wip_entity_id = X_Wip_Entity_Id
262: and organization_id = X_Organization_Id
263: and repetitive_schedule_id = X_Repetitive_Schedule_Id

Line 555: FROM wip_operations

551: firstop := NULL;
552: IF X_Repetitive_Schedule_Id IS NULL then
553: SELECT nvl(min(operation_seq_num),0)
554: INTO firstop
555: FROM wip_operations
556: WHERE wip_entity_id = X_Wip_Entity_Id
557: AND organization_id = X_Organization_Id;
558: ELSE
559: SELECT nvl(min(operation_seq_num),0)

Line 561: FROM wip_operations

557: AND organization_id = X_Organization_Id;
558: ELSE
559: SELECT nvl(min(operation_seq_num),0)
560: INTO firstop
561: FROM wip_operations
562: WHERE wip_entity_id = X_Wip_Entity_Id
563: AND organization_id = X_Organization_Id
564: AND repetitive_schedule_id = X_Repetitive_Schedule_Id;
565: END IF;

Line 574: FROM wip_operations wo

570: firstdate := X_Entity_Start_Date;
571: ELSIF X_Repetitive_Schedule_Id IS NULL THEN
572: SELECT department_id, first_unit_start_date
573: INTO firstdep, firstdate
574: FROM wip_operations wo
575: WHERE wip_entity_id = X_Wip_Entity_Id
576: AND organization_id = X_Organization_Id
577: AND operation_seq_num = firstop;
578: ELSE

Line 581: FROM wip_operations wo

577: AND operation_seq_num = firstop;
578: ELSE
579: SELECT department_id, first_unit_start_date
580: INTO firstdep, firstdate
581: FROM wip_operations wo
582: WHERE wip_entity_id = X_Wip_Entity_Id
583: AND organization_id = X_Organization_Id
584: AND operation_seq_num = firstop
585: AND repetitive_schedule_id = X_Repetitive_Schedule_Id;

Line 813: UPDATE wip_operations

809: X_Resource_Start_Date DATE,
810: X_Resource_Completion_Date DATE) IS
811: BEGIN
812: IF X_Repetitive_Schedule_Id is NULL THEN
813: UPDATE wip_operations
814: SET first_unit_start_date = DECODE(SIGN(X_First_Unit_Start_Date-
815: X_Resource_Start_Date),
816: -1, X_First_Unit_Start_Date,
817: X_Resource_Start_Date),

Line 827: UPDATE wip_operations

823: wip_entity_id = X_Wip_Entity_Id
824: AND organization_id = X_Organization_Id
825: AND operation_seq_num = X_Operation_Seq_Num;
826: ELSE
827: UPDATE wip_operations
828: SET first_unit_start_date = DECODE(SIGN(X_First_Unit_Start_Date-
829: X_Resource_Start_Date),
830: -1, X_First_Unit_Start_Date,
831: X_Resource_Start_Date),

Line 983: FROM WIP_OPERATIONS

979: INTO X_First_Unit_Start_Date,
980: X_Last_Unit_Start_Date,
981: X_First_Unit_Completion_Date,
982: X_Last_Unit_Completion_Date
983: FROM WIP_OPERATIONS
984: WHERE ORGANIZATION_ID = X_Organization_Id
985: AND WIP_ENTITY_ID = X_Wip_Entity_Id
986: AND OPERATION_SEQ_NUM = X_Prev_Operation_Seq_Num;
987: ELSE

Line 996: FROM WIP_OPERATIONS

992: INTO X_First_Unit_Start_Date,
993: X_Last_Unit_Start_Date,
994: X_First_Unit_Completion_Date,
995: X_Last_Unit_Completion_Date
996: FROM WIP_OPERATIONS
997: WHERE ORGANIZATION_ID = X_Organization_Id
998: AND WIP_ENTITY_ID = X_Wip_Entity_Id
999: AND REPETITIVE_SCHEDULE_ID = X_Repetitive_Schedule_Id
1000: AND OPERATION_SEQ_NUM = X_Prev_Operation_Seq_Num;

Line 1056: END WIP_OPERATIONS_UTILITIES;

1052: BEGIN
1053: ROLLBACK;
1054: END rollback_database;
1055:
1056: END WIP_OPERATIONS_UTILITIES;