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.

[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on FND_GLOBAL

Line 6: -- g_last_updated_by NUMBER := fnd_global.user_id;

2: -- $Header: cnvwkshb.pls 120.30 2009/02/09 12:05:58 rajukum ship $
3: g_api_version CONSTANT NUMBER := 1.0;
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_Payment_Worksheet_PVT';
5: --G_last_update_date DATE := sysdate;
6: -- g_last_updated_by NUMBER := fnd_global.user_id;
7: --G_creation_date DATE := sysdate;
8: --g_created_by NUMBER := fnd_global.user_id;
9: --g_last_update_login NUMBER := fnd_global.login_id;
10: g_credit_type_id CONSTANT NUMBER := -1000;

Line 8: --g_created_by NUMBER := fnd_global.user_id;

4: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_Payment_Worksheet_PVT';
5: --G_last_update_date DATE := sysdate;
6: -- g_last_updated_by NUMBER := fnd_global.user_id;
7: --G_creation_date DATE := sysdate;
8: --g_created_by NUMBER := fnd_global.user_id;
9: --g_last_update_login NUMBER := fnd_global.login_id;
10: g_credit_type_id CONSTANT NUMBER := -1000;
11:
12:

Line 9: --g_last_update_login NUMBER := fnd_global.login_id;

5: --G_last_update_date DATE := sysdate;
6: -- g_last_updated_by NUMBER := fnd_global.user_id;
7: --G_creation_date DATE := sysdate;
8: --g_created_by NUMBER := fnd_global.user_id;
9: --g_last_update_login NUMBER := fnd_global.login_id;
10: g_credit_type_id CONSTANT NUMBER := -1000;
11:
12:
13: PROCEDURE update_ptd_details (

Line 246: last_updated_by = fnd_global.user_id,

242: THEN
243: UPDATE cn_payment_transactions ptrx
244: SET payrun_id = NULL,
245: last_update_date = SYSDATE,
246: last_updated_by = fnd_global.user_id,
247: last_update_login = fnd_global.login_id
248: WHERE ptrx.payrun_id = p_payrun_id
249: AND ptrx.credited_salesrep_id = p_salesrep_id
250: AND ptrx.incentive_type_code IN ('PMTPLN_REC', 'COMMISSION', 'BONUS')

Line 247: last_update_login = fnd_global.login_id

243: UPDATE cn_payment_transactions ptrx
244: SET payrun_id = NULL,
245: last_update_date = SYSDATE,
246: last_updated_by = fnd_global.user_id,
247: last_update_login = fnd_global.login_id
248: WHERE ptrx.payrun_id = p_payrun_id
249: AND ptrx.credited_salesrep_id = p_salesrep_id
250: AND ptrx.incentive_type_code IN ('PMTPLN_REC', 'COMMISSION', 'BONUS')
251: AND EXISTS (SELECT 1

Line 259: last_updated_by = fnd_global.user_id,

255: ELSE
256: UPDATE cn_payment_transactions ptrx
257: SET payrun_id = NULL,
258: last_update_date = SYSDATE,
259: last_updated_by = fnd_global.user_id,
260: last_update_login = fnd_global.login_id
261: WHERE ptrx.payrun_id = p_payrun_id
262: AND ptrx.credited_salesrep_id = p_salesrep_id
263: AND ptrx.incentive_type_code IN ('PMTPLN_REC', decode(p_incentive_type, 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS'))

Line 260: last_update_login = fnd_global.login_id

256: UPDATE cn_payment_transactions ptrx
257: SET payrun_id = NULL,
258: last_update_date = SYSDATE,
259: last_updated_by = fnd_global.user_id,
260: last_update_login = fnd_global.login_id
261: WHERE ptrx.payrun_id = p_payrun_id
262: AND ptrx.credited_salesrep_id = p_salesrep_id
263: AND ptrx.incentive_type_code IN ('PMTPLN_REC', decode(p_incentive_type, 'COMMISSION', 'COMMISSION', 'BONUS', 'BONUS'))
264: AND EXISTS (SELECT 1

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

1784:
1785: l_batch_rec.posting_batch_id := recv_posting_batch_id;
1786: l_batch_rec.NAME := 'PMTPLN batch number:' || l_get_payrun_rec.payrun_id || ':' || p_worksheet_rec.salesrep_id || ':' ||
1787: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;
1788: l_batch_rec.created_by := fnd_global.user_id;
1789: l_batch_rec.creation_date := SYSDATE;
1790: l_batch_rec.last_updated_by := fnd_global.user_id;
1791: l_batch_rec.last_update_date := SYSDATE;
1792: l_batch_rec.last_update_login := fnd_global.login_id;

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

1786: l_batch_rec.NAME := 'PMTPLN batch number:' || l_get_payrun_rec.payrun_id || ':' || p_worksheet_rec.salesrep_id || ':' ||
1787: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;
1788: l_batch_rec.created_by := fnd_global.user_id;
1789: l_batch_rec.creation_date := SYSDATE;
1790: l_batch_rec.last_updated_by := fnd_global.user_id;
1791: l_batch_rec.last_update_date := SYSDATE;
1792: l_batch_rec.last_update_login := fnd_global.login_id;
1793: -- Create the Posting Batches
1794: cn_prepostbatches.begin_record(x_operation => 'INSERT',

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

1788: l_batch_rec.created_by := fnd_global.user_id;
1789: l_batch_rec.creation_date := SYSDATE;
1790: l_batch_rec.last_updated_by := fnd_global.user_id;
1791: l_batch_rec.last_update_date := SYSDATE;
1792: l_batch_rec.last_update_login := fnd_global.login_id;
1793: -- Create the Posting Batches
1794: cn_prepostbatches.begin_record(x_operation => 'INSERT',
1795: x_rowid => l_rowid,
1796: x_posting_batch_rec => l_batch_rec,

Line 1838: x_created_by => fnd_global.user_id,

1834: x_adj_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0),
1835: x_held_amount => nvl(l_calc_rec_tbl(i).held_amount, 0),
1836: x_pmt_amount_recovery => nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0),
1837: x_worksheet_status => 'UNPAID',
1838: x_created_by => fnd_global.user_id,
1839: x_creation_date => SYSDATE,
1840: p_org_id => p_worksheet_rec.org_id,
1841: p_object_version_number => 1);
1842: x_loading_status := 'CN_INSERTED';

Line 1897: x_created_by => fnd_global.user_id,

1893: x_adj_pmt_amount => nvl(l_pmt_amount_ctr, 0),
1894: x_held_amount => nvl(l_held_amount, 0),
1895: x_pmt_amount_recovery => nvl(l_pmt_amount_rec, 0),
1896: x_worksheet_status => 'UNPAID',
1897: x_created_by => fnd_global.user_id,
1898: x_creation_date => SYSDATE,
1899: p_org_id => p_worksheet_rec.org_id,
1900: p_object_version_number => 1);
1901:

Line 1933: last_updated_by = fnd_global.user_id,

1929: THEN
1930: UPDATE cn_commission_lines cls
1931: SET posting_status = 'POSTED',
1932: last_update_date = SYSDATE,
1933: last_updated_by = fnd_global.user_id,
1934: last_update_login = fnd_global.login_id
1935: WHERE posting_status <> 'POSTED'
1936: AND status = 'CALC'
1937: AND srp_payee_assign_id IS NULL

Line 1934: last_update_login = fnd_global.login_id

1930: UPDATE cn_commission_lines cls
1931: SET posting_status = 'POSTED',
1932: last_update_date = SYSDATE,
1933: last_updated_by = fnd_global.user_id,
1934: last_update_login = fnd_global.login_id
1935: WHERE posting_status <> 'POSTED'
1936: AND status = 'CALC'
1937: AND srp_payee_assign_id IS NULL
1938: AND commission_line_id IN (SELECT commission_line_id

Line 1947: last_updated_by = fnd_global.user_id,

1943: --payee
1944: UPDATE cn_commission_lines cls
1945: SET posting_status = 'POSTED',
1946: last_update_date = SYSDATE,
1947: last_updated_by = fnd_global.user_id,
1948: last_update_login = fnd_global.login_id
1949: WHERE posting_status <> 'POSTED'
1950: AND status = 'CALC'
1951: AND srp_payee_assign_id IS NOT NULL

Line 1948: last_update_login = fnd_global.login_id

1944: UPDATE cn_commission_lines cls
1945: SET posting_status = 'POSTED',
1946: last_update_date = SYSDATE,
1947: last_updated_by = fnd_global.user_id,
1948: last_update_login = fnd_global.login_id
1949: WHERE posting_status <> 'POSTED'
1950: AND status = 'CALC'
1951: AND srp_payee_assign_id IS NOT NULL
1952: AND commission_line_id IN (SELECT commission_line_id

Line 1975: last_updated_by = fnd_global.user_id,

1971: FORALL m IN 1..l_wk_plan_elements.COUNT
1972: UPDATE cn_commission_lines cls
1973: SET posting_status = 'POSTED',
1974: last_update_date = SYSDATE,
1975: last_updated_by = fnd_global.user_id,
1976: last_update_login = fnd_global.login_id
1977: WHERE posting_status <> 'POSTED'
1978: AND credit_type_id = g_credit_type_id
1979: AND processed_period_id <= l_get_payrun_rec.pay_period_id

Line 1976: last_update_login = fnd_global.login_id

1972: UPDATE cn_commission_lines cls
1973: SET posting_status = 'POSTED',
1974: last_update_date = SYSDATE,
1975: last_updated_by = fnd_global.user_id,
1976: last_update_login = fnd_global.login_id
1977: WHERE posting_status <> 'POSTED'
1978: AND credit_type_id = g_credit_type_id
1979: AND processed_period_id <= l_get_payrun_rec.pay_period_id
1980: AND status = 'CALC'

Line 1990: last_updated_by = fnd_global.user_id,

1986:
1987: UPDATE cn_commission_lines clk
1988: SET posting_status = 'POSTED',
1989: last_update_date = SYSDATE,
1990: last_updated_by = fnd_global.user_id,
1991: last_update_login = fnd_global.login_id
1992: WHERE processed_period_id <= l_get_payrun_rec.pay_period_id
1993: AND status = 'CALC'
1994: AND credit_type_id = g_credit_type_id

Line 1991: last_update_login = fnd_global.login_id

1987: UPDATE cn_commission_lines clk
1988: SET posting_status = 'POSTED',
1989: last_update_date = SYSDATE,
1990: last_updated_by = fnd_global.user_id,
1991: last_update_login = fnd_global.login_id
1992: WHERE processed_period_id <= l_get_payrun_rec.pay_period_id
1993: AND status = 'CALC'
1994: AND credit_type_id = g_credit_type_id
1995: AND posting_status <> 'POSTED'

Line 2562: last_updated_by = fnd_global.user_id,

2558: AND p.org_id = wksht_rec.org_id
2559: AND s.org_id = wksht_rec.org_id
2560: AND r.org_id = wksht_rec.org_id),
2561: last_update_date = SYSDATE,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: object_version_number = nvl(object_version_number, 0) + 1
2565: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2566: AND cnpt.amount = cnpt.payment_amount

Line 2563: last_update_login = fnd_global.login_id,

2559: AND s.org_id = wksht_rec.org_id
2560: AND r.org_id = wksht_rec.org_id),
2561: last_update_date = SYSDATE,
2562: last_updated_by = fnd_global.user_id,
2563: last_update_login = fnd_global.login_id,
2564: object_version_number = nvl(object_version_number, 0) + 1
2565: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2566: AND cnpt.amount = cnpt.payment_amount
2567: AND incentive_type_code IN ('COMMISSION', 'BONUS')

Line 2597: last_updated_by = fnd_global.user_id,

2593: AND p.org_id = wksht_rec.org_id
2594: AND s.org_id = wksht_rec.org_id
2595: AND r.org_id = wksht_rec.org_id),
2596: last_update_date = SYSDATE,
2597: last_updated_by = fnd_global.user_id,
2598: last_update_login = fnd_global.login_id
2599: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2600: AND cnpt.amount <> cnpt.payment_amount
2601: AND incentive_type_code IN ('COMMISSION', 'BONUS')

Line 2598: last_update_login = fnd_global.login_id

2594: AND s.org_id = wksht_rec.org_id
2595: AND r.org_id = wksht_rec.org_id),
2596: last_update_date = SYSDATE,
2597: last_updated_by = fnd_global.user_id,
2598: last_update_login = fnd_global.login_id
2599: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2600: AND cnpt.amount <> cnpt.payment_amount
2601: AND incentive_type_code IN ('COMMISSION', 'BONUS')
2602: -- 01/03/03 gasriniv added hold flag check for bug 2710066

Line 2646: fnd_global.user_id,

2642: 'N',
2643: wksht_rec.payrun_id,
2644: v1.quota_id,
2645: v1.pay_element_type_id,
2646: fnd_global.user_id,
2647: SYSDATE,
2648: --R12
2649: wksht_rec.org_id
2650: FROM (SELECT q.incentive_type_code,

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

2703: THEN
2704: l_batch_rec.posting_batch_id := l_posting_batch_id;
2705: l_batch_rec.NAME := 'Refresh batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
2706: l_posting_batch_id;
2707: l_batch_rec.created_by := fnd_global.user_id;
2708: l_batch_rec.creation_date := SYSDATE;
2709: l_batch_rec.last_updated_by := fnd_global.user_id;
2710: l_batch_rec.last_update_date := SYSDATE;
2711: l_batch_rec.last_update_login := fnd_global.login_id;

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

2705: l_batch_rec.NAME := 'Refresh batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
2706: l_posting_batch_id;
2707: l_batch_rec.created_by := fnd_global.user_id;
2708: l_batch_rec.creation_date := SYSDATE;
2709: l_batch_rec.last_updated_by := fnd_global.user_id;
2710: l_batch_rec.last_update_date := SYSDATE;
2711: l_batch_rec.last_update_login := fnd_global.login_id;
2712: -- Create the Posting Batches
2713: cn_prepostbatches.begin_record(x_operation => 'INSERT',

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

2707: l_batch_rec.created_by := fnd_global.user_id;
2708: l_batch_rec.creation_date := SYSDATE;
2709: l_batch_rec.last_updated_by := fnd_global.user_id;
2710: l_batch_rec.last_update_date := SYSDATE;
2711: l_batch_rec.last_update_login := fnd_global.login_id;
2712: -- Create the Posting Batches
2713: cn_prepostbatches.begin_record(x_operation => 'INSERT',
2714: x_rowid => l_rowid,
2715: x_posting_batch_rec => l_batch_rec,

Line 2762: fnd_global.user_id,

2758: 'N',
2759: wksht_rec.payrun_id,
2760: -1000,
2761: decode(r.payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
2762: fnd_global.user_id,
2763: SYSDATE,
2764: --R12
2765: wksht_rec.org_id
2766: FROM cn_srp_periods srp,

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

2793: THEN
2794: l_batch_rec.posting_batch_id := carryover_posting_batch_id;
2795: l_batch_rec.NAME := 'Refresh batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
2796: carryover_posting_batch_id;
2797: l_batch_rec.created_by := fnd_global.user_id;
2798: l_batch_rec.creation_date := SYSDATE;
2799: l_batch_rec.last_updated_by := fnd_global.user_id;
2800: l_batch_rec.last_update_date := SYSDATE;
2801: l_batch_rec.last_update_login := fnd_global.login_id;

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

2795: l_batch_rec.NAME := 'Refresh batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
2796: carryover_posting_batch_id;
2797: l_batch_rec.created_by := fnd_global.user_id;
2798: l_batch_rec.creation_date := SYSDATE;
2799: l_batch_rec.last_updated_by := fnd_global.user_id;
2800: l_batch_rec.last_update_date := SYSDATE;
2801: l_batch_rec.last_update_login := fnd_global.login_id;
2802: -- Create the Posting Batches
2803: cn_prepostbatches.begin_record(x_operation => 'INSERT',

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

2797: l_batch_rec.created_by := fnd_global.user_id;
2798: l_batch_rec.creation_date := SYSDATE;
2799: l_batch_rec.last_updated_by := fnd_global.user_id;
2800: l_batch_rec.last_update_date := SYSDATE;
2801: l_batch_rec.last_update_login := fnd_global.login_id;
2802: -- Create the Posting Batches
2803: cn_prepostbatches.begin_record(x_operation => 'INSERT',
2804: x_rowid => l_rowid,
2805: x_posting_batch_rec => l_batch_rec,

Line 2823: last_updated_by = fnd_global.user_id,

2819: AND cnptheld.paid_flag = 'N'
2820: --R12
2821: AND cnptheld.org_id = wksht_rec.org_id),
2822: last_update_date = SYSDATE,
2823: last_updated_by = fnd_global.user_id,
2824: last_update_login = fnd_global.login_id
2825: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2826: AND cnpt.credited_salesrep_id = wksht_rec.salesrep_id
2827: AND cnpt.hold_flag = 'N'

Line 2824: last_update_login = fnd_global.login_id

2820: --R12
2821: AND cnptheld.org_id = wksht_rec.org_id),
2822: last_update_date = SYSDATE,
2823: last_updated_by = fnd_global.user_id,
2824: last_update_login = fnd_global.login_id
2825: WHERE cnpt.payrun_id = wksht_rec.payrun_id
2826: AND cnpt.credited_salesrep_id = wksht_rec.salesrep_id
2827: AND cnpt.hold_flag = 'N'
2828: AND cnpt.paid_flag = 'N'

Line 2918: fnd_global.user_id,

2914: nvl(cl.commission_amount, 0),
2915: -- Bug 2875120 : remove cn_api function call in sql statement
2916: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
2917: SYSDATE,
2918: fnd_global.user_id,
2919: --R12
2920: wksht_rec.org_id,
2921: 1,
2922: cl.processed_date

Line 3017: fnd_global.user_id,

3013: nvl(cl.commission_amount, 0),
3014: -- Bug 2875120 : remove cn_api function call in sql statement
3015: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
3016: SYSDATE,
3017: fnd_global.user_id,
3018: --R12
3019: wksht_rec.org_id,
3020: 1,
3021: cl.processed_date

Line 3060: last_updated_by = fnd_global.user_id,

3056: WHERE p.quota_id = cnpt.quota_id
3057: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3058: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))),
3059: last_update_date = SYSDATE,
3060: last_updated_by = fnd_global.user_id,
3061: last_update_login = fnd_global.login_id,
3062: object_version_number = nvl(object_version_number, 0) + 1
3063: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3064: AND pay_period_id <= wksht_rec.pay_period_id

Line 3061: last_update_login = fnd_global.login_id,

3057: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3058: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))),
3059: last_update_date = SYSDATE,
3060: last_updated_by = fnd_global.user_id,
3061: last_update_login = fnd_global.login_id,
3062: object_version_number = nvl(object_version_number, 0) + 1
3063: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3064: AND pay_period_id <= wksht_rec.pay_period_id
3065: AND incentive_type_code =

