eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_INTERFACE_UTILS_PUB

Line 16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

12: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
13: -- p_validation_level IN VARCHAR2 := 100
14: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
15: -- p_debug_mode IN VARCHAR2 := 'N'
16: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
17: -- p_element_versions IN PA_NUM_1000_NUM
18: -- x_return_status OUT VARCHAR2
19: -- x_msg_count OUT NUMBER
20: -- x_msg_data OUT VARCHAR2

Line 39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

35: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
36: ,p_validation_level IN VARCHAR2 := 100
37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: ,p_element_versions IN SYSTEM.PA_NUM_TBL_TYPE
41: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 41: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729

37: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
38: ,p_debug_mode IN VARCHAR2 := 'N'
39: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
40: ,p_element_versions IN SYSTEM.PA_NUM_TBL_TYPE
41: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
42: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
43: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
44: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: )

Line 924: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

920: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
921: ,p_validation_level IN VARCHAR2 := 100
922: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
923: ,p_debug_mode IN VARCHAR2 := 'N'
924: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
925: ,p_element_versions IN PA_NUM_1000_NUM
926: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
927: ,x_return_status OUT NOCOPY VARCHAR2
928: ,x_msg_count OUT NOCOPY NUMBER

Line 926: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729

922: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
923: ,p_debug_mode IN VARCHAR2 := 'N'
924: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
925: ,p_element_versions IN PA_NUM_1000_NUM
926: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
927: ,x_return_status OUT NOCOPY VARCHAR2
928: ,x_msg_count OUT NOCOPY NUMBER
929: ,x_msg_data OUT NOCOPY VARCHAR2
930: )

Line 991: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

987: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
988: -- p_validation_level IN VARCHAR2 := 100
989: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
990: -- p_debug_mode IN VARCHAR2 := 'N'
991: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
992: -- p_element_versions IN pa_element_version_id_tbl_typ
993: -- x_return_status OUT VARCHAR2
994: -- x_msg_count OUT NUMBER
995: -- x_msg_data OUT VARCHAR2

Line 1012: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1008: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1009: ,p_validation_level IN VARCHAR2 := 100
1010: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1011: ,p_debug_mode IN VARCHAR2 := 'N'
1012: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1013: ,p_element_versions IN pa_element_version_id_tbl_typ
1014: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1015: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1016: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1134: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1130: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1131: -- p_validation_level IN VARCHAR2 := 100
1132: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1133: -- p_debug_mode IN VARCHAR2 := 'N'
1134: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1135: -- p_element_versions IN PA_NUM_1000_NUM
1136: -- x_return_status OUT VARCHAR2
1137: -- x_msg_count OUT NUMBER
1138: -- x_msg_data OUT VARCHAR2

Line 1149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

1145: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1146: ,p_validation_level IN VARCHAR2 := 100
1147: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1148: ,p_debug_mode IN VARCHAR2 := 'N'
1149: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1150: ,p_element_versions IN PA_NUM_1000_NUM
1151: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1152: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1153: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2257: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2253: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2254: ,p_validation_level IN VARCHAR2 := 100
2255: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2256: ,p_debug_mode IN VARCHAR2 := 'N'
2257: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2258: ,p_structure_version_id IN NUMBER
2259: ,p_element_version_id IN NUMBER := NULL
2260: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2261: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2579: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2575: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2576: ,p_validation_level IN VARCHAR2 := 100
2577: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2578: ,p_debug_mode IN VARCHAR2 := 'N'
2579: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2580: ,p_structure_version_id IN NUMBER
2581: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2582: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2583: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2682: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2678: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2679: -- p_validation_level IN VARCHAR2 := 100
2680: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2681: -- p_debug_mode IN VARCHAR2 := 'N'
2682: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2683: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2684: -- x_return_status OUT VARCHAR2
2685: -- x_msg_count OUT NUMBER
2686: -- x_msg_data OUT VARCHAR2

Line 2683: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2679: -- p_validation_level IN VARCHAR2 := 100
2680: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2681: -- p_debug_mode IN VARCHAR2 := 'N'
2682: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2683: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2684: -- x_return_status OUT VARCHAR2
2685: -- x_msg_count OUT NUMBER
2686: -- x_msg_data OUT VARCHAR2
2687: --

Line 2706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2702: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2703: ,p_validation_level IN VARCHAR2 := 100
2704: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2705: ,p_debug_mode IN VARCHAR2 := 'N'
2706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2707: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2708: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2709: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2710: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2707: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2703: ,p_validation_level IN VARCHAR2 := 100
2704: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2705: ,p_debug_mode IN VARCHAR2 := 'N'
2706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2707: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2708: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2709: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2710: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2711: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2708: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2704: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2705: ,p_debug_mode IN VARCHAR2 := 'N'
2706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2707: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2708: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2709: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2710: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2711: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2712: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2709: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

2705: ,p_debug_mode IN VARCHAR2 := 'N'
2706: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2707: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2708: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2709: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2710: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2711: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2712: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2713: ) IS

Line 2813: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2809: IF (p_commit = FND_API.G_TRUE) THEN
2810: savepoint Program_Schedule_dates_rollup;
2811: END IF;
2812:
2813: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2814: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2815: THEN
2816: IF l_debug_mode = 'Y' THEN
2817: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);

Line 2814: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )

2810: savepoint Program_Schedule_dates_rollup;
2811: END IF;
2812:
2813: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2814: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2815: THEN
2816: IF l_debug_mode = 'Y' THEN
2817: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);
2818: END IF;

Line 2824: IF p_published_str_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_published_str_ver_id IS NOT NULL

2820: FOR cur_select_grid_rec IN cur_select_grid LOOP
2821:
2822: --when rollinup to a working verison which is being published, first rollup to the published version then continue with the working
2823: --verison and up in the hierarchy.
2824: IF p_published_str_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_published_str_ver_id IS NOT NULL
2825: AND p_project_id= cur_select_grid_rec.project_id
2826: THEN
2827:
2828: IF l_debug_mode = 'Y' THEN

Line 2888: ELSIF (p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) --bug5861729

2884: RAISE FND_API.G_EXC_ERROR;
2885: END IF;
2886: END IF;
2887: END LOOP;
2888: ELSIF (p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) --bug5861729
2889: THEN
2890:
2891: OPEN cur_top_task(p_structure_version_id);
2892: FETCH cur_top_task BULK COLLECT INTO l_tasks_ver_ids;