[Home] [Help]
1: PACKAGE BODY CZ_IMP_PS_NODE as
2: /* $Header: czipsnb.pls 120.16.12020000.2 2012/08/17 15:04:42 smanna ship $ */
3:
4: CAPTION_RULE_TYPE CONSTANT NUMBER:=700;
5: JAVA_SYS_PROP_RULE_TYPE CONSTANT NUMBER:=501;
114: FOR I in 1..sImpOrigSysRef.COUNT LOOP
115:
116: /* Return if MAX_ERR is reached */
117: IF(FAILED >= MAX_ERR) THEN
118: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT:MAX',11276,inRun_Id);
119: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
120: END IF;
121:
122: DECLARE
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
166: FETCH c_imp_local_str INTO nImpIntlText;
167: CLOSE c_imp_local_str;
168: EXCEPTION
169: WHEN OTHERS THEN
170: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT.LOCAL_STR',11276,inRun_Id);
171: RAISE;
172: END;
173:
174: IF (nImpIntlText = nOnlIntlText) THEN
192: AND fsk_devlproject_1_1=sImpFSKDevlProject(i)
193: AND language=nOnlLang;
194:
195:
196: UPDATE CZ_IMP_PS_NODES
197: SET INTL_TEXT_ID =nOnlIntlTextId
198: WHERE fsk_intltext_1_1 = sImpOrigSysRef(i)
199: AND fsk_devlproject_5_1 = sImpFSKDevlProject(i)
200: AND RUN_ID = inRUN_ID;
232: WHERE orig_sys_ref = sImpOrigSysRef(i)
233: AND fsk_devlproject_1_1 = sImpFSKDevlProject(i)
234: AND run_id = inRUN_ID;
235:
236: UPDATE CZ_IMP_PS_NODES
237: SET INTL_TEXT_ID =nNextId
238: WHERE fsk_intltext_1_1 = sImpOrigSysRef(i)
239: AND fsk_devlproject_5_1 = sImpFSKDevlProject(i)
240: AND RUN_ID = inRUN_ID;
311: FETCH c_imp_local_str2 INTO nImpLocStr;
312: CLOSE c_imp_local_str2;
313: EXCEPTION
314: WHEN OTHERS THEN
315: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT.LOCAL_STR2',11276,inRun_Id);
316: RAISE;
317: END;
318:
319: IF (nOnlIntlTextId = nImpLocStr) THEN
415: RAISE;
416: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
417: RAISE;
418: WHEN OTHERS THEN
419: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT',11276,inRun_Id);
420: RAISE;
421: END KRS_INTL_TEXT;
422: ------------------------------------------------------------------------------
423: PROCEDURE CND_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
480: WHERE orig_sys_ref = l_orig_sys_ref_tbl(i) AND run_id = inRUN_ID;
481: COMMIT;
482: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_INTLTXT_FAIL',
483: 'COUNT' , SQL%ROWCOUNT);
484: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
485: FAILED := FAILED + SQL%ROWCOUNT;
486:
487: /* Return if MAX_ERR is reached */
488: IF(FAILED >= MAX_ERR) THEN
486:
487: /* Return if MAX_ERR is reached */
488: IF(FAILED >= MAX_ERR) THEN
489: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,
490: 'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
491: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
492: END IF;
493: END IF;
494: END LOOP;
505: RAISE;
506: WHEN OTHERS THEN
507: IF l_csr_1%ISOPEN THEN CLOSE l_csr_1; END IF;
508: IF l_csr_2%ISOPEN THEN CLOSE l_csr_2; END IF;
509: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
510: RAISE;
511: END CND_INTL_TEXT;
512: ------------------------------------------------------------------------------
513: PROCEDURE MAIN_INTL_TEXT(inRUN_ID IN PLS_INTEGER,
551: WHEN NO_DATA_FOUND THEN
552: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
553: VALUES(inRUN_ID,SYSDATE,SYSDATE);
554: WHEN OTHERS THEN
555: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:RUNID',11276,inRun_Id);
556: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
557: END;
558:
559: if (CZ_IMP_ALL.get_time) then
585: end if;
586:
587: /* Report Insert Errors */
588: IF(nXfrInsertCount<> INSERTS) THEN
589: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:INSERTS ',11276,inRun_Id);
590: END IF;
591: /* Report Update Errors */
592: IF(nXfrUpdateCount<> UPDATES) THEN
593: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:UPDATES ',11276,inRun_Id);
589: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:INSERTS ',11276,inRun_Id);
590: END IF;
591: /* Report Update Errors */
592: IF(nXfrUpdateCount<> UPDATES) THEN
593: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:UPDATES ',11276,inRun_Id);
594: END IF;
595: /* Report NoChange Errors */
596: IF(nNoChangeCount<> NOCHANGE) THEN
597: x_error:=CZ_UTILS.LOG_REPORT('No Change count: Key resolution - ' || to_char(NOCHANGE) || ', Actual-' || to_char(nNoChangeCount),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:NOCHANGE ',11276,inRun_Id);
593: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:UPDATES ',11276,inRun_Id);
594: END IF;
595: /* Report NoChange Errors */
596: IF(nNoChangeCount<> NOCHANGE) THEN
597: x_error:=CZ_UTILS.LOG_REPORT('No Change count: Key resolution - ' || to_char(NOCHANGE) || ', Actual-' || to_char(nNoChangeCount),1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:NOCHANGE ',11276,inRun_Id);
598: END IF;
599:
600: /* Return the transferred number of rows and not the number of rows with keys resolved */
601: INSERTS:=nXfrInsertCount;
600: /* Return the transferred number of rows and not the number of rows with keys resolved */
601: INSERTS:=nXfrInsertCount;
602: UPDATES:=nXfrUpdateCount;
603:
604: CZ_IMP_PS_NODE.RPT_INTL_TEXT(inRUN_ID);
605:
606: END MAIN_INTL_TEXT;
607: ------------------------------------------------------------------------------
608:
676: EXIT WHEN NOT x_xfr_intl_text_f;
677:
678: IF(FAILED >= MAX_ERR) THEN
679: ROLLBACK;
680: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:MAX',11276,inRun_Id);
681: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
682: END IF;
683:
684: IF(p_xfr_intl_text.disposition = 'I') THEN
711: FAILED:=FAILED +1;
712: UPDATE cz_imp_localized_texts
713: SET REC_STATUS='ERR'
714: WHERE ROWID = p_xfr_intl_text.ROWID;
715: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:INSERT',11276,inRun_Id);
716: END;
717: ELSIF(p_xfr_intl_text.disposition = 'M') THEN
718: BEGIN
719: UPDATE cz_localized_texts SET
740: FAILED:=FAILED +1;
741: UPDATE cz_imp_localized_texts
742: SET REC_STATUS='ERR'
743: WHERE ROWID = p_xfr_intl_text.ROWID;
744: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:UPDATE',11276,inRun_Id);
745: END;
746:
747: ELSIF(p_xfr_intl_text.disposition = 'N') THEN -- Setting record status to ok
748: UPDATE cz_imp_localized_texts
762: RAISE;
763: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
764: RAISE;
765: WHEN OTHERS THEN
766: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT',11276,inRun_Id);
767: RAISE;
768: END XFR_INTL_TEXT;
769:
770: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
819: WHERE RUN_ID=inRUN_ID;
820: COMMIT;
821: EXCEPTION
822: WHEN OTHERS THEN
823: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);
824: END;
825: EXCEPTION
826: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
827: RAISE;
827: RAISE;
828: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
829: RAISE;
830: WHEN OTHERS THEN
831: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);
832: RAISE;
833: END;
834: /*--INTL_TEXT IMPORT SECTION END--------------------------------------------*/
835:
1029: l_err_msg := 'For ORIG_SYS_REF = ' || sOrigSysRef
1030: || ', multiple copies of the model with different engine type exists in the repository.'
1031: || ' Please set DisableMultipleCopyImport setting to Yes/True and enable appropriate model/s for the Import.';
1032:
1033: xERROR:=cz_utils.log_report(l_err_msg,1,'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT',11276,inRUN_ID);
1034:
1035: RAISE IMP_CHILD_MULTI_COPIES ;
1036: END IF;
1037:
1190:
1191: IF(sModelType = 'N' AND nModelType <> 'N')THEN
1192:
1193: --'The Configuration Model Type for ''%MODELNAME'' has changed from ''Container'' to ''Standard''.'
1194: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_CONTAINER_REFRESH', 'MODELNAME', sName), 1, 'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT ', 11276,inRun_Id);
1195: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING, CZ_UTILS.GET_TEXT('CZ_IMP_CONTAINER_REFRESH', 'MODELNAME', sName));
1196: END IF;
1197:
1198: -- Don't update model_type if it is 'P'
1204: if (nInstances > 0) then
1205: begin
1206: sModeltype := 'P';
1207: /*If the model has multiple instances, then do not refresh this or its parent model */
1208: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_CANNOT_REFRESH_PTO', 'MODELNAME', sName), 1, 'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT ', 11276,inRun_Id);
1209: sRecStatus := 'N8';
1210: sDisposition := 'R';
1211: end;
1212: else sModelType := nModelType; end if;
1250: END IF;
1251:
1252: IF(sDisposition<>'R')THEN
1253:
1254: UPDATE CZ_IMP_PS_NODES SET
1255: DEVL_PROJECT_ID=nOnlDevlProjectId
1256: WHERE fsk_devlproject_5_1 = sOrigSysRef
1257: AND RUN_ID=inRUN_ID;
1258:
1259: END IF;
1260:
1261: /* Return if MAX_ERR is reached */
1262: IF(FAILED >= MAX_ERR) THEN
1263: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT:MAX',11276,inRun_Id);
1264: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1265: END IF;
1266: sDisposition:=NULL; sRecStatus:=NULL;dispositionflag:=0;
1267:
1285: RAISE;
1286: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1287: RAISE;
1288: WHEN OTHERS THEN
1289: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT',11276,inRun_Id);
1290: RAISE;
1291: END KRS_DEVL_PROJECT;
1292: ------------------------------------------------------------------------------
1293: PROCEDURE CND_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
1353:
1354: EXIT WHEN NOT x_imp_devl_project_f;
1355:
1356: IF(FAILED >= MAX_ERR) THEN
1357: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT:MAX',11276,inRun_Id);
1358: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1359: END IF;
1360: -- only seeded models from contracts can be imported
1361: IF (p_imp_devl_project.seeded_flag = '1' AND NOT gContractsModel) THEN
1364: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_SEEDED_FLG',
1365: 'MODELNAME', p_imp_devl_project.name,
1366: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1367: );
1368: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1369: END IF;
1370: -- validate only for generic import, for BOM we populate during extraction so no need for validation
1371: IF (p_imp_devl_project.bom_caption_rule_id IS NOT NULL AND p_imp_devl_project.model_type NOT IN ('A', 'P', 'N')) THEN
1372: IF NOT (is_rule_id_valid(p_imp_devl_project.bom_caption_rule_id,
1382: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_BOM_CPTN_RULE',
1383: 'MODELNAME', p_imp_devl_project.name,
1384: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1385: );
1386: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1387: END IF;
1388: END IF;
1389: -- validate only for generic import, for BOM we populate during extraction so no need for validation
1390: IF (p_imp_devl_project.nonbom_caption_rule_id IS NOT NULL AND p_imp_devl_project.model_type NOT IN ('A', 'P', 'N')) THEN
1401: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_NONBOM_CPTN_RULE',
1402: 'MODELNAME', p_imp_devl_project.name,
1403: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1404: );
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
1428: RAISE;
1429: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1430: RAISE;
1431: WHEN OTHERS THEN
1432: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1433: RAISE;
1434: END CND_DEVL_PROJECT;
1435: ------------------------------------------------------------------------------
1436: PROCEDURE MAIN_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,
1515: end if;
1516:
1517: /* Report Insert Errors */
1518: IF(nXfrInsertCount<> INSERTS) THEN
1519: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:INSERTS ',11276,inRun_Id);
1520: END IF;
1521: /* Report Update Errors */
1522: IF(nXfrUpdateCount<> UPDATES) THEN
1523: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:UPDATES ',11276,inRun_Id);
1519: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_INSERTERRORS','RESOLVED',to_char(INSERTS),'ACTUAL',to_char(nXfrInsertCount)),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:INSERTS ',11276,inRun_Id);
1520: END IF;
1521: /* Report Update Errors */
1522: IF(nXfrUpdateCount<> UPDATES) THEN
1523: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:UPDATES ',11276,inRun_Id);
1524: END IF;
1525: /* Report NoChange Errors */
1526: IF(nNoChangeCount<> NOCHANGE) THEN
1527: x_error:=CZ_UTILS.LOG_REPORT('No Change count: Key resolution - ' || to_char(NOCHANGE) || ', Actual-' || to_char(nNoChangeCount),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:NOCHANGE ',11276,inRun_Id);
1523: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_UPDATEERRORS','RESOLVED',to_char(UPDATES),'ACTUAL',to_char(nXfrUpdateCount)),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:UPDATES ',11276,inRun_Id);
1524: END IF;
1525: /* Report NoChange Errors */
1526: IF(nNoChangeCount<> NOCHANGE) THEN
1527: x_error:=CZ_UTILS.LOG_REPORT('No Change count: Key resolution - ' || to_char(NOCHANGE) || ', Actual-' || to_char(nNoChangeCount),1,'CZ_IMP_PS_NODE.MAIN_DEVL_PROJECT:NOCHANGE ',11276,inRun_Id);
1528: END IF;
1529:
1530: /* Return the transferred number of rows and not the number of rows with keys resolved */
1531: INSERTS:=nXfrInsertCount;
1530: /* Return the transferred number of rows and not the number of rows with keys resolved */
1531: INSERTS:=nXfrInsertCount;
1532: UPDATES:=nXfrUpdateCount;
1533:
1534: CZ_IMP_PS_NODE.RPT_DEVL_PROJECT(inRUN_ID);
1535:
1536: EXCEPTION
1537: WHEN IMP_CHILD_MULTI_COPIES THEN
1538: RAISE;
1627: EXIT WHEN NOT x_xfr_devl_project_f;
1628:
1629: IF(FAILED >= MAX_ERR) THEN
1630: ROLLBACK;
1631: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:MAX',11276,inRun_Id);
1632: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1633: END IF;
1634:
1635: --
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:
1647: x_error:=CZ_UTILS.LOG_REPORT('Incorrect value of config_engine_type="'||p_xfr_devl_project.config_engine_type||'"',1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:INSERT',11276,inRun_Id);
1648: COMMIT;
1649:
1650: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1651:
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;
1763:
1764: ELSIF(p_xfr_devl_project.disposition = 'M') THEN
1765: BEGIN
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 ;
1836: END IF;
1837: END LOOP;
1838:
1846: RAISE;
1847: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1848: RAISE;
1849: WHEN OTHERS THEN
1850: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT',11276,inRun_Id);
1851: RAISE;
1852: END XFR_DEVL_PROJECT;
1853:
1854: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
1903: WHERE RUN_ID=inRUN_ID;
1904: COMMIT;
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);
1908: END;
1909: EXCEPTION
1910: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1911: RAISE;
1911: RAISE;
1912: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1913: RAISE;
1914: WHEN OTHERS THEN
1915: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);
1916: RAISE;
1917: END;
1918: /*--DEVL_PROJECT IMPORT SECTION END-----------------------------------------*/
1919:
1951: SO_ITEM_TYPE_CODE,MINIMUM_SELECTED,MAXIMUM_SELECTED,EFFECTIVE_FROM,EFFECTIVE_UNTIL,
1952: DECIMAL_QTY_FLAG,PRIMARY_UOM_CODE,BOM_SORT_ORDER,IB_TRACKABLE,
1953: INITIAL_NUM_VALUE,SHIPPABLE_ITEM_FLAG,INVENTORY_TRANSACTABLE_FLAG,
1954: SERIALIZABLE_ITEM_FLAG
1955: FROM CZ_IMP_PS_NODES WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
1956: ORDER BY PLAN_LEVEL,
1957: DECODE(x_usesurr_psnode,0,ORIG_SYS_REF,1,USER_STR03),
1958: DECODE(x_usesurr_intltext,0,FSK_INTLTEXT_1_1,1,FSK_INTLTEXT_1_EXT),
1959: DECODE(x_usesurr_itemmaster,0,FSK_ITEMMASTER_2_1,1,FSK_ITEMMASTER_2_EXT),
1970: x_onl_devlprj_devlprjid_f BOOLEAN:=FALSE;
1971: x_onl_reference_f BOOLEAN:=FALSE;
1972: x_error BOOLEAN:=FALSE;
1973: x_project_f BOOLEAN:=FALSE;
1974: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1971: x_onl_reference_f BOOLEAN:=FALSE;
1972: x_error BOOLEAN:=FALSE;
1973: x_project_f BOOLEAN:=FALSE;
1974: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1972: x_error BOOLEAN:=FALSE;
1973: x_project_f BOOLEAN:=FALSE;
1974: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1973: x_project_f BOOLEAN:=FALSE;
1974: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1974: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1975: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1976: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1977: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1978: nOnlOrigSysRef CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1979: nImpIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1980: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1981: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1982: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1983: nImpItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1984: nOnlMax CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1985: nOnlMin CZ_IMP_PS_NODES.MINIMUM%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1986: nOnlTreeSeq CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1987: nImpTreeSequence CZ_IMP_PS_NODES.TREE_SEQ%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1988: nOnlName CZ_IMP_PS_NODES.NAME%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1989: nImpName CZ_IMP_PS_NODES.NAME%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1990: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1991: nOnlInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1992: nImpInitialValue CZ_IMP_PS_NODES.INITIAL_VALUE%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
1993: nOnlInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
1994: nImpInitialNumValue CZ_IMP_PS_NODES.initial_num_value%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
1995: nOnlPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
1996: nOnlProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
1997: nImpProductFlag CZ_IMP_PS_NODES.PRODUCT_FLAG%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
1998: nOnlReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
1999: nImpReferenceId CZ_IMP_PS_NODES.REFERENCE_ID%TYPE;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2000: nOnlSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2001: nImpSystemNodeFlag CZ_IMP_PS_NODES.SYSTEM_NODE_FLAG%TYPE;
2002: nOnlBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2003: nImpBomTreatment CZ_IMP_PS_NODES.BOM_TREATMENT%TYPE;
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2004: nOnlEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2005: nImpEffFrom CZ_IMP_PS_NODES.EFFECTIVE_FROM%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2006: nOnlEffUntil CZ_PS_NODES.EFFECTIVE_UNTIL%type;
2007: nImpEffUntil CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2008: nEffUntilCap CZ_IMP_PS_NODES.EFFECTIVE_UNTIL%type;
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2009: nOnlSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2010: nImpSoItemTypeCode CZ_IMP_PS_NODES.SO_ITEM_TYPE_CODE%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2011:
2012: nOnlMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2013: nImpMinSel CZ_IMP_PS_NODES.MINIMUM_SELECTED%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2014: nOnlMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2015: nImpMaxSel CZ_IMP_PS_NODES.MAXIMUM_SELECTED%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2016:
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2017: nOnlBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2018: nImpBomReqFlag CZ_IMP_PS_NODES.BOM_REQUIRED%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2019: nOnlCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2020: nImpCompSeqId CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_ID%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2021: nOnlDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2022: nImpDecQtyFlag CZ_IMP_PS_NODES.DECIMAL_QTY_FLAG%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2023: nOnlPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2024: nImpPriUOMCode CZ_IMP_PS_NODES.PRIMARY_UOM_CODE%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2025: nOnlBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2026: nImpBOMSortOrder CZ_IMP_PS_NODES.BOM_SORT_ORDER%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2027: nOnlCompSeqPath CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2028: nOnlIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2029: nImpIBTrack CZ_IMP_PS_NODES.IB_TRACKABLE%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2030: nOnlSrcAppId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2031: nOnlShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2032: nImpShipItemFlag CZ_IMP_PS_NODES.SHIPPABLE_ITEM_FLAG%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2033: nOnlInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2034: nImpInvTransFlag CZ_IMP_PS_NODES.INVENTORY_TRANSACTABLE_FLAG%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2035: nOnlSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2036: nImpSerItemFlag CZ_IMP_PS_NODES.SERIALIZABLE_ITEM_FLAG%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2037: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2038: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2039: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2040: localName CZ_IMP_PS_NODES.NAME%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2041: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2042: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2043: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2044: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2045: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2046: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2047: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2048: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2049: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2050: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2051: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2052: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2053: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
2054: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
2062: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
2055: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
2062: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
2063: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2056: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
2057: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
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;
2058: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
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;
2059: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
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;
2060: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
2061:
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
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;
2072:
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%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;
2072:
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2074:
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;
2072:
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2074:
2075:
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;
2072:
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2074:
2075:
2076: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
2077: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
2072:
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2074:
2075:
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;
2073: nOnlDevlProjectId2 CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
2074:
2075:
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;
2074:
2075:
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:
2075:
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 */
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 */
2085: nErrorCount PLS_INTEGER:=0; /*Error index */
2230:
2231: /* Check that the Online data exists for the 3 FSK */
2232: DECLARE
2233: CURSOR c_onl_psnode_parentid IS
2234: SELECT PS_NODE_ID, PLAN_LEVEL FROM CZ_IMP_PS_NODES WHERE ORIG_SYS_REF=DECODE(x_usesurr_psnode, 0, sFSKPSNODE31, 1, sFSKPSNODE3EXT)
2235: AND DEVL_PROJECT_ID=nDevlProjectId AND RUN_ID=inRUN_ID
2236: AND ps_node_id IS NOT NULL
2237: AND src_application_id = nImpSrcApplicationId
2238: AND NVL(COMPONENT_SEQUENCE_PATH, -1) = NVL(SUBSTR(nImpTreeSeq, 1, INSTR(nImpTreeSeq, '-', -1, 1) - 1), -1);
2281:
2282: IF(nPsNodeType = cnReference)THEN
2283: DECLARE
2284: CURSOR c_onl_reference IS
2285: SELECT PS_NODE_ID, devl_project_id, item_id, ib_trackable FROM CZ_IMP_PS_NODES
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
2611: END IF;
2612:
2613: /* End Fix for bug # 3495030 */
2614:
2615: UPDATE CZ_IMP_PS_NODES SET
2616: ORIG_SYS_REF=DECODE(x_usesurr_psnode,1,DECODE(sDISPOSITION,NULL,sImpUserStr03,ORIG_SYS_REF), ORIG_SYS_REF),
2617: PS_NODE_ID=DECODE(sDISPOSITION,'R',PS_NODE_ID,'I',
2618: DECODE(PS_NODE_TYPE,bomModel,DEVL_PROJECT_ID,cnModel,DEVL_PROJECT_ID,nNextId),nOnlPsnodeId),
2619: ITEM_ID=DECODE(sDISPOSITION,'R',ITEM_ID,nonlitemid),
2641: nLastTreeSeq := nThisTreeSeq;
2642: nDebug := 1026;
2643: /* Return if MAX_ERR is reached */
2644: IF (FAILED >= MAX_ERR) THEN
2645: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.KRS_PS_NODE',11276,inRun_Id);
2646: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
2647: END IF;
2648: sDisposition:=NULL; sRecStatus:=NULL;
2649:
2663: RAISE;
2664: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2665: RAISE;
2666: WHEN OTHERS THEN
2667: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_PS_NODE',nDebug,inRun_ID);
2668: RAISE;
2669: END KRS_PS_NODE;
2670:
2671: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
2680: SELECT DELETED_FLAG, SYSTEM_NODE_FLAG, SRC_APPLICATION_ID, ORIG_SYS_REF,
2681: PS_NODE_TYPE, MINIMUM, MAXIMUM, INSTANTIABLE_FLAG, NAME, FSK_DEVLPROJECT_5_1,
2682: FSK_PSNODE_3_1, FSK_PSNODE_3_EXT, REFERENCE_ID, INITIAL_NUM_VALUE, DECIMAL_QTY_FLAG,
2683: MINIMUM_SELECTED, MAXIMUM_SELECTED, UI_OMIT, DISPLAY_IN_SUMMARY_FLAG, ROWID
2684: FROM CZ_IMP_PS_NODES
2685: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
2686: /* Internal vars */
2687: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
2688: nErrorCount PLS_INTEGER:=0; /*Error index */
2693:
2694: /*Cursor Var for Import */
2695: p_imp_psnode c_imp_psnode%ROWTYPE;
2696: x_imp_psnode_f BOOLEAN:=FALSE;
2697: l_disposition cz_imp_ps_nodes.disposition%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);
2694: /*Cursor Var for Import */
2695: p_imp_psnode c_imp_psnode%ROWTYPE;
2696: x_imp_psnode_f BOOLEAN:=FALSE;
2697: l_disposition cz_imp_ps_nodes.disposition%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;
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;
2707: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2708:
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;
2707: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2708:
2709: BEGIN
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;
2707: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2708:
2709: BEGIN
2710:
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;
2707: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2708:
2709: BEGIN
2710:
2711: --
2711: --
2712: -- All dups are rejected because we don't know which to accept, GENERIC IMPORT ONLY
2713: --
2714:
2715: UPDATE cz_imp_ps_nodes a
2716: SET disposition = 'R', rec_status = 'DUP'
2717: WHERE run_id = inRun_ID
2718: AND rec_status IS NULL
2719: AND EXISTS (SELECT count(*), orig_sys_ref,fsk_devlproject_5_1,src_application_id
2716: SET disposition = 'R', rec_status = 'DUP'
2717: WHERE run_id = inRun_ID
2718: AND rec_status IS NULL
2719: AND EXISTS (SELECT count(*), orig_sys_ref,fsk_devlproject_5_1,src_application_id
2720: FROM cz_imp_ps_nodes
2721: WHERE run_id = a.run_id
2722: AND rec_status IS NULL
2723: AND orig_sys_ref = a.orig_sys_ref
2724: AND fsk_devlproject_5_1 = a.fsk_devlproject_5_1
2728: HAVING count(*) > 1);
2729:
2730: IF (SQL%ROWCOUNT > 0 ) THEN
2731: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_DUPS', 'PSNODES', SQL%ROWCOUNT);
2732: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2733: END IF;
2734:
2735: OPEN c_imp_psnode;
2736: LOOP
2739:
2740: EXIT WHEN NOT x_imp_psnode_f;
2741:
2742: IF(FAILED >= MAX_ERR) THEN
2743: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2744: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
2745: END IF;
2746:
2747: l_disposition := NULL;
2760: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_ROOT_MINMAX',
2761: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2762: 'OSR', p_imp_psnode.ORIG_SYS_REF
2763: );
2764: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2765: END IF;
2766: IF p_imp_psnode.minimum IS NULL THEN
2767: l_minimum:=1;
2768: ELSE
2783: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_ROOT_UI_OMIT',
2784: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2785: 'OSR', p_imp_psnode.ORIG_SYS_REF
2786: );
2787: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2788: END IF;
2789:
2790: ELSE
2791: l_minimum:=p_imp_psnode.minimum;
2810: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_INIT_VALUE',
2811: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2812: 'OSR', p_imp_psnode.ORIG_SYS_REF
2813: );
2814: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2815: END IF;
2816:
2817: IF (l_minimum > l_maximum AND l_maximum <> -1) THEN
2818: l_disposition := 'R';
2819: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_MINMAX',
2820: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2821: 'OSR', p_imp_psnode.ORIG_SYS_REF
2822: );
2823: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2824: END IF;
2825: END IF;
2826: END IF;
2827:
2843: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_INIT_VALUE',
2844: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2845: 'OSR', p_imp_psnode.ORIG_SYS_REF
2846: );
2847: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2848: END IF;
2849:
2850: IF (l_minimum_selected > l_maximum_selected AND l_maximum_selected <> -1) THEN
2851: l_disposition := 'R';
2852: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_MINMAX',
2853: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2854: 'OSR', p_imp_psnode.ORIG_SYS_REF
2855: );
2856: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2857: END IF;
2858: END IF;
2859: END IF;
2860:
2865: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_TYPE_INVALID',
2866: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2867: 'OSR', p_imp_psnode.ORIG_SYS_REF
2868: );
2869: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2870: END IF;
2871:
2872: IF(p_imp_psnode.NAME IS NULL) THEN
2873:
2876: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_NAME_IS_NULL',
2877: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2878: 'OSR', p_imp_psnode.ORIG_SYS_REF
2879: );
2880: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2881: END IF;
2882:
2883: IF(p_imp_psnode.PS_NODE_TYPE NOT IN (cnReference,cnConnector) AND
2884: p_imp_psnode.REFERENCE_ID IS NOT NULL) THEN
2888: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_REFID_NULL',
2889: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2890: 'OSR', p_imp_psnode.ORIG_SYS_REF
2891: );
2892: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2893: END IF;
2894:
2895: IF(p_imp_psnode.INSTANTIABLE_FLAG IS NULL) THEN
2896: sInstantiableFlag := NULL;
2920: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INSTFLAG',
2921: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2922: 'OSR', p_imp_psnode.ORIG_SYS_REF
2923: );
2924: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2925: END IF;
2926: END IF;
2927:
2928: IF (p_imp_psnode.DISPLAY_IN_SUMMARY_FLAG NOT IN (NULL,'1')) THEN
2930: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_SUMRY_FLAG',
2931: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2932: 'OSR', p_imp_psnode.ORIG_SYS_REF
2933: );
2934: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2935: END IF;
2936:
2937: IF l_disposition='R' THEN
2938: FAILED:=FAILED+1;
2938: FAILED:=FAILED+1;
2939: l_rec_status:='FAIL';
2940: END IF;
2941:
2942: UPDATE cz_imp_ps_nodes SET
2943: deleted_flag=DECODE(deleted_flag,NULL,'0',deleted_flag),
2944: system_node_flag=DECODE(system_node_flag,NULL,'0',SYSTEM_NODE_FLAG),
2945: instantiable_flag=DECODE(instantiable_flag,NULL,sInstantiableFlag,instantiable_flag),
2946: src_application_id=DECODE(src_application_id,NULL,cnDefSrcAppId,src_application_id),
2967: RAISE;
2968: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2969: RAISE;
2970: WHEN OTHERS THEN
2971: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2972: RAISE;
2973: END CND_PS_NODE ;
2974:
2975: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
3020: WHEN NO_DATA_FOUND THEN
3021: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
3022: VALUES(inRUN_ID,SYSDATE,SYSDATE);
3023: WHEN OTHERS THEN
3024: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_PS_NODE',11276,inRun_Id);
3025: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
3026: END;
3027:
3028: if (CZ_IMP_ALL.get_time) then
3061: genStatisticsCz := 0;
3062: END;
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);
3062: END;
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:
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
3072: end_time := dbms_utility.get_time();
3073: d_str := inRun_id || ' XFR gather_stats :' || (end_time-st_time)/100.00;
3101: INSERTS:=nXfrInsertCount;
3102: UPDATES:=nXfrUpdateCount;
3103: NOCHANGE:=nNoChangeCount;
3104:
3105: CZ_IMP_PS_NODE.RPT_PS_NODE(inRUN_ID);
3106:
3107: END MAIN_PS_NODE ;
3108:
3109: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
3117: NOCHANGE IN OUT NOCOPY PLS_INTEGER,--VR
3118: inXFR_GROUP IN VARCHAR2
3119: ) IS
3120:
3121: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3118: inXFR_GROUP IN VARCHAR2
3119: ) IS
3120:
3121: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3119: ) IS
3120:
3121: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3120:
3121: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3121: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3122: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3123: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3124: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3125: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3126: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3127: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3128: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3129: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3130: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3131: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3132: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3133: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3134: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3135: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3136: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3137: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3138: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3139: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3140: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3141: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3142: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3143: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3144: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3145: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3146: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3147: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3148: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3149: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3150: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3151: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3152: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3153: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3154: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3155: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3156: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3157: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3158: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3159: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3160: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3161: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3162: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3163: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3164: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3165: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3166: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3167: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3168: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3169: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3170: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3171: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3172: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3173: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3174: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
3175: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
3183: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
3176: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
3177: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
3178: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
3179: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
3180: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
3181: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
3182: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%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;
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;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%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;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
3193: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE 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;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
3193: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
3194: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
3195:
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;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
3193: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
3194: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
3195:
3196: iPsNodeId tPsNodeId;
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;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
3193: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
3194: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
3195:
3196: iPsNodeId tPsNodeId;
3197: iDevlProjectId tDevlProjectId;
3190:
3191: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
3192: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
3193: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
3194: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
3195:
3196: iPsNodeId tPsNodeId;
3197: iDevlProjectId tDevlProjectId;
3198: iFromPopulatorId tFromPopulatorId;
3268: -- PS nodes that are references, connectors or componentns, NOT ROOTS
3269: CURSOR l_model_refs_csr IS
3270: SELECT plan_level, ps_node_id, devl_project_id, reference_id,
3271: minimum, maximum, ps_node_type, parent_id, disposition
3272: FROM cz_imp_ps_nodes
3273: WHERE ps_node_type IN (cnReference,cnConnector,cnComponent)
3274: AND deleted_flag='0' AND rec_status='OK' AND run_id=inRun_ID
3275: ORDER BY plan_level, devl_project_id, reference_id;
3276:
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
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
3286: AND rec_status='PASS'
3287: AND devl_project_id=ROOTS.devl_project_id
3288: AND ps_node_type IN (cnReference,cnConnector))
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
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
3308: WHERE run_id=inRUN_ID
3309: AND rec_status='PASS'
3310: AND devl_project_id=ROOTS.devl_project_id
3311: AND ps_node_type IN (cnReference,cnConnector))
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
3332: AND d.run_id=inRUN_ID
3333: AND d.rec_status='OK'
3334: AND REFS.rec_status='PASS'
3335: AND REFS.run_id=inRUN_ID
3336: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes
3337: WHERE run_id=inRUN_ID
3338: AND rec_status='PASS'
3339: AND reference_id=ROOTS.devl_project_id
3340: AND ps_node_type IN (cnReference,cnConnector))
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
3435: SHIPPABLE_ITEM_FLAG,
3436: INVENTORY_TRANSACTABLE_FLAG,
3437: ASSEMBLE_TO_ORDER_FLAG,
3438: SERIALIZABLE_ITEM_FLAG
3439: FROM CZ_IMP_PS_NODES
3440: WHERE CZ_IMP_PS_NODES.RUN_ID = inRUN_ID AND REC_STATUS='PASS'
3441: AND devl_project_id=inModelId AND disposition=inDisposition
3442: ORDER BY PLAN_LEVEL,USER_NUM04 DESC;
3443:
3436: INVENTORY_TRANSACTABLE_FLAG,
3437: ASSEMBLE_TO_ORDER_FLAG,
3438: SERIALIZABLE_ITEM_FLAG
3439: FROM CZ_IMP_PS_NODES
3440: WHERE CZ_IMP_PS_NODES.RUN_ID = inRUN_ID AND REC_STATUS='PASS'
3441: AND devl_project_id=inModelId AND disposition=inDisposition
3442: ORDER BY PLAN_LEVEL,USER_NUM04 DESC;
3443:
3444: x_xfr_psnode_f BOOLEAN:=FALSE;
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;
3535: l_retcode number;
3607: LOOP
3608: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3609: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3610: ROLLBACK;
3611: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
3612: UPDATE CZ_IMP_PS_NODES
3613: SET REC_STATUS='ERR'
3614: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3615: AND DISPOSITION='I';
3608: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3609: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3610: ROLLBACK;
3611: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
3612: UPDATE CZ_IMP_PS_NODES
3613: SET REC_STATUS='ERR'
3614: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3615: AND DISPOSITION='I';
3616: COMMIT;
3726: nCommitCount:= nCommitCount + SQL%ROWCOUNT;
3727:
3728: BEGIN
3729: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
3730: UPDATE CZ_IMP_PS_NODES
3731: SET REC_STATUS='OK'
3732: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3733: AND DISPOSITION='I';
3734:
3766: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3767: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3768:
3769: ROLLBACK;
3770: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
3771: UPDATE CZ_IMP_PS_NODES
3772: SET REC_STATUS='ERR'
3773: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3774: AND DISPOSITION='I';
3767: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3768:
3769: ROLLBACK;
3770: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
3771: UPDATE CZ_IMP_PS_NODES
3772: SET REC_STATUS='ERR'
3773: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3774: AND DISPOSITION='I';
3775: COMMIT;
3781: FOR j IN iPsNodeID.FIRST..iPsNodeId.LAST LOOP -- singe row loop
3782:
3783: IF(FAILED >= MAX_ERR) THEN
3784: ROLLBACK;
3785: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
3786: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
3787: END IF;
3788:
3789: BEGIN -- single row insert
3890:
3891:
3892: nInsertCount:=nInsertCount+1;
3893:
3894: UPDATE CZ_IMP_PS_NODES
3895: SET REC_STATUS='OK'
3896: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3897: AND DISPOSITION='I';
3898:
3932: EXIT OUTER_LOOP;
3933: ELSE
3934: -- not a root node, so import continues
3935: FAILED:=FAILED +1;
3936: UPDATE CZ_IMP_PS_NODES
3937: SET REC_STATUS='ERR'
3938: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3939: AND DISPOSITION='I';
3940:
4035: LOOP
4036: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
4037: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
4038: ROLLBACK;
4039: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
4040: UPDATE CZ_IMP_PS_NODES
4041: SET REC_STATUS='ERR'
4042: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
4043: AND DISPOSITION='M';
4036: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
4037: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
4038: ROLLBACK;
4039: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
4040: UPDATE CZ_IMP_PS_NODES
4041: SET REC_STATUS='ERR'
4042: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
4043: AND DISPOSITION='M';
4044: COMMIT;
4120: nCommitCount:= nCommitCount + SQL%ROWCOUNT;
4121:
4122: BEGIN -- bulk update
4123: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
4124: UPDATE CZ_IMP_PS_NODES
4125: SET REC_STATUS='OK'
4126: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
4127: AND DISPOSITION='M';
4128:
4158: LOOP
4159: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
4160: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
4161: ROLLBACK;
4162: x_error:=CZ_UTILS.LOG_REPORT('Fatal Error : CZ_IMP_PS_NODES.MAXIMUM should be specified in Generic Import',1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
4163: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
4164: END IF;
4165: END LOOP;
4166: END IF;
4168: FOR j IN iPsNodeID.FIRST..iPsNodeId.LAST LOOP -- single row loop
4169:
4170: IF (FAILED >= MAX_ERR) THEN
4171: ROLLBACK;
4172: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,'CZ_IMP_PS_NODE.XFR_PS_NODE',11276,inRun_Id);
4173: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
4174: END IF;
4175:
4176:
4243: WHERE PS_NODE_ID=iPSNODEID(j);
4244:
4245: nUpdateCount:= nUpdateCount + 1;
4246:
4247: UPDATE CZ_IMP_PS_NODES -- single row update
4248: SET REC_STATUS='OK'
4249: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
4250: AND DISPOSITION='M';
4251:
4258:
4259: EXCEPTION -- single row update
4260: WHEN OTHERS THEN
4261: FAILED:=FAILED +1;
4262: UPDATE CZ_IMP_PS_NODES
4263: SET REC_STATUS='ERR'
4264: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
4265: AND DISPOSITION='M';
4266:
4284: END; -- bulk update
4285: END IF; -- IF count > 0
4286: END LOOP; -- bulk fetch for update
4287:
4288: UPDATE CZ_IMP_PS_NODES
4289: SET REC_STATUS='OK'
4290: WHERE DISPOSITION='N' and run_id = inRUN_ID
4291: AND devl_project_id = p_model_id;
4292: nNoChangeCount:=nNoChangeCount+(sql%rowcount);
4297:
4298: END update_ps_nodes;
4299:
4300:
4301: -- private procdure to delete PS nodes that are no longer present in the cz_imp_ps_nodes of this run id
4302: -- deletes the nodes logically and calls the cz_refs.delete_node logically to delete the expls
4303: -- for refs, connectors and non-virtual components
4304:
4305: PROCEDURE delete_ps_nodes(p_model_id IN NUMBER, x_retcode OUT NOCOPY NUMBER)
4312: FROM cz_ps_nodes a
4313: WHERE deleted_flag = '0'
4314: AND devl_project_id = p_model_id
4315: AND ps_node_type IN (cnReference, cnConnector, cnComponent)
4316: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes
4317: WHERE orig_sys_ref = a.orig_sys_ref
4318: AND devl_project_id = p_model_id
4319: AND src_application_id = a.src_application_id
4320: AND run_id=inRun_Id);
4326:
4327: UPDATE cz_ps_nodes a
4328: SET deleted_flag = '1'
4329: WHERE devl_project_id = p_model_id
4330: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes
4331: WHERE orig_sys_ref = a.orig_sys_ref
4332: AND devl_project_id = p_model_id
4333: AND src_application_id = a.src_application_id
4334: AND run_id=inRun_Id);
4827: IF l_c1_prj_id_tbl.COUNT > 0 THEN
4828: FOR i IN l_c1_prj_id_tbl.FIRST..l_c1_prj_id_tbl.LAST LOOP
4829: IF l_c1_rec_status_tbl(i)='ERR' THEN
4830:
4831: UPDATE CZ_IMP_PS_NODES
4832: SET REC_STATUS='ERR'
4833: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4834: AND RUN_ID=inRUN_ID;
4835:
4857: IF l_c2_prj_id_tbl.COUNT > 0 THEN
4858: FOR i IN l_c2_prj_id_tbl.FIRST..l_c2_prj_id_tbl.LAST LOOP
4859: IF l_c2_rec_status_tbl(i) IN ('SKP','ERR') THEN
4860:
4861: UPDATE CZ_IMP_PS_NODES
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:
4887: IF l_c3_prj_id_tbl.COUNT > 0 THEN
4888: FOR i IN l_c3_prj_id_tbl.FIRST..l_c3_prj_id_tbl.LAST LOOP
4889: IF l_c3_rec_status_tbl(i) IN ('SKP','ERR') THEN
4890:
4891: UPDATE CZ_IMP_PS_NODES
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:
5000: IF l_c4_prj_id_tbl.COUNT > 0 THEN
5001: FOR i IN l_c4_prj_id_tbl.FIRST..l_c4_prj_id_tbl.LAST LOOP
5002: IF l_c4_rec_status_tbl(i)='ERR' THEN
5003:
5004: UPDATE CZ_IMP_PS_NODES
5005: SET REC_STATUS='ERR'
5006: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
5007: AND RUN_ID=inRUN_ID;
5008:
5054: NULL, '1');
5055:
5056: IF (p_out_err > 0) THEN
5057: FAILED:=FAILED +1;
5058: UPDATE CZ_IMP_PS_NODES
5059: SET REC_STATUS='ERR'
5060: WHERE PS_NODE_ID=l_PsNodeId(i)
5061: AND RUN_ID=inRUN_ID
5062: AND DISPOSITION=l_dis(i);
5122:
5123: DECLARE
5124: CURSOR c_xfr_run_result IS
5125: SELECT DISPOSITION,REC_STATUS,COUNT(*)
5126: FROM CZ_IMP_PS_NODES
5127: WHERE RUN_ID = inRUN_ID
5128: GROUP BY DISPOSITION,REC_STATUS;
5129:
5130: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;
5146: COMMIT;
5147:
5148: EXCEPTION
5149: WHEN OTHERS THEN
5150: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
5151: END;
5152:
5153: DECLARE
5154: nErrors PLS_INTEGER;
5166: WHERE RUN_ID=inRUN_ID;
5167: COMMIT;
5168: EXCEPTION
5169: WHEN OTHERS THEN
5170: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
5171: END;
5172: EXCEPTION
5173: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
5174: RAISE;
5174: RAISE;
5175: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
5176: RAISE;
5177: WHEN OTHERS THEN
5178: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
5179: END;
5180: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
5181:
5182: /*--PS_NODE IMPORT SECTION END----------------------------------------------*/
5180: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
5181:
5182: /*--PS_NODE IMPORT SECTION END----------------------------------------------*/
5183: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
5184: END CZ_IMP_PS_NODE;