eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LOT_API_PKG dependencies on MTL_LOT_NUMBERS

Line 137: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

133: PROCEDURE Populate_Lot_Records (
134: x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_count OUT NOCOPY NUMBER
136: , x_msg_data OUT NOCOPY VARCHAR2
137: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
138: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
139: , p_copy_lot_attribute_flag IN VARCHAR2
140: , p_source IN NUMBER
141: , p_api_version IN NUMBER

Line 138: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

134: x_return_status OUT NOCOPY VARCHAR2
135: , x_msg_count OUT NOCOPY NUMBER
136: , x_msg_data OUT NOCOPY VARCHAR2
137: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
138: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
139: , p_copy_lot_attribute_flag IN VARCHAR2
140: , p_source IN NUMBER
141: , p_api_version IN NUMBER
142: , p_init_msg_list IN VARCHAR2

Line 168: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

164: PROCEDURE Populate_Lot_Records (
165: x_return_status OUT NOCOPY VARCHAR2
166: , x_msg_count OUT NOCOPY NUMBER
167: , x_msg_data OUT NOCOPY VARCHAR2
168: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
170: , p_copy_lot_attribute_flag IN VARCHAR2
171: , p_source IN NUMBER
172: , p_api_version IN NUMBER

Line 169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

165: x_return_status OUT NOCOPY VARCHAR2
166: , x_msg_count OUT NOCOPY NUMBER
167: , x_msg_data OUT NOCOPY VARCHAR2
168: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE
169: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE
170: , p_copy_lot_attribute_flag IN VARCHAR2
171: , p_source IN NUMBER
172: , p_api_version IN NUMBER
173: , p_init_msg_list IN VARCHAR2

Line 188: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */

184: WHERE organization_id = cp_organization_id;
185:
186: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
187:
188: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
189: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
190: SELECT lot_number
191: FROM mtl_lot_numbers
192: WHERE lot_number = cp_lot_number AND

Line 189: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS

185:
186: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
187:
188: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
189: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
190: SELECT lot_number
191: FROM mtl_lot_numbers
192: WHERE lot_number = cp_lot_number AND
193: inventory_item_id = cp_inventory_item_id AND

Line 191: FROM mtl_lot_numbers

187:
188: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
189: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
190: SELECT lot_number
191: FROM mtl_lot_numbers
192: WHERE lot_number = cp_lot_number AND
193: inventory_item_id = cp_inventory_item_id AND
194: organization_id = cp_organization_id ;
195:

Line 198: CURSOR c_parent_lot_attr (cp_lot_number mtl_lot_numbers.lot_number%TYPE) IS

194: organization_id = cp_organization_id ;
195:
196: l_chk_lot_rec c_chk_lot_exists%ROWTYPE;
197:
198: CURSOR c_parent_lot_attr (cp_lot_number mtl_lot_numbers.lot_number%TYPE) IS
199: SELECT *
200: FROM mtl_lot_numbers
201: WHERE lot_number = cp_lot_number ;
202:

Line 200: FROM mtl_lot_numbers

196: l_chk_lot_rec c_chk_lot_exists%ROWTYPE;
197:
198: CURSOR c_parent_lot_attr (cp_lot_number mtl_lot_numbers.lot_number%TYPE) IS
199: SELECT *
200: FROM mtl_lot_numbers
201: WHERE lot_number = cp_lot_number ;
202:
203: l_parent_lot_attr c_parent_lot_attr%ROWTYPE ;
204:

Line 214: l_child_lot_rec mtl_lot_numbers%ROWTYPE ;

210: l_api_version NUMBER;
211: l_init_msg_list VARCHAR2(100);
212: l_commit VARCHAR2(100);
213: l_source NUMBER;
214: l_child_lot_rec mtl_lot_numbers%ROWTYPE ;
215: l_mtl_gen_obj_no NUMBER ;
216:
217: l_lot_cont BOOLEAN ;
218: l_child_lot_cont BOOLEAN ;

Line 329: -- Check for existence of p_lot_rec.parent_lot_number in Mtl_Lot_Numbers and set p_parent_exists_flag.

325: END IF;
326:
327:
328: l_parent_exists_flag := NULL ;
329: -- Check for existence of p_lot_rec.parent_lot_number in Mtl_Lot_Numbers and set p_parent_exists_flag.
330: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.INVENTORY_ITEM_ID,p_lot_rec.ORGANIZATION_ID);
331: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
332:
333: IF c_chk_lot_exists%FOUND THEN

Line 334: /* Parent lot exists in Mtl_Lot_Numbers Table. */

330: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.INVENTORY_ITEM_ID,p_lot_rec.ORGANIZATION_ID);
331: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
332:
333: IF c_chk_lot_exists%FOUND THEN
334: /* Parent lot exists in Mtl_Lot_Numbers Table. */
335: l_parent_exists_flag := 'Y' ;
336:
337: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
338: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */

