DBA Data[Home] [Help]

APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_SETUP_REC_VALUES_PKG

Line 1: package body ITA_SETUP_REC_VALUES_PKG as

1: package body ITA_SETUP_REC_VALUES_PKG as
2: /* $Header: itatrevb.pls 120.12.12000000.2 2007/10/09 11:06:58 shelango ship $ */
3: --
4: -- ************************************************************************/
5: -- ** PROCEDURE - custom_debug takes message as a parameter and the message can */

Line 324: then ITA_SETUP_REC_VALUES_PKG.UPDATE_ROW (

320: where REC_VALUE_ID = X_REC_VALUE_ID or
321: (PARAMETER_CODE = X_PARAMETER_CODE and CONTEXT_ORG_NAME = X_CONTEXT_ORG_NAME);
322:
323: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
324: then ITA_SETUP_REC_VALUES_PKG.UPDATE_ROW (
325: X_REC_VALUE_ID => X_REC_VALUE_ID,
326: X_PARAMETER_CODE => X_PARAMETER_CODE,
327: X_CONTEXT_ORG_ID => X_CONTEXT_ORG_ID,
328: X_CONTEXT_ORG_NAME => X_CONTEXT_ORG_NAME,

Line 341: then ITA_SETUP_REC_VALUES_PKG.INSERT_ROW (

337: X_PK2_VALUE => X_PK2_VALUE,
338: X_REC_INTERFACE_ID => X_REC_INTERFACE_ID);
339: end if;
340: exception when NO_DATA_FOUND
341: then ITA_SETUP_REC_VALUES_PKG.INSERT_ROW (
342: X_REC_VALUE_ID => X_REC_VALUE_ID,
343: X_PARAMETER_CODE => X_PARAMETER_CODE,
344: X_CONTEXT_ORG_ID => X_CONTEXT_ORG_ID,
345: X_CONTEXT_ORG_NAME => X_CONTEXT_ORG_NAME,

Line 391: then ITA_SETUP_REC_VALUES_PKG.UPDATE_ROW (

387: where REC_VALUE_ID = X_REC_VALUE_ID or
388: (PARAMETER_CODE = X_PARAMETER_CODE and CONTEXT_ORG_NAME = X_CONTEXT_ORG_NAME);
389:
390: if (db_luby is not null and db_ludate is not null)
391: then ITA_SETUP_REC_VALUES_PKG.UPDATE_ROW (
392: X_REC_VALUE_ID => db_rec_value_id,
393: X_PARAMETER_CODE => X_PARAMETER_CODE,
394: X_CONTEXT_ORG_ID => X_CONTEXT_ORG_ID,
395: X_CONTEXT_ORG_NAME => X_CONTEXT_ORG_NAME,

Line 408: then ITA_SETUP_REC_VALUES_PKG.INSERT_ROW (

404: X_PK2_VALUE => X_PK2_VALUE,
405: X_REC_INTERFACE_ID => X_REC_INTERFACE_ID);
406: end if;
407: exception when NO_DATA_FOUND
408: then ITA_SETUP_REC_VALUES_PKG.INSERT_ROW (
409: X_REC_VALUE_ID => X_REC_VALUE_ID,
410: X_PARAMETER_CODE => X_PARAMETER_CODE,
411: X_CONTEXT_ORG_ID => X_CONTEXT_ORG_ID,
412: X_CONTEXT_ORG_NAME => X_CONTEXT_ORG_NAME,

Line 927: end ITA_SETUP_REC_VALUES_PKG;

923: return null;
924: END getRecValueMeaning;
925:
926:
927: end ITA_SETUP_REC_VALUES_PKG;