eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CZ_IMP_PS_NODE dependencies on CZ_IMP_PS_NODE

Line 1: PACKAGE BODY CZ_IMP_PS_NODE as

1: PACKAGE BODY CZ_IMP_PS_NODE as
2: /* $Header: czipsnb.pls 120.11 2008/04/15 14:05:00 skudryav ship $ */
3:
4: CAPTION_RULE_TYPE CONSTANT NUMBER:=700;
5: JAVA_SYS_PROP_RULE_TYPE CONSTANT NUMBER:=501;

Line 104: 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);

100: FOR I in 1..sImpOrigSysRef.COUNT LOOP
101:
102: /* Return if MAX_ERR is reached */
103: IF(FAILED >= MAX_ERR) THEN
104: 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);
105: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
106: END IF;
107:
108: DECLARE

Line 115: cz_imp_ps_nodes ip, cz_imp_devl_project id

111:
112: CURSOR c_onl_intl_text IS
113: SELECT ol.intl_text_id,ol.localized_str, ol.model_id, ol.orig_sys_ref
114: FROM cz_localized_texts ol, cz_devl_projects od, cz_ps_nodes op,
115: cz_imp_ps_nodes ip, cz_imp_devl_project id
116: WHERE ol.orig_sys_ref = sImpOrigSysRef(i)
117: AND ip.fsk_intltext_1_1 = sImpOrigSysRef(i)
118: AND op.intl_text_id = ol.intl_text_id
119: AND ip.orig_sys_ref = op.orig_sys_ref

Line 151: UPDATE CZ_IMP_PS_NODES

147: WHERE orig_sys_ref = sImpOrigSysRef(i)
148: AND fsk_devlproject_1_1 = sImpFSKDevlProject(i)
149: AND run_id = inRUN_ID;
150:
151: UPDATE CZ_IMP_PS_NODES
152: SET INTL_TEXT_ID =nOnlIntlTextId
153: WHERE fsk_intltext_1_1 = sImpOrigSysRef(i)
154: AND fsk_devlproject_5_1 = sImpFSKDevlProject(i)
155: AND RUN_ID = inRUN_ID;

Line 184: UPDATE CZ_IMP_PS_NODES

180: WHERE orig_sys_ref = sImpOrigSysRef(i)
181: AND fsk_devlproject_1_1 = sImpFSKDevlProject(i)
182: AND run_id = inRUN_ID;
183:
184: UPDATE CZ_IMP_PS_NODES
185: SET INTL_TEXT_ID =nNextId
186: WHERE fsk_intltext_1_1 = sImpOrigSysRef(i)
187: AND fsk_devlproject_5_1 = sImpFSKDevlProject(i)
188: AND RUN_ID = inRUN_ID;

Line 313: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT',11276,inRun_Id);

309: RAISE;
310: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
311: RAISE;
312: WHEN OTHERS THEN
313: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_INTL_TEXT',11276,inRun_Id);
314: RAISE;
315: END KRS_INTL_TEXT;
316: ------------------------------------------------------------------------------
317: PROCEDURE CND_INTL_TEXT(inRUN_ID IN PLS_INTEGER,

Line 378: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);

374: WHERE orig_sys_ref = l_orig_sys_ref_tbl(i) AND run_id = inRUN_ID;
375: COMMIT;
376: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_INTLTXT_FAIL',
377: 'COUNT' , SQL%ROWCOUNT);
378: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
379: FAILED := FAILED + SQL%ROWCOUNT;
380:
381: /* Return if MAX_ERR is reached */
382: IF(FAILED >= MAX_ERR) THEN

Line 384: 'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);

380:
381: /* Return if MAX_ERR is reached */
382: IF(FAILED >= MAX_ERR) THEN
383: x_error:=CZ_UTILS.LOG_REPORT(CZ_UTILS.GET_TEXT('CZ_IMP_MAXERR_REACHED'),1,
384: 'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
385: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
386: END IF;
387: END IF;
388: END LOOP;

Line 403: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);

399: RAISE;
400: WHEN OTHERS THEN
401: IF l_csr_1%ISOPEN THEN CLOSE l_csr_1; END IF;
402: IF l_csr_2%ISOPEN THEN CLOSE l_csr_2; END IF;
403: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_INTL_TEXT',11276,inRun_Id);
404: RAISE;
405: END CND_INTL_TEXT;
406: ------------------------------------------------------------------------------
407: PROCEDURE MAIN_INTL_TEXT(inRUN_ID IN PLS_INTEGER,

Line 447: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:RUNID',11276,inRun_Id);

443: WHEN NO_DATA_FOUND THEN
444: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
445: VALUES(inRUN_ID,SYSDATE,SYSDATE);
446: WHEN OTHERS THEN
447: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_INTL_TEXT:RUNID',11276,inRun_Id);
448: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
449: END;
450:
451: if (CZ_IMP_ALL.get_time) then

Line 483: 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);

479: end if;
480:
481: /* Report Insert Errors */
482: IF(nXfrInsertCount<> INSERTS) THEN
483: 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);
484: END IF;
485: /* Report Update Errors */
486: IF(nXfrUpdateCount<> UPDATES) THEN
487: 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);

Line 487: 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);

483: 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);
484: END IF;
485: /* Report Update Errors */
486: IF(nXfrUpdateCount<> UPDATES) THEN
487: 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);
488: END IF;
489: /* Return the transferred number of rows and not the number of rows with keys resolved */
490: INSERTS:=nXfrInsertCount;
491: UPDATES:=nXfrUpdateCount;

Line 493: CZ_IMP_PS_NODE.RPT_INTL_TEXT(inRUN_ID);

489: /* Return the transferred number of rows and not the number of rows with keys resolved */
490: INSERTS:=nXfrInsertCount;
491: UPDATES:=nXfrUpdateCount;
492:
493: CZ_IMP_PS_NODE.RPT_INTL_TEXT(inRUN_ID);
494:
495: END MAIN_INTL_TEXT;
496: ------------------------------------------------------------------------------
497:

Line 567: 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);

563: EXIT WHEN NOT x_xfr_intl_text_f;
564:
565: IF(FAILED >= MAX_ERR) THEN
566: ROLLBACK;
567: 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);
568: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
569: END IF;
570:
571: IF(p_xfr_intl_text.disposition = 'I') THEN

Line 602: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:INSERT',11276,inRun_Id);

598: FAILED:=FAILED +1;
599: UPDATE cz_imp_localized_texts
600: SET REC_STATUS='ERR'
601: WHERE ROWID = p_xfr_intl_text.ROWID;
602: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:INSERT',11276,inRun_Id);
603: END;
604: ELSIF(p_xfr_intl_text.disposition = 'M') THEN
605: BEGIN
606: UPDATE cz_localized_texts SET

Line 631: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:UPDATE',11276,inRun_Id);

627: FAILED:=FAILED +1;
628: UPDATE cz_imp_localized_texts
629: SET REC_STATUS='ERR'
630: WHERE ROWID = p_xfr_intl_text.ROWID;
631: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT:UPDATE',11276,inRun_Id);
632: END;
633:
634: END IF;
635: END LOOP;

Line 647: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT',11276,inRun_Id);

643: RAISE;
644: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
645: RAISE;
646: WHEN OTHERS THEN
647: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_INTL_TEXT',11276,inRun_Id);
648: RAISE;
649: END XFR_INTL_TEXT;
650:
651: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 704: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);

700: WHERE RUN_ID=inRUN_ID;
701: COMMIT;
702: EXCEPTION
703: WHEN OTHERS THEN
704: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);
705: END;
706: EXCEPTION
707: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
708: RAISE;

Line 712: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);

708: RAISE;
709: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
710: RAISE;
711: WHEN OTHERS THEN
712: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_INTL_TEXT',11276,inRun_Id);
713: RAISE;
714: END;
715: /*--INTL_TEXT IMPORT SECTION END--------------------------------------------*/
716:

Line 985: 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);

981:
982: IF(sModelType = 'N' AND nModelType <> 'N')THEN
983:
984: --'The Configuration Model Type for ''%MODELNAME'' has changed from ''Container'' to ''Standard''.'
985: 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);
986: cz_imp_all.setReturnCode(cz_imp_all.CONCURRENT_WARNING, CZ_UTILS.GET_TEXT('CZ_IMP_CONTAINER_REFRESH', 'MODELNAME', sName));
987: END IF;
988:
989: -- Don't update model_type if it is 'P'