Line 338: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */

334: /* Parent lot exists in Mtl_Lot_Numbers Table. */
335: l_parent_exists_flag := 'Y' ;
336:
337: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
338: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */
339: l_parent_exists_flag := 'N' ;
340: END IF;
341: CLOSE c_chk_lot_exists;
342:

Line 351: -- Bug 4115021- For OPM inventory convergence added sampling event id to mtl_lot_numbers table.

347: FETCH c_parent_lot_attr INTO l_parent_lot_attr ;
348:
349: IF c_parent_lot_attr%FOUND THEN
350:
351: -- Bug 4115021- For OPM inventory convergence added sampling event id to mtl_lot_numbers table.
352: x_child_lot_rec.sampling_event_id := NVL ( x_child_lot_rec.sampling_event_id , l_parent_lot_attr.sampling_event_id ) ;
353: x_child_lot_rec.grade_code := NVL ( x_child_lot_rec.grade_code , l_parent_lot_attr.grade_code ) ;
354: x_child_lot_rec.origination_type := NVL ( x_child_lot_rec.origination_type , l_parent_lot_attr.origination_type ) ;
355: x_child_lot_rec.origination_date := NVL ( x_child_lot_rec.origination_date , l_parent_lot_attr.origination_date ) ;

Line 592: p_lot_rec IN OUT NOCOPY mtl_lot_numbers%ROWTYPE

588:
589:
590:
591: PROCEDURE Set_Msi_Default_Attr (
592: p_lot_rec IN OUT NOCOPY mtl_lot_numbers%ROWTYPE
593: , x_return_status OUT NOCOPY VARCHAR2
594: , x_msg_count OUT NOCOPY NUMBER
595: , x_msg_data OUT NOCOPY VARCHAR2
596: )

Line 626: FROM mtl_lot_numbers

622: , origination_type
623: , retest_date
624: , maturity_date
625: , hold_date
626: FROM mtl_lot_numbers
627: WHERE organization_id = cp_organization_id
628: AND inventory_item_id = cp_inventory_item_id
629: AND lot_number = cp_lot_number;
630:

Line 960: , x_lot_rec IN OUT NOCOPY Mtl_Lot_Numbers%ROWTYPE

956: PROCEDURE Validate_Lot_Attributes(
957: x_return_status OUT NOCOPY VARCHAR2
958: , x_msg_count OUT NOCOPY NUMBER
959: , x_msg_data OUT NOCOPY VARCHAR2
960: , x_lot_rec IN OUT NOCOPY Mtl_Lot_Numbers%ROWTYPE
961: , p_source IN NUMBER
962: ) IS
963:
964: /* Shelf life code constants */

Line 975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

971: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
972: l_chk_lot_uniqueness BOOLEAN;
973: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
974: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
975: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
976: l_wms_installed VARCHAR2(5);
977: l_lot_number_uniqueness NUMBER;
978: l_return_status VARCHAR2(1);
979: l_msg_count NUMBER;

Line 982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;

978: l_return_status VARCHAR2(1);
979: l_msg_count NUMBER;
980: l_msg_data VARCHAR2(3000);
981: l_status NUMBER;
982: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
983: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
984: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
985: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
986: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

Line 999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;

995: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;

Line 1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;

996: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;

Line 1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;

997: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;

Line 1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;

998:
999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;

Line 1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;

999: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;

Line 1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;

1000: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;

Line 1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;

1001: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;

Line 1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;

1002: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;

Line 1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;

1003: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;

Line 1008: p_date_code mtl_lot_numbers.date_code%TYPE ;

1004: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;

Line 1009: p_status_id mtl_lot_numbers.status_id%TYPE ;

1005: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;

Line 1010: p_change_date mtl_lot_numbers.change_date%TYPE ;

