DBA Data[Home] [Help]

APPS.OZF_CLAIM_ACCRUAL_PVT dependencies on OZF_CLAIM_UTILITY_PVT

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

1887: ,x_msg_data OUT NOCOPY VARCHAR2
1888: ,x_msg_count OUT NOCOPY NUMBER
1889:
1890: ,p_line_util_tbl IN line_util_tbl_type
1891: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
1892: ,x_error_index OUT NOCOPY NUMBER
1893: ) IS
1894: l_api_version CONSTANT NUMBER := 1.0;
1895: l_api_name CONSTANT VARCHAR2(30) := 'Create_Line_Util_Tbl';

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

1966:
1967: x_return_status := FND_API.g_ret_sts_success;
1968:
1969: ---------------------- check claim access ------------------------
1970: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
1971: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
1972: IF p_line_util_tbl.EXISTS(j) THEN
1973:
1974: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 1978: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

1974: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
1975: FETCH csr_claim_id INTO l_claim_id;
1976: CLOSE csr_claim_id;
1977:
1978: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
1979: P_Api_Version_Number => 1.0
1980: , P_Init_Msg_List => FND_API.G_FALSE
1981: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1982: , P_Commit => FND_API.G_FALSE

Line 2037: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2033: , x_return_status => l_return_status
2034: , x_msg_count => x_msg_count
2035: , x_msg_data => x_msg_data
2036: , p_line_util_rec => l_line_util_rec
2037: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2038: , x_line_util_id => l_line_util_id
2039: );
2040:
2041: -- Bug fix 7463302

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

2178: ,x_msg_count OUT NOCOPY NUMBER
2179: ,x_msg_data OUT NOCOPY VARCHAR2
2180:
2181: ,p_line_util_rec IN line_util_rec_type
2182: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2183: ,x_line_util_id OUT NOCOPY NUMBER
2184: )
2185: IS
2186: l_api_version CONSTANT NUMBER := 1.0;

Line 2288: IF l_line_util_rec.update_from_tbl_flag = FND_API.g_false AND p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

2284: FETCH csr_claim_id INTO l_claim_id, l_line_acctd_amount;
2285: CLOSE csr_claim_id;
2286:
2287: ---------------------- check claim access ------------------------
2288: IF l_line_util_rec.update_from_tbl_flag = FND_API.g_false AND p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2289: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2290: P_Api_Version_Number => 1.0
2291: , P_Init_Msg_List => FND_API.G_FALSE
2292: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2289: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2285: CLOSE csr_claim_id;
2286:
2287: ---------------------- check claim access ------------------------
2288: IF l_line_util_rec.update_from_tbl_flag = FND_API.g_false AND p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2289: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2290: P_Api_Version_Number => 1.0
2291: , P_Init_Msg_List => FND_API.G_FALSE
2292: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2293: , P_Commit => FND_API.G_FALSE

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

2629: ,x_msg_data OUT NOCOPY VARCHAR2
2630: ,x_msg_count OUT NOCOPY NUMBER
2631:
2632: ,p_line_util_tbl IN line_util_tbl_type
2633: ,p_mode IN VARCHAr2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2634:
2635: ,x_error_index OUT NOCOPY NUMBER
2636: ) IS
2637: l_api_version CONSTANT NUMBER := 1.0;

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

2683:
2684: x_return_status := FND_API.g_ret_sts_success;
2685:
2686: ---------------------- check claim access ------------------------
2687: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
2688: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
2689: IF p_line_util_tbl.EXISTS(j) THEN
2690:
2691: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 2695: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2691: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
2692: FETCH csr_claim_id INTO l_claim_id;
2693: CLOSE csr_claim_id;
2694:
2695: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2696: P_Api_Version_Number => 1.0
2697: , P_Init_Msg_List => FND_API.G_FALSE
2698: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2699: , P_Commit => FND_API.G_FALSE

Line 2743: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

