88: WHEN NO_DATA_FOUND THEN
89: RETURN NULL;
90: WHEN OTHERS THEN
91: AP_WEB_DB_UTIL_PKG.RaiseException('get_shortpaid_audit_code');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93:
94: END get_shortpaid_audit_code;
95:
96: /*========================================================================
1810:
1811: EXCEPTION
1812: WHEN OTHERS THEN
1813: AP_WEB_DB_UTIL_PKG.RaiseException('process_audit_actions');
1814: APP_EXCEPTION.RAISE_EXCEPTION;
1815: END process_audit_actions;
1816:
1817: /*========================================================================
1818: | PUBLIC PROCEDURE update_cc_transaction