12267: RAISE G_EXCEPTION_HALT_VALIDATION;
12268: END IF;
12269:
12270: -- Delete Header billing schedule bug# 4188236
12271: DELETE FROM OKS_LEVEL_ELEMENTS
12272: WHERE RUL_ID IN
12273: (SELECT SLL.ID
12274: FROM OKS_STREAM_LEVELS_B SLL
12275: WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);
12391: okc_debug.log('1070: Completed header update ' || l_return_status );
12392: END IF;
12393:
12394: -- Delete Header billing schedule bug# 4188236
12395: DELETE FROM OKS_LEVEL_ELEMENTS
12396: WHERE RUL_ID IN
12397: (SELECT SLL.ID
12398: FROM OKS_STREAM_LEVELS_B SLL
12399: WHERE SLL.DNZ_CHR_ID=P_CHR_ID and CLE_ID IS NULL);