APPS.WIP_LOT_TEMP_CLEANUP dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 6: p_lots in out nocopy mtl_transaction_lots_temp_rec) is

2: /* $Header: wipltclb.pls 115.6 2002/11/28 13:20:19 rmahidha ship $ */
3:
4: procedure fetch_and_delete(
5: p_tmp_id in number,
6: p_lots in out nocopy mtl_transaction_lots_temp_rec) is
7:
8: i number := 0;
9:
10: cursor get_lots(c_tmp_id number) is

Line 29: from mtl_transaction_lots_temp

25: lot_expiration_date,
26: error_code,
27: serial_transaction_temp_id,
28: group_header_id
29: from mtl_transaction_lots_temp
30: where transaction_temp_id = c_tmp_id;
31:
32: lot_rec get_lots%rowtype;
33: begin

Line 74: delete from mtl_transaction_lots_temp

70:
71: close get_lots;
72:
73: if (p_lots.numrecs > 0) then
74: delete from mtl_transaction_lots_temp
75: where transaction_temp_id = p_tmp_id;
76: end if;
77: end fetch_and_delete;
78:

Line 82: p_lots in out nocopy mtl_transaction_lots_temp_rec) is

78:
79:
80: procedure fetch_and_delete(
81: p_hdr_id in number,
82: p_lots in out nocopy mtl_transaction_lots_temp_rec) is
83:
84: i number := 0;
85:
86: cursor get_lots(c_hdr_id number) is

Line 105: from mtl_transaction_lots_temp

101: lot_expiration_date,
102: error_code,
103: serial_transaction_temp_id,
104: group_header_id
105: from mtl_transaction_lots_temp
106: where group_header_id = c_hdr_id;
107:
108: lot_rec get_lots%rowtype;
109: begin

Line 150: delete from mtl_transaction_lots_temp

146:
147: close get_lots;
148:
149: if (p_lots.numrecs > 0) then
150: delete from mtl_transaction_lots_temp
151: where group_header_id = p_hdr_id;
152: end if;
153: end fetch_and_delete;
154:

Line 156: p_lots in mtl_transaction_lots_temp_rec) is

152: end if;
153: end fetch_and_delete;
154:
155: procedure insert_rows(
156: p_lots in mtl_transaction_lots_temp_rec) is
157: i number := 1;
158: begin
159: while (i <= nvl(p_lots.numrecs,0)) loop
160: insert into mtl_transaction_lots_temp (

Line 160: insert into mtl_transaction_lots_temp (

156: p_lots in mtl_transaction_lots_temp_rec) is
157: i number := 1;
158: begin
159: while (i <= nvl(p_lots.numrecs,0)) loop
160: insert into mtl_transaction_lots_temp (
161: transaction_temp_id,
162: last_update_date,
163: last_updated_by,
164: creation_date,