[Home] [Help]
6: g_pkg_name CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_put_away';
7:
8: /* FP-J Lot/Serial Support Enhancement
9: * Record type to store information for one serial number. This is used for
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
9: * Record type to store information for one serial number. This is used for
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
10: * inserting MTL_SERIAL_NUMBERS for the serial numbers in the LPN
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
11: */
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
12: TYPE msn_attribute_rec_tp IS RECORD(
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
13: serial_number mtl_serial_numbers.serial_number%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
14: , to_serial_number mtl_serial_numbers.serial_number%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
15: , vendor_serial_number mtl_serial_numbers.vendor_serial_number%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
16: , vendor_lot_number mtl_serial_numbers.vendor_lot_number%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
17: , parent_serial_number mtl_serial_numbers.parent_serial_number%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
18: , origination_date mtl_serial_numbers.origination_date%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
19: , end_item_unit_number mtl_serial_numbers.end_item_unit_number%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
20: , territory_code mtl_serial_numbers.territory_code%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
21: , time_since_new mtl_serial_numbers.time_since_new%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
22: , cycles_since_new mtl_serial_numbers.cycles_since_new%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
23: , time_since_overhaul mtl_serial_numbers.time_since_overhaul%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
24: , cycles_since_overhaul mtl_serial_numbers.cycles_since_overhaul%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
25: , time_since_repair mtl_serial_numbers.time_since_repair%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
26: , cycles_since_repair mtl_serial_numbers.cycles_since_repair%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
27: , time_since_visit mtl_serial_numbers.time_since_visit%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
28: , cycles_since_visit mtl_serial_numbers.cycles_since_visit%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
29: , time_since_mark mtl_serial_numbers.time_since_mark%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
30: , cycles_since_mark mtl_serial_numbers.cycles_since_mark%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
31: , number_of_repairs mtl_serial_numbers.number_of_repairs%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
32: , serial_attribute_category mtl_serial_numbers.serial_attribute_category%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
33: , c_attribute1 mtl_serial_numbers.c_attribute1%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
34: , c_attribute2 mtl_serial_numbers.c_attribute2%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
35: , c_attribute3 mtl_serial_numbers.c_attribute3%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
36: , c_attribute4 mtl_serial_numbers.c_attribute4%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
37: , c_attribute5 mtl_serial_numbers.c_attribute5%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
38: , c_attribute6 mtl_serial_numbers.c_attribute6%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
39: , c_attribute7 mtl_serial_numbers.c_attribute7%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
40: , c_attribute8 mtl_serial_numbers.c_attribute8%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
41: , c_attribute9 mtl_serial_numbers.c_attribute9%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
42: , c_attribute10 mtl_serial_numbers.c_attribute10%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
43: , c_attribute11 mtl_serial_numbers.c_attribute11%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
44: , c_attribute12 mtl_serial_numbers.c_attribute12%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
45: , c_attribute13 mtl_serial_numbers.c_attribute13%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
46: , c_attribute14 mtl_serial_numbers.c_attribute14%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
47: , c_attribute15 mtl_serial_numbers.c_attribute15%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
48: , c_attribute16 mtl_serial_numbers.c_attribute16%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
49: , c_attribute17 mtl_serial_numbers.c_attribute17%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
50: , c_attribute18 mtl_serial_numbers.c_attribute18%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
51: , c_attribute19 mtl_serial_numbers.c_attribute19%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
52: , c_attribute20 mtl_serial_numbers.c_attribute20%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
53: , d_attribute1 mtl_serial_numbers.d_attribute1%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
54: , d_attribute2 mtl_serial_numbers.d_attribute2%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
55: , d_attribute3 mtl_serial_numbers.d_attribute3%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
56: , d_attribute4 mtl_serial_numbers.d_attribute4%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
57: , d_attribute5 mtl_serial_numbers.d_attribute5%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
58: , d_attribute6 mtl_serial_numbers.d_attribute6%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
59: , d_attribute7 mtl_serial_numbers.d_attribute7%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
60: , d_attribute8 mtl_serial_numbers.d_attribute8%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
61: , d_attribute9 mtl_serial_numbers.d_attribute9%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
62: , d_attribute10 mtl_serial_numbers.d_attribute10%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
63: , n_attribute1 mtl_serial_numbers.n_attribute1%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
64: , n_attribute2 mtl_serial_numbers.n_attribute2%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
65: , n_attribute3 mtl_serial_numbers.n_attribute3%TYPE
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
66: , n_attribute4 mtl_serial_numbers.n_attribute4%TYPE
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
67: , n_attribute5 mtl_serial_numbers.n_attribute5%TYPE
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
75:
68: , n_attribute6 mtl_serial_numbers.n_attribute6%TYPE
69: , n_attribute7 mtl_serial_numbers.n_attribute7%TYPE
70: , n_attribute8 mtl_serial_numbers.n_attribute8%TYPE
71: , n_attribute9 mtl_serial_numbers.n_attribute9%TYPE
72: , n_attribute10 mtl_serial_numbers.n_attribute10%TYPE
73: );
74:
75:
76: -- Constants and types declaration
662: AND rs.lpn_id = l_lpn
663: AND rs.item_id = l_inventory_item_id
664: AND rs.to_organization_id = l_org_id
665: AND EXISTS(SELECT 1
666: FROM mtl_serial_numbers msn
667: WHERE msn.inventory_item_id = l_inventory_item_id
668: -- AND msn.lpn_id = rs.lpn_id --14133874
669: AND msn.serial_number = rss.serial_num );
670:
2603: CLOSE suggestions_csr;
2604: END IF;
2605: END suggestions_pub;
2606:
2607: /* Local function to insert record in MTL_SERIAL_NUMBERS_TEMP given
2608: * a record type containing the information of one serial number (including
2609: * attributes). This procedure is called from complete_putaway to create
2610: * as many MSNT records for the serial numbers within the LPN for the quantity
2611: * confirmed
2616: , p_serial_atts IN msn_attribute_rec_tp
2617: , p_user_id IN NUMBER
2618: , p_to_serial_number IN VARCHAR2 DEFAULT NULL) RETURN BOOLEAN IS
2619: BEGIN
2620: INSERT INTO mtl_serial_numbers_temp
2621: (
2622: transaction_temp_id
2623: , last_update_date
2624: , last_updated_by
2970: WHEN OTHERS THEN
2971: RETURN FALSE;
2972: END insert_dup_mtlt;
2973:
2974: /* Local function to insert records in MTL_SERIAL_NUMBERS_TEMP
2975: * from the original MSNT record(s). These records are needed by
2976: * the receiving transaction manager for the deliver transaction
2977: */
2978: FUNCTION insert_dup_msnt (
2978: FUNCTION insert_dup_msnt (
2979: p_orig_temp_id IN NUMBER
2980: , p_new_temp_id IN NUMBER) RETURN BOOLEAN IS
2981: BEGIN
2982: INSERT INTO mtl_serial_numbers_temp
2983: (
2984: transaction_temp_id
2985: , last_update_date
2986: , last_updated_by
3111: , n_attribute7
3112: , n_attribute8
3113: , n_attribute9
3114: , n_attribute10
3115: FROM mtl_serial_numbers_temp
3116: WHERE transaction_temp_id = p_orig_temp_id);
3117: RETURN TRUE;
3118: EXCEPTION
3119: WHEN OTHERS THEN
3212: RETURN FALSE;
3213: END insert_mtli_helper;
3214:
3215: /* FP-J Lot/Serial Support Enhancement
3216: * Helper routine to create MTL_SERIAL_NUMBERS_INTERFACE records
3217: * for the serials corresponding to the dropped quantity
3218: * Called for a receiving LPN when INV and PO patch levels are J or higher
3219: */
3220: FUNCTION insert_msni_helper(
3240:
3241: --Get the serial status
3242: SELECT status_id
3243: INTO l_serial_status_id
3244: FROM mtl_serial_numbers
3245: WHERE serial_number = p_serial_number
3246: AND inventory_item_id = p_item_id;
3247:
3248: --Call the insert_msni API
3445: -- Added for Bug 6356147
3446: l_flow_schedule VARCHAR2(1);
3447:
3448: --Bug #2966531 - Fetch serial attributes in addition to serial number
3449: --from MTL_SERIAL_NUMBERS for the LPN item combination
3450: CURSOR ser_csr IS
3451: SELECT serial_number
3452: , serial_number to_serial_number
3453: , vendor_serial_number
3507: , n_attribute7
3508: , n_attribute8
3509: , n_attribute9
3510: , n_attribute10
3511: FROM mtl_serial_numbers
3512: WHERE lpn_id = p_lpn_id
3513: AND inventory_item_id = p_item_id
3514: AND NVL(revision, '#%^') = NVL(p_rev, '#%^')
3515: AND NVL(lot_number, -999) = NVL(p_lot, -999)
3608: n_attribute7 ,
3609: n_attribute8 ,
3610: n_attribute9 ,
3611: n_attribute10
3612: FROM mtl_serial_numbers
3613: WHERE lpn_id = p_lpn_id
3614: AND inventory_item_id = p_item_id
3615: AND NVL(revision, '#%^') = NVL(p_rev, '#%^')
3616: AND NVL(lot_number, -999) = NVL(p_lot, -999)
3717: , n_attribute7
3718: , n_attribute8
3719: , n_attribute9
3720: , n_attribute10
3721: FROM mtl_serial_numbers msn
3722: WHERE msn.lpn_id = p_lpn_id
3723: AND msn.inventory_item_id = p_item_id
3724: AND ((p_rev IS NOT NULL AND msn.revision = p_rev)
3725: OR (p_rev IS NULL AND msn.revision IS NULL))
3798: , n_attribute7
3799: , n_attribute8
3800: , n_attribute9
3801: , n_attribute10
3802: FROM mtl_serial_numbers_interface msni
3803: -- Bug# 3281512 - Performance Fixes
3804: -- Since this cursor is only used for receiving, the product code
3805: -- will always be 'RCV'. This is needed in order to use the index.
3806: WHERE msni.product_code = 'RCV'
4181: --4049874
4182: IF l_serial_code = 6 THEN
4183: SELECT count(1)
4184: INTO l_is_msni_req
4185: FROM mtl_serial_numbers
4186: WHERE inventory_item_id = p_item_id
4187: AND lpn_id = p_lpn_id
4188: AND current_status = 7
4189: AND current_organization_id = p_org_id;
4384: -- ER 7307189 changes start
4385:
4386: SELECT COUNT(msn.group_mark_id)
4387: INTO res_count
4388: FROM mtl_serial_numbers msn ,
4389: mtl_reservations mr
4390: WHERE mr.lpn_id =msn.lpn_id
4391: AND msn.group_mark_id=mr.reservation_id
4392: AND msn.lpn_id = p_lpn_id;
4547: END IF; --END IF check transaction_source_type = 5clear scr
4548: END IF; --END IF p_entire_lpn = 'N'
4549:
4550: /*
4551: * Do not update MTL_SERIAL_NUMBERS from here if the LPN Resides in
4552: * Receiving and WMS and PO patch levels are J or higher
4553: * For other LPN contexts and if patch levels are lower than J,
4554: * continue with the updates
4555: */
4563: mydebug('complete_putaway: INV/WIP LPN. Update MSN.');
4564: END IF;
4565:
4566: -- Update MSN's group_mark_id
4567: UPDATE mtl_serial_numbers
4568: SET group_mark_id = p_temp_id
4569: WHERE serial_number = l_serial
4570: AND inventory_item_id = p_item_id
4571: AND lot_number = p_lot;
4573: -- Bug 2458540
4574: -- Update the Serial Status to 4 before calling Receiving Transaction
4575: -- Processor for RMA serial At SALES ORDER ISSUE STANDARD RECEIPT CASE
4576: IF (l_serial_code = 6 AND l_ref = 'ORDER_LINE_ID') THEN
4577: UPDATE mtl_serial_numbers
4578: SET current_status = 4
4579: , previous_status = current_status
4580: WHERE serial_number = l_serial
4581: AND inventory_item_id = p_item_id
4615: -- ER 7307189 changes start
4616:
4617: SELECT COUNT(msn.group_mark_id)
4618: INTO res_count
4619: FROM mtl_serial_numbers msn ,
4620: mtl_reservations mr
4621: WHERE mr.lpn_id =msn.lpn_id
4622: AND msn.group_mark_id=mr.reservation_id
4623: AND msn.lpn_id = p_lpn_id;
4771: /* Bug 5213359-Added the following check */
4772:
4773: SELECT count(transaction_temp_id)
4774: INTO l_exist_msnt
4775: FROM mtl_serial_numbers_temp
4776: WHERE transaction_temp_id = p_temp_id
4777: AND fm_serial_number = l_serial ;
4778:
4779: mydebug('complete_putaway In patchset J, checking for msnt l_exist_msnt:'|| l_exist_msnt);
4799: END IF; --END IF l_transaction_source_type_id = 5
4800: END IF; --END IF p_entire_lpn = 'N'
4801:
4802: /*
4803: * Do not update MTL_SERIAL_NUMBERS from here if the LPN Resides in
4804: * Receiving and WMS and PO patch levels are J or higher
4805: * For other LPN contexts and if patch levels are lower than J,
4806: * continue with the updates
4807: */
4815: mydebug('complete_putaway: INV/WIP LPN. ');
4816: END IF;
4817:
4818: -- Update MSN's group_mark_id
4819: UPDATE mtl_serial_numbers
4820: SET group_mark_id = p_temp_id
4821: WHERE serial_number = l_serial
4822: AND inventory_item_id = p_item_id;
4823:
4824: -- Bug 2458540
4825: -- Update the Serial Status to 4 before calling Receiving Transaction
4826: -- Processor for RMA serial At SALES ORDER ISSUE STANDARD RECEIPT CASE
4827: IF (l_serial_code = 6 AND l_ref = 'ORDER_LINE_ID') THEN
4828: UPDATE mtl_serial_numbers
4829: SET current_status = 4
4830: , previous_status = current_status
4831: WHERE serial_number = l_serial
4832: AND inventory_item_id = p_item_id;
5442: END IF; --END IF check sub type to call the corresponding API
5443: --14487832
5444: IF l_serial_code NOT IN (1,6) THEN
5445:
5446: DELETE FROM mtl_serial_numbers_interface
5447: WHERE product_transaction_id = l_product_transaction_id;
5448:
5449: IF (l_debug = 1) THEN
5450: mydebug('complete_putaway: Deleted msni with l_product_transaction_id '||l_product_transaction_id);
6623: WHERE transaction_temp_id = l_temp_id;
6624:
6625: -- Delete lot and serial records
6626: BEGIN
6627: DELETE mtl_serial_numbers_temp
6628: WHERE transaction_temp_id = (SELECT serial_transaction_temp_id
6629: FROM mtl_transaction_lots_temp
6630: WHERE transaction_temp_id = l_temp_id);
6631: EXCEPTION
6641: NULL;
6642: END;
6643:
6644: BEGIN
6645: DELETE mtl_serial_numbers_temp
6646: WHERE transaction_temp_id = l_temp_id;
6647: EXCEPTION
6648: WHEN NO_DATA_FOUND THEN
6649: NULL;
6743:
6744: IF p_delete_mmtt_flag = 'Y' THEN
6745: -- Delete lot and serial records
6746: BEGIN
6747: DELETE mtl_serial_numbers_temp
6748: WHERE transaction_temp_id IN
6749: (SELECT serial_transaction_temp_id
6750: FROM mtl_transaction_lots_temp
6751: WHERE transaction_temp_id = l_temp_id);
6764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6765: END;
6766:
6767: BEGIN
6768: DELETE mtl_serial_numbers_temp
6769: WHERE transaction_temp_id = l_temp_id;
6770: EXCEPTION
6771: WHEN OTHERS THEN
6772: mydebug('archive_task: Error deleting MSNT: ' || sqlerrm);
6850: -- Add cursor to get the serial number(s) for a given MSNT record.
6851: -- SQL compiler complains of a Hash Join otherwise.
6852: CURSOR c_serial_number(v_transaction_temp_id NUMBER) IS
6853: SELECT fm_serial_number
6854: FROM mtl_serial_numbers_temp
6855: WHERE transaction_temp_id = v_transaction_temp_id;
6856: l_fm_serial_number NUMBER;
6857:
6858: BEGIN
6989: LOOP
6990: FETCH c_serial_number INTO l_fm_serial_number;
6991: EXIT WHEN c_serial_number%NOTFOUND;
6992:
6993: UPDATE mtl_serial_numbers
6994: SET group_mark_id = NULL
6995: WHERE serial_number = l_fm_serial_number
6996: AND inventory_item_id = l_item_id
6997: AND current_organization_id = l_org_id;
7013: LOOP
7014: FETCH c_serial_number INTO l_fm_serial_number;
7015: EXIT WHEN c_serial_number%NOTFOUND;
7016:
7017: UPDATE mtl_serial_numbers
7018: SET group_mark_id = NULL
7019: WHERE serial_number = l_fm_serial_number
7020: AND inventory_item_id = l_item_id
7021: AND current_organization_id = l_org_id;
7044: LOOP
7045: FETCH c_serial_number INTO l_fm_serial_number;
7046: EXIT WHEN c_serial_number%NOTFOUND;
7047:
7048: UPDATE mtl_serial_numbers
7049: SET current_status = 5,
7050: previous_status = NULL
7051: WHERE serial_number = l_fm_serial_number
7052: AND inventory_item_id = l_item_id
7074: LOOP
7075: FETCH c_serial_number INTO l_fm_serial_number;
7076: EXIT WHEN c_serial_number%NOTFOUND;
7077:
7078: UPDATE mtl_serial_numbers
7079: SET current_status = 5,
7080: previous_status = NULL
7081: WHERE serial_number = l_fm_serial_number
7082: AND inventory_item_id = l_item_id
7458: WHERE transaction_temp_id = l_temp_id;
7459:
7460: CURSOR ser_csr IS
7461: SELECT serial_number
7462: FROM mtl_serial_numbers
7463: WHERE lpn_id = l_lpn_id
7464: AND inventory_item_id = l_item_id
7465: AND current_organization_id = l_org_id
7466: AND NVL(lot_number, -999) = NVL(l_lot_number, -999);
9036: AND lpn_id = p_lpn_id;
9037:
9038: CURSOR l_serial_cursor IS
9039: SELECT serial_number
9040: FROM mtl_serial_numbers
9041: WHERE inventory_item_id = l_item_id
9042: AND current_organization_id = p_organization_id
9043: AND lpn_id = p_lpn_id;
9044: