[Home] [Help]
1129: x_return_status := FND_API.g_ret_sts_success;
1130:
1131: ------------------------ start -------------------------
1132: BEGIN
1133: UPDATE ozf_claim_lines_all
1134: SET payment_status = 'PAID'
1135: WHERE claim_line_id = p_claim_line_id;
1136: EXCEPTION
1137: WHEN OTHERS THEN
1641: , pay.trx_number --"settlement_number"
1642: , pay.trx_date --"settlement_date"
1643: , sum(pay.amount_due_original) --"settlement_amount"
1644: from ar_payment_schedules pay , ( select distinct customer_trx_id
1645: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
1646: where cm_line.line_type = 'LINE'
1647: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4940650
1648: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id) -- order line id
1649: and ln.claim_id = cv_claim_id) cla
1928: SUM(lu.acctd_amount),
1929: SUM(lu.plan_curr_amount),
1930: SUM(lu.univ_curr_amount),
1931: SUM(lu.util_curr_amount) -- 8710054
1932: FROM ozf_claim_lines_util_all lu
1933: ,ozf_claim_lines_all l
1934: ,ozf_funds_utilized_all_b fu
1935: WHERE l.claim_line_id = lu.claim_line_id
1936: AND fu.utilization_id = lu.utilization_id
1929: SUM(lu.plan_curr_amount),
1930: SUM(lu.univ_curr_amount),
1931: SUM(lu.util_curr_amount) -- 8710054
1932: FROM ozf_claim_lines_util_all lu
1933: ,ozf_claim_lines_all l
1934: ,ozf_funds_utilized_all_b fu
1935: WHERE l.claim_line_id = lu.claim_line_id
1936: AND fu.utilization_id = lu.utilization_id
1937: AND l.claim_id = cv_claim_id
2056: , ln.offer_type
2057: , ln.prorate_earnings_flag
2058: , ln.earnings_end_date
2059: , ln.dpp_cust_account_id
2060: FROM ozf_claim_lines ln
2061: WHERE ln.claim_id = cv_claim_id;
2062:
2063: l_line_detail_tbl DPP_SLA_CLAIM_EXTRACT_PUB.claim_line_tbl_type;
2064: l_line_counter NUMBER := 1;
2874: , sum(nvl(tax_original,0))
2875: , sum(nvl(freight_original,0))
2876: , previous_customer_trx_id
2877: from ar_payment_schedules ps, ra_customer_trx trx , ( select distinct customer_trx_id
2878: from ozf_claim_lines ln , ra_customer_trx_lines cm_line
2879: where cm_line.line_type = 'LINE'
2880: and cm_line.interface_line_context = 'ORDER ENTRY' --added filter for 4953844
2881: and cm_line.interface_line_attribute6 = to_char(ln.payment_reference_id)
2882: and ln.claim_id = cv_claim_id) cla
2887:
2888:
2889: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
2890: SELECT SUM(claim_currency_amount)
2891: FROM ozf_claim_lines
2892: WHERE claim_id = cv_claim_id;
2893:
2894: l_settlement_amount NUMBER := 0; --Bug3951827
2895: l_write_off_flag BOOLEAN;
3317: l_reopened_claims NUMBER := 0;
3318:
3319: CURSOR csr_total_claim_line(cv_claim_id IN NUMBER) IS
3320: SELECT COUNT(claim_line_id)
3321: FROM ozf_claim_lines
3322: WHERE claim_id = cv_claim_id;
3323:
3324: CURSOR csr_paid_claim_line(cv_claim_id IN NUMBER) IS
3325: SELECT COUNT(claim_line_id)
3322: WHERE claim_id = cv_claim_id;
3323:
3324: CURSOR csr_paid_claim_line(cv_claim_id IN NUMBER) IS
3325: SELECT COUNT(claim_line_id)
3326: FROM ozf_claim_lines
3327: WHERE claim_id = cv_claim_id
3328: AND payment_status = 'PAID';
3329:
3330: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3592: UPDATE ozf_claims_all
3593: SET payment_status = 'INTERFACED'
3594: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3595:
3596: UPDATE ozf_claim_lines_all
3597: SET payment_status = 'PAID'
3598: WHERE claim_id = l_claim_rma_fetch(i).claim_id;
3599: END IF;
3600: END IF; -- end if l_claim_rma_fetch.claim_id is not null and g_miss_num
3858: WHERE customer_trx_id = cv_customer_trx_id;
3859:
3860: CURSOR csr_sum_line_amount(cv_claim_id IN NUMBER) IS
3861: SELECT SUM(claim_currency_amount)
3862: FROM ozf_claim_lines
3863: WHERE claim_id = cv_claim_id;
3864:
3865: CURSOR csr_claim_lock(cv_claim_id IN NUMBER) IS
3866: SELECT *