[Home] [Help]
56: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
57: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
58: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
59: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
60: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
61: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
62: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
63: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
64: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1233: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1234: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1235: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1236: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1237: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1238: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1239: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1240: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1241: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1322: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1323: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1324: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1325: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1326: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1327: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1328: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1329: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1330: l_dup_flag varchar2(1) :='N';
1335: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1336: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1337: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1338: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1339: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1340: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1341: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1342: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1343: l_temp NUMBER;
1454: -- IPM Tables
1455: l_orig_count NUMBER; -- bug 5003827 issue 22
1456: -- l_count_index NUMBER;
1457: l_ra_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1458: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1459: --
1460: l_res_assignment_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1461: l_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1462: l_call_calc_api VARCHAR2(1);
1464: -- Start of variable to be used in Calculate API Call
1465: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1466: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1467:
1468: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1469: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1470: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1471: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1472: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5353: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5357: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5358: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5359: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5360: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5361: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5354: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5355: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
5356: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5357: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5358: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
5359: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5360: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5361: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5362: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
5486: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5487: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5488: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5489: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5490: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5491: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5492: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5493: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5494: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
5534: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5535: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5536: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5537: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5538: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5539: --For bug 3948128
5540: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
5541:
5542: -- Added for bug 3698458
5548: /* End of variables for Variable for Resource Attributes
5549: */
5550: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5551: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
5552: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
5553: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
5554: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
5555: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
5556: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
7532: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7533: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7534: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
7535: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
7536: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7537: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
7538: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
7539: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
7540: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8099: ,p_resource_assignment_tab => l_calc_ra_id_tbl
8100: ,p_delete_budget_lines_tab => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
8101: -- bug fix:5726773 ,p_spread_amts_flag_tab => l_spread_amt_flag_tbl
8102: ,p_txn_currency_code_tab => l_currency_code_tbl
8103: ,p_txn_currency_override_tab => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8104: ,p_total_qty_tab => l_quantity_tbl
8105: ,p_total_raw_cost_tab => l_tot_rc_tbl
8106: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8107: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
8506: --When its required to delete a resource assignment containing budget lines. This parameter
8507: --will be considered only for BUDGET and FORECAST context
8508: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
8509: -- This param will be used for B/F Context. Bug - 3719918
8510: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8511: ,p_calling_module IN VARCHAR2 DEFAULT NULL
8512: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8513: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
8514: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
8538:
8539: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
8540: l_start_date_tbl SYSTEM.pa_date_tbl_type;
8541: l_end_date_tbl SYSTEM.pa_date_tbl_type;
8542: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
8543: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8544: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
8545: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
8546: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
8577: SKIP_LOOP EXCEPTION;
8578: i NUMBER;
8579: l_cntr NUMBER;
8580:
8581: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
8582: l_task_id PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
8583: l_rbs_element_id PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID%TYPE;
8584: l_res_class_code PA_RESOURCE_ASSIGNMENTS.RESOURCE_CLASS_CODE%TYPE;
8585: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
10610: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl
10611: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
10612: ,p_resource_list_member_id_tbl => SYSTEM.PA_NUM_TBL_TYPE()
10613: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
10614: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
10615: ,p_raw_cost_tbl => l_raw_cost_tbl
10616: ,p_burdened_cost_tbl => l_burdened_cost_tbl
10617: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
10618: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()