Line 85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL;
81: ) IS
82:
83: CURSOR C IS SELECT ROWID FROM CE_PAYMENT_TRANSACTIONS
84: WHERE TRXN_REFERENCE_NUMBER = X_TRXN_REFERENCE_NUMBER; 85: CURSOR C1 IS SELECT CE_PAYMENT_TRANSACTIONS_S.NEXTVAL FROM DUAL; 86:
87: BEGIN
88: IF ( X_TRXN_REFERENCE_NUMBER ) IS NULL THEN
89: OPEN C1;