APPS.XNP_GEO_AREAS_PKG dependencies on XNP_GEO_AREAS_B

Line 17: cursor C is select ROWID from XNP_GEO_AREAS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from XNP_GEO_AREAS_B
18: where GEO_AREA_ID = X_GEO_AREA_ID
19: ;
20: begin
21: insert into XNP_GEO_AREAS_B (

Line 21: insert into XNP_GEO_AREAS_B (

17: cursor C is select ROWID from XNP_GEO_AREAS_B
18: where GEO_AREA_ID = X_GEO_AREA_ID
19: ;
20: begin
21: insert into XNP_GEO_AREAS_B (
22: GEO_AREA_ID,
23: GEO_AREA_TYPE_CODE,
24: CODE,
25: ACTIVE_FLAG,

Line 95: from XNP_GEO_AREAS_B

91: cursor c is select
92: GEO_AREA_TYPE_CODE,
93: CODE,
94: ACTIVE_FLAG
95: from XNP_GEO_AREAS_B
96: where GEO_AREA_ID = X_GEO_AREA_ID
97: for update of GEO_AREA_ID nowait;
98: recinfo c%rowtype;
99:

Line 155: update XNP_GEO_AREAS_B set

151: X_LAST_UPDATED_BY in NUMBER,
152: X_LAST_UPDATE_LOGIN in NUMBER
153: ) is
154: begin
155: update XNP_GEO_AREAS_B set
156: GEO_AREA_TYPE_CODE = X_GEO_AREA_TYPE_CODE,
157: CODE = X_CODE,
158: ACTIVE_FLAG = X_ACTIVE_FLAG,
159: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 194: delete from XNP_GEO_AREAS_B

190: if (sql%notfound) then
191: raise no_data_found;
192: end if;
193:
194: delete from XNP_GEO_AREAS_B
195: where GEO_AREA_ID = X_GEO_AREA_ID;
196:
197: if (sql%notfound) then
198: raise no_data_found;

Line 208: from XNP_GEO_AREAS_B B

204: begin
205: delete from XNP_GEO_AREAS_TL T
206: where not exists
207: (select NULL
208: from XNP_GEO_AREAS_B B
209: where B.GEO_AREA_ID = T.GEO_AREA_ID
210: );
211:
212: update XNP_GEO_AREAS_TL T set (

Line 284: FROM xnp_geo_areas_b

280: -- BUG FIX 1647105
281: -- Cannot assume the gea_area_id for WORLD will be 0
282: -- IF X_CODE <> 'WORLD' THEN
283: SELECT geo_area_id INTO l_geo_area_id
284: FROM xnp_geo_areas_b
285: WHERE geo_area_type_code = X_GEO_AREA_TYPE_CODE
286: AND code = X_CODE;
287: -- ELSE
288: -- l_geo_area_id := 0;

Line 315: SELECT XNP_GEO_AREAS_B_S.NEXTVAL

311: DECLARE
312: l_geo_area_id NUMBER;
313: BEGIN
314: IF X_CODE <> 'WORLD' THEN
315: SELECT XNP_GEO_AREAS_B_S.NEXTVAL
316: INTO l_geo_area_id
317: FROM dual;
318: ELSE
319: l_geo_area_id := 0;

Line 350: FROM xnp_geo_areas_b

346: -- BUG FIX 1647105
347: -- Cannot assume the gea_area_id for WORLD will be 0
348: -- IF X_CODE <> 'WORLD' THEN
349: SELECT geo_area_id INTO l_geo_area_id
350: FROM xnp_geo_areas_b
351: WHERE geo_area_type_code = X_GEO_AREA_TYPE_CODE
352: AND code = X_CODE;
353: -- ELSE
354: -- l_geo_area_id := 0;