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_TBL_TYPE

Line 40: ,p_element_versions IN SYSTEM.PA_NUM_TBL_TYPE

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
44: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 63: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

59: l_sch_finish_date_tbl t_schDate_Tbl;
60: l_effort_tbl t_proj_id_table;
61: l_elem_ver_id_tbl t_proj_id_table;
62: --
63: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
64: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
65: l_planning_end_tbl SYSTEM.pa_date_tbl_type;
66: --
67: TYPE DYNAMIC_CUR IS REF CURSOR;

Line 913: * to SYSTEM.PA_NUM_TBL_TYPE and delegates the processing to Rollup_From_Subproject_Unltd

909: END Rollup_From_Subproject_Unltd;
910:
911: /* Bug 6854670
912: * This is a wrapper procedure which simply converts the parameter from type PA_NUM_1000_NUM
913: * to SYSTEM.PA_NUM_TBL_TYPE and delegates the processing to Rollup_From_Subproject_Unltd
914: * This procedure should be there to maintain compatibility with calls from online flow
915: */
916: PROCEDURE Rollup_From_Subproject(
917: p_api_version IN NUMBER := 1.0

Line 933: l_element_versions SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

929: ,x_msg_data OUT NOCOPY VARCHAR2
930: )
931: IS
932:
933: l_element_versions SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
934: l_debug_mode VARCHAR2(1);
935:
936: BEGIN
937:

Line 1172: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

1168: l_sch_finish_date_tbl t_schDate_Tbl;
1169: l_effort_tbl t_proj_id_table;
1170: l_elem_ver_id_tbl t_proj_id_table;
1171:
1172: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
1173: /* Bug #: 3305199 SMukka */
1174: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1175: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1176: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */

Line 1174: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */

1170: l_elem_ver_id_tbl t_proj_id_table;
1171:
1172: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
1173: /* Bug #: 3305199 SMukka */
1174: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1175: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1176: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1177: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1178: l_planning_end_tbl SYSTEM.pa_date_tbl_type;

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

2719: AND relationship_type = 'S'
2720: AND object_type_from = 'PA_STRUCTURES'
2721: AND object_type_to = 'PA_TASKS'
2722: ;
2723: -- Bug 6854670 (Changed type from PA_NUM_1000_NUM to SYSTEM.PA_NUM_TBL_TYPE)
2724: l_tasks_ver_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2725: l_top_task_version_id NUMBER;
2726: l_debug_mode VARCHAR2(1);
2727:

Line 2724: l_tasks_ver_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();

2720: AND object_type_from = 'PA_STRUCTURES'
2721: AND object_type_to = 'PA_TASKS'
2722: ;
2723: -- Bug 6854670 (Changed type from PA_NUM_1000_NUM to SYSTEM.PA_NUM_TBL_TYPE)
2724: l_tasks_ver_ids SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
2725: l_top_task_version_id NUMBER;
2726: l_debug_mode VARCHAR2(1);
2727:
2728: --select all the projects belonging to the same program group as p_project_id.