DBA Data[Home] [Help]

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;