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 25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

21:
22:
23:
24: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

Line 26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

22:
23:
24: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30: p_balance_type_code IN VARCHAR2,

Line 27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,

23:
24: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30: p_balance_type_code IN VARCHAR2,
31: p_run_start_date IN DATE,

Line 28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

24: PROCEDURE Get_Capacity_Vector(p_OU_id IN NUMBER,
25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30: p_balance_type_code IN VARCHAR2,
31: p_run_start_date IN DATE,
32: p_run_end_date IN DATE,

Line 29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,

25: p_exp_org_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
26: p_person_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
27: p_resource_id_tab IN PA_PLSQL_DATATYPES.IdTabTyp,
28: p_in_res_eff_s_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30: p_balance_type_code IN VARCHAR2,
31: p_run_start_date IN DATE,
32: p_run_end_date IN DATE,
33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

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

29: p_in_res_eff_e_date_tab IN PA_PLSQL_DATATYPES.DateTabTyp,
30: p_balance_type_code IN VARCHAR2,
31: p_run_start_date IN DATE,
32: p_run_end_date IN DATE,
33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895

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

30: p_balance_type_code IN VARCHAR2,
31: p_run_start_date IN DATE,
32: p_run_end_date IN DATE,
33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895

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

31: p_run_start_date IN DATE,
32: p_run_end_date IN DATE,
33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

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

32: p_run_end_date IN DATE,
33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

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

33: x_resource_capacity_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895

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

34: x_exp_orgz_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
42: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

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

35: x_person_id_tab OUT NOCOPY PA_PLSQL_DATATYPES.IdTabTyp, --File.Sql.39 bug 4440895
36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
42: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

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

36: x_period_type_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
42: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

37: x_period_name_tab OUT NOCOPY PA_PLSQL_DATATYPES.Char30TabTyp, --File.Sql.39 bug 4440895
38: x_global_exp_date_tab OUT NOCOPY PA_PLSQL_DATATYPES.DateTabTyp, --File.Sql.39 bug 4440895
39: x_period_year_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
40: x_qm_number_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
41: x_period_num_tab OUT NOCOPY PA_PLSQL_DATATYPES.NumTabTyp, --File.Sql.39 bug 4440895
42: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
43: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
44: x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
45: );