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_PS_NODE dependencies on CZ_DEVL_PROJECTS

Line 114: FROM cz_localized_texts ol, cz_devl_projects od, cz_ps_nodes op,

110: -- check online table for this text in this language for this model
111:
112: CURSOR c_onl_intl_text IS
113: SELECT ol.intl_text_id,ol.localized_str, ol.model_id, ol.orig_sys_ref
114: FROM cz_localized_texts ol, cz_devl_projects od, cz_ps_nodes op,
115: cz_imp_ps_nodes ip, cz_imp_devl_project id
116: WHERE ol.orig_sys_ref = sImpOrigSysRef(i)
117: AND ip.fsk_intltext_1_1 = sImpOrigSysRef(i)
118: AND op.intl_text_id = ol.intl_text_id

Line 745: onlName CZ_DEVL_PROJECTS.NAME%TYPE;

741: x_error BOOLEAN:=FALSE;
742:
743: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
744: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
745: onlName CZ_DEVL_PROJECTS.NAME%TYPE;
746: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
747: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
748: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
749: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

Line 754: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

750: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;
751: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
752: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;
753: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;
754: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
755: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
756: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
757: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
758: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

Line 758: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

754: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
755: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
756: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
757: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
758: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
760: nExplId NUMBER;
761: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;
762: nModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

Line 759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

755: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
756: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
757: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
758: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
760: nExplId NUMBER;
761: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;
762: nModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
763: sModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

Line 841: SELECT devl_project_id FROM cz_devl_projects

837:
838: /* Check the online database */
839: DECLARE
840: CURSOR c_onl_devl_project IS
841: SELECT devl_project_id FROM cz_devl_projects
842: WHERE ORIG_SYS_REF=sOrigSysRef
843: AND DEVL_PROJECT_ID=PERSISTENT_PROJECT_ID
844: AND DELETED_FLAG='0';
845: BEGIN

Line 860: SELECT NULL FROM cz_devl_projects

856: END IF;
857: ELSE
858: DECLARE
859: CURSOR c_onl_model_root IS
860: SELECT NULL FROM cz_devl_projects
861: WHERE devl_project_id = REFRESH_MODEL_ID
862: AND deleted_flag = '0';
863: CURSOR c_onl_model_id IS
864: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e

Line 864: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e

860: SELECT NULL FROM cz_devl_projects
861: WHERE devl_project_id = REFRESH_MODEL_ID
862: AND deleted_flag = '0';
863: CURSOR c_onl_model_id IS
864: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e
865: WHERE d.deleted_flag = '0'
866: AND e.deleted_flag = '0'
867: AND d.orig_sys_ref = sOrigSysRef
868: AND e.model_id = REFRESH_MODEL_ID

Line 906: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv

902:
903: IF(NOT x_onl_devl_project_f)THEN
904: DECLARE
905: CURSOR c_check IS
906: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv
907: WHERE rp.deleted_flag = '0'
908: AND rp.object_type = 'PRJ'
909: AND rp.name = sName
910: AND dv.deleted_flag = '0'

Line 921: FROM cz_rp_entries rp, cz_devl_projects dv

917: IF(c_check%FOUND)THEN
918:
919: BEGIN
920: SELECT MAX(cz_utils.conv_num(SUBSTR(rp.name, 7, INSTR(rp.name, ')') - 7))) INTO nDummy
921: FROM cz_rp_entries rp, cz_devl_projects dv
922: WHERE rp.deleted_flag = '0'
923: AND rp.object_type = 'PRJ'
924: AND rp.name like 'Copy (%) of ' || sName
925: AND dv.deleted_flag = '0'

Line 944: FROM cz_devl_projects WHERE devl_project_id = nOnlDevlProjectId;

940: ELSE
941:
942: BEGIN
943: SELECT name, model_type INTO onlName, sModelType
944: FROM cz_devl_projects WHERE devl_project_id = nOnlDevlProjectId;
945:
946: IF(SUBSTR(onlName,1,6) = 'Copy (')THEN
947: sName := SUBSTR(onlName,1,INSTR(onlName,') of')+4) || sName;
948: END IF;

Line 1116: (SELECT 1 FROM cz_devl_projects

1112: AND deleted_flag = '0'
1113: AND (devl_project_id = 0
1114: OR
1115: (devl_project_id <> 0 AND EXISTS
1116: (SELECT 1 FROM cz_devl_projects
1117: WHERE deleted_flag = '0'
1118: AND devl_project_id = a.devl_project_id
1119: AND orig_sys_ref = p_orig_sys_ref)))
1120: AND ROWNUM < 2;

Line 1338: dbModelType cz_devl_projects.model_type%TYPE;

1334:
1335: copy_child_models cz_xfr_project_bills.copy_addl_child_models%TYPE;
1336: server_id cz_xfr_project_bills.source_server%TYPE;
1337:
1338: dbModelType cz_devl_projects.model_type%TYPE;
1339:
1340: -- Internal vars --
1341: nCommitCount PLS_INTEGER:=0; -- COMMIT buffer index --
1342: nInsertCount PLS_INTEGER:=0; -- Inserts --

Line 1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);

1364:
1365: BEGIN
1366:
1367: -- Get the Update Flags for each column
1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);

Line 1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);

1365: BEGIN
1366:
1367: -- Get the Update Flags for each column
1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);

Line 1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);

1366:
1367: -- Get the Update Flags for each column
1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);

Line 1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);

1367: -- Get the Update Flags for each column
1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);

Line 1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);

1368: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);

Line 1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);

1369: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);

Line 1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);

1370: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);

Line 1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);

1371: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);

Line 1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);

1372: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);

Line 1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);

1373: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);

Line 1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);

1374: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);

Line 1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);

1375: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);

Line 1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);

1376: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);

Line 1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);

1377: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);

Line 1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);

1378: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1386:

Line 1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);

1379: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1386:
1387: OPEN c_xfr_devl_project;

Line 1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);

1380: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1386:
1387: OPEN c_xfr_devl_project;
1388: LOOP

Line 1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);

1381: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1382: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1383: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1384: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1385: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1386:
1387: OPEN c_xfr_devl_project;
1388: LOOP
1389: IF(nCommitCount>= COMMIT_SIZE) THEN

Line 1432: INSERT INTO cz_devl_projects (devl_project_id, intl_text_id,

1428:
1429: IF(p_xfr_devl_project.disposition = 'I') THEN
1430: BEGIN
1431:
1432: INSERT INTO cz_devl_projects (devl_project_id, intl_text_id,
1433: name, version, deleted_flag, orig_sys_ref, desc_text,
1434: creation_date, last_update_date, created_by, last_updated_by,
1435: persistent_project_id, model_type, organization_id, inventory_item_id, product_key,
1436: bom_caption_rule_id, nonbom_caption_rule_id, config_engine_type)

Line 1518: UPDATE cz_devl_projects SET

1514:
1515: ELSIF(p_xfr_devl_project.disposition = 'M') THEN
1516: BEGIN
1517:
1518: UPDATE cz_devl_projects SET
1519: intl_text_id=DECODE(NOUPDATE_INTL_TEXT_ID,0,p_xfr_devl_project.intl_text_id,intl_text_id),
1520: name=DECODE(NOUPDATE_NAME,0,p_xfr_devl_project.name,name),
1521: version=DECODE(NOUPDATE_VERSION,0,p_xfr_devl_project.version,version),
1522: deleted_flag=DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_devl_project.deleted_flag,deleted_flag),

Line 1608: v_table_name VARCHAR2(30) := 'CZ_DEVL_PROJECTS';

1604: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1605: PROCEDURE RPT_DEVL_PROJECT ( inRUN_ID IN PLS_INTEGER ) AS
1606: x_error BOOLEAN:=FALSE;
1607:
1608: v_table_name VARCHAR2(30) := 'CZ_DEVL_PROJECTS';
1609: v_ok VARCHAR2(4) := 'OK';
1610: v_completed VARCHAR2(1) := '1';
1611:
1612: CURSOR c_xfr_run_result IS

Line 1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;

Line 1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;

Line 1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;

1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;
1761: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;
1762:
1763: /* Internal vars */
1764: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 1773: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS',inXFR_GROUP);

1769: nDups PLS_INTEGER:=0; /*Dupl records */
1770: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES',inXFR_GROUP);
1771: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_INTL_TEXTS',inXFR_GROUP);
1772: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
1773: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS',inXFR_GROUP);
1774: nAllocateBlock PLS_INTEGER:=1;
1775: nAllocateCounter PLS_INTEGER;
1776: nNextValue NUMBER;
1777: nNextId NUMBER;

Line 1948: SELECT p.PS_NODE_ID, p.devl_project_id, p.item_id FROM CZ_PS_NODES p, CZ_DEVL_PROJECTS d

1944: CURSOR c_onl_refpartnbr IS
1945: SELECT ref_part_nbr FROM cz_item_masters
1946: WHERE item_id = nReferredItemId;
1947: CURSOR c_reference IS
1948: SELECT p.PS_NODE_ID, p.devl_project_id, p.item_id FROM CZ_PS_NODES p, CZ_DEVL_PROJECTS d
1949: WHERE p.ORIG_SYS_REF = sFSKREFERENCE
1950: AND p.ps_node_id = p.persistent_node_id
1951: AND p.deleted_flag = '0'
1952: AND p.ps_node_id = d.devl_project_id

Line 2160: FROM CZ_DEVL_PROJECTS

2156:
2157: DECLARE
2158: CURSOR c_node IS
2159: SELECT model_type
2160: FROM CZ_DEVL_PROJECTS
2161: WHERE DEVL_PROJECT_ID IN (SELECT PARENT_ID FROM CZ_PS_NODES
2162: WHERE PS_NODE_ID = nOnlPsnodeId
2163: AND DELETED_FLAG = '0')
2164: AND DELETED_FLAG = '0';

Line 2311: l_model_name cz_devl_projects.name%type;

2307: l_rec_status cz_imp_ps_nodes.rec_status%TYPE;
2308:
2309: sInstantiableFlag cz_ps_nodes.instantiable_flag%type;
2310: l_msg VARCHAR2(255);
2311: l_model_name cz_devl_projects.name%type;
2312: l_debug NUMBER;
2313: l_minimum cz_imp_ps_nodes.minimum%TYPE;
2314: l_maximum cz_imp_ps_nodes.maximum%TYPE;
2315: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;

Line 3095: l_model_name cz_devl_projects.name%type;

3091:
3092: sVirtualFlag cz_ps_nodes.virtual_flag%type := '1';
3093: l_last_model_id cz_ps_nodes.devl_project_id%type := 0;
3094: l_msg VARCHAR2(2000);
3095: l_model_name cz_devl_projects.name%type;
3096: l_disposition cz_imp_ps_nodes.disposition%type;
3097: i integer;
3098: j integer;
3099: l_debug number:=0;

Line 4399: DELETE FROM cz_devl_projects

4395:
4396: -- delete if failed model was a new model
4397:
4398: IF l_c1_dis_tbl(i) = 'I' THEN
4399: DELETE FROM cz_devl_projects
4400: WHERE devl_project_id = l_c1_prj_id_tbl(i);
4401: DELETE FROM cz_rp_entries
4402: WHERE object_id = l_c1_prj_id_tbl(i)
4403: AND object_type = 'PRJ';

Line 4429: DELETE FROM cz_devl_projects

4425:
4426: -- delete if failed model was a new model
4427:
4428: IF l_c2_dis_tbl(i) = 'I' THEN
4429: DELETE FROM cz_devl_projects
4430: WHERE devl_project_id = l_c2_prj_id_tbl(i);
4431: DELETE FROM cz_rp_entries
4432: WHERE object_id = l_c2_prj_id_tbl(i)
4433: AND object_type = 'PRJ';

Line 4459: DELETE FROM cz_devl_projects

4455:
4456: -- delete if failed model was a new model
4457:
4458: IF l_c3_dis_tbl(i) = 'I' THEN
4459: DELETE FROM cz_devl_projects
4460: WHERE devl_project_id = l_c3_prj_id_tbl(i);
4461: DELETE FROM cz_rp_entries
4462: WHERE object_id = l_c3_prj_id_tbl(i)
4463: AND object_type = 'PRJ';

Line 4572: DELETE FROM cz_devl_projects

4568:
4569: -- delete if failed model was a new model
4570:
4571: IF l_c4_dis_tbl(i) = 'I' THEN
4572: DELETE FROM cz_devl_projects
4573: WHERE devl_project_id = l_c4_prj_id_tbl(i);
4574: DELETE FROM cz_rp_entries
4575: WHERE object_id = l_c4_prj_id_tbl(i)
4576: AND object_type = 'PRJ';