APPS.CSF_TDS_PUB dependencies on CSF_SPATIAL_CTRY_MAPPINGS

Line 138: type mdsListType is table of csf_spatial_ctry_mappings.SPATIAL_DATASET%type;

134: multiDataSetProfileValue VARCHAR2(10);
135: x_status boolean;
136:
137: multiDataSetProfileEnabled VARCHAR2(2);
138: type mdsListType is table of csf_spatial_ctry_mappings.SPATIAL_DATASET%type;
139: mdsList mdsListType;
140: BEGIN
141: status := 1;
142: msg := 'SUCCESS';

Line 160: select distinct SPATIAL_DATASET bulk collect into mdsList from csf_spatial_ctry_mappings;

156: THEN
157: select '' SPATIAL_DATASET bulk collect into mdsList from dual;
158: ELSIF UPPER(multiDataSetProfileEnabled) = 'Y'
159: THEN
160: select distinct SPATIAL_DATASET bulk collect into mdsList from csf_spatial_ctry_mappings;
161: END IF;
162:
163: --Loop though all the data set
164: FOR i IN mdsList.first .. mdsList.last loop