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.EGO_GTIN_ATTRS_PVT dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3604: AND eiuai.ORGANIZATION_ID = c_organization_id;
3605:
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;

Line 3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3605:
3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;
3613: l_msg_data VARCHAR2(4000);

Line 3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3606: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3607: l_attr_diffs EGO_USER_ATTR_DIFF_TABLE;
3608: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3609: l_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3610: l_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3611: l_return_status VARCHAR2(10);
3612: l_msg_count NUMBER;
3613: l_msg_data VARCHAR2(4000);
3614: BEGIN

Line 3671: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3667: END IF; -- end IF l_attribute_names.COUN
3668:
3669: IF l_attr_diffs.COUNT > 0 THEN
3670: Debug_Msg('Calling EGO_GTIN_PVT.Item_Propagate_Attributes');
3671: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))
3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))
3674: );
3675:

Line 3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))
3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))
3674: );
3675:
3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(i.ITEM_CATALOG_GROUP_ID)));
3678:
3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
3680:

Line 3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));

3675:
3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY
3677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(i.ITEM_CATALOG_GROUP_ID)));
3678:
3679: l_data_level_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('REVISION_ID', NULL));
3680:
3681: l_msg_data := NULL;
3682: EGO_GTIN_PVT.Item_Propagate_Attributes
3683: ( p_pk_column_name_value_pairs => l_pk_column_name_value_pairs

Line 3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,

3750:
3751: /*
3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,

Line 3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,

3751: /*
3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,
3759: p_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE,

Line 3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,

3752: */
3753: PROCEDURE Process_Multi_Row_AG(p_attr_group_name VARCHAR2,
3754: p_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3755: p_class_code_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3756: p_data_level_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY,
3757: p_extension_id NUMBER,
3758: p_transaction_type VARCHAR2,
3759: p_attr_name_value_pairs EGO_USER_ATTR_DATA_TABLE,
3760: x_return_status OUT NOCOPY VARCHAR2,

Line 3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3889: l_new_row BOOLEAN;
3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:

Line 3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3890: l_row_identifier NUMBER;
3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:
3898: TYPE t_col_list_type IS TABLE OF NUMBER INDEX BY VARCHAR2(100);

Line 3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;

3891: l_attribute_names EGO_VARCHAR_TBL_TYPE := EGO_VARCHAR_TBL_TYPE(null);
3892: l_trade_item_desc MTL_SYSTEM_ITEMS_B.TRADE_ITEM_DESCRIPTOR%TYPE;
3893: l_pk_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3894: l_cc_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3895: l_dl_column_name_value_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY;
3896: l_category_id NUMBER;
3897:
3898: TYPE t_col_list_type IS TABLE OF NUMBER INDEX BY VARCHAR2(100);
3899: l_multi_row_cols t_col_list_type;

Line 4037: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY( EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , TO_CHAR(p_inventory_item_id))

4033: FROM MTL_SYSTEM_ITEMS_B
4034: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
4035: AND ORGANIZATION_ID = p_organization_id;
4036:
4037: l_pk_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY( EGO_COL_NAME_VALUE_PAIR_OBJ( 'INVENTORY_ITEM_ID' , TO_CHAR(p_inventory_item_id))
4038: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , TO_CHAR(p_organization_id) ) );
4039:
4040: -- Bug: 5523366
4041: EGO_ITEM_PVT.Get_Related_Class_Codes(

Line 4045: l_cc_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

4041: EGO_ITEM_PVT.Get_Related_Class_Codes(
4042: p_classification_code => l_category_id
4043: , x_related_class_codes_list => l_related_class_codes_list );
4044:
4045: l_cc_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
4046: EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID' , TO_CHAR(l_category_id) )
4047: , EGO_COL_NAME_VALUE_PAIR_OBJ( 'RELATED_CLASS_CODE_LIST_1' , l_related_class_codes_list ));
4048:
4049: l_dl_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , NULL));

Line 4049: l_dl_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , NULL));

4045: l_cc_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
4046: EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID' , TO_CHAR(l_category_id) )
4047: , EGO_COL_NAME_VALUE_PAIR_OBJ( 'RELATED_CLASS_CODE_LIST_1' , l_related_class_codes_list ));
4048:
4049: l_dl_column_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ( 'REVISION_ID' , NULL));
4050:
4051: Debug_Msg('Checking the Trade Item Descriptor');
4052: BEGIN
4053: SELECT TRADE_ITEM_DESCRIPTOR INTO l_trade_item_desc