410: , p_object_version_number NUMBER
411: ) IS
412: CURSOR l_insert IS
413: SELECT ROWID
414: FROM iex_dunning_transactions
415: WHERE dunning_trx_id = px_dunning_trx_id;
416: --
417: CURSOR get_seq_csr is
418: SELECT iex_dunning_transactions_s.nextval
414: FROM iex_dunning_transactions
415: WHERE dunning_trx_id = px_dunning_trx_id;
416: --
417: CURSOR get_seq_csr is
418: SELECT iex_dunning_transactions_s.nextval
419: FROM sys.dual;
420: BEGIN
421: --
422: If (px_dunning_trx_id IS NULL) OR (px_dunning_trx_id = FND_API.G_MISS_NUM) then
425: CLOSE get_seq_csr;
426: End If;
427: --Start adding for bug 8489610 by gnramasa 14-May-09
428: --
429: INSERT INTO IEX_DUNNING_TRANSACTIONS (
430: DUNNING_TRX_ID
431: , DUNNING_ID
432: , CUST_TRX_ID
433: , PAYMENT_SCHEDULE_ID