[Home] [Help]
112: ,p_planning_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
113: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
114: ,p_spread_curve_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
115: ,p_sp_fixed_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
116: ,p_txn_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
117: ,p_inventory_item_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
118: ,p_expenditure_type_tbl IN SYSTEM.pa_varchar2_30_tbl_type
119: ,p_person_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
120: ,p_job_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE
1292: ,p_resource_list_member_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1293: ,p_project_assignment_id_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1294: /* The following columns are not (to be) passed by TA/WP. They are based by Edit Plan page BF case */
1295: ,p_quantity_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1296: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
1297: ,p_raw_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1298: ,p_burdened_cost_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1299: ,p_revenue_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1300: ,p_cost_rate_tbl IN SYSTEM.pa_num_tbl_type DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
1382: l_bf_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1383: l_bf_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1384: l_bf_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1385: l_bf_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1386: l_bf_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1387: l_bf_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1388: l_bf_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1389: l_bf_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1390: l_dup_flag varchar2(1) :='N';
1395: l_bf_ins_quantity_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1396: l_bf_ins_raw_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1397: l_bf_ins_burdened_cost_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1398: l_bf_ins_revenue_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1399: l_bf_ins_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1400: l_bf_ins_cost_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1401: l_bf_ins_bill_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1402: l_bf_ins_burdened_rate_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
1403: l_temp NUMBER;
1515: -- IPM Tables
1516: l_orig_count NUMBER; -- bug 5003827 issue 22
1517: -- l_count_index NUMBER;
1518: l_ra_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1519: l_curr_code_temp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1520: --
1521: l_res_assignment_id_temp_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1522: l_res_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
1523: l_call_calc_api VARCHAR2(1);
1525: -- Start of variable to be used in Calculate API Call
1526: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1527: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
1528:
1529: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE:= SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1530: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1531: l_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1532: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1533: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1576: l_rm_temp_count number;
1577:
1578: -- Bug 8370812
1579: l_ra_id_rollup_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
1580: l_curr_code_rollup_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
1581: l_rollup_index NUMBER;
1582: l_add_flag BOOLEAN;
1583: --CBS related Chnages
1584: l_res_class_flag pa_resource_lists_all_bg.resource_class_flag%TYPE := 'Y';
6008: ,p_planning_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6009: ,p_schedule_start_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6010: ,p_schedule_end_date_tbl IN SYSTEM.PA_DATE_TBL_TYPE
6011: ,p_quantity_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6012: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6013: ,p_txn_currency_override_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE
6014: ,p_raw_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6015: ,p_burdened_cost_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6016: ,p_revenue_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6017: ,p_cost_rate_tbl IN SYSTEM.PA_NUM_TBL_TYPE
6144: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6145: l_schedule_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6146: l_schedule_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6147: l_total_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6148: l_override_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6149: l_billable_percent_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6150: l_cost_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6151: l_burdened_rate_override_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6152: l_sp_fixed_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6192: l_raw_cost_rate_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6193: l_revenue_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6194: l_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6195: l_total_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6196: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6197: --For bug 3948128
6198: l_scheduled_delay SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6199:
6200: -- Added for bug 3698458
6206: /* End of variables for Variable for Resource Attributes
6207: */
6208: l_spread_amt_flag_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6209: l_delete_budget_lines_tbl SYSTEM.PA_VARCHAR2_1_TBL_TYPE := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
6210: l_currency_code_tmp_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6211: l_existing_curr_code pa_budget_lines.txn_currency_code%TYPE;
6212: l_projfunc_currency_code pa_budget_lines.txn_currency_code%TYPE;
6213: l_projfunc_currency_code_out pa_budget_lines.txn_currency_code%TYPE;
6214: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type;
6252: -- Bug 5906826
6253: l_ra_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6254: l_line_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6255: l_line_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE := SYSTEM.PA_DATE_TBL_TYPE();
6256: l_txn_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
6257: l_tot_qty_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6258: l_txn_raw_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6259: l_txn_burdened_cost_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
6260: l_cal_api_called_flg VARCHAR2(1) := 'N';
7721:
7722: l_ra_id_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7723: l_line_start_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7724: l_line_end_date_tbl := SYSTEM.PA_DATE_TBL_TYPE();
7725: l_txn_currency_code_tbl := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
7726: l_tot_qty_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7727: l_txn_raw_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7728: l_txn_burdened_cost_tbl := SYSTEM.PA_NUM_TBL_TYPE();
7729: l_delete_budget_lines_tbl := SYSTEM.PA_VARCHAR2_1_TBL_TYPE();
8358: l_temp_proj_assmt_id_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8359: l_temp_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8360: l_temp_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE() ;
8361: l_quantity_tbl SYSTEM.PA_NUM_TBL_TYPE := SYSTEM.PA_NUM_TBL_TYPE();
8362: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
8363: l_module_name VARCHAR2(100):='pa.fp_planning_txn_pub.copy_planning_transactions';
8364: l_resource_rec_tbl PA_TASK_ASSIGNMENT_UTILS.l_resource_rec_tbl_type;
8365: l_planning_start_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8366: l_planning_end_date_tbl SYSTEM.PA_DATE_TBL_TYPE:= SYSTEM.PA_DATE_TBL_TYPE();
8925: ,p_resource_assignment_tab => l_calc_ra_id_tbl
8926: ,p_delete_budget_lines_tab => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
8927: -- bug fix:5726773 ,p_spread_amts_flag_tab => l_spread_amt_flag_tbl
8928: ,p_txn_currency_code_tab => l_currency_code_tbl
8929: ,p_txn_currency_override_tab => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
8930: ,p_total_qty_tab => l_quantity_tbl
8931: ,p_total_raw_cost_tab => l_tot_rc_tbl
8932: ,p_total_burdened_cost_tab => SYSTEM.PA_NUM_TBL_TYPE()
8933: ,p_total_revenue_tab => SYSTEM.PA_NUM_TBL_TYPE()
9332: --When its required to delete a resource assignment containing budget lines. This parameter
9333: --will be considered only for BUDGET and FORECAST context
9334: ,p_validate_delete_flag IN VARCHAR2 DEFAULT 'N'
9335: -- This param will be used for B/F Context. Bug - 3719918
9336: ,p_currency_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
9337: ,p_calling_module IN VARCHAR2 DEFAULT NULL
9338: ,p_task_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9339: ,p_rbs_element_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE()
9340: ,p_rate_based_flag_tbl IN SYSTEM.PA_VARCHAR2_1_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
9364:
9365: l_period_name_tbl SYSTEM.pa_varchar2_30_tbl_type;
9366: l_start_date_tbl SYSTEM.pa_date_tbl_type;
9367: l_end_date_tbl SYSTEM.pa_date_tbl_type;
9368: l_txn_currency_code_tbl SYSTEM.pa_varchar2_15_tbl_type;
9369: l_txn_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9370: l_txn_burdened_cost_tbl SYSTEM.pa_num_tbl_type;
9371: l_txn_revenue_tbl SYSTEM.pa_num_tbl_type;
9372: l_project_raw_cost_tbl SYSTEM.pa_num_tbl_type;
9403: SKIP_LOOP EXCEPTION;
9404: i NUMBER;
9405: l_cntr NUMBER;
9406:
9407: l_currency_code_tbl SYSTEM.PA_VARCHAR2_15_TBL_TYPE := SYSTEM.PA_VARCHAR2_15_TBL_TYPE();
9408: l_task_id PA_RESOURCE_ASSIGNMENTS.TASK_ID%TYPE;
9409: l_rbs_element_id PA_RESOURCE_ASSIGNMENTS.RBS_ELEMENT_ID%TYPE;
9410: l_res_class_code PA_RESOURCE_ASSIGNMENTS.RESOURCE_CLASS_CODE%TYPE;
9411: l_rate_based_flag PA_RESOURCE_ASSIGNMENTS.RATE_BASED_FLAG%TYPE;
11476: ,p_planned_people_effort_tbl => l_planned_people_effort_tbl
11477: ,p_latest_eff_pub_flag_tbl => SYSTEM.PA_VARCHAR2_1_TBL_TYPE()
11478: ,p_resource_list_member_id_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11479: ,p_quantity_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11480: ,p_currency_code_tbl => SYSTEM.PA_VARCHAR2_15_TBL_TYPE()
11481: ,p_raw_cost_tbl => l_raw_cost_tbl
11482: ,p_burdened_cost_tbl => l_burdened_cost_tbl
11483: ,p_revenue_tbl => SYSTEM.PA_NUM_TBL_TYPE()
11484: ,p_cost_rate_tbl => SYSTEM.PA_NUM_TBL_TYPE()