APPS.OZF_MASS_SETTLEMENT_PVT dependencies on OZF_SETTLEMENT_DOCS_ALL

Line 1691: FROM ozf_settlement_docs_all

1687: , settlement_type_id
1688: , settlement_amount
1689: , gl_date
1690: , wo_rec_trx_id
1691: FROM ozf_settlement_docs_all
1692: WHERE claim_id = cv_group_claim_id;
1693: -- add addtional order by clause for mass settlement ordering rule criteria
1694:
1695: CURSOR csr_get_source_object_id(cv_claim_id IN NUMBER) IS

Line 2627: UPDATE ozf_settlement_docs_all

2623: , group_claim_id = null
2624: , payment_method = null
2625: WHERE group_claim_id = p_group_claim_id;
2626:
2627: UPDATE ozf_settlement_docs_all
2628: SET payment_status = 'CANCELLED'
2629: WHERE group_claim_id = p_group_claim_id;
2630:
2631: EXCEPTION

Line 2726: FROM ozf_settlement_docs_all

2722: , payment_reference_number
2723: , group_claim_id
2724: , gl_date
2725: , wo_rec_trx_id
2726: FROM ozf_settlement_docs_all
2727: WHERE claim_id = cv_claim_id
2728: AND group_claim_id = cv_group_claim_id
2729: AND payment_status <> 'CANCELLED';
2730:

Line 2899: UPDATE ozf_settlement_docs_all

2895: OZF_Utility_PVT.debug_message('Payment -- payment_reference_number = '||l_settlement_doc_tbl(j).payment_reference_number);
2896: END IF;
2897:
2898: BEGIN
2899: UPDATE ozf_settlement_docs_all
2900: SET payment_status = 'PENDING_PAID'
2901: WHERE settlement_doc_id = l_settlement_doc_tbl(j).settlement_doc_id;
2902: EXCEPTION
2903: WHEN OTHERS THEN