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 135: , x_child_lot_rec OUT NOCOPY MTL_LOT_NUMBERS%ROWTYPE

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

Line 136: , p_lot_rec IN MTL_LOT_NUMBERS%ROWTYPE

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

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

150: WHERE organization_id = cp_organization_id;
151:
152: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
153:
154: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
155: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
156: SELECT lot_number
157: FROM mtl_lot_numbers
158: WHERE lot_number = cp_lot_number AND

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

151:
152: l_lot_uom_conv c_lot_uom_conv%ROWTYPE ;
153:
154: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
155: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
156: SELECT lot_number
157: FROM mtl_lot_numbers
158: WHERE lot_number = cp_lot_number AND
159: inventory_item_id = cp_inventory_item_id AND

Line 157: FROM mtl_lot_numbers

153:
154: /* Cursor definition to check lot existence in Mtl_Lot_Numbers Table */
155: CURSOR c_chk_lot_exists(cp_lot_number mtl_lot_numbers.lot_number%TYPE,cp_inventory_item_id NUMBER, cp_organization_id NUMBER) IS
156: SELECT lot_number
157: FROM mtl_lot_numbers
158: WHERE lot_number = cp_lot_number AND
159: inventory_item_id = cp_inventory_item_id AND
160: organization_id = cp_organization_id ;
161:

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

160: organization_id = cp_organization_id ;
161:
162: l_chk_lot_rec c_chk_lot_exists%ROWTYPE;
163:
164: CURSOR c_parent_lot_attr (cp_lot_number mtl_lot_numbers.lot_number%TYPE) IS
165: SELECT *
166: FROM mtl_lot_numbers
167: WHERE lot_number = cp_lot_number ;
168:

Line 166: FROM mtl_lot_numbers

162: l_chk_lot_rec c_chk_lot_exists%ROWTYPE;
163:
164: CURSOR c_parent_lot_attr (cp_lot_number mtl_lot_numbers.lot_number%TYPE) IS
165: SELECT *
166: FROM mtl_lot_numbers
167: WHERE lot_number = cp_lot_number ;
168:
169: l_parent_lot_attr c_parent_lot_attr%ROWTYPE ;
170:

Line 180: l_child_lot_rec mtl_lot_numbers%ROWTYPE ;

176: l_api_version NUMBER;
177: l_init_msg_list VARCHAR2(100);
178: l_commit VARCHAR2(100);
179: l_source NUMBER;
180: l_child_lot_rec mtl_lot_numbers%ROWTYPE ;
181: l_mtl_gen_obj_no NUMBER ;
182:
183: l_lot_cont BOOLEAN ;
184: l_child_lot_cont BOOLEAN ;

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

288: END IF;
289:
290:
291: l_parent_exists_flag := NULL ;
292: -- Check for existence of p_lot_rec.parent_lot_number in Mtl_Lot_Numbers and set p_parent_exists_flag.
293: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.INVENTORY_ITEM_ID,p_lot_rec.ORGANIZATION_ID);
294: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
295:
296: IF c_chk_lot_exists%FOUND THEN

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

293: OPEN c_chk_lot_exists(p_lot_rec.parent_lot_number,p_lot_rec.INVENTORY_ITEM_ID,p_lot_rec.ORGANIZATION_ID);
294: FETCH c_chk_lot_exists INTO l_chk_lot_rec;
295:
296: IF c_chk_lot_exists%FOUND THEN
297: /* Parent lot exists in Mtl_Lot_Numbers Table. */
298: l_parent_exists_flag := 'Y' ;
299:
300: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
301: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */

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

297: /* Parent lot exists in Mtl_Lot_Numbers Table. */
298: l_parent_exists_flag := 'Y' ;
299:
300: ELSIF c_chk_lot_exists%NOTFOUND AND p_lot_rec.parent_lot_number IS NOT NULL THEN
301: /* Parent lot DOES NOT exist in Mtl_Lot_Numbers Table. */
302: l_parent_exists_flag := 'N' ;
303: END IF;
304: CLOSE c_chk_lot_exists;
305:

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

310: FETCH c_parent_lot_attr INTO l_parent_lot_attr ;
311:
312: IF c_parent_lot_attr%FOUND THEN
313:
314: -- Bug 4115021- For OPM inventory convergence added sampling event id to mtl_lot_numbers table.
315: x_child_lot_rec.sampling_event_id := NVL ( x_child_lot_rec.sampling_event_id , l_parent_lot_attr.sampling_event_id ) ;
316: x_child_lot_rec.grade_code := NVL ( x_child_lot_rec.grade_code , l_parent_lot_attr.grade_code ) ;
317: x_child_lot_rec.origination_type := NVL ( x_child_lot_rec.origination_type , l_parent_lot_attr.origination_type ) ;
318: x_child_lot_rec.origination_date := NVL ( x_child_lot_rec.origination_date , l_parent_lot_attr.origination_date ) ;

