APPS.AP_POL_LOCATIONS_PKG dependencies on AP_POL_LOCATIONS_B

Line 135: delete from AP_POL_LOCATIONS_B

131: if (sql%notfound) then
132: raise no_data_found;
133: end if;
134:
135: delete from AP_POL_LOCATIONS_B
136: where LOCATION_ID = X_LOCATION_ID;
137:
138: if (sql%notfound) then
139: raise no_data_found;

Line 168: cursor C is select ROWID from AP_POL_LOCATIONS_B

164: X_LAST_UPDATE_LOGIN in NUMBER,
165: X_LANGUAGE in VARCHAR2,
166: X_SOURCE_LANG in VARCHAR2) is
167:
168: cursor C is select ROWID from AP_POL_LOCATIONS_B
169: where LOCATION_ID = X_LOCATION_ID;
170:
171: begin
172:

Line 173: insert into AP_POL_LOCATIONS_B (

169: where LOCATION_ID = X_LOCATION_ID;
170:
171: begin
172:
173: insert into AP_POL_LOCATIONS_B (
174: LOCATION_ID,
175: TERRITORY_CODE,
176: UNDEFINED_LOCATION_FLAG,
177: END_DATE,

Line 275: from AP_POL_LOCATIONS_B

271: COUNTRY,
272: STATE_PROVINCE_ID,
273: COUNTY_ID,
274: CITY_LOCALITY_ID
275: from AP_POL_LOCATIONS_B
276: where LOCATION_ID = X_LOCATION_ID
277: for update of LOCATION_ID nowait;
278: recinfo c%rowtype;
279:

Line 358: update AP_POL_LOCATIONS_B set

354: X_LAST_UPDATE_LOGIN in NUMBER,
355: X_LANGUAGE in VARCHAR2,
356: X_SOURCE_LANG in VARCHAR2) is
357: begin
358: update AP_POL_LOCATIONS_B set
359: TERRITORY_CODE = X_TERRITORY_CODE,
360: UNDEFINED_LOCATION_FLAG = X_UNDEFINED_LOCATION_FLAG,
361: END_DATE = X_END_DATE,
362: STATUS = X_STATUS,

Line 399: from AP_POL_LOCATIONS_B B

395: begin
396: delete from AP_POL_LOCATIONS_TL T
397: where not exists
398: (select NULL
399: from AP_POL_LOCATIONS_B B
400: where B.LOCATION_ID = T.LOCATION_ID
401: );
402:
403: update AP_POL_LOCATIONS_TL T set (