eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_PMT_TRANS_PVT dependencies on CN_PAYMENT_TRANSACTIONS

Line 31: cn_payment_transactions pmttrxeo,

27: pmttrxeo.incentive_type_code,
28: pmttrxeo.waive_flag,
29: pmttrxeo.recoverable_flag
30: FROM
31: cn_payment_transactions pmttrxeo,
32: cn_commission_headers ch,
33: (select cust_acct.cust_account_id customer_id,
34: party.party_name customer_name
35: from hz_parties party, hz_cust_accounts cust_acct

Line 296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,

292: p_validation_level IN NUMBER,
293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,

Line 297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,

293: x_return_status OUT NOCOPY VARCHAR2,
294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,

Line 298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,

294: x_msg_count OUT NOCOPY NUMBER,
295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,

Line 299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,

295: x_msg_data OUT NOCOPY VARCHAR2,
296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,

Line 300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,

296: p_payment_transaction_id IN cn_payment_transactions.payment_transaction_id%TYPE,
297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
304: x_status OUT NOCOPY VARCHAR2,

Line 301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,

297: p_hold_flag IN cn_payment_transactions.hold_flag%TYPE,
298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
304: x_status OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,

Line 302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,

298: p_recoverable_flag IN cn_payment_transactions.recoverable_flag%TYPE,
299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
304: x_status OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: --R12

Line 303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,

299: p_payment_amount IN cn_payment_transactions.payment_amount%TYPE,
300: p_waive_flag IN cn_payment_transactions.waive_flag%TYPE,
301: p_incentive_type_code IN cn_payment_transactions.incentive_type_code%TYPE,
302: p_payrun_id IN cn_payment_transactions.payrun_id%TYPE,
303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
304: x_status OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: --R12
307: p_org_id IN cn_payment_transactions.org_id%TYPE,

Line 307: p_org_id IN cn_payment_transactions.org_id%TYPE,

303: p_salesrep_id IN cn_payment_transactions.credited_salesrep_id%TYPE,
304: x_status OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: --R12
307: p_org_id IN cn_payment_transactions.org_id%TYPE,
308: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE
309: )
310: IS
311: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Pmt_Transactions';

Line 308: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE

304: x_status OUT NOCOPY VARCHAR2,
305: x_loading_status OUT NOCOPY VARCHAR2,
306: --R12
307: p_org_id IN cn_payment_transactions.org_id%TYPE,
308: p_object_version_number IN OUT NOCOPY cn_payment_transactions.object_version_number%TYPE
309: )
310: IS
311: l_api_name CONSTANT VARCHAR2 (30) := 'Update_Pmt_Transactions';
312: l_api_version CONSTANT NUMBER := 1.0;

Line 341: FROM cn_payment_transactions

