APPS.GCS_TREATMENTS_PKG dependencies on GCS_TREATMENTS_TL

Line 72: INSERT INTO gcs_treatments_TL

68: (SELECT 1
69: FROM gcs_treatments_b cb
70: WHERE cb.TREATMENT_ID= insert_row.TREATMENT_ID);
71:
72: INSERT INTO gcs_treatments_TL
73: (
74: TREATMENT_ID,
75: LANGUAGE,
76: SOURCE_LANG,

Line 100: FROM gcs_treatments_tl ctl

96:
97: FROM dual
98: WHERE NOT EXISTS
99: (SELECT 1
100: FROM gcs_treatments_tl ctl
101: WHERE ctl.TREATMENT_ID = insert_row.TREATMENT_ID
102: AND ctl.language = userenv('LANG'));
103:
104: OPEN treatment_row;

Line 161: GCS_TREATMENTS_TL

157: raise no_data_found;
158: END IF;
159:
160: INSERT INTO
161: GCS_TREATMENTS_TL
162: (
163: TREATMENT_ID,
164: LANGUAGE,
165: SOURCE_LANG,

Line 190: FROM GCS_TREATMENTS_TL ctl

186:
187: FROM dual
188: WHERE NOT EXISTS
189: (SELECT 1
190: FROM GCS_TREATMENTS_TL ctl
191: WHERE ctl.TREATMENT_ID = update_row.TREATMENT_ID
192: AND ctl.language = userenv('LANG'));
193:
194:

Line 196: UPDATE GCS_TREATMENTS_TL ctl

192: AND ctl.language = userenv('LANG'));
193:
194:
195:
196: UPDATE GCS_TREATMENTS_TL ctl
197: SET
198: LAST_UPDATE_DATE = update_row.LAST_UPDATE_DATE,
199: LAST_UPDATED_BY = update_row.LAST_UPDATED_BY,
200: CREATION_DATE = update_row.CREATION_DATE,

Line 331: FROM GCS_TREATMENTS_TL ctl

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

Line 339: GCS_TREATMENTS_TL ctl

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

Line 362: GCS_TREATMENTS_TL tt

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

Line 393: from GCS_TREATMENTS_TL B,

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

Line 397: ) v, GCS_TREATMENTS_TL t

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