Line 999: 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);

995: if (nInstances > 0) then
996: begin
997: sModeltype := 'P';
998: /*If the model has multiple instances, then do not refresh this or its parent model */
999: 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);
1000: sRecStatus := 'N8';
1001: sDisposition := 'R';
1002: end;
1003: else sModelType := nModelType; end if;

Line 1043: UPDATE CZ_IMP_PS_NODES SET

1039: END IF;
1040:
1041: IF(sDisposition<>'R')THEN
1042:
1043: UPDATE CZ_IMP_PS_NODES SET
1044: DEVL_PROJECT_ID=nOnlDevlProjectId
1045: WHERE fsk_devlproject_5_1 = sOrigSysRef
1046: AND RUN_ID=inRUN_ID;
1047:

Line 1052: 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);

1048: END IF;
1049:
1050: /* Return if MAX_ERR is reached */
1051: IF(FAILED >= MAX_ERR) THEN
1052: 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);
1053: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1054: END IF;
1055:
1056: sDisposition:=NULL; sRecStatus:=NULL;

Line 1074: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT',11276,inRun_Id);

1070: RAISE;
1071: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1072: RAISE;
1073: WHEN OTHERS THEN
1074: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_DEVL_PROJECT',11276,inRun_Id);
1075: RAISE;
1076: END KRS_DEVL_PROJECT;
1077: ------------------------------------------------------------------------------
1078: PROCEDURE CND_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,

Line 1142: 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);

1138:
1139: EXIT WHEN NOT x_imp_devl_project_f;
1140:
1141: IF(FAILED >= MAX_ERR) THEN
1142: 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);
1143: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1144: END IF;
1145: -- only seeded models from contracts can be imported
1146: IF (p_imp_devl_project.seeded_flag = '1' AND NOT gContractsModel) THEN

Line 1153: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);

1149: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_SEEDED_FLG',
1150: 'MODELNAME', p_imp_devl_project.name,
1151: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1152: );
1153: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1154: END IF;
1155: -- validate only for generic import, for BOM we populate during extraction so no need for validation
1156: 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
1157: IF NOT (is_rule_id_valid(p_imp_devl_project.bom_caption_rule_id,

Line 1171: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);

1167: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_BOM_CPTN_RULE',
1168: 'MODELNAME', p_imp_devl_project.name,
1169: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1170: );
1171: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1172: END IF;
1173: END IF;
1174: -- validate only for generic import, for BOM we populate during extraction so no need for validation
1175: 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

Line 1190: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);

1186: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PRJ_NONBOM_CPTN_RULE',
1187: 'MODELNAME', p_imp_devl_project.name,
1188: 'MODLELOSR', p_imp_devl_project.orig_sys_ref
1189: );
1190: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1191: END IF;
1192: END IF;
1193:
1194: UPDATE CZ_IMP_DEVL_PROJECT SET

Line 1217: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);

1213: RAISE;
1214: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1215: RAISE;
1216: WHEN OTHERS THEN
1217: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_DEVL_PROJECT',11276,inRun_Id);
1218: RAISE;
1219: END CND_DEVL_PROJECT;
1220: ------------------------------------------------------------------------------
1221: PROCEDURE MAIN_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,

Line 1301: 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);

1297: end if;
1298:
1299: /* Report Insert Errors */
1300: IF(nXfrInsertCount<> INSERTS) THEN
1301: 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);
1302: END IF;
1303: /* Report Update Errors */
1304: IF(nXfrUpdateCount<> UPDATES) THEN
1305: 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);

Line 1305: 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);

1301: 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);
1302: END IF;
1303: /* Report Update Errors */
1304: IF(nXfrUpdateCount<> UPDATES) THEN
1305: 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);
1306: END IF;
1307:
1308: /* Return the transferred number of rows and not the number of rows with keys resolved */
1309: INSERTS:=nXfrInsertCount;

Line 1312: CZ_IMP_PS_NODE.RPT_DEVL_PROJECT(inRUN_ID);

1308: /* Return the transferred number of rows and not the number of rows with keys resolved */
1309: INSERTS:=nXfrInsertCount;
1310: UPDATES:=nXfrUpdateCount;
1311:
1312: CZ_IMP_PS_NODE.RPT_DEVL_PROJECT(inRUN_ID);
1313:
1314: END MAIN_DEVL_PROJECT;
1315: ------------------------------------------------------------------------------
1316: PROCEDURE XFR_DEVL_PROJECT(inRUN_ID IN PLS_INTEGER,

Line 1404: 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);

1400: EXIT WHEN NOT x_xfr_devl_project_f;
1401:
1402: IF(FAILED >= MAX_ERR) THEN
1403: ROLLBACK;
1404: 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);
1405: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
1406: END IF;
1407:
1408: --

Line 1420: 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);

1416: SET REC_STATUS='ERR'
1417: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1418: AND DISPOSITION=p_xfr_devl_project.disposition;
1419:
1420: 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);
1421: COMMIT;
1422:
1423: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
1424:

Line 1512: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:INSERT',11276,inRun_Id);

1508: FAILED:=FAILED +1;
1509: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1510: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1511: AND DISPOSITION='I';
1512: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:INSERT',11276,inRun_Id);
1513: END;
1514:
1515: ELSIF(p_xfr_devl_project.disposition = 'M') THEN
1516: BEGIN

Line 1585: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:UPDATE',11276,inRun_Id);

1581:
1582: UPDATE cz_imp_devl_project SET REC_STATUS='ERR'
1583: WHERE DEVL_PROJECT_ID=p_xfr_devl_project.DEVL_PROJECT_ID AND RUN_ID=inRUN_ID
1584: AND DISPOSITION='M';
1585: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT:UPDATE',11276,inRun_Id);
1586: END ;
1587: END IF;
1588: END LOOP;
1589:

Line 1600: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT',11276,inRun_Id);

1596: RAISE;
1597: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1598: RAISE;
1599: WHEN OTHERS THEN
1600: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.XFR_DEVL_PROJECT',11276,inRun_Id);
1601: RAISE;
1602: END XFR_DEVL_PROJECT;
1603:
1604: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 1657: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);

1653: WHERE RUN_ID=inRUN_ID;
1654: COMMIT;
1655: EXCEPTION
1656: WHEN OTHERS THEN
1657: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);
1658: END;
1659: EXCEPTION
1660: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
1661: RAISE;

Line 1665: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);

1661: RAISE;
1662: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
1663: RAISE;
1664: WHEN OTHERS THEN
1665: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_DEVL_PROJECT',11276,inRun_Id);
1666: RAISE;
1667: END;
1668: /*--DEVL_PROJECT IMPORT SECTION END-----------------------------------------*/
1669:

Line 1698: FROM CZ_IMP_PS_NODES WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID

1694: FSK_DEVLPROJECT_5_1,FSK_DEVLPROJECT_5_EXT,
1695: fsk_psnode_6_1, COMPONENT_SEQUENCE_PATH, ROWID, MINIMUM, MAXIMUM,
1696: nvl(SRC_APPLICATION_ID, cnDefSrcAppId),
1697: nvl(FSK_ITEMMASTER_2_2, cnDefSrcAppId)
1698: FROM CZ_IMP_PS_NODES WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID
1699: ORDER BY PLAN_LEVEL,
1700: DECODE(x_usesurr_psnode,0,ORIG_SYS_REF,1,USER_STR03),
1701: DECODE(x_usesurr_intltext,0,FSK_INTLTEXT_1_1,1,FSK_INTLTEXT_1_EXT),
1702: DECODE(x_usesurr_itemmaster,0,FSK_ITEMMASTER_2_1,1,FSK_ITEMMASTER_2_EXT),

Line 1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;

1713: x_onl_devlprj_devlprjid_f BOOLEAN:=FALSE;
1714: x_onl_reference_f BOOLEAN:=FALSE;
1715: x_error BOOLEAN:=FALSE;
1716: x_project_f BOOLEAN:=FALSE;
1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;

