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 1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

1874: TYPE tExplosionType IS TABLE OF cz_exv_item_master.explosion_type%TYPE INDEX BY BINARY_INTEGER;
1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;

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

1875: TYPE tPlanLevel IS TABLE OF cz_exv_item_master.plan_level%TYPE INDEX BY BINARY_INTEGER;
1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1883:

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

1876: TYPE tModelType IS TABLE OF cz_exv_item_master.model_type%TYPE INDEX BY BINARY_INTEGER;
1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1883:
1884: Description tDescription;

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

1877:
1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1883:
1884: Description tDescription;
1885: OrganizationId tOrganizationId;

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

1878: TYPE tOrigSysRef IS TABLE OF cz_imp_devl_project.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
1879: TYPE tName IS TABLE OF cz_imp_devl_project.name%TYPE INDEX BY BINARY_INTEGER;
1880: TYPE tDescText IS TABLE OF cz_imp_devl_project.desc_text%TYPE INDEX BY BINARY_INTEGER;
1881: TYPE tTopItemId IS TABLE OF cz_imp_devl_project.top_item_id%TYPE INDEX BY BINARY_INTEGER;
1882: TYPE tProductKey IS TABLE OF cz_imp_devl_project.product_key%TYPE INDEX BY BINARY_INTEGER;
1883:
1884: Description tDescription;
1885: OrganizationId tOrganizationId;
1886: ComponentItemId tComponentItemId;

Line 1966: INSERT INTO CZ_IMP_DEVL_PROJECT

1962: xError:=cz_utils.log_report(d_str,1,'EXTRACTION',11299,inRun_Id);
1963: end if;
1964:
1965: FORALL i IN 1..iOrigSysRef.COUNT
1966: INSERT INTO CZ_IMP_DEVL_PROJECT
1967: (ORGANIZATION_ID, TOP_ITEM_ID, EXPLOSION_TYPE, ORIG_SYS_REF, VERSION,
1968: RUN_ID, NAME, FSK_INTLTEXT_1_1, DESC_TEXT, PLAN_LEVEL, MODEL_ID, MODEL_TYPE,
1969: INVENTORY_ITEM_ID, PRODUCT_KEY, BOM_CAPTION_RULE_ID, NONBOM_CAPTION_RULE_ID, CONFIG_ENGINE_TYPE)
1970: VALUES

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

4308: --DBMS_OUTPUT.PUT_LINE(CZ_UTILS.GET_TEXT('CZ_IMP_IMPORT_COMPLETED','RUNID',TO_CHAR(genRun_ID)));
4309:
4310: IF l_compare_detailed_types THEN
4311:
4312: FOR model IN (SELECT devl_project_id FROM cz_imp_devl_project WHERE run_id = genRun_ID
4313: AND rec_status = 'OK')LOOP
4314: FOR i IN (SELECT ps_node_id, detailed_type_id
4315: FROM CZ_UI_TYPEDPSN_V
4316: WHERE devl_project_Id = model.devl_project_id