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_WORKSHEETS

Line 84: l_status cn_payment_worksheets.worksheet_status%TYPE ;

80: l_api_version CONSTANT NUMBER := 1.0;
81: l_request_id NUMBER := NULL ;
82: l_org_id NUMBER := NULL ;
83: l_worksheet_id NUMBER := NULL;
84: l_status cn_payment_worksheets.worksheet_status%TYPE ;
85: l_ovn NUMBER := NULL ;
86: request_id NUMBER;
87: l_phase VARCHAR2(4000);
88: l_req_status VARCHAR2(4000);

Line 122: FROM cn_payment_worksheets

118: payment_worksheet_id,
119: object_version_number,
120: org_id
121: INTO l_status, l_request_id, p_rec.worksheet_id,l_ovn, p_rec.org_id
122: FROM cn_payment_worksheets
123: WHERE quota_id is null
124: AND payrun_id = p_rec.payrun_id
125: AND salesrep_id = p_rec.salesrep_id ;
126:

Line 370: FROM cn_payment_worksheets

366: -- 12/25/02 RC bug 2710066
367: CURSOR get_wksht_nullqid
368: IS
369: SELECT NVL (SUM (NVL (pmt_amount_calc, 0)), 0) earn_amount
370: FROM cn_payment_worksheets
371: WHERE payrun_id = p_payrun_id
372: AND salesrep_id = p_salesrep_id
373: AND quota_id IS NULL;
374:

Line 380: FROM cn_payment_worksheets

376:
377: CURSOR get_wksht_notnullqid
378: IS
379: SELECT NVL (SUM (NVL (pmt_amount_calc, 0)), 0) earn_amount
380: FROM cn_payment_worksheets
381: WHERE payrun_id = p_payrun_id
382: AND salesrep_id = p_salesrep_id AND quota_id IS NOT NULL
383: AND org_id = p_org_id;
384:

Line 397: FROM cn_payment_worksheets

393: p_quota_id cn_payment_transactions.quota_id%TYPE
394: )
395: IS
396: SELECT *
397: FROM cn_payment_worksheets
398: WHERE payrun_id = p_payrun_id
399: AND salesrep_id = p_salesrep_id
400: AND quota_id = p_quota_id
401: AND EXISTS (

Line 415: FROM cn_payment_worksheets

411: p_quota_id cn_payment_transactions.quota_id%TYPE
412: )
413: IS
414: SELECT *
415: FROM cn_payment_worksheets
416: WHERE salesrep_id = p_salesrep_id
417: AND quota_id = p_quota_id
418: AND payrun_id = p_payrun_id;
419:

Line 716: FROM cn_payment_worksheets

712: THEN
713:
714: SELECT object_version_number
715: INTO l_wksht_ovn
716: FROM cn_payment_worksheets
717: WHERE payrun_id = p_payrun_id
718: AND salesrep_id = p_salesrep_id
719: AND quota_id IS NULL;
720:

Line 737: UPDATE cn_payment_worksheets

733: --l_waive_factor = 1 is for waive_flag changes from N to Y.
734: --l_waive_factor = -1 is for waive_flag changes from Y to N.
735: l_waive_amount := waive_per_quota.payment_amount * l_waive_factor;
736:
737: UPDATE cn_payment_worksheets
738: SET pmt_amount_adj = NVL (pmt_amount_adj, 0) + l_waive_amount,
739: object_version_number = object_version_number + 1,
740: last_update_date = SYSDATE,
741: last_updated_by = fnd_global.user_id,

Line 752: UPDATE cn_payment_worksheets

748: l_waive_amount_total := l_waive_amount_total + l_waive_amount;
749: END LOOP;
750:
751: --Update summary waive record.
752: UPDATE cn_payment_worksheets
753: SET pmt_amount_adj = NVL (pmt_amount_adj, 0) + l_waive_amount_total,
754: object_version_number = nvl(object_version_number,0) + 1,
755: last_update_date = SYSDATE,
756: last_updated_by = fnd_global.user_id,

