APPS.CN_PAY_APPROVAL_FLOW_PVT dependencies on CN_PAY_APPROVAL_FLOW_PKG

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 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 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: