[Home] [Help]
1768: nFailed PLS_INTEGER:=0; /*Failed records */
1769: nDups PLS_INTEGER:=0; /*Dupl records */
1770: x_usesurr_psnode PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_PS_NODES',inXFR_GROUP);
1771: x_usesurr_intltext PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_INTL_TEXTS',inXFR_GROUP);
1772: x_usesurr_itemmaster PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_ITEM_MASTERS',inXFR_GROUP);
1773: x_usesurr_devlproject PLS_INTEGER:=CZ_UTILS.GET_PK_USEEXPANSION_FLAG('CZ_DEVL_PROJECTS',inXFR_GROUP);
1774: nAllocateBlock PLS_INTEGER:=1;
1775: nAllocateCounter PLS_INTEGER;
1776: nNextValue NUMBER;
1864:
1865: /* Check that the Online data exists for the 2 FSK */
1866: DECLARE
1867: CURSOR c_onl_itemmaster IS
1868: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
1869: WHERE ORIG_SYS_REF=sFSKITEMMASTER21 AND deleted_flag = '0'
1870: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
1871: CURSOR c_onl_itemmaster_usesurr IS
1872: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
1868: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
1869: WHERE ORIG_SYS_REF=sFSKITEMMASTER21 AND deleted_flag = '0'
1870: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
1871: CURSOR c_onl_itemmaster_usesurr IS
1872: SELECT ITEM_ID,REF_PART_NBR FROM CZ_ITEM_MASTERS
1873: WHERE ORIG_SYS_REF=sFSKITEMMASTER2EXT AND deleted_flag = '0'
1874: AND SRC_APPLICATION_ID=nFSKITEMMASTER22;
1875: BEGIN
1876: nDebug := 1009;
1941: SELECT name FROM cz_imp_devl_project
1942: WHERE devl_project_id = nOnlDevlProjectId
1943: AND RUN_ID=inRun_ID;
1944: CURSOR c_onl_refpartnbr IS
1945: SELECT ref_part_nbr FROM cz_item_masters
1946: WHERE item_id = nReferredItemId;
1947: CURSOR c_reference IS
1948: SELECT p.PS_NODE_ID, p.devl_project_id, p.item_id FROM CZ_PS_NODES p, CZ_DEVL_PROJECTS d
1949: WHERE p.ORIG_SYS_REF = sFSKREFERENCE