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_IMP_DEVL_PROJECT

Line 129: cz_imp_ps_nodes ip, cz_imp_devl_project id

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
133: AND ip.orig_sys_ref = op.orig_sys_ref

Line 215: FROM cz_imp_devl_project

211: ELSE /* insert */
212:
213: BEGIN
214: SELECT devl_project_id INTO nModelId
215: FROM cz_imp_devl_project
216: WHERE orig_sys_ref = sImpFSKDevlProject(i)
217: AND run_id = inRUN_ID
218: AND rec_status = 'OK';
219:

Line 852: FROM CZ_IMP_DEVL_PROJECT

848: ) IS
849: CURSOR c_imp_devl_project IS
850: SELECT plan_level,orig_sys_ref,name,fsk_intltext_1_1,organization_id,top_item_id,explosion_type,model_id,model_type,
851: devl_project_id,intl_text_id,product_key,config_engine_type,desc_text,ROWID
852: FROM CZ_IMP_DEVL_PROJECT
853: WHERE rec_status IS NULL
854: AND Run_ID = inRUN_ID
855: ORDER BY model_id,plan_level,ORIG_SYS_REF,NAME,ROWID;
856:

Line 865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;

861: x_onl_root_f BOOLEAN:=FALSE;
862: x_onl_child_f BOOLEAN:=FALSE;
863: x_error BOOLEAN:=FALSE;
864:
865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;

Line 866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;

862: x_onl_child_f BOOLEAN:=FALSE;
863: x_error BOOLEAN:=FALSE;
864:
865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

Line 867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;

863: x_error BOOLEAN:=FALSE;
864:
865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

Line 868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;

864:
865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

Line 869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;

865: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;
866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;

Line 870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

866: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;

Line 871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

867: onlName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

Line 872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

868: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;
869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

Line 873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;

869: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;
870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;

Line 874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;

870: sImpDevlProjId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

Line 875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;

871: sImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;

Line 876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

872: nImpIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;
880: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

Line 877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;

873: sImpDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;
880: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;
881: sConfigEngType CZ_IMP_DEVL_PROJECT.CONFIG_ENGINE_TYPE%TYPE;

Line 878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;

874: sOnlDescText CZ_IMP_DEVL_PROJECT.NAME%TYPE;
875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;

875: nImpModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%TYPE;
876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 880: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

876: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 881: sConfigEngType CZ_IMP_DEVL_PROJECT.CONFIG_ENGINE_TYPE%TYPE;

877: nImpName CZ_IMP_DEVL_PROJECT.NAME%TYPE;
878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 882: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;

878: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 883: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;

879: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%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;

Line 887: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_ID%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;
891: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

Line 888: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_ID%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;
891: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
892: nExplId NUMBER;

Line 889: sExplType CZ_IMP_DEVL_PROJECT.EXPLOSION_TYPE%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;
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;

Line 894: nModelType CZ_IMP_DEVL_PROJECT.MODEL_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;
896:
897: /* Internal vars */
898: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 895: sModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%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;
896:
897: /* Internal vars */
898: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
899: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 1229: UPDATE CZ_IMP_DEVL_PROJECT SET

1225: END IF;
1226: END IF;
1227:
1228:
1229: UPDATE CZ_IMP_DEVL_PROJECT SET
1230: DEVL_PROJECT_ID=DECODE(sDisposition,'R',DEVL_PROJECT_ID,nOnlDevlProjectId),
1231: PERSISTENT_PROJECT_ID=DECODE(sDisposition,'I',NVL(nPersistentProjectId,nOnlDevlProjectId),PERSISTENT_PROJECT_ID),
1232: INTL_TEXT_ID=DECODE(sDisposition,'R',INTL_TEXT_ID,nOnlIntlTextId),
1233: NAME=DECODE(sDisposition,'R',NAME,sName),

Line 1242: UPDATE CZ_IMP_DEVL_PROJECT SET

1238:
1239: /* If PTO is being changed to an ATO model, reject import of the model's parents and children */
1240: IF(nPlanLevel > 0 AND sDisposition = 'R' AND sRecStatus = 'N8')THEN
1241:
1242: UPDATE CZ_IMP_DEVL_PROJECT SET
1243: DISPOSITION=sDisposition,
1244: REC_STATUS=sRecStatus
1245: WHERE MODEL_ID = REFRESH_MODEL_ID;
1246:

Line 1301: orig_sys_ref, name, model_id, model_type, seeded_flag, ROWID FROM CZ_IMP_DEVL_PROJECT

1297: ) IS
1298:
1299: CURSOR c_imp_devl_project IS
1300: SELECT DELETED_FLAG, bom_caption_rule_id, nonbom_caption_rule_id,
1301: orig_sys_ref, name, model_id, model_type, seeded_flag, ROWID FROM CZ_IMP_DEVL_PROJECT
1302: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
1303: /* Internal vars */
1304: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
1305: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 1315: l_disposition cz_imp_devl_project.disposition%TYPE;

1311: p_imp_devl_project c_imp_devl_project%ROWTYPE;
1312: x_imp_devl_project_f BOOLEAN:=FALSE;
1313: l_msg VARCHAR2(2000);
1314: l_nbr NUMBER;
1315: l_disposition cz_imp_devl_project.disposition%TYPE;
1316: l_rec_status cz_imp_devl_project.rec_status%TYPE;
1317:
1318: FUNCTION is_rule_id_valid(p_id NUMBER, p_type NUMBER, p_orig_sys_ref IN VARCHAR2) RETURN BOOLEAN
1319: IS

Line 1316: l_rec_status cz_imp_devl_project.rec_status%TYPE;

1312: x_imp_devl_project_f BOOLEAN:=FALSE;
1313: l_msg VARCHAR2(2000);
1314: l_nbr NUMBER;
1315: l_disposition cz_imp_devl_project.disposition%TYPE;
1316: l_rec_status cz_imp_devl_project.rec_status%TYPE;
1317:
1318: FUNCTION is_rule_id_valid(p_id NUMBER, p_type NUMBER, p_orig_sys_ref IN VARCHAR2) RETURN BOOLEAN
1319: IS
1320: l_nbr number;

Line 1409: UPDATE CZ_IMP_DEVL_PROJECT SET

1405: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1406: END IF;
1407: END IF;
1408:
1409: UPDATE CZ_IMP_DEVL_PROJECT SET
1410: DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
1411: SEEDED_FLAG=DECODE(SEEDED_FLAG,NULL,'0',SEEDED_FLAG),
1412: DISPOSITION=l_disposition,
1413: REC_STATUS=l_rec_status

Line 1553: SELECT * FROM CZ_IMP_DEVL_PROJECT

1549: p_rp_folder_id IN NUMBER
1550: ) IS
1551:
1552: CURSOR c_xfr_devl_project IS
1553: SELECT * FROM CZ_IMP_DEVL_PROJECT
1554: WHERE Run_ID=inRUN_ID AND rec_status='PASS'
1555: ORDER BY model_id, plan_level;
1556:
1557: x_xfr_devl_project_f BOOLEAN:=FALSE;

Line 1636: -- check corectness of CZ_IMP_DEVL_PROJECT.config_engine_type

1632: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1633: END IF;
1634:
1635: --
1636: -- check corectness of CZ_IMP_DEVL_PROJECT.config_engine_type
1637: --
1638: IF inXFR_GROUP='GENERIC' THEN
1639: G_CONFIG_ENGINE_TYPE := p_xfr_devl_project.config_engine_type;
1640: IF p_xfr_devl_project.config_engine_type NOT IN('F', 'L') THEN

Line 1642: UPDATE cz_imp_devl_project

1638: IF inXFR_GROUP='GENERIC' THEN
1639: G_CONFIG_ENGINE_TYPE := p_xfr_devl_project.config_engine_type;
1640: IF p_xfr_devl_project.config_engine_type NOT IN('F', 'L') THEN
1641: ROLLBACK;
1642: UPDATE cz_imp_devl_project
1643: SET REC_STATUS='ERR'
1644: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1645: AND DISPOSITION=p_xfr_devl_project.disposition;
1646:

Line 1660: UPDATE cz_imp_devl_project

