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 128: FROM cz_localized_texts ol, cz_devl_projects od, cz_ps_nodes op,

124: -- check online table for this text in this language for this model
125:
126: CURSOR c_onl_intl_text IS
127: SELECT ol.intl_text_id,ol.localized_str, ol.model_id, ol.orig_sys_ref,ol.language
128: FROM cz_localized_texts ol, cz_devl_projects od, cz_ps_nodes op,
129: cz_imp_ps_nodes ip, cz_imp_devl_project id
130: WHERE ol.orig_sys_ref = sImpOrigSysRef(i)
131: AND ip.fsk_intltext_1_1 = sImpOrigSysRef(i)
132: AND op.intl_text_id = ol.intl_text_id

Line 884: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

880: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
881: sConfigEngType CZ_IMP_DEVL_PROJECT.CONFIG_ENGINE_TYPE%TYPE;
882: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;
883: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;
884: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
885: nImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
886: sImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;

Line 885: nImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;

881: sConfigEngType CZ_IMP_DEVL_PROJECT.CONFIG_ENGINE_TYPE%TYPE;
882: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;
883: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;
884: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
885: nImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
886: sImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
889: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;

Line 886: sImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;

882: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;
883: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;
884: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
885: nImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
886: sImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
889: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
890: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

Line 890: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

886: sImpProdKey CZ_DEVL_PROJECTS.PRODUCT_KEY%TYPE;
887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
889: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
890: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
891: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
892: nExplId NUMBER;
893: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;
894: nModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

Line 891: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%TYPE;
888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%TYPE;
889: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%TYPE;
890: nModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
891: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
892: nExplId NUMBER;
893: COPY_CHILD_MODELS CZ_XFR_PROJECT_BILLS.COPY_ADDL_CHILD_MODELS%TYPE;
894: nModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
895: sModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

Line 1000: -- SELECT devl_project_id FROM cz_devl_projects

996:
997: /* Check the online database */
998: --DECLARE
999: --CURSOR c_onl_devl_project IS
1000: -- SELECT devl_project_id FROM cz_devl_projects
1001: -- WHERE ORIG_SYS_REF=sOrigSysRef
1002: -- AND DEVL_PROJECT_ID=PERSISTENT_PROJECT_ID
1003: -- AND DELETED_FLAG='0';
1004:

Line 1011: nCurStmt := 'SELECT devl_project_id, persistent_project_id,intl_text_id,name,model_type,product_key,desc_text FROM cz_devl_projects ' --VR Added extra columns to check for update status

1007: nOnlDevlProjectId := NULL;
1008:
1009: --LA 9595142 Made the cursor dynamic to use import enabled flag when required
1010: IF (disableMultipleCopyImport = 1) THEN
1011: nCurStmt := 'SELECT devl_project_id, persistent_project_id,intl_text_id,name,model_type,product_key,desc_text FROM cz_devl_projects ' --VR Added extra columns to check for update status
1012: || ' WHERE ORIG_SYS_REF= :1 '
1013: || ' AND DELETED_FLAG= ''0'' '
1014: || ' AND IMPORT_ENABLED = ''1'' '
1015: || ' AND NVL(config_engine_type,''L'') = :2' ; --LA 12548898 Engine Sync

Line 1025: FROM cz_devl_projects WHERE ORIG_SYS_REF=sOrigSysRef

1021:
1022: -- LA 12548898 If given BOM with both engine type exists then stop import
1023: -- process and force to enable DISABLEMULTIPLECOPYIMPORT settings
1024: SELECT COUNT(DISTINCT(config_engine_type)) INTO v_engine_cnt
1025: FROM cz_devl_projects WHERE ORIG_SYS_REF=sOrigSysRef
1026: AND deleted_flag = '0' ;
1027:
1028: IF v_engine_cnt > 1 THEN
1029: l_err_msg := 'For ORIG_SYS_REF = ' || sOrigSysRef

Line 1038: nCurStmt := 'SELECT devl_project_id,intl_text_id,name,model_type,product_key,desc_text FROM cz_devl_projects '

1034:
1035: RAISE IMP_CHILD_MULTI_COPIES ;
1036: END IF;
1037:
1038: nCurStmt := 'SELECT devl_project_id,intl_text_id,name,model_type,product_key,desc_text FROM cz_devl_projects '
1039: || ' WHERE ORIG_SYS_REF= :1 '
1040: || ' AND DELETED_FLAG= ''0'' '
1041: || ' AND DEVL_PROJECT_ID=PERSISTENT_PROJECT_ID '
1042: || ' AND NVL(config_engine_type,''L'') = :2' ; --LA 12548898 Engine Sync

