DBA Data[Home] [Help]

APPS.PA_STRUCT_TASK_ROLLUP_PUB dependencies on PA_NUM_TBL_TYPE

Line 38: ,p_element_versions IN SYSTEM.PA_NUM_TBL_TYPE

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

Line 61: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

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

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

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(
870: p_api_version IN NUMBER := 1.0

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

882: ,x_msg_data OUT NOCOPY VARCHAR2
883: )
884: IS
885:
886: l_element_versions SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
887: l_debug_mode VARCHAR2(1);
888:
889: BEGIN
890:

Line 1125: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

1121: l_sch_finish_date_tbl t_schDate_Tbl;
1122: l_effort_tbl t_proj_id_table;
1123: l_elem_ver_id_tbl t_proj_id_table;
1124:
1125: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
1126: /* Bug #: 3305199 SMukka */
1127: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1128: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1129: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */

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

1123: l_elem_ver_id_tbl t_proj_id_table;
1124:
1125: l_res_asgmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
1126: /* Bug #: 3305199 SMukka */
1127: /* Changing data type from PA_PLSQL_DATATYPES.IdTabTyp to SYSTEM.pa_num_tbl_type */
1128: /*l_planning_start_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1129: /*l_planning_end_tbl PA_PLSQL_DATATYPES.NumTabTyp; */
1130: l_planning_start_tbl SYSTEM.pa_date_tbl_type;
1131: l_planning_end_tbl SYSTEM.pa_date_tbl_type;

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:

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

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:
2573: --select all the projects belonging to the same program group as p_project_id.