APPS.XNP_SV_STATUS_TYPES_PKG dependencies on XNP_SV_STATUS_TYPES_PKG

Line 1: package body XNP_SV_STATUS_TYPES_PKG as

1: package body XNP_SV_STATUS_TYPES_PKG as
2: /* $Header: XNPSTTPB.pls 120.2 2005/07/19 04:03:30 appldev ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in OUT NOCOPY VARCHAR2,
5: X_STATUS_TYPE_CODE in VARCHAR2,

Line 306: XNP_SV_STATUS_TYPES_PKG.UPDATE_ROW (

302: -- l_user_id := 1;
303: --END IF;
304: l_user_id := fnd_load_util.owner_id(X_OWNER);
305:
306: XNP_SV_STATUS_TYPES_PKG.UPDATE_ROW (
307: X_STATUS_TYPE_CODE => X_STATUS_TYPE_CODE,
308: X_PHASE_INDICATOR => X_PHASE_INDICATOR,
309: X_ACTIVE_FLAG => X_ACTIVE_FLAG,
310: X_INITIAL_FLAG => X_INITIAL_FLAG,

Line 320: XNP_SV_STATUS_TYPES_PKG.INSERT_ROW (

316: X_LAST_UPDATED_BY => l_user_id,
317: X_LAST_UPDATE_LOGIN => 0);
318: EXCEPTION
319: WHEN NO_DATA_FOUND THEN
320: XNP_SV_STATUS_TYPES_PKG.INSERT_ROW (
321: X_ROWID => l_row_id,
322: X_STATUS_TYPE_CODE => X_STATUS_TYPE_CODE,
323: X_PHASE_INDICATOR => X_PHASE_INDICATOR,
324: X_ACTIVE_FLAG => X_ACTIVE_FLAG,

Line 355: end XNP_SV_STATUS_TYPES_PKG;

351: last_update_login = 0
352: WHERE status_type_code = X_STATUS_TYPE_CODE
353: AND userenv('LANG') IN (language, source_lang);
354: END TRANSLATE_ROW;
355: end XNP_SV_STATUS_TYPES_PKG;