Line 3080: last_updated_by = fnd_global.user_id,

3076: AND wksht_rec.pay_date BETWEEN p.start_date AND p.end_date
3077: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))
3078: AND p.org_id = wksht_rec.org_id),
3079: last_update_date = SYSDATE,
3080: last_updated_by = fnd_global.user_id,
3081: last_update_login = fnd_global.login_id,
3082: object_version_number = nvl(object_version_number, 0) + 1
3083: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3084: AND payrun_id = wksht_rec.payrun_id;

Line 3081: last_update_login = fnd_global.login_id,

3077: AND nvl(l_srp_status, 'A') = nvl(p.status, nvl(l_srp_status, 'A'))
3078: AND p.org_id = wksht_rec.org_id),
3079: last_update_date = SYSDATE,
3080: last_updated_by = fnd_global.user_id,
3081: last_update_login = fnd_global.login_id,
3082: object_version_number = nvl(object_version_number, 0) + 1
3083: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3084: AND payrun_id = wksht_rec.payrun_id;
3085: END IF;

Line 3123: last_updated_by = fnd_global.user_id,

3119: AND p.org_id = wksht_rec.org_id
3120: AND s.org_id = wksht_rec.org_id
3121: AND r.org_id = wksht_rec.org_id),
3122: last_update_date = SYSDATE,
3123: last_updated_by = fnd_global.user_id,
3124: last_update_login = fnd_global.login_id,
3125: object_version_number = nvl(object_version_number, 0) + 1
3126: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3127: AND payrun_id = wksht_rec.payrun_id

