DBA Data[Home] [Help]

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 1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1184: AND application_id = PA_PERIOD_PROCESS_PKG.Application_id
1185: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1186: AND adjustment_period_flag = 'N';
1187:
1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1185: AND set_of_books_id = p_fp_cols_rec.x_set_of_books_id
1186: AND adjustment_period_flag = 'N';
1187:
1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

Line 1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;

1186: AND adjustment_period_flag = 'N';
1187:
1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:

Line 1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1188: l_res_asg_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:
1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1196: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;

Line 1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;

1189: l_rlm_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1190: l_task_id_tab PA_PLSQL_DATATYPES.IdTabTyp;
1191: l_currency_code PA_BUDGET_LINES.TXN_CURRENCY_CODE%TYPE;
1192: l_planning_start_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1193: l_planning_end_date_tab PA_PLSQL_DATATYPES.DateTabTyp;
1194:
1195: l_actual_from_date PA_PERIODS_ALL.START_DATE%TYPE;
1196: l_actual_to_date PA_PERIODS_ALL.START_DATE%TYPE;
1197: l_currency_count NUMBER;

Line 2714: l_wp_task_tab PA_PLSQL_DATATYPES.IdTabTyp;

2710: l_oth_act_rawcost_tc_ind NUMBER;
2711:
2712: l_oth_quantity_ind NUMBER;
2713: --
2714: l_wp_task_tab PA_PLSQL_DATATYPES.IdTabTyp;
2715:
2716: l_start_date DATE;
2717: l_completion_date DATE;
2718:

Line 4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;

4181: l_module_name VARCHAR2(200) := 'pa.plsql.PA_FP_GEN_FCST_AMT_PUB1.GET_ACTUALS_FOR_RA';
4182:
4183: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4184:
4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;

4182:
4183: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4184:
4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4183: l_wp_bdgt_ver_id pa_budget_versions.budget_version_id%type;
4184:
4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4184:
4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4185: l_txn_currency_code_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4193:

Line 4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4186: l_init_quantity_tab PA_PLSQL_DATATYPES.NumTabTyp;
4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4193:
4194: l_msg_count NUMBER;

Line 4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4187: l_txn_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4193:
4194: l_msg_count NUMBER;
4195: l_msg_data VARCHAR2(2000);

Line 4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;

4188: l_txn_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4189: l_prj_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4190: l_prj_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4191: l_init_raw_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4192: l_init_brdn_cost_tab PA_PLSQL_DATATYPES.NumTabTyp;
4193:
4194: l_msg_count NUMBER;
4195: l_msg_data VARCHAR2(2000);
4196: l_data VARCHAR2(2000);

Line 4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;

4397: l_init_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:
4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4403: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4404: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4405:

Line 4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4398: l_txn_revenue_tbl_1 SYSTEM.pa_num_tbl_type;
4399:
4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4403: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4404: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4405:
4406: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;

Line 4403: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4399:
4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4403: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4404: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4405:
4406: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4407: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;

Line 4404: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;

4400:
4401: l_ext_period_name_tab PA_PLSQL_DATATYPES.Char30TabTyp;
4402: l_ext_raw_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4403: l_ext_burdened_cost_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4404: l_ext_revenue_bill_rate_tab PA_PLSQL_DATATYPES.NumTabTyp;
4405:
4406: l_plan_txn_prd_amt_tbl_1 PA_FP_FCST_GEN_CLIENT_EXT.l_plan_txn_prd_amt_tbl;
4407: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
4408: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;