Line 1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;

1714: x_onl_reference_f BOOLEAN:=FALSE;
1715: x_error BOOLEAN:=FALSE;
1716: x_project_f BOOLEAN:=FALSE;
1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;

Line 1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;

1715: x_error BOOLEAN:=FALSE;
1716: x_project_f BOOLEAN:=FALSE;
1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;

Line 1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;

1716: x_project_f BOOLEAN:=FALSE;
1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;

Line 1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;

1717: sImpOrigsysref CZ_IMP_PS_NODES.ORIG_SYS_REF%TYPE;
1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;

Line 1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;

1718: sImpUserstr03 CZ_IMP_PS_NODES.USER_STR03%TYPE;
1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;

Line 1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;

1719: nOnlPsnodeId CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;

Line 1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;

1720: nImpParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;

Line 1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;

1721: nOnlParentId CZ_IMP_PS_NODES.PARENT_ID%TYPE;
1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

Line 1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;

1722: nImpPlanLevel CZ_IMP_PS_NODES.PLAN_LEVEL%TYPE;
1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;

Line 1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;

1723: nOnlItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;

Line 1728: localName CZ_IMP_PS_NODES.NAME%TYPE;

1724: nReferredItemId CZ_IMP_PS_NODES.ITEM_ID%TYPE;
1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;

Line 1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

1725: nOnlIntlTextId CZ_IMP_PS_NODES.INTL_TEXT_ID%TYPE;
1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;

Line 1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;

1726: nOnlDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;

Line 1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;

1727: nOnlReference CZ_IMP_PS_NODES.PS_NODE_ID%TYPE;
1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;

Line 1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;

1728: localName CZ_IMP_PS_NODES.NAME%TYPE;
1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;

Line 1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;

1729: nImpTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;

Line 1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;

1730: sFSKINTLTEXT11 CZ_IMP_PS_NODES.FSK_INTLTEXT_1_1%TYPE;
1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;

Line 1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;

1731: sFSKINTLTEXT1EXT CZ_IMP_PS_NODES.FSK_INTLTEXT_1_EXT%TYPE;
1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;

Line 1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;

1732: sFSKITEMMASTER21 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_1%TYPE;
1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;

Line 1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;

1733: sFSKITEMMASTER2EXT CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_EXT%TYPE;
1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;

Line 1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;

1734: nFSKITEMMASTER22 CZ_IMP_PS_NODES.FSK_ITEMMASTER_2_2%TYPE;
1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;

Line 1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;

1735: nImpSrcApplicationId CZ_IMP_PS_NODES.SRC_APPLICATION_ID%TYPE;
1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;

Line 1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;

1736: sFSKPSNODE31 CZ_IMP_PS_NODES.FSK_PSNODE_3_1%TYPE;
1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;

Line 1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;

1737: sFSKPSNODE3EXT CZ_IMP_PS_NODES.FSK_PSNODE_3_EXT%TYPE;
1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

Line 1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;

1738: sFSKPSNODE41 CZ_IMP_PS_NODES.FSK_PSNODE_4_1%TYPE;
1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

Line 1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;

1739: sFSKPSNODE4EXT CZ_IMP_PS_NODES.FSK_PSNODE_4_EXT%TYPE;
1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;

Line 1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;

1740: sFSKDEVLPROJECT51 CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_1%TYPE;
1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;

Line 1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

1741: sFSKDEVLPROJECT5EXT CZ_IMP_PS_NODES.FSK_DEVLPROJECT_5_EXT%TYPE;
1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;

Line 1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;

1742: sFSKREFERENCE CZ_IMP_PS_NODES.fsk_psnode_6_1%TYPE;
1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;

Line 1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;

1743: sLastFSK CZ_IMP_PS_NODES.NAME%TYPE;
1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;

Line 1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;

1744: sThisFSK CZ_IMP_PS_NODES.NAME%TYPE;
1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;

Line 1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;

1745: nLastTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

Line 1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;

1746: nThisTreeSeq CZ_IMP_PS_NODES.COMPONENT_SEQUENCE_PATH%TYPE;
1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;

Line 1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;

1747: sRecStatus CZ_IMP_PS_NODES.REC_STATUS%TYPE;
1748: sDisposition CZ_IMP_PS_NODES.DISPOSITION%TYPE;
1749: sOnlItemRefPartNbr CZ_IMP_PS_NODES.NAME%TYPE;
1750: nDevlProjectId CZ_IMP_PS_NODES.DEVL_PROJECT_ID%TYPE;
1751: nPsNodeType CZ_IMP_PS_NODES.PS_NODE_TYPE%TYPE;
1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:

Line 1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;

1752: sPsNodeName CZ_DB_SETTINGS.VALUE%TYPE;
1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;

Line 1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;

1753: cDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;
1761: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;

Line 1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;

1754: cDummyDeletedFlag CZ_DEVL_PROJECTS.DELETED_FLAG%TYPE;
1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;
1761: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;
1762:

Line 1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;

1755:
1756: sMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1757: sMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1758: impMinimum CZ_IMP_PS_NODES.MINIMUM%TYPE;
1759: impMaximum CZ_IMP_PS_NODES.MAXIMUM%TYPE;
1760: nModelType CZ_DEVL_PROJECTS.MODEL_TYPE%TYPE;
1761: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;
1762:
1763: /* Internal vars */

Line 1761: ibTrackable cz_imp_ps_nodes.ib_trackable%TYPE;

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

Line 1895: SELECT PS_NODE_ID, PLAN_LEVEL FROM CZ_IMP_PS_NODES WHERE ORIG_SYS_REF=DECODE(x_usesurr_psnode, 0, sFSKPSNODE31, 1, sFSKPSNODE3EXT)

1891:
1892: /* Check that the Online data exists for the 3 FSK */
1893: DECLARE
1894: CURSOR c_onl_psnode_parentid IS
1895: SELECT PS_NODE_ID, PLAN_LEVEL FROM CZ_IMP_PS_NODES WHERE ORIG_SYS_REF=DECODE(x_usesurr_psnode, 0, sFSKPSNODE31, 1, sFSKPSNODE3EXT)
1896: AND DEVL_PROJECT_ID=nDevlProjectId AND RUN_ID=inRUN_ID
1897: AND ps_node_id IS NOT NULL
1898: AND src_application_id = nImpSrcApplicationId
1899: AND NVL(COMPONENT_SEQUENCE_PATH, -1) = NVL(SUBSTR(nImpTreeSeq, 1, INSTR(nImpTreeSeq, '-', -1, 1) - 1), -1);

Line 1932: SELECT PS_NODE_ID, devl_project_id, item_id, ib_trackable FROM CZ_IMP_PS_NODES

1928:
1929: IF(nPsNodeType = cnReference)THEN
1930: DECLARE
1931: CURSOR c_onl_reference IS
1932: SELECT PS_NODE_ID, devl_project_id, item_id, ib_trackable FROM CZ_IMP_PS_NODES
1933: WHERE ORIG_SYS_REF = sFSKREFERENCE
1934: AND RUN_ID=inRun_ID
1935: AND ps_node_id IS NOT NULL;
1936: CURSOR c_model_type IS

Line 2225: UPDATE CZ_IMP_PS_NODES SET

2221: END IF;
2222:
2223: /* End Fix for bug # 3495030 */
2224:
2225: UPDATE CZ_IMP_PS_NODES SET
2226: ORIG_SYS_REF=DECODE(x_usesurr_psnode,1,DECODE(sDISPOSITION,NULL,sImpUserStr03,ORIG_SYS_REF), ORIG_SYS_REF),
2227: PS_NODE_ID=DECODE(sDISPOSITION,'R',PS_NODE_ID,'I',
2228: DECODE(PS_NODE_TYPE,bomModel,DEVL_PROJECT_ID,cnModel,DEVL_PROJECT_ID,nNextId),nOnlPsnodeId),
2229: ITEM_ID=DECODE(sDISPOSITION,'R',ITEM_ID,nonlitemid),

Line 2255: 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);

2251: nLastTreeSeq := nThisTreeSeq;
2252: nDebug := 1026;
2253: /* Return if MAX_ERR is reached */
2254: IF (FAILED >= MAX_ERR) THEN
2255: 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);
2256: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
2257: END IF;
2258: sDisposition:=NULL; sRecStatus:=NULL;
2259:

