APPS.OZF_SPLIT_CLAIM_PVT dependencies on OZF_CLAIM_LINES_ALL

Line 417: FROM ozf_claim_lines_all

413: /* BEGIN FIX BUG : split amount becomes null after updating split claim.*/
414: --SELECT SUM(claim_currency_amount)
415: SELECT NVL(SUM(claim_currency_amount), 0)
416: /* END FIX BUG : while calculating claim amount, line_sume_amount should set to 0 if it is null.*/
417: FROM ozf_claim_lines_all
418: WHERE claim_id = p_id;
419: l_line_amount_sum number;
420: l_diff_amount number;
421:

Line 741: FROM ozf_claim_lines_all

737: l_parent_amount_remaining NUMBER:=0;
738:
739: CURSOR line_amt_sum_csr( p_id in NUMBER) IS
740: SELECT NVL(SUM(claim_currency_amount), 0)
741: FROM ozf_claim_lines_all
742: WHERE claim_id = p_id;
743: l_parent_line_sum NUMBER:=0;
744: l_child_line_sum NUMBER:=0;
745: l_child_line_total NUMBER:=0;

Line 868: FROM ozf_claim_lines_all

864: l_object_version_number NUMBER;
865:
866: CURSOR getObjectVersionNumber(p_line_id IN NUMBER) IS
867: SELECT object_version_number
868: FROM ozf_claim_lines_all
869: WHERE claim_line_id = p_line_id;
870: --Bug# 7699177 fixed by ateotia(-)
871:
872: BEGIN

Line 972: FROM ozf_claim_lines_all

968: l_parent_amount_remaining NUMBER:=0;
969:
970: CURSOR line_amount_sum_csr(p_id in number) IS
971: SELECT NVL(SUM(claim_currency_amount), 0)
972: FROM ozf_claim_lines_all
973: WHERE claim_id = p_id;
974: l_current_sum number;
975:
976: CURSOR line_count_csr(p_id in number) IS

Line 978: FROM ozf_claim_lines_all

974: l_current_sum number;
975:
976: CURSOR line_count_csr(p_id in number) IS
977: SELECT Count(claim_line_id)
978: FROM ozf_claim_lines_all
979: WHERE claim_id = p_id;
980: l_line_count number:=0;
981:
982: CURSOR line_associate_csr(p_id in number) IS

Line 984: FROM ozf_claim_lines_all

980: l_line_count number:=0;
981:
982: CURSOR line_associate_csr(p_id in number) IS
983: SELECT earnings_associated_flag
984: FROM ozf_claim_lines_all
985: WHERE claim_id = p_id;
986: l_earning_flag varchar2(1);
987:
988: l_no_line_found boolean := true;

Line 992: FROM ozf_claim_lines_all

988: l_no_line_found boolean := true;
989:
990: CURSOR line_info_csr(p_id in number) IS
991: SELECT *
992: FROM ozf_claim_lines_all
993: where claim_id = p_id;
994:
995: l_claim_line line_info_csr%rowtype;
996: l_pvt_claim_line OZF_CLAIM_LINE_PVT.claim_line_rec_type ;

Line 1059: delete from ozf_claim_lines_all

1055: IF OZF_DEBUG_HIGH_ON THEN
1056: ozf_utility_PVT.debug_message('delete claim line amount ' || l_claim_line.claim_line_id);
1057: END IF;
1058:
1059: delete from ozf_claim_lines_all
1060: where claim_line_id = l_claim_line.claim_line_id;
1061: ELSE
1062: IF OZF_DEBUG_HIGH_ON THEN
1063: ozf_utility_PVT.debug_message('update parent claim amount ' ||l_claim_line.claim_line_id);

Line 1105: update ozf_claim_lines_all

1101: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
1102: RAISE FND_API.g_exc_unexpected_error;
1103: END IF;
1104: /*
1105: update ozf_claim_lines_all
1106: set claim_currency_amount = l_parent_amount_remaining - l_new_split_amount,
1107: quantity = null
1108: where claim_line_id = l_claim_line.claim_line_id;
1109: */