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 356: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

352: l_userid NUMBER;
353: l_loginid NUMBER;
354: l_shelf_life_code NUMBER;
355: l_shelf_life_days NUMBER;
356: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
357: l_attributes_default_count NUMBER;
358: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
359: l_column_idx BINARY_INTEGER;
360: l_return_status VARCHAR2 ( 1 );

Line 358: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

354: l_shelf_life_code NUMBER;
355: l_shelf_life_days NUMBER;
356: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
357: l_attributes_default_count NUMBER;
358: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
359: l_column_idx BINARY_INTEGER;
360: l_return_status VARCHAR2 ( 1 );
361: l_msg_data VARCHAR2 ( 2000 );
362: l_msg_count NUMBER;

Line 373: l_att_after_source_copy inv_lot_sel_attr.lot_sel_attributes_tbl_type;

369: l_default_serial_status_id NUMBER;
370: l_status_rec inv_material_status_pub.mtl_status_update_rec_type;
371:
372: -- Bug 2181558 Variable Declaration Starts
373: l_att_after_source_copy inv_lot_sel_attr.lot_sel_attributes_tbl_type;
374: l_source_non_wms_lot_att_rec non_wms_lot_att_rec_type;
375: l_num_wms_lot_att_copied NUMBER;
376: -- Bug 2181558 Variable Declaration Ends
377: l_dest_status_enabled VARCHAR2(1); --Added bug4066234

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

1112: inv_pick_wave_pick_confirm_pub.tracelog ( 'After Insert action_id=3' , 'INV_LOT_API_PUB');
1113: END IF;
1114: ELSE -- if transaction_action_id is not 3
1115: /* ---------------------------------------------------------
1116: * call inv_lot_sel_attr.get_default to get the default value
1117: * of the lot attributes
1118: * ---------------------------------------------------------*/
1119: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE ) THEN
1120:

Line 1124: inv_lot_sel_attr.get_default (

1120:
1121: IF (l_debug = 1) THEN
1122: inv_pick_wave_pick_confirm_pub.tracelog ( 'Before calling get_default' , 'INV_LOT_API_PUB');
1123: END IF;
1124: inv_lot_sel_attr.get_default (
1125: x_attributes_default => l_attributes_default,
1126: x_attributes_default_count => l_attributes_default_count,
1127: x_return_status => l_return_status,
1128: x_msg_count => l_msg_count,

Line 1267: inv_lot_sel_attr.get_context_code

1263:
1264: --print_debug('before get_context_code 20', 4);
1265:
1266: /** Populate Lot Attribute Category info. **/
1267: inv_lot_sel_attr.get_context_code
1268: (
1269: g_lot_attributes_tbl ( 10 ).column_value,
1270: p_organization_id,
1271: p_inventory_item_id,

Line 1595: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1591: x_msg_count OUT NOCOPY NUMBER,
1592: x_msg_data OUT NOCOPY VARCHAR2
1593: )
1594: IS
1595: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1596: l_attributes_default_count NUMBER;
1597: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1598: l_column_idx BINARY_INTEGER;
1599: l_return_status VARCHAR2 ( 1 );

Line 1597: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;

1593: )
1594: IS
1595: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1596: l_attributes_default_count NUMBER;
1597: l_attributes_in inv_lot_sel_attr.lot_sel_attributes_tbl_type;
1598: l_column_idx BINARY_INTEGER;
1599: l_return_status VARCHAR2 ( 1 );
1600: l_msg_data VARCHAR2 ( 2000 );
1601: l_msg_count NUMBER;

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

2049: and LOT.inventory_item_id = p_inventory_item_id);
2050: */
2051: ELSE
2052: /* ---------------------------------------------------------
2053: * call inv_lot_sel_attr.get_default to get the default value
2054: * of the lot attributes
2055: * ---------------------------------------------------------*/
2056: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE )
2057: THEN

Line 2058: inv_lot_sel_attr.get_default (

2054: * of the lot attributes
2055: * ---------------------------------------------------------*/
2056: IF ( inv_install.adv_inv_installed ( NULL ) = TRUE )
2057: THEN
2058: inv_lot_sel_attr.get_default (
2059: x_attributes_default => l_attributes_default,
2060: x_attributes_default_count => l_attributes_default_count,
2061: x_return_status => l_return_status,
2062: x_msg_count => l_msg_count,

Line 2108: inv_lot_sel_attr.get_context_code (

2104: END IF;
2105: END IF;
2106:
2107: /** Populate Lot Attribute Category info. **/
2108: inv_lot_sel_attr.get_context_code (
2109: g_lot_attributes_tbl ( 10 ).column_value,
2110: p_organization_id,
2111: p_inventory_item_id,
2112: 'Lot Attributes'

Line 2567: l_got_lock:= inv_lot_sel_attr.lock_lot_records(p_org_id

2563: print_debug('before updating msi '||p_lot_prefix,9);
2564: END IF;
2565:
2566: /* Added for bug 8428348 */
2567: l_got_lock:= inv_lot_sel_attr.lock_lot_records(p_org_id
2568: , p_inventory_item_id
2569: , p_lot_uniqueness
2570: , p_lot_generation
2571: , p_lot_prefix

Line 3772: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,

3768: ***************************************************************************************/
3769: PROCEDURE get_lot_att_from_source (
3770: x_return_status OUT NOCOPY VARCHAR2,
3771: x_count OUT NOCOPY NUMBER,
3772: x_source_wms_lot_att_tbl OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type,
3773: x_source_non_wms_lot_att_rec OUT NOCOPY non_wms_lot_att_rec_type,
3774: p_from_organization_id IN NUMBER,
3775: p_inventory_item_id IN NUMBER,
3776: p_lot_number IN VARCHAR2,

Line 3778: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type

3774: p_from_organization_id IN NUMBER,
3775: p_inventory_item_id IN NUMBER,
3776: p_lot_number IN VARCHAR2,
3777: p_count IN NUMBER,
3778: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3779: )
3780: IS
3781: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3782: v_found BOOLEAN := FALSE;

Line 3781: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;

3777: p_count IN NUMBER,
3778: p_source_wms_lot_att_tbl IN inv_lot_sel_attr.lot_sel_attributes_tbl_type
3779: )
3780: IS
3781: temp_tbl inv_lot_sel_attr.lot_sel_attributes_tbl_type;
3782: v_found BOOLEAN := FALSE;
3783: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3784: BEGIN
3785: IF (l_debug = 1) THEN

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

5164: print_debug('Upd Lot Attr: WMS is installed ', 9);
5165: END IF;
5166:
5167: IF p_lot_rec.lot_attribute_category IS NULL THEN
5168: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');
5169: ELSE
5170: l_context := p_lot_rec.lot_attribute_category;
5171: END IF;
5172:

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

5385:
5386: l_context := NULL;
5387:
5388: IF p_lot_rec.lot_attribute_category IS NULL THEN
5389: inv_lot_sel_attr.get_context_code(l_context, p_lot_rec.organization_id, p_lot_rec.inventory_item_id, 'Lot Attributes');
5390: ELSE
5391: l_context := p_lot_rec.lot_attribute_category;
5392: END IF;
5393:

Line 7473: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;

7469: ) IS
7470: TYPE seg_name IS TABLE OF VARCHAR2(1000)
7471: INDEX BY BINARY_INTEGER;
7472:
7473: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7474: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7475: l_attributes_default_count NUMBER;
7476: l_c_attr_index NUMBER;
7477: l_n_attr_index NUMBER;

Line 7474: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;

7470: TYPE seg_name IS TABLE OF VARCHAR2(1000)
7471: INDEX BY BINARY_INTEGER;
7472:
7473: lot_dff inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7474: l_attributes_default inv_lot_sel_attr.lot_sel_attributes_tbl_type;
7475: l_attributes_default_count NUMBER;
7476: l_c_attr_index NUMBER;
7477: l_n_attr_index NUMBER;
7478: l_d_attr_index NUMBER;

Line 7884: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(

7880: IF g_debug = 1 THEN
7881: print_debug('After populating the lot_dff table with D_ATTRIBUTES', 9);
7882: END IF;
7883:
7884: l_enabled_attributes := INV_LOT_SEL_ATTR.is_enabled(
7885: p_flex_name => 'Lot Attributes'
7886: , p_organization_id => p_organization_id
7887: , p_inventory_item_id => p_inventory_item_id);
7888:

Line 7895: inv_lot_sel_attr.get_default (

7891: end if;
7892: /*
7893: * Get the default lot attribute values if any
7894: */
7895: inv_lot_sel_attr.get_default (
7896: x_attributes_default => l_attributes_default,
7897: x_attributes_default_count => l_attributes_default_count,
7898: x_return_status => l_return_status,
7899: x_msg_count => l_msg_count,

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

8028: print_debug('setting l_context = ' || p_lot_attribute_category, 9);
8029: l_context := p_lot_attribute_category;
8030: ELSE
8031: /*Get the context for the item passed */
8032: inv_lot_sel_attr.get_context_code(l_context, p_organization_id, p_inventory_item_id, 'Lot Attributes');
8033: END IF;
8034:
8035: IF l_context IS NULL AND l_required_flag = TRUE THEN
8036: fnd_message.set_name('WMS', 'WMS_NO_CONTEXT');