Line 2276: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_PS_NODE',nDebug,inRun_ID);

2272: RAISE;
2273: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2274: RAISE;
2275: WHEN OTHERS THEN
2276: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.KRS_PS_NODE',nDebug,inRun_ID);
2277: RAISE;
2278: END KRS_PS_NODE;
2279:
2280: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 2293: FROM CZ_IMP_PS_NODES

2289: SELECT DELETED_FLAG, SYSTEM_NODE_FLAG, SRC_APPLICATION_ID, ORIG_SYS_REF,
2290: PS_NODE_TYPE, MINIMUM, MAXIMUM, INSTANTIABLE_FLAG, NAME, FSK_DEVLPROJECT_5_1,
2291: FSK_PSNODE_3_1, FSK_PSNODE_3_EXT, REFERENCE_ID, INITIAL_NUM_VALUE, DECIMAL_QTY_FLAG,
2292: MINIMUM_SELECTED, MAXIMUM_SELECTED, UI_OMIT, DISPLAY_IN_SUMMARY_FLAG, ROWID
2293: FROM CZ_IMP_PS_NODES
2294: WHERE REC_STATUS IS NULL AND RUN_ID = inRUN_ID;
2295: /* Internal vars */
2296: nCommitCount PLS_INTEGER:=0; /*COMMIT buffer index */
2297: nErrorCount PLS_INTEGER:=0; /*Error index */

Line 2306: l_disposition cz_imp_ps_nodes.disposition%TYPE;

2302:
2303: /*Cursor Var for Import */
2304: p_imp_psnode c_imp_psnode%ROWTYPE;
2305: x_imp_psnode_f BOOLEAN:=FALSE;
2306: l_disposition cz_imp_ps_nodes.disposition%TYPE;
2307: l_rec_status cz_imp_ps_nodes.rec_status%TYPE;
2308:
2309: sInstantiableFlag cz_ps_nodes.instantiable_flag%type;
2310: l_msg VARCHAR2(255);

Line 2307: l_rec_status cz_imp_ps_nodes.rec_status%TYPE;

2303: /*Cursor Var for Import */
2304: p_imp_psnode c_imp_psnode%ROWTYPE;
2305: x_imp_psnode_f BOOLEAN:=FALSE;
2306: l_disposition cz_imp_ps_nodes.disposition%TYPE;
2307: l_rec_status cz_imp_ps_nodes.rec_status%TYPE;
2308:
2309: sInstantiableFlag cz_ps_nodes.instantiable_flag%type;
2310: l_msg VARCHAR2(255);
2311: l_model_name cz_devl_projects.name%type;

Line 2313: l_minimum cz_imp_ps_nodes.minimum%TYPE;

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

Line 2314: l_maximum cz_imp_ps_nodes.maximum%TYPE;

2310: l_msg VARCHAR2(255);
2311: l_model_name cz_devl_projects.name%type;
2312: l_debug NUMBER;
2313: l_minimum cz_imp_ps_nodes.minimum%TYPE;
2314: l_maximum cz_imp_ps_nodes.maximum%TYPE;
2315: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;
2316: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2317:
2318: BEGIN

Line 2315: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;

2311: l_model_name cz_devl_projects.name%type;
2312: l_debug NUMBER;
2313: l_minimum cz_imp_ps_nodes.minimum%TYPE;
2314: l_maximum cz_imp_ps_nodes.maximum%TYPE;
2315: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;
2316: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2317:
2318: BEGIN
2319:

Line 2316: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;

2312: l_debug NUMBER;
2313: l_minimum cz_imp_ps_nodes.minimum%TYPE;
2314: l_maximum cz_imp_ps_nodes.maximum%TYPE;
2315: l_minimum_selected cz_imp_ps_nodes.minimum_selected%TYPE;
2316: l_maximum_selected cz_imp_ps_nodes.maximum_selected%TYPE;
2317:
2318: BEGIN
2319:
2320: --

Line 2324: UPDATE cz_imp_ps_nodes a

2320: --
2321: -- All dups are rejected because we don't know which to accept, GENERIC IMPORT ONLY
2322: --
2323:
2324: UPDATE cz_imp_ps_nodes a
2325: SET disposition = 'R', rec_status = 'DUP'
2326: WHERE run_id = inRun_ID
2327: AND rec_status IS NULL
2328: AND EXISTS (SELECT count(*), orig_sys_ref,fsk_devlproject_5_1,src_application_id

Line 2329: FROM cz_imp_ps_nodes

2325: SET disposition = 'R', rec_status = 'DUP'
2326: WHERE run_id = inRun_ID
2327: AND rec_status IS NULL
2328: AND EXISTS (SELECT count(*), orig_sys_ref,fsk_devlproject_5_1,src_application_id
2329: FROM cz_imp_ps_nodes
2330: WHERE run_id = a.run_id
2331: AND rec_status IS NULL
2332: AND orig_sys_ref = a.orig_sys_ref
2333: AND fsk_devlproject_5_1 = a.fsk_devlproject_5_1

Line 2341: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2337: HAVING count(*) > 1);
2338:
2339: IF (SQL%ROWCOUNT > 0 ) THEN
2340: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_DUPS', 'PSNODES', SQL%ROWCOUNT);
2341: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2342: END IF;
2343:
2344: OPEN c_imp_psnode;
2345: LOOP

Line 2352: 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);

2348:
2349: EXIT WHEN NOT x_imp_psnode_f;
2350:
2351: IF(FAILED >= MAX_ERR) THEN
2352: 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);
2353: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
2354: END IF;
2355:
2356: l_disposition := NULL;

Line 2373: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2369: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_ROOT_MINMAX',
2370: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2371: 'OSR', p_imp_psnode.ORIG_SYS_REF
2372: );
2373: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2374: END IF;
2375: IF p_imp_psnode.minimum IS NULL THEN
2376: l_minimum:=1;
2377: ELSE

Line 2396: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2392: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_ROOT_UI_OMIT',
2393: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2394: 'OSR', p_imp_psnode.ORIG_SYS_REF
2395: );
2396: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2397: END IF;
2398:
2399: ELSE
2400: l_minimum:=p_imp_psnode.minimum;

Line 2423: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2419: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_INIT_VALUE',
2420: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2421: 'OSR', p_imp_psnode.ORIG_SYS_REF
2422: );
2423: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2424: END IF;
2425:
2426: IF (l_minimum > l_maximum AND l_maximum <> -1) THEN
2427: l_disposition := 'R';

Line 2432: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2428: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_MINMAX',
2429: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2430: 'OSR', p_imp_psnode.ORIG_SYS_REF
2431: );
2432: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2433: END IF;
2434: END IF;
2435: END IF;
2436:

Line 2456: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2452: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_INIT_VALUE',
2453: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2454: 'OSR', p_imp_psnode.ORIG_SYS_REF
2455: );
2456: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2457: END IF;
2458:
2459: IF (l_minimum_selected > l_maximum_selected AND l_maximum_selected <> -1) THEN
2460: l_disposition := 'R';

Line 2465: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2461: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INV_MINMAX',
2462: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2463: 'OSR', p_imp_psnode.ORIG_SYS_REF
2464: );
2465: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2466: END IF;
2467: END IF;
2468: END IF;
2469:

Line 2478: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2474: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_TYPE_INVALID',
2475: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2476: 'OSR', p_imp_psnode.ORIG_SYS_REF
2477: );
2478: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2479: END IF;
2480:
2481: IF(p_imp_psnode.NAME IS NULL) THEN
2482:

Line 2489: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2485: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_NAME_IS_NULL',
2486: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2487: 'OSR', p_imp_psnode.ORIG_SYS_REF
2488: );
2489: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2490: END IF;
2491:
2492: IF(p_imp_psnode.PS_NODE_TYPE NOT IN (cnReference,cnConnector) AND
2493: p_imp_psnode.REFERENCE_ID IS NOT NULL) THEN

Line 2501: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2497: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_REFID_NULL',
2498: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2499: 'OSR', p_imp_psnode.ORIG_SYS_REF
2500: );
2501: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2502: END IF;
2503:
2504: IF(p_imp_psnode.INSTANTIABLE_FLAG IS NULL) THEN
2505: sInstantiableFlag := NULL;

