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 10968: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

10964: which will be later used in procedure get_serial_attr_record. */
10965:
10966: PROCEDURE get_serial_attr_table
10967: IS
10968: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
10969: l_debug NUMBER
10970: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
10971:
10972: BEGIN

Line 11207: x_lot_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

11203: *attributes from MSNI in x_lot_ser_attr_tbl which is then used for attr val.*
11204: *****************************************************************************/
11205:
11206: PROCEDURE get_serial_attr_record (
11207: x_lot_ser_attr_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
11208: , p_transaction_interface_id IN NUMBER
11209: , p_fm_serial_number IN VARCHAR2
11210: , p_to_serial_number IN VARCHAR2
11211: , p_serial_number IN VARCHAR2

Line 11249: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

11245: ORDER BY column_id;
11246: */
11247:
11248: l_column_id NUMBER;
11249: l_lot_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
11250: l_column_idx NUMBER;
11251: --l_select_stmt LONG;
11252: l_sql_p INTEGER;
11253: l_rows_processed INTEGER;

Line 12110: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

12106: l_login_id NUMBER;
12107: l_sysdate DATE;
12108: l_mtli_csr mtli_csr%ROWTYPE;
12109: l_serial_attributes_csr msn_serial_attributes_csr%ROWTYPE;
12110: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
12111: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
12112: l_debug NUMBER;
12113: l_indexed_ser_attr_tbl lot_sel_index_attr_tbl_type;
12114: l_sequence NUMBER;

Line 12111: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

12107: l_sysdate DATE;
12108: l_mtli_csr mtli_csr%ROWTYPE;
12109: l_serial_attributes_csr msn_serial_attributes_csr%ROWTYPE;
12110: l_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
12111: l_validated_ser_attr_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
12112: l_debug NUMBER;
12113: l_indexed_ser_attr_tbl lot_sel_index_attr_tbl_type;
12114: l_sequence NUMBER;
12115: l_validation_status VARCHAR2 (1);

Line 13495: inv_lot_sel_attr.get_context_code(

13491: --Check if the source and destination Items have the attribute context.
13492: IF(l_debug = 1) THEN
13493: mydebug('In Lot translate : dest Records : checking DFF context', 'tmpinsert2');
13494: END IF;
13495: inv_lot_sel_attr.get_context_code(
13496: context_value => l_context_value_src
13497: ,org_id => l_mti_csr.organization_id
13498: ,item_id => l_old_item_id
13499: ,flex_name => 'Serial Attributes'

Line 13506: inv_lot_sel_attr.get_context_code(

13502: IF(l_debug = 1) THEN
13503: mydebug('l_context_value_src => '|| l_context_value_src, 'tmpinsert2');
13504: END IF;
13505:
13506: inv_lot_sel_attr.get_context_code(
13507: context_value => l_context_value_dst
13508: ,org_id => l_mti_csr.organization_id
13509: ,item_id => l_mti_csr.inventory_item_id
13510: ,flex_name => 'Serial Attributes'