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 115: cz_imp_ps_nodes ip, cz_imp_devl_project id

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

Line 163: FROM cz_imp_devl_project

159: ELSE /* insert */
160:
161: BEGIN
162: SELECT devl_project_id INTO nModelId
163: FROM cz_imp_devl_project
164: WHERE orig_sys_ref = sImpFSKDevlProject(i)
165: AND run_id = inRUN_ID
166: AND rec_status = 'OK';
167:

Line 731: FROM CZ_IMP_DEVL_PROJECT

727: ) IS
728: CURSOR c_imp_devl_project IS
729: SELECT plan_level,orig_sys_ref,name,fsk_intltext_1_1,organization_id,
730: top_item_id,explosion_type,model_id,model_type, ROWID
731: FROM CZ_IMP_DEVL_PROJECT
732: WHERE rec_status IS NULL AND Run_ID = inRUN_ID
733: ORDER BY model_id,plan_level,ORIG_SYS_REF,NAME,ROWID;
734:
735: /* cursor's data found indicator */

Line 743: sOrigSysRef CZ_IMP_DEVL_PROJECT.ORIG_SYS_REF%TYPE;

739: x_onl_root_f BOOLEAN:=FALSE;
740: x_onl_child_f BOOLEAN:=FALSE;
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;

Line 744: sName CZ_IMP_DEVL_PROJECT.NAME%TYPE;

740: x_onl_child_f BOOLEAN:=FALSE;
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;

Line 746: sFskIntlText11 CZ_IMP_DEVL_PROJECT.FSK_INTLTEXT_1_1%TYPE;

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

Line 747: nPlanLevel CZ_IMP_DEVL_PROJECT.PLAN_LEVEL%TYPE;

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;
750: nPersistentProjectId CZ_IMP_DEVL_PROJECT.PERSISTENT_PROJECT_ID%TYPE;
751: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%TYPE;

Line 748: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%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;
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;

Line 749: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%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;
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;

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

Line 751: nOnlIntlTextId CZ_IMP_DEVL_PROJECT.INTL_TEXT_ID%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;
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;

Line 752: sRecStatus CZ_IMP_DEVL_PROJECT.REC_STATUS%TYPE;

748: nOnlDevlProjectId CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%TYPE;
749: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%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;

Line 753: sDisposition CZ_IMP_DEVL_PROJECT.DISPOSITION%TYPE;

749: REFRESH_MODEL_ID CZ_IMP_DEVL_PROJECT.DEVL_PROJECT_ID%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;

Line 755: nOrgId CZ_IMP_DEVL_PROJECT.ORGANIZATION_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;
759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;

Line 756: nTopId CZ_IMP_DEVL_PROJECT.TOP_ITEM_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;
759: sModelId CZ_DEVL_PROJECTS.DEVL_PROJECT_ID%TYPE;
760: nExplId NUMBER;

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

Line 762: nModelType CZ_IMP_DEVL_PROJECT.MODEL_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;
764:
765: /* Internal vars */
766: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */

Line 763: sModelType CZ_IMP_DEVL_PROJECT.MODEL_TYPE%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;
764:
765: /* Internal vars */
766: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
767: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 1018: UPDATE CZ_IMP_DEVL_PROJECT SET

1014: nOnlDevlProjectId:=nNextValue+nAllocateCounter;
1015: END IF;
1016: END IF;
1017:
1018: UPDATE CZ_IMP_DEVL_PROJECT SET
1019: DEVL_PROJECT_ID=DECODE(sDisposition,'R',DEVL_PROJECT_ID,nOnlDevlProjectId),
1020: PERSISTENT_PROJECT_ID=DECODE(sDisposition,'I',NVL(nPersistentProjectId,nOnlDevlProjectId),PERSISTENT_PROJECT_ID),
1021: INTL_TEXT_ID=DECODE(sDisposition,'R',INTL_TEXT_ID,nOnlIntlTextId),
1022: NAME=DECODE(sDisposition,'R',NAME,sName),