Line 2533: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2529: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_INSTFLAG',
2530: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2531: 'OSR', p_imp_psnode.ORIG_SYS_REF
2532: );
2533: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2534: END IF;
2535: END IF;
2536:
2537: IF (p_imp_psnode.DISPLAY_IN_SUMMARY_FLAG NOT IN (NULL,'1')) THEN

Line 2543: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2539: l_msg:=CZ_UTILS.GET_TEXT('CZ_IMP_PSNODE_SUMRY_FLAG',
2540: 'MODELNAME', p_imp_psnode.FSK_DEVLPROJECT_5_1,
2541: 'OSR', p_imp_psnode.ORIG_SYS_REF
2542: );
2543: x_error:=CZ_UTILS.LOG_REPORT(l_msg,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2544: END IF;
2545:
2546: IF l_disposition='R' THEN
2547: FAILED:=FAILED+1;

Line 2551: UPDATE cz_imp_ps_nodes SET

2547: FAILED:=FAILED+1;
2548: l_rec_status:='FAIL';
2549: END IF;
2550:
2551: UPDATE cz_imp_ps_nodes SET
2552: deleted_flag=DECODE(deleted_flag,NULL,'0',deleted_flag),
2553: system_node_flag=DECODE(system_node_flag,NULL,'0',SYSTEM_NODE_FLAG),
2554: instantiable_flag=DECODE(instantiable_flag,NULL,sInstantiableFlag,instantiable_flag),
2555: src_application_id=DECODE(src_application_id,NULL,cnDefSrcAppId,src_application_id),

Line 2580: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);

2576: RAISE;
2577: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
2578: RAISE;
2579: WHEN OTHERS THEN
2580: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.CND_PS_NODE',11276,inRun_Id);
2581: RAISE;
2582: END CND_PS_NODE ;
2583:
2584: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 2626: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_PS_NODE',11276,inRun_Id);

2622: WHEN NO_DATA_FOUND THEN
2623: INSERT INTO CZ_XFR_RUN_INFOS (RUN_ID,STARTED,LAST_ACTIVITY)
2624: VALUES(inRUN_ID,SYSDATE,SYSDATE);
2625: WHEN OTHERS THEN
2626: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.MAIN_PS_NODE',11276,inRun_Id);
2627: RAISE CZ_ADMIN.IMP_UNEXP_SQL_ERROR;
2628: END;
2629:
2630: if (CZ_IMP_ALL.get_time) then

Line 2672: CZ_IMP_PS_NODE.RPT_PS_NODE(inRUN_ID);

2668: /* Return the transferred number of rows and not the number of rows with keys resolved*/
2669: INSERTS:=nXfrInsertCount;
2670: UPDATES:=nXfrUpdateCount;
2671:
2672: CZ_IMP_PS_NODE.RPT_PS_NODE(inRUN_ID);
2673:
2674: END MAIN_PS_NODE ;
2675:
2676: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/

Line 2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;

2683: FAILED IN OUT NOCOPY PLS_INTEGER,
2684: inXFR_GROUP IN VARCHAR2
2685: ) IS
2686:
2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;

Line 2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;

2684: inXFR_GROUP IN VARCHAR2
2685: ) IS
2686:
2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

Line 2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;

2685: ) IS
2686:
2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;

Line 2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;

2686:
2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;

Line 2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;

2687: TYPE tPsNodeId IS TABLE OF cz_imp_ps_nodes.ps_node_id%TYPE INDEX BY BINARY_INTEGER;
2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

Line 2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;

2688: TYPE tDevlProjectId IS TABLE OF cz_imp_ps_nodes.devl_project_id%TYPE INDEX BY BINARY_INTEGER;
2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;

2689: TYPE tFromPopulatorId IS TABLE OF cz_imp_ps_nodes.from_populator_id%TYPE INDEX BY BINARY_INTEGER;
2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

Line 2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;

2690: TYPE tPropertyBackptr IS TABLE OF cz_imp_ps_nodes.property_backptr%TYPE INDEX BY BINARY_INTEGER;
2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;

Line 2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;

2691: TYPE tItemTypeBackptr IS TABLE OF cz_imp_ps_nodes.item_type_backptr%TYPE INDEX BY BINARY_INTEGER;
2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

Line 2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;

2692: TYPE tIntlTextId IS TABLE OF cz_imp_ps_nodes.intl_text_id%TYPE INDEX BY BINARY_INTEGER;
2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

Line 2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;

2693: TYPE tSubConsId IS TABLE OF cz_imp_ps_nodes.sub_cons_id%TYPE INDEX BY BINARY_INTEGER;
2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

Line 2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;

2694: TYPE tItemId IS TABLE OF cz_imp_ps_nodes.item_id%TYPE INDEX BY BINARY_INTEGER;
2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

Line 2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;

2695: TYPE tName IS TABLE OF cz_imp_ps_nodes.name%TYPE INDEX BY BINARY_INTEGER;
2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

Line 2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;

2696: TYPE tResourceFlag IS TABLE OF cz_imp_ps_nodes.resource_flag%TYPE INDEX BY BINARY_INTEGER;
2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;

2697: TYPE tInitialValue IS TABLE OF cz_imp_ps_nodes.initial_value%TYPE INDEX BY BINARY_INTEGER;
2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

Line 2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;

2698: TYPE tInitialNumValue IS TABLE OF cz_imp_ps_nodes.initial_num_value%TYPE INDEX BY BINARY_INTEGER;
2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;

2699: TYPE tParentId IS TABLE OF cz_imp_ps_nodes.parent_id%TYPE INDEX BY BINARY_INTEGER;
2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;

2700: TYPE tMinimum IS TABLE OF cz_imp_ps_nodes.minimum%TYPE INDEX BY BINARY_INTEGER;
2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;

2701: TYPE tMaximum IS TABLE OF cz_imp_ps_nodes.maximum%TYPE INDEX BY BINARY_INTEGER;
2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;

Line 2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;

2702: TYPE tPsNodeType IS TABLE OF cz_imp_ps_nodes.ps_node_type%TYPE INDEX BY BINARY_INTEGER;
2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;

2703: TYPE tFeatureType IS TABLE OF cz_imp_ps_nodes.feature_type%TYPE INDEX BY BINARY_INTEGER;
2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;

Line 2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;

2704: TYPE tProductFlag IS TABLE OF cz_imp_ps_nodes.product_flag%TYPE INDEX BY BINARY_INTEGER;
2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;

Line 2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;

2705: TYPE tReferenceId IS TABLE OF cz_imp_ps_nodes.reference_id%TYPE INDEX BY BINARY_INTEGER;
2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;

Line 2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;

2706: TYPE tMultiConfigFlag IS TABLE OF cz_imp_ps_nodes.multi_config_flag%TYPE INDEX BY BINARY_INTEGER;
2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

Line 2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;

2707: TYPE tOrderSeqFlag IS TABLE OF cz_imp_ps_nodes.order_seq_flag%TYPE INDEX BY BINARY_INTEGER;
2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;

Line 2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;

2708: TYPE tSystemNodeFlag IS TABLE OF cz_imp_ps_nodes.system_node_flag%TYPE INDEX BY BINARY_INTEGER;
2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;

Line 2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;

2709: TYPE tTreeSeq IS TABLE OF cz_imp_ps_nodes.tree_seq%TYPE INDEX BY BINARY_INTEGER;
2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;

Line 2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;

2710: TYPE tCountedOptionsFlag IS TABLE OF cz_imp_ps_nodes.counted_options_flag%TYPE INDEX BY BINARY_INTEGER;
2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;

2711: TYPE tUiOmit IS TABLE OF cz_imp_ps_nodes.ui_omit%TYPE INDEX BY BINARY_INTEGER;
2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

Line 2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;

2712: TYPE tUiSection IS TABLE OF cz_imp_ps_nodes.ui_section%TYPE INDEX BY BINARY_INTEGER;
2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

Line 2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;

2713: TYPE tBomTreatment IS TABLE OF cz_imp_ps_nodes.bom_treatment%TYPE INDEX BY BINARY_INTEGER;
2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;

