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_DEVL_PROJECT

Line 1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

1812: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;

Line 1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;

1813: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1821:

Line 1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;

1814: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1821:
1822: Description tDescription;

Line 1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;

1815:
1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1821:
1822: Description tDescription;
1823: OrganizationId tOrganizationId;

Line 1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;

1816: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1817: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1818: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1819: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1820: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1821:
1822: Description tDescription;
1823: OrganizationId tOrganizationId;
1824: ComponentItemId tComponentItemId;

Line 1904: INSERT INTO CZ_IMP_DEVL_PROJECT

1900: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1901: end if;
1902:
1903: FORALL i IN 1..iOrigSysRef.COUNT
1904: INSERT INTO CZ_IMP_DEVL_PROJECT
1905: (ORGANIZATION_ID, TOP_ITEM_ID, EXPLOSION_TYPE, ORIG_SYS_REF, VERSION,
1906: RUN_ID, NAME, FSK_INTLTEXT_1_1, DESC_TEXT, PLAN_LEVEL, MODEL_ID, MODEL_TYPE,
1907: INVENTORY_ITEM_ID, PRODUCT_KEY, BOM_CAPTION_RULE_ID, NONBOM_CAPTION_RULE_ID, CONFIG_ENGINE_TYPE)
1908: VALUES

Line 3920: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID

3916: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
3917:
3918: IF l_compare_detailed_types THEN
3919:
3920: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID
3921: AND rec_status = 'OK')LOOP
3922: FOR i IN (SELECT ps_node_id, detailed_type_id
3923: FROM CZ_UI_TYPEDPSN_V
3924: WHERE devl_project_Id = model.devl_project_id