DBA Data[Home] [Help]

APPS.PA_PLANNING_TRANSACTION_UTILS dependencies on PA_NUM_TBL_TYPE

Line 250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type

246: -- Dates will not be defaulted if they are passed to the API at a particular index.
247:
248: PROCEDURE get_default_planning_dates
249: ( p_project_id IN pa_projects_all.project_id%TYPE
250: ,p_element_version_id_tbl IN SYSTEM.pa_num_tbl_type
251: ,p_project_structure_version_id IN pa_budget_versions.project_structure_version_id%TYPE
252: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
253: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
254: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.pa_date_tbl_type --File.Sql.39 bug 4440895

Line 559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type

555: PROCEDURE call_update_rep_lines_api
556: (
557: p_source IN VARCHAR2
558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE
559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
560: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type -- cbs enhancement bug#16688443
561: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
562: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type

Line 560: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type -- cbs enhancement bug#16688443

556: (
557: p_source IN VARCHAR2
558: ,p_budget_version_id IN pa_budget_versions.budget_Version_id%TYPE
559: ,p_resource_assignment_id_tbl IN SYSTEM.pa_num_tbl_type
560: ,p_cbs_element_id_tbl IN SYSTEM.pa_num_tbl_type -- cbs enhancement bug#16688443
561: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
562: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
564: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type

Line 565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

561: ,p_period_name_tbl IN SYSTEM.pa_varchar2_30_tbl_type
562: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
564: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

562: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type
563: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
564: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type

Line 567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type

563: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type
564: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

564: ,p_txn_currency_code_tbl IN SYSTEM.pa_varchar2_15_tbl_type
565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

Line 569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

565: ,p_txn_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type

Line 570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type

566: ,p_txn_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type
574: ,p_cost_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type

567: ,p_txn_revenue_tbl IN SYSTEM.pa_num_tbl_type
568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type
574: ,p_cost_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
575: ,p_revenue_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type

568: ,p_project_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type
574: ,p_cost_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
575: ,p_revenue_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
576: ,p_burden_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type

Line 573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type

569: ,p_project_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
570: ,p_project_revenue_tbl IN SYSTEM.pa_num_tbl_type
571: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type
572: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type
573: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type
574: ,p_cost_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
575: ,p_revenue_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
576: ,p_burden_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
577: ,p_other_rejection_code IN SYSTEM.pa_varchar2_30_tbl_type

Line 580: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type

576: ,p_burden_rejection_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
577: ,p_other_rejection_code IN SYSTEM.pa_varchar2_30_tbl_type
578: ,p_pc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
579: ,p_pfc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
580: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
581: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
582: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
583: ,p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
584: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type

Line 581: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type

577: ,p_other_rejection_code IN SYSTEM.pa_varchar2_30_tbl_type
578: ,p_pc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
579: ,p_pfc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
580: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
581: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
582: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
583: ,p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
584: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
585: ,p_qty_sign IN NUMBER -- for bug 4543744

Line 582: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type

578: ,p_pc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
579: ,p_pfc_cur_conv_rej_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
580: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type
581: ,p_rbs_element_id_tbl IN SYSTEM.pa_num_tbl_type
582: ,p_task_id_tbl IN SYSTEM.pa_num_tbl_type
583: ,p_res_class_code_tbl IN SYSTEM.pa_varchar2_30_tbl_type
584: ,p_rate_based_flag_tbl IN SYSTEM.pa_varchar2_1_tbl_type
585: ,p_qty_sign IN NUMBER -- for bug 4543744
586: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895