Line 2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;

2714: TYPE tOrigSysRef IS TABLE OF cz_imp_ps_nodes.orig_sys_ref%TYPE INDEX BY BINARY_INTEGER;
2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;

Line 2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;

2715: TYPE tCheckoutUser IS TABLE OF cz_imp_ps_nodes.checkout_user%TYPE INDEX BY BINARY_INTEGER;
2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;

Line 2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;

2716: TYPE tDisposition IS TABLE OF cz_imp_ps_nodes.disposition%TYPE INDEX BY BINARY_INTEGER;
2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;

Line 2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;

2717: TYPE tRecStatus IS TABLE OF cz_imp_ps_nodes.rec_status%TYPE INDEX BY BINARY_INTEGER;
2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;

Line 2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;

2718: TYPE tDeletedFlag IS TABLE OF cz_imp_ps_nodes.deleted_flag%TYPE INDEX BY BINARY_INTEGER;
2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;

Line 2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;

2719: TYPE tEffectiveFrom IS TABLE OF cz_imp_ps_nodes.effective_from%TYPE INDEX BY BINARY_INTEGER;
2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;

Line 2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;

2720: TYPE tEffectiveUntil IS TABLE OF cz_imp_ps_nodes.effective_until%TYPE INDEX BY BINARY_INTEGER;
2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;

Line 2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;

2721: TYPE tEffectiveUsageMask IS TABLE OF cz_imp_ps_nodes.EFFECTIVE_USAGE_MASK%TYPE INDEX BY BINARY_INTEGER;
2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;

Line 2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;

2722: TYPE tUserStr01 IS TABLE OF cz_imp_ps_nodes.USER_STR01%TYPE INDEX BY BINARY_INTEGER;
2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;

2723: TYPE tUserStr02 IS TABLE OF cz_imp_ps_nodes.USER_STR02%TYPE INDEX BY BINARY_INTEGER;
2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

Line 2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;

2724: TYPE tUserStr03 IS TABLE OF cz_imp_ps_nodes.USER_STR03%TYPE INDEX BY BINARY_INTEGER;
2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line 2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;

2725: TYPE tUserStr04 IS TABLE OF cz_imp_ps_nodes.USER_STR04%TYPE INDEX BY BINARY_INTEGER;
2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

Line 2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;

2726: TYPE tUserNum01 IS TABLE OF cz_imp_ps_nodes.USER_NUM01%TYPE INDEX BY BINARY_INTEGER;
2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;

Line 2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;

2727: TYPE tUserNum02 IS TABLE OF cz_imp_ps_nodes.USER_NUM02%TYPE INDEX BY BINARY_INTEGER;
2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;

Line 2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;

2728: TYPE tUserNum03 IS TABLE OF cz_imp_ps_nodes.USER_NUM03%TYPE INDEX BY BINARY_INTEGER;
2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;

2729: TYPE tUserNum04 IS TABLE OF cz_imp_ps_nodes.USER_NUM04%TYPE INDEX BY BINARY_INTEGER;
2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;

Line 2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;

2730: TYPE tCreationDate IS TABLE OF cz_imp_ps_nodes.CREATION_DATE%TYPE INDEX BY BINARY_INTEGER;
2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;

Line 2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;

2731: TYPE tLastUpdateDate IS TABLE OF cz_imp_ps_nodes.LAST_UPDATE_DATE%TYPE INDEX BY BINARY_INTEGER;
2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;

Line 2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;

2732: TYPE tCreatedBy IS TABLE OF cz_imp_ps_nodes.CREATED_BY%TYPE INDEX BY BINARY_INTEGER;
2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;

2733: TYPE tLastUpdatedBy IS TABLE OF cz_imp_ps_nodes.LAST_UPDATED_BY%TYPE INDEX BY BINARY_INTEGER;
2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;

2734: TYPE tSecurityMask IS TABLE OF cz_imp_ps_nodes.SECURITY_MASK%TYPE INDEX BY BINARY_INTEGER;
2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;

2735: TYPE tPlanLevel IS TABLE OF cz_imp_ps_nodes.PLAN_LEVEL%TYPE INDEX BY BINARY_INTEGER;
2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;

2736: TYPE tSoItemTypeCode IS TABLE OF cz_imp_ps_nodes.SO_ITEM_TYPE_CODE%TYPE INDEX BY BINARY_INTEGER;
2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;

2737: TYPE tMinimumSelected IS TABLE OF cz_imp_ps_nodes.MINIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;

2738: TYPE tMaximumSelected IS TABLE OF cz_imp_ps_nodes.MAXIMUM_SELECTED%TYPE INDEX BY BINARY_INTEGER;
2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;

2739: TYPE tBomRequired IS TABLE OF cz_imp_ps_nodes.BOM_REQUIRED%TYPE INDEX BY BINARY_INTEGER;
2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

Line 2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;

2740: TYPE tComponentSequenceId IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_ID%TYPE INDEX BY BINARY_INTEGER;
2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;

Line 2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

2741: TYPE tOrganizationId IS TABLE OF cz_imp_ps_nodes.ORGANIZATION_ID%TYPE INDEX BY BINARY_INTEGER;
2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;

Line 2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;

2742: TYPE tTopItemId IS TABLE OF cz_imp_ps_nodes.TOP_ITEM_ID%TYPE INDEX BY BINARY_INTEGER;
2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;

Line 2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;

2743: TYPE tExplosionType IS TABLE OF cz_imp_ps_nodes.EXPLOSION_TYPE%TYPE INDEX BY BINARY_INTEGER;
2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

Line 2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;

2744: TYPE tDecimalQtyFlag IS TABLE OF cz_imp_ps_nodes.DECIMAL_QTY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;

Line 2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;

2745: TYPE tInstantiableFlag IS TABLE OF cz_imp_ps_nodes.INSTANTIABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;

Line 2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;

2746: TYPE tQuoteableFlag IS TABLE OF cz_imp_ps_nodes.QUOTEABLE_FLAG%TYPE INDEX BY BINARY_INTEGER;
2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;

2747: TYPE tPrimaryUomCode IS TABLE OF cz_imp_ps_nodes.PRIMARY_UOM_CODE%TYPE INDEX BY BINARY_INTEGER;
2748: TYPE tBomSortOrder IS TABLE OF cz_imp_ps_nodes.BOM_SORT_ORDER%TYPE INDEX BY BINARY_INTEGER;
2749: TYPE tComponentSequencePath IS TABLE OF cz_imp_ps_nodes.COMPONENT_SEQUENCE_PATH%TYPE INDEX BY BINARY_INTEGER;
2750: TYPE tIbTrackable IS TABLE OF cz_imp_ps_nodes.IB_TRACKABLE%TYPE INDEX BY BINARY_INTEGER;
2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;

Line 2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;

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

Line 2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;

2751: TYPE tSrcApplicationId IS TABLE OF cz_imp_ps_nodes.SRC_APPLICATION_ID%TYPE INDEX BY BINARY_INTEGER;
2752: TYPE tChar_tbl IS TABLE OF VARCHAR2(1) INDEX BY BINARY_INTEGER;
2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;

Line 2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;

2753: TYPE tModelType IS TABLE OF cz_imp_devl_project.MODEL_TYPE%TYPE INDEX BY BINARY_INTEGER;
2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
2760: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2761:

Line 2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;

2754: TYPE tDisplayInSummaryFlag IS TABLE OF cz_imp_ps_nodes.DISPLAY_IN_SUMMARY_FLAG%TYPE INDEX BY BINARY_INTEGER;
2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
2760: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2761:
2762: iPsNodeId tPsNodeId;

Line 2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;

2755: TYPE tIBLinkItemFlag IS TABLE OF cz_imp_ps_nodes.IB_LINK_ITEM_FLAG%TYPE INDEX BY BINARY_INTEGER;
2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
2760: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2761:
2762: iPsNodeId tPsNodeId;
2763: iDevlProjectId tDevlProjectId;

Line 2760: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;

