122: l_appr_hist_rec.approver_type := 'USER'; -- User always submits
123:
124:
125:
126: IF OZF_Claim_Accrual_PVT.Earnings_Approval_Required(p_activity_id) = FND_API.g_true THEN
127: AMS_Gen_Approval_Pvt.Get_Approval_Rule(p_activity_id ,
128: 'CLAM',
129: 'EARNING',
130: null,
166:
167: l_appr_hist_rec.approval_type := 'PERFORMANCE';
168: l_appr_hist_rec.sequence_num := 0;
169:
170: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(p_activity_id) = FND_API.g_true THEN
171: AMS_Gen_Approval_Pvt.Get_Approval_Rule(p_activity_id ,
172: 'CLAM',
173: 'PERFORMANCE',
174: null,
214: p_claim_id IN NUMBER
215: ,x_offer_perf_req OUT NOCOPY VARCHAR2
216: )
217: IS
218: l_offer_perf_tbl OZF_Claim_Accrual_PVT.offer_performance_tbl_type;
219: l_offer_name VARCHAR2(30);
220:
221: CURSOR csr_offer_name(cv_offer_id IN NUMBER) IS
222: SELECT o.offer_code
223: FROM ozf_offers o
224: WHERE o.qp_list_header_id = cv_offer_id;
225:
226: BEGIN
227: OZF_Claim_Accrual_PVT.Check_Offer_Performance_Tbl(
228: p_claim_id => p_claim_id
229: ,x_offer_perf_tbl => l_offer_perf_tbl
230: );
231:
248: p_claim_id IN NUMBER
249: ,x_offer_earn_req OUT NOCOPY VARCHAR2
250: )
251: IS
252: l_offer_earn_tbl OZF_Claim_Accrual_PVT.offer_earning_tbl_type;
253: l_offer_name VARCHAR2(30);
254:
255: CURSOR csr_offer_name(cv_offer_id IN NUMBER) IS
256: SELECT o.offer_code
257: FROM ozf_offers o
258: WHERE o.qp_list_header_id = cv_offer_id;
259:
260: BEGIN
261: OZF_Claim_Accrual_PVT.Check_Offer_Earning_Tbl(
262: p_claim_id => p_claim_id
263: ,x_offer_earn_tbl => l_offer_earn_tbl
264: );
265:
2354: );
2355:
2356: IF l_update_status = 'APPROVED' AND
2357: l_approval_type = 'EARNING' THEN
2358: IF OZF_Claim_Accrual_PVT.Perform_Approval_Required(l_claim_id) = FND_API.g_true THEN
2359: -- Start Performance Approval
2360: Start_Approval_Process(
2361: p_claim_id => l_claim_id
2362: ,p_orig_status_id => l_orig_status_id