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

Line 104: l_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

100: AND ( rbc.txn_raw_cost_rate_override is not null OR
101: rbc.txn_burden_cost_rate_override is not null OR
102: rbc.txn_bill_rate_override is not null );
103:
104: l_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: -- This flag tracks if the pa_resource_asgn_curr_tmp global
108: -- temp table has been deleted/cleared yet.

Line 105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

101: rbc.txn_burden_cost_rate_override is not null OR
102: rbc.txn_bill_rate_override is not null );
103:
104: l_res_asg_id_tab PA_PLSQL_DATATYPES.NumTabTyp;
105: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
106:
107: -- This flag tracks if the pa_resource_asgn_curr_tmp global
108: -- temp table has been deleted/cleared yet.
109: l_rbc_tmp_tbl_deleted_flag VARCHAR2(1);

Line 503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

499: FROM pa_budget_lines bl
500: WHERE bl.resource_assignment_id = c_res_asg_id
501: AND bl.txn_currency_code = p_txn_currency_code;
502:
503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
504: l_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
505: l_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
506: l_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
507: l_count NUMBER;

Line 504: l_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

500: WHERE bl.resource_assignment_id = c_res_asg_id
501: AND bl.txn_currency_code = p_txn_currency_code;
502:
503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
504: l_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
505: l_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
506: l_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
507: l_count NUMBER;
508: l_msg_count NUMBER;

Line 505: l_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

501: AND bl.txn_currency_code = p_txn_currency_code;
502:
503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
504: l_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
505: l_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
506: l_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
507: l_count NUMBER;
508: l_msg_count NUMBER;
509: l_data VARCHAR2(1000);

Line 506: l_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

502:
503: l_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
504: l_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
505: l_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
506: l_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
507: l_count NUMBER;
508: l_msg_count NUMBER;
509: l_data VARCHAR2(1000);
510: l_msg_data VARCHAR2(1000);

Line 642: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

638: and ra.rate_based_flag = 'Y'
639: GROUP BY tmp.target_res_asg_id
640: HAVING COUNT(DISTINCT(tmp.unit_of_measure)) > 1;
641:
642: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
643:
644: l_currency_code CONSTANT PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE := 'DOLLARS';
645: l_last_updated_by NUMBER := FND_GLOBAL.user_id;
646: l_last_update_login NUMBER := FND_GLOBAL.login_id;

Line 1203: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1199: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
1200: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1201: AND adjustment_period_flag = 'N';
1202:
1203: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;

Line 1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1200: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1201: AND adjustment_period_flag = 'N';
1202:
1203: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711

1201: AND adjustment_period_flag = 'N';
1202:
1203: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1209: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1202:
1203: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1209: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1210:

Line 1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1204: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1209: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1210:
1211: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1212: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 1209: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1205: l_cbs_id_tab PA_PLSQL_DATATYPES.IdTabTyp;--bug#16791711
1206: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1207: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1208: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1209: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1210:
1211: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1212: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1213: l_currency_count NUMBER;

Line 2737: l_wp_task_tab PA_PLSQL_DATATYPES.IdTabTyp;

2733: l_oth_act_rawcost_tc_ind NUMBER;
2734:
2735: l_oth_quantity_ind NUMBER;
2736: --
2737: l_wp_task_tab PA_PLSQL_DATATYPES.IdTabTyp;
2738:
2739: l_start_date DATE;
2740: l_completion_date DATE;
2741:

Line 4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

4205: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GET_ACTUALS_FOR_RA';
4206:
4207: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4208:
4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

4206:
4207: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4208:
4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4207: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4208:
4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4208:
4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4209: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4217:

Line 4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4210: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4217:
4218: l_msg_count NUMBER;

Line 4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4211: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4217:
4218: l_msg_count NUMBER;
4219: l_msg_data VARCHAR2(2000);

Line 4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4212: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4213: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4214: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4215: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4216: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4217:
4218: l_msg_count NUMBER;
4219: l_msg_data VARCHAR2(2000);
4220: l_data VARCHAR2(2000);

Line 4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

4421: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:
4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4427: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4428: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4429:

Line 4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4422: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4423:
4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4427: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4428: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4429:
4430: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;

Line 4427: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4423:
4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4427: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4428: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4429:
4430: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4431: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;

Line 4428: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4424:
4425: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4426: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4427: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4428: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4429:
4430: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4431: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4432: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;