337: credited_salesrep_id,
338: --R12
339: org_id,
340: object_version_number ovn
341: FROM cn_payment_transactions
342: WHERE payment_transaction_id = p_payment_transaction_id;
343:
344: -- clku, bug 2451907, fixed the Group by statement, adding waive_flag
345: CURSOR get_earnings (

Line 346: p_quota_id cn_payment_transactions.quota_id%TYPE

342: WHERE payment_transaction_id = p_payment_transaction_id;
343:
344: -- clku, bug 2451907, fixed the Group by statement, adding waive_flag
345: CURSOR get_earnings (
346: p_quota_id cn_payment_transactions.quota_id%TYPE
347: )
348: IS
349: SELECT NVL (SUM (NVL (amount, 0)), 0) earn_amount
350: -- 12/25/02 RC bug 2710066

Line 354: FROM cn_payment_transactions

350: -- 12/25/02 RC bug 2710066
351: -- Commenting out waive_flag and quota_id from group by
352: -- quota_id
353: --, waive_flag
354: FROM cn_payment_transactions
355: WHERE payrun_id = p_payrun_id
356: AND credited_salesrep_id = p_salesrep_id
357: AND NVL (paid_flag, 'N') = 'N'
358: AND NVL (hold_flag, 'N') = 'N'

Line 391: p_payrun_id cn_payment_transactions.payrun_id%TYPE,

387: pmt_trans_rec get_pmt_trans%ROWTYPE;
388:
389: -- get the worksheet when waive the recovery
390: CURSOR get_wksht (
391: p_payrun_id cn_payment_transactions.payrun_id%TYPE,
392: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
393: p_quota_id cn_payment_transactions.quota_id%TYPE
394: )
395: IS

Line 392: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,

388:
389: -- get the worksheet when waive the recovery
390: CURSOR get_wksht (
391: p_payrun_id cn_payment_transactions.payrun_id%TYPE,
392: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
393: p_quota_id cn_payment_transactions.quota_id%TYPE
394: )
395: IS
396: SELECT *

Line 393: p_quota_id cn_payment_transactions.quota_id%TYPE

389: -- get the worksheet when waive the recovery
390: CURSOR get_wksht (
391: p_payrun_id cn_payment_transactions.payrun_id%TYPE,
392: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE,
393: p_quota_id cn_payment_transactions.quota_id%TYPE
394: )
395: IS
396: SELECT *
397: FROM cn_payment_worksheets

Line 403: FROM cn_payment_transactions

399: AND salesrep_id = p_salesrep_id
400: AND quota_id = p_quota_id
401: AND EXISTS (
402: SELECT 1
403: FROM cn_payment_transactions
404: WHERE payrun_id = p_payrun_id
405: AND credited_salesrep_id = p_salesrep_id
406: AND quota_id = p_quota_id
407: AND NVL (waive_flag, 'N') = 'N'

Line 411: p_quota_id cn_payment_transactions.quota_id%TYPE

407: AND NVL (waive_flag, 'N') = 'N'
408: AND incentive_type_code <> 'PMTPLN');
409:
410: CURSOR get_payment_worksheet (
411: p_quota_id cn_payment_transactions.quota_id%TYPE
412: )
413: IS
414: SELECT *
415: FROM cn_payment_worksheets

Line 422: p_quota_id cn_payment_transactions.quota_id%TYPE

418: AND payrun_id = p_payrun_id;
419:
420: -- Bug 2795606 : use amount since get_cp will handle adj amt
421: CURSOR get_mpa (
422: p_quota_id cn_payment_transactions.quota_id%TYPE
423: )
424: IS
425: SELECT NVL (SUM (NVL (amount, 0)), 0) mpa_amount
426: FROM cn_payment_transactions

Line 426: FROM cn_payment_transactions

422: p_quota_id cn_payment_transactions.quota_id%TYPE
423: )
424: IS
425: SELECT NVL (SUM (NVL (amount, 0)), 0) mpa_amount
426: FROM cn_payment_transactions
427: WHERE credited_salesrep_id = p_salesrep_id
428: AND quota_id = p_quota_id
429: AND payrun_id = p_payrun_id
430: AND incentive_type_code = 'MANUAL_PAY_ADJ' ;

Line 435: p_quota_id cn_payment_transactions.quota_id%TYPE

431:
432: l_mpa NUMBER;
433:
434: CURSOR get_cp (
435: p_quota_id cn_payment_transactions.quota_id%TYPE
436: )
437: IS
438: SELECT NVL (SUM (NVL (payment_amount, 0) - NVL (amount, 0)), 0) cp_amount
439: FROM cn_payment_transactions

Line 439: FROM cn_payment_transactions

435: p_quota_id cn_payment_transactions.quota_id%TYPE
436: )
437: IS
438: SELECT NVL (SUM (NVL (payment_amount, 0) - NVL (amount, 0)), 0) cp_amount
439: FROM cn_payment_transactions
440: WHERE credited_salesrep_id = p_salesrep_id
441: AND quota_id = p_quota_id
442: AND payrun_id = p_payrun_id
443: AND incentive_type_code NOT IN ('PMTPLN', 'PMTPLN_REC')

Line 451: p_quota_id cn_payment_transactions.quota_id%TYPE

447: l_cp NUMBER;
448:
449: -- (3) get payment holds
450: CURSOR get_ph (
451: p_quota_id cn_payment_transactions.quota_id%TYPE
452: )
453: IS
454: SELECT NVL (SUM (NVL (payment_amount, 0)), 0) ph_amount
455: FROM cn_payment_transactions

Line 455: FROM cn_payment_transactions

451: p_quota_id cn_payment_transactions.quota_id%TYPE
452: )
453: IS
454: SELECT NVL (SUM (NVL (payment_amount, 0)), 0) ph_amount
455: FROM cn_payment_transactions
456: WHERE credited_salesrep_id = p_salesrep_id
457: AND quota_id = p_quota_id
458: AND payrun_id = p_payrun_id
459: AND hold_flag = 'Y'

Line 467: p_quota_id cn_payment_transactions.quota_id%TYPE

463:
464: -- (4) get waive = nrec
465: --bug 3114349, issue 3. Added quota_id as a parameter.
466: CURSOR get_wv (
467: p_quota_id cn_payment_transactions.quota_id%TYPE
468: )
469: IS
470: SELECT -NVL (SUM (NVL (payment_amount, 0)), 0) wv_amount
471: FROM cn_payment_transactions

