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_NUM_1000_NUM

Line 17: -- p_element_versions IN PA_NUM_1000_NUM

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
21:

Line 865: * This is a wrapper procedure which simply converts the parameter from type PA_NUM_1000_NUM

861: RAISE;
862: END Rollup_From_Subproject_Unltd;
863:
864: /* Bug 6854670
865: * This is a wrapper procedure which simply converts the parameter from type PA_NUM_1000_NUM
866: * to SYSTEM.PA_NUM_TBL_TYPE and delegates the processing to Rollup_From_Subproject_Unltd
867: * This procedure should be there to maintain compatibility with calls from online flow
868: */
869: PROCEDURE Rollup_From_Subproject(

Line 878: ,p_element_versions IN PA_NUM_1000_NUM

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
882: ,x_msg_data OUT NOCOPY VARCHAR2

Line 972: l_element_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

968: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
969: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
970:
971: IS
972: l_element_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
973: l_count number :=0;
974: BEGIN
975:
976: IF (p_debug_mode = 'Y') THEN

Line 1088: -- p_element_versions IN PA_NUM_1000_NUM

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
1092:

Line 1103: ,p_element_versions IN PA_NUM_1000_NUM

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
1107: )

Line 1287: l_parent_task_ver_id_tbl PA_NUM_1000_NUM := PA_NUM_1000_NUM();

1283: WHERE element_version_id = cp_parent_task_ver_id;
1284: parent_task_str_ver_id NUMBER;
1285: parent_task_proj_id NUMBER;
1286: --
1287: l_parent_task_ver_id_tbl PA_NUM_1000_NUM := PA_NUM_1000_NUM();
1288: l_dummy NUMBER;
1289:
1290: l_assgn_context VARCHAR2(30); --bug 4153366
1291: l_debug_mode varchar2(1) := 'N';--added by rtarway, 4218977

Line 2568: -- Bug 6854670 (Changed type from PA_NUM_1000_NUM to SYSTEM.PA_NUM_TBL_TYPE)

2564: AND relationship_type = 'S'
2565: AND object_type_from = 'PA_STRUCTURES'
2566: AND object_type_to = 'PA_TASKS'
2567: ;
2568: -- Bug 6854670 (Changed type from PA_NUM_1000_NUM to SYSTEM.PA_NUM_TBL_TYPE)
2569: l_tasks_ver_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2570: l_top_task_version_id NUMBER;
2571: l_debug_mode VARCHAR2(1);
2572: