APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL

Line 1685: FROM ozf_settlement_docs_all

1681: , settlement_type_id
1682: , settlement_amount
1683: , gl_date
1684: , wo_rec_trx_id
1685: FROM ozf_settlement_docs_all
1686: WHERE claim_id = cv_group_claim_id;
1687: -- add addtional order by clause for mass settlement ordering rule criteria
1688:
1689: CURSOR csr_get_source_object_id(cv_claim_id IN NUMBER) IS

Line 2606: UPDATE ozf_settlement_docs_all

2602: , group_claim_id = null
2603: , payment_method = null
2604: WHERE group_claim_id = p_group_claim_id;
2605:
2606: UPDATE ozf_settlement_docs_all
2607: SET payment_status = 'CANCELLED'
2608: WHERE group_claim_id = p_group_claim_id;
2609:
2610: EXCEPTION

Line 2705: FROM ozf_settlement_docs_all

2701: , payment_reference_number
2702: , group_claim_id
2703: , gl_date
2704: , wo_rec_trx_id
2705: FROM ozf_settlement_docs_all
2706: WHERE claim_id = cv_claim_id
2707: AND group_claim_id = cv_group_claim_id
2708: AND payment_status <> 'CANCELLED';
2709:

Line 2819: UPDATE ozf_settlement_docs_all

2815: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2816: END IF;
2817:
2818: BEGIN
2819: UPDATE ozf_settlement_docs_all
2820: SET payment_status = 'PENDING_PAID'
2821: WHERE settlement_doc_id = l_settlement_doc_tbl(j).settlement_doc_id;
2822: EXCEPTION
2823: WHEN OTHERS THEN