2739: , x_return_status => l_return_status
2740: , x_msg_count => x_msg_count
2741: , x_msg_data => x_msg_data
2742: , p_line_util_rec => l_line_util_rec
2743: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
2744: , x_object_version => l_object_version
2745: );
2746: IF l_return_status = fnd_api.g_ret_sts_error THEN
2747: x_error_index := i;

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

2825: ,x_msg_count OUT NOCOPY NUMBER
2826: ,x_msg_data OUT NOCOPY VARCHAR2
2827:
2828: ,p_line_util_rec IN line_util_rec_type
2829: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
2830: ,x_object_version OUT NOCOPY NUMBER
2831: )
2832: IS
2833: l_api_version CONSTANT NUMBER := 1.0;

Line 2937: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

2933: CLOSE csr_claim_date;
2934:
2935:
2936: ---------------------- check claim access ------------------------
2937: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2938: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2939: P_Api_Version_Number => 1.0
2940: , P_Init_Msg_List => FND_API.G_FALSE
2941: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 2938: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

2934:
2935:
2936: ---------------------- check claim access ------------------------
2937: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
2938: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
2939: P_Api_Version_Number => 1.0
2940: , P_Init_Msg_List => FND_API.G_FALSE
2941: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
2942: , P_Commit => FND_API.G_FALSE

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

3165: ,x_msg_count OUT NOCOPY NUMBER
3166: ,x_msg_data OUT NOCOPY VARCHAR2
3167:
3168: ,p_funds_util_flt IN funds_util_flt_type
3169: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3170: )
3171: IS
3172: l_api_version CONSTANT NUMBER := 1.0;
3173: l_api_name CONSTANT VARCHAR2(30) := 'Delete_All_Line_Util';

Line 3289: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3285: ,x_msg_data => x_msg_data
3286: ,x_msg_count => x_msg_count
3287: ,p_line_util_id => l_lu_line_util_id
3288: ,p_object_version => l_object_version_number
3289: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3290: );
3291: IF l_return_status = fnd_api.g_ret_sts_error THEN
3292: RAISE FND_API.g_exc_error;
3293: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

3364: ,x_msg_data OUT NOCOPY VARCHAR2
3365: ,x_msg_count OUT NOCOPY NUMBER
3366:
3367: ,p_line_util_tbl IN line_util_tbl_type
3368: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3369:
3370: ,x_error_index OUT NOCOPY NUMBER
3371: ) IS
3372: l_api_version CONSTANT NUMBER := 1.0;

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

3424:
3425: x_return_status := FND_API.g_ret_sts_success;
3426:
3427: ---------------------- check claim access ------------------------
3428: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode AND p_line_util_tbl.count > 0 THEN
3429: FOR j IN p_line_util_tbl.FIRST..p_line_util_tbl.LAST LOOP
3430: IF p_line_util_tbl.EXISTS(j) THEN
3431:
3432: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);

Line 3436: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3432: OPEN csr_claim_id(p_line_util_tbl(j).claim_line_id);
3433: FETCH csr_claim_id INTO l_claim_id;
3434: CLOSE csr_claim_id;
3435:
3436: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3437: P_Api_Version_Number => 1.0
3438: , P_Init_Msg_List => FND_API.G_FALSE
3439: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3440: , P_Commit => FND_API.G_FALSE

Line 3483: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

3479: , x_msg_count => x_msg_count
3480: , x_msg_data => x_msg_data
3481: , p_line_util_id => l_line_util_id
3482: , p_object_version => l_object_version
3483: , p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
3484: );
3485: IF l_return_status = fnd_api.g_ret_sts_error THEN
3486: x_error_index := i;
3487: RAISE FND_API.g_exc_error;

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

3576: ,x_msg_data OUT NOCOPY VARCHAR2
3577:
3578: ,p_line_util_id IN NUMBER
3579: ,p_object_version IN NUMBER
3580: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
3581: )
3582: IS
3583: l_api_version CONSTANT NUMBER := 1.0;
3584: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Line_Util';

Line 3657: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN

3653: FETCH csr_claim_id INTO l_claim_id;
3654: CLOSE csr_claim_id;
3655:
3656: ---------------------- check claim access ------------------------
3657: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3658: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3659: P_Api_Version_Number => 1.0
3660: , P_Init_Msg_List => FND_API.G_FALSE
3661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 3658: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(

3654: CLOSE csr_claim_id;
3655:
3656: ---------------------- check claim access ------------------------
3657: IF p_mode = OZF_CLAIM_UTILITY_PVT.g_manu_mode THEN
3658: OZF_CLAIM_UTILITY_PVT.Check_Claim_access(
3659: P_Api_Version_Number => 1.0
3660: , P_Init_Msg_List => FND_API.G_FALSE
3661: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
3662: , P_Commit => FND_API.G_FALSE

Line 4413: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,

4409: X_Msg_Count => x_msg_count,
4410: X_Msg_Data => x_msg_data,
4411: P_claim => l_claim_Rec,
4412: p_event => 'UPDATE',
4413: p_mode => OZF_claim_Utility_pvt.G_AUTO_MODE,
4414: X_Object_Version_Number => l_object_version_number
4415: );
4416: IF l_return_status = FND_API.g_ret_sts_error THEN
4417: RAISE FND_API.g_exc_error;

Line 5672: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

5668: ,x_msg_count => x_msg_count
5669: ,x_msg_data => x_msg_data
5670: ,p_summary_view => null
5671: ,p_funds_util_flt => l_funds_util_flt
5672: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
5673: );
5674: IF l_return_status = fnd_api.g_ret_sts_error THEN
5675: RAISE FND_API.g_exc_error;
5676: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

6523: ,x_msg_count OUT NOCOPY NUMBER
6524: ,x_msg_data OUT NOCOPY VARCHAR2
6525:
6526: ,p_fund_util_flt IN funds_util_flt_type
6527: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
6528: )
6529: IS
6530: l_api_version CONSTANT NUMBER := 1.0;
6531: l_api_name CONSTANT VARCHAR2(30) := 'Create_Group_Line_Util';

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

6635: ,x_msg_data OUT NOCOPY VARCHAR2
6636:
6637: ,p_summary_view IN VARCHAR2 := NULL
6638: ,p_funds_util_flt IN funds_util_flt_type
6639: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
6640: )
6641: IS
6642: l_api_version CONSTANT NUMBER := 1.0;
6643: l_api_name CONSTANT VARCHAR2(30) := 'Update_Group_Line_Util';

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

8020: ,x_msg_count OUT NOCOPY NUMBER
8021: ,x_msg_data OUT NOCOPY VARCHAR2
8022:
8023: ,p_funds_util_flt IN funds_util_flt_type
8024: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
8025: )
8026: IS
8027: l_api_version CONSTANT NUMBER := 1.0;
8028: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Group_Line_Util';

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

8512: ,x_msg_count OUT NOCOPY NUMBER
8513: ,x_msg_data OUT NOCOPY VARCHAR2
8514:
8515: ,p_claim_line_util_id IN NUMBER
8516: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
8517: )
8518: IS
8519: l_api_version CONSTANT NUMBER := 1.0;
8520: l_api_name CONSTANT VARCHAR2(30) := 'Update_Dummy_Utilizations';

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

8752: ,x_msg_count OUT NOCOPY NUMBER
8753: ,x_msg_data OUT NOCOPY VARCHAR2
8754:
8755: ,p_claim_id IN NUMBER
8756: ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
8757:
8758: ,x_next_status OUT NOCOPY VARCHAR2
8759: )
8760: IS

Line 10334: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode

10330: ,x_msg_count => x_msg_count
10331: ,x_msg_data => x_msg_data
10332: ,p_summary_view => 'ACTIVITY'
10333: ,p_funds_util_flt => l_funds_util_flt
10334: ,p_mode => OZF_CLAIM_UTILITY_PVT.g_auto_mode
10335: );
10336:
10337: IF l_return_status = FND_API.g_ret_sts_error THEN
10338: RAISE FND_API.g_exc_error;