DBA Data[Home] [Help]

APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on OZF_CLAIM_PVT

Line 150: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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);

Line 151: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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';

Line 665: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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';

Line 666: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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;

Line 821: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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;

Line 822: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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';

Line 951: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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;

Line 952: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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';

Line 1244: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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

Line 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';

Line 2022: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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;

Line 2023: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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';

Line 2267: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

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;

Line 2268: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

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';

Line 2279: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

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

Line 2280: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;

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