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 FND_GLOBAL

Line 678: last_updated_by = fnd_global.user_id,

674: payment_amount = p_payment_amount,
675: waive_flag = DECODE (p_incentive_type_code, 'PMTPLN_REC', p_waive_flag, 'N'),
676: -- bug 3080846
677: last_update_date = SYSDATE,
678: last_updated_by = fnd_global.user_id,
679: last_update_login = fnd_global.login_id,
680: object_version_number = nvl(object_version_number,1) + 1
681: WHERE payment_transaction_id = p_payment_transaction_id;
682:

Line 679: last_update_login = fnd_global.login_id,

675: waive_flag = DECODE (p_incentive_type_code, 'PMTPLN_REC', p_waive_flag, 'N'),
676: -- bug 3080846
677: last_update_date = SYSDATE,
678: last_updated_by = fnd_global.user_id,
679: last_update_login = fnd_global.login_id,
680: object_version_number = nvl(object_version_number,1) + 1
681: WHERE payment_transaction_id = p_payment_transaction_id;
682:
683: --This if statement is for waive recovery.

Line 741: last_updated_by = fnd_global.user_id,

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,
742: last_update_login = fnd_global.login_id
743: WHERE payrun_id = p_payrun_id
744: AND salesrep_id = p_salesrep_id
745: AND quota_id = waive_per_quota.quota_id

Line 742: last_update_login = fnd_global.login_id

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,
742: last_update_login = fnd_global.login_id
743: WHERE payrun_id = p_payrun_id
744: AND salesrep_id = p_salesrep_id
745: AND quota_id = waive_per_quota.quota_id
746: ;

Line 756: last_updated_by = fnd_global.user_id,

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,
757: last_update_login = fnd_global.login_id
758: WHERE payrun_id = p_payrun_id
759: AND salesrep_id = p_salesrep_id
760: AND quota_id IS NULL

Line 757: last_update_login = fnd_global.login_id

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,
757: last_update_login = fnd_global.login_id
758: WHERE payrun_id = p_payrun_id
759: AND salesrep_id = p_salesrep_id
760: AND quota_id IS NULL
761: ;

Line 769: last_updated_by = fnd_global.user_id,

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,
769: last_updated_by = fnd_global.user_id,
770: last_update_login = fnd_global.login_id
771: WHERE incentive_type_code = 'PMTPLN_REC'
772: AND credited_salesrep_id = p_salesrep_id
773: AND payrun_id = p_payrun_id

Line 770: last_update_login = fnd_global.login_id

766: object_version_number = nvl(object_version_number,0) + 1,
767: -- bug 3080846
768: last_update_date = SYSDATE,
769: last_updated_by = fnd_global.user_id,
770: last_update_login = fnd_global.login_id
771: WHERE incentive_type_code = 'PMTPLN_REC'
772: AND credited_salesrep_id = p_salesrep_id
773: AND payrun_id = p_payrun_id
774: ;

Line 806: last_updated_by = fnd_global.user_id,

802: payment_amount = pmt_trans_rec_amount.payment_amount,
803: object_version_number = object_version_number + 1,
804: -- bug 3080846
805: last_update_date = SYSDATE,
806: last_updated_by = fnd_global.user_id,
807: last_update_login = fnd_global.login_id
808: WHERE payment_transaction_id = p_payment_transaction_id
809: AND payrun_id = p_payrun_id
810: AND credited_salesrep_id = p_salesrep_id

Line 807: last_update_login = fnd_global.login_id

803: object_version_number = object_version_number + 1,
804: -- bug 3080846
805: last_update_date = SYSDATE,
806: last_updated_by = fnd_global.user_id,
807: last_update_login = fnd_global.login_id
808: WHERE payment_transaction_id = p_payment_transaction_id
809: AND payrun_id = p_payrun_id
810: AND credited_salesrep_id = p_salesrep_id
811: AND (hold_flag = 'N' OR hold_flag IS NULL) ;

Line 857: last_updated_by = fnd_global.user_id,

853: pmt_amount_calc = l_earn,
854: object_version_number = object_version_number + 1,
855: -- bug 3080846
856: last_update_date = SYSDATE,
857: last_updated_by = fnd_global.user_id,
858: last_update_login = fnd_global.login_id
859: WHERE payment_worksheet_id = worksheet.payment_worksheet_id;
860: END LOOP;
861:

Line 858: last_update_login = fnd_global.login_id

854: object_version_number = object_version_number + 1,
855: -- bug 3080846
856: last_update_date = SYSDATE,
857: last_updated_by = fnd_global.user_id,
858: last_update_login = fnd_global.login_id
859: WHERE payment_worksheet_id = worksheet.payment_worksheet_id;
860: END LOOP;
861:
862: -- updating the summary record with totals

Line 888: last_updated_by = fnd_global.user_id,

884: ),
885: object_version_number = object_version_number + 1,
886: -- bug 3080846
887: last_update_date = SYSDATE,
888: last_updated_by = fnd_global.user_id,
889: last_update_login = fnd_global.login_id
890: WHERE quota_id IS NULL
891: AND salesrep_id = pmt_trans_rec.credited_salesrep_id
892: AND payrun_id = pmt_trans_rec.payrun_id

