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 912: * This is a wrapper procedure which simply converts the parameter from type PA_NUM_1000_NUM

908: RAISE;
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(

Line 925: ,p_element_versions IN PA_NUM_1000_NUM

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

Line 1019: l_element_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();

1015: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1016: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1017:
1018: IS
1019: l_element_ver_ids PA_NUM_1000_NUM := PA_NUM_1000_NUM();
1020: l_count number :=0;
1021: BEGIN
1022:
1023: IF (p_debug_mode = 'Y') THEN

Line 1135: -- p_element_versions IN PA_NUM_1000_NUM

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

Line 1150: ,p_element_versions IN PA_NUM_1000_NUM

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

Line 1334: l_parent_task_ver_id_tbl PA_NUM_1000_NUM := PA_NUM_1000_NUM();

1330: WHERE element_version_id = cp_parent_task_ver_id;
1331: parent_task_str_ver_id NUMBER;
1332: parent_task_proj_id NUMBER;
1333: --
1334: l_parent_task_ver_id_tbl PA_NUM_1000_NUM := PA_NUM_1000_NUM();
1335: l_dummy NUMBER;
1336:
1337: l_assgn_context VARCHAR2(30); --bug 4153366
1338: l_debug_mode varchar2(1) := 'N';--added by rtarway, 4218977

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: