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

Line 1: PACKAGE BODY INV_LOT_SEL_ATTR AS

1: PACKAGE BODY INV_LOT_SEL_ATTR AS
2: /* $Header: INVLSDFB.pls 120.8 2008/01/25 12:44:11 mporecha ship $ */
3:
4: /* Global constant holding package name */
5: g_pkg_name CONSTANT VARCHAR2(20) := 'INV_LOT_SEL_ATTR' ;

Line 5: g_pkg_name CONSTANT VARCHAR2(20) := 'INV_LOT_SEL_ATTR' ;

1: PACKAGE BODY INV_LOT_SEL_ATTR AS
2: /* $Header: INVLSDFB.pls 120.8 2008/01/25 12:44:11 mporecha ship $ */
3:
4: /* Global constant holding package name */
5: g_pkg_name CONSTANT VARCHAR2(20) := 'INV_LOT_SEL_ATTR' ;
6:
7: g_version_printed BOOLEAN := FALSE;
8:
9: PROCEDURE debug(

Line 894: INV_LOT_SEL_ATTR.get_context_code(

890: -- Get Contexts
891: fnd_dflex.get_contexts(v_flexfield, v_contexts);
892:
893: -- Get attributes category
894: INV_LOT_SEL_ATTR.get_context_code(
895: context_value => v_attributes_category
896: , org_id => p_organization_id
897: , item_id => p_inventory_item_id
898: , flex_name => p_flex_name

Line 997: l_column_attributes INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

993: l_rec_index BINARY_INTEGER := 0;
994:
995: l_count NUMBER;
996: l_lot_serial_number VARCHAR2(240) := p_lot_serial_number;
997: l_column_attributes INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
998: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug 6636904
999: l_context_column_name VARCHAR2(240); --bug 2474713
1000: l_module_name VARCHAR2(25) := 'GET_ATTRIBUTE_VALUES';
1001: l_debug_level NUMBER := 9;

Line 1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);

1019:
1020: BEGIN
1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);

Line 1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);

1020: BEGIN
1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);

Line 1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);

1021:
1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);

Line 1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);

1022: IF (l_debug = 1) THEN
1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;

Line 1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);

1023: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);

Line 1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);

1024: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1032: -- Get Contexts

Line 1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);

1025: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1026: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1027: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1028: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1029: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1030: END IF;
1031: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1032: -- Get Contexts
1033: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);

Line 1394: ,x_inv_lot_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

1390: /* New Procedure to get the Inventory Attributes */
1391: procedure get_inv_lot_attributes( x_return_status OUT NOCOPY VARCHAR2
1392: ,x_msg_count OUT NOCOPY NUMBER
1393: ,x_msg_data OUT NOCOPY VARCHAR2
1394: ,x_inv_lot_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
1395: ,P_inventory_item_id IN NUMBER
1396: ,P_LOT_NUMBER IN VARCHAR2
1397: ,p_organization_id IN NUMBER
1398: ,p_attribute_category IN VARCHAR2

Line 1519: ,x_inv_serial_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

1515:
1516: procedure get_inv_serial_attributes( x_return_status OUT NOCOPY VARCHAR2
1517: ,x_msg_count OUT NOCOPY NUMBER
1518: ,x_msg_data OUT NOCOPY VARCHAR2
1519: ,x_inv_serial_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
1520: ,x_concatenated_values OUT NOCOPY VARCHAR2
1521: ,P_inventory_item_id IN NUMBER
1522: ,P_SERIAL_NUMBER IN VARCHAR2
1523: ,p_attribute_category IN VARCHAR2

Line 1907: END INV_LOT_SEL_ATTR;

1903: fnd_msg_pub.count_and_get(p_encoded => FND_API.G_FALSE, p_count => x_msg_count, p_data => x_msg_data);
1904: END get_inv_serial_attributes;
1905:
1906:
1907: END INV_LOT_SEL_ATTR;