APPS.RRS_SITE_INFO dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 512: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

508: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
509:
510: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
511: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
512: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
513: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
514: l_site_id NUMBER;
515: l_location_id NUMBER;
516:

Line 659: EGO_COL_NAME_VALUE_PAIR_ARRAY(

655: end if;
656:
657:
658: l_pk_column_values :=
659: EGO_COL_NAME_VALUE_PAIR_ARRAY(
660: EGO_COL_NAME_VALUE_PAIR_OBJ('SITE_ID', TO_CHAR(l_site_id)));
661:
662: l_object_name := 'RRS_SITE';
663: -- l_object_name := l_rrs_entity(k).lookup_code;

Line 790: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

786: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
787:
788: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
789: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
790: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
791: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
792: l_site_id NUMBER;
793: l_location_id NUMBER;
794:

Line 910: EGO_COL_NAME_VALUE_PAIR_ARRAY(

906: end if;
907:
908:
909: l_pk_column_values :=
910: EGO_COL_NAME_VALUE_PAIR_ARRAY(
911: EGO_COL_NAME_VALUE_PAIR_OBJ('LOCATION_ID', TO_CHAR(l_location_id)));
912:
913:
914: l_object_name := 'RRS_LOCATION';

Line 1011: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

1007: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
1008:
1009: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1010: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
1011: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
1012: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
1013: l_site_id NUMBER;
1014: l_location_id NUMBER;
1015:

Line 1187: EGO_COL_NAME_VALUE_PAIR_ARRAY(

1183:
1184:
1185: for p in l_trade_area_ids.First..l_trade_area_ids.Last Loop
1186: l_pk_column_values :=
1187: EGO_COL_NAME_VALUE_PAIR_ARRAY(
1188: EGO_COL_NAME_VALUE_PAIR_OBJ('TRADE_AREA_ID', TO_CHAR(l_trade_area_ids(p)))
1189: );
1190:
1191: EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data(