[Home] [Help]
127: WHERE NOT EXISTS
128: (SELECT 1
129: FROM gcs_hierarchies_b hb
130: WHERE hb.hierarchy_id = insert_row.hierarchy_id);
131: INSERT INTO gcs_hierarchies_tl
132: (hierarchy_id,
133: language,
134: source_lang,
135: hierarchy_name,
150: creation_date,
151: created_by
152: FROM dual
153: WHERE NOT EXISTS (SELECT 1
154: FROM gcs_hierarchies_tl htl
155: WHERE htl.hierarchy_id = insert_row.hierarchy_id
156: AND htl.language = userenv('LANG'));
157: OPEN hier_row;
158: FETCH hier_row
231: WHERE hb.hierarchy_id = update_row.hierarchy_id;
232: IF SQL%NOTFOUND THEN
233: raise no_data_found;
234: END IF;
235: INSERT INTO gcs_hierarchies_tl
236: (hierarchy_id,
237: language,
238: source_lang,
239: hierarchy_name,
254: creation_date,
255: created_by
256: FROM dual
257: WHERE NOT EXISTS (SELECT 1
258: FROM gcs_hierarchies_tl htl
259: WHERE htl.hierarchy_id = update_row.hierarchy_id
260: AND htl.language = userenv('LANG'));
261: UPDATE gcs_hierarchies_tl ht
262: SET hierarchy_name = update_row.hierarchy_name,
257: WHERE NOT EXISTS (SELECT 1
258: FROM gcs_hierarchies_tl htl
259: WHERE htl.hierarchy_id = update_row.hierarchy_id
260: AND htl.language = userenv('LANG'));
261: UPDATE gcs_hierarchies_tl ht
262: SET hierarchy_name = update_row.hierarchy_name,
263: description = update_row.description,
264: last_update_date = update_row.last_update_date,
265: last_updated_by = update_row.last_updated_by,
388: -- Procedure
389: -- Translate_Row
390: -- Purpose
391: -- Updates translated infromation for a row in the
392: -- gcs_hierarchies_tl table.
393: -- Arguments
394: -- hierarchy_id
395: -- owner
396: -- last_update_date
417: f_ludate := nvl(to_date(last_update_date, 'YYYY/MM/DD'), sysdate);
418: BEGIN
419: SELECT htl.last_updated_by, htl.last_update_date
420: INTO db_luby, db_ludate
421: FROM GCS_HIERARCHIES_TL htl
422: WHERE htl.hierarchy_id = translate_row.hierarchy_id
423: AND htl.language = userenv('LANG');
424: -- Test for customization information
425: IF fnd_load_util.upload_test(f_luby,
426: f_ludate,
427: db_luby,
428: db_ludate,
429: custom_mode) THEN
430: UPDATE gcs_hierarchies_tl htl
431: SET hierarchy_name = translate_row.hierarchy_name,
432: description = translate_row.description,
433: source_lang = userenv('LANG'),
434: last_update_date = f_ludate,
454: --
455: procedure ADD_LANGUAGE is
456: begin
457: insert /*+ append parallel(tt) */
458: into GCS_HIERARCHIES_TL tt
459: (HIERARCHY_ID,
460: LANGUAGE,
461: SOURCE_LANG,
462: HIERARCHY_NAME,
478: B.LAST_UPDATE_DATE,
479: B.LAST_UPDATED_BY,
480: B.LAST_UPDATE_LOGIN,
481: B.DESCRIPTION
482: from GCS_HIERARCHIES_TL B, FND_LANGUAGES L
483: where L.INSTALLED_FLAG in ('I', 'B')
484: and B.LANGUAGE = userenv('LANG')) v,
485: GCS_HIERARCHIES_TL t
486: where T.HIERARCHY_ID(+) = v.HIERARCHY_ID
481: B.DESCRIPTION
482: from GCS_HIERARCHIES_TL B, FND_LANGUAGES L
483: where L.INSTALLED_FLAG in ('I', 'B')
484: and B.LANGUAGE = userenv('LANG')) v,
485: GCS_HIERARCHIES_TL t
486: where T.HIERARCHY_ID(+) = v.HIERARCHY_ID
487: and T.LANGUAGE(+) = v.LANGUAGE_CODE
488: and t.HIERARCHY_ID IS NULL;
489: end ADD_LANGUAGE;
2278:
2279: -- Get the hierarchies' information
2280: SELECT hierarchy_id, hierarchy_name BULK COLLECT
2281: INTO l_hier_info
2282: FROM gcs_hierarchies_tl
2283: WHERE language = userenv('LANG');
2284:
2285:
2286: IF l_hier_info.FIRST IS NOT NULL AND l_hier_info.LAST IS NOT NULL THEN
2420: BEGIN
2421:
2422: SELECT hierarchy_name
2423: INTO l_hierarchy_name
2424: FROM gcs_hierarchies_tl
2425: WHERE language = userenv('LANG')
2426: AND hierarchy_id = p_hierarchy_id;
2427:
2428: -- Get Source Data Set's FEM Balance type code for the given data type code.
2610: SELECT tl.hierarchy_name,
2611: b.fem_ledger_id
2612: INTO l_hierarchy_name,l_ledger_id
2613: FROM gcs_hierarchies_b b,
2614: gcs_hierarchies_tl tl
2615: WHERE b.hierarchy_id = tl.hierarchy_id
2616: AND tl.hierarchy_id = p_hierarchy_id
2617: AND tl.language = userenv('LANG');
2618: