DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_UTILITY_PVT

Line 120: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

116: ,x_msg_count OUT NOCOPY NUMBER
117:
118: ,p_line_util_tbl IN line_util_tbl_type
119: ,p_currency_rec IN currency_rec_type
120: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
121:
122: ,x_error_index OUT NOCOPY NUMBER
123: );
124: ---------------------------------------------------------------------

Line 156: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

152: ,x_msg_data OUT NOCOPY VARCHAR2
153:
154: ,p_line_util_rec IN line_util_rec_type
155: ,p_currency_rec IN currency_rec_type
156: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
157:
158: ,x_line_util_id OUT NOCOPY NUMBER
159: ,px_line_util_tbl IN OUT NOCOPY line_util_tbl_type --ninarasi fix for bug 13550004
160: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939

Line 188: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

184: ,x_msg_data OUT NOCOPY VARCHAR2
185:
186: ,p_line_util_id IN NUMBER
187: ,p_object_version IN NUMBER
188: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
189: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939
190: );
191:
192: ---------------------------------------------------------------------

Line 218: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

214: ,x_msg_count OUT NOCOPY NUMBER
215: ,x_msg_data OUT NOCOPY VARCHAR2
216:
217: ,p_line_util_rec IN line_util_rec_type
218: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
219:
220: ,x_object_version OUT NOCOPY NUMBER
221: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939
222: );

Line 2216: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

2212: ,x_msg_count OUT NOCOPY NUMBER
2213:
2214: ,p_line_util_tbl IN line_util_tbl_type
2215: ,p_currency_rec IN currency_rec_type
2216: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2217: ,x_error_index OUT NOCOPY NUMBER
2218: ) IS
2219: l_api_version CONSTANT NUMBER := 1.0;
2220: l_api_name CONSTANT VARCHAR2(30) := 'Create_Line_Util_Tbl';

Line 2311: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN

2307:
2308: x_return_status := FND_API.g_ret_sts_success;
2309:
2310: --Claim Access Check: Abort process, if current user doesnt have access on claim.
2311: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
2312: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
2313: IF p_line_util_tbl.EXISTS(j) THEN
2314:
2315: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 2319: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2315: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
2316: FETCH csr_claim_id INTO l_claim_id;
2317: CLOSE csr_claim_id;
2318:
2319: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2320: P_Api_Version_Number => 1.0
2321: , P_Init_Msg_List => FND_API.G_FALSE
2322: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2323: , P_Commit => FND_API.G_FALSE

Line 2409: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2405: , x_msg_count => x_msg_count
2406: , x_msg_data => x_msg_data
2407: , p_line_util_rec => l_line_util_rec
2408: , p_currency_rec => l_currency_rec
2409: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2410: , x_line_util_id => l_line_util_id
2411: , px_line_util_tbl => l_line_util_tbl --ninarasi fix for bug 13530939
2412: , px_upd_line_util_tbl => l_upd_fund_util_tbl
2413: );

Line 2634: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

2630: ,x_msg_data OUT NOCOPY VARCHAR2
2631:
2632: ,p_line_util_rec IN line_util_rec_type
2633: ,p_currency_rec IN currency_rec_type
2634: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2635: ,x_line_util_id OUT NOCOPY NUMBER
2636: ,px_line_util_tbl IN OUT NOCOPY line_util_tbl_type --ninarasi fix for bug 13530939
2637: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939
2638: )

Line 2961: ,p_mode IN VARCHAr2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

2957: ,x_msg_data OUT NOCOPY VARCHAR2
2958: ,x_msg_count OUT NOCOPY NUMBER
2959:
2960: ,p_line_util_tbl IN line_util_tbl_type
2961: ,p_mode IN VARCHAr2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2962:
2963: ,x_error_index OUT NOCOPY NUMBER
2964: ) IS
2965: l_api_version CONSTANT NUMBER := 1.0;

Line 3008: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN

3004:
3005: x_return_status := FND_API.g_ret_sts_success;
3006:
3007: ---------------------- check claim access ------------------------
3008: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
3009: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
3010: IF p_line_util_tbl.EXISTS(j) THEN
3011:
3012: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 3016: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3012: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
3013: FETCH csr_claim_id INTO l_claim_id;
3014: CLOSE csr_claim_id;
3015:
3016: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3017: P_Api_Version_Number => 1.0
3018: , P_Init_Msg_List => FND_API.G_FALSE
3019: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3020: , P_Commit => FND_API.G_FALSE

Line 3059: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3055: , x_return_status => l_return_status
3056: , x_msg_count => x_msg_count
3057: , x_msg_data => x_msg_data
3058: , p_line_util_rec => l_line_util_rec
3059: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3060: , x_object_version => l_object_version
3061: , px_upd_line_util_tbl => l_upd_fund_util_tbl
3062: );
3063: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 3158: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

3154: ,x_msg_count OUT NOCOPY NUMBER
3155: ,x_msg_data OUT NOCOPY VARCHAR2
3156:
3157: ,p_line_util_rec IN line_util_rec_type
3158: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3159: ,x_object_version OUT NOCOPY NUMBER
3160: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939
3161: )
3162: IS

Line 3271: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

3267: CLOSE csr_claim_date;
3268:
3269:
3270: ---------------------- check claim access ------------------------
3271: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3272: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3273: P_Api_Version_Number => 1.0
3274: , P_Init_Msg_List => FND_API.G_FALSE
3275: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3272: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3268:
3269:
3270: ---------------------- check claim access ------------------------
3271: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3272: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3273: P_Api_Version_Number => 1.0
3274: , P_Init_Msg_List => FND_API.G_FALSE
3275: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3276: , P_Commit => FND_API.G_FALSE

Line 3503: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

3499: ,x_msg_data OUT NOCOPY VARCHAR2
3500:
3501: ,p_funds_util_flt IN funds_util_flt_type
3502: ,p_currency_rec IN currency_rec_type
3503: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3504: )
3505: IS
3506: l_api_version CONSTANT NUMBER := 1.0;
3507: l_api_name CONSTANT VARCHAR2(30) := 'Delete_All_Line_Util';

Line 3612: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3608: ,x_msg_data => x_msg_data
3609: ,x_msg_count => x_msg_count
3610: ,p_line_util_id => l_lu_line_util_id
3611: ,p_object_version => l_object_version_number
3612: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3613: ,px_upd_line_util_tbl => l_upd_fund_util_tbl --ninarasi fix for bug 13530939
3614: );
3615:
3616: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT THEN --ninarasi fix for bug 13530939

Line 3720: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

3716: ,x_msg_data OUT NOCOPY VARCHAR2
3717: ,x_msg_count OUT NOCOPY NUMBER
3718:
3719: ,p_line_util_tbl IN line_util_tbl_type
3720: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3721:
3722: ,x_error_index OUT NOCOPY NUMBER
3723: ) IS
3724: l_api_version CONSTANT NUMBER := 1.0;

Line 3773: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN

3769:
3770: x_return_status := FND_API.g_ret_sts_success;
3771:
3772: ---------------------- check claim access ------------------------
3773: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
3774: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
3775: IF p_line_util_tbl.EXISTS(j) THEN
3776:
3777: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 3781: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3777: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
3778: FETCH csr_claim_id INTO l_claim_id;
3779: CLOSE csr_claim_id;
3780:
3781: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3782: P_Api_Version_Number => 1.0
3783: , P_Init_Msg_List => FND_API.G_FALSE
3784: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3785: , P_Commit => FND_API.G_FALSE

Line 3823: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3819: , x_msg_count => x_msg_count
3820: , x_msg_data => x_msg_data
3821: , p_line_util_id => l_line_util_id
3822: , p_object_version => l_object_version
3823: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3824: , px_upd_line_util_tbl => l_upd_fund_util_tbl --ninarasi fix for bug 13530939
3825: );
3826:
3827: IF l_upd_fund_util_tbl.COUNT = G_BULK_LIMIT OR i = p_line_util_tbl.LAST THEN --ninarasi fix for bug 13530939