Line 471: FROM cn_payment_transactions

467: p_quota_id cn_payment_transactions.quota_id%TYPE
468: )
469: IS
470: SELECT -NVL (SUM (NVL (payment_amount, 0)), 0) wv_amount
471: FROM cn_payment_transactions
472: WHERE credited_salesrep_id = p_salesrep_id
473: -- AND quota_id is null
474: AND payrun_id = p_payrun_id
475: AND waive_flag = 'Y'

Line 483: p_quota_id cn_payment_transactions.quota_id%TYPE

479: l_wv NUMBER;
480:
481: --fix for bug: 2848235
482: CURSOR get_pmt_trans_amt (
483: p_quota_id cn_payment_transactions.quota_id%TYPE
484: )
485: IS
486: SELECT NVL (SUM (NVL (amount, 0)), 0) amount,
487: NVL (SUM (NVL (payment_amount, 0)), 0) payment_amount

Line 488: FROM cn_payment_transactions

484: )
485: IS
486: SELECT NVL (SUM (NVL (amount, 0)), 0) amount,
487: NVL (SUM (NVL (payment_amount, 0)), 0) payment_amount
488: FROM cn_payment_transactions
489: WHERE credited_salesrep_id = p_salesrep_id
490: AND quota_id = p_quota_id
491: AND payrun_id = p_payrun_id
492: AND (hold_flag = 'N' OR hold_flag IS NULL)

Line 501: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE

497:
498: --bug 3114349, issue 3.
499: CURSOR get_waive_quota_id (
500: p_payrun_id cn_payruns.payrun_id%TYPE,
501: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE
502: )
503: IS
504: SELECT -NVL (SUM (NVL (payment_amount, 0)), 0) payment_amount,
505: quota_id

Line 506: FROM cn_payment_transactions

502: )
503: IS
504: SELECT -NVL (SUM (NVL (payment_amount, 0)), 0) payment_amount,
505: quota_id
506: FROM cn_payment_transactions
507: WHERE payrun_id = p_payrun_id
508: AND credited_salesrep_id = p_salesrep_id
509: AND credit_type_id = -1000
510: AND incentive_type_code = 'PMTPLN_REC'

Line 515: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE

511: GROUP BY quota_id;
512:
513: CURSOR get_waive_flag (
514: p_payrun_id cn_payruns.payrun_id%TYPE,
515: p_salesrep_id cn_payment_transactions.credited_salesrep_id%TYPE
516: )
517: IS
518: SELECT NVL (waive_flag, 'N') waive_flag,
519: object_version_number ovn

Line 520: FROM cn_payment_transactions

516: )
517: IS
518: SELECT NVL (waive_flag, 'N') waive_flag,
519: object_version_number ovn
520: FROM cn_payment_transactions
521: WHERE payrun_id = p_payrun_id
522: AND credited_salesrep_id = p_salesrep_id
523: AND credit_type_id = -1000
524: AND incentive_type_code = 'PMTPLN_REC'

Line 527: l_waive_flag cn_payment_transactions.waive_flag%TYPE;

523: AND credit_type_id = -1000
524: AND incentive_type_code = 'PMTPLN_REC'
525: AND ROWNUM < 2;
526:
527: l_waive_flag cn_payment_transactions.waive_flag%TYPE;
528: l_waive_flag_db cn_payment_transactions.waive_flag%TYPE;
529: l_change_waive_flag NUMBER;
530: l_waive_amount NUMBER;
531: l_waive_amount_total NUMBER;

Line 528: l_waive_flag_db cn_payment_transactions.waive_flag%TYPE;

524: AND incentive_type_code = 'PMTPLN_REC'
525: AND ROWNUM < 2;
526:
527: l_waive_flag cn_payment_transactions.waive_flag%TYPE;
528: l_waive_flag_db cn_payment_transactions.waive_flag%TYPE;
529: l_change_waive_flag NUMBER;
530: l_waive_amount NUMBER;
531: l_waive_amount_total NUMBER;
532: l_waive_factor NUMBER;

Line 669: UPDATE cn_payment_transactions

665: RAISE fnd_api.g_exc_error;
666: END IF;
667: END IF;
668:
669: UPDATE cn_payment_transactions
670: SET hold_flag = p_hold_flag,
671: recoverable_flag = DECODE (p_incentive_type_code, 'MANUAL_PAY_ADJ', p_recoverable_flag, 'N'),
672: -- bug 3146137
673: amount = DECODE (p_incentive_type_code, 'MANUAL_PAY_ADJ', p_payment_amount, amount),

