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_LOT_API_PUB dependencies on INV_LOT_SEL_ATTR

Line 39: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,

35:
36: PROCEDURE get_lot_att_from_source (
37: x_return_status OUT NOCOPY VARCHAR2,
38: x_count OUT NOCOPY NUMBER,
39: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,
40: x_source_non_wms_lot_att_rec OUT NOCOPY non_wms_lot_att_rec_type,
41: p_from_organization_id IN NUMBER,
42: p_inventory_item_id IN NUMBER,
43: p_lot_number IN VARCHAR2,

Line 45: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

41: p_from_organization_id IN NUMBER,
42: p_inventory_item_id IN NUMBER,
43: p_lot_number IN VARCHAR2,
44: p_count IN NUMBER,
45: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
46: );
47:
48: /********************** Bug - 2181558 Additions Ends ************************/
49:

Line 245: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

241: l_userid NUMBER;
242: l_loginid NUMBER;
243: l_shelf_life_code NUMBER;
244: l_shelf_life_days NUMBER;
245: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
246: l_attributes_default_count NUMBER;
247: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
248: l_column_idx BINARY_INTEGER;
249: l_return_status VARCHAR2 ( 1 );

Line 247: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

243: l_shelf_life_code NUMBER;
244: l_shelf_life_days NUMBER;
245: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
246: l_attributes_default_count NUMBER;
247: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
248: l_column_idx BINARY_INTEGER;
249: l_return_status VARCHAR2 ( 1 );
250: l_msg_data VARCHAR2 ( 2000 );
251: l_msg_count NUMBER;

Line 262: l_att_after_source_copy inv_lot_sel_attr.lot_sel_attributes_tbl_type;

258: l_default_serial_status_id NUMBER;
259: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
260:
261: -- Bug 2181558 Variable Declaration Starts
262: l_att_after_source_copy inv_lot_sel_attr.lot_sel_attributes_tbl_type;
263: l_source_non_wms_lot_att_rec non_wms_lot_att_rec_type;
264: l_num_wms_lot_att_copied NUMBER;
265: -- Bug 2181558 Variable Declaration Ends
266: l_dest_status_enabled VARCHAR2(1); --Added bug4066234

Line 1001: * call inv_lot_sel_attr.get_default to get the default value

997: inv_pick_wave_pick_confirm_pub.tracelog ( 'After Insert action_id=3' , 'INV_LOT_API_PUB');
998: END IF;
999: ELSE -- if transaction_action_id is not 3
1000: /* ---------------------------------------------------------
1001: * call inv_lot_sel_attr.get_default to get the default value
1002: * of the lot attributes
1003: * ---------------------------------------------------------*/
1004: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE ) THEN
1005:

Line 1009: inv_lot_sel_attr.get_default (

1005:
1006: IF (l_debug = 1) THEN
1007: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_default' , 'INV_LOT_API_PUB');
1008: END IF;
1009: inv_lot_sel_attr.get_default (
1010: x_attributes_default => l_attributes_default,
1011: x_attributes_default_count => l_attributes_default_count,
1012: x_return_status => l_return_status,
1013: x_msg_count => l_msg_count,

Line 1152: inv_lot_sel_attr.get_context_code

1148:
1149: --print_debug('before get_context_code 20', 4);
1150:
1151: /** Populate Lot Attribute Category info. **/
1152: inv_lot_sel_attr.get_context_code
1153: (
1154: g_lot_attributes_tbl ( 10 ).column_value,
1155: p_organization_id,
1156: p_inventory_item_id,

Line 1476: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1472: x_msg_count OUT NOCOPY NUMBER,
1473: x_msg_data OUT NOCOPY VARCHAR2
1474: )
1475: IS
1476: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1477: l_attributes_default_count NUMBER;
1478: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1479: l_column_idx BINARY_INTEGER;
1480: l_return_status VARCHAR2 ( 1 );

Line 1478: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1474: )
1475: IS
1476: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1477: l_attributes_default_count NUMBER;
1478: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1479: l_column_idx BINARY_INTEGER;
1480: l_return_status VARCHAR2 ( 1 );
1481: l_msg_data VARCHAR2 ( 2000 );
1482: l_msg_count NUMBER;

Line 1934: * call inv_lot_sel_attr.get_default to get the default value

1930: and LOT.inventory_item_id = p_inventory_item_id);
1931: */
1932: ELSE
1933: /* ---------------------------------------------------------
1934: * call inv_lot_sel_attr.get_default to get the default value
1935: * of the lot attributes
1936: * ---------------------------------------------------------*/
1937: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE )
1938: THEN

Line 1939: inv_lot_sel_attr.get_default (

1935: * of the lot attributes
1936: * ---------------------------------------------------------*/
1937: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE )
1938: THEN
1939: inv_lot_sel_attr.get_default (
1940: x_attributes_default => l_attributes_default,
1941: x_attributes_default_count => l_attributes_default_count,
1942: x_return_status => l_return_status,
1943: x_msg_count => l_msg_count,

Line 1989: inv_lot_sel_attr.get_context_code (

1985: END IF;
1986: END IF;
1987:
1988: /** Populate Lot Attribute Category info. **/
1989: inv_lot_sel_attr.get_context_code (
1990: g_lot_attributes_tbl ( 10 ).column_value,
1991: p_organization_id,
1992: p_inventory_item_id,
1993: 'Lot Attributes'

Line 3613: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,

3609: ***************************************************************************************/
3610: PROCEDURE get_lot_att_from_source (
3611: x_return_status OUT NOCOPY VARCHAR2,
3612: x_count OUT NOCOPY NUMBER,
3613: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3614: x_source_non_wms_lot_att_rec OUT NOCOPY non_wms_lot_att_rec_type,
3615: p_from_organization_id IN NUMBER,
3616: p_inventory_item_id IN NUMBER,
3617: p_lot_number IN VARCHAR2,

Line 3619: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

3615: p_from_organization_id IN NUMBER,
3616: p_inventory_item_id IN NUMBER,
3617: p_lot_number IN VARCHAR2,
3618: p_count IN NUMBER,
3619: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3620: )
3621: IS
3622: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3623: v_found BOOLEAN := FALSE;

Line 3622: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3618: p_count IN NUMBER,
3619: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3620: )
3621: IS
3622: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3623: v_found BOOLEAN := FALSE;
3624: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3625: BEGIN
3626: IF (l_debug = 1) THEN

Line 5006: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');

5002: print_debug('Upd Lot Attr: WMS is installed ', 9);
5003: END IF;
5004:
5005: IF p_lot_rec.lot_attribute_category IS NULL THEN
5006: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');
5007: ELSE
5008: l_context := p_lot_rec.lot_attribute_category;
5009: END IF;
5010:

Line 5227: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');

5223:
5224: l_context := NULL;
5225:
5226: IF p_lot_rec.lot_attribute_category IS NULL THEN
5227: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');
5228: ELSE
5229: l_context := p_lot_rec.lot_attribute_category;
5230: END IF;
5231:

Line 7120: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;

7116: ) IS
7117: TYPE seg_name IS TABLE OF VARCHAR2(1000)
7118: INDEX BY BINARY_INTEGER;
7119:
7120: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7121: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7122: l_attributes_default_count NUMBER;
7123: l_c_attr_index NUMBER;
7124: l_n_attr_index NUMBER;

Line 7121: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

7117: TYPE seg_name IS TABLE OF VARCHAR2(1000)
7118: INDEX BY BINARY_INTEGER;
7119:
7120: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7121: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7122: l_attributes_default_count NUMBER;
7123: l_c_attr_index NUMBER;
7124: l_n_attr_index NUMBER;
7125: l_d_attr_index NUMBER;

Line 7531: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(

7527: IF g_debug = 1 THEN
7528: print_debug('After populating the lot_dff table with D_ATTRIBUTES', 9);
7529: END IF;
7530:
7531: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(
7532: p_flex_name => 'Lot Attributes'
7533: , p_organization_id => p_organization_id
7534: , p_inventory_item_id => p_inventory_item_id);
7535:

Line 7542: inv_lot_sel_attr.get_default (

7538: end if;
7539: /*
7540: * Get the default lot attribute values if any
7541: */
7542: inv_lot_sel_attr.get_default (
7543: x_attributes_default => l_attributes_default,
7544: x_attributes_default_count => l_attributes_default_count,
7545: x_return_status => l_return_status,
7546: x_msg_count => l_msg_count,

Line 7679: inv_lot_sel_attr.get_context_code(l_context, p_organization_id, p_inventory_item_id, 'Lot Attributes');

7675: print_debug('setting l_context = ' || p_lot_attribute_category, 9);
7676: l_context := p_lot_attribute_category;
7677: ELSE
7678: /*Get the context for the item passed */
7679: inv_lot_sel_attr.get_context_code(l_context, p_organization_id, p_inventory_item_id, 'Lot Attributes');
7680: END IF;
7681:
7682: IF l_context IS NULL AND l_required_flag = TRUE THEN
7683: fnd_message.set_name('WMS', 'WMS_NO_CONTEXT');