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

Line 27: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

23: X_MSG_DATA OUT NOCOPY VARCHAR2) IS
24:
25: l_module_name VARCHAR2(200) := 'pa.plsql.pa_fp_gen_fcst_amt_pub.get_total_plan_txn_amts';
26:
27: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
28:
29: /* Local variables for calling pa_fp_gen_amount_utils.get_values_for_planning_rate api */
30: l_res_format_id PA_RESOURCE_LIST_MEMBERS.RES_FORMAT_ID%TYPE;
31: l_resource_asn_rec PA_FP_GEN_AMOUNT_UTILS.RESOURCE_ASN_REC;

Line 2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

2019: l_future_no_of_period NUMBER;
2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
2022:
2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2020: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
2022:
2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

2021: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
2022:
2023: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
2024: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2025: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
2026:
2027: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
2028: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
2029: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;

2395: X_MSG_DATA OUT NOCOPY VARCHAR2)
2396: IS
2397: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2398:
2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

2396: IS
2397: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2398:
2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2397: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2398:
2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2405:

Line 2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2398:
2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2405:
2406: l_msg_count NUMBER;

Line 2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;

2399: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2405:
2406: l_msg_count NUMBER;
2407: l_msg_data VARCHAR2(2000);

Line 2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;

2400: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2401: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2402: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2403: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2404: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2405:
2406: l_msg_count NUMBER;
2407: l_msg_data VARCHAR2(2000);
2408: l_data VARCHAR2(2000);