Line 1031: UPDATE CZ_IMP_DEVL_PROJECT SET

1027:
1028: /* If PTO is being changed to an ATO model, reject import of the model's parents and children */
1029: IF(nPlanLevel > 0 AND sDisposition = 'R' AND sRecStatus = 'N8')THEN
1030:
1031: UPDATE CZ_IMP_DEVL_PROJECT SET
1032: DISPOSITION=sDisposition,
1033: REC_STATUS=sRecStatus
1034: WHERE MODEL_ID = REFRESH_MODEL_ID;
1035:

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

1082: ) IS
1083:
1084: CURSOR c_imp_devl_project IS
1085: SELECT DELETED_FLAG, bom_caption_rule_id, nonbom_caption_rule_id,
1086: orig_sys_ref, name, model_id, model_type, seeded_flag, ROWID FROM CZ_IMP_DEVL_PROJECT
1087: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
1088: /* Internal vars */
1089: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
1090: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 1100: l_disposition cz_imp_devl_project.disposition%TYPE;

1096: p_imp_devl_project c_imp_devl_project%ROWTYPE;
1097: x_imp_devl_project_f BOOLEAN:=FALSE;
1098: l_msg VARCHAR2(2000);
1099: l_nbr NUMBER;
1100: l_disposition cz_imp_devl_project.disposition%TYPE;
1101: l_rec_status cz_imp_devl_project.rec_status%TYPE;
1102:
1103: FUNCTION is_rule_id_valid(p_id NUMBER, p_type NUMBER, p_orig_sys_ref IN VARCHAR2) RETURN BOOLEAN
1104: IS

Line 1101: l_rec_status cz_imp_devl_project.rec_status%TYPE;

1097: x_imp_devl_project_f BOOLEAN:=FALSE;
1098: l_msg VARCHAR2(2000);
1099: l_nbr NUMBER;
1100: l_disposition cz_imp_devl_project.disposition%TYPE;
1101: l_rec_status cz_imp_devl_project.rec_status%TYPE;
1102:
1103: FUNCTION is_rule_id_valid(p_id NUMBER, p_type NUMBER, p_orig_sys_ref IN VARCHAR2) RETURN BOOLEAN
1104: IS
1105: l_nbr number;

Line 1194: UPDATE CZ_IMP_DEVL_PROJECT SET

1190: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1191: END IF;
1192: END IF;
1193:
1194: UPDATE CZ_IMP_DEVL_PROJECT SET
1195: DELETED_FLAG=DECODE(DELETED_FLAG,NULL,'0',DELETED_FLAG),
1196: SEEDED_FLAG=DECODE(SEEDED_FLAG,NULL,'0',SEEDED_FLAG),
1197: DISPOSITION=l_disposition,
1198: REC_STATUS=l_rec_status

Line 1327: SELECT * FROM CZ_IMP_DEVL_PROJECT

1323: p_rp_folder_id IN NUMBER
1324: ) IS
1325:
1326: CURSOR c_xfr_devl_project IS
1327: SELECT * FROM CZ_IMP_DEVL_PROJECT
1328: WHERE Run_ID=inRUN_ID AND rec_status='PASS'
1329: ORDER BY model_id, plan_level;
1330:
1331: x_xfr_devl_project_f BOOLEAN:=FALSE;

Line 1409: -- check corectness of CZ_IMP_DEVL_PROJECT.config_engine_type

1405: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1406: END IF;
1407:
1408: --
1409: -- check corectness of CZ_IMP_DEVL_PROJECT.config_engine_type
1410: --
1411: IF inXFR_GROUP='GENERIC' THEN
1412: G_CONFIG_ENGINE_TYPE := p_xfr_devl_project.config_engine_type;
1413: IF p_xfr_devl_project.config_engine_type NOT IN('F', 'L') THEN

Line 1415: UPDATE cz_imp_devl_project

