DBA Data[Home] [Help]

APPS.XNP_GEO_AREAS_PKG dependencies on XNP_GEO_AREAS_PKG

Line 1: package body XNP_GEO_AREAS_PKG as

1: package body XNP_GEO_AREAS_PKG as
2: /* $Header: XNPGEOAB.pls 120.3 2006/02/13 07:49:44 dputhiye ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_GEO_AREA_ID in NUMBER,

Line 299: XNP_GEO_AREAS_PKG.UPDATE_ROW (

295: --END IF;
296: l_user_id := fnd_load_util.owner_id(X_OWNER);
297:
298:
299: XNP_GEO_AREAS_PKG.UPDATE_ROW (
300: X_GEO_AREA_ID => l_geo_area_id,
301: X_GEO_AREA_TYPE_CODE => X_GEO_AREA_TYPE_CODE,
302: X_CODE => X_CODE,
303: X_ACTIVE_FLAG => X_ACTIVE_FLAG,

Line 321: XNP_GEO_AREAS_PKG.INSERT_ROW (

317: FROM dual;
318: ELSE
319: l_geo_area_id := 0;
320: END IF;
321: XNP_GEO_AREAS_PKG.INSERT_ROW (
322: X_ROWID => l_row_id,
323: X_GEO_AREA_ID => l_geo_area_id,
324: X_GEO_AREA_TYPE_CODE => X_GEO_AREA_TYPE_CODE,
325: X_CODE => X_CODE,

Line 369: end XNP_GEO_AREAS_PKG;

365: last_update_login = 0
366: WHERE geo_area_id = l_geo_area_id
367: AND userenv('LANG') IN (language, source_lang);
368: END TRANSLATE_ROW;
369: end XNP_GEO_AREAS_PKG;