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_ARRAY

Line 9: , p_class_code_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

5: , p_party_id IN NUMBER
6: , p_object_id IN NUMBER
7: , p_data_level_name IN VARCHAR2
8: , p_attr_group_id IN NUMBER
9: , p_class_code_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
10: ) AS
11:
12: class_code VARCHAR2(3000) := NULL;
13: scheme_code VARCHAR2(5) := NULL;

Line 186: p_class_code_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY();

182: END CASE;
183: END LOOP;
184:
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;

Line 196: , p_class_code_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY

192: END Get_Supp_Related_Class_Codes;
193:
194: PROCEDURE Get_Item_Related_Class_Codes (
195: p_item_id IN NUMBER
196: , p_class_code_pairs IN OUT NOCOPY EGO_COL_NAME_VALUE_PAIR_ARRAY
197: ) AS
198: l_related_class_codes_list VARCHAR2(150) := NULL;
199: l_item_catalog_group_id NUMBER := NULL;
200: BEGIN

Line 219: p_class_code_pairs := EGO_COL_NAME_VALUE_PAIR_ARRAY(

215: , NULL
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;

Line 286: l_pk_column_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;

282: l_user_data_level_name VARCHAR2(240) := NULL;
283:
284: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE := NULL;
285: l_current_data_element EGO_USER_ATTR_DATA_OBJ := NULL;
286: l_pk_column_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
287: l_class_code_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
288: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
289:
290: CURSOR supp_ag_dl_cursor(p_header_id IN NUMBER)

Line 287: l_class_code_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;

283:
284: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE := NULL;
285: l_current_data_element EGO_USER_ATTR_DATA_OBJ := NULL;
286: l_pk_column_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
287: l_class_code_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
288: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
289:
290: CURSOR supp_ag_dl_cursor(p_header_id IN NUMBER)
291: IS

Line 288: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;

284: l_row_attrs_table EGO_USER_ATTR_DATA_TABLE := NULL;
285: l_current_data_element EGO_USER_ATTR_DATA_OBJ := NULL;
286: l_pk_column_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
287: l_class_code_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
288: l_data_level_pairs EGO_COL_NAME_VALUE_PAIR_ARRAY := NULL;
289:
290: CURSOR supp_ag_dl_cursor(p_header_id IN NUMBER)
291: IS
292: SELECT DISTINCT

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 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 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 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 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 */