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 463: WIP_OPERATIONS_INFO.first_operation

459:
460:
461: /* For the parent wip_entity_id, find the first operation */
462:
463: WIP_OPERATIONS_INFO.first_operation
464: (
465: p_org_id =>to_number(x_org_id),
466: p_wip_entity_id => to_number(x_wip_entity_id),
467: p_line_id => to_number(x_line_id),

Line 665: FROM wip_operations wop

661: -- This first operation check is not necessary since, no other transaction
662: -- will have their op seq and steps match !!
663: /* AND exists
664: ( SELECT 'x'
665: FROM wip_operations wop
666: WHERE
667: wti.organization_id = wop.organization_id
668: AND wti.wip_entity_id = wop.wip_entity_id
669: AND wti.fm_operation_seq_num = wop.operation_seq_num

Line 957: WIP_OPERATIONS_INFO.first_operation

953:
954:
955: /* For the parent wip_entity_id, find the first operation */
956:
957: WIP_OPERATIONS_INFO.first_operation
958: (
959: p_org_id => to_number(x_org_id),
960: p_wip_entity_id => to_number(x_wip_entity_id),
961: p_line_id => to_number(x_line_id),

Line 978: wip_operations wo

974: x_last_department_id,
975: x_last_department_code
976: from bom_standard_operations bso,
977: bom_departments bd,
978: wip_operations wo
979: WHERE wo.operation_seq_num = x_last_operation_seq_num
980: AND wo.department_id = bd.department_id
981: AND wo.standard_operation_id = bso.standard_operation_id (+)
982: AND wo.organization_id = x_org_id