Line 889: last_update_login = fnd_global.login_id

885: object_version_number = object_version_number + 1,
886: -- bug 3080846
887: last_update_date = SYSDATE,
888: last_updated_by = fnd_global.user_id,
889: last_update_login = fnd_global.login_id
890: WHERE quota_id IS NULL
891: AND salesrep_id = pmt_trans_rec.credited_salesrep_id
892: AND payrun_id = pmt_trans_rec.payrun_id
893: AND org_id = p_org_id;

Line 1177: l_batch_rec.created_by := fnd_global.user_id;

1173: -- Create the Record in cn_posting_batches
1174: cn_prepostbatches.get_uid (l_posting_batch_id);
1175: l_batch_rec.posting_batch_id := l_posting_batch_id;
1176: l_batch_rec.NAME := 'MANUAL_PAY_ADJ batch number:' || p_payrun_id || ':' || p_salesrep_id || ':' || l_posting_batch_id;
1177: l_batch_rec.created_by := fnd_global.user_id;
1178: l_batch_rec.creation_date := SYSDATE;
1179: l_batch_rec.last_updated_by := fnd_global.user_id;
1180: l_batch_rec.last_update_date := SYSDATE;
1181: l_batch_rec.last_update_login := fnd_global.login_id;

Line 1179: l_batch_rec.last_updated_by := fnd_global.user_id;

1175: l_batch_rec.posting_batch_id := l_posting_batch_id;
1176: l_batch_rec.NAME := 'MANUAL_PAY_ADJ batch number:' || p_payrun_id || ':' || p_salesrep_id || ':' || l_posting_batch_id;
1177: l_batch_rec.created_by := fnd_global.user_id;
1178: l_batch_rec.creation_date := SYSDATE;
1179: l_batch_rec.last_updated_by := fnd_global.user_id;
1180: l_batch_rec.last_update_date := SYSDATE;
1181: l_batch_rec.last_update_login := fnd_global.login_id;
1182: -- call table handler
1183: cn_prepostbatches.begin_record (x_operation => 'INSERT',

Line 1181: l_batch_rec.last_update_login := fnd_global.login_id;

1177: l_batch_rec.created_by := fnd_global.user_id;
1178: l_batch_rec.creation_date := SYSDATE;
1179: l_batch_rec.last_updated_by := fnd_global.user_id;
1180: l_batch_rec.last_update_date := SYSDATE;
1181: l_batch_rec.last_update_login := fnd_global.login_id;
1182: -- call table handler
1183: cn_prepostbatches.begin_record (x_operation => 'INSERT',
1184: x_rowid => l_rowid,
1185: x_posting_batch_rec => l_batch_rec,

Line 1224: last_updated_by = fnd_global.user_id,

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,
1227: object_version_number = NVL(object_version_number+1,1)
1228: WHERE salesrep_id = p_salesrep_id

Line 1226: last_update_login = fnd_global.login_id,

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,
1227: object_version_number = NVL(object_version_number+1,1)
1228: WHERE salesrep_id = p_salesrep_id
1229: AND payrun_id = p_payrun_id
1230: AND quota_id = p_quota_id

Line 1245: x_created_by => fnd_global.user_id,

1241: x_adj_pmt_amount_nrec => 0,
1242: x_adj_pmt_amount => l_rec_amount + l_nrec_amount,
1243: x_pmt_amount_recovery => 0,
1244: x_worksheet_status => 'UNPAID',
1245: x_created_by => fnd_global.user_id,
1246: x_creation_date => SYSDATE,
1247: p_org_id => p_org_id,
1248: p_object_version_number => 1
1249: );

Line 1255: last_updated_by = fnd_global.user_id,

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,
1258: object_version_number = NVL(object_version_number+1,1)
1259: WHERE salesrep_id = p_salesrep_id

Line 1257: last_update_login = fnd_global.login_id,

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,
1258: object_version_number = NVL(object_version_number+1,1)
1259: WHERE salesrep_id = p_salesrep_id
1260: AND payrun_id = p_payrun_id
1261: AND quota_id IS NULL

Line 1469: last_updated_by = fnd_global.user_id,

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,
1471: -- bug 3080846
1472: last_update_login = fnd_global.login_id
1473: WHERE salesrep_id = trans_rec.credited_salesrep_id

Line 1472: last_update_login = fnd_global.login_id

1468: object_version_number = object_version_number + 1,
1469: last_updated_by = fnd_global.user_id,
1470: last_update_date = SYSDATE,
1471: -- bug 3080846
1472: last_update_login = fnd_global.login_id
1473: WHERE salesrep_id = trans_rec.credited_salesrep_id
1474: AND payrun_id = trans_rec.payrun_id
1475: AND (quota_id = trans_rec.quota_id OR quota_id IS NULL)
1476: ;

Line 1962: last_updated_by = fnd_global.user_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
1964: WHERE payrun_id = p_rec.payrun_id
1965: AND salesrep_id = p_rec.salesrep_id
1966: AND quota_id IS NULL ;

Line 1963: last_update_login = fnd_global.login_id

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
1964: WHERE payrun_id = p_rec.payrun_id
1965: AND salesrep_id = p_rec.salesrep_id
1966: AND quota_id IS NULL ;
1967: