DBA Data[Home] [Help]

APPS.PA_PROJ_TASK_STRUC_PUB dependencies on PA_PROJECT_PUB

Line 495: -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created

491: -- History
492: --
493: -- 25-MAY-02 MAansari -Created
494: --
495: -- Notes: This api is called from PA_PROJECT_PUB.CREATE_PROJECT to clean up the tasks in pa_proj_elements that were created
496: -- by calling copy structure api. Copy structure api copies template's tasks to pro_elements though there
497: -- are no pa_TASKs for the new project. However pa_tasks and pa_proj_elements must be in syn. To d this we need to firts remove
498: -- tasks from pa_proj_elements as they were erroneously created by COPY_STRUCTURE and then call create_default_structure
499: -- to syn up pa_pro_elements with pa_tasks.

Line 524: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

520: -- is checked
521:
522: /*PROCEDURE get_task_above(
523: p_task_id IN NUMBER
524: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
525: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
526: ,x_task_id_above OUT NUMBER
527: ,x_return_status OUT VARCHAR2
528: );*/

Line 525: ,p_tasks_out IN pa_project_pub.task_out_tbl_type

521:
522: /*PROCEDURE get_task_above(
523: p_task_id IN NUMBER
524: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
525: ,p_tasks_out IN pa_project_pub.task_out_tbl_type
526: ,x_task_id_above OUT NUMBER
527: ,x_return_status OUT VARCHAR2
528: );*/
529:

Line 892: ,p_tasks_in IN pa_project_pub.task_in_tbl_type

888: ,p_structure_type IN VARCHAR2 := 'FINANCIAL'
889: ,p_project_id IN NUMBER
890: ,p_structure_version_id IN NUMBER
891: ,p_pm_product_code IN VARCHAR2 := 'JUNK_CHARS'
892: ,p_tasks_in IN pa_project_pub.task_in_tbl_type
893: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
894: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
895: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895
896:

Line 901: p_tasks_in IN pa_project_pub.task_out_tbl_type

897:
898: --FUNCTION check_multiple_version
899:
900: PROCEDURE recalc_task_weightings(
901: p_tasks_in IN pa_project_pub.task_out_tbl_type
902: ,p_task_version_id IN NUMBER
903: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
904: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
905: ,x_return_status OUT NOCOPY VARCHAR2 ); --File.Sql.39 bug 4440895

Line 981: p_tasks_in IN pa_project_pub.task_out_tbl_type

977: ,x_task_version_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
978: );
979:
980: PROCEDURE rollup_dates(
981: p_tasks_in IN pa_project_pub.task_out_tbl_type
982: ,p_task_version_id IN NUMBER := null
983: ,p_structure_version_id IN NUMBER
984: ,p_project_id IN NUMBER
985: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1001: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type

997: --This will be passed only from create_project context.
998: ,p_source_project_id IN pa_projects_all.project_id%TYPE := NULL
999: ,p_pm_product_code IN pa_projects_all.pm_product_code%TYPE
1000: ,p_structure_type IN pa_structure_types.structure_type_class_code%TYPE
1001: ,p_tasks_in_tbl IN pa_project_pub.task_in_tbl_type
1002: ,p_create_task_version_only IN VARCHAR2 := 'N'
1003: ,p_wp_str_exists IN VARCHAR2
1004: ,p_is_wp_separate_from_fn IN VARCHAR2
1005: ,p_is_wp_versioning_enabled IN VARCHAR2

Line 1012: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type

1008: -- PA L Changes 3010538
1009: ,p_process_mode IN VARCHAR2 := 'ONLINE'
1010: -- Bug 3075609. To identify create task version only context.
1011: ,p_create_task_versions_only IN VARCHAR2 := 'N'
1012: ,px_tasks_out_tbl IN OUT NOCOPY pa_project_pub.task_out_tbl_type
1013: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1014: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1015: ,x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
1016: