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.

[Home] [Help]

APPS.INV_SERIAL_NUMBER_PUB dependencies on INV_LOT_SEL_ATTR

Line 412: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

408: l_api_name CONSTANT VARCHAR2(30) := 'insertSerial';
409: l_userid NUMBER;
410: l_loginid NUMBER;
411: l_serial_control_code NUMBER;
412: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
413: l_attributes_default_count NUMBER;
414: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
415: l_column_idx BINARY_INTEGER := 44;
416: l_return_status VARCHAR2(1);

Line 414: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

410: l_loginid NUMBER;
411: l_serial_control_code NUMBER;
412: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
413: l_attributes_default_count NUMBER;
414: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
415: l_column_idx BINARY_INTEGER := 44;
416: l_return_status VARCHAR2(1);
417: l_msg_data VARCHAR2(2000);
418: l_msg_count NUMBER;

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

612: END IF; -- if wms installed is true
613: END IF; -- if transaction_Temp_id is not null
614:
615: ----------------------------------------------------------
616: -- call inv_lot_sel_attr.get_default to get the default value
617: -- of the lot attributes
618: ---------------------------------------------------------
619: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
620: IF l_wms_installed THEN

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

615: ----------------------------------------------------------
616: -- call inv_lot_sel_attr.get_default to get the default value
617: -- of the lot attributes
618: ---------------------------------------------------------
619: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
620: IF l_wms_installed THEN
621: inv_lot_sel_attr.get_default(
622: x_attributes_default => l_attributes_default
623: , x_attributes_default_count => l_attributes_default_count

Line 621: inv_lot_sel_attr.get_default(

617: -- of the lot attributes
618: ---------------------------------------------------------
619: -- invtrace('calling inv_lot_sel_attr.get_default to get the default value of lot attributes');
620: IF l_wms_installed THEN
621: inv_lot_sel_attr.get_default(
622: x_attributes_default => l_attributes_default
623: , x_attributes_default_count => l_attributes_default_count
624: , x_return_status => l_return_status
625: , x_msg_count => l_msg_count

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

898: -- 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);
899: ELSE
900: /** Populate Serial Attribute Category info. **/
901: IF (l_wms_installed) THEN
902: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
903: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
904: , 'Serial Attributes');
905: ELSE
906: -- invtrace('wms is not installed. populating all the column values in the g_serial_attributes_tbl with null value');

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

899: ELSE
900: /** Populate Serial Attribute Category info. **/
901: IF (l_wms_installed) THEN
902: -- invtrace('wms is installed. Calling inv_lot_sel_attr.get_context_code');
903: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
904: , 'Serial Attributes');
905: ELSE
906: -- invtrace('wms is not installed. populating all the column values in the g_serial_attributes_tbl with null value');
907: g_serial_attributes_tbl(1).column_value := NULL;

Line 2418: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2414: l_api_name CONSTANT VARCHAR2(30) := 'insertSerial';
2415: l_userid NUMBER;
2416: l_loginid NUMBER;
2417: l_serial_control_code NUMBER;
2418: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2419: l_attributes_default_count NUMBER;
2420: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2421: l_column_idx BINARY_INTEGER := 44;
2422: l_return_status VARCHAR2(1);

Line 2420: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

2416: l_loginid NUMBER;
2417: l_serial_control_code NUMBER;
2418: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2419: l_attributes_default_count NUMBER;
2420: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
2421: l_column_idx BINARY_INTEGER := 44;
2422: l_return_status VARCHAR2(1);
2423: l_msg_data VARCHAR2(2000);
2424: l_msg_count NUMBER;

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

