DBA Data[Home] [Help]

APPS.PA_DELIVERABLE_PUB dependencies on PA_NUM_TBL_TYPE

Line 1721: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

1717: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1718: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1719: ,p_debug_mode IN VARCHAR2 :='N'
1720: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1721: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1724: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1725: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

1718: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1719: ,p_debug_mode IN VARCHAR2 :='N'
1720: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1721: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1724: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1725: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1726: ,p_project_id IN pa_projects_all.project_id%TYPE

Line 1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

1719: ,p_debug_mode IN VARCHAR2 :='N'
1720: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1721: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1722: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1723: ,p_rec_ver_number_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1724: ,p_dlv_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1725: ,p_dlv_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1726: ,p_project_id IN pa_projects_all.project_id%TYPE
1727: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1935: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

1931: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
1932: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1933: ,p_debug_mode IN VARCHAR2 :='N'
1934: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1935: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1936: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1937: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1938: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1939: ,p_task_or_dlv_elt_id IN NUMBER

Line 1936: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

1932: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
1933: ,p_debug_mode IN VARCHAR2 :='N'
1934: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
1935: ,p_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1936: ,p_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
1937: ,p_element_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1938: ,p_element_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
1939: ,p_task_or_dlv_elt_id IN NUMBER
1940: ,p_task_or_dlv_ver_id IN NUMBER

Line 2502: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

2498: ,p_debug_mode IN VARCHAR2 :='N'
2499: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2500: ,p_source_project_id IN NUMBER
2501: ,p_target_project_id IN NUMBER
2502: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
2503: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
2504: ,p_item_details_flag IN VARCHAR2 := 'N'
2505: ,p_dlv_actions_flag IN VARCHAR2 := 'N'
2506: ,p_dlv_attachments_flag IN VARCHAR2 := 'N'

Line 2503: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()

2499: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2500: ,p_source_project_id IN NUMBER
2501: ,p_target_project_id IN NUMBER
2502: ,p_dlv_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
2503: ,p_dlv_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE()
2504: ,p_item_details_flag IN VARCHAR2 := 'N'
2505: ,p_dlv_actions_flag IN VARCHAR2 := 'N'
2506: ,p_dlv_attachments_flag IN VARCHAR2 := 'N'
2507: ,p_association_flag IN VARCHAR2 := 'N'

Line 2645: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type

2641: ,p_validation_level IN NUMBER :=FND_API.G_VALID_LEVEL_FULL
2642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2643: ,p_debug_mode IN VARCHAR2 :='N'
2644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2645: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
2646: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type
2647: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2648: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2649: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2646: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type

2642: ,p_calling_module IN VARCHAR2 :='SELF_SERVICE'
2643: ,p_debug_mode IN VARCHAR2 :='N'
2644: ,p_max_msg_count IN NUMBER :=PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
2645: ,p_src_task_versions_tab IN SYSTEM.pa_num_tbl_type
2646: ,p_dest_task_versions_tab IN SYSTEM.pa_num_tbl_type
2647: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2648: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2649: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2650: )

Line 2663: l_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

2659: l_project_id NUMBER ;
2660: l_task_element_id NUMBER ;
2661:
2662:
2663: l_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
2664: l_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
2665: l_element_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
2666: l_element_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
2667:

Line 2664: l_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;

2660: l_task_element_id NUMBER ;
2661:
2662:
2663: l_element_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
2664: l_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE() ;
2665: l_element_name_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
2666: l_element_number_tbl SYSTEM.PA_VARCHAR2_240_TBL_TYPE := SYSTEM.PA_VARCHAR2_240_TBL_TYPE() ;
2667:
2668: -- 3461959 : Task_To_Deliverable association not getting copied