DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_INTL_TEXT

Line 1670: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;

1666: nModelId IN NUMBER)
1667: IS
1668: xERROR BOOLEAN:=FALSE;
1669:
1670: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%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:

Line 1671: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;

1667: IS
1668: xERROR BOOLEAN:=FALSE;
1669:
1670: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%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;

Line 1672: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;

1668: xERROR BOOLEAN:=FALSE;
1669:
1670: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%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;

Line 1673: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;

1669:
1670: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%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;

Line 1709: FROM cz_exv_intl_text

1705: SELECT DISTINCT component_item_id,
1706: NVL(common_component_sequence_id, component_sequence_id) AS component_sequence_id,
1707: component_code,
1708: description, language, source_lang
1709: FROM cz_exv_intl_text
1710: WHERE organization_id = nOrg_ID
1711: AND top_item_id = nTop_ID
1712: AND explosion_type = sExpl_type;
1713:

Line 1834: FROM cz_exv_intl_text

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),
1833: CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(gModelItemId_tbl(j)))
1834: FROM cz_exv_intl_text
1835: WHERE organization_id = nOrg_ID
1836: AND top_item_id = gModelItemId_tbl(j)
1837: AND explosion_type = sExpl_type
1838: AND component_item_id = top_item_id;