APPS.CN_PAYMENT_SECURITY_PVT dependencies on CN_PAY_APPROVAL_FLOW

Line 226: -- into cn_reasons, update records in cn_pay_approval_flow

222:
223: --
224: -- Procedure : Paid_Payrun_Audit
225: -- This procedue will update payrun status to paid, insert audit record
226: -- into cn_reasons, update records in cn_pay_approval_flow
227: -- Should call this procedure at the end of pay_payrun procedure
228: --
229: PROCEDURE paid_payrun_audit (
230: p_payrun_id IN NUMBER,

Line 296: -- call cn_pay_approval_flow_pvt.pay_payrun

292: );
293:
294: END LOOP;
295:
296: -- call cn_pay_approval_flow_pvt.pay_payrun
297: cn_pay_approval_flow_pvt.pay_payrun (p_api_version => 1.0,
298: x_return_status => x_return_status,
299: x_msg_count => x_msg_count,
300: x_msg_data => x_msg_data,

Line 297: cn_pay_approval_flow_pvt.pay_payrun (p_api_version => 1.0,

293:
294: END LOOP;
295:
296: -- call cn_pay_approval_flow_pvt.pay_payrun
297: cn_pay_approval_flow_pvt.pay_payrun (p_api_version => 1.0,
298: x_return_status => x_return_status,
299: x_msg_count => x_msg_count,
300: x_msg_data => x_msg_data,
301: p_payrun_id => p_payrun_id

Line 551: cn_pay_approval_flow_pvt.submit_worksheet (p_api_version => 1.0,

547: l_new_status := 'SUBMITTED';
548:
549: IF p_do_approval_flow = fnd_api.g_true
550: THEN
551: cn_pay_approval_flow_pvt.submit_worksheet (p_api_version => 1.0,
552: x_return_status => x_return_status,
553: x_msg_count => x_msg_count,
554: x_msg_data => x_msg_data,
555: p_worksheet_id => p_worksheet_id

Line 572: cn_pay_approval_flow_pvt.approve_worksheet (p_api_version => 1.0,

568: l_new_status := 'APPROVED';
569:
570: IF p_do_approval_flow = fnd_api.g_true
571: THEN
572: cn_pay_approval_flow_pvt.approve_worksheet (p_api_version => 1.0,
573: x_return_status => x_return_status,
574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,
576: p_worksheet_id => p_worksheet_id

Line 593: cn_pay_approval_flow_pvt.reject_worksheet (p_api_version => 1.0,

589: l_new_status := 'UNPAID';
590:
591: IF p_do_approval_flow = fnd_api.g_true
592: THEN
593: cn_pay_approval_flow_pvt.reject_worksheet (p_api_version => 1.0,
594: x_return_status => x_return_status,
595: x_msg_count => x_msg_count,
596: x_msg_data => x_msg_data,
597: p_worksheet_id => p_worksheet_id

Line 1450: -- cn_pay_approval_flow table to find out which analysts this wksht

1446: */
1447:
1448: -- l_assigned_to_user_id is null
1449: -- if wksht is submitted or approved, need to check in
1450: -- cn_pay_approval_flow table to find out which analysts this wksht
1451: -- submit_to and see if current user has access to these analyst
1452: -- only need to check if p_action = SUBMIT or APPROVE
1453: IF l_assigned_to_user_id IS NULL
1454: THEN

Line 1497: FROM cn_pay_approval_flow

1493: AND ((m2.start_date_active <= v3.end_date) AND (v3.start_date <= NVL (m2.end_date_active, v3.start_date)))
1494: AND m2.CATEGORY <> 'TBH'
1495: AND m2.hierarchy_type IN ('MGR_TO_MGR', 'MGR_TO_REP', 'REP_TO_REP')
1496: AND m2.resource_id IN (SELECT DISTINCT submit_to_resource_id
1497: FROM cn_pay_approval_flow
1498: WHERE payment_worksheet_id = p_worksheet_id));
1499: EXCEPTION
1500: WHEN NO_DATA_FOUND
1501: THEN

Line 1527: FROM cn_pay_approval_flow

1523:
1524: --Added for R12 payment security check end.
1525: SELECT COUNT (1)
1526: INTO l_tmp
1527: FROM cn_pay_approval_flow
1528: WHERE payment_worksheet_id = p_worksheet_id
1529: AND submit_by_user_id = fnd_global.user_id AND approval_status = 'APPROVED';
1530:
1531: IF l_tmp > 0