Line 3935: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

3931: ,x_msg_data OUT NOCOPY VARCHAR2
3932:
3933: ,p_line_util_id IN NUMBER
3934: ,p_object_version IN NUMBER
3935: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3936: ,px_upd_line_util_tbl IN OUT NOCOPY upd_fund_util_tbl_type --ninarasi fix for bug 13530939
3937: )
3938: IS
3939: l_api_version CONSTANT NUMBER := 1.0;

Line 4023: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

4019: FETCH csr_claim_id INTO l_claim_id;
4020: CLOSE csr_claim_id;
4021:
4022: ---------------------- check claim access ------------------------
4023: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
4024: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
4025: P_Api_Version_Number => 1.0
4026: , P_Init_Msg_List => FND_API.G_FALSE
4027: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 4024: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

4020: CLOSE csr_claim_id;
4021:
4022: ---------------------- check claim access ------------------------
4023: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
4024: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
4025: P_Api_Version_Number => 1.0
4026: , P_Init_Msg_List => FND_API.G_FALSE
4027: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
4028: , P_Commit => FND_API.G_FALSE

Line 4793: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,

4789: X_Msg_Count => x_msg_count,
4790: X_Msg_Data => x_msg_data,
4791: P_claim => l_claim_Rec,
4792: p_event => 'UPDATE',
4793: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
4794: X_Object_Version_Number => l_object_version_number
4795: );
4796: IF l_return_status = FND_API.g_ret_sts_error THEN
4797: RAISE FND_API.g_exc_error;

Line 6767: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

6763: ,x_msg_count => x_msg_count
6764: ,x_msg_data => x_msg_data
6765: ,p_summary_view => null
6766: ,p_funds_util_flt => l_funds_util_flt
6767: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
6768: );
6769: IF l_return_status = fnd_api.g_ret_sts_error THEN
6770: RAISE FND_API.g_exc_error;
6771: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 9575: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

9571: ,x_msg_data OUT NOCOPY VARCHAR2
9572:
9573: ,p_summary_view IN VARCHAR2 := NULL
9574: ,p_funds_util_flt IN funds_util_flt_type
9575: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
9576: )
9577: IS
9578: l_api_version CONSTANT NUMBER := 1.0;
9579: l_api_name CONSTANT VARCHAR2(30) := 'Update_Group_Line_Util';

Line 10362: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

10358: ,x_msg_count OUT NOCOPY NUMBER
10359: ,x_msg_data OUT NOCOPY VARCHAR2
10360:
10361: ,p_funds_util_flt IN funds_util_flt_type
10362: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
10363: )
10364: IS
10365: l_api_version CONSTANT NUMBER := 1.0;
10366: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Group_Line_Util';

Line 10906: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

10902: ,x_msg_count OUT NOCOPY NUMBER
10903: ,x_msg_data OUT NOCOPY VARCHAR2
10904:
10905: ,p_claim_line_util_id IN NUMBER
10906: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
10907: )
10908: IS
10909: l_api_version CONSTANT NUMBER := 1.0;
10910: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dummy_Utilizations';

Line 11149: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode

11145: ,x_msg_count OUT NOCOPY NUMBER
11146: ,x_msg_data OUT NOCOPY VARCHAR2
11147:
11148: ,p_claim_id IN NUMBER
11149: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
11150:
11151: ,x_next_status OUT NOCOPY VARCHAR2
11152: )
11153: IS

Line 12741: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

12737: ,x_msg_count => x_msg_count
12738: ,x_msg_data => x_msg_data
12739: ,p_summary_view => 'ACTIVITY'
12740: ,p_funds_util_flt => l_funds_util_flt
12741: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
12742: );
12743:
12744: IF l_return_status = FND_API.g_ret_sts_error THEN
12745: RAISE FND_API.g_exc_error;