APPS.ITA_SETUP_PARAMETERS_PKG dependencies on ITA_SETUP_PARAMETERS_B

Line 29: cursor C is select ROWID from ITA_SETUP_PARAMETERS_B

25: X_LAST_UPDATE_LOGIN in NUMBER,
26: X_COLUMN_REFERENCE1 in VARCHAR2,
27: X_COLUMN_REFERENCE2 in VARCHAR2
28: ) is
29: cursor C is select ROWID from ITA_SETUP_PARAMETERS_B
30: where PARAMETER_CODE = X_PARAMETER_CODE
31: ;
32: begin
33: insert into ITA_SETUP_PARAMETERS_B (

Line 33: insert into ITA_SETUP_PARAMETERS_B (

29: cursor C is select ROWID from ITA_SETUP_PARAMETERS_B
30: where PARAMETER_CODE = X_PARAMETER_CODE
31: ;
32: begin
33: insert into ITA_SETUP_PARAMETERS_B (
34: SELECT_CLAUSE,
35: FROM_CLAUSE,
36: WHERE_CLAUSE,
37: END_DATE,

Line 158: from ITA_SETUP_PARAMETERS_B

154: COLUMN_ID,
155: CONTEXT_PREDICATE_FLAG,
156: COLUMN_REFERENCE1,
157: COLUMN_REFERENCE2
158: from ITA_SETUP_PARAMETERS_B
159: where PARAMETER_CODE = X_PARAMETER_CODE
160: for update of PARAMETER_CODE nowait;
161: recinfo c%rowtype;
162:

Line 258: update ITA_SETUP_PARAMETERS_B set

254: X_COLUMN_REFERENCE1 in VARCHAR2,
255: X_COLUMN_REFERENCE2 in VARCHAR2
256: ) is
257: begin
258: update ITA_SETUP_PARAMETERS_B set
259: SELECT_CLAUSE = X_SELECT_CLAUSE,
260: FROM_CLAUSE = X_FROM_CLAUSE,
261: WHERE_CLAUSE = X_WHERE_CLAUSE,
262: END_DATE = nvl(END_DATE, X_END_DATE),

Line 309: delete from ITA_SETUP_PARAMETERS_B

305: if (sql%notfound) then
306: raise no_data_found;
307: end if;
308:
309: delete from ITA_SETUP_PARAMETERS_B
310: where PARAMETER_CODE = X_PARAMETER_CODE;
311:
312: if (sql%notfound) then
313: raise no_data_found;

Line 323: from ITA_SETUP_PARAMETERS_B B

319: begin
320: delete from ITA_SETUP_PARAMETERS_TL T
321: where not exists
322: (select NULL
323: from ITA_SETUP_PARAMETERS_B B
324: where B.PARAMETER_CODE = T.PARAMETER_CODE
325: );
326:
327: update ITA_SETUP_PARAMETERS_TL T set (

Line 444: from ITA_SETUP_PARAMETERS_B

440:
441:
442: select LAST_UPDATED_BY, LAST_UPDATE_DATE
443: into db_luby, db_ludate
444: from ITA_SETUP_PARAMETERS_B
445: where parameter_code = X_parameter_code;
446:
447:
448:

Line 481: -- Inserting records into the ITA_SETUP_PARAMETERS_B and ITA_SETUP_PARAMETERS_TL

477: end if;
478: exception
479: when no_data_found then
480: -- Record doesn't exist - insert in all cases
481: -- Inserting records into the ITA_SETUP_PARAMETERS_B and ITA_SETUP_PARAMETERS_TL
482: -- in and only if the parameter is part of the schema.
483: if flag = 'Y' then
484: ITA_SETUP_PARAMETERS_PKG.INSERT_ROW(
485: X_ROWID => ROW_ID,