Line 552: p_lot_rec IN OUT NOCOPY mtl_lot_numbers%ROWTYPE

548:
549:
550:
551: PROCEDURE Set_Msi_Default_Attr (
552: p_lot_rec IN OUT NOCOPY mtl_lot_numbers%ROWTYPE
553: , x_return_status OUT NOCOPY VARCHAR2
554: , x_msg_count OUT NOCOPY NUMBER
555: , x_msg_data OUT NOCOPY VARCHAR2
556: )

Line 585: FROM mtl_lot_numbers

581: , origination_type
582: , retest_date
583: , maturity_date
584: , hold_date
585: FROM mtl_lot_numbers
586: WHERE organization_id = cp_organization_id
587: AND inventory_item_id = cp_inventory_item_id
588: AND lot_number = cp_lot_number;
589:

Line 904: , x_lot_rec IN OUT NOCOPY Mtl_Lot_Numbers%ROWTYPE

900: PROCEDURE Validate_Lot_Attributes(
901: x_return_status OUT NOCOPY VARCHAR2
902: , x_msg_count OUT NOCOPY NUMBER
903: , x_msg_data OUT NOCOPY VARCHAR2
904: , x_lot_rec IN OUT NOCOPY Mtl_Lot_Numbers%ROWTYPE
905: , p_source IN NUMBER
906: ) IS
907:
908: /* Shelf life code constants */

Line 919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;

915: l_lot_control_code mtl_system_items_b.lot_control_code%TYPE;
916: l_chk_lot_uniqueness BOOLEAN;
917: l_shelf_life_days mtl_system_items.shelf_life_days%TYPE;
918: l_shelf_life_code mtl_system_items.shelf_life_code%TYPE;
919: l_expiration_date mtl_lot_numbers.expiration_date%TYPE;
920: l_wms_installed VARCHAR2(5);
921: l_lot_number_uniqueness NUMBER;
922: l_return_status VARCHAR2(1);
923: l_msg_count NUMBER;

Line 926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;

922: l_return_status VARCHAR2(1);
923: l_msg_count NUMBER;
924: l_msg_data VARCHAR2(3000);
925: l_status NUMBER;
926: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE;
927: l_inv_attributes_tbl inv_lot_api_pub.char_tbl;
928: l_c_attributes_tbl inv_lot_api_pub.char_tbl;
929: l_n_attributes_tbl inv_lot_api_pub.number_tbl;
930: l_d_attributes_tbl inv_lot_api_pub.date_tbl;

Line 943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;

939: p_c_attributes_tbl inv_lot_api_pub.char_tbl ;
940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;

Line 944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;

940: p_n_attributes_tbl inv_lot_api_pub.number_tbl ;
941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;

Line 945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;

941: p_d_attributes_tbl inv_lot_api_pub.date_tbl ;
942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;

Line 946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;

942:
943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;

Line 947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;

943: p_inventory_item_id mtl_lot_numbers.inventory_item_id%TYPE ;
944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;

Line 948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;

944: p_organization_id mtl_lot_numbers.organization_id%TYPE ;
945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;

Line 949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;

945: p_lot_number mtl_lot_numbers.lot_number%TYPE ;
946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;

Line 950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;

946: p_expiration_date mtl_lot_numbers.expiration_date%TYPE ;
947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;

Line 951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;

947: p_disable_flag mtl_lot_numbers.disable_flag%TYPE ;
948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;

Line 952: p_date_code mtl_lot_numbers.date_code%TYPE ;

948: p_attribute_category mtl_lot_numbers.attribute_category%TYPE ;
949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;

Line 953: p_status_id mtl_lot_numbers.status_id%TYPE ;

949: p_lot_attribute_category mtl_lot_numbers.lot_attribute_category%TYPE ;
950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;

Line 954: p_change_date mtl_lot_numbers.change_date%TYPE ;

950: p_grade_code mtl_lot_numbers.grade_code%TYPE ;
951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;

Line 955: p_age mtl_lot_numbers.age%TYPE ;

951: p_origination_date mtl_lot_numbers.origination_date%TYPE ;
952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;

Line 956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;

952: p_date_code mtl_lot_numbers.date_code%TYPE ;
953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;

Line 957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;

953: p_status_id mtl_lot_numbers.status_id%TYPE ;
954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;

Line 958: p_item_size mtl_lot_numbers.item_size%TYPE ;

954: p_change_date mtl_lot_numbers.change_date%TYPE ;
955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;

Line 959: p_color mtl_lot_numbers.color%TYPE ;

955: p_age mtl_lot_numbers.age%TYPE ;
956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;

Line 960: p_volume mtl_lot_numbers.volume%TYPE ;

956: p_retest_date mtl_lot_numbers.retest_date%TYPE ;
957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;

