APPS.WIP_MOVE_ALLOC_CLEANUP dependencies on WIP_MOVE_TXN_ALLOCATIONS

Line 6: p_mov_allocs in out nocopy wip_move_txn_allocations_rec) is

2: /* $Header: wipmaclb.pls 115.6 2002/11/28 13:23:49 rmahidha ship $ */
3:
4: procedure fetch_and_delete(
5: p_mov_grp_id in number,
6: p_mov_allocs in out nocopy wip_move_txn_allocations_rec) is
7:
8: i number := 0;
9:
10: cursor get_move_allocs(c_mov_grp_id number) is

Line 26: from wip_move_txn_allocations

22: PROGRAM_ID,
23: PROGRAM_UPDATE_DATE,
24: TRANSACTION_QUANTITY,
25: PRIMARY_QUANTITY
26: from wip_move_txn_allocations
27: where transaction_id in
28: (select transaction_id
29: from wip_move_txn_interface
30: where group_id = c_mov_grp_id);

Line 69: delete from wip_move_txn_allocations

65: p_mov_allocs.PRIMARY_QUANTITY(i) := mov_alloc_rec.PRIMARY_QUANTITY;
66: end loop;
67:
68: if (p_mov_allocs.numrecs > 0) then
69: delete from wip_move_txn_allocations
70: where transaction_id in
71: (select transaction_id
72: from wip_move_txn_interface
73: where group_id = p_mov_grp_id);

Line 78: p_mov_allocs in wip_move_txn_allocations_rec) is

74: end if;
75: end fetch_and_delete;
76:
77: procedure insert_rows(
78: p_mov_allocs in wip_move_txn_allocations_rec) is
79: i number := 1;
80: begin
81: while (i <= nvl(p_mov_allocs.numrecs, 0)) loop
82: insert into wip_move_txn_allocations (

Line 82: insert into wip_move_txn_allocations (

78: p_mov_allocs in wip_move_txn_allocations_rec) is
79: i number := 1;
80: begin
81: while (i <= nvl(p_mov_allocs.numrecs, 0)) loop
82: insert into wip_move_txn_allocations (
83: TRANSACTION_ID,
84: REPETITIVE_SCHEDULE_ID,
85: ORGANIZATION_ID,
86: LAST_UPDATE_DATE,