DBA Data[Home] [Help]

APPS.CN_PMT_TRANS_PVT dependencies on CN_PMT_TRANS_PKG

Line 323: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type;

319: l_new_amount NUMBER;
320: l_pbt_profile_value VARCHAR2 (01) := 'N';
321: l_count NUMBER;
322: l_earnings NUMBER;
323: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type;
324: l_recovery_amount NUMBER;
325: l_payment_amount NUMBER;
326: l_wksht_ovn NUMBER;
327:

Line 987: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type;

983: l_pay_date DATE;
984: l_pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE;
985: l_rowid VARCHAR2 (100);
986: l_quota_id NUMBER;
987: l_pmt_trans_rec cn_pmt_trans_pkg.pmt_trans_rec_type;
988: l_batch_rec cn_prepostbatches.posting_batch_rec_type;
989: --Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by Julia Huang on 9/1/04.
990: l_payables_flag cn_repositories.payables_flag%TYPE;
991: l_pmt_tran_id cn_payment_transactions.payment_transaction_id%TYPE;

Line 1208: cn_pmt_trans_pkg.INSERT_RECORD (p_tran_rec => l_pmt_trans_rec);

1204: --R12
1205: l_pmt_trans_rec.org_id := p_org_id;
1206: l_pmt_trans_rec.object_version_number := 1;
1207: -- Call Table hander to Insert Payment Transactions
1208: cn_pmt_trans_pkg.INSERT_RECORD (p_tran_rec => l_pmt_trans_rec);
1209: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1210: l_pmt_tran_id := cn_pmt_trans_pkg.get_pmt_tran_id;
1211: x_pmt_transaction_id := l_pmt_tran_id ;
1212:

Line 1210: l_pmt_tran_id := cn_pmt_trans_pkg.get_pmt_tran_id;

1206: l_pmt_trans_rec.object_version_number := 1;
1207: -- Call Table hander to Insert Payment Transactions
1208: cn_pmt_trans_pkg.INSERT_RECORD (p_tran_rec => l_pmt_trans_rec);
1209: -- Bug 3866089 (the same as 11.5.8 bug 3841926, 11.5.10 3866116) by jjhuang on 11/1/04
1210: l_pmt_tran_id := cn_pmt_trans_pkg.get_pmt_tran_id;
1211: x_pmt_transaction_id := l_pmt_tran_id ;
1212:
1213: -- Update the payment Worksheets based on the recoverable flag
1214: IF NVL (p_recoverable_flag, 'N') = 'N'

Line 1453: cn_pmt_trans_pkg.DELETE_RECORD (p_payment_transaction_id);

1449: DELETE FROM cn_posting_batches cnpb
1450: WHERE cnpb.posting_batch_id = trans_rec.posting_batch_id;
1451:
1452: -- Delete the payment Transactions
1453: cn_pmt_trans_pkg.DELETE_RECORD (p_payment_transaction_id);
1454:
1455: -- assign to a variable to get the payment transaction amounts
1456: IF NVL (trans_rec.recoverable_flag, 'N') = 'N'
1457: THEN