APPS.ITA_SETUP_GROUPS_PKG dependencies on ITA_SETUP_GROUPS_B

Line 21: cursor C is select ROWID from ITA_SETUP_GROUPS_B

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from ITA_SETUP_GROUPS_B
22: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
23: ;
24: begin
25: insert into ITA_SETUP_GROUPS_B (

Line 25: insert into ITA_SETUP_GROUPS_B (

21: cursor C is select ROWID from ITA_SETUP_GROUPS_B
22: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
23: ;
24: begin
25: insert into ITA_SETUP_GROUPS_B (
26: TABLE_ID,
27: TABLE_APP_ID,
28: CONTEXT_PARAMETER_CODE,
29: CONTEXT_PARAMETER_CODE2,

Line 118: from ITA_SETUP_GROUPS_B

114: HIERARCHY_LEVEL,
115: AUDIT_START_DATE,
116: AUDIT_END_DATE,
117: OBJECT_VERSION_NUMBER
118: from ITA_SETUP_GROUPS_B
119: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE
120: for update of SETUP_GROUP_CODE nowait;
121: recinfo c%rowtype;
122:

Line 195: update ITA_SETUP_GROUPS_B set

191: ) is
192: begin
193:
194: fnd_file.put_line(fnd_file.log,'SG_PKG.UR: ' || X_AUDIT_END_DATE);
195: update ITA_SETUP_GROUPS_B set
196: TABLE_ID = X_TABLE_ID,
197: TABLE_APP_ID = X_TABLE_APP_ID,
198: CONTEXT_PARAMETER_CODE = X_CONTEXT_PARAMETER_CODE,
199: CONTEXT_PARAMETER_CODE2 = X_CONTEXT_PARAMETER_CODE2,

Line 238: delete from ITA_SETUP_GROUPS_B

234: if (sql%notfound) then
235: raise no_data_found;
236: end if;
237:
238: delete from ITA_SETUP_GROUPS_B
239: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE;
240:
241: if (sql%notfound) then
242: raise no_data_found;

Line 252: from ITA_SETUP_GROUPS_B B

248: begin
249: delete from ITA_SETUP_GROUPS_TL T
250: where not exists
251: (select NULL
252: from ITA_SETUP_GROUPS_B B
253: where B.SETUP_GROUP_CODE = T.SETUP_GROUP_CODE
254: );
255:
256: update ITA_SETUP_GROUPS_TL T set (

Line 347: from ita_setup_groups_b

343: -- special handling for gl_sets_of_books and ce_system_parameters_all for R12 - bug 4958045
344: if (X_TABLE_NAME in ('GL_SETS_OF_BOOKS','CE_SYSTEM_PARAMETERS_ALL')) then
345: select table_id
346: into view_table_id
347: from ita_setup_groups_b
348: where setup_group_code = X_SETUP_GROUP_CODE
349: and table_app_id = view_appid;
350: else
351: select table_id

Line 368: from ITA_SETUP_GROUPS_B

364: select LAST_UPDATED_BY, LAST_UPDATE_DATE,
365: audit_start_date, audit_end_date -- should not be updated
366: into db_luby, db_ludate,
367: l_audit_start_date, l_audit_end_date
368: from ITA_SETUP_GROUPS_B
369: where SETUP_GROUP_CODE = X_SETUP_GROUP_CODE;
370:
371: -- Test for customization and version
372: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,