DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_SECURITY_PVT

Line 1525: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);

1521: -- Initialize API return status to success
1522: x_return_status := fnd_api.g_ret_sts_success;
1523: x_loading_status := 'CN_INSERTED';
1524: --Added for R12 payment security check begin.
1525: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);
1526:
1527: IF (l_has_access = FALSE)
1528: THEN
1529: RAISE fnd_api.g_exc_error;

Line 1629: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);

1625: END IF;
1626:
1627: -- Get the Pay By Summary Profile value
1628: -- N - Pay by Summary Y - Pay by Transaction
1629: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);
1630:
1631: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1632: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,
1633: p_salesrep_id => p_worksheet_rec.salesrep_id,

Line 2212: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);

2208: BEGIN
2209: fnd_file.put_line(fnd_file.log, 'Entering create_mult_worksheet_conc ');
2210: retcode := 0;
2211: --Added for R12 payment security check begin.
2212: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);
2213: --Get the salesrep batch size from profile option.
2214: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
2215: fnd_file.put_line(fnd_file.log,'Batch size : ' ||l_batch_sz);
2216:

Line 2442: l_pay_by_mode := cn_payment_security_pvt.get_pay_by_mode(wksht_rec.payrun_id);

2438:
2439: RAISE fnd_api.g_exc_error;
2440: END IF;
2441:
2442: l_pay_by_mode := cn_payment_security_pvt.get_pay_by_mode(wksht_rec.payrun_id);
2443:
2444: SELECT s.status,
2445: nvl(r.payroll_flag, 'N'),
2446: r.payables_flag

Line 2465: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

2461: IF p_operation = 'REFRESH'
2462: THEN
2463:
2464: --Added for R12 payment security check end.
2465: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
2466: p_init_msg_list => p_init_msg_list,
2467: p_commit => 'F',
2468: p_validation_level => p_validation_level,
2469: x_return_status => x_return_status,

Line 3333: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3329:
3330: ELSIF p_operation IN ('LOCK', 'RELEASE_HOLD')
3331: THEN
3332:
3333: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3334: p_init_msg_list => p_init_msg_list,
3335: p_commit => 'F',
3336: p_validation_level => p_validation_level,
3337: x_return_status => x_return_status,

Line 3383: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,

3379: END IF;
3380: END IF;
3381:
3382: -- set wksht audit
3383: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,
3384: p_payrun_id => wksht_rec.payrun_id,
3385: p_salesrep_id => wksht_rec.salesrep_id,
3386: p_action => p_operation,
3387: x_return_status => x_return_status,

Line 3398: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3394: END IF;
3395: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')
3396: THEN
3397: -- 'UNLOCK', 'SUBMIT'
3398: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3399: p_init_msg_list => p_init_msg_list,
3400: p_commit => 'F',
3401: p_validation_level => p_validation_level,
3402: x_return_status => x_return_status,

Line 3414: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3410: RAISE fnd_api.g_exc_error;
3411: END IF;
3412: ELSIF p_operation IN ('APPROVE', 'REJECT')
3413: THEN
3414: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3415: p_init_msg_list => p_init_msg_list,
3416: p_commit => 'F',
3417: p_validation_level => p_validation_level,
3418: x_return_status => x_return_status,

Line 3431: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3427: RAISE fnd_api.g_exc_error;
3428: END IF;
3429: ELSIF p_operation IN ('HOLD_ALL', 'RELEASE_ALL', 'RESET_TO_UNPAID')
3430: THEN
3431: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3432: p_init_msg_list => p_init_msg_list,
3433: p_commit => 'F',
3434: p_validation_level => p_validation_level,
3435: x_return_status => x_return_status,

Line 3566: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3562: l_validation_only := nvl(p_validation_only, 'N');
3563:
3564: FOR wksht IN get_worksheet_dtls
3565: LOOP
3566: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3567: p_init_msg_list => p_init_msg_list,
3568: p_commit => 'F',
3569: p_validation_level => p_validation_level,
3570: x_return_status => x_return_status,

Line 3643: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,

3639: AND cnpd.credited_salesrep_id = wksht.salesrep_id
3640: AND nvl(cnpd.hold_flag, 'N') = 'N');
3641:
3642: -- add notes and audit
3643: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,
3644: p_payrun_id => wksht.payrun_id,
3645: p_salesrep_id => wksht.salesrep_id,
3646: p_action => 'REMOVE',
3647: x_return_status => x_return_status,

Line 4323: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_payrun_refresh);

4319: WHERE NAME = p_name
4320: AND org_id = mo_global.get_current_org_id;
4321: BEGIN
4322: fnd_file.put_line(fnd_file.log, 'Input Parameters Payrun_Name =' || p_name);
4323: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_payrun_refresh);
4324: --Get the salesrep batch size from profile option.
4325: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
4326: fnd_file.put_line(fnd_file.log, 'Batch Size =' || to_char(l_batch_sz));
4327: