eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_LOT_SEL_ATTR

Line 379: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

375: l_api_name CONSTANT VARCHAR2(30) := 'insertSerial';
376: l_userid NUMBER;
377: l_loginid NUMBER;
378: l_serial_control_code NUMBER;
379: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
380: l_attributes_default_count NUMBER;
381: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
382: l_column_idx BINARY_INTEGER := 44;
383: l_return_status VARCHAR2(1);

Line 381: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

377: l_loginid NUMBER;
378: l_serial_control_code NUMBER;
379: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
380: l_attributes_default_count NUMBER;
381: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
382: l_column_idx BINARY_INTEGER := 44;
383: l_return_status VARCHAR2(1);
384: l_msg_data VARCHAR2(2000);
385: l_msg_count NUMBER;

Line 582: -- call inv_lot_sel_attr.get_default to get the default value

578: END IF; -- if wms installed is true
579: END IF; -- if transaction_Temp_id is not null
580:
581: ----------------------------------------------------------
582: -- call inv_lot_sel_attr.get_default to get the default value
583: -- of the lot attributes
584: ---------------------------------------------------------
585: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
586: IF l_wms_installed THEN

Line 585: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');

581: ----------------------------------------------------------
582: -- call inv_lot_sel_attr.get_default to get the default value
583: -- of the lot attributes
584: ---------------------------------------------------------
585: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
586: IF l_wms_installed THEN
587: inv_lot_sel_attr.get_default(
588: x_attributes_default => l_attributes_default
589: , x_attributes_default_count => l_attributes_default_count

Line 587: inv_lot_sel_attr.get_default(

583: -- of the lot attributes
584: ---------------------------------------------------------
585: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
586: IF l_wms_installed THEN
587: inv_lot_sel_attr.get_default(
588: x_attributes_default => l_attributes_default
589: , x_attributes_default_count => l_attributes_default_count
590: , x_return_status => l_return_status
591: , x_msg_count => l_msg_count

Line 868: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');

864: -- invtrace('l_status_id from MSN when serial_number = ' || p_serial_number || ' current_organization_id = ' || p_organization_id || 'inventory_item_id = ' || p_inventory_item_id);
865: ELSE
866: /** Populate Serial Attribute Category info. **/
867: IF (l_wms_installed) THEN
868: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
869: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
870: , 'Serial Attributes');
871: ELSE
872: -- invtrace('wms is not installed. populating all the column values in the g_serial_attributes_tbl with null value');

Line 869: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id

865: ELSE
866: /** Populate Serial Attribute Category info. **/
867: IF (l_wms_installed) THEN
868: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
869: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
870: , 'Serial Attributes');
871: ELSE
872: -- invtrace('wms is not installed. populating all the column values in the g_serial_attributes_tbl with null value');
873: g_serial_attributes_tbl(1).column_value := NULL;

Line 2087: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2083: l_api_name CONSTANT VARCHAR2(30) := 'insertSerial';
2084: l_userid NUMBER;
2085: l_loginid NUMBER;
2086: l_serial_control_code NUMBER;
2087: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2088: l_attributes_default_count NUMBER;
2089: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2090: l_column_idx BINARY_INTEGER := 44;
2091: l_return_status VARCHAR2(1);

Line 2089: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2085: l_loginid NUMBER;
2086: l_serial_control_code NUMBER;
2087: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2088: l_attributes_default_count NUMBER;
2089: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2090: l_column_idx BINARY_INTEGER := 44;
2091: l_return_status VARCHAR2(1);
2092: l_msg_data VARCHAR2(2000);
2093: l_msg_count NUMBER;

Line 2268: -- call inv_lot_sel_attr.get_default to get the default value

2264: END IF; -- if wms_installed is true
2265: END IF; -- if transaction_temp_id is not null
2266:
2267: ----------------------------------------------------------
2268: -- call inv_lot_sel_attr.get_default to get the default value
2269: -- of the lot attributes
2270: ---------------------------------------------------------
2271: IF l_wms_installed THEN
2272: inv_lot_sel_attr.get_default(

Line 2272: inv_lot_sel_attr.get_default(

2268: -- call inv_lot_sel_attr.get_default to get the default value
2269: -- of the lot attributes
2270: ---------------------------------------------------------
2271: IF l_wms_installed THEN
2272: inv_lot_sel_attr.get_default(
2273: x_attributes_default => l_attributes_default
2274: , x_attributes_default_count => l_attributes_default_count
2275: , x_return_status => l_return_status
2276: , x_msg_count => l_msg_count

Line 2489: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id

2485: /** 2756040 - Populate Serial Attribute Category info when it is not
2486: ** a receiving transaction **/
2487: IF ((g_serial_attributes_tbl(1).column_value = NULL)
2488: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN
2489: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
2490: , 'Serial Attributes');
2491: END IF;
2492: ELSE
2493: g_serial_attributes_tbl(1).column_value := NULL;

Line 3354: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,

3350: x_validation_status OUT NOCOPY VARCHAR2,
3351: p_serial_number IN VARCHAR2,
3352: p_organization_id IN NUMBER,
3353: p_inventory_item_id IN NUMBER,
3354: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3355: p_validate_only IN BOOLEAN
3356: ) IS
3357: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3358: v_flexfield fnd_dflex.dflex_r;

Line 3364: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;

3360: v_contexts fnd_dflex.contexts_dr;
3361: v_segments fnd_dflex.segments_dr;
3362: l_attributes_default_count NUMBER;
3363: l_enabled_attributes NUMBER;
3364: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;
3365: v_context_value mtl_flex_context.descriptive_flex_context_code%type;
3366: v_colName VARCHAR2(50);
3367: l_context_value VARCHAR2(150);
3368: l_return_status VARCHAR2(1);

Line 3393: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(p_flex_name => l_attributes_name,

3389: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_serial_number='||p_serial_number);
3390: END IF;
3391:
3392: -- call to see if the Serial attributes is enabled for this item/org/category combination
3393: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(p_flex_name => l_attributes_name,
3394: p_organization_id => p_organization_id,
3395: p_inventory_item_id => p_inventory_item_id);
3396: IF (l_debug = 1) THEN
3397: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_enabled_attributes='||l_enabled_attributes);

Line 3423: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling inv_lot_sel_attr.get_default...');

3419: END LOOP;
3420: END IF;
3421:
3422: IF (l_debug = 1) THEN
3423: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling inv_lot_sel_attr.get_default...');
3424: END IF;
3425:
3426: inv_lot_sel_attr.get_default(x_attributes_default => l_attributes_default,
3427: x_attributes_default_count => l_attributes_default_count,

Line 3426: inv_lot_sel_attr.get_default(x_attributes_default => l_attributes_default,

3422: IF (l_debug = 1) THEN
3423: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling inv_lot_sel_attr.get_default...');
3424: END IF;
3425:
3426: inv_lot_sel_attr.get_default(x_attributes_default => l_attributes_default,
3427: x_attributes_default_count => l_attributes_default_count,
3428: x_return_status => l_return_status,
3429: x_msg_count => l_msg_count,
3430: x_msg_data => x_msg_data,

Line 3486: inv_lot_sel_attr.get_context_code(l_context_value, p_organization_id,p_inventory_item_id,l_attributes_name);

3482:
3483: FOR i IN 1..g_serial_attributes_tbl.COUNT LOOP
3484: IF (Upper(g_serial_attributes_tbl(i).COLUMN_NAME) = 'SERIAL_ATTRIBUTE_CATEGORY'
3485: AND g_serial_attributes_tbl(i).column_value IS NULL ) THEN
3486: inv_lot_sel_attr.get_context_code(l_context_value, p_organization_id,p_inventory_item_id,l_attributes_name);
3487: g_serial_attributes_tbl(i).column_value := l_context_value;
3488: ELSE
3489: l_context_value := g_serial_attributes_tbl(i).column_value;
3490: END IF;

Line 4793: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

4789: l_api_name CONSTANT VARCHAR2(30):= 'insertRangeUnitTrx';
4790: l_userid NUMBER;
4791: l_loginid NUMBER;
4792: l_serial_control_code NUMBER;
4793: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
4794: l_attributes_default_count NUMBER;
4795: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
4796: l_column_idx BINARY_INTEGER := 44;
4797: l_return_status VARCHAR2(1);

Line 4795: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

4791: l_loginid NUMBER;
4792: l_serial_control_code NUMBER;
4793: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
4794: l_attributes_default_count NUMBER;
4795: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
4796: l_column_idx BINARY_INTEGER := 44;
4797: l_return_status VARCHAR2(1);
4798: l_msg_data VARCHAR2(2000);
4799: l_msg_count NUMBER;

Line 5038: -- call inv_lot_sel_attr.get_default to get the default value

5034: END IF; -- if wms_installed is true
5035: END IF; -- if transaction_temp_id is not null
5036:
5037: ----------------------------------------------------------
5038: -- call inv_lot_sel_attr.get_default to get the default value
5039: -- of the lot attributes
5040: ---------------------------------------------------------
5041: IF l_wms_installed THEN
5042: inv_lot_sel_attr.get_default(

Line 5042: inv_lot_sel_attr.get_default(

5038: -- call inv_lot_sel_attr.get_default to get the default value
5039: -- of the lot attributes
5040: ---------------------------------------------------------
5041: IF l_wms_installed THEN
5042: inv_lot_sel_attr.get_default(
5043: x_attributes_default => l_attributes_default
5044: , x_attributes_default_count => l_attributes_default_count
5045: , x_return_status => l_return_status
5046: , x_msg_count => l_msg_count

Line 5265: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id

5261: /** 2756040 - Populate Serial Attribute Category info when it is not
5262: ** a receiving transaction **/
5263: IF ((g_serial_attributes_tbl(1).column_value = NULL)
5264: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN
5265: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
5266: , 'Serial Attributes');
5267: END IF;
5268: ELSE
5269: g_serial_attributes_tbl(1).column_value := NULL;