Line 764: UPDATE cn_payment_transactions

760: AND quota_id IS NULL
761: ;
762: END IF;
763:
764: UPDATE cn_payment_transactions
765: SET waive_flag = p_waive_flag,
766: object_version_number = nvl(object_version_number,0) + 1,
767: -- bug 3080846
768: last_update_date = SYSDATE,

Line 788: DELETE FROM cn_payment_transactions

784: INTO pmt_trans_rec_amount;
785:
786: CLOSE get_pmt_trans_amt;
787:
788: DELETE FROM cn_payment_transactions
789: WHERE payment_transaction_id IN (
790: SELECT payment_transaction_id
791: FROM cn_payment_transactions
792: WHERE quota_id = pmt_trans_rec.quota_id

Line 791: FROM cn_payment_transactions

787:
788: DELETE FROM cn_payment_transactions
789: WHERE payment_transaction_id IN (
790: SELECT payment_transaction_id
791: FROM cn_payment_transactions
792: WHERE quota_id = pmt_trans_rec.quota_id
793: AND payrun_id = p_payrun_id
794: AND credited_salesrep_id = p_salesrep_id
795: AND (hold_flag = 'N' OR hold_flag IS NULL)

Line 800: UPDATE cn_payment_transactions

796: AND incentive_type_code IN ('COMMISSION', 'BONUS')
797: )
798: AND payment_transaction_id <> p_payment_transaction_id;
799:
800: UPDATE cn_payment_transactions
801: SET amount = pmt_trans_rec_amount.amount,
802: payment_amount = pmt_trans_rec_amount.payment_amount,
803: object_version_number = object_version_number + 1,
804: -- bug 3080846

Line 900: FROM cn_payment_transactions

896: IF p_payment_transaction_id IS NOT NULL
897: THEN
898: SELECT object_version_number
899: INTO p_object_version_number
900: FROM cn_payment_transactions
901: WHERE payment_transaction_id = p_payment_transaction_id;
902:
903: -- when waiving recovery on all trxns
904: ELSIF p_payment_transaction_id IS NULL

Line 965: p_org_id IN cn_payment_transactions.org_id%TYPE,

961: p_incentive_type_code IN VARCHAR2,
962: p_recoverable_flag IN VARCHAR2,
963: p_payment_amount IN NUMBER,
964: p_quota_id IN NUMBER,
965: p_org_id IN cn_payment_transactions.org_id%TYPE,
966: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,
967: x_pmt_transaction_id OUT NOCOPY NUMBER,
968: x_status OUT NOCOPY VARCHAR2,
969: x_loading_status OUT NOCOPY VARCHAR2,

Line 966: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,

962: p_recoverable_flag IN VARCHAR2,
963: p_payment_amount IN NUMBER,
964: p_quota_id IN NUMBER,
965: p_org_id IN cn_payment_transactions.org_id%TYPE,
966: p_object_version_number IN cn_payment_transactions.object_version_number%TYPE,
967: x_pmt_transaction_id OUT NOCOPY NUMBER,
968: x_status OUT NOCOPY VARCHAR2,
969: x_loading_status OUT NOCOPY VARCHAR2,
970: x_return_status OUT NOCOPY VARCHAR2,

Line 984: l_pay_element_type_id cn_payment_transactions.pay_element_type_id%TYPE;

980: l_posting_batch_id NUMBER;
981: l_rec_amount NUMBER := 0;
982: l_nrec_amount NUMBER := 0;
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;

Line 991: l_pmt_tran_id cn_payment_transactions.payment_transaction_id%TYPE;

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;
992:
993: CURSOR get_apps
994: IS
995: SELECT payables_flag

Line 1360: FROM cn_payment_transactions

1356: posting_batch_id,
1357: quota_id,
1358: org_id,
1359: object_version_number ovn
1360: FROM cn_payment_transactions
1361: WHERE payment_transaction_id = p_payment_transaction_id;
1362:
1363: trans_rec get_pmt_trans%ROWTYPE;
1364: l_adj_rec NUMBER := 0;

Line 1552: cn_payment_transactions cpt

1548: cpw.org_id,
1549: cpt.object_version_number ovn
1550: FROM cn_payruns cp,
1551: cn_payment_worksheets cpw,
1552: cn_payment_transactions cpt
1553: WHERE cpw.payment_worksheet_id = p_payment_worksheet_id
1554: AND cp.payrun_id = cpw.payrun_id
1555: AND cp.payrun_id = cpt.payrun_id
1556: AND cpw.salesrep_id = cpt.credited_salesrep_id