DBA Data[Home] [Help]

APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PAY_APPROVAL_FLOW

Line 1: PACKAGE BODY CN_PAY_APPROVAL_FLOW_PVT AS

1: PACKAGE BODY CN_PAY_APPROVAL_FLOW_PVT AS
2: -- $Header: cnvpflwb.pls 120.4 2006/02/13 15:23:30 fmburu ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PAY_APPROVAL_FLOW_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvpflwb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PAY_APPROVAL_FLOW_PVT';

1: PACKAGE BODY CN_PAY_APPROVAL_FLOW_PVT AS
2: -- $Header: cnvpflwb.pls 120.4 2006/02/13 15:23:30 fmburu ship $
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_PAY_APPROVAL_FLOW_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnvpflwb.pls';
6:
7: --
8: -- Procedure : Get_Payrun_Info

Line 60: l_approval_status cn_pay_approval_flow.approval_status%TYPE;

56: p_resource_id IN NUMBER,
57: p_period_id IN NUMBER,
58: p_user_email IN VARCHAR2) IS
59:
60: l_approval_status cn_pay_approval_flow.approval_status%TYPE;
61: l_flow_rec cn_pay_approval_flow_pkg.pay_approval_flow_rec_type;
62:
63: CURSOR c_mgr_csr(c_org_id NUMBER) IS
64: SELECT DISTINCT m1.parent_resource_id mgr_resource_id,

Line 61: l_flow_rec cn_pay_approval_flow_pkg.pay_approval_flow_rec_type;

57: p_period_id IN NUMBER,
58: p_user_email IN VARCHAR2) IS
59:
60: l_approval_status cn_pay_approval_flow.approval_status%TYPE;
61: l_flow_rec cn_pay_approval_flow_pkg.pay_approval_flow_rec_type;
62:
63: CURSOR c_mgr_csr(c_org_id NUMBER) IS
64: SELECT DISTINCT m1.parent_resource_id mgr_resource_id,
65: re1.source_email mgr_email,re1.user_id mgr_user_id

Line 122: -- insert record into cn_pay_approval_flow

118: FROM cn_payruns
119: WHERE payrun_id = p_payrun_id;
120:
121: IF cn_payment_security_pvt.is_superuser(p_period_id => p_period_id,p_org_id=>p_org_id) = 1 THEN
122: -- insert record into cn_pay_approval_flow
123: SELECT cn_pay_approval_flow_s.NEXTVAL
124: INTO l_flow_rec.pay_approval_flow_id FROM dual;
125: l_flow_rec.payrun_id := p_payrun_id;
126: l_flow_rec.payment_worksheet_id := p_worksheet_id;

Line 123: SELECT cn_pay_approval_flow_s.NEXTVAL

119: WHERE payrun_id = p_payrun_id;
120:
121: IF cn_payment_security_pvt.is_superuser(p_period_id => p_period_id,p_org_id=>p_org_id) = 1 THEN
122: -- insert record into cn_pay_approval_flow
123: SELECT cn_pay_approval_flow_s.NEXTVAL
124: INTO l_flow_rec.pay_approval_flow_id FROM dual;
125: l_flow_rec.payrun_id := p_payrun_id;
126: l_flow_rec.payment_worksheet_id := p_worksheet_id;
127: l_flow_rec.submit_by_resource_id := p_resource_id ;

Line 137: cn_pay_approval_flow_pkg.insert_row

133: l_flow_rec.approval_status := l_approval_status ;
134: l_flow_rec.updated_by_resource_id := p_resource_id;
135: --R12
136: l_flow_rec.org_id := p_org_id;
137: cn_pay_approval_flow_pkg.insert_row
138: ( p_pay_approval_flow_rec => l_flow_rec);
139: ELSE
140: FOR l_mgr_csr IN c_mgr_csr(p_org_id) LOOP
141: -- insert record into cn_pay_approval_flow

Line 141: -- insert record into cn_pay_approval_flow

