APPS.WIP_MOVE_TXN_INTERFACE_CLEANUP dependencies on WIP_MOVE_TXN_INTERFACE

Line 1: PACKAGE BODY WIP_MOVE_TXN_INTERFACE_CLEANUP AS

1: PACKAGE BODY WIP_MOVE_TXN_INTERFACE_CLEANUP AS
2: /* $Header: wipmvclb.pls 115.7 2002/11/28 13:38:40 rmahidha ship $ */
3:
4: procedure fetch_and_delete(
5: p_grp_id in number,

Line 6: p_moves in out nocopy wip_move_txn_interface_rec) is

2: /* $Header: wipmvclb.pls 115.7 2002/11/28 13:38:40 rmahidha ship $ */
3:
4: procedure fetch_and_delete(
5: p_grp_id in number,
6: p_moves in out nocopy wip_move_txn_interface_rec) is
7:
8: i number := 0;
9:
10: cursor get_moves(c_grp_id number) is

Line 79: from wip_move_txn_interface

75: qa_collection_id,
76: overcompletion_transaction_id,
77: overcompletion_transaction_qty,
78: overcompletion_primary_qty
79: from wip_move_txn_interface
80: where group_id = c_grp_id;
81:
82: move_rec get_moves%rowtype;
83: begin

Line 174: delete from wip_move_txn_interface

170:
171: close get_moves;
172:
173: if (p_moves.numrecs > 0) then
174: delete from wip_move_txn_interface
175: where group_id = p_grp_id;
176: end if;
177: end fetch_and_delete;
178:

Line 180: p_moves in wip_move_txn_interface_rec) is

176: end if;
177: end fetch_and_delete;
178:
179: procedure insert_rows(
180: p_moves in wip_move_txn_interface_rec) is
181: i number := 1;
182: begin
183: while (i <= nvl(p_moves.numrecs, 0)) loop
184: insert into wip_move_txn_interface (

Line 184: insert into wip_move_txn_interface (

180: p_moves in wip_move_txn_interface_rec) is
181: i number := 1;
182: begin
183: while (i <= nvl(p_moves.numrecs, 0)) loop
184: insert into wip_move_txn_interface (
185: TRANSACTION_ID,
186: LAST_UPDATE_DATE,
187: LAST_UPDATED_BY,
188: LAST_UPDATED_BY_NAME,

Line 326: END WIP_MOVE_TXN_INTERFACE_CLEANUP;

322: i := i + 1;
323: end loop;
324: end insert_rows;
325:
326: END WIP_MOVE_TXN_INTERFACE_CLEANUP;