APPS.XNP_GEO_AREAS_PKG dependencies on XNP_GEO_AREAS_B_S

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 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;