1656:
1657:
1658: IF (p_xfr_devl_project.disposition = 'N') THEN
1659:
1660: UPDATE cz_imp_devl_project
1661: SET REC_STATUS='OK'
1662: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID
1663: AND RUN_ID=inRUN_ID
1664: AND DISPOSITION='N';

Line 1701: UPDATE cz_imp_devl_project

1697: p_xfr_devl_project.bom_caption_rule_id, p_xfr_devl_project.nonbom_caption_rule_id, p_xfr_devl_project.config_engine_type, '1');
1698:
1699: nInsertCount:=nInsertCount+1;
1700:
1701: UPDATE cz_imp_devl_project
1702: SET REC_STATUS='OK'
1703: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1704: AND DISPOSITION='I';
1705:

Line 1758: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'

1754:
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757: FAILED:=FAILED +1;
1758: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1759: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1760: AND DISPOSITION='I';
1761: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:INSERT',11276,inRun_Id);
1762: END;

Line 1788: UPDATE cz_imp_devl_project

1784: IF(SQL%NOTFOUND) THEN
1785: FAILED:=FAILED+1;
1786: ELSE
1787: nUpdateCount:=nUpdateCount+1;
1788: UPDATE cz_imp_devl_project
1789: SET REC_STATUS='OK'
1790: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1791: AND DISPOSITION='M';
1792: END IF;

Line 1831: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'

1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: FAILED:=FAILED +1;
1830:
1831: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1832: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1833: AND DISPOSITION='M';
1834: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:UPDATE',11276,inRun_Id);
1835: END ;

Line 1864: FROM cz_imp_devl_project

1860: v_completed VARCHAR2(1) := '1';
1861:
1862: CURSOR c_xfr_run_result IS
1863: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1864: FROM cz_imp_devl_project
1865: WHERE RUN_ID = inRUN_ID
1866: GROUP BY DISPOSITION,REC_STATUS;
1867:
1868: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

Line 2290: SELECT model_type FROM cz_imp_devl_project

2286: WHERE ORIG_SYS_REF = sFSKREFERENCE
2287: AND RUN_ID=inRun_ID
2288: AND ps_node_id IS NOT NULL;
2289: CURSOR c_model_type IS
2290: SELECT model_type FROM cz_imp_devl_project
2291: WHERE devl_project_id = nDevlProjectId
2292: AND RUN_ID=inRun_ID;
2293: CURSOR c_onl_name IS
2294: SELECT name FROM cz_imp_devl_project

Line 2294: SELECT name FROM cz_imp_devl_project

2290: SELECT model_type FROM cz_imp_devl_project
2291: WHERE devl_project_id = nDevlProjectId
2292: AND RUN_ID=inRun_ID;
2293: CURSOR c_onl_name IS
2294: SELECT name FROM cz_imp_devl_project
2295: WHERE devl_project_id = nOnlDevlProjectId
2296: AND RUN_ID=inRun_ID;
2297: CURSOR c_onl_refpartnbr IS
2298: SELECT ref_part_nbr FROM cz_item_masters

Line 3067: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_DEVL_PROJECT');

3063:
3064: IF(genStatisticsCz = 1)THEN
3065: x_error:=cz_utils.log_report('Gather Stats : Start' ,1,'CZ_IMP_PS_NODE.XFR',11299,inRun_Id);
3066: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_PS_NODES');
3067: fnd_stats.gather_table_stats('CZ', 'CZ_IMP_DEVL_PROJECT');
3068: fnd_stats.gather_table_stats('CZ', 'CZ_PS_NODES');
3069: x_error:=cz_utils.log_report('Gather Stats : End' ,1,'CZ_IMP_PS_NODE.XFR',11299,inRun_Id);
3070:
3071: if (CZ_IMP_ALL.get_time) then

Line 3187: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

3183: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
3184: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
3185: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
3186: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
3187: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
3188: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3189: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
3190:
3191: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;

Line 3281: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS,cz_imp_devl_project d

3277: -- root nodes containing NO refs but ARE referenced, order by reference_id
3278: CURSOR C1 IS
3279: SELECT REFS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition, REFS.devl_project_id AS REFERRING_MODEL_ID,
3280: ROOTS.ps_node_type, ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, ROOTS.name, d.model_type
3281: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS,cz_imp_devl_project d
3282: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
3283: AND ROOTS.devl_project_id=REFS.reference_id
3284: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes
3285: WHERE run_id=inRUN_ID