Line 3124: last_update_login = fnd_global.login_id,

3120: AND s.org_id = wksht_rec.org_id
3121: AND r.org_id = wksht_rec.org_id),
3122: last_update_date = SYSDATE,
3123: last_updated_by = fnd_global.user_id,
3124: last_update_login = fnd_global.login_id,
3125: object_version_number = nvl(object_version_number, 0) + 1
3126: WHERE credited_salesrep_id = wksht_rec.salesrep_id
3127: AND payrun_id = wksht_rec.payrun_id
3128: AND incentive_type_code = 'PMTPLN'

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

3139:
3140: l_batch_rec.posting_batch_id := recv_posting_batch_id;
3141: l_batch_rec.NAME := 'PMTPLN batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
3142: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;
3143: l_batch_rec.created_by := fnd_global.user_id;
3144: l_batch_rec.creation_date := SYSDATE;
3145: l_batch_rec.last_updated_by := fnd_global.user_id;
3146: l_batch_rec.last_update_date := SYSDATE;
3147: l_batch_rec.last_update_login := fnd_global.login_id;

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

3141: l_batch_rec.NAME := 'PMTPLN batch number:' || wksht_rec.payrun_id || ':' || wksht_rec.salesrep_id || ':' ||
3142: l_calc_rec_tbl(i).quota_id || ':' || recv_posting_batch_id;
3143: l_batch_rec.created_by := fnd_global.user_id;
3144: l_batch_rec.creation_date := SYSDATE;
3145: l_batch_rec.last_updated_by := fnd_global.user_id;
3146: l_batch_rec.last_update_date := SYSDATE;
3147: l_batch_rec.last_update_login := fnd_global.login_id;
3148: -- Create the Posting Batches
3149: cn_prepostbatches.begin_record(x_operation => 'INSERT',

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

3143: l_batch_rec.created_by := fnd_global.user_id;
3144: l_batch_rec.creation_date := SYSDATE;
3145: l_batch_rec.last_updated_by := fnd_global.user_id;
3146: l_batch_rec.last_update_date := SYSDATE;
3147: l_batch_rec.last_update_login := fnd_global.login_id;
3148: -- Create the Posting Batches
3149: cn_prepostbatches.begin_record(x_operation => 'INSERT',
3150: x_rowid => l_rowid,
3151: x_posting_batch_rec => l_batch_rec,

Line 3197: last_updated_by = fnd_global.user_id,

3193: AND p.org_id = wksht_rec.org_id
3194: AND s.org_id = wksht_rec.org_id
3195: AND r.org_id = wksht_rec.org_id),
3196: last_update_date = SYSDATE,
3197: last_updated_by = fnd_global.user_id,
3198: last_update_login = fnd_global.login_id,
3199: object_version_number = nvl(object_version_number, 0) + 1
3200: WHERE incentive_type_code = 'PMTPLN'
3201: AND payrun_id = wksht_rec.payrun_id

Line 3198: last_update_login = fnd_global.login_id,

3194: AND s.org_id = wksht_rec.org_id
3195: AND r.org_id = wksht_rec.org_id),
3196: last_update_date = SYSDATE,
3197: last_updated_by = fnd_global.user_id,
3198: last_update_login = fnd_global.login_id,
3199: object_version_number = nvl(object_version_number, 0) + 1
3200: WHERE incentive_type_code = 'PMTPLN'
3201: AND payrun_id = wksht_rec.payrun_id
3202: AND credited_salesrep_id = wksht_rec.salesrep_id

