DBA Data[Home] [Help]

APPS.INV_RCV_INTEGRATION_APIS dependencies on INV_LOT_API_PUB

Line 29: g_empty_char_tbl inv_lot_api_pub.char_tbl;

25:
26: G_YES CONSTANT VARCHAR2(1) := 'Y';
27: G_NO CONSTANT VARCHAR2(1) := 'N';
28:
29: g_empty_char_tbl inv_lot_api_pub.char_tbl;
30: g_empty_num_tbl inv_lot_api_pub.number_tbl;
31: g_empty_date_tbl inv_lot_api_pub.date_tbl;
32:
33: -- Bug 3446419

Line 30: g_empty_num_tbl inv_lot_api_pub.number_tbl;

26: G_YES CONSTANT VARCHAR2(1) := 'Y';
27: G_NO CONSTANT VARCHAR2(1) := 'N';
28:
29: g_empty_char_tbl inv_lot_api_pub.char_tbl;
30: g_empty_num_tbl inv_lot_api_pub.number_tbl;
31: g_empty_date_tbl inv_lot_api_pub.date_tbl;
32:
33: -- Bug 3446419
34: -- Added primary quantity for Lot/Serial validations in the record type

Line 31: g_empty_date_tbl inv_lot_api_pub.date_tbl;

27: G_NO CONSTANT VARCHAR2(1) := 'N';
28:
29: g_empty_char_tbl inv_lot_api_pub.char_tbl;
30: g_empty_num_tbl inv_lot_api_pub.number_tbl;
31: g_empty_date_tbl inv_lot_api_pub.date_tbl;
32:
33: -- Bug 3446419
34: -- Added primary quantity for Lot/Serial validations in the record type
35: -- if uom_code, organization_id,item_id is not passed then we will

Line 430: , p_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl

426: , p_txn_type IN NUMBER DEFAULT G_SHIP
427: , p_disable_flag IN NUMBER DEFAULT NULL
428: , p_attribute_category IN VARCHAR2 DEFAULT NULL
429: , p_lot_attribute_category IN VARCHAR2 DEFAULT NULL
430: , p_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
431: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
432: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl DEFAULT g_empty_num_tbl
433: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl DEFAULT g_empty_date_tbl
434: , p_grade_code IN VARCHAR2 DEFAULT NULL

Line 431: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl

427: , p_disable_flag IN NUMBER DEFAULT NULL
428: , p_attribute_category IN VARCHAR2 DEFAULT NULL
429: , p_lot_attribute_category IN VARCHAR2 DEFAULT NULL
430: , p_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
431: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
432: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl DEFAULT g_empty_num_tbl
433: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl DEFAULT g_empty_date_tbl
434: , p_grade_code IN VARCHAR2 DEFAULT NULL
435: , p_origination_date IN DATE DEFAULT NULL

Line 432: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl DEFAULT g_empty_num_tbl

428: , p_attribute_category IN VARCHAR2 DEFAULT NULL
429: , p_lot_attribute_category IN VARCHAR2 DEFAULT NULL
430: , p_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
431: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
432: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl DEFAULT g_empty_num_tbl
433: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl DEFAULT g_empty_date_tbl
434: , p_grade_code IN VARCHAR2 DEFAULT NULL
435: , p_origination_date IN DATE DEFAULT NULL
436: , p_date_code IN VARCHAR2 DEFAULT NULL

Line 433: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl DEFAULT g_empty_date_tbl

429: , p_lot_attribute_category IN VARCHAR2 DEFAULT NULL
430: , p_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
431: , p_c_attributes_tbl IN inv_lot_api_pub.char_tbl DEFAULT g_empty_char_tbl
432: , p_n_attributes_tbl IN inv_lot_api_pub.number_tbl DEFAULT g_empty_num_tbl
433: , p_d_attributes_tbl IN inv_lot_api_pub.date_tbl DEFAULT g_empty_date_tbl
434: , p_grade_code IN VARCHAR2 DEFAULT NULL
435: , p_origination_date IN DATE DEFAULT NULL
436: , p_date_code IN VARCHAR2 DEFAULT NULL
437: , p_status_id IN NUMBER DEFAULT NULL