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 37: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM

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

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

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

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

873: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
874: ,p_validation_level IN VARCHAR2 := 100
875: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
876: ,p_debug_mode IN VARCHAR2 := 'N'
877: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_element_versions IN PA_NUM_1000_NUM
879: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
880: ,x_return_status OUT NOCOPY VARCHAR2
881: ,x_msg_count OUT NOCOPY NUMBER

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

875: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
876: ,p_debug_mode IN VARCHAR2 := 'N'
877: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
878: ,p_element_versions IN PA_NUM_1000_NUM
879: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM --bug5861729
880: ,x_return_status OUT NOCOPY VARCHAR2
881: ,x_msg_count OUT NOCOPY NUMBER
882: ,x_msg_data OUT NOCOPY VARCHAR2
883: )

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

940: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
941: -- p_validation_level IN VARCHAR2 := 100
942: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
943: -- p_debug_mode IN VARCHAR2 := 'N'
944: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
945: -- p_element_versions IN pa_element_version_id_tbl_typ
946: -- x_return_status OUT VARCHAR2
947: -- x_msg_count OUT NUMBER
948: -- x_msg_data OUT VARCHAR2

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

961: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
962: ,p_validation_level IN VARCHAR2 := 100
963: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
964: ,p_debug_mode IN VARCHAR2 := 'N'
965: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
966: ,p_element_versions IN pa_element_version_id_tbl_typ
967: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
968: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
969: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

1083: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1084: -- p_validation_level IN VARCHAR2 := 100
1085: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1086: -- p_debug_mode IN VARCHAR2 := 'N'
1087: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1088: -- p_element_versions IN PA_NUM_1000_NUM
1089: -- x_return_status OUT VARCHAR2
1090: -- x_msg_count OUT NUMBER
1091: -- x_msg_data OUT VARCHAR2

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

1098: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
1099: ,p_validation_level IN VARCHAR2 := 100
1100: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
1101: ,p_debug_mode IN VARCHAR2 := 'N'
1102: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1103: ,p_element_versions IN PA_NUM_1000_NUM
1104: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1105: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1106: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2165: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2166: ,p_validation_level IN VARCHAR2 := 100
2167: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2168: ,p_debug_mode IN VARCHAR2 := 'N'
2169: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2170: ,p_structure_version_id IN NUMBER
2171: ,p_element_version_id IN NUMBER := NULL
2172: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2173: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

2420: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2421: ,p_validation_level IN VARCHAR2 := 100
2422: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2423: ,p_debug_mode IN VARCHAR2 := 'N'
2424: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2425: ,p_structure_version_id IN NUMBER
2426: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2427: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2428: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2523: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2524: -- p_validation_level IN VARCHAR2 := 100
2525: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2526: -- p_debug_mode IN VARCHAR2 := 'N'
2527: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2528: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2529: -- x_return_status OUT VARCHAR2
2530: -- x_msg_count OUT NUMBER
2531: -- x_msg_data OUT VARCHAR2

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

2524: -- p_validation_level IN VARCHAR2 := 100
2525: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2526: -- p_debug_mode IN VARCHAR2 := 'N'
2527: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2528: -- p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2529: -- x_return_status OUT VARCHAR2
2530: -- x_msg_count OUT NUMBER
2531: -- x_msg_data OUT VARCHAR2
2532: --

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

2547: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
2548: ,p_validation_level IN VARCHAR2 := 100
2549: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2550: ,p_debug_mode IN VARCHAR2 := 'N'
2551: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2552: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2553: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2554: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2555: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2548: ,p_validation_level IN VARCHAR2 := 100
2549: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2550: ,p_debug_mode IN VARCHAR2 := 'N'
2551: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2552: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2553: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2554: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2555: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2556: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

2549: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
2550: ,p_debug_mode IN VARCHAR2 := 'N'
2551: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2552: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2553: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2554: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2555: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2556: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2557: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

2550: ,p_debug_mode IN VARCHAR2 := 'N'
2551: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2552: ,p_project_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2553: ,p_structure_version_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2554: ,p_published_str_ver_id IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2555: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2556: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2557: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2558: ) IS

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

2626: IF (p_commit = FND_API.G_TRUE) THEN
2627: savepoint Program_Schedule_dates_rollup;
2628: END IF;
2629:
2630: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2631: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2632: THEN
2633: IF l_debug_mode = 'Y' THEN
2634: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);

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

2627: savepoint Program_Schedule_dates_rollup;
2628: END IF;
2629:
2630: IF (p_structure_version_id IS NULL OR p_structure_version_id = PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2631: AND (p_project_id IS NOT NULL AND p_project_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM )
2632: THEN
2633: IF l_debug_mode = 'Y' THEN
2634: pa_debug.write('PA_STRUCT_TASK_ROLLUP_PUB.PROGRAM_SCHEDUlE_DATES_ROLLUP', 'Before Opening cursor cur_select_grid', 3);
2635: END IF;

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

2637: FOR cur_select_grid_rec IN cur_select_grid LOOP
2638:
2639: --when rollinup to a working verison which is being published, first rollup to the published version then continue with the working
2640: --verison and up in the hierarchy.
2641: IF p_published_str_ver_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM AND p_published_str_ver_id IS NOT NULL
2642: AND p_project_id= cur_select_grid_rec.project_id
2643: THEN
2644:
2645: IF l_debug_mode = 'Y' THEN

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

2701: RAISE FND_API.G_EXC_ERROR;
2702: END IF;
2703: END IF;
2704: END LOOP;
2705: ELSIF (p_structure_version_id IS NOT NULL AND p_structure_version_id <> PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM ) --bug5861729
2706: THEN
2707:
2708: OPEN cur_top_task(p_structure_version_id);
2709: FETCH cur_top_task BULK COLLECT INTO l_tasks_ver_ids;