DBA Data[Home] [Help]

APPS.PA_FP_GEN_FCST_AMT_PVT dependencies on PA_PLSQL_DATATYPES

Line 26: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

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

Line 1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

1988: l_future_no_of_period NUMBER;
1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
1991:
1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1989: l_res_asg_id PA_RESOURCE_ASSIGNMENTS.RESOURCE_ASSIGNMENT_ID%TYPE;
1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
1991:
1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1990: l_amt_dtls_tbl PA_FP_MAINTAIN_ACTUAL_PUB.l_amt_dtls_tbl_typ;
1991:
1992: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
1993: l_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1994: l_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1995:
1996: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1997: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1998: l_etc_from_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;

2362: X_MSG_DATA OUT NOCOPY VARCHAR2)
2363: IS
2364: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2365:
2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;

2363: IS
2364: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2365:
2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;

Line 2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2364: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PVT.upd_tgt_rate_based_flag';
2365:
2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2372:

Line 2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;

2365:
2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2372:
2373: l_msg_count NUMBER;

Line 2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;

2366: l_tgt_res_asg_tab pa_plsql_datatypes.IdTabTyp;
2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2372:
2373: l_msg_count NUMBER;
2374: l_msg_data VARCHAR2(2000);

Line 2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;

2367: l_budget_line_id_tab pa_plsql_datatypes.IdTabTyp;
2368: l_init_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2369: l_raw_cost_tab pa_plsql_datatypes.NumTabTyp;
2370: l_init_rev_tab pa_plsql_datatypes.NumTabTyp;
2371: l_rev_tab pa_plsql_datatypes.NumTabTyp;
2372:
2373: l_msg_count NUMBER;
2374: l_msg_data VARCHAR2(2000);
2375: l_data VARCHAR2(2000);