eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_SINGLE dependencies on CZ_IMP_LOCALIZED_TEXTS

Line 1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

1671: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;
1672: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1673: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1674:
1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;
1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;
1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;

Line 1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;

1672: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1673: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1674:
1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;
1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;
1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;
1680:

Line 1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;

1673: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1674:
1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;
1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;
1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;
1680:
1681: TYPE tTextStr IS TABLE OF cz_imp_intl_text.text_str%TYPE INDEX BY BINARY_INTEGER;

Line 1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;

1674:
1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;
1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;
1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;
1680:
1681: TYPE tTextStr IS TABLE OF cz_imp_intl_text.text_str%TYPE INDEX BY BINARY_INTEGER;
1682:

Line 1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;

1675: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1676: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1677: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;
1678: TYPE tSrcLang IS TABLE OF cz_imp_localized_texts.source_lang%TYPE INDEX BY BINARY_INTEGER;
1679: TYPE tFSKDevlProject IS TABLE OF cz_imp_localized_texts.fsk_devlproject_1_1%TYPE INDEX BY BINARY_INTEGER;
1680:
1681: TYPE tTextStr IS TABLE OF cz_imp_intl_text.text_str%TYPE INDEX BY BINARY_INTEGER;
1682:
1683: CompSeqId tCompSeqId;

Line 1693: iFSKDevlProject cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;

1689: iLocalizedStr tLocalizedStr;
1690: iLanguage tLanguage;
1691: iSrcLang tSrcLang;
1692: -- iFSKDevlProject tFSKDevlProject;
1693: iFSKDevlProject cz_imp_localized_texts.fsk_devlproject_1_1%TYPE;
1694: nTopBillSequenceId BOM_EXPLOSIONS.top_bill_sequence_id%type;
1695:
1696: st_time number;
1697: end_time number;

Line 1810: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

1806: END IF;
1807:
1808: iFSKDevlProject := CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(l_parent_model_id));
1809:
1810: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
1811: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1812: VALUES (iLocalizedStr(i), iLanguage(i), iSrcLang(i), inRun_ID,
1813: CompItemId(i)||':'||sExpl_type||':'||nOrg_ID||':'||CompSeqId(i), iFSKDevlProject);
1814: END LOOP;

Line 1828: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

1824: FOR j IN gModelItemId_tbl.FIRST..gModelItemId_tbl.LAST LOOP
1825:
1826: IF ( gModelItemId_tbl(j) <> nTop_ID) THEN
1827:
1828: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
1829: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, FSK_DEVLPROJECT_1_1)
1830: SELECT description, language, source_lang, inRun_ID,
1831: gModelItemId_tbl(j)||':'||sExpl_type||':'||nOrg_ID||':'||
1832: NVL(common_component_sequence_id, component_sequence_id),

Line 2577: -- add record to CZ_IMP_LOCALIZED_TEXTS with

2573: l_localtext_orig_sys_ref_tbl(l_rec_counter) := NULL;
2574:
2575: --
2576: -- if it is translatable property then populate l_num_value_tbl () with intl_text_id and
2577: -- add record to CZ_IMP_LOCALIZED_TEXTS with
2578: -- ORIG_SYS_REF = l_prop_orig_sys_ref_tbl(l_rec_counter)
2579: --
2580: IF l_db_column_types_tbl(n)=TL_TEXT_TYPE THEN -- translatable text
2581: l_localtext_orig_sys_ref_tbl(l_rec_counter) := l_prop_orig_sys_ref_tbl(l_rec_counter)||':'||l_db_columns_tbl(n)||':'||TO_CHAR(l_inventory_item_id);

Line 2583: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2579: --
2580: IF l_db_column_types_tbl(n)=TL_TEXT_TYPE THEN -- translatable text
2581: l_localtext_orig_sys_ref_tbl(l_rec_counter) := l_prop_orig_sys_ref_tbl(l_rec_counter)||':'||l_db_columns_tbl(n)||':'||TO_CHAR(l_inventory_item_id);
2582:
2583: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2584: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID)
2585: VALUES
2586: (l_column_value,l_language, l_source_lang, p_run_id, l_localtext_orig_sys_ref_tbl(l_rec_counter),0);
2587: l_num_value_tbl (l_rec_counter) := NULL;

Line 2623: INSERT INTO CZ_IMP_LOCALIZED_TEXTS

2619:
2620: COMMIT;
2621:
2622: FORALL i IN l_prop_values_tbl.FIRST..l_prop_values_tbl.LAST
2623: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2624: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID)
2625: SELECT
2626: LOCALIZED_STR, LANG.LANGUAGE_CODE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID
2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang

Line 2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang

2623: INSERT INTO CZ_IMP_LOCALIZED_TEXTS
2624: (LOCALIZED_STR, LANGUAGE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID)
2625: SELECT
2626: LOCALIZED_STR, LANG.LANGUAGE_CODE, SOURCE_LANG, RUN_ID, ORIG_SYS_REF, MODEL_ID
2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2628: WHERE intl.run_id=p_run_id AND intl.orig_sys_ref=l_localtext_orig_sys_ref_tbl(i) AND installed_flag in( 'B', 'I')
2629: AND LANGUAGE_CODE<>SOURCE_LANG
2630: AND EXISTS
2631: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang

Line 2631: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang

2627: FROM CZ_IMP_LOCALIZED_TEXTS intl,fnd_languages lang
2628: WHERE intl.run_id=p_run_id AND intl.orig_sys_ref=l_localtext_orig_sys_ref_tbl(i) AND installed_flag in( 'B', 'I')
2629: AND LANGUAGE_CODE<>SOURCE_LANG
2630: AND EXISTS
2631: (SELECT 1 FROM CZ_IMP_LOCALIZED_TEXTS loc,fnd_languages lang
2632: WHERE loc.run_id=p_run_id AND orig_sys_ref = intl.orig_sys_ref
2633: AND lang.language_code <> loc.language
2634: );
2635: COMMIT;