APPS.ITA_SETUP_REC_VALUES_PKG dependencies on ITA_SETUP_REC_VALUES_B

Line 153: insert into ITA_SETUP_REC_VALUES_B (

149: begin
150:
151: custom_debug('In to the INSERT_ROW X_PARAMETER_CODE ' || X_PARAMETER_CODE);
152:
153: insert into ITA_SETUP_REC_VALUES_B (
154: REC_VALUE_ID,
155: PARAMETER_CODE,
156: CONTEXT_ORG_ID,
157: CONTEXT_ORG_NAME,

Line 248: update ITA_SETUP_REC_VALUES_B set

244: X_PK2_VALUE in VARCHAR2,
245: X_REC_INTERFACE_ID NUMBER
246: ) is
247: begin
248: update ITA_SETUP_REC_VALUES_B set
249: REC_VALUE_ID = X_REC_VALUE_ID,
250: PARAMETER_CODE = X_PARAMETER_CODE,
251: CONTEXT_ORG_ID = X_CONTEXT_ORG_ID,
252: CONTEXT_ORG_NAME = X_CONTEXT_ORG_NAME,

Line 319: from ITA_SETUP_REC_VALUES_B

315: -- Translate char last_update_date to date
316: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
317:
318: select LAST_UPDATED_BY, LAST_UPDATE_DATE into db_luby, db_ludate
319: from ITA_SETUP_REC_VALUES_B
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))

Line 386: from ITA_SETUP_REC_VALUES_B

382: db_ludate date;
383:
384: begin
385: select REC_VALUE_ID, LAST_UPDATED_BY, LAST_UPDATE_DATE into db_rec_value_id, db_luby, db_ludate
386: from ITA_SETUP_REC_VALUES_B
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)

Line 434: from ITA_SETUP_REC_VALUES_B b

430: begin
431: delete from ITA_SETUP_REC_VALUES_TL tl
432: where not exists (
433: select null
434: from ITA_SETUP_REC_VALUES_B b
435: where
436: b.PARAMETER_CODE = tl.PARAMETER_CODE and
437: b.CONTEXT_ORG_NAME = tl.CONTEXT_ORG_NAME
438: );