Line 3216: last_updated_by = fnd_global.user_id,

3212: pmt_amount_adj_nrec = nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0),
3213: pmt_amount_adj = nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0),
3214: pmt_amount_recovery = nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0),
3215: last_update_date = SYSDATE,
3216: last_updated_by = fnd_global.user_id,
3217: last_update_login = fnd_global.login_id,
3218: object_version_number = nvl(object_version_number, 0) + 1
3219: WHERE payrun_id = wksht_rec.payrun_id
3220: AND salesrep_id = wksht_rec.salesrep_id

Line 3217: last_update_login = fnd_global.login_id,

3213: pmt_amount_adj = nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0),
3214: pmt_amount_recovery = nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0),
3215: last_update_date = SYSDATE,
3216: last_updated_by = fnd_global.user_id,
3217: last_update_login = fnd_global.login_id,
3218: object_version_number = nvl(object_version_number, 0) + 1
3219: WHERE payrun_id = wksht_rec.payrun_id
3220: AND salesrep_id = wksht_rec.salesrep_id
3221: AND quota_id = l_calc_rec_tbl(i).quota_id;

Line 3240: x_created_by => fnd_global.user_id,

3236: x_adj_pmt_amount_nrec => nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0),
3237: x_adj_pmt_amount => nvl(l_calc_rec_tbl(i).pmt_amount_ctr, 0),
3238: x_pmt_amount_recovery => nvl(l_calc_rec_tbl(i).pmt_amount_rec, 0),
3239: x_worksheet_status => 'UNPAID',
3240: x_created_by => fnd_global.user_id,
3241: x_creation_date => SYSDATE,
3242: p_org_id => wksht_rec.org_id,
3243: p_object_version_number => 1);
3244: END IF;