Line 3303: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d

3299: CURSOR C2 IS
3300: SELECT REFS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition,
3301: REFS.devl_project_id AS REFERRING_MODEL_ID, ROOTS.ps_node_type,
3302: ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, ROOTS.name, d.model_type
3303: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d
3304: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
3305: AND ROOTS.ps_node_id = REFS.reference_id
3306: AND REFS.ps_node_type IN (cnReference,cnConnector)
3307: AND EXISTS (SELECT 1 FROM cz_imp_ps_nodes

Line 3325: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d

3321: -- root nodes that are NOT referenced but DO contain references to other models
3322: CURSOR C3 IS
3323: SELECT ROOTS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition,
3324: REFS.reference_id, ROOTS.ps_node_type, ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, d.model_type
3325: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d
3326: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
3327: AND ROOTS.ps_node_id = REFS.devl_project_id
3328: AND REFS.ps_node_type IN (cnReference,cnConnector)
3329: AND ROOTS.run_id=inRUN_ID

Line 3347: FROM cz_imp_ps_nodes p, cz_imp_devl_project d

3343: -- Remaining models if any (NOT referenced AND with NO references)
3344: CURSOR C4 IS
3345: SELECT p.plan_level, p.devl_project_id, p.ps_node_id, p.disposition,
3346: p.ps_node_type, p.minimum, p.maximum, p.rec_status, d.model_type
3347: FROM cz_imp_ps_nodes p, cz_imp_devl_project d
3348: WHERE p.run_id=inRUN_ID
3349: AND p.rec_status='PASS'
3350: AND (p.ps_node_id = p.devl_project_id OR (p.parent_id IS NULL AND p.plan_level=0))
3351: AND p.devl_project_id=d.devl_project_id

Line 3916: FROM cz_imp_devl_project

3912: x_retcode := 1;
3913:
3914: -- get model name for message log
3915: SELECT name INTO l_model_name
3916: FROM cz_imp_devl_project
3917: WHERE devl_project_id=p_model_id
3918: AND deleted_flag='0'
3919: AND run_id=inRun_ID
3920: AND rec_status='OK'

Line 3943: FROM cz_imp_devl_project

3939: AND DISPOSITION='I';
3940:
3941: -- get model name
3942: SELECT name INTO l_model_name
3943: FROM cz_imp_devl_project
3944: WHERE devl_project_id=p_model_id
3945: AND deleted_flag='0'
3946: AND run_id=inRun_ID
3947: AND rec_status='OK'

Line 4269: FROM cz_imp_devl_project

4265: AND DISPOSITION='M';
4266:
4267: -- get model name
4268: SELECT name INTO l_model_name
4269: FROM cz_imp_devl_project
4270: WHERE devl_project_id=p_model_id
4271: AND deleted_flag='0'
4272: AND run_id=inRun_ID
4273: AND rec_status='OK'

Line 4558: FROM cz_imp_devl_project

4554: l_c1_rec_status_tbl(i):='OK';
4555: COMMIT;
4556: -- get model name
4557: SELECT name INTO l_model_name
4558: FROM cz_imp_devl_project
4559: WHERE devl_project_id=l_c1_prj_id_tbl(i)
4560: AND deleted_flag='0'
4561: AND run_id=inRun_ID
4562: AND rec_status='OK'

Line 4704: FROM cz_imp_devl_project

4700: IF (l_retcode = 0) THEN
4701: l_c2_rec_status_tbl(i):='OK';
4702: COMMIT;
4703: SELECT name INTO l_model_name
4704: FROM cz_imp_devl_project
4705: WHERE devl_project_id=l_c2_prj_id_tbl(i)
4706: AND deleted_flag='0'
4707: AND run_id=inRun_ID
4708: AND rec_status='OK'

Line 4803: FROM cz_imp_devl_project

4799: IF (l_retcode = 0) THEN
4800: l_c3_rec_status_tbl(i):='OK';
4801: COMMIT;
4802: SELECT name INTO l_model_name
4803: FROM cz_imp_devl_project
4804: WHERE devl_project_id=l_c3_prj_id_tbl(i)
4805: AND deleted_flag='0'
4806: AND run_id=inRun_ID
4807: AND rec_status='OK'

Line 4836: UPDATE CZ_IMP_DEVL_PROJECT

4832: SET REC_STATUS='ERR'
4833: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4834: AND RUN_ID=inRUN_ID;
4835:
4836: UPDATE CZ_IMP_DEVL_PROJECT
4837: SET REC_STATUS='ERR'
4838: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4839: AND RUN_ID=inRUN_ID
4840: AND DISPOSITION=l_c1_dis_tbl(i);

Line 4866: UPDATE CZ_IMP_DEVL_PROJECT

4862: SET REC_STATUS=DECODE(l_c2_rec_status_tbl(i),'SKP','PASS',l_c2_rec_status_tbl(i))
4863: WHERE DEVL_PROJECT_ID=l_c2_prj_id_tbl(i)
4864: AND RUN_ID=inRUN_ID;
4865:
4866: UPDATE CZ_IMP_DEVL_PROJECT
4867: SET REC_STATUS=DECODE(l_c2_rec_status_tbl(i),'SKP','PASS',l_c2_rec_status_tbl(i))
4868: WHERE DEVL_PROJECT_ID=l_c2_prj_id_tbl(i)
4869: AND RUN_ID=inRUN_ID
4870: AND DISPOSITION=l_c2_dis_tbl(i);

Line 4896: UPDATE CZ_IMP_DEVL_PROJECT

4892: SET REC_STATUS=DECODE(l_c3_rec_status_tbl(i),'SKP','PASS',l_c3_rec_status_tbl(i))
4893: WHERE DEVL_PROJECT_ID=l_c3_prj_id_tbl(i)
4894: AND RUN_ID=inRUN_ID;
4895:
4896: UPDATE CZ_IMP_DEVL_PROJECT
4897: SET REC_STATUS=DECODE(l_C3_rec_status_tbl(i),'SKP','PASS',l_c3_rec_status_tbl(i))
4898: WHERE DEVL_PROJECT_ID=l_c3_prj_id_tbl(i)
4899: AND RUN_ID=inRUN_ID
4900: AND DISPOSITION=l_c3_dis_tbl(i);

Line 4983: FROM cz_imp_devl_project

4979: IF (l_retcode = 0) THEN
4980: l_c4_rec_status_tbl(i):='OK';
4981: COMMIT;
4982: SELECT name INTO l_model_name
4983: FROM cz_imp_devl_project
4984: WHERE devl_project_id=l_c4_prj_id_tbl(i)
4985: AND deleted_flag='0'
4986: AND run_id=inRun_ID
4987: AND rec_status='OK'

Line 5009: UPDATE CZ_IMP_DEVL_PROJECT

5005: SET REC_STATUS='ERR'
5006: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
5007: AND RUN_ID=inRUN_ID;
5008:
5009: UPDATE CZ_IMP_DEVL_PROJECT
5010: SET REC_STATUS='PASS'
5011: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
5012: AND RUN_ID=inRUN_ID
5013: AND DISPOSITION=l_c4_dis_tbl(i);

Line 5065: FROM cz_imp_devl_project

5061: AND RUN_ID=inRUN_ID
5062: AND DISPOSITION=l_dis(i);
5063:
5064: SELECT name INTO l_model_name
5065: FROM cz_imp_devl_project
5066: WHERE devl_project_id=l_DevlProjectId(i)
5067: AND deleted_flag='0'
5068: AND run_id=inRun_ID
5069: AND rec_status='OK'

Line 5086: FOR c_model IN (SELECT devl_project_id FROM cz_imp_devl_project

5082: -- Call update_node_depth explicitly due to it's removal from check_node procedure
5083: cz_refs.update_node_depth(NULL) ;
5084:
5085: --Fix for the bug #3040079. We need to call a new cz_refs procedure for every model we inserted.
5086: FOR c_model IN (SELECT devl_project_id FROM cz_imp_devl_project
5087: WHERE run_id = inRUN_ID
5088: AND rec_status = 'OK')LOOP
5089: cz_refs.populate_component_id(c_model.devl_project_id);
5090: END LOOP;