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 667: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

663: x_return_status OUT NOCOPY VARCHAR2
664: ,x_msg_count OUT NOCOPY NUMBER
665: ,x_msg_data OUT NOCOPY VARCHAR2
666:
667: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
668: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
669: )
670: IS
671: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Claim_for_Completion';

Line 668: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

664: ,x_msg_count OUT NOCOPY NUMBER
665: ,x_msg_data OUT NOCOPY VARCHAR2
666:
667: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
668: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
669: )
670: IS
671: l_api_name CONSTANT VARCHAR2(30) := 'Reject_Claim_for_Completion';
672: l_full_name CONSTANT VARCHAR2(60) := G_PKG_NAME || '.' || l_api_name;

Line 823: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

819: x_return_status OUT NOCOPY VARCHAR2
820: ,x_msg_count OUT NOCOPY NUMBER
821: ,x_msg_data OUT NOCOPY VARCHAR2
822:
823: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
824: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
825: )
826: IS
827: l_api_version CONSTANT NUMBER := 1.0;

Line 824: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

820: ,x_msg_count OUT NOCOPY NUMBER
821: ,x_msg_data OUT NOCOPY VARCHAR2
822:
823: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
824: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
825: )
826: IS
827: l_api_version CONSTANT NUMBER := 1.0;
828: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Claim_for_Completion';

Line 953: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

949: x_return_status OUT NOCOPY VARCHAR2
950: ,x_msg_count OUT NOCOPY NUMBER
951: ,x_msg_data OUT NOCOPY VARCHAR2
952:
953: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
954: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
955: )
956: IS
957: l_api_version CONSTANT NUMBER := 1.0;

Line 954: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

950: ,x_msg_count OUT NOCOPY NUMBER
951: ,x_msg_data OUT NOCOPY VARCHAR2
952:
953: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
954: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
955: )
956: IS
957: l_api_version CONSTANT NUMBER := 1.0;
958: l_api_name CONSTANT VARCHAR2(30) := 'Approve_Claim_for_Completion';

Line 1246: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

1242: ,x_msg_count OUT NOCOPY NUMBER
1243: ,x_msg_data OUT NOCOPY VARCHAR2
1244:
1245: ,p_approval_require IN VARCHAR2
1246: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1247: ,p_prev_status IN VARCHAR2
1248: ,p_curr_status IN VARCHAR2
1249:
1250: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

Line 1250: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

1246: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
1247: ,p_prev_status IN VARCHAR2
1248: ,p_curr_status IN VARCHAR2
1249:
1250: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
1251: )
1252: IS
1253: l_api_version CONSTANT NUMBER := 1.0;
1254: l_api_name CONSTANT VARCHAR2(30) := 'Create_Payment_for_Completion';

Line 2035: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

2031: PROCEDURE Update_Claim_Remaining_Amount(
2032: x_return_status OUT NOCOPY VARCHAR2
2033: ,x_msg_count OUT NOCOPY NUMBER
2034: ,x_msg_data OUT NOCOPY VARCHAR2
2035: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2036: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2037: )
2038: IS
2039: l_api_version CONSTANT NUMBER := 1.0;

Line 2036: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

2032: x_return_status OUT NOCOPY VARCHAR2
2033: ,x_msg_count OUT NOCOPY NUMBER
2034: ,x_msg_data OUT NOCOPY VARCHAR2
2035: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2036: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2037: )
2038: IS
2039: l_api_version CONSTANT NUMBER := 1.0;
2040: l_api_name CONSTANT VARCHAR2(30) := 'Update_Claim_Remaining_Amount';

Line 2502: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type

2498: ,x_return_status OUT NOCOPY VARCHAR2
2499: ,x_msg_data OUT NOCOPY VARCHAR2
2500: ,x_msg_count OUT NOCOPY NUMBER
2501:
2502: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2503: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2504: )
2505: IS
2506: l_api_version CONSTANT NUMBER := 1.0;

Line 2503: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type

2499: ,x_msg_data OUT NOCOPY VARCHAR2
2500: ,x_msg_count OUT NOCOPY NUMBER
2501:
2502: ,p_claim_rec IN OZF_CLAIM_PVT.claim_rec_type
2503: ,x_claim_rec OUT NOCOPY OZF_CLAIM_PVT.claim_rec_type
2504: )
2505: IS
2506: l_api_version CONSTANT NUMBER := 1.0;
2507: l_api_name CONSTANT VARCHAR2(30) := 'Complete_Settlement';

Line 2514: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2510:
2511: l_curr_status VARCHAR2(30);
2512: l_prev_status VARCHAR2(30);
2513:
2514: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2515: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2516: l_approval_require VARCHAR2(1);
2517:
2518: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS

Line 2515: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;

2511: l_curr_status VARCHAR2(30);
2512: l_prev_status VARCHAR2(30);
2513:
2514: l_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2515: l_complete_claim_rec OZF_CLAIM_PVT.claim_rec_type;
2516: l_approval_require VARCHAR2(1);
2517:
2518: CURSOR csr_claim_prev_status(cv_claim_id IN NUMBER) IS
2519: SELECT status_code