DBA Data[Home] [Help]

APPS.CZ_IMP_SINGLE dependencies on CZ_EXV_INTL_TEXT

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

1604: nModelId IN NUMBER)
1605: IS
1606: xERROR BOOLEAN:=FALSE;
1607:
1608: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
1609: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;
1610: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1611: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1612:

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

1605: IS
1606: xERROR BOOLEAN:=FALSE;
1607:
1608: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
1609: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;
1610: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1611: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1612:
1613: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

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

1606: xERROR BOOLEAN:=FALSE;
1607:
1608: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
1609: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;
1610: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1611: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1612:
1613: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1614: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;

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

1607:
1608: TYPE tCompSeqId IS TABLE OF cz_exv_intl_text.component_sequence_id%TYPE INDEX BY BINARY_INTEGER;
1609: TYPE tOrgId IS TABLE OF cz_exv_intl_text.organization_id%TYPE INDEX BY BINARY_INTEGER;
1610: TYPE tCompItemId IS TABLE OF cz_exv_intl_text.component_item_id%TYPE INDEX BY BINARY_INTEGER;
1611: TYPE tCompCode IS TABLE OF cz_exv_intl_text.component_code%TYPE INDEX BY BINARY_INTEGER;
1612:
1613: TYPE tOrigSysRef IS TABLE OF cz_imp_localized_texts.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1614: TYPE tLocalizedStr IS TABLE OF cz_imp_localized_texts.localized_str%TYPE INDEX BY BINARY_INTEGER;
1615: TYPE tLanguage IS TABLE OF cz_imp_localized_texts.language%TYPE INDEX BY BINARY_INTEGER;

Line 1647: FROM cz_exv_intl_text

1643: SELECT DISTINCT component_item_id,
1644: NVL(common_component_sequence_id, component_sequence_id) AS component_sequence_id,
1645: component_code,
1646: description, language, source_lang
1647: FROM cz_exv_intl_text
1648: WHERE organization_id = nOrg_ID
1649: AND top_item_id = nTop_ID
1650: AND explosion_type = sExpl_type;
1651:

Line 1772: FROM cz_exv_intl_text

1768: SELECT description, language, source_lang, inRun_ID,
1769: gModelItemId_tbl(j)||':'||sExpl_type||':'||nOrg_ID||':'||
1770: NVL(common_component_sequence_id, component_sequence_id),
1771: CZ_ORAAPPS_INTEGRATE.PROJECT_SURROGATE_KEY(sExpl_type,to_char(nOrg_ID),to_char(gModelItemId_tbl(j)))
1772: FROM cz_exv_intl_text
1773: WHERE organization_id = nOrg_ID
1774: AND top_item_id = gModelItemId_tbl(j)
1775: AND explosion_type = sExpl_type
1776: AND component_item_id = top_item_id;