eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_FP_PLANNING_TRANSACTION_PUB dependencies on PA_NUM_TBL_TYPE

Line 41: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

37: ,p_calling_module IN VARCHAR2 DEFAULT NULL
38: ,p_project_id IN Pa_projects_all.project_id%TYPE
39: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
40: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
41: ,p_task_elem_version_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
42: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
43: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
44: ,p_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
45: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 49: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

45: ,p_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
46: -- Bug 3793623 New params p_planning_start_date_tbl and p_planning_end_date_tbl added
47: ,p_planning_start_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
48: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
49: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
50: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
51: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
52: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 52: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

48: ,p_planning_end_date_tbl IN SYSTEM.pa_date_tbl_type DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
49: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
50: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
51: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
52: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
54: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()

Line 53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

49: ,p_planned_people_effort_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
50: ,p_latest_eff_pub_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
51: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
52: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
54: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

51: --One record in the above pl/sql tables correspond to all the records in the below pl/sql tables
52: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
54: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

53: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
54: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

54: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

55: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
63: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'

Line 60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

56: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
63: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
64: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

Line 61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

57: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
63: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
64: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
65: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

58: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
59: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
60: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
61: ,p_bill_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
62: ,p_burdened_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
63: ,p_skip_duplicates_flag IN VARCHAR2 DEFAULT 'N'
64: ,p_unplanned_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
65: ,p_pm_product_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
66: ,p_pm_res_asgmt_ref IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 99: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128

95: ,p_attribute28 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
96: ,p_attribute29 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
97: ,p_attribute30 IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
98: ,p_apply_progress_flag IN VARCHAR2 DEFAULT 'N' /* Bug# 3720357 */
99: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128
100: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
101: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
102: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
103: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 121: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

117: p_context IN VARCHAR2
118: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
119: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE DEFAULT NULL
120: ,p_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
121: ,p_task_elem_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
122: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
123: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
124: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
125: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 126: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

122: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
123: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_100_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_100_TBL_TYPE()
124: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
125: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
126: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
127: -- One pl/sql record in The Above tables
128: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
129: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
130: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 128: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

124: ,p_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
125: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
126: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
127: -- One pl/sql record in The Above tables
128: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
129: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
130: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
131: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
132: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()

Line 129: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

125: ,p_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
126: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
127: -- One pl/sql record in The Above tables
128: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
129: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
130: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
131: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
132: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
133: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

Line 131: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

127: -- One pl/sql record in The Above tables
128: ,p_resource_assignment_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
129: ,p_resource_list_member_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
130: ,p_assignment_description_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
131: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
132: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
133: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
134: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
135: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 135: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

131: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
132: ,p_resource_alias_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
133: ,p_resource_class_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
134: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
135: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
136: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
137: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
138: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
139: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 139: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

135: ,p_resource_class_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
136: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
137: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
138: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
139: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
140: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
141: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()

Line 140: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

136: ,p_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
137: ,p_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
138: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
139: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
140: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
141: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

138: ,p_resource_name IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
139: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
140: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
141: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

140: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
141: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
147: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
148: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

141: ,p_person_type_code IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
147: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
148: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
149: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

142: ,p_bom_resource_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
143: ,p_non_labor_resource_tbl IN SYSTEM.PA_VARCHAR2_20_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_20_TBL_TYPE()
144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
147: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
148: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
149: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
150: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 148: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

144: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
145: ,p_item_category_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
146: ,p_project_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
147: ,p_project_role_name_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
148: ,p_organization_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
149: ,p_organization_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
150: ,p_fc_res_type_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
151: ,p_financial_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
152: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()

Line 156: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

152: ,p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
153: ,p_expenditure_category_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
154: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
155: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
156: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
157: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
158: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
159: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
160: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 158: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

154: ,p_event_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
155: ,p_revenue_category_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
156: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
157: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
158: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
159: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
160: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
161: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
162: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()

Line 160: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

156: ,p_supplier_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
157: ,p_unit_of_measure_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
158: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
159: ,p_etc_method_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
160: ,p_mfc_cost_type_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
161: ,p_procure_resource_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
162: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
163: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
164: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 166: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

162: ,p_incurred_by_res_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
163: ,p_incur_by_resource_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
164: ,p_incur_by_resource_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
165: ,p_incur_by_res_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
166: ,p_incur_by_role_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
167: ,p_use_task_schedule_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
168: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
169: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
170: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 172: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

168: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
169: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
170: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
171: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
172: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
173: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
174: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

171: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
172: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
173: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
174: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

172: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
173: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
174: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

173: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
174: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

174: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

175: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

176: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

Line 181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

177: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
185: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()

Line 182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

178: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
185: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
186: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()

Line 183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

179: ,p_cost_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
185: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
186: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
187: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()

Line 184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

180: ,p_burdened_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
181: ,p_burdened_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
182: ,p_bill_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
183: ,p_bill_rate_override_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
184: ,p_billable_percent_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
185: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE DEFAULT SYSTEM.PA_DATE_TBL_TYPE()
186: ,p_named_role_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
187: ,p_financial_category_name_tbl IN SYSTEM.PA_VARCHAR2_80_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_80_TBL_TYPE()
188: ,p_supplier_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()

