146: x_return_status OUT NOCOPY VARCHAR2
147: ,x_msg_count OUT NOCOPY NUMBER
148: ,x_msg_data OUT NOCOPY VARCHAR2
149:
150: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
151: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
152: )
153: IS
154: l_return_status VARCHAR2(1);
147: ,x_msg_count OUT NOCOPY NUMBER
148: ,x_msg_data OUT NOCOPY VARCHAR2
149:
150: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
151: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
152: )
153: IS
154: l_return_status VARCHAR2(1);
155: l_api_name CONSTANT VARCHAR2(30) := 'Reopen_Claim_for_Completion';
661: x_return_status OUT NOCOPY VARCHAR2
662: ,x_msg_count OUT NOCOPY NUMBER
663: ,x_msg_data OUT NOCOPY VARCHAR2
664:
665: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
666: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
667: )
668: IS
669: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Claim_for_Completion';
662: ,x_msg_count OUT NOCOPY NUMBER
663: ,x_msg_data OUT NOCOPY VARCHAR2
664:
665: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
666: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
667: )
668: IS
669: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Claim_for_Completion';
670: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;
817: x_return_status OUT NOCOPY VARCHAR2
818: ,x_msg_count OUT NOCOPY NUMBER
819: ,x_msg_data OUT NOCOPY VARCHAR2
820:
821: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
822: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
823: )
824: IS
825: l_api_version CONSTANT NUMBER := 1.0;
818: ,x_msg_count OUT NOCOPY NUMBER
819: ,x_msg_data OUT NOCOPY VARCHAR2
820:
821: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
822: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
823: )
824: IS
825: l_api_version CONSTANT NUMBER := 1.0;
826: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Claim_for_Completion';
947: x_return_status OUT NOCOPY VARCHAR2
948: ,x_msg_count OUT NOCOPY NUMBER
949: ,x_msg_data OUT NOCOPY VARCHAR2
950:
951: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
952: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
953: )
954: IS
955: l_api_version CONSTANT NUMBER := 1.0;
948: ,x_msg_count OUT NOCOPY NUMBER
949: ,x_msg_data OUT NOCOPY VARCHAR2
950:
951: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
952: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
953: )
954: IS
955: l_api_version CONSTANT NUMBER := 1.0;
956: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Claim_for_Completion';
1240: ,x_msg_count OUT NOCOPY NUMBER
1241: ,x_msg_data OUT NOCOPY VARCHAR2
1242:
1243: ,p_approval_require IN VARCHAR2
1244: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1245: ,p_prev_status IN VARCHAR2
1246: ,p_curr_status IN VARCHAR2
1247:
1248: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
1244: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1245: ,p_prev_status IN VARCHAR2
1246: ,p_curr_status IN VARCHAR2
1247:
1248: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
1249: )
1250: IS
1251: l_api_version CONSTANT NUMBER := 1.0;
1252: l_api_name CONSTANT VARCHAR2(30) := 'Create_Payment_for_Completion';
2018: PROCEDURE Update_Claim_Remaining_Amount(
2019: x_return_status OUT NOCOPY VARCHAR2
2020: ,x_msg_count OUT NOCOPY NUMBER
2021: ,x_msg_data OUT NOCOPY VARCHAR2
2022: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2023: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2024: )
2025: IS
2026: l_api_version CONSTANT NUMBER := 1.0;
2019: x_return_status OUT NOCOPY VARCHAR2
2020: ,x_msg_count OUT NOCOPY NUMBER
2021: ,x_msg_data OUT NOCOPY VARCHAR2
2022: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2023: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2024: )
2025: IS
2026: l_api_version CONSTANT NUMBER := 1.0;
2027: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_Remaining_Amount';
2263: ,x_return_status OUT NOCOPY VARCHAR2
2264: ,x_msg_data OUT NOCOPY VARCHAR2
2265: ,x_msg_count OUT NOCOPY NUMBER
2266:
2267: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2268: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2269: )
2270: IS
2271: l_api_version CONSTANT NUMBER := 1.0;
2264: ,x_msg_data OUT NOCOPY VARCHAR2
2265: ,x_msg_count OUT NOCOPY NUMBER
2266:
2267: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2268: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2269: )
2270: IS
2271: l_api_version CONSTANT NUMBER := 1.0;
2272: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Settlement';
2275:
2276: l_curr_status VARCHAR2(30);
2277: l_prev_status VARCHAR2(30);
2278:
2279: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2280: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2281: l_approval_require VARCHAR2(1);
2282:
2283: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS
2276: l_curr_status VARCHAR2(30);
2277: l_prev_status VARCHAR2(30);
2278:
2279: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2280: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2281: l_approval_require VARCHAR2(1);
2282:
2283: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS
2284: SELECT status_code