APPS.INV_TXN_MANAGER_GRP dependencies on INV_LOT_SEL_ATTR

Line 18: g_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

14: l_acctid_validated BOOLEAN := FALSE ; --Bug#4247753. Added this variable
15: --to indicate if 'validate_acctid' has
16: --already been called in 'GETACCTID'
17: g_pkg_name VARCHAR2(80) ;
18: g_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
19: g_select_stmt LONG :=
20: 'SELECT NVL(MSNI.SERIAL_ATTRIBUTE_CATEGORY,
21: MSN.SERIAL_ATTRIBUTE_CATEGORY),
22: NVL(MSNI.C_ATTRIBUTE1,

Line 10397: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

10393: which will be later used in procedure get_serial_attr_record. */
10394:
10395: PROCEDURE get_serial_attr_table
10396: IS
10397: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
10398: l_debug NUMBER
10399: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10400:
10401: BEGIN

Line 10636: x_lot_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

10632: *attributes from MSNI in x_lot_ser_attr_tbl which is then used for attr val.*
10633: *****************************************************************************/
10634:
10635: PROCEDURE get_serial_attr_record (
10636: x_lot_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
10637: , p_transaction_interface_id IN NUMBER
10638: , p_fm_serial_number IN VARCHAR2
10639: , p_to_serial_number IN VARCHAR2
10640: , p_serial_number IN VARCHAR2

Line 10678: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

10674: ORDER BY column_id;
10675: */
10676:
10677: l_column_id NUMBER;
10678: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
10679: l_column_idx NUMBER;
10680: --l_select_stmt LONG;
10681: l_sql_p INTEGER;
10682: l_rows_processed INTEGER;

Line 11539: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

11535: l_login_id NUMBER;
11536: l_sysdate DATE;
11537: l_mtli_csr mtli_csr%ROWTYPE;
11538: l_serial_attributes_csr msn_serial_attributes_csr%ROWTYPE;
11539: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
11540: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
11541: l_debug NUMBER;
11542: l_indexed_ser_attr_tbl lot_sel_index_attr_tbl_type;
11543: l_sequence NUMBER;

Line 11540: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

11536: l_sysdate DATE;
11537: l_mtli_csr mtli_csr%ROWTYPE;
11538: l_serial_attributes_csr msn_serial_attributes_csr%ROWTYPE;
11539: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
11540: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
11541: l_debug NUMBER;
11542: l_indexed_ser_attr_tbl lot_sel_index_attr_tbl_type;
11543: l_sequence NUMBER;
11544: l_validation_status VARCHAR2 (1);

Line 12924: inv_lot_sel_attr.get_context_code(

12920: --Check if the source and destination Items have the attribute context.
12921: IF(l_debug = 1) THEN
12922: mydebug('In Lot translate : dest Records : checking DFF context', 'tmpinsert2');
12923: END IF;
12924: inv_lot_sel_attr.get_context_code(
12925: context_value => l_context_value_src
12926: ,org_id => l_mti_csr.organization_id
12927: ,item_id => l_old_item_id
12928: ,flex_name => 'Serial Attributes'

Line 12935: inv_lot_sel_attr.get_context_code(

12931: IF(l_debug = 1) THEN
12932: mydebug('l_context_value_src => '|| l_context_value_src, 'tmpinsert2');
12933: END IF;
12934:
12935: inv_lot_sel_attr.get_context_code(
12936: context_value => l_context_value_dst
12937: ,org_id => l_mti_csr.organization_id
12938: ,item_id => l_mti_csr.inventory_item_id
12939: ,flex_name => 'Serial Attributes'