APPS.RRS_SITE_INFO dependencies on EGO_COL_NAME_VALUE_PAIR_ARRAY

Line 530: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

526: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
527:
528: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
529: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
530: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
531: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
532: l_site_id NUMBER;
533: l_location_id NUMBER;
534:

Line 677: EGO_COL_NAME_VALUE_PAIR_ARRAY(

673: end if;
674:
675:
676: l_pk_column_values :=
677: EGO_COL_NAME_VALUE_PAIR_ARRAY(
678: EGO_COL_NAME_VALUE_PAIR_OBJ('SITE_ID', TO_CHAR(l_site_id)));
679:
680: l_object_name := 'RRS_SITE';
681: -- l_object_name := l_rrs_entity(k).lookup_code;

Line 808: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

804: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
805:
806: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
807: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
808: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
809: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
810: l_site_id NUMBER;
811: l_location_id NUMBER;
812:

Line 928: EGO_COL_NAME_VALUE_PAIR_ARRAY(

924: end if;
925:
926:
927: l_pk_column_values :=
928: EGO_COL_NAME_VALUE_PAIR_ARRAY(
929: EGO_COL_NAME_VALUE_PAIR_OBJ('LOCATION_ID', TO_CHAR(l_location_id)));
930:
931:
932: l_object_name := 'RRS_LOCATION';

Line 1029: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;

1025: l_api_name CONSTANT VARCHAR2(30) := 'Get_User_Attrs_For_Item';
1026:
1027: l_request_table EGO_ATTR_GROUP_REQUEST_TABLE;
1028: l_current_data_obj EGO_USER_ATTR_DATA_OBJ;
1029: l_pk_column_values EGO_COL_NAME_VALUE_PAIR_ARRAY;
1030: l_user_privileges_on_object EGO_VARCHAR_TBL_TYPE;
1031: l_site_id NUMBER;
1032: l_location_id NUMBER;
1033:

Line 1205: EGO_COL_NAME_VALUE_PAIR_ARRAY(

1201:
1202:
1203: for p in l_trade_area_ids.First..l_trade_area_ids.Last Loop
1204: l_pk_column_values :=
1205: EGO_COL_NAME_VALUE_PAIR_ARRAY(
1206: EGO_COL_NAME_VALUE_PAIR_OBJ('TRADE_AREA_ID', TO_CHAR(l_trade_area_ids(p)))
1207: );
1208:
1209: EGO_USER_ATTRS_DATA_PUB.Get_User_Attrs_Data(