1411: IF inXFR_GROUP='GENERIC' THEN
1412: G_CONFIG_ENGINE_TYPE := p_xfr_devl_project.config_engine_type;
1413: IF p_xfr_devl_project.config_engine_type NOT IN('F', 'L') THEN
1414: ROLLBACK;
1415: UPDATE cz_imp_devl_project
1416: SET REC_STATUS='ERR'
1417: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1418: AND DISPOSITION=p_xfr_devl_project.disposition;
1419:

Line 1452: UPDATE cz_imp_devl_project

1448: p_xfr_devl_project.bom_caption_rule_id, p_xfr_devl_project.nonbom_caption_rule_id, p_xfr_devl_project.config_engine_type);
1449:
1450: nInsertCount:=nInsertCount+1;
1451:
1452: UPDATE cz_imp_devl_project
1453: SET REC_STATUS='OK'
1454: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1455: AND DISPOSITION='I';
1456:

Line 1509: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'

1505:
1506: EXCEPTION
1507: WHEN OTHERS THEN
1508: FAILED:=FAILED +1;
1509: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1510: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1511: AND DISPOSITION='I';
1512: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:INSERT',11276,inRun_Id);
1513: END;

Line 1539: UPDATE cz_imp_devl_project

1535: IF(SQL%NOTFOUND) THEN
1536: FAILED:=FAILED+1;
1537: ELSE
1538: nUpdateCount:=nUpdateCount+1;
1539: UPDATE cz_imp_devl_project
1540: SET REC_STATUS='OK'
1541: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1542: AND DISPOSITION='M';
1543: END IF;

Line 1582: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'

1578: EXCEPTION
1579: WHEN OTHERS THEN
1580: FAILED:=FAILED +1;
1581:
1582: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1583: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1584: AND DISPOSITION='M';
1585: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:UPDATE',11276,inRun_Id);
1586: END ;

Line 1614: FROM cz_imp_devl_project

1610: v_completed VARCHAR2(1) := '1';
1611:
1612: CURSOR c_xfr_run_result IS
1613: SELECT DISPOSITION,REC_STATUS,COUNT(*)
1614: FROM cz_imp_devl_project
1615: WHERE RUN_ID = inRUN_ID
1616: GROUP BY DISPOSITION,REC_STATUS;
1617:
1618: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

Line 1937: SELECT model_type FROM cz_imp_devl_project

1933: WHERE ORIG_SYS_REF = sFSKREFERENCE
1934: AND RUN_ID=inRun_ID
1935: AND ps_node_id IS NOT NULL;
1936: CURSOR c_model_type IS
1937: SELECT model_type FROM cz_imp_devl_project
1938: WHERE devl_project_id = nDevlProjectId
1939: AND RUN_ID=inRun_ID;
1940: CURSOR c_onl_name IS
1941: SELECT name FROM cz_imp_devl_project

Line 1941: SELECT name FROM cz_imp_devl_project

1937: SELECT model_type FROM cz_imp_devl_project
1938: WHERE devl_project_id = nDevlProjectId
1939: AND RUN_ID=inRun_ID;
1940: CURSOR c_onl_name IS
1941: SELECT name FROM cz_imp_devl_project
1942: WHERE devl_project_id = nOnlDevlProjectId
1943: AND RUN_ID=inRun_ID;
1944: CURSOR c_onl_refpartnbr IS
1945: SELECT ref_part_nbr FROM cz_item_masters

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

2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;

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

2843: -- root nodes containing NO refs but ARE referenced, order by reference_id
2844: CURSOR C1 IS
2845: SELECT REFS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition, REFS.devl_project_id AS REFERRING_MODEL_ID,
2846: ROOTS.ps_node_type, ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, ROOTS.name, d.model_type
2847: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS,cz_imp_devl_project d
2848: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
2849: AND ROOTS.devl_project_id=REFS.reference_id
2850: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes
2851: WHERE run_id=inRUN_ID

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

