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.PON_ATTR_MAPPING dependencies on EGO_COL_NAME_VALUE_PAIR_OBJ

Line 189: := EGO_COL_NAME_VALUE_PAIR_OBJ('CLASSIFICATION_CODE', return_code);

185: IF (return_code IS NOT NULL) THEN
186: p_class_code_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();
187: p_class_code_pairs.EXTEND();
188: p_class_code_pairs(p_class_code_pairs.LAST)
189: := EGO_COL_NAME_VALUE_PAIR_OBJ('CLASSIFICATION_CODE', return_code);
190: END IF;
191:
192: END Get_Supp_Related_Class_Codes;
193:

Line 220: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))

216: , NULL
217: , l_related_class_codes_list
218: );
219: p_class_code_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
220: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
221: , EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST', l_related_class_codes_list)
222: );
223: END IF;
224: END Get_Item_Related_Class_Codes;

Line 221: , EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST', l_related_class_codes_list)

217: , l_related_class_codes_list
218: );
219: p_class_code_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(
220: EGO_COL_NAME_VALUE_PAIR_OBJ('ITEM_CATALOG_GROUP_ID', TO_CHAR(l_item_catalog_group_id))
221: , EGO_COL_NAME_VALUE_PAIR_OBJ('RELATED_CLASS_CODE_LIST', l_related_class_codes_list)
222: );
223: END IF;
224: END Get_Item_Related_Class_Codes;
225:

Line 587: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', l_party_id));

583: l_object_id := EGO_EXT_FWK_PUB.Get_Object_Id_From_Name('HZ_PARTIES');
584: l_object_name := 'HZ_PARTIES';
585: l_application_id := 177;
586: l_attr_group_type := 'POS_SUPP_PROFMGMT_GROUP';
587: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PARTY_ID', l_party_id));
588: Get_Supp_Related_Class_Codes(l_vendor_id, l_party_id, l_object_id, l_data_level_name, supp_ag_dl_rec.attr_group_id, l_class_code_pairs);
589:
590: -- Bug 12815017
591: -- If l_class_code_pairs is null, it means that none of the

Line 600: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', 'N'));

596: -- Bug 16169826
597: -- Modified code to use IF stement instead of CONTINUE
598: IF (l_class_code_pairs IS NOT NULL) THEN
599:
600: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('IS_PROSPECT', 'N'));
601:
602: /* call ego api to sync data */
603: ego_user_attrs_data_pvt.Process_Row(
604: p_api_version => 1.0

Line 863: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)

859: l_object_name := 'EGO_ITEM';
860: l_application_id := 431;
861: l_attr_group_type := 'EGO_ITEMMGMT_GROUP';
862: IF (item_ag_dl_rec.data_level_id = 43103) THEN
863: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
864: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
865: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));
867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN

Line 864: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));

860: l_application_id := 431;
861: l_attr_group_type := 'EGO_ITEMMGMT_GROUP';
862: IF (item_ag_dl_rec.data_level_id = 43103) THEN
863: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
864: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
865: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));
867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN
868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)

Line 866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));

862: IF (item_ag_dl_rec.data_level_id = 43103) THEN
863: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
864: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
865: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));
867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN
868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);

Line 868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)

864: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
865: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));
867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN
868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));

Line 869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));

865: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
866: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id));
867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN
868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN

Line 871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)

867: ELSIF (item_ag_dl_rec.data_level_id = 43104) THEN
868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN
874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));

Line 872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));

868: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
869: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_org_id));
870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN
874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));
876: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);

Line 874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)

870: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN
874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));
876: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
877: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
878: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));

Line 875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));

871: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
872: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN
874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));
876: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
877: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
878: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
879: END IF;

Line 877: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)

873: ELSIF (item_ag_dl_rec.data_level_id = 43105) THEN
874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));
876: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
877: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
878: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
879: END IF;
880:
881: /* call ego api to sync data */

Line 878: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));

874: l_pk_column_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('INVENTORY_ITEM_ID', l_item_id)
875: , EGO_COL_NAME_VALUE_PAIR_OBJ('ORGANIZATION_ID', l_ship_to_org_id));
876: Get_Item_Related_Class_Codes(l_item_id, l_class_code_pairs);
877: l_data_level_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(EGO_COL_NAME_VALUE_PAIR_OBJ('PK1_VALUE', l_vendor_id)
878: , EGO_COL_NAME_VALUE_PAIR_OBJ('PK2_VALUE', l_vendor_site_id));
879: END IF;
880:
881: /* call ego api to sync data */
882: ego_user_attrs_data_pvt.Process_Row(