APPS.INV_RCV_INTEGRATION_APIS dependencies on INV_LOT_API_PUB

Line 1921: , p_attributes_tbl IN inv_lot_api_pub.char_tbl

1917: , p_txn_type IN NUMBER
1918: , p_disable_flag IN NUMBER
1919: , p_attribute_category IN VARCHAR2
1920: , p_lot_attribute_category IN VARCHAR2
1921: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1922: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1923: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1924: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1925: , p_grade_code IN VARCHAR2

Line 1922: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl

1918: , p_disable_flag IN NUMBER
1919: , p_attribute_category IN VARCHAR2
1920: , p_lot_attribute_category IN VARCHAR2
1921: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1922: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1923: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1924: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1925: , p_grade_code IN VARCHAR2
1926: , p_origination_date IN DATE

Line 1923: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl

1919: , p_attribute_category IN VARCHAR2
1920: , p_lot_attribute_category IN VARCHAR2
1921: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1922: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1923: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1924: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1925: , p_grade_code IN VARCHAR2
1926: , p_origination_date IN DATE
1927: , p_date_code IN VARCHAR2

Line 1924: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl

1920: , p_lot_attribute_category IN VARCHAR2
1921: , p_attributes_tbl IN inv_lot_api_pub.char_tbl
1922: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl
1923: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl
1924: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl
1925: , p_grade_code IN VARCHAR2
1926: , p_origination_date IN DATE
1927: , p_date_code IN VARCHAR2
1928: , p_status_id IN NUMBER

Line 2048: l_unique_lot := inv_lot_api_pub.validate_unique_lot(

2044: -- a) Check for lot number uniqueness within the organization
2045: -- b) Validate the expiration date based on shelf life code
2046: IF (p_lot_number IS NOT NULL) THEN
2047: --If the lot exists, check for lot uniqueness
2048: l_unique_lot := inv_lot_api_pub.validate_unique_lot(
2049: p_org_id => p_org_id
2050: , p_inventory_item_id => p_inventory_item_id
2051: , p_lot_uniqueness => l_lot_uniqueness
2052: , p_auto_lot_number => p_lot_number);

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

2133: l_lot_exists = 'N') THEN
2134: --Call the create_inv_lot API to create the lot number
2135: l_expiration_date := p_expiration_date;
2136: IF (l_debug = 1) THEN
2137: print_debug('validate_lot_number: calling inv_lot_api_pub.creat_inv_lot to create the lot', 9);
2138: END IF;
2139:
2140: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
2141: , x_msg_count => x_msg_count

Line 2140: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status

2136: IF (l_debug = 1) THEN
2137: print_debug('validate_lot_number: calling inv_lot_api_pub.creat_inv_lot to create the lot', 9);
2138: END IF;
2139:
2140: inv_lot_api_pub.create_inv_lot(x_return_status => x_return_status
2141: , x_msg_count => x_msg_count
2142: , x_msg_data => x_msg_data
2143: , p_inventory_item_id => p_inventory_item_id
2144: , p_organization_id => p_org_id

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

2174: , p_width_uom => p_width_uom
2175: , p_territory_code => p_territory_code
2176: , p_supplier_lot_number => p_supplier_lot_number
2177: , p_vendor_name => p_vendor_name
2178: , p_source => inv_lot_api_pub.inv);
2179: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2180: IF (l_debug = 1) THEN
2181: print_debug('validate_lot_number: Error in creating the lot number', 9);
2182: END IF;