137: cn_pay_approval_flow_pkg.insert_row
138: ( p_pay_approval_flow_rec => l_flow_rec);
139: ELSE
140: FOR l_mgr_csr IN c_mgr_csr(p_org_id) LOOP
141: -- insert record into cn_pay_approval_flow
142: SELECT cn_pay_approval_flow_s.NEXTVAL
143: INTO l_flow_rec.pay_approval_flow_id FROM dual;
144: l_flow_rec.payrun_id := p_payrun_id;
145: l_flow_rec.payment_worksheet_id := p_worksheet_id;

Line 142: SELECT cn_pay_approval_flow_s.NEXTVAL

138: ( p_pay_approval_flow_rec => l_flow_rec);
139: ELSE
140: FOR l_mgr_csr IN c_mgr_csr(p_org_id) LOOP
141: -- insert record into cn_pay_approval_flow
142: SELECT cn_pay_approval_flow_s.NEXTVAL
143: INTO l_flow_rec.pay_approval_flow_id FROM dual;
144: l_flow_rec.payrun_id := p_payrun_id;
145: l_flow_rec.payment_worksheet_id := p_worksheet_id;
146: l_flow_rec.submit_by_resource_id := p_resource_id ;

Line 156: cn_pay_approval_flow_pkg.insert_row

152: l_flow_rec.approval_status := l_approval_status ;
153: l_flow_rec.updated_by_resource_id := p_resource_id;
154: --R12
155: l_flow_rec.org_id := p_org_id;
156: cn_pay_approval_flow_pkg.insert_row
157: ( p_pay_approval_flow_rec => l_flow_rec);
158: END LOOP;
159: END IF;
160:

Line 224: -- delete records in CN_PAY_APPROVAL_FLOW

220: RAISE FND_API.G_EXC_ERROR ;
221: END IF;
222: --Added for R12 payment security check end.
223:
224: -- delete records in CN_PAY_APPROVAL_FLOW
225: DELETE FROM cn_pay_approval_flow
226: WHERE payment_worksheet_id = p_worksheet_id;
227: -- get_payrun_info
228: Get_Payrun_Info

Line 225: DELETE FROM cn_pay_approval_flow

221: END IF;
222: --Added for R12 payment security check end.
223:
224: -- delete records in CN_PAY_APPROVAL_FLOW
225: DELETE FROM cn_pay_approval_flow
226: WHERE payment_worksheet_id = p_worksheet_id;
227: -- get_payrun_info
228: Get_Payrun_Info
229: (p_worksheet_id => p_worksheet_id,

Line 354: UPDATE cn_pay_approval_flow

350: x_resource_id => l_resource_id,
351: x_user_email => l_user_email);
352:
353: -- update pay_approval_flow record
354: UPDATE cn_pay_approval_flow
355: SET approval_status = 'APPROVED', updated_by_resource_id = l_resource_id,
356: last_updated_by = fnd_global.user_id,
357: last_update_date = Sysdate,
358: last_update_login = fnd_global.login_id

Line 482: UPDATE cn_pay_approval_flow

478: x_resource_id => l_resource_id,
479: x_user_email => l_user_email);
480:
481: -- update pay_approval_flow record
482: UPDATE cn_pay_approval_flow
483: SET approval_status = 'REJECTED', updated_by_resource_id = l_resource_id,
484: last_updated_by = fnd_global.user_id,
485: last_update_date = Sysdate,
486: last_update_login = fnd_global.login_id

Line 588: DELETE FROM cn_pay_approval_flow

584: END IF;
585: --Added for R12 payment security check end.
586:
587: -- delete record
588: DELETE FROM cn_pay_approval_flow
589: WHERE payrun_id = p_payrun_id
590: ;
591: -- End of API body.
592: -- Standard check of p_commit.

Line 633: END CN_PAY_APPROVAL_FLOW_PVT ;

629: p_encoded => FND_API.G_FALSE);
630:
631: END Pay_Payrun;
632:
633: END CN_PAY_APPROVAL_FLOW_PVT ;