Line 1060: SELECT NULL FROM cz_devl_projects

1056: END IF;
1057: ELSE
1058: DECLARE
1059: CURSOR c_onl_model_root IS
1060: SELECT NULL FROM cz_devl_projects
1061: WHERE devl_project_id = REFRESH_MODEL_ID
1062: AND deleted_flag = '0';
1063: CURSOR c_onl_model_id IS
1064: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e

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

1060: SELECT NULL FROM cz_devl_projects
1061: WHERE devl_project_id = REFRESH_MODEL_ID
1062: AND deleted_flag = '0';
1063: CURSOR c_onl_model_id IS
1064: SELECT d.devl_project_id, e.model_ref_expl_id FROM cz_devl_projects d, cz_model_ref_expls e
1065: WHERE d.deleted_flag = '0'
1066: AND e.deleted_flag = '0'
1067: AND d.orig_sys_ref = sOrigSysRef
1068: AND e.model_id = REFRESH_MODEL_ID

Line 1106: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv

1102:
1103: IF(NOT x_onl_devl_project_f)THEN
1104: DECLARE
1105: CURSOR c_check IS
1106: SELECT null FROM cz_rp_entries rp, cz_devl_projects dv
1107: WHERE rp.deleted_flag = '0'
1108: AND rp.object_type = 'PRJ'
1109: AND rp.name = sName
1110: AND dv.deleted_flag = '0'

Line 1121: FROM cz_rp_entries rp, cz_devl_projects dv

1117: IF(c_check%FOUND)THEN
1118:
1119: BEGIN
1120: SELECT MAX(cz_utils.conv_num(SUBSTR(rp.name, 7, INSTR(rp.name, ')') - 7))) INTO nDummy
1121: FROM cz_rp_entries rp, cz_devl_projects dv
1122: WHERE rp.deleted_flag = '0'
1123: AND rp.object_type = 'PRJ'
1124: AND rp.name like 'Copy (%) of ' || sName
1125: AND dv.deleted_flag = '0'

Line 1144: FROM cz_devl_projects WHERE devl_project_id = nOnlDevlProjectId;

1140: ELSE
1141:
1142: BEGIN
1143: SELECT name, model_type INTO onlName, sModelType
1144: FROM cz_devl_projects WHERE devl_project_id = nOnlDevlProjectId;
1145:
1146: IF(SUBSTR(onlName,1,6) = 'Copy (')THEN
1147: sName := SUBSTR(onlName,1,INSTR(onlName,') of')+4) || sName;
1148: END IF;

Line 1331: (SELECT 1 FROM cz_devl_projects

1327: AND deleted_flag = '0'
1328: AND (devl_project_id = 0
1329: OR
1330: (devl_project_id <> 0 AND EXISTS
1331: (SELECT 1 FROM cz_devl_projects
1332: WHERE deleted_flag = '0'
1333: AND devl_project_id = a.devl_project_id
1334: AND orig_sys_ref = p_orig_sys_ref)))
1335: AND ROWNUM < 2;

Line 1564: dbModelType cz_devl_projects.model_type%TYPE;

1560:
1561: copy_child_models cz_xfr_project_bills.copy_addl_child_models%TYPE;
1562: server_id cz_xfr_project_bills.source_server%TYPE;
1563:
1564: dbModelType cz_devl_projects.model_type%TYPE;
1565:
1566: -- Internal vars --
1567: nCommitCount PLS_INTEGER:=0; -- COMMIT buffer index --
1568: nInsertCount PLS_INTEGER:=0; -- Inserts --

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

1591:
1592: BEGIN
1593:
1594: -- Get the Update Flags for each column
1595: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);

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

1592: BEGIN
1593:
1594: -- Get the Update Flags for each column
1595: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);

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

1593:
1594: -- Get the Update Flags for each column
1595: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);

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

1594: -- Get the Update Flags for each column
1595: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);

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

1595: NOUPDATE_NAME := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NAME',inXFR_GROUP);
1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);

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

1596: NOUPDATE_VERSION := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','VERSION',inXFR_GROUP);
1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);

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

1597: NOUPDATE_INTL_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INTL_TEXT_ID',inXFR_GROUP);
1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);

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

1598: NOUPDATE_CREATION_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATION_DATE',inXFR_GROUP);
1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);

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

1599: NOUPDATE_LAST_UPDATE_DATE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATE_DATE',inXFR_GROUP);
1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);

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

1600: NOUPDATE_CREATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','CREATED_BY',inXFR_GROUP);
1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);

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

1601: NOUPDATE_LAST_UPDATED_BY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','LAST_UPDATED_BY',inXFR_GROUP);
1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);

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

1602: NOUPDATE_DELETED_FLAG := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DELETED_FLAG',inXFR_GROUP);
1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);

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

1603: NOUPDATE_ORIG_SYS_REF := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORIG_SYS_REF',inXFR_GROUP);
1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);

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

1604: NOUPDATE_DESC_TEXT := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','DESC_TEXT',inXFR_GROUP);
1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1612: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);

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

1605: NOUPDATE_MODEL_TYPE := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','MODEL_TYPE',inXFR_GROUP);
1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1612: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1613:

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

1606: NOUPDATE_INVENTORY_ITEM_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','INVENTORY_ITEM_ID',inXFR_GROUP);
1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1612: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1613:
1614: OPEN c_xfr_devl_project;

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

1607: NOUPDATE_ORGANIZATION_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','ORGANIZATION_ID',inXFR_GROUP);
1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1612: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1613:
1614: OPEN c_xfr_devl_project;
1615: LOOP

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

1608: NOUPDATE_PRODUCT_KEY := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','PRODUCT_KEY',inXFR_GROUP);
1609: NOUPDATE_BOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_RULE_ID',inXFR_GROUP);
1610: NOUPDATE_NONBOM_CPTN_RULE_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_RULE_ID',inXFR_GROUP);
1611: NOUPDATE_BOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','BOM_CAPTION_TEXT_ID',inXFR_GROUP);
1612: NOUPDATE_NONBOM_CPTN_TEXT_ID := CZ_UTILS.GET_NOUPDATE_FLAG('CZ_DEVL_PROJECTS','NONBOM_CAPTION_TEXT_ID',inXFR_GROUP);
1613:
1614: OPEN c_xfr_devl_project;
1615: LOOP
1616: IF(nCommitCount>= COMMIT_SIZE) THEN

Line 1681: INSERT INTO cz_devl_projects (devl_project_id, intl_text_id,

1677: IF(p_xfr_devl_project.disposition = 'I') THEN
1678: BEGIN
1679:
1680: --LA 9595142 Add while creating a model
1681: INSERT INTO cz_devl_projects (devl_project_id, intl_text_id,
1682: name, version, deleted_flag, orig_sys_ref, desc_text,
1683: creation_date, last_update_date, created_by, last_updated_by,
1684: persistent_project_id, model_type, organization_id, inventory_item_id, product_key,
1685: bom_caption_rule_id, nonbom_caption_rule_id, config_engine_type, import_enabled)

Line 1767: UPDATE cz_devl_projects SET

1763:
1764: ELSIF(p_xfr_devl_project.disposition = 'M') THEN
1765: BEGIN
1766:
1767: UPDATE cz_devl_projects SET
1768: intl_text_id=DECODE(NOUPDATE_INTL_TEXT_ID,0,p_xfr_devl_project.intl_text_id,intl_text_id),
1769: name=DECODE(NOUPDATE_NAME,0,p_xfr_devl_project.name,name),
1770: version=DECODE(NOUPDATE_VERSION,0,p_xfr_devl_project.version,version),
1771: deleted_flag=DECODE(NOUPDATE_DELETED_FLAG,0,p_xfr_devl_project.deleted_flag,deleted_flag),

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

1854: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1855: PROCEDURE RPT_DEVL_PROJECT ( inRUN_ID IN PLS_INTEGER ) AS
1856: x_error BOOLEAN:=FALSE;
1857:
1858: v_table_name VARCHAR2(30) := 'CZ_DEVL_PROJECTS';
1859: v_ok VARCHAR2(4) := 'OK';
1860: v_completed VARCHAR2(1) := '1';
1861:
1862: CURSOR c_xfr_run_result IS

Line 2066: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

2062: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
2063: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2064: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
2065: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
2066: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2067: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2068: --LA
2069: tmpOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
2070: tmpName CZ_IMP_PS_NODES.NAME%TYPE;

Line 2067: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

2063: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2064: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
2065: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
2066: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2067: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
2068: --LA
2069: tmpOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
2070: tmpName CZ_IMP_PS_NODES.NAME%TYPE;
2071: tmpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;

Line 2080: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;

2076: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
2077: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
2078: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
2079: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
2080: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;
2081: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;
2082:
2083: /* Internal vars */
2084: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

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

2091: dispositionflag PLS_INTEGER:=0; /*Disposition Counter*/
2092: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES',inXFR_GROUP);
2093: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_INTL_TEXTS',inXFR_GROUP);
2094: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
2095: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS',inXFR_GROUP);
2096: nAllocateBlock PLS_INTEGER:=1;
2097: nAllocateCounter PLS_INTEGER;
2098: nNextValue NUMBER;
2099: nNextId NUMBER;

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

2297: CURSOR c_onl_refpartnbr IS
2298: SELECT ref_part_nbr FROM cz_item_masters
2299: WHERE item_id = nReferredItemId;
2300: CURSOR c_reference IS
2301: SELECT p.PS_NODE_ID, p.devl_project_id, p.item_id FROM CZ_PS_NODES p, CZ_DEVL_PROJECTS d
2302: WHERE p.ORIG_SYS_REF = sFSKREFERENCE
2303: AND p.ps_node_id = p.persistent_node_id
2304: AND p.deleted_flag = '0'
2305: AND p.ps_node_id = d.devl_project_id

Line 2550: FROM CZ_DEVL_PROJECTS

2546:
2547: DECLARE
2548: CURSOR c_node IS
2549: SELECT model_type
2550: FROM CZ_DEVL_PROJECTS
2551: WHERE DEVL_PROJECT_ID IN (SELECT PARENT_ID FROM CZ_PS_NODES
2552: WHERE PS_NODE_ID = nOnlPsnodeId
2553: AND DELETED_FLAG = '0')
2554: AND DELETED_FLAG = '0';

Line 2702: l_model_name cz_devl_projects.name%type;

2698: l_rec_status cz_imp_ps_nodes.rec_status%TYPE;
2699:
2700: sInstantiableFlag cz_ps_nodes.instantiable_flag%type;
2701: l_msg VARCHAR2(255);
2702: l_model_name cz_devl_projects.name%type;
2703: l_debug NUMBER;
2704: l_minimum cz_imp_ps_nodes.minimum%TYPE;
2705: l_maximum cz_imp_ps_nodes.maximum%TYPE;
2706: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;

Line 3530: l_model_name cz_devl_projects.name%type;

3526:
3527: sVirtualFlag cz_ps_nodes.virtual_flag%type := '1';
3528: l_last_model_id cz_ps_nodes.devl_project_id%type := 0;
3529: l_msg VARCHAR2(2000);
3530: l_model_name cz_devl_projects.name%type;
3531: l_disposition cz_imp_ps_nodes.disposition%type;
3532: i integer;
3533: j integer;
3534: l_debug number:=0;

Line 4845: DELETE FROM cz_devl_projects

4841:
4842: -- delete if failed model was a new model
4843:
4844: IF l_c1_dis_tbl(i) = 'I' THEN
4845: DELETE FROM cz_devl_projects
4846: WHERE devl_project_id = l_c1_prj_id_tbl(i);
4847: DELETE FROM cz_rp_entries
4848: WHERE object_id = l_c1_prj_id_tbl(i)
4849: AND object_type = 'PRJ';

Line 4875: DELETE FROM cz_devl_projects

4871:
4872: -- delete if failed model was a new model
4873:
4874: IF l_c2_dis_tbl(i) = 'I' THEN
4875: DELETE FROM cz_devl_projects
4876: WHERE devl_project_id = l_c2_prj_id_tbl(i);
4877: DELETE FROM cz_rp_entries
4878: WHERE object_id = l_c2_prj_id_tbl(i)
4879: AND object_type = 'PRJ';

Line 4905: DELETE FROM cz_devl_projects

4901:
4902: -- delete if failed model was a new model
4903:
4904: IF l_c3_dis_tbl(i) = 'I' THEN
4905: DELETE FROM cz_devl_projects
4906: WHERE devl_project_id = l_c3_prj_id_tbl(i);
4907: DELETE FROM cz_rp_entries
4908: WHERE object_id = l_c3_prj_id_tbl(i)
4909: AND object_type = 'PRJ';

Line 5018: DELETE FROM cz_devl_projects

5014:
5015: -- delete if failed model was a new model
5016:
5017: IF l_c4_dis_tbl(i) = 'I' THEN
5018: DELETE FROM cz_devl_projects
5019: WHERE devl_project_id = l_c4_prj_id_tbl(i);
5020: DELETE FROM cz_rp_entries
5021: WHERE object_id = l_c4_prj_id_tbl(i)
5022: AND object_type = 'PRJ';