APPS.ITA_SETUP_PARAMETER_MIG_PKG dependencies on ITA_SETUP_PARAMETER_MIG

Line 1: package body ITA_SETUP_PARAMETER_MIG_PKG as

1: package body ITA_SETUP_PARAMETER_MIG_PKG as
2: /* $Header: itatmigb.pls 120.1 2005/09/19 17:08:36 cpetriuc noship $ */
3:
4:
5: procedure INSERT_ROW (

Line 20: insert into ITA_SETUP_PARAMETER_MIG (

16: X_LAST_UPDATED_BY in NUMBER,
17: X_LAST_UPDATE_LOGIN in NUMBER
18: ) is
19: begin
20: insert into ITA_SETUP_PARAMETER_MIG (
21: MIGRATION_ID,
22: OLD_PARAMETER_CODE,
23: NEW_PARAMETER_CODE,
24: START_DATE,

Line 67: from ITA_SETUP_PARAMETER_MIG

63: START_DATE,
64: END_DATE,
65: SECURITY_GROUP_ID,
66: OBJECT_VERSION_NUMBER
67: from ITA_SETUP_PARAMETER_MIG
68: where MIGRATION_ID = X_MIGRATION_ID
69: for update of MIGRATION_ID nowait;
70: recinfo c%rowtype;
71:

Line 118: update ITA_SETUP_PARAMETER_MIG set

114: X_LAST_UPDATED_BY in NUMBER,
115: X_LAST_UPDATE_LOGIN in NUMBER
116: ) is
117: begin
118: update ITA_SETUP_PARAMETER_MIG set
119: OLD_PARAMETER_CODE = X_OLD_PARAMETER_CODE,
120: NEW_PARAMETER_CODE = X_NEW_PARAMETER_CODE,
121: START_DATE = nvl(START_DATE, X_START_DATE),
122: END_DATE = nvl(END_DATE, X_END_DATE),

Line 141: delete from ITA_SETUP_PARAMETER_MIG

137: procedure DELETE_ROW (
138: X_MIGRATION_ID in NUMBER
139: ) is
140: begin
141: delete from ITA_SETUP_PARAMETER_MIG
142: where MIGRATION_ID = X_MIGRATION_ID;
143:
144: if (sql%notfound) then
145: raise no_data_found;

Line 174: from ITA_SETUP_PARAMETER_MIG

170: -- Translate char last_update_date to date
171: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
172:
173: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
174: from ITA_SETUP_PARAMETER_MIG
175: where MIGRATION_ID = X_MIGRATION_ID;
176:
177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
178: then ITA_SETUP_PARAMETER_MIG_PKG.UPDATE_ROW (

Line 178: then ITA_SETUP_PARAMETER_MIG_PKG.UPDATE_ROW (

174: from ITA_SETUP_PARAMETER_MIG
175: where MIGRATION_ID = X_MIGRATION_ID;
176:
177: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
178: then ITA_SETUP_PARAMETER_MIG_PKG.UPDATE_ROW (
179: X_MIGRATION_ID => X_MIGRATION_ID,
180: X_OLD_PARAMETER_CODE => X_OLD_PARAMETER_CODE,
181: X_NEW_PARAMETER_CODE => X_NEW_PARAMETER_CODE,
182: X_START_DATE => X_START_DATE,

Line 191: then ITA_SETUP_PARAMETER_MIG_PKG.INSERT_ROW (

187: X_LAST_UPDATED_BY => f_luby,
188: X_LAST_UPDATE_LOGIN => 0);
189: end if;
190: exception when NO_DATA_FOUND
191: then ITA_SETUP_PARAMETER_MIG_PKG.INSERT_ROW (
192: X_MIGRATION_ID => X_MIGRATION_ID,
193: X_OLD_PARAMETER_CODE => X_OLD_PARAMETER_CODE,
194: X_NEW_PARAMETER_CODE => X_NEW_PARAMETER_CODE,
195: X_START_DATE => X_START_DATE,

Line 207: end ITA_SETUP_PARAMETER_MIG_PKG;

203: X_LAST_UPDATE_LOGIN => 0);
204: end LOAD_ROW;
205:
206:
207: end ITA_SETUP_PARAMETER_MIG_PKG;