[Home] [Help]
2090: nNoChangeCount PLS_INTEGER:=0;
2091: dispositionflag PLS_INTEGER:=0; /*Disposition Counter*/
2092: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES',inXFR_GROUP);
2093: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_INTL_TEXTS',inXFR_GROUP);
2094: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
2095: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS',inXFR_GROUP);
2096: nAllocateBlock PLS_INTEGER:=1;
2097: nAllocateCounter PLS_INTEGER;
2098: nNextValue NUMBER;
2203:
2204: /* Check that the Online data exists for the 2 FSK */
2205: DECLARE
2206: CURSOR c_onl_itemmaster IS
2207: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
2208: WHERE ORIG_SYS_REF=sFSKITEMMASTER21 AND deleted_flag = '0'
2209: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
2210: CURSOR c_onl_itemmaster_usesurr IS
2211: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
2207: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
2208: WHERE ORIG_SYS_REF=sFSKITEMMASTER21 AND deleted_flag = '0'
2209: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
2210: CURSOR c_onl_itemmaster_usesurr IS
2211: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
2212: WHERE ORIG_SYS_REF=sFSKITEMMASTER2EXT AND deleted_flag = '0'
2213: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
2214: BEGIN
2215: nDebug := 1009;
2294: SELECT name FROM cz_imp_devl_project
2295: WHERE devl_project_id = nOnlDevlProjectId
2296: AND RUN_ID=inRun_ID;
2297: CURSOR c_onl_refpartnbr IS
2298: SELECT ref_part_nbr FROM cz_item_masters
2299: WHERE item_id = nReferredItemId;
2300: CURSOR c_reference IS
2301: SELECT p.PS_NODE_ID, p.devl_project_id, p.item_id FROM CZ_PS_NODES p, CZ_DEVL_PROJECTS d
2302: WHERE p.ORIG_SYS_REF = sFSKREFERENCE