[Home] [Help]
894: x_return_status := FND_API.g_ret_sts_success;
895:
896: ------------------------ start -------------------------
897: BEGIN
898: UPDATE ozf_claim_lines_all
899: SET payment_status = 'PAID'
900: WHERE claim_line_id = p_claim_line_id;
901: EXCEPTION
902: WHEN OTHERS THEN
1364: , pay.trx_number --"settlement_number"
1365: , pay.trx_date --"settlement_date"
1366: , sum(pay.amount_due_original) --"settlement_amount"
1367: from ar_payment_schedules pay , ( select distinct customer_trx_id
1368: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
1369: where cm_line.line_type = 'LINE'
1370: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4940650
1371: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id) -- order line id
1372: and ln.claim_id = cv_claim_id) cla
1564: fu.component_id,
1565: SUM(lu.acctd_amount),
1566: SUM(lu.plan_curr_amount),
1567: SUM(lu.univ_curr_amount)
1568: FROM ozf_claim_lines_util_all lu
1569: ,ozf_claim_lines_all l
1570: ,ozf_funds_utilized_all_b fu
1571: WHERE l.claim_line_id = lu.claim_line_id
1572: AND fu.utilization_id = lu.utilization_id
1565: SUM(lu.acctd_amount),
1566: SUM(lu.plan_curr_amount),
1567: SUM(lu.univ_curr_amount)
1568: FROM ozf_claim_lines_util_all lu
1569: ,ozf_claim_lines_all l
1570: ,ozf_funds_utilized_all_b fu
1571: WHERE l.claim_line_id = lu.claim_line_id
1572: AND fu.utilization_id = lu.utilization_id
1573: AND l.claim_id = cv_claim_id
1696: , ln.offer_type
1697: , ln.prorate_earnings_flag
1698: , ln.earnings_end_date
1699: , ln.dpp_cust_account_id
1700: FROM ozf_claim_lines ln
1701: WHERE ln.claim_id = cv_claim_id;
1702:
1703: l_line_detail_tbl DPP_SLA_CLAIM_EXTRACT_PUB.claim_line_tbl_type;
1704: l_line_counter NUMBER := 1;
2402: , sum(nvl(tax_original,0))
2403: , sum(nvl(freight_original,0))
2404: , previous_customer_trx_id
2405: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id
2406: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
2407: where cm_line.line_type = 'LINE'
2408: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4953844
2409: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id)
2410: and ln.claim_id = cv_claim_id) cla
2415:
2416:
2417: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
2418: SELECT SUM(claim_currency_amount)
2419: FROM ozf_claim_lines
2420: WHERE claim_id = cv_claim_id;
2421:
2422: l_settlement_amount NUMBER := 0; --Bug3951827
2423: l_write_off_flag BOOLEAN;
2845: l_reopened_claims NUMBER := 0;
2846:
2847: CURSOR csr_total_claim_line(cv_claim_id IN NUMBER) IS
2848: SELECT COUNT(claim_line_id)
2849: FROM ozf_claim_lines
2850: WHERE claim_id = cv_claim_id;
2851:
2852: CURSOR csr_paid_claim_line(cv_claim_id IN NUMBER) IS
2853: SELECT COUNT(claim_line_id)
2850: WHERE claim_id = cv_claim_id;
2851:
2852: CURSOR csr_paid_claim_line(cv_claim_id IN NUMBER) IS
2853: SELECT COUNT(claim_line_id)
2854: FROM ozf_claim_lines
2855: WHERE claim_id = cv_claim_id
2856: AND payment_status = 'PAID';
2857:
2858: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3120: UPDATE ozf_claims_all
3121: SET payment_status = 'INTERFACED'
3122: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3123:
3124: UPDATE ozf_claim_lines_all
3125: SET payment_status = 'PAID'
3126: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3127: END IF;
3128: END IF; -- end if l_claim_rma_fetch.claim_id is not null and g_miss_num
3386: WHERE customer_trx_id = cv_customer_trx_id;
3387:
3388: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
3389: SELECT SUM(claim_currency_amount)
3390: FROM ozf_claim_lines
3391: WHERE claim_id = cv_claim_id;
3392:
3393: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3394: SELECT *