APPS.WIP_SERIAL_TEMP_CLEANUP dependencies on MTL_SERIAL_NUMBERS_TEMP

Line 6: p_serials in out nocopy mtl_serial_numbers_temp_rec) is

2: /* $Header: wipstclb.pls 115.6 2002/11/29 14:38:28 rmahidha ship $ */
3:
4: procedure fetch_and_delete(
5: p_tmp_id in number,
6: p_serials in out nocopy mtl_serial_numbers_temp_rec) is
7:
8: i number := 0;
9:
10: cursor get_serials(c_tmp_id number) is

Line 29: from mtl_serial_numbers_temp

25: to_serial_number,
26: serial_prefix,
27: error_code error_code,
28: group_header_id
29: from mtl_serial_numbers_temp
30: where transaction_temp_id = c_tmp_id;
31:
32: serial_rec get_serials%rowtype;
33: begin

Line 74: delete from mtl_serial_numbers_temp

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

Line 81: p_serials in out nocopy mtl_serial_numbers_temp_rec) is

77: end fetch_and_delete;
78:
79: procedure fetch_and_delete(
80: p_hdr_id in number,
81: p_serials in out nocopy mtl_serial_numbers_temp_rec) is
82:
83: i number := 0;
84:
85: cursor get_serials(c_hdr_id number) is

Line 104: from mtl_serial_numbers_temp

100: to_serial_number,
101: serial_prefix,
102: error_code error_code,
103: group_header_id
104: from mtl_serial_numbers_temp
105: where group_header_id = c_hdr_id;
106:
107: serial_rec get_serials%rowtype;
108: begin

Line 149: delete from mtl_serial_numbers_temp

145:
146: close get_serials;
147:
148: if (p_serials.numrecs > 0) then
149: delete from mtl_serial_numbers_temp
150: where group_header_id = p_hdr_id;
151: end if;
152: end fetch_and_delete;
153:

Line 155: p_serials in mtl_serial_numbers_temp_rec) is

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

Line 159: insert into mtl_serial_numbers_temp (

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