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_FORECAST_GRC_PVT dependencies on PA_PLSQL_DATATYPES

Line 230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

226:
227:
228: ----------------------------------------------------------------------------------------
229: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

227:
228: ----------------------------------------------------------------------------------------
229: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
235: p_balance_type_code IN VARCHAR2,

Line 232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

228: ----------------------------------------------------------------------------------------
229: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
235: p_balance_type_code IN VARCHAR2,
236: p_run_start_date IN DATE,

Line 233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

229: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
235: p_balance_type_code IN VARCHAR2,
236: p_run_start_date IN DATE,
237: p_run_end_date IN DATE,

Line 234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

230: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
231: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
232: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
233: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
235: p_balance_type_code IN VARCHAR2,
236: p_run_start_date IN DATE,
237: p_run_end_date IN DATE,
238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

Line 238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

234: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
235: p_balance_type_code IN VARCHAR2,
236: p_run_start_date IN DATE,
237: p_run_end_date IN DATE,
238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895

Line 239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895

235: p_balance_type_code IN VARCHAR2,
236: p_run_start_date IN DATE,
237: p_run_end_date IN DATE,
238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895

Line 240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895

236: p_run_start_date IN DATE,
237: p_run_end_date IN DATE,
238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

Line 241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895

237: p_run_end_date IN DATE,
238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

Line 242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895

238: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

Line 243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895

239: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

240: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
248: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

241: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
248: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
249: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

242: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
243: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
244: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
245: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
246: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
247: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
248: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
249: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
250: )IS