2756:
2757: TYPE tPSShippableItemFlag IS TABLE OF cz_imp_ps_nodes.shippable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2758: TYPE tInventoryTransactableFlag IS TABLE OF cz_imp_ps_nodes.inventory_transactable_flag%TYPE INDEX BY BINARY_INTEGER;
2759: TYPE tAssembleToOrderFlag IS TABLE OF cz_imp_ps_nodes.assemble_to_order_flag%TYPE INDEX BY BINARY_INTEGER;
2760: TYPE tSerializableItemFlag IS TABLE OF cz_imp_ps_nodes.serializable_item_flag%TYPE INDEX BY BINARY_INTEGER;
2761:
2762: iPsNodeId tPsNodeId;
2763: iDevlProjectId tDevlProjectId;
2764: iFromPopulatorId tFromPopulatorId;

Line 2838: FROM cz_imp_ps_nodes

2834: -- PS nodes that are references, connectors or componentns, NOT ROOTS
2835: CURSOR l_model_refs_csr IS
2836: SELECT plan_level, ps_node_id, devl_project_id, reference_id,
2837: minimum, maximum, ps_node_type, parent_id, disposition
2838: FROM cz_imp_ps_nodes
2839: WHERE ps_node_type IN (cnReference,cnConnector,cnComponent)
2840: AND deleted_flag='0' AND rec_status='OK' AND run_id=inRun_ID
2841: ORDER BY plan_level, devl_project_id, reference_id;
2842:

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

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

Line 2850: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes

2846: ROOTS.ps_node_type, ROOTS.minimum, ROOTS.maximum, ROOTS.rec_status, ROOTS.name, d.model_type
2847: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS,cz_imp_devl_project d
2848: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
2849: AND ROOTS.devl_project_id=REFS.reference_id
2850: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes
2851: WHERE run_id=inRUN_ID
2852: AND rec_status='PASS'
2853: AND devl_project_id=ROOTS.devl_project_id
2854: AND ps_node_type IN (cnReference,cnConnector))

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

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

Line 2873: AND EXISTS (SELECT 1 FROM cz_imp_ps_nodes

2869: FROM cz_imp_ps_nodes ROOTS, cz_imp_ps_nodes REFS, cz_imp_devl_project d
2870: WHERE (ROOTS.ps_node_id = ROOTS.devl_project_id OR (ROOTS.parent_id IS NULL AND ROOTS.plan_level=0))
2871: AND ROOTS.ps_node_id = REFS.reference_id
2872: AND REFS.ps_node_type IN (cnReference,cnConnector)
2873: AND EXISTS (SELECT 1 FROM cz_imp_ps_nodes
2874: WHERE run_id=inRUN_ID
2875: AND rec_status='PASS'
2876: AND devl_project_id=ROOTS.devl_project_id
2877: AND ps_node_type IN (cnReference,cnConnector))

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

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

Line 2902: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes

2898: AND d.run_id=inRUN_ID
2899: AND d.rec_status='OK'
2900: AND REFS.rec_status='PASS'
2901: AND REFS.run_id=inRUN_ID
2902: AND NOT EXISTS (SELECT 1 FROM cz_imp_ps_nodes
2903: WHERE run_id=inRUN_ID
2904: AND rec_status='PASS'
2905: AND reference_id=ROOTS.devl_project_id
2906: AND ps_node_type IN (cnReference,cnConnector))

Line 2913: FROM cz_imp_ps_nodes p, cz_imp_devl_project d

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

Line 3005: FROM CZ_IMP_PS_NODES

3001: SHIPPABLE_ITEM_FLAG,
3002: INVENTORY_TRANSACTABLE_FLAG,
3003: ASSEMBLE_TO_ORDER_FLAG,
3004: SERIALIZABLE_ITEM_FLAG
3005: FROM CZ_IMP_PS_NODES
3006: WHERE CZ_IMP_PS_NODES.RUN_ID = inRUN_ID AND REC_STATUS='PASS'
3007: AND devl_project_id=inModelId AND disposition=inDisposition
3008: ORDER BY PLAN_LEVEL,USER_NUM04 DESC;
3009:

Line 3006: WHERE CZ_IMP_PS_NODES.RUN_ID = inRUN_ID AND REC_STATUS='PASS'

3002: INVENTORY_TRANSACTABLE_FLAG,
3003: ASSEMBLE_TO_ORDER_FLAG,
3004: SERIALIZABLE_ITEM_FLAG
3005: FROM CZ_IMP_PS_NODES
3006: WHERE CZ_IMP_PS_NODES.RUN_ID = inRUN_ID AND REC_STATUS='PASS'
3007: AND devl_project_id=inModelId AND disposition=inDisposition
3008: ORDER BY PLAN_LEVEL,USER_NUM04 DESC;
3009:
3010: x_xfr_psnode_f BOOLEAN:=FALSE;

Line 3096: l_disposition cz_imp_ps_nodes.disposition%type;

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

Line 3177: 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);

3173: LOOP
3174: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3175: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3176: ROLLBACK;
3177: 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);
3178: UPDATE CZ_IMP_PS_NODES
3179: SET REC_STATUS='ERR'
3180: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3181: AND DISPOSITION='I';

Line 3178: UPDATE CZ_IMP_PS_NODES

3174: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3175: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3176: ROLLBACK;
3177: 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);
3178: UPDATE CZ_IMP_PS_NODES
3179: SET REC_STATUS='ERR'
3180: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3181: AND DISPOSITION='I';
3182: COMMIT;

Line 3296: UPDATE CZ_IMP_PS_NODES

3292: nCommitCount:= nCommitCount + SQL%ROWCOUNT;
3293:
3294: BEGIN
3295: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
3296: UPDATE CZ_IMP_PS_NODES
3297: SET REC_STATUS='OK'
3298: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3299: AND DISPOSITION='I';
3300:

Line 3336: 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);

3332: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3333: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3334:
3335: ROLLBACK;
3336: 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);
3337: UPDATE CZ_IMP_PS_NODES
3338: SET REC_STATUS='ERR'
3339: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3340: AND DISPOSITION='I';

Line 3337: UPDATE CZ_IMP_PS_NODES

3333: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3334:
3335: ROLLBACK;
3336: 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);
3337: UPDATE CZ_IMP_PS_NODES
3338: SET REC_STATUS='ERR'
3339: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3340: AND DISPOSITION='I';
3341: COMMIT;

Line 3351: 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);

3347: FOR j IN iPsNodeID.FIRST..iPsNodeId.LAST LOOP -- singe row loop
3348:
3349: IF(FAILED >= MAX_ERR) THEN
3350: ROLLBACK;
3351: 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);
3352: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
3353: END IF;
3354:
3355: BEGIN -- single row insert

Line 3460: UPDATE CZ_IMP_PS_NODES

3456:
3457:
3458: nInsertCount:=nInsertCount+1;
3459:
3460: UPDATE CZ_IMP_PS_NODES
3461: SET REC_STATUS='OK'
3462: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3463: AND DISPOSITION='I';
3464:

Line 3502: UPDATE CZ_IMP_PS_NODES

3498: EXIT OUTER_LOOP;
3499: ELSE
3500: -- not a root node, so import continues
3501: FAILED:=FAILED +1;
3502: UPDATE CZ_IMP_PS_NODES
3503: SET REC_STATUS='ERR'
3504: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3505: AND DISPOSITION='I';
3506:

Line 3605: 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);

3601: LOOP
3602: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3603: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3604: ROLLBACK;
3605: 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);
3606: UPDATE CZ_IMP_PS_NODES
3607: SET REC_STATUS='ERR'
3608: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3609: AND DISPOSITION='M';

Line 3606: UPDATE CZ_IMP_PS_NODES

3602: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3603: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3604: ROLLBACK;
3605: 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);
3606: UPDATE CZ_IMP_PS_NODES
3607: SET REC_STATUS='ERR'
3608: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3609: AND DISPOSITION='M';
3610: COMMIT;

Line 3690: UPDATE CZ_IMP_PS_NODES

3686: nCommitCount:= nCommitCount + SQL%ROWCOUNT;
3687:
3688: BEGIN -- bulk update
3689: FORALL j IN iPsNodeID.FIRST..iPsNodeId.LAST
3690: UPDATE CZ_IMP_PS_NODES
3691: SET REC_STATUS='OK'
3692: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3693: AND DISPOSITION='M';
3694:

Line 3728: 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);

3724: LOOP
3725: IF (iPSNODETYPE(j)=263 AND (iMAXIMUMSELECTED(j) IS NULL OR iMAXIMUMSELECTED(j) IN(0,-1))) OR
3726: (iPSNODETYPE(j)<>263 AND (iMAXIMUM(j) IS NULL OR iMAXIMUM(j) IN(0,-1))) THEN
3727: ROLLBACK;
3728: 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);
3729: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
3730: END IF;
3731: END LOOP;
3732: END IF;

Line 3738: 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);

3734: FOR j IN iPsNodeID.FIRST..iPsNodeId.LAST LOOP -- single row loop
3735:
3736: IF (FAILED >= MAX_ERR) THEN
3737: ROLLBACK;
3738: 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);
3739: RAISE CZ_ADMIN.IMP_MAXERR_REACHED;
3740: END IF;
3741:
3742:

Line 3813: UPDATE CZ_IMP_PS_NODES -- single row update

3809: WHERE PS_NODE_ID=iPSNODEID(j);
3810:
3811: nUpdateCount:= nUpdateCount + 1;
3812:
3813: UPDATE CZ_IMP_PS_NODES -- single row update
3814: SET REC_STATUS='OK'
3815: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3816: AND DISPOSITION='M';
3817:

Line 3828: UPDATE CZ_IMP_PS_NODES

3824:
3825: EXCEPTION -- single row update
3826: WHEN OTHERS THEN
3827: FAILED:=FAILED +1;
3828: UPDATE CZ_IMP_PS_NODES
3829: SET REC_STATUS='ERR'
3830: WHERE PS_NODE_ID=iPSNODEID(j) AND RUN_ID=inRUN_ID
3831: AND DISPOSITION='M';
3832:

Line 3861: -- private procdure to delete PS nodes that are no longer present in the cz_imp_ps_nodes of this run id

3857:
3858: END update_ps_nodes;
3859:
3860:
3861: -- private procdure to delete PS nodes that are no longer present in the cz_imp_ps_nodes of this run id
3862: -- deletes the nodes logically and calls the cz_refs.delete_node logically to delete the expls
3863: -- for refs, connectors and non-virtual components
3864:
3865: PROCEDURE delete_ps_nodes(p_model_id IN NUMBER, x_retcode OUT NOCOPY NUMBER)

Line 3876: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes

3872: FROM cz_ps_nodes a
3873: WHERE deleted_flag = '0'
3874: AND devl_project_id = p_model_id
3875: AND ps_node_type IN (cnReference, cnConnector, cnComponent)
3876: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes
3877: WHERE orig_sys_ref = a.orig_sys_ref
3878: AND devl_project_id = p_model_id
3879: AND src_application_id = a.src_application_id
3880: AND run_id=inRun_Id);

Line 3890: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes

3886:
3887: UPDATE cz_ps_nodes a
3888: SET deleted_flag = '1'
3889: WHERE devl_project_id = p_model_id
3890: AND NOT EXISTS (SELECT NULL FROM cz_imp_ps_nodes
3891: WHERE orig_sys_ref = a.orig_sys_ref
3892: AND devl_project_id = p_model_id
3893: AND src_application_id = a.src_application_id
3894: AND run_id=inRun_Id);

Line 4385: UPDATE CZ_IMP_PS_NODES

4381: IF l_c1_prj_id_tbl.COUNT > 0 THEN
4382: FOR i IN l_c1_prj_id_tbl.FIRST..l_c1_prj_id_tbl.LAST LOOP
4383: IF l_c1_rec_status_tbl(i)='ERR' THEN
4384:
4385: UPDATE CZ_IMP_PS_NODES
4386: SET REC_STATUS='ERR'
4387: WHERE DEVL_PROJECT_ID=l_c1_prj_id_tbl(i)
4388: AND RUN_ID=inRUN_ID;
4389:

Line 4415: UPDATE CZ_IMP_PS_NODES

4411: IF l_c2_prj_id_tbl.COUNT > 0 THEN
4412: FOR i IN l_c2_prj_id_tbl.FIRST..l_c2_prj_id_tbl.LAST LOOP
4413: IF l_c2_rec_status_tbl(i) IN ('SKP','ERR') THEN
4414:
4415: UPDATE CZ_IMP_PS_NODES
4416: SET REC_STATUS=DECODE(l_c2_rec_status_tbl(i),'SKP','PASS',l_c2_rec_status_tbl(i))
4417: WHERE DEVL_PROJECT_ID=l_c2_prj_id_tbl(i)
4418: AND RUN_ID=inRUN_ID;
4419:

Line 4445: UPDATE CZ_IMP_PS_NODES

4441: IF l_c3_prj_id_tbl.COUNT > 0 THEN
4442: FOR i IN l_c3_prj_id_tbl.FIRST..l_c3_prj_id_tbl.LAST LOOP
4443: IF l_c3_rec_status_tbl(i) IN ('SKP','ERR') THEN
4444:
4445: UPDATE CZ_IMP_PS_NODES
4446: SET REC_STATUS=DECODE(l_c3_rec_status_tbl(i),'SKP','PASS',l_c3_rec_status_tbl(i))
4447: WHERE DEVL_PROJECT_ID=l_c3_prj_id_tbl(i)
4448: AND RUN_ID=inRUN_ID;
4449:

Line 4558: UPDATE CZ_IMP_PS_NODES

4554: IF l_c4_prj_id_tbl.COUNT > 0 THEN
4555: FOR i IN l_c4_prj_id_tbl.FIRST..l_c4_prj_id_tbl.LAST LOOP
4556: IF l_c4_rec_status_tbl(i)='ERR' THEN
4557:
4558: UPDATE CZ_IMP_PS_NODES
4559: SET REC_STATUS='ERR'
4560: WHERE DEVL_PROJECT_ID=l_c4_prj_id_tbl(i)
4561: AND RUN_ID=inRUN_ID;
4562:

Line 4612: UPDATE CZ_IMP_PS_NODES

4608: NULL);
4609:
4610: IF (p_out_err > 0) THEN
4611: FAILED:=FAILED +1;
4612: UPDATE CZ_IMP_PS_NODES
4613: SET REC_STATUS='ERR'
4614: WHERE PS_NODE_ID=l_PsNodeId(i)
4615: AND RUN_ID=inRUN_ID
4616: AND DISPOSITION=l_dis(i);

Line 4674: FROM CZ_IMP_PS_NODES

4670:
4671: DECLARE
4672: CURSOR c_xfr_run_result IS
4673: SELECT DISPOSITION,REC_STATUS,COUNT(*)
4674: FROM CZ_IMP_PS_NODES
4675: WHERE RUN_ID = inRUN_ID
4676: GROUP BY DISPOSITION,REC_STATUS;
4677:
4678: ins_disposition CZ_XFR_RUN_RESULTS.disposition%TYPE;

Line 4698: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);

4694: COMMIT;
4695:
4696: EXCEPTION
4697: WHEN OTHERS THEN
4698: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
4699: END;
4700:
4701: DECLARE
4702: nErrors PLS_INTEGER;

Line 4718: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);

4714: WHERE RUN_ID=inRUN_ID;
4715: COMMIT;
4716: EXCEPTION
4717: WHEN OTHERS THEN
4718: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
4719: END;
4720: EXCEPTION
4721: WHEN CZ_ADMIN.IMP_MAXERR_REACHED THEN
4722: RAISE;

Line 4726: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);

4722: RAISE;
4723: WHEN CZ_ADMIN.IMP_UNEXP_SQL_ERROR THEN
4724: RAISE;
4725: WHEN OTHERS THEN
4726: x_error:=CZ_UTILS.LOG_REPORT(SQLERRM,1,'CZ_IMP_PS_NODE.RPT_PS_NODE',11276,inRun_Id);
4727: END;
4728: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
4729:
4730: /*--PS_NODE IMPORT SECTION END----------------------------------------------*/

Line 4732: END CZ_IMP_PS_NODE;

4728: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
4729:
4730: /*--PS_NODE IMPORT SECTION END----------------------------------------------*/
4731: /*<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<<0>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>*/
4732: END CZ_IMP_PS_NODE;