2865: CURSOR C2 IS
2866: SELECT REFS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition,
2867: REFS.devl_project_id AS REFERRING_MODEL_ID, ROOTS.ps_node_type,
2868: ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, ROOTS.name, d.model_type
2869: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d
2870: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
2871: AND ROOTS.ps_node_id = REFS.reference_id
2872: AND REFS.ps_node_type IN (cnReference,cnConnector)
2873: AND EXISTS (SELECT 1 FROM cz_imp_ps_nodes

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

2887: -- root nodes that are NOT referenced but DO contain references to other models
2888: CURSOR C3 IS
2889: SELECT ROOTS.plan_level, ROOTS.devl_project_id, ROOTS.ps_node_id, ROOTS.disposition,
2890: REFS.reference_id, ROOTS.ps_node_type, ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, d.model_type
2891: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d
2892: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
2893: AND ROOTS.ps_node_id = REFS.devl_project_id
2894: AND REFS.ps_node_type IN (cnReference,cnConnector)
2895: AND ROOTS.run_id=inRUN_ID

Line 2913: FROM cz_imp_ps_nodes p, cz_imp_devl_project d

2909: -- Remaining models if any (NOT referenced AND with NO references)
2910: CURSOR C4 IS
2911: SELECT p.plan_level, p.devl_project_id, p.ps_node_id, p.disposition,
2912: p.ps_node_type, p.minimum, p.maximum, p.rec_status, d.model_type
2913: FROM cz_imp_ps_nodes p, cz_imp_devl_project d
2914: WHERE p.run_id=inRUN_ID
2915: AND p.rec_status='PASS'
2916: AND (p.ps_node_id = p.devl_project_id OR (p.parent_id IS NULL AND p.plan_level=0))
2917: AND p.devl_project_id=d.devl_project_id

Line 3482: FROM cz_imp_devl_project

3478: x_retcode := 1;
3479:
3480: -- get model name for message log
3481: SELECT name INTO l_model_name
3482: FROM cz_imp_devl_project
3483: WHERE devl_project_id=p_model_id
3484: AND deleted_flag='0'
3485: AND run_id=inRun_ID
3486: AND rec_status='OK'

Line 3509: FROM cz_imp_devl_project

3505: AND DISPOSITION='I';
3506:
3507: -- get model name
3508: SELECT name INTO l_model_name
3509: FROM cz_imp_devl_project
3510: WHERE devl_project_id=p_model_id
3511: AND deleted_flag='0'
3512: AND run_id=inRun_ID
3513: AND rec_status='OK'

Line 3835: FROM cz_imp_devl_project

3831: AND DISPOSITION='M';
3832:
3833: -- get model name
3834: SELECT name INTO l_model_name
3835: FROM cz_imp_devl_project
3836: WHERE devl_project_id=p_model_id
3837: AND deleted_flag='0'
3838: AND run_id=inRun_ID
3839: AND rec_status='OK'

Line 4112: FROM cz_imp_devl_project

4108: l_c1_rec_status_tbl(i):='OK';
4109: COMMIT;
4110: -- get model name
4111: SELECT name INTO l_model_name
4112: FROM cz_imp_devl_project
4113: WHERE devl_project_id=l_c1_prj_id_tbl(i)
4114: AND deleted_flag='0'
4115: AND run_id=inRun_ID
4116: AND rec_status='OK'

Line 4258: FROM cz_imp_devl_project

4254: IF (l_retcode = 0) THEN
4255: l_c2_rec_status_tbl(i):='OK';
4256: COMMIT;
4257: SELECT name INTO l_model_name
4258: FROM cz_imp_devl_project
4259: WHERE devl_project_id=l_c2_prj_id_tbl(i)
4260: AND deleted_flag='0'
4261: AND run_id=inRun_ID
4262: AND rec_status='OK'

Line 4357: FROM cz_imp_devl_project

4353: IF (l_retcode = 0) THEN
4354: l_c3_rec_status_tbl(i):='OK';
4355: COMMIT;
4356: SELECT name INTO l_model_name
4357: FROM cz_imp_devl_project
4358: WHERE devl_project_id=l_c3_prj_id_tbl(i)
4359: AND deleted_flag='0'
4360: AND run_id=inRun_ID
4361: AND rec_status='OK'

Line 4390: UPDATE CZ_IMP_DEVL_PROJECT

4386: SET REC_STATUS='ERR'
4387: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4388: AND RUN_ID=inRUN_ID;
4389:
4390: UPDATE CZ_IMP_DEVL_PROJECT
4391: SET REC_STATUS='ERR'
4392: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4393: AND RUN_ID=inRUN_ID
4394: AND DISPOSITION=l_c1_dis_tbl(i);

Line 4420: UPDATE CZ_IMP_DEVL_PROJECT

4416: SET REC_STATUS=DECODE(l_c2_rec_status_tbl(i),'SKP','PASS',l_c2_rec_status_tbl(i))
4417: WHERE DEVL_PROJECT_ID=l_c2_prj_id_tbl(i)
4418: AND RUN_ID=inRUN_ID;
4419:
4420: UPDATE CZ_IMP_DEVL_PROJECT
4421: SET REC_STATUS=DECODE(l_c2_rec_status_tbl(i),'SKP','PASS',l_c2_rec_status_tbl(i))
4422: WHERE DEVL_PROJECT_ID=l_c2_prj_id_tbl(i)
4423: AND RUN_ID=inRUN_ID
4424: AND DISPOSITION=l_c2_dis_tbl(i);

Line 4450: UPDATE CZ_IMP_DEVL_PROJECT

4446: SET REC_STATUS=DECODE(l_c3_rec_status_tbl(i),'SKP','PASS',l_c3_rec_status_tbl(i))
4447: WHERE DEVL_PROJECT_ID=l_c3_prj_id_tbl(i)
4448: AND RUN_ID=inRUN_ID;
4449:
4450: UPDATE CZ_IMP_DEVL_PROJECT
4451: SET REC_STATUS=DECODE(l_C3_rec_status_tbl(i),'SKP','PASS',l_c3_rec_status_tbl(i))
4452: WHERE DEVL_PROJECT_ID=l_c3_prj_id_tbl(i)
4453: AND RUN_ID=inRUN_ID
4454: AND DISPOSITION=l_c3_dis_tbl(i);

Line 4537: FROM cz_imp_devl_project

4533: IF (l_retcode = 0) THEN
4534: l_c4_rec_status_tbl(i):='OK';
4535: COMMIT;
4536: SELECT name INTO l_model_name
4537: FROM cz_imp_devl_project
4538: WHERE devl_project_id=l_c4_prj_id_tbl(i)
4539: AND deleted_flag='0'
4540: AND run_id=inRun_ID
4541: AND rec_status='OK'

Line 4563: UPDATE CZ_IMP_DEVL_PROJECT

4559: SET REC_STATUS='ERR'
4560: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
4561: AND RUN_ID=inRUN_ID;
4562:
4563: UPDATE CZ_IMP_DEVL_PROJECT
4564: SET REC_STATUS='PASS'
4565: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
4566: AND RUN_ID=inRUN_ID
4567: AND DISPOSITION=l_c4_dis_tbl(i);

Line 4619: FROM cz_imp_devl_project

4615: AND RUN_ID=inRUN_ID
4616: AND DISPOSITION=l_dis(i);
4617:
4618: SELECT name INTO l_model_name
4619: FROM cz_imp_devl_project
4620: WHERE devl_project_id=l_DevlProjectId(i)
4621: AND deleted_flag='0'
4622: AND run_id=inRun_ID
4623: AND rec_status='OK'

Line 4635: FOR c_model IN (SELECT devl_project_id FROM cz_imp_devl_project

4631: END LOOP;
4632: END IF;
4633:
4634: --Fix for the bug #3040079. We need to call a new cz_refs procedure for every model we inserted.
4635: FOR c_model IN (SELECT devl_project_id FROM cz_imp_devl_project
4636: WHERE run_id = inRUN_ID
4637: AND rec_status = 'OK')LOOP
4638: cz_refs.populate_component_id(c_model.devl_project_id);
4639: END LOOP;