Line 850: UPDATE cn_payment_worksheets

846: l_earn := earn.earn_amount;
847: END LOOP;
848:
849: -- 12/25/02 RC bug 2710066
850: UPDATE cn_payment_worksheets
851: SET pmt_amount_adj = l_wv + l_cp + l_mpa,
852: held_amount = l_ph,
853: pmt_amount_calc = l_earn,
854: object_version_number = object_version_number + 1,

Line 863: UPDATE cn_payment_worksheets

859: WHERE payment_worksheet_id = worksheet.payment_worksheet_id;
860: END LOOP;
861:
862: -- updating the summary record with totals
863: UPDATE cn_payment_worksheets
864: SET pmt_amount_adj =
865: (SELECT NVL (SUM (NVL (pmt_amount_adj, 0)), 0)
866: FROM cn_payment_worksheets
867: WHERE quota_id IS NOT NULL

Line 866: FROM cn_payment_worksheets

862: -- updating the summary record with totals
863: UPDATE cn_payment_worksheets
864: SET pmt_amount_adj =
865: (SELECT NVL (SUM (NVL (pmt_amount_adj, 0)), 0)
866: FROM cn_payment_worksheets
867: WHERE quota_id IS NOT NULL
868: AND salesrep_id = pmt_trans_rec.credited_salesrep_id
869: AND payrun_id = pmt_trans_rec.payrun_id
870: ),

Line 873: FROM cn_payment_worksheets

869: AND payrun_id = pmt_trans_rec.payrun_id
870: ),
871: held_amount =
872: (SELECT NVL (SUM (NVL (held_amount, 0)), 0)
873: FROM cn_payment_worksheets
874: WHERE quota_id IS NOT NULL
875: AND salesrep_id = pmt_trans_rec.credited_salesrep_id
876: AND payrun_id = pmt_trans_rec.payrun_id
877: ),

Line 880: FROM cn_payment_worksheets

876: AND payrun_id = pmt_trans_rec.payrun_id
877: ),
878: pmt_amount_calc =
879: (SELECT l_delta_earn + NVL (SUM (NVL (pmt_amount_calc, 0)), 0)
880: FROM cn_payment_worksheets
881: WHERE quota_id IS NOT NULL
882: AND salesrep_id = pmt_trans_rec.credited_salesrep_id
883: AND payrun_id = pmt_trans_rec.payrun_id
884: ),

Line 908: FROM cn_payment_worksheets

904: ELSIF p_payment_transaction_id IS NULL
905: THEN
906: SELECT object_version_number
907: INTO p_object_version_number
908: FROM cn_payment_worksheets
909: WHERE payrun_id = p_payrun_id
910: AND salesrep_id = p_salesrep_id
911: AND quota_id IS NULL;
912: END IF;

Line 1222: UPDATE cn_payment_worksheets

1218: l_rec_amount := NVL (p_payment_amount, 0);
1219: END IF;
1220:
1221: -- Update the Worksheet
1222: UPDATE cn_payment_worksheets
1223: SET pmt_amount_adj = NVL (pmt_amount_adj, 0) + NVL (l_rec_amount, 0) + NVL (l_nrec_amount, 0),
1224: last_updated_by = fnd_global.user_id,
1225: last_update_date = SYSDATE,
1226: last_update_login = fnd_global.login_id,