Line 961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;

957: p_maturity_date mtl_lot_numbers.maturity_date%TYPE ;
958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;

Line 962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;

958: p_item_size mtl_lot_numbers.item_size%TYPE ;
959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;

Line 963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;

959: p_color mtl_lot_numbers.color%TYPE ;
960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;

Line 964: p_length mtl_lot_numbers.length%TYPE ;

960: p_volume mtl_lot_numbers.volume%TYPE ;
961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;

Line 965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;

961: p_volume_uom mtl_lot_numbers.volume_uom%TYPE ;
962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;

Line 966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;

962: p_place_of_origin mtl_lot_numbers.place_of_origin%TYPE ;
963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;

Line 967: p_thickness mtl_lot_numbers.thickness%TYPE ;

963: p_best_by_date mtl_lot_numbers.best_by_date%TYPE ;
964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;

Line 968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;

964: p_length mtl_lot_numbers.length%TYPE ;
965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;

Line 969: p_width mtl_lot_numbers.width%TYPE ;

965: p_length_uom mtl_lot_numbers.length_uom%TYPE ;
966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;

Line 970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;

966: p_recycled_content mtl_lot_numbers.recycled_content%TYPE ;
967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;

Line 971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;

967: p_thickness mtl_lot_numbers.thickness%TYPE ;
968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;

Line 972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;

968: p_thickness_uom mtl_lot_numbers.thickness_uom%TYPE ;
969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;

Line 973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;

969: p_width mtl_lot_numbers.width%TYPE ;
970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;

Line 974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;

970: p_width_uom mtl_lot_numbers.width_uom%TYPE ;
971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;

Line 975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;

971: p_territory_code mtl_lot_numbers.territory_code%TYPE ;
972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
979:

Line 976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;

972: p_supplier_lot_number mtl_lot_numbers.supplier_lot_number%TYPE ;
973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
979:
980: l_lot_cont BOOLEAN ;

Line 977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;

973: p_vendor_name mtl_lot_numbers.vendor_name%TYPE ;
974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
979:
980: l_lot_cont BOOLEAN ;
981: l_child_lot_cont BOOLEAN ;

Line 978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;

974: p_parent_lot_number mtl_lot_numbers.parent_lot_number%TYPE ;
975: p_origination_type mtl_lot_numbers.origination_type%TYPE ;
976: p_expiration_action_code mtl_lot_numbers.expiration_action_code%TYPE ;
977: p_expiration_action_date mtl_lot_numbers.expiration_action_date%TYPE ;
978: p_hold_date mtl_lot_numbers.hold_date%TYPE ;
979:
980: l_lot_cont BOOLEAN ;
981: l_child_lot_cont BOOLEAN ;
982: l_lot_status_flag VARCHAR2(1) ;

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

1468: END IF;
1469:
1470: -- SELECT MTL_GEN_OBJECT_ID_S.NEXTVAL INTO l_mtl_gen_obj_no FROM dual;
1471:
1472: -- Replace the INSERT INTO mtl_lot_numbers statement with population of OUT lot record parameter.
1473:
1474: x_lot_rec.inventory_item_id := p_inventory_item_id;
1475: x_lot_rec.organization_id := p_organization_id;
1476: x_lot_rec.lot_number := p_lot_number;

Line 1632: FROM mtl_lot_numbers

1628:
1629: /* Parent lot validation logic */
1630: CURSOR c_get_lot_record IS
1631: SELECT *
1632: FROM mtl_lot_numbers
1633: WHERE lot_number = p_lot_number
1634: AND inventory_item_id = p_inventory_item_id
1635: AND organization_id = p_organization_id;
1636:

Line 2133: FROM mtl_lot_numbers

2129: ) IS
2130:
2131: CURSOR c_lot_rec IS
2132: SELECT *
2133: FROM mtl_lot_numbers
2134: WHERE inventory_item_id = p_inventory_item_id
2135: AND organization_id = p_organization_id
2136: AND lot_number = p_lot_number ;
2137:

Line 2255: DELETE FROM mtl_lot_numbers

2251: IF c_lot_rec%FOUND THEN
2252:
2253: l_gen_obj_id := l_lot_rec.gen_object_id ;
2254:
2255: DELETE FROM mtl_lot_numbers
2256: WHERE inventory_item_id = p_inventory_item_id
2257: AND organization_id = p_organization_id
2258: AND lot_number = p_lot_number ;
2259:

Line 2353: FROM mtl_lot_numbers

2349: IF p_org_id IS NOT NULL THEN
2350: BEGIN
2351: SELECT count('1')
2352: INTO l_exists
2353: FROM mtl_lot_numbers
2354: WHERE inventory_item_id = p_inventory_item_id
2355: AND organization_id = p_org_id
2356: AND lot_number = p_lot_number
2357: AND ROWNUM = 1;