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
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
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
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
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
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
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