2595: END IF; -- if wms_installed is true
2596: END IF; -- if transaction_temp_id is not null
2597:
2598: ----------------------------------------------------------
2599: -- call inv_lot_sel_attr.get_default to get the default value
2600: -- of the lot attributes
2601: ---------------------------------------------------------
2602: IF l_wms_installed THEN
2603: inv_lot_sel_attr.get_default(

Line 2603: inv_lot_sel_attr.get_default(

2599: -- call inv_lot_sel_attr.get_default to get the default value
2600: -- of the lot attributes
2601: ---------------------------------------------------------
2602: IF l_wms_installed THEN
2603: inv_lot_sel_attr.get_default(
2604: x_attributes_default => l_attributes_default
2605: , x_attributes_default_count => l_attributes_default_count
2606: , x_return_status => l_return_status
2607: , x_msg_count => l_msg_count

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

2816: /** 2756040 - Populate Serial Attribute Category info when it is not
2817: ** a receiving transaction **/
2818: IF ((g_serial_attributes_tbl(1).column_value = NULL)
2819: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN
2820: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
2821: , 'Serial Attributes');
2822: END IF;
2823: ELSE
2824: g_serial_attributes_tbl(1).column_value := NULL;

Line 3711: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,

3707: x_validation_status OUT NOCOPY VARCHAR2,
3708: p_serial_number IN VARCHAR2,
3709: p_organization_id IN NUMBER,
3710: p_inventory_item_id IN NUMBER,
3711: p_serial_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3712: p_validate_only IN BOOLEAN
3713: ) IS
3714: l_attributes_name VARCHAR2(50) := 'Serial Attributes';
3715: v_flexfield fnd_dflex.dflex_r;

Line 3721: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;

3717: v_contexts fnd_dflex.contexts_dr;
3718: v_segments fnd_dflex.segments_dr;
3719: l_attributes_default_count NUMBER;
3720: l_enabled_attributes NUMBER;
3721: l_attributes_default INV_LOT_SEL_ATTR.Lot_Sel_Attributes_Tbl_Type;
3722: v_context_value mtl_flex_context.descriptive_flex_context_code%type;
3723: v_colName VARCHAR2(50);
3724: l_context_value VARCHAR2(150);
3725: l_return_status VARCHAR2(1);

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

3746: invtrace('VALIDATE_UPDATE_SERIAL_ATT:p_serial_number='||p_serial_number);
3747: END IF;
3748:
3749: -- call to see if the Serial attributes is enabled for this item/org/category combination
3750: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(p_flex_name => l_attributes_name,
3751: p_organization_id => p_organization_id,
3752: p_inventory_item_id => p_inventory_item_id);
3753: IF (l_debug = 1) THEN
3754: invtrace('VALIDATE_UPDATE_SERIAL_ATT:l_enabled_attributes='||l_enabled_attributes);

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

3784: END LOOP;
3785: END IF;
3786:
3787: IF (l_debug = 1) THEN
3788: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling inv_lot_sel_attr.get_default...');
3789: END IF;
3790:
3791: inv_lot_sel_attr.get_default(x_attributes_default => l_attributes_default,
3792: x_attributes_default_count => l_attributes_default_count,

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

3787: IF (l_debug = 1) THEN
3788: invtrace('VALIDATE_UPDATE_SERIAL_ATT:Calling inv_lot_sel_attr.get_default...');
3789: END IF;
3790:
3791: inv_lot_sel_attr.get_default(x_attributes_default => l_attributes_default,
3792: x_attributes_default_count => l_attributes_default_count,
3793: x_return_status => l_return_status,
3794: x_msg_count => l_msg_count,
3795: x_msg_data => x_msg_data,

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

3847:
3848: FOR i IN 1..g_serial_attributes_tbl.COUNT LOOP
3849: IF (Upper(g_serial_attributes_tbl(i).COLUMN_NAME) = 'SERIAL_ATTRIBUTE_CATEGORY'
3850: AND g_serial_attributes_tbl(i).column_value IS NULL ) THEN
3851: inv_lot_sel_attr.get_context_code(l_context_value, p_organization_id,p_inventory_item_id,l_attributes_name);
3852: g_serial_attributes_tbl(i).column_value := l_context_value;
3853: ELSE
3854: l_context_value := g_serial_attributes_tbl(i).column_value;
3855: END IF;

Line 5180: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

5176: l_api_name CONSTANT VARCHAR2(30):= 'insertRangeUnitTrx';
5177: l_userid NUMBER;
5178: l_loginid NUMBER;
5179: l_serial_control_code NUMBER;
5180: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
5181: l_attributes_default_count NUMBER;
5182: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
5183: l_column_idx BINARY_INTEGER := 44;
5184: l_return_status VARCHAR2(1);

Line 5182: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

5178: l_loginid NUMBER;
5179: l_serial_control_code NUMBER;
5180: l_attributes_default INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
5181: l_attributes_default_count NUMBER;
5182: l_attributes_in INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
5183: l_column_idx BINARY_INTEGER := 44;
5184: l_return_status VARCHAR2(1);
5185: l_msg_data VARCHAR2(2000);
5186: l_msg_count NUMBER;

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

5421: END IF; -- if wms_installed is true
5422: END IF; -- if transaction_temp_id is not null
5423:
5424: ----------------------------------------------------------
5425: -- call inv_lot_sel_attr.get_default to get the default value
5426: -- of the lot attributes
5427: ---------------------------------------------------------
5428: IF l_wms_installed THEN
5429: inv_lot_sel_attr.get_default(

Line 5429: inv_lot_sel_attr.get_default(

5425: -- call inv_lot_sel_attr.get_default to get the default value
5426: -- of the lot attributes
5427: ---------------------------------------------------------
5428: IF l_wms_installed THEN
5429: inv_lot_sel_attr.get_default(
5430: x_attributes_default => l_attributes_default
5431: , x_attributes_default_count => l_attributes_default_count
5432: , x_return_status => l_return_status
5433: , x_msg_count => l_msg_count

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

5648: /** 2756040 - Populate Serial Attribute Category info when it is not
5649: ** a receiving transaction **/
5650: IF ((g_serial_attributes_tbl(1).column_value = NULL)
5651: OR(p_transaction_action_id NOT IN(12, 27, 31))) THEN
5652: inv_lot_sel_attr.get_context_code(g_serial_attributes_tbl(1).column_value, p_organization_id, p_inventory_item_id
5653: , 'Serial Attributes');
5654: END IF;
5655: ELSE
5656: g_serial_attributes_tbl(1).column_value := NULL;