Line 221: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128

217: ,p_attribute28_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
218: ,p_attribute29_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
219: ,p_attribute30_tbl IN SYSTEM.PA_VARCHAR2_150_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_150_TBL_TYPE()
220: ,p_apply_progress_flag IN VARCHAR2 DEFAULT 'N' /* Passed from apply_progress api (sakthi's team) */
221: ,p_scheduled_delay IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()--For bug 3948128
222: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' /* Bug# 4200168 */
223: ,p_upd_cost_amts_too_for_ta_flg IN VARCHAR2 DEFAULT 'N' --Added for bug #4538286
224: ,p_distrib_amts IN VARCHAR2 DEFAULT 'Y' -- Bug 5684639.
225: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 256: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

252: ,p_src_project_id IN pa_projects_all.project_id%TYPE
253: ,p_target_project_id IN pa_projects_all.project_id%TYPE
254: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
255: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
256: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_copy_people_flag IN VARCHAR2 := NULL
259: ,p_copy_equip_flag IN VARCHAR2 := NULL
260: ,p_copy_mat_item_flag IN VARCHAR2 := NULL

Line 257: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

253: ,p_target_project_id IN pa_projects_all.project_id%TYPE
254: ,p_src_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
255: ,p_targ_budget_version_id IN pa_budget_versions.budget_version_id%TYPE DEFAULT NULL
256: ,p_src_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
257: ,p_targ_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
258: ,p_copy_people_flag IN VARCHAR2 := NULL
259: ,p_copy_equip_flag IN VARCHAR2 := NULL
260: ,p_copy_mat_item_flag IN VARCHAR2 := NULL
261: ,p_copy_fin_elem_flag IN VARCHAR2 := NULL

Line 304: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

300: (
301: p_context IN VARCHAR2
302: ,p_calling_context IN VARCHAR2 DEFAULT NULL -- Added for Bug 6856934
303: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
304: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
305: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
307: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
308: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown

Line 307: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

303: ,p_task_or_res IN VARCHAR2 DEFAULT 'TASKS'
304: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
305: ,p_task_number_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
306: ,p_task_name_tbl IN SYSTEM.PA_VARCHAR2_240_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_240_TBL_TYPE()
307: ,p_resource_assignment_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
308: --Introduced for bug 3589130. If this parameter is passed as Y then an error will be thrown
309: --When its required to delete a resource assignment containing budget lines. This parameter
310: --will be considered only for BUDGET and FORECAST context
311: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'

Line 315: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

311: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
312: -- This param will be used for B/F Context. Bug - 3719918
313: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
314: ,p_calling_module IN VARCHAR2 DEFAULT NULL
315: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
316: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
317: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
319: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.

Line 316: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()

312: -- This param will be used for B/F Context. Bug - 3719918
313: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
314: ,p_calling_module IN VARCHAR2 DEFAULT NULL
315: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
316: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
317: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
318: ,p_resource_class_code_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE()
319: --For Bug 3937716. Calls to PJI and budget version rollup APIs will be skipped if p_rollup_required_flag is N.
320: ,p_rollup_required_flag IN VARCHAR2 DEFAULT 'Y'

Line 337: IN 1)p_project_id IN SYSTEM.PA_NUM_TBL_TYPE

333: then it attaches it.
334: This would be called when workplan is enabled for
335: a project or template.
336: Parameters:
337: IN 1)p_project_id IN SYSTEM.PA_NUM_TBL_TYPE
338: =======================================================================*/
339: PROCEDURE add_wp_plan_type
340: (
341: p_src_project_id IN pa_projects_all.project_id%TYPE

Line 371: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE

367: PROCEDURE check_and_create_task_rec_info
368: (
369: p_project_id IN Pa_projects_all.project_id%TYPE
370: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
371: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
372: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
373: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */

Line 374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE

370: ,p_struct_elem_version_id IN Pa_proj_element_versions.element_version_id%TYPE
371: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
372: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
373: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
376: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
377: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */

371: ,p_element_version_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
372: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
373: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
376: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
377: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 376: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */

372: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
373: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
376: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
377: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895

Line 378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

374: ,p_planned_people_effort_tbl IN SYSTEM.PA_NUM_TBL_TYPE
375: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
376: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */
377: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

Line 381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

377: ,p_apply_progress_flag IN VARCHAR2 /* Bug 3720357 */
378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
383: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
384: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
385: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895

378: ,x_element_version_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
383: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
384: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
385: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
386: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 383: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895

379: ,x_planning_start_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
383: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
384: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
385: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
386: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
387: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 384: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895

380: ,x_planning_end_date_tbl OUT NOCOPY SYSTEM.PA_DATE_TBL_TYPE --File.Sql.39 bug 4440895
381: ,x_planned_effort_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
382: ,x_resource_assignment_id_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE --File.Sql.39 bug 4440895
383: ,x_raw_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
384: ,x_burdened_cost_tbl OUT NOCOPY SYSTEM.PA_NUM_TBL_TYPE /* Bug# 3720357 */ --File.Sql.39 bug 4440895
385: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
386: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
387: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
388: );