Line 3264: last_updated_by = fnd_global.user_id,

3260: pmt_amount_adj_nrec = l_adj_pmt_amount_nrec,
3261: pmt_amount_adj = l_pmt_amount_ctr,
3262: pmt_amount_recovery = l_pmt_amount_rec,
3263: last_update_date = SYSDATE,
3264: last_updated_by = fnd_global.user_id,
3265: last_update_login = fnd_global.login_id,
3266: object_version_number = nvl(object_version_number, 0) + 1
3267: WHERE payrun_id = wksht_rec.payrun_id
3268: AND salesrep_id = wksht_rec.salesrep_id

Line 3265: last_update_login = fnd_global.login_id,

3261: pmt_amount_adj = l_pmt_amount_ctr,
3262: pmt_amount_recovery = l_pmt_amount_rec,
3263: last_update_date = SYSDATE,
3264: last_updated_by = fnd_global.user_id,
3265: last_update_login = fnd_global.login_id,
3266: object_version_number = nvl(object_version_number, 0) + 1
3267: WHERE payrun_id = wksht_rec.payrun_id
3268: AND salesrep_id = wksht_rec.salesrep_id
3269: AND quota_id IS NULL;

Line 3285: last_updated_by = fnd_global.user_id,

3281: THEN
3282: UPDATE cn_commission_lines cls
3283: SET posting_status = 'POSTED',
3284: last_update_date = SYSDATE,
3285: last_updated_by = fnd_global.user_id,
3286: last_update_login = fnd_global.login_id
3287: WHERE posting_status <> 'POSTED'
3288: AND status = 'CALC'
3289: AND srp_payee_assign_id IS NULL

Line 3286: last_update_login = fnd_global.login_id

3282: UPDATE cn_commission_lines cls
3283: SET posting_status = 'POSTED',
3284: last_update_date = SYSDATE,
3285: last_updated_by = fnd_global.user_id,
3286: last_update_login = fnd_global.login_id
3287: WHERE posting_status <> 'POSTED'
3288: AND status = 'CALC'
3289: AND srp_payee_assign_id IS NULL
3290: AND commission_line_id IN (SELECT commission_line_id

Line 3299: last_updated_by = fnd_global.user_id,

3295: -- payee
3296: UPDATE cn_commission_lines cls
3297: SET posting_status = 'POSTED',
3298: last_update_date = SYSDATE,
3299: last_updated_by = fnd_global.user_id,
3300: last_update_login = fnd_global.login_id
3301: WHERE posting_status <> 'POSTED'
3302: AND status = 'CALC'
3303: AND srp_payee_assign_id IS NOT NULL

Line 3300: last_update_login = fnd_global.login_id

3296: UPDATE cn_commission_lines cls
3297: SET posting_status = 'POSTED',
3298: last_update_date = SYSDATE,
3299: last_updated_by = fnd_global.user_id,
3300: last_update_login = fnd_global.login_id
3301: WHERE posting_status <> 'POSTED'
3302: AND status = 'CALC'
3303: AND srp_payee_assign_id IS NOT NULL
3304: AND commission_line_id IN (SELECT commission_line_id

Line 3325: last_updated_by = fnd_global.user_id,

3321: FORALL m IN 1..l_wk_plan_elements.COUNT
3322: UPDATE cn_commission_lines cls
3323: SET posting_status = 'POSTED',
3324: last_update_date = SYSDATE,
3325: last_updated_by = fnd_global.user_id,
3326: last_update_login = fnd_global.login_id
3327: WHERE posting_status <> 'POSTED'
3328: AND credit_type_id = g_credit_type_id
3329: AND processed_period_id <= wksht_rec.pay_period_id

Line 3326: last_update_login = fnd_global.login_id

3322: UPDATE cn_commission_lines cls
3323: SET posting_status = 'POSTED',
3324: last_update_date = SYSDATE,
3325: last_updated_by = fnd_global.user_id,
3326: last_update_login = fnd_global.login_id
3327: WHERE posting_status <> 'POSTED'
3328: AND credit_type_id = g_credit_type_id
3329: AND processed_period_id <= wksht_rec.pay_period_id
3330: AND status = 'CALC'

Line 3341: last_updated_by = fnd_global.user_id,

3337: ELSE
3338: UPDATE cn_commission_lines clk
3339: SET posting_status = 'POSTED',
3340: last_update_date = SYSDATE,
3341: last_updated_by = fnd_global.user_id,
3342: last_update_login = fnd_global.login_id
3343: WHERE processed_period_id <= wksht_rec.pay_period_id
3344: AND status = 'CALC'
3345: AND credit_type_id = g_credit_type_id

Line 3342: last_update_login = fnd_global.login_id

3338: UPDATE cn_commission_lines clk
3339: SET posting_status = 'POSTED',
3340: last_update_date = SYSDATE,
3341: last_updated_by = fnd_global.user_id,
3342: last_update_login = fnd_global.login_id
3343: WHERE processed_period_id <= wksht_rec.pay_period_id
3344: AND status = 'CALC'
3345: AND credit_type_id = g_credit_type_id
3346: AND posting_status <> 'POSTED'

Line 3498: last_updated_by = fnd_global.user_id,

3494: --Update object_version_number
3495: UPDATE cn_payment_worksheets
3496: SET object_version_number = nvl(object_version_number, 0) + 1,
3497: last_update_date = SYSDATE,
3498: last_updated_by = fnd_global.user_id,
3499: last_update_login = fnd_global.login_id
3500: WHERE (payrun_id, salesrep_id) IN (SELECT payrun_id,
3501: salesrep_id
3502: FROM cn_payment_worksheets

Line 3499: last_update_login = fnd_global.login_id

3495: UPDATE cn_payment_worksheets
3496: SET object_version_number = nvl(object_version_number, 0) + 1,
3497: last_update_date = SYSDATE,
3498: last_updated_by = fnd_global.user_id,
3499: last_update_login = fnd_global.login_id
3500: WHERE (payrun_id, salesrep_id) IN (SELECT payrun_id,
3501: salesrep_id
3502: FROM cn_payment_worksheets
3503: WHERE payment_worksheet_id = p_worksheet_id);

Line 3635: last_updated_by = fnd_global.user_id,

3631: UPDATE cn_payment_transactions
3632: SET payrun_id = NULL,
3633: waive_flag = 'N',
3634: last_update_date = SYSDATE,
3635: last_updated_by = fnd_global.user_id,
3636: last_update_login = fnd_global.login_id
3637: WHERE payrun_id = wksht.payrun_id
3638: AND credited_salesrep_id = wksht.salesrep_id
3639: AND incentive_type_code = 'PMTPLN_REC';

Line 3636: last_update_login = fnd_global.login_id

3632: SET payrun_id = NULL,
3633: waive_flag = 'N',
3634: last_update_date = SYSDATE,
3635: last_updated_by = fnd_global.user_id,
3636: last_update_login = fnd_global.login_id
3637: WHERE payrun_id = wksht.payrun_id
3638: AND credited_salesrep_id = wksht.salesrep_id
3639: AND incentive_type_code = 'PMTPLN_REC';
3640:

Line 3658: last_updated_by = fnd_global.user_id,

3654: UPDATE cn_payment_transactions
3655: SET payrun_id = NULL,
3656: payment_amount = amount,
3657: last_update_date = SYSDATE,
3658: last_updated_by = fnd_global.user_id,
3659: last_update_login = fnd_global.login_id
3660: WHERE payrun_id = wksht.payrun_id
3661: AND credited_salesrep_id = wksht.salesrep_id
3662: AND commission_line_id IS NOT NULL;

Line 3659: last_update_login = fnd_global.login_id

3655: SET payrun_id = NULL,
3656: payment_amount = amount,
3657: last_update_date = SYSDATE,
3658: last_updated_by = fnd_global.user_id,
3659: last_update_login = fnd_global.login_id
3660: WHERE payrun_id = wksht.payrun_id
3661: AND credited_salesrep_id = wksht.salesrep_id
3662: AND commission_line_id IS NOT NULL;
3663: ELSE

Line 3673: last_updated_by = fnd_global.user_id,

3669:
3670: UPDATE cn_payment_transactions
3671: SET payrun_id = '',
3672: last_update_date = SYSDATE,
3673: last_updated_by = fnd_global.user_id,
3674: last_update_login = fnd_global.login_id
3675: WHERE payrun_id = wksht.payrun_id
3676: AND credited_salesrep_id = wksht.salesrep_id
3677: AND nvl(hold_flag, 'N') = 'Y';

Line 3674: last_update_login = fnd_global.login_id

3670: UPDATE cn_payment_transactions
3671: SET payrun_id = '',
3672: last_update_date = SYSDATE,
3673: last_updated_by = fnd_global.user_id,
3674: last_update_login = fnd_global.login_id
3675: WHERE payrun_id = wksht.payrun_id
3676: AND credited_salesrep_id = wksht.salesrep_id
3677: AND nvl(hold_flag, 'N') = 'Y';
3678: END IF;

Line 4070: last_update_login = fnd_global.login_id,

4066: bb_pmt_recovery_plans = s_bb_pmt_recovery_plans,
4067: current_earnings = l_curr_earnings,
4068: current_earnings_due = s_curr_earnings_due,
4069: last_update_date = SYSDATE,
4070: last_update_login = fnd_global.login_id,
4071: last_updated_by = fnd_global.user_id,
4072: object_version_number = l_wksht_sum_rec.object_version_number + 1
4073: WHERE payment_worksheet_id = l_wksht_sum_rec.payment_worksheet_id;
4074: END LOOP;

Line 4071: last_updated_by = fnd_global.user_id,

4067: current_earnings = l_curr_earnings,
4068: current_earnings_due = s_curr_earnings_due,
4069: last_update_date = SYSDATE,
4070: last_update_login = fnd_global.login_id,
4071: last_updated_by = fnd_global.user_id,
4072: object_version_number = l_wksht_sum_rec.object_version_number + 1
4073: WHERE payment_worksheet_id = l_wksht_sum_rec.payment_worksheet_id;
4074: END LOOP;
4075:

Line 4127: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;

4123: l_logical_batch_id NUMBER;
4124: l_max_batch_id NUMBER;
4125: l_physical_batch_id NUMBER;
4126: l_job_count NUMBER := 0;
4127: l_conc_request_id NUMBER(15) := fnd_global.conc_request_id;
4128: l_runner_count NUMBER := 0;
4129: l_error_count NUMBER := 0;
4130: l_warning_count NUMBER := 0;
4131: mysysdate CONSTANT DATE := SYSDATE;

Line 4212: fnd_global.user_id,

4208: 'VOID',
4209: p_org_id,
4210: p_params.conc_program_name,
4211: mysysdate,
4212: fnd_global.user_id,
4213: mysysdate,
4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,

Line 4214: fnd_global.user_id,

4210: p_params.conc_program_name,
4211: mysysdate,
4212: fnd_global.user_id,
4213: mysysdate,
4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,
4217: fnd_global.prog_appl_id,
4218: fnd_global.conc_program_id,

Line 4215: fnd_global.login_id,

4211: mysysdate,
4212: fnd_global.user_id,
4213: mysysdate,
4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,
4217: fnd_global.prog_appl_id,
4218: fnd_global.conc_program_id,
4219: mysysdate);

Line 4216: fnd_global.conc_request_id,

4212: fnd_global.user_id,
4213: mysysdate,
4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,
4217: fnd_global.prog_appl_id,
4218: fnd_global.conc_program_id,
4219: mysysdate);
4220:

Line 4217: fnd_global.prog_appl_id,

4213: mysysdate,
4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,
4217: fnd_global.prog_appl_id,
4218: fnd_global.conc_program_id,
4219: mysysdate);
4220:
4221: END IF;

Line 4218: fnd_global.conc_program_id,

4214: fnd_global.user_id,
4215: fnd_global.login_id,
4216: fnd_global.conc_request_id,
4217: fnd_global.prog_appl_id,
4218: fnd_global.conc_program_id,
4219: mysysdate);
4220:
4221: END IF;
4222: