APPS.ITA_SETUP_INSTANCES_PKG dependencies on ITA_SETUP_INSTANCES_B

Line 21: insert into ITA_SETUP_INSTANCES_B (

17: X_LAST_UPDATED_BY in NUMBER,
18: X_LAST_UPDATE_LOGIN in NUMBER
19: ) is
20: begin
21: insert into ITA_SETUP_INSTANCES_B (
22: INSTANCE_CODE,
23: DBC_FILE_PATH,
24: DBC_FILE_NAME,
25: CURRENT_FLAG,

Line 102: from ITA_SETUP_INSTANCES_B

98: CURRENT_FLAG,
99: MASTER_FLAG,
100: SECURITY_GROUP_ID,
101: OBJECT_VERSION_NUMBER
102: from ITA_SETUP_INSTANCES_B
103: where INSTANCE_CODE = X_INSTANCE_CODE
104: for update of INSTANCE_CODE nowait;
105: recinfo c%rowtype;
106:

Line 174: update ITA_SETUP_INSTANCES_B set

170: X_LAST_UPDATED_BY in NUMBER,
171: X_LAST_UPDATE_LOGIN in NUMBER
172: ) is
173: begin
174: update ITA_SETUP_INSTANCES_B set
175: INSTANCE_CODE = X_INSTANCE_CODE,
176: DBC_FILE_PATH = X_DBC_FILE_PATH,
177: DBC_FILE_NAME = X_DBC_FILE_NAME,
178: MASTER_FLAG = X_MASTER_FLAG,

Line 218: delete from ITA_SETUP_INSTANCES_B

214: if (sql%notfound) then
215: raise no_data_found;
216: end if;
217:
218: delete from ITA_SETUP_INSTANCES_B
219: where INSTANCE_CODE = X_INSTANCE_CODE;
220:
221: if (sql%notfound) then
222: raise no_data_found;

Line 252: from ITA_SETUP_INSTANCES_B

248: -- Translate char last_update_date to date
249: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
250:
251: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
252: from ITA_SETUP_INSTANCES_B
253: where INSTANCE_CODE = X_INSTANCE_CODE;
254:
255: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate, X_CUSTOM_MODE))
256: then ITA_SETUP_INSTANCES_PKG.UPDATE_ROW (

Line 293: from ITA_SETUP_INSTANCES_B b

289: begin
290: delete from ITA_SETUP_INSTANCES_TL tl
291: where not exists (
292: select null
293: from ITA_SETUP_INSTANCES_B b
294: where b.INSTANCE_CODE = tl.INSTANCE_CODE
295: );
296:
297: update ITA_SETUP_INSTANCES_TL tl set (