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.16.12020000.6 2013/01/08 08:28:05 xzhixong 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.16.12020000.6 2013/01/08 08:28:05 xzhixong 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 911: INV_LOT_SEL_ATTR.get_context_code(

907: -- Get Contexts
908: fnd_dflex.get_contexts(v_flexfield, v_contexts);
909:
910: -- Get attributes category
911: INV_LOT_SEL_ATTR.get_context_code(
912: context_value => v_attributes_category
913: , org_id => p_organization_id
914: , item_id => p_inventory_item_id
915: , flex_name => p_flex_name

Line 1016: l_column_attributes INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;

1012: l_rec_index BINARY_INTEGER := 0;
1013:
1014: l_count NUMBER;
1015: l_lot_serial_number VARCHAR2(240) := p_lot_serial_number;
1016: l_column_attributes INV_LOT_SEL_ATTR.LOT_SEL_ATTRIBUTES_TBL_TYPE;
1017: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug 6636904
1018: l_context_column_name VARCHAR2(240); --bug 2474713
1019: l_module_name VARCHAR2(25) := 'GET_ATTRIBUTE_VALUES';
1020: l_debug_level NUMBER := 9;

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

1063:
1064: BEGIN
1065:
1066: IF (l_debug = 1) THEN
1067: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);

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

1064: BEGIN
1065:
1066: IF (l_debug = 1) THEN
1067: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);

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

1065:
1066: IF (l_debug = 1) THEN
1067: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);

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

1066: IF (l_debug = 1) THEN
1067: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;

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

1067: inv_trx_util_pub.trace('inputs to get_attribute_values: ','INV_LOT_SEL_ATTR',9);
1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;
1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);

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

1068: inv_trx_util_pub.trace('p_table_name ' || p_table_name,'INV_LOT_SEL_ATTR',9);
1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;
1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1076: -- Get Contexts

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

1069: inv_trx_util_pub.trace('p_attributes_name '|| p_attributes_name,'INV_LOT_SEL_ATTR',9);
1070: inv_trx_util_pub.trace('p_inventory_item_id '||p_inventory_item_id,'INV_LOT_SEL_ATTR',9);
1071: inv_trx_util_pub.trace('p_organization_id '||p_organization_id,'INV_LOT_SEL_ATTR',9);
1072: inv_trx_util_pub.trace('p_lot_serial_number '||p_lot_serial_number,'INV_LOT_SEL_ATTR',9);
1073: inv_trx_util_pub.trace('p_issue_receipt '||p_issue_receipt,'INV_LOT_SEL_ATTR',9);
1074: END IF;
1075: fnd_dflex.get_flexfield('INV', p_attributes_name, l_flexfield, l_flexinfo);
1076: -- Get Contexts
1077: fnd_dflex.get_contexts(l_flexfield, l_contexts_info);

Line 1546: ,x_inv_lot_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

1542: /* New Procedure to get the Inventory Attributes */
1543: procedure get_inv_lot_attributes( x_return_status OUT NOCOPY VARCHAR2
1544: ,x_msg_count OUT NOCOPY NUMBER
1545: ,x_msg_data OUT NOCOPY VARCHAR2
1546: ,x_inv_lot_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
1547: ,P_inventory_item_id IN NUMBER
1548: ,P_LOT_NUMBER IN VARCHAR2
1549: ,p_organization_id IN NUMBER
1550: ,p_attribute_category IN VARCHAR2

Line 1671: ,x_inv_serial_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type

1667:
1668: procedure get_inv_serial_attributes( x_return_status OUT NOCOPY VARCHAR2
1669: ,x_msg_count OUT NOCOPY NUMBER
1670: ,x_msg_data OUT NOCOPY VARCHAR2
1671: ,x_inv_serial_attributes OUT NOCOPY inv_lot_sel_attr.lot_sel_attributes_tbl_type
1672: ,x_concatenated_values OUT NOCOPY VARCHAR2
1673: ,P_inventory_item_id IN NUMBER
1674: ,P_SERIAL_NUMBER IN VARCHAR2
1675: ,p_attribute_category IN VARCHAR2

Line 2286: END INV_LOT_SEL_ATTR;

2282:
2283: /* End of changes for bug 8428348 */
2284:
2285:
2286: END INV_LOT_SEL_ATTR;