DBA Data[Home] [Help]

APPS.PA_STATUS_PUB dependencies on PA_NUM_TBL_TYPE

Line 536: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

532: ,p_progress_mode IN VARCHAR2 :='FUTURE'
533: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
535: ,p_project_id IN NUMBER
536: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
537: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
538: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
540: ,p_structure_version_id IN NUMBER

Line 537: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

533: ,p_pm_product_code IN VARCHAR2 := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
534: ,p_structure_type IN VARCHAR2 := 'WORKPLAN'
535: ,p_project_id IN NUMBER
536: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
537: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
538: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
540: ,p_structure_version_id IN NUMBER
541: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()

Line 539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

535: ,p_project_id IN NUMBER
536: ,p_object_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
537: ,p_object_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
538: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
540: ,p_structure_version_id IN NUMBER
541: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
542: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
543: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 542: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

538: ,p_object_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
540: ,p_structure_version_id IN NUMBER
541: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
542: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
543: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
544: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
545: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

Line 543: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

539: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
540: ,p_structure_version_id IN NUMBER
541: ,p_as_of_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
542: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
543: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
544: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
545: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

543: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
544: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
545: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
548: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
549: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
550: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
551: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()

Line 548: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

544: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type := SYSTEM.pa_varchar2_1_tbl_type()
545: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
548: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
549: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
550: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
551: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
552: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()

Line 549: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

545: ,p_resource_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
548: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
549: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
550: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
551: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
552: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
553: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2()

Line 550: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

546: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
547: ,p_percent_complete_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
548: ,p_record_version_number_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
549: ,p_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
550: ,p_eff_rup_percent_complete_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
551: ,p_task_status_tbl IN SYSTEM.pa_varchar2_150_tbl_type := SYSTEM.pa_varchar2_150_tbl_type()
552: ,p_progress_status_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type()
553: ,p_progress_comment_tbl IN SYSTEM.pa_varchar2_4000_tbl_type2 := SYSTEM.pa_varchar2_4000_tbl_type2()
554: ,p_brief_overview_tbl IN SYSTEM.pa_varchar2_250_tbl_type := SYSTEM.pa_varchar2_250_tbl_type()

Line 561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

557: ,p_estimated_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
558: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
559: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
560: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

558: ,p_estimated_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
559: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
560: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

559: ,p_scheduled_start_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
560: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

560: ,p_scheduled_finish_date_tbl IN SYSTEM.pa_date_tbl_type := SYSTEM.pa_date_tbl_type()
561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

561: ,p_est_remaining_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

Line 566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

562: ,p_etc_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

563: ,p_actual_work_quantity_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

564: ,p_actual_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
572: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

565: ,p_actual_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
566: ,p_act_eff_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
567: ,p_actual_cost_this_period_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
568: ,p_planned_cost_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
569: ,p_planned_effort_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
570: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
571: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
572: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
573: );