APPS.INV_RCV_INTEGRATION_APIS dependencies on INV_LOT_API_PUB

Line 1905: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

1901: , p_txn_type IN NUMBER
1902: , p_disable_flag IN NUMBER
1903: , p_attribute_category IN VARCHAR2
1904: , p_lot_attribute_category IN VARCHAR2
1905: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1906: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1907: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1908: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1909: , p_grade_code IN VARCHAR2

Line 1906: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

1902: , p_disable_flag IN NUMBER
1903: , p_attribute_category IN VARCHAR2
1904: , p_lot_attribute_category IN VARCHAR2
1905: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1906: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1907: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1908: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1909: , p_grade_code IN VARCHAR2
1910: , p_origination_date IN DATE

Line 1907: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

1903: , p_attribute_category IN VARCHAR2
1904: , p_lot_attribute_category IN VARCHAR2
1905: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1906: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1907: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1908: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1909: , p_grade_code IN VARCHAR2
1910: , p_origination_date IN DATE
1911: , p_date_code IN VARCHAR2

Line 1908: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

1904: , p_lot_attribute_category IN VARCHAR2
1905: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1906: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1907: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1908: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1909: , p_grade_code IN VARCHAR2
1910: , p_origination_date IN DATE
1911: , p_date_code IN VARCHAR2
1912: , p_status_id IN NUMBER

Line 2032: l_unique_lot := inv_lot_api_pub.validate_unique_lot(

2028: -- a) Check for lot number uniqueness within the organization
2029: -- b) Validate the expiration date based on shelf life code
2030: IF (p_lot_number IS NOT NULL) THEN
2031: --If the lot exists, check for lot uniqueness
2032: l_unique_lot := inv_lot_api_pub.validate_unique_lot(
2033: p_org_id => p_org_id
2034: , p_inventory_item_id => p_inventory_item_id
2035: , p_lot_uniqueness => l_lot_uniqueness
2036: , p_auto_lot_number => p_lot_number);

Line 2121: print_debug('validate_lot_number: calling inv_lot_api_pub.creat_inv_lot to create the lot', 9);

2117: l_lot_exists = 'N') THEN
2118: --Call the create_inv_lot API to create the lot number
2119: l_expiration_date := p_expiration_date;
2120: IF (l_debug = 1) THEN
2121: print_debug('validate_lot_number: calling inv_lot_api_pub.creat_inv_lot to create the lot', 9);
2122: END IF;
2123:
2124: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
2125: , x_msg_count => x_msg_count

Line 2124: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

2120: IF (l_debug = 1) THEN
2121: print_debug('validate_lot_number: calling inv_lot_api_pub.creat_inv_lot to create the lot', 9);
2122: END IF;
2123:
2124: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
2125: , x_msg_count => x_msg_count
2126: , x_msg_data => x_msg_data
2127: , p_inventory_item_id => p_inventory_item_id
2128: , p_organization_id => p_org_id

Line 2162: , p_source => inv_lot_api_pub.inv);

2158: , p_width_uom => p_width_uom
2159: , p_territory_code => p_territory_code
2160: , p_supplier_lot_number => p_supplier_lot_number
2161: , p_vendor_name => p_vendor_name
2162: , p_source => inv_lot_api_pub.inv);
2163: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2164: IF (l_debug = 1) THEN
2165: print_debug('validate_lot_number: Error in creating the lot number', 9);
2166: END IF;