1006: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;

Line 1011: p_age mtl_lot_numbers.age%TYPE ;

1007: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;

Line 1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;

1008: p_date_code mtl_lot_numbers.date_code%TYPE ;
1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;

Line 1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;

1009: p_status_id mtl_lot_numbers.status_id%TYPE ;
1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;

Line 1014: p_item_size mtl_lot_numbers.item_size%TYPE ;

1010: p_change_date mtl_lot_numbers.change_date%TYPE ;
1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;

Line 1015: p_color mtl_lot_numbers.color%TYPE ;

1011: p_age mtl_lot_numbers.age%TYPE ;
1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;

Line 1016: p_volume mtl_lot_numbers.volume%TYPE ;

1012: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;

Line 1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;

1013: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;

Line 1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;

1014: p_item_size mtl_lot_numbers.item_size%TYPE ;
1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;

Line 1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;

1015: p_color mtl_lot_numbers.color%TYPE ;
1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;

Line 1020: p_length mtl_lot_numbers.length%TYPE ;

1016: p_volume mtl_lot_numbers.volume%TYPE ;
1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;

Line 1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;

1017: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;

Line 1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;

1018: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;

Line 1023: p_thickness mtl_lot_numbers.thickness%TYPE ;

1019: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;

Line 1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;

1020: p_length mtl_lot_numbers.length%TYPE ;
1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;

Line 1025: p_width mtl_lot_numbers.width%TYPE ;

1021: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;

Line 1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;

1022: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;

Line 1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;

1023: p_thickness mtl_lot_numbers.thickness%TYPE ;
1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;

Line 1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;

1024: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;

Line 1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;

1025: p_width mtl_lot_numbers.width%TYPE ;
1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;

Line 1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;

1026: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;

Line 1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;

1027: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
1035:

Line 1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;

1028: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
1035:
1036: l_lot_cont BOOLEAN ;

Line 1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;

1029: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
1035:
1036: l_lot_cont BOOLEAN ;
1037: l_child_lot_cont BOOLEAN ;

Line 1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;

1030: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
1031: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
1032: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
1033: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
1034: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
1035:
1036: l_lot_cont BOOLEAN ;
1037: l_child_lot_cont BOOLEAN ;
1038: l_lot_status_flag VARCHAR2(1) ;

Line 1528: -- Replace the INSERT INTO mtl_lot_numbers statement with population of OUT lot record parameter.

1524: END IF;
1525:
1526: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;
1527:
1528: -- Replace the INSERT INTO mtl_lot_numbers statement with population of OUT lot record parameter.
1529:
1530: x_lot_rec.inventory_item_id := p_inventory_item_id;
1531: x_lot_rec.organization_id := p_organization_id;
1532: x_lot_rec.lot_number := p_lot_number;

Line 1688: FROM mtl_lot_numbers

1684:
1685: /* Parent lot validation logic */
1686: CURSOR c_get_lot_record IS
1687: SELECT *
1688: FROM mtl_lot_numbers
1689: WHERE lot_number = p_lot_number
1690: AND inventory_item_id = p_inventory_item_id
1691: AND organization_id = p_organization_id;
1692:

Line 2189: FROM mtl_lot_numbers

2185: ) IS
2186:
2187: CURSOR c_lot_rec IS
2188: SELECT *
2189: FROM mtl_lot_numbers
2190: WHERE inventory_item_id = p_inventory_item_id
2191: AND organization_id = p_organization_id
2192: AND lot_number = p_lot_number ;
2193:

Line 2311: DELETE FROM mtl_lot_numbers

2307: IF c_lot_rec%FOUND THEN
2308:
2309: l_gen_obj_id := l_lot_rec.gen_object_id ;
2310:
2311: DELETE FROM mtl_lot_numbers
2312: WHERE inventory_item_id = p_inventory_item_id
2313: AND organization_id = p_organization_id
2314: AND lot_number = p_lot_number ;
2315:

Line 2409: FROM mtl_lot_numbers

2405: IF p_org_id IS NOT NULL THEN
2406: BEGIN
2407: SELECT count('1')
2408: INTO l_exists
2409: FROM mtl_lot_numbers
2410: WHERE inventory_item_id = p_inventory_item_id
2411: AND organization_id = p_org_id
2412: AND lot_number = p_lot_number
2413: AND ROWNUM = 1;