APPS.OZF_SPLIT_CLAIM_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 410: FROM ozf_claim_lines_all

406: /* BEGIN FIX BUG : split amount becomes null after updating split claim.*/
407: --SELECT SUM(claim_currency_amount)
408: SELECT NVL(SUM(claim_currency_amount), 0)
409: /* END FIX BUG : while calculating claim amount, line_sume_amount should set to 0 if it is null.*/
410: FROM ozf_claim_lines_all
411: WHERE claim_id = p_id;
412: l_line_amount_sum number;
413: l_diff_amount number;
414:

Line 734: FROM ozf_claim_lines_all

730: l_parent_amount_remaining NUMBER:=0;
731:
732: CURSOR line_amt_sum_csr( p_id in NUMBER) IS
733: SELECT NVL(SUM(claim_currency_amount), 0)
734: FROM ozf_claim_lines_all
735: WHERE claim_id = p_id;
736: l_parent_line_sum NUMBER:=0;
737: l_child_line_sum NUMBER:=0;
738: l_child_line_total NUMBER:=0;

Line 925: FROM ozf_claim_lines_all

921: l_parent_amount_remaining NUMBER:=0;
922:
923: CURSOR line_amount_sum_csr(p_id in number) IS
924: SELECT NVL(SUM(claim_currency_amount), 0)
925: FROM ozf_claim_lines_all
926: WHERE claim_id = p_id;
927: l_current_sum number;
928:
929: CURSOR line_count_csr(p_id in number) IS

Line 931: FROM ozf_claim_lines_all

927: l_current_sum number;
928:
929: CURSOR line_count_csr(p_id in number) IS
930: SELECT Count(claim_line_id)
931: FROM ozf_claim_lines_all
932: WHERE claim_id = p_id;
933: l_line_count number:=0;
934:
935: CURSOR line_associate_csr(p_id in number) IS

Line 937: FROM ozf_claim_lines_all

933: l_line_count number:=0;
934:
935: CURSOR line_associate_csr(p_id in number) IS
936: SELECT earnings_associated_flag
937: FROM ozf_claim_lines_all
938: WHERE claim_id = p_id;
939: l_earning_flag varchar2(1);
940:
941: l_no_line_found boolean := true;

Line 945: FROM ozf_claim_lines_all

941: l_no_line_found boolean := true;
942:
943: CURSOR line_info_csr(p_id in number) IS
944: SELECT *
945: FROM ozf_claim_lines_all
946: where claim_id = p_id;
947:
948: l_claim_line line_info_csr%rowtype;
949: l_pvt_claim_line OZF_CLAIM_LINE_PVT.claim_line_rec_type ;

Line 1013: delete from ozf_claim_lines_all

1009: IF OZF_DEBUG_HIGH_ON THEN
1010: ozf_utility_PVT.debug_message('delete claim line amount ' || l_claim_line.claim_line_id);
1011: END IF;
1012:
1013: delete from ozf_claim_lines_all
1014: where claim_line_id = l_claim_line.claim_line_id;
1015: ELSE
1016:
1017: IF OZF_DEBUG_HIGH_ON THEN

Line 1066: update ozf_claim_lines_all

1062: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1063: RAISE FND_API.g_exc_unexpected_error;
1064: END IF;
1065: /*
1066: update ozf_claim_lines_all
1067: set claim_currency_amount = l_parent_amount_remaining - l_new_split_amount,
1068: quantity = null
1069: where claim_line_id = l_claim_line.claim_line_id;
1070: */