APPS.GCS_CURR_TREATMENTS_PKG dependencies on GCS_CURR_TREATMENTS_TL

Line 125: INSERT INTO gcs_curr_treatments_tl

121: (SELECT 1
122: FROM gcs_curr_treatments_b cb
123: WHERE cb.CURR_TREATMENT_ID= insert_row.CURR_TREATMENT_ID);
124:
125: INSERT INTO gcs_curr_treatments_tl
126: (
127: CURR_TREATMENT_ID,
128: LANGUAGE,
129: SOURCE_LANG,

Line 152: FROM gcs_curr_treatments_tl ctl

148: DESCRIPTION
149: FROM dual
150: WHERE NOT EXISTS
151: (SELECT 1
152: FROM gcs_curr_treatments_tl ctl
153: WHERE ctl.CURR_TREATMENT_ID = insert_row.CURR_TREATMENT_ID
154: AND ctl.language = userenv('LANG'));
155:
156: OPEN curtreat_row;

Line 249: GCS_CURR_TREATMENTS_TL

245: raise no_data_found;
246: END IF;
247:
248: INSERT INTO
249: GCS_CURR_TREATMENTS_TL
250: (
251: CURR_TREATMENT_ID,
252: LANGUAGE,
253: SOURCE_LANG,

Line 277: FROM GCS_CURR_TREATMENTS_TL ctl

273: FROM dual
274: WHERE NOT EXISTS
275: (
276: SELECT 1
277: FROM GCS_CURR_TREATMENTS_TL ctl
278: WHERE ctl.CURR_TREATMENT_ID = update_row.CURR_TREATMENT_ID
279: AND ctl.language = userenv('LANG')
280: );
281:

Line 284: UPDATE GCS_CURR_TREATMENTS_TL ctl

280: );
281:
282:
283:
284: UPDATE GCS_CURR_TREATMENTS_TL ctl
285: SET
286: CURR_TREATMENT_NAME = update_row.CURR_TREATMENT_NAME,
287: LAST_UPDATE_DATE = update_row.LAST_UPDATE_DATE,
288: LAST_UPDATED_BY = update_row.LAST_UPDATED_BY,

Line 476: FROM GCS_CURR_TREATMENTS_TL ctl

472:
473: BEGIN
474: SELECT ctl.last_updated_by, ctl.last_update_date
475: INTO db_luby, db_ludate
476: FROM GCS_CURR_TREATMENTS_TL ctl
477: WHERE ctl.CURR_TREATMENT_ID = translate_row.CURR_TREATMENT_ID
478: AND ctl.language = userenv('LANG');
479:
480: -- Test for customization information

Line 484: GCS_CURR_TREATMENTS_TL ctl

480: -- Test for customization information
481: IF fnd_load_util.upload_test(f_luby, f_ludate, db_luby, db_ludate,
482: custom_mode) THEN
483: UPDATE
484: GCS_CURR_TREATMENTS_TL ctl
485: SET
486: LANGUAGE=userenv('LANG'),
487: SOURCE_LANG= userenv('LANG'),
488: CURR_TREATMENT_NAME=translate_row.CURR_TREATMENT_NAME,

Line 510: gcs_curr_treatments_tl tt

506: procedure ADD_LANGUAGE
507: is
508: begin
509: insert /*+ append parallel(tt) */ into
510: gcs_curr_treatments_tl tt
511: (
512: CURR_TREATMENT_ID,
513: LANGUAGE ,
514: SOURCE_LANG ,

Line 540: from gcs_curr_treatments_tl B,

536: B.LAST_UPDATE_LOGIN,
537: B.DESCRIPTION
538:
539:
540: from gcs_curr_treatments_tl B,
541: FND_LANGUAGES L
542: where L.INSTALLED_FLAG in ('I', 'B')
543: and B.LANGUAGE = userenv('LANG')
544: ) v, gcs_curr_treatments_tl t

Line 544: ) v, gcs_curr_treatments_tl t

540: from gcs_curr_treatments_tl B,
541: FND_LANGUAGES L
542: where L.INSTALLED_FLAG in ('I', 'B')
543: and B.LANGUAGE = userenv('LANG')
544: ) v, gcs_curr_treatments_tl t
545: where T.CURR_TREATMENT_ID(+) = v.CURR_TREATMENT_ID
546: and T.LANGUAGE(+) = v.LANGUAGE_CODE
547: and t.CURR_TREATMENT_ID IS NULL;
548: