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_PUB dependencies on PA_NUM_TBL_TYPE

Line 87: l_res_asgn_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

83: select resource_assignment_id, txn_currency_code
84: from pa_resource_asgn_curr
85: where budget_version_id = P_BUDGET_VERSION_ID;
86:
87: l_res_asgn_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
88: l_txn_curr_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
89: -- END Bug 10298995 : Added for Viasat enhancement
90: -- Bug 4592564: Removed variables for Unspent Amounts option.
91:

Line 98: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

94:
95: l_call_maintain_data_api VARCHAR2(1);
96:
97: --Bug 8557807
98: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
99: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type;
100: l_translated_err_msg_count NUMBER;
101: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type;
102: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

Line 102: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();

98: l_ci_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
99: l_translated_msgs_tbl SYSTEM.pa_varchar2_2000_tbl_type;
100: l_translated_err_msg_count NUMBER;
101: l_translated_err_msg_level_tbl SYSTEM.pa_varchar2_30_tbl_type;
102: l_budget_version_id_tbl SYSTEM.pa_num_tbl_type:=SYSTEM.PA_NUM_TBL_TYPE();
103: l_impl_cost_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
104: l_impl_rev_flag_tbl SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
105:
106: BEGIN

Line 1206: l_cal_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1202: l_conv_rates_required_flag VARCHAR2(1);
1203: l_raTxn_rollup_api_call_flag VARCHAR2(1); -- Added for IPM new entity ER
1204:
1205: l_source_context VARCHAR2(30) :='RESOURCE_ASSIGNMENT';
1206: l_cal_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1208: l_cal_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711

Line 1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1203: l_raTxn_rollup_api_call_flag VARCHAR2(1); -- Added for IPM new entity ER
1204:
1205: l_source_context VARCHAR2(30) :='RESOURCE_ASSIGNMENT';
1206: l_cal_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1208: l_cal_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1205: l_source_context VARCHAR2(30) :='RESOURCE_ASSIGNMENT';
1206: l_cal_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1208: l_cal_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711

1206: l_cal_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1208: l_cal_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1207: l_cal_src_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1208: l_cal_rate_based_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1215: l_cal_bill_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1209: l_cal_rlm_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1215: l_cal_bill_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1216: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1217: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();

Line 1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1210: l_cal_cbs_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1215: l_cal_bill_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1216: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1217: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1218: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 1215: l_cal_bill_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1211: l_cal_task_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1212: l_cal_etc_method_code_tab SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1213: l_cal_rcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1214: l_cal_bcost_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1215: l_cal_bill_rate_override_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1216: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1217: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1218: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1219: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();

Line 1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1216: l_delete_budget_lines_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1217: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1218: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1219: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1217: l_spread_amts_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1218: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1219: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1218: l_cal_txn_currency_code_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1219: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1219: l_txn_currency_override_tab SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1220: l_cal_etc_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1221: l_addl_qty_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1222: l_cal_etc_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1223: l_addl_raw_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1231: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1224: l_cal_etc_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1231: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1232: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();

Line 1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1225: l_addl_burdened_cost_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1231: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1232: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1233: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;

Line 1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1226: l_cal_etc_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1227: l_addl_revenue_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1228: l_raw_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1229: l_b_cost_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1230: l_bill_rate_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1231: l_line_start_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1232: l_line_end_date_tab SYSTEM.pa_date_tbl_type:=SYSTEM.pa_date_tbl_type();
1233: l_input_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;
1234: l_period_rates_tbl PA_FP_FCST_GEN_CLIENT_EXT.l_pds_rate_dtls_tab;

Line 1273: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1269: l_ra_txn_source_code PA_RESOURCE_ASSIGNMENTS.TRANSACTION_SOURCE_CODE%TYPE;
1270: l_bl_count NUMBER;
1271:
1272: l_cnt NUMBER := 1;
1273: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1274: l_cal_txn_curr_code_tab_tmp SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1275: l_cal_rate_based_flag_tab_tmp SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1276: l_cal_rlm_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711

Line 1276: l_cal_rlm_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1272: l_cnt NUMBER := 1;
1273: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1274: l_cal_txn_curr_code_tab_tmp SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1275: l_cal_rate_based_flag_tab_tmp SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1276: l_cal_rlm_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();

Line 1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711

1273: l_cal_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1274: l_cal_txn_curr_code_tab_tmp SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1275: l_cal_rate_based_flag_tab_tmp SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1276: l_cal_rlm_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1274: l_cal_txn_curr_code_tab_tmp SYSTEM.pa_varchar2_15_tbl_type:=SYSTEM.pa_varchar2_15_tbl_type();
1275: l_cal_rate_based_flag_tab_tmp SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1276: l_cal_rlm_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1277: l_cal_cbs_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();--bug#16791711
1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1283: l_cal_etc_brdn_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1284: l_cal_etc_revenue_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1285:

Line 1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1278: l_cal_task_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1283: l_cal_etc_brdn_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1284: l_cal_etc_revenue_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1285:
1286: l_fcst_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;

Line 1283: l_cal_etc_brdn_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1279: l_cal_unit_of_measure_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1283: l_cal_etc_brdn_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1284: l_cal_etc_revenue_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1285:
1286: l_fcst_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1287:

Line 1284: l_cal_etc_revenue_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1280: l_cal_etc_method_code_tab_tmp SYSTEM.pa_varchar2_30_tbl_type:=SYSTEM.pa_varchar2_30_tbl_type();
1281: l_cal_etc_qty_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1282: l_cal_etc_raw_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1283: l_cal_etc_brdn_cost_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1284: l_cal_etc_revenue_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1285:
1286: l_fcst_gen_src_code PA_PROJ_FP_OPTIONS.GEN_COST_SRC_CODE%TYPE;
1287:
1288: l_etc_start_date DATE;

Line 1306: l_cal_src_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1302:
1303: /* Variables Added for ER 4376722 */
1304: l_billable_flag_tab SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1305: l_billable_flag_tab_tmp SYSTEM.pa_varchar2_1_tbl_type:=SYSTEM.pa_varchar2_1_tbl_type();
1306: l_cal_src_ra_id_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1307:
1308: -- This index is used in billability logic to track the running index of the _tmp tables
1309: l_tmp_index NUMBER;
1310:

Line 1673: l_cal_rcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1669:
1670: /* Bug 4654157 and 4670253: Variables for enforcing positive total plan quantity */
1671: l_index NUMBER; -- index for _tmp tables
1672: l_total_plan_qty NUMBER;
1673: l_cal_rcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1674: l_cal_bcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1675: l_cal_bill_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1676:
1677: -- IPM: New Entity ER ------------------------------------------

Line 1674: l_cal_bcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1670: /* Bug 4654157 and 4670253: Variables for enforcing positive total plan quantity */
1671: l_index NUMBER; -- index for _tmp tables
1672: l_total_plan_qty NUMBER;
1673: l_cal_rcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1674: l_cal_bcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1675: l_cal_bill_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1676:
1677: -- IPM: New Entity ER ------------------------------------------
1678: -- Stores ids of resources with Financial Plan as the ETC generation source

Line 1675: l_cal_bill_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1671: l_index NUMBER; -- index for _tmp tables
1672: l_total_plan_qty NUMBER;
1673: l_cal_rcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1674: l_cal_bcost_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1675: l_cal_bill_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1676:
1677: -- IPM: New Entity ER ------------------------------------------
1678: -- Stores ids of resources with Financial Plan as the ETC generation source
1679: l_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1679: l_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1675: l_cal_bill_rate_ovrd_tab_tmp SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1676:
1677: -- IPM: New Entity ER ------------------------------------------
1678: -- Stores ids of resources with Financial Plan as the ETC generation source
1679: l_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1680: -- Stores ids of resources with Workplan as the ETC generation source
1681: l_wp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1682: -- Stores ids of non-billable resources with Financial Plan as the ETC generation source
1683: l_non_billable_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

Line 1681: l_wp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1677: -- IPM: New Entity ER ------------------------------------------
1678: -- Stores ids of resources with Financial Plan as the ETC generation source
1679: l_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1680: -- Stores ids of resources with Workplan as the ETC generation source
1681: l_wp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1682: -- Stores ids of non-billable resources with Financial Plan as the ETC generation source
1683: l_non_billable_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1684:
1685: -- Defining a table of tables to process tables in a loop.

Line 1683: l_non_billable_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();

1679: l_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1680: -- Stores ids of resources with Workplan as the ETC generation source
1681: l_wp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1682: -- Stores ids of non-billable resources with Financial Plan as the ETC generation source
1683: l_non_billable_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1684:
1685: -- Defining a table of tables to process tables in a loop.
1686: TYPE SystemPaNumTblTypeTabType
1687: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;

Line 1687: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;

1683: l_non_billable_fp_ra_id_tab SYSTEM.pa_num_tbl_type:=SYSTEM.pa_num_tbl_type();
1684:
1685: -- Defining a table of tables to process tables in a loop.
1686: TYPE SystemPaNumTblTypeTabType
1687: IS TABLE OF SYSTEM.pa_num_tbl_type INDEX BY BINARY_INTEGER;
1688:
1689: l_ra_id_tab_table SystemPaNumTblTypeTabType;
1690: l_planning_options_flag_tab PA_PLSQL_DATATYPES.Char1TabTyp;
1691: l_src_version_id_tab PA_PLSQL_DATATYPES.NumTabTyp;

Line 3565: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));

3561:
3562: INSERT INTO pa_resource_asgn_curr_tmp
3563: ( resource_assignment_id )
3564: SELECT DISTINCT column_value
3565: FROM TABLE( CAST( l_ra_id_tab_table(i) AS SYSTEM.pa_num_tbl_type ));
3566:
3567: -- Call the maintenance api in COPY mode
3568: IF p_pa_debug_mode = 'Y' THEN
3569: PA_FP_GEN_AMOUNT_UTILS.FP_DEBUG(

Line 3630: FROM TABLE(CAST( l_non_billable_fp_ra_id_tab AS SYSTEM.pa_num_tbl_type ))

3626: FROM pa_resource_asgn_curr rbc
3627: WHERE rbc.budget_version_id = p_budget_version_id
3628: AND rbc.txn_bill_rate_override IS NOT NULL
3629: AND EXISTS ( SELECT null
3630: FROM TABLE(CAST( l_non_billable_fp_ra_id_tab AS SYSTEM.pa_num_tbl_type ))
3631: WHERE rbc.resource_assignment_id = column_value );
3632:
3633: l_count := SQL%ROWCOUNT;
3634: