APPS.WIP_OVERCOMPLETION dependencies on WIP_OPERATIONS

Line 187: | update_wip_operations

183: end ;
184:
185: /*=====================================================================+
186: | PROCEDURE
187: | update_wip_operations
188: |
189: | PURPOSE
190: | Updates the quantity in the queue step of the from operation for
191: | the child move transactions

Line 200: procedure update_wip_operations

196: |
197: | NOTES
198: |
199: +=====================================================================*/
200: procedure update_wip_operations
201: (
202: p_txn_id IN NUMBER, -- must be of the CHILD
203: P_GROUP_ID IN NUMBER,
204: P_TXN_DATE IN VARCHAR2,

Line 212: update wip_operations wop

208: P_APPL_ID IN NUMBER default -1,
209: P_PROG_ID IN NUMBER default -1
210: ) is
211: BEGIN
212: update wip_operations wop
213: set (quantity_in_queue
214: ,last_updated_by
215: , last_update_date,
216: last_update_login, request_id, program_application_id,

Line 229: wip_operations wop1,

225: DECODE(P_appl_id,-1,NULL,P_appl_id),
226: DECODE(P_prog_id,-1,NULL,P_prog_id),
227: DECODE(P_req_id,-1,NULL,SYSDATE)
228: from
229: wip_operations wop1,
230: wip_move_txn_interface wti1,
231: wip_move_txn_allocations wma1
232: where
233: wop1.rowid = wop.rowid

Line 253: wip_operations wop2,

249: -- must be passed.
250: where wop.rowid =
251: (
252: select wop2.rowid from
253: wip_operations wop2,
254: wip_move_txn_interface wti2,
255: wip_move_txn_allocations wma2
256: where
257: wti2.group_id = p_group_id

Line 469: WIP_OPERATIONS_INFO.first_operation

465:
466:
467: /* For the parent wip_entity_id, find the first operation */
468:
469: WIP_OPERATIONS_INFO.first_operation
470: (
471: p_org_id =>to_number(x_org_id),
472: p_wip_entity_id => to_number(x_wip_entity_id),
473: p_line_id => to_number(x_line_id),

Line 671: FROM wip_operations wop

667: -- This first operation check is not necessary since, no other transaction
668: -- will have their op seq and steps match !!
669: /* AND exists
670: ( SELECT 'x'
671: FROM wip_operations wop
672: WHERE
673: wti.organization_id = wop.organization_id
674: AND wti.wip_entity_id = wop.wip_entity_id
675: AND wti.fm_operation_seq_num = wop.operation_seq_num

Line 963: WIP_OPERATIONS_INFO.first_operation

959:
960:
961: /* For the parent wip_entity_id, find the first operation */
962:
963: WIP_OPERATIONS_INFO.first_operation
964: (
965: p_org_id => to_number(x_org_id),
966: p_wip_entity_id => to_number(x_wip_entity_id),
967: p_line_id => to_number(x_line_id),

Line 984: wip_operations wo

980: x_last_department_id,
981: x_last_department_code
982: from bom_standard_operations bso,
983: bom_departments bd,
984: wip_operations wo
985: WHERE wo.operation_seq_num = x_last_operation_seq_num
986: AND wo.department_id = bd.department_id
987: AND wo.standard_operation_id = bso.standard_operation_id (+)
988: AND wo.organization_id = x_org_id