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_OBJ

Line 3672: ( EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', TO_CHAR(i.INVENTORY_ITEM_ID))

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:
3676: l_class_code_name_value_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 3673: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', TO_CHAR(i.ORGANIZATION_ID))

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:
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)));

Line 3677: (EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', to_char(i.ITEM_CATALOG_GROUP_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:
3681: l_msg_data := NULL;

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 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 4038: ,EGO_COL_NAME_VALUE_PAIR_OBJ( 'ORGANIZATION_ID' , TO_CHAR(p_organization_id) ) );

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(
4042: p_classification_code => l_category_id

Line 4046: EGO_COL_NAME_VALUE_PAIR_OBJ( 'ITEM_CATALOG_GROUP_ID' , TO_CHAR(l_category_id) )

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));
4050:

Line 4047: , EGO_COL_NAME_VALUE_PAIR_OBJ( 'RELATED_CLASS_CODE_LIST_1' , l_related_class_codes_list ));

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));
4050:
4051: Debug_Msg('Checking the Trade Item Descriptor');

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