APPS.GCS_ELIM_RULE_STEPS_PKG dependencies on GCS_ELIM_RULE_STEPS_TL

Line 71: INSERT INTO gcs_elim_rule_steps_tl

67: FROM gcs_elim_rule_steps_b cb
68: WHERE cb.RULE_STEP_ID= insert_row.RULE_STEP_ID
69: );
70:
71: INSERT INTO gcs_elim_rule_steps_tl
72: (
73: LANGUAGE,
74: SOURCE_LANG,
75: STEP_NAME,

Line 97: FROM gcs_elim_rule_steps_tl ctl

93:
94: FROM dual
95: WHERE NOT EXISTS
96: (SELECT 1
97: FROM gcs_elim_rule_steps_tl ctl
98: WHERE ctl.RULE_STEP_ID = insert_row.RULE_STEP_ID
99: AND ctl.language = userenv('LANG'));
100:
101: OPEN elimrulesteps_row;

Line 157: gcs_elim_rule_steps_tl

153: END IF;
154:
155:
156: INSERT INTO
157: gcs_elim_rule_steps_tl
158: (
159: RULE_STEP_ID,
160: LANGUAGE,
161: SOURCE_LANG,

Line 183: FROM gcs_elim_rule_steps_tl ctl

179:
180: FROM dual
181: WHERE NOT EXISTS
182: (SELECT 1
183: FROM gcs_elim_rule_steps_tl ctl
184: WHERE ctl.RULE_STEP_ID = update_row.RULE_STEP_ID
185: AND ctl.language = userenv('LANG'));
186:
187:

Line 189: UPDATE gcs_elim_rule_steps_tl ctl

185: AND ctl.language = userenv('LANG'));
186:
187:
188:
189: UPDATE gcs_elim_rule_steps_tl ctl
190: SET
191: LAST_UPDATE_DATE = update_row.LAST_UPDATE_DATE,
192: LAST_UPDATED_BY = update_row.LAST_UPDATED_BY,
193: LAST_UPDATE_LOGIN = update_row.LAST_UPDATE_LOGIN

Line 239: FROM gcs_elim_rule_steps_TL cb

235:
236: BEGIN
237: SELECT cb.last_updated_by, cb.last_update_date
238: INTO db_luby, db_ludate
239: FROM gcs_elim_rule_steps_TL cb
240: WHERE cb.RULE_STEP_ID = load_row.RULE_STEP_ID;
241:
242: -- Test for customization information
243: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,custom_mode)

Line 314: FROM gcs_elim_rule_steps_TL ctl

310:
311: BEGIN
312: SELECT ctl.last_updated_by, ctl.last_update_date
313: INTO db_luby, db_ludate
314: FROM gcs_elim_rule_steps_TL ctl
315: WHERE ctl.RULE_STEP_ID = translate_row.RULE_STEP_ID
316: AND ctl.language = userenv('LANG');
317:
318: -- Test for customization information

Line 322: gcs_elim_rule_steps_TL ctl

318: -- Test for customization information
319: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
320: custom_mode) THEN
321: UPDATE
322: gcs_elim_rule_steps_TL ctl
323: SET
324: STEP_NAME=translate_row.STEP_NAME,
325: LAST_UPDATE_DATE=f_ludate,
326: LAST_UPDATED_BY=f_luby,

Line 344: gcs_elim_rule_steps_TL tt

340: procedure ADD_LANGUAGE
341: is
342: begin
343: insert /*+ append parallel(tt) */ into
344: gcs_elim_rule_steps_TL tt
345: (
346: LANGUAGE,
347: SOURCE_LANG ,
348: STEP_NAME ,

Line 372: from gcs_elim_rule_steps_TL B,

368: B.LAST_UPDATE_LOGIN ,
369: B.RULE_STEP_ID
370:
371:
372: from gcs_elim_rule_steps_TL B,
373: FND_LANGUAGES L
374: where L.INSTALLED_FLAG in ('I', 'B')
375: and B.LANGUAGE = userenv('LANG')
376: ) v, gcs_elim_rule_steps_TL t

Line 376: ) v, gcs_elim_rule_steps_TL t

372: from gcs_elim_rule_steps_TL B,
373: FND_LANGUAGES L
374: where L.INSTALLED_FLAG in ('I', 'B')
375: and B.LANGUAGE = userenv('LANG')
376: ) v, gcs_elim_rule_steps_TL t
377: where T.RULE_STEP_ID(+) = v.RULE_STEP_ID
378: and T.LANGUAGE(+) = v.LANGUAGE_CODE
379: and t.RULE_STEP_ID IS NULL;
380: