5303: BEGIN
5304:
5305: -- WHENEVER NOT FOUND CONTINUE;
5306:
5307: IF (NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
5308: IF (PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_itemid,p_orgid) = 'Y') THEN
5309: IF (p_srctype = 3 AND p_acttype in(3,21) AND p_unit_number IS NOT NULL) then
5310: l_unit_no_ok := 0;
5311: SELECT count(1) INTO l_unit_no_ok
5304:
5305: -- WHENEVER NOT FOUND CONTINUE;
5306:
5307: IF (NVL(PJM_UNIT_EFF.ENABLED,'N') = 'Y') THEN
5308: IF (PJM_UNIT_EFF.UNIT_EFFECTIVE_ITEM(p_itemid,p_orgid) = 'Y') THEN
5309: IF (p_srctype = 3 AND p_acttype in(3,21) AND p_unit_number IS NOT NULL) then
5310: l_unit_no_ok := 0;
5311: SELECT count(1) INTO l_unit_no_ok
5312: FROM PJM_UNIT_NUMBERS_LOV_V