Line 1235: cn_payment_worksheets_pkg.INSERT_RECORD (x_payrun_id => p_payrun_id,

1231: ;
1232:
1233: IF SQL%NOTFOUND
1234: THEN
1235: cn_payment_worksheets_pkg.INSERT_RECORD (x_payrun_id => p_payrun_id,
1236: x_salesrep_id => p_salesrep_id,
1237: x_quota_id => p_quota_id,
1238: x_credit_type_id => g_credit_type_id,
1239: x_calc_pmt_amount => 0,

Line 1253: UPDATE cn_payment_worksheets

1249: );
1250: END IF;
1251:
1252: -- Update the Summary Record.
1253: UPDATE cn_payment_worksheets
1254: SET pmt_amount_adj = NVL (pmt_amount_adj, 0) + NVL (l_rec_amount, 0) + NVL (l_nrec_amount, 0),
1255: last_updated_by = fnd_global.user_id,
1256: last_update_date = SYSDATE,
1257: last_update_login = fnd_global.login_id,

Line 1466: UPDATE cn_payment_worksheets

1462: l_adj_rec := 0;
1463: END IF;
1464:
1465: -- Update the Payment Worksheets
1466: UPDATE cn_payment_worksheets
1467: SET pmt_amount_adj = NVL (pmt_amount_adj, 0) - NVL (l_adj_rec, 0) - NVL (l_adj_nrec, 0),
1468: object_version_number = object_version_number + 1,
1469: last_updated_by = fnd_global.user_id,
1470: last_update_date = SYSDATE,

Line 1536: p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE

1532: l_loading_status VARCHAR2 (100);
1533:
1534: -- cursor to get the hold payment transactions
1535: CURSOR get_hold_pmt_trans (
1536: p_payment_worksheet_id cn_payment_worksheets.payment_worksheet_id%TYPE
1537: )
1538: IS
1539: SELECT cpt.payment_transaction_id,
1540: cpt.hold_flag,

Line 1551: cn_payment_worksheets cpw,

1547: --R12
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

Line 1687: cn_payment_worksheets wk, cn_salesreps srp

1683: CURSOR get_paysheet_details IS
1684: SELECT
1685: payment_worksheet_id,object_version_number, name
1686: FROM
1687: cn_payment_worksheets wk, cn_salesreps srp
1688: WHERE
1689: quota_id is null
1690: AND wk.payrun_id = p_payrun_id
1691: AND wk.salesrep_id = p_salesrep_id

Line 1694: l_new_status cn_payment_worksheets.worksheet_status%type ;

1690: AND wk.payrun_id = p_payrun_id
1691: AND wk.salesrep_id = p_salesrep_id
1692: AND wk.salesrep_id = srp.salesrep_id ;
1693:
1694: l_new_status cn_payment_worksheets.worksheet_status%type ;
1695: l_srp_name cn_salesreps.name%type ;
1696:
1697: BEGIN
1698: SAVEPOINT hold_multiple_trans_conc;

Line 1803: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id,l_new_status) ;

1799: l_note_msg := fnd_message.get;
1800: l_new_status := 'FAILED' ;
1801: END ;
1802:
1803: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id,l_new_status) ;
1804:
1805: BEGIN
1806: jtf_notes_pub.create_note (
1807: p_api_version => 1.0,

Line 1812: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',

1808: x_return_status => l_return_status,
1809: x_msg_count => l_msg_count,
1810: x_msg_data => l_msg_data,
1811: p_source_object_id => l_worksheet_id,
1812: p_source_object_code => 'CN_PAYMENT_WORKSHEETS',
1813: p_notes => l_note_msg,
1814: p_notes_detail => l_note_msg,
1815: p_note_type => 'CN_SYSGEN', -- for system generated
1816: x_jtf_note_id => l_note_id -- returned

Line 1835: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id, 'FAILED') ;

1831: fnd_message.set_token('SRP_NAME', l_srp_name );
1832: fnd_message.set_token('MESSAGE_TEXT', l_errText);
1833: fnd_msg_pub.ADD;
1834:
1835: cn_payment_worksheets_pkg.update_status(p_salesrep_id,p_payrun_id, 'FAILED') ;
1836:
1837: retcode := 2;
1838: errbuf := fnd_msg_pub.get (p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
1839: COMMIT ;

Line 1959: UPDATE cn_payment_worksheets

1955: RAISE fnd_api.g_exc_error;
1956: END IF ;
1957: p_rec.request_id := l_request_id ;
1958:
1959: UPDATE cn_payment_worksheets
1960: SET request_id = p_rec.request_id,
1961: last_update_date = SYSDATE,
1962: last_updated_by = fnd_global.user_id,
1963: last_update_login = fnd_global.login_id