APPS.GCS_ELIM_RULES_PKG dependencies on GCS_ELIM_RULES_TL

Line 70: INSERT INTO gcs_elim_rules_tl

66: (SELECT 1
67: FROM gcs_elim_rules_b cb
68: WHERE cb.RULE_ID= insert_row.RULE_ID);
69:
70: INSERT INTO gcs_elim_rules_tl
71: (
72: RULE_ID,
73: LANGUAGE,
74: SOURCE_LANG,

Line 99: FROM gcs_elim_rules_tl ctl

95:
96: FROM dual
97: WHERE NOT EXISTS
98: (SELECT 1
99: FROM gcs_elim_rules_tl ctl
100: WHERE ctl.RULE_ID = insert_row.RULE_ID
101: AND ctl.language = userenv('LANG'));
102:
103: OPEN elimrules_row;

Line 159: gcs_elim_rules_tl

155: raise no_data_found;
156: END IF;
157:
158: INSERT INTO
159: gcs_elim_rules_tl
160: (
161: RULE_ID,
162: LANGUAGE,
163: SOURCE_LANG,

Line 187: FROM gcs_elim_rules_tl ctl

183:
184: FROM dual
185: WHERE NOT EXISTS
186: (SELECT 1
187: FROM gcs_elim_rules_tl ctl
188: WHERE ctl.RULE_ID = update_row.RULE_ID
189: AND ctl.language = userenv('LANG'));
190:
191:

Line 193: UPDATE gcs_elim_rules_tl ctl

189: AND ctl.language = userenv('LANG'));
190:
191:
192:
193: UPDATE gcs_elim_rules_tl ctl
194: SET
195: LAST_UPDATE_DATE = update_row.LAST_UPDATE_DATE,
196: LAST_UPDATED_BY = update_row.LAST_UPDATED_BY,
197: CREATION_DATE = update_row.CREATION_DATE,

Line 333: FROM gcs_elim_rules_tl ctl

329:
330: BEGIN
331: SELECT ctl.last_updated_by, ctl.last_update_date
332: INTO db_luby, db_ludate
333: FROM gcs_elim_rules_tl ctl
334: WHERE ctl.RULE_ID = translate_row.RULE_ID
335: AND ctl.language = userenv('LANG');
336:
337: -- Test for customization information

Line 341: gcs_elim_rules_tl ctl

337: -- Test for customization information
338: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
339: custom_mode) THEN
340: UPDATE
341: gcs_elim_rules_tl ctl
342: SET
343: SOURCE_LANG= userenv('LANG'),
344: RULE_ID=translate_row.RULE_ID,
345: LAST_UPDATE_DATE=f_ludate,

Line 363: gcs_elim_rules_tl tt

359: procedure ADD_LANGUAGE
360: is
361: begin
362: insert /*+ append parallel(tt) */ into
363: gcs_elim_rules_tl tt
364: (
365: RULE_ID,
366: LANGUAGE,
367: SOURCE_LANG,

Line 394: from gcs_elim_rules_tl B,

390: B.CREATED_BY,
391: B.LAST_UPDATE_LOGIN
392:
393:
394: from gcs_elim_rules_tl B,
395: FND_LANGUAGES L
396: where L.INSTALLED_FLAG in ('I', 'B')
397: and B.LANGUAGE = userenv('LANG')
398: ) v, gcs_elim_rules_tl t

Line 398: ) v, gcs_elim_rules_tl t

394: from gcs_elim_rules_tl B,
395: FND_LANGUAGES L
396: where L.INSTALLED_FLAG in ('I', 'B')
397: and B.LANGUAGE = userenv('LANG')
398: ) v, gcs_elim_rules_tl t
399: where T.RULE_ID(+) = v.RULE_ID
400: and T.LANGUAGE(+) = v.LANGUAGE_CODE
401: and t.RULE_ID IS NULL;
402: