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_CALC_PLAN_PKG dependencies on PA_RESOURCE_ASSIGNMENTS

Line 10: g_budget_version_id pa_resource_assignments.budget_version_id%TYPE;

6:
7: skip_record EXCEPTION;
8: g_stage Varchar2(1000);
9: g_rowcount NUMBER;
10: g_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
11: g_project_currency_code Varchar2(30);
12: g_projfunc_currency_code Varchar2(30);
13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;
14: g_project_id pa_resource_assignments.project_id%TYPE;

Line 14: g_project_id pa_resource_assignments.project_id%TYPE;

10: g_budget_version_id pa_resource_assignments.budget_version_id%TYPE;
11: g_project_currency_code Varchar2(30);
12: g_projfunc_currency_code Varchar2(30);
13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;
14: g_project_id pa_resource_assignments.project_id%TYPE;
15: g_task_id pa_resource_assignments.task_id%TYPE;
16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;

Line 15: g_task_id pa_resource_assignments.task_id%TYPE;

11: g_project_currency_code Varchar2(30);
12: g_projfunc_currency_code Varchar2(30);
13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;
14: g_project_id pa_resource_assignments.project_id%TYPE;
15: g_task_id pa_resource_assignments.task_id%TYPE;
16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);

Line 17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;

13: g_fp_budget_version_type pa_budget_versions.version_type%TYPE;
14: g_project_id pa_resource_assignments.project_id%TYPE;
15: g_task_id pa_resource_assignments.task_id%TYPE;
16: g_time_phased_code VARCHAR2(100) := null;
17: g_resource_list_member_id pa_resource_assignments.resource_list_member_id%TYPE;
18: g_bv_resource_list_id pa_budget_versions.resource_list_id%TYPE;
19: g_resource_id NUMBER := to_number(null);
20: g_bv_approved_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
21: g_fp_multi_curr_enabled pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;

Line 1329: * Based on the statistics collected for the pa_budget_lines and pa_resource_assignments on pjperf table

1325: END CHECK_MRC_INSTALLED;
1326:
1327: /* This API will set the statistics for global tmp tables. Since Gather_statistics and set_table_stats
1328: * does the commit in the main session, this api made as autonomous so that main session should not be impacted.
1329: * Based on the statistics collected for the pa_budget_lines and pa_resource_assignments on pjperf table
1330: * the tmp table stats will be set as follows
1331: * If number of rows < 500 then set the number of rows = 500 and num blocks to number of rows/30
1332: * if number of rows > 500 then set the number of rows to passed in value and block size to numrows / 30
1333: * This API will be called only once for all tmp tables

Line 3353: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3349: FETCH cur_EvenSpCur INTO l_evenSpCurveId;
3350: CLOSE cur_EvenSpCur;
3351:
3352: g_stage :='Reset_Planning_end_date:100';
3353: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3354: SET ra.spread_curve_id = DECODE(ra.spread_curve_id,6
3355: ,decode(sign(nvl(ra.sp_fixed_date,p_etc_start_date) - p_etc_start_date),-1,l_evenSpCurveId,ra.spread_curve_id)
3356: ,ra.spread_curve_id)
3357: ,ra.sp_fixed_date = DECODE(sign(nvl(ra.sp_fixed_date,p_etc_start_date) - p_etc_start_date),-1,NULL,ra.sp_fixed_date)

Line 3376: From pa_resource_assignments ra

3372: -- bug 8512066 skkoppul : updating the start date as well coz budget line dates
3373: -- should match the resource assignements dates in a non time phase context
3374: UPDATE pa_budget_lines bl
3375: SET ( bl.start_date, bl.end_date ) = (select ra.planning_start_date, ra.planning_end_date
3376: From pa_resource_assignments ra
3377: Where ra.resource_assignment_id = bl.resource_assignment_id)
3378: WHERE bl.budget_version_id = p_budget_version_id
3379: AND EXISTS ( SELECT 'Y'
3380: FROM pa_resource_assignments pra

Line 3380: FROM pa_resource_assignments pra

3376: From pa_resource_assignments ra
3377: Where ra.resource_assignment_id = bl.resource_assignment_id)
3378: WHERE bl.budget_version_id = p_budget_version_id
3379: AND EXISTS ( SELECT 'Y'
3380: FROM pa_resource_assignments pra
3381: ,pa_fp_spread_calc_tmp tmp
3382: WHERE pra.resource_assignment_id = bl.resource_assignment_id
3383: AND pra.budget_version_id = bl.budget_version_id
3384: AND tmp.budget_version_id = pra.budget_version_id

Line 3419: ,pa_resource_assignments ra

3415:
3416: CURSOR cur_spbl_chk IS
3417: SELECT tmp.resource_assignment_id
3418: FROM pa_fp_spread_calc_tmp tmp
3419: ,pa_resource_assignments ra
3420: WHERE tmp.budget_version_id = p_budget_version_id
3421: AND tmp.resource_assignment_id = ra.resource_assignment_id
3422: AND NVL(tmp.sp_curve_change_flag,'N') = 'N'
3423: /* Bug fix: AND ra.sp_fixed_date is NOT NULL this is commented as in some ofthe flows,

Line 3532: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3528:
3529: --print_msg('More than one budget Line exists for Spread Curve Fixed Date');
3530: FORALL i IN l_raId_tab.FIRST .. l_raId_tab.LAST
3531: /* update the RA and set sp_fixed_date to null so that spread api will spread the amts evenly */
3532: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3533: SET ra.spread_curve_id = l_evenSpCurveId
3534: ,ra.sp_fixed_date = NULL
3535: /* bug fix:4122400 for fixed date spread curve, change the plan end date as ETC start date */
3536: /* Bug fix: 4247427 ,ra.planning_end_date = p_etc_start_date

Line 3607: ,pa_resource_assignments ra

3603: SELECT 'Y'
3604: FROM DUAL
3605: WHERE EXISTS (select null
3606: from pa_budget_lines bl
3607: ,pa_resource_assignments ra
3608: where ra.resource_assignment_id = p_res_ass_id
3609: and bl.resource_assignment_id = ra.resource_assignment_id
3610: and bl.txn_currency_code = p_txn_currency_code
3611: and ra.sp_fixed_date is NOT NULL

Line 3653: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3649: FETCH cur_EvenSpCur INTO l_evenSpCurveId;
3650: CLOSE cur_EvenSpCur;
3651: --print_msg('More than one budget Line exists for Spread Curve Fixed Date');
3652: /* update the RA and set sp_fixed_date to null so that spread api will spread the amts evenly */
3653: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3654: SET ra.spread_curve_id = l_evenSpCurveId
3655: ,ra.sp_fixed_date = NULL
3656: /* bug fix:4122400 for fixed date spread curve, change the plan end date as ETC start date */
3657: ,ra.planning_end_date = p_etc_start_date

Line 3908: ,pa_resource_assignments ra

3904: ,bl.burden_rejection_code
3905: ,bl.pfc_cur_conv_rejection_code
3906: ,bl.pc_cur_conv_rejection_code
3907: FROM pa_budget_lines bl
3908: ,pa_resource_assignments ra
3909: ,pa_fp_spread_calc_tmp tmp
3910: WHERE tmp.budget_version_id = p_budget_version_id
3911: AND bl.resource_assignment_id = tmp.resource_assignment_id
3912: AND bl.txn_currency_code = tmp.txn_currency_code

Line 4779: ,pa_resource_assignments ra

4775: ,decode(p_generation_context,'REVENUE_MARKUP',
4776: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4777: FROM pa_fp_rollup_tmp tmp
4778: ,pa_fp_gen_rate_tmp fptmp
4779: ,pa_resource_assignments ra
4780: ,pa_fp_spread_calc_tmp caltmp
4781: WHERE caltmp.budget_version_id = p_budget_version_id
4782: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4783: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'

Line 4815: ,pa_resource_assignments ra

4811: ,decode(p_generation_context,'REVENUE_MARKUP',
4812: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4813: FROM pa_fp_rollup_tmp tmp
4814: ,pa_fp_gen_rate_tmp fptmp
4815: ,pa_resource_assignments ra
4816: ,pa_fp_spread_calc_tmp caltmp
4817: WHERE caltmp.budget_version_id = p_budget_version_id
4818: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4819: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'

Line 5019: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

5015: and the budget start date is greater than ETC start date
5016: */
5017: PROCEDURE delete_budget_lines
5018: ( p_budget_version_id IN pa_budget_lines.budget_version_id%type
5019: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
5020: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
5021: ,p_line_start_date IN pa_budget_lines.start_date%TYPE
5022: ,p_line_end_date IN pa_budget_lines.end_date%TYPE
5023: ,p_source_context IN varchar2

Line 5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE

5637:
5638: PROCEDURE chk_req_rate_api_inputs
5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

Line 5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE

5638: PROCEDURE chk_req_rate_api_inputs
5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE

Line 5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE

5639: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE

Line 5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE

5640: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

Line 5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

5641: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5642: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5643: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

Line 5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

5644: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE

Line 5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

5645: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE

Line 5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE

5646: ,p_quantity IN pa_budget_lines.quantity%TYPE
5647: ,p_item_date IN pa_budget_lines.start_date%TYPE
5648: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5649: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5650: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5651: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5652: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5653: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5654: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE

Line 6126: ,pa_resource_assignments ra

6122: ,decode(NVL(g_wp_version_flag,'N'),'Y','N'
6123: ,decode(nvl(ra.rate_based_flag,'N'),'Y','N'
6124: ,'N',decode(bl.txn_cost_rate_override,0,'Y','N'))))
6125: FROM pa_budget_lines bl
6126: ,pa_resource_assignments ra
6127: ,pa_fp_spread_calc_tmp tmp
6128: WHERE tmp.budget_version_id = p_budget_version_id
6129: AND (NVL(tmp.refresh_rates_flag,'N') in ('Y','R','C')
6130: OR NVL(tmp.refresh_conv_rates_flag,'N') = 'Y'

Line 6718: -- pa_resource_assignments based on a resource_assignment_id and txn_currency_code

6714: END mass_adjust_new;
6715:
6716: /*
6717: -- FUNCTION get_resource_list_member_id is used to get the resource_list_member_id from
6718: -- pa_resource_assignments based on a resource_assignment_id and txn_currency_code
6719: */
6720:
6721: FUNCTION get_resource_list_member_id
6722: ( p_resource_assignment_id IN NUMBER) RETURN NUMBER IS

Line 6728: FROM pa_resource_assignments

6724: x_resource_list_member_id NUMBER := NULL;
6725:
6726: CURSOR get_res_list_member_csr IS
6727: SELECT resource_list_member_id
6728: FROM pa_resource_assignments
6729: WHERE resource_assignment_id = p_resource_assignment_id;
6730:
6731: get_res_list_member_rec get_res_list_member_csr%ROWTYPE;
6732:

Line 6752: -- pa_budget_line to pa_resource_assignments

6748:
6749: /*
6750: -- PROCEDURE rollup_pf_pfc_to_ra is called from PROCEDURE calculate
6751: -- This procedure is called to Rollup PC and PFC numbers stored in
6752: -- pa_budget_line to pa_resource_assignments
6753: */
6754: -- gboomina for AAI Requirement - Start
6755: -- Modifying this procedure to take calling module as a parameter
6756: -- so that this api can be called from Collect actuals flow

Line 6849: UPDATE PA_RESOURCE_ASSIGNMENTS ra

6845: l_login_id := fnd_global.login_id;
6846: /* Bug fix: 4251858 */
6847: -- gboomina AAI Requirement - Start
6848: if (p_calling_module = 'CALCULATE_API') then
6849: UPDATE PA_RESOURCE_ASSIGNMENTS ra
6850: SET ra.total_plan_quantity = null
6851: ,ra.total_plan_raw_cost = null
6852: ,ra.total_plan_burdened_cost = null
6853: ,ra.total_plan_revenue = null

Line 6911: UPDATE PA_RESOURCE_ASSIGNMENTS ra

6907: -- gboomina AAI Requirement - End
6908:
6909: IF l_resource_assignment_id_tab.COUNT > 0 THEN
6910: FORALL i IN l_resource_assignment_id_tab.FIRST .. l_resource_assignment_id_tab.LAST
6911: UPDATE PA_RESOURCE_ASSIGNMENTS ra
6912: SET ra.total_plan_quantity = l_pfc_quantity_tab(i)
6913: ,ra.total_plan_raw_cost = l_pfc_raw_cost_tab(i)
6914: ,ra.total_plan_burdened_cost = l_pfc_burden_cost_tab(i)
6915: ,ra.total_plan_revenue = l_pfc_revenue_tab(i)

Line 6942: -- pa_resource_assignments to pa_budget_versions

6938:
6939: /*
6940: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6941: -- This procedure is called to Rollup PC and PFC numbers stored in
6942: -- pa_resource_assignments to pa_budget_versions
6943: */
6944: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6945: ,x_return_status OUT NOCOPY VARCHAR2
6946: ,x_msg_count OUT NOCOPY NUMBER

Line 6994: FROM pa_resource_assignments pra

6990: ,DECODE(sum(total_project_burdened_cost),0,NULL,
6991: sum(total_project_burdened_cost)) total_project_burdened_cost
6992: ,DECODE(sum(total_project_revenue),0,NULL,
6993: sum(total_project_revenue)) total_project_revenue
6994: FROM pa_resource_assignments pra
6995: WHERE pra.budget_version_id = p_budget_version_id
6996: AND pra.project_id = g_project_id;
6997:
6998: rollup_ra_rec rollup_ra_csr%ROWTYPE;

Line 7243: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

7239:
7240:
7241: PROCEDURE convert_ra_txn_currency
7242: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7243: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7244: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7245: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7246: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7247: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE

Line 7653: ,pa_resource_assignments ra

7649: cursor cur_nullBls is
7650: select tmp1.resource_assignment_id
7651: ,tmp1.txn_currency_code
7652: from pa_fp_spread_calc_tmp tmp1
7653: ,pa_resource_assignments ra
7654: where tmp1.budget_version_id = p_budget_version_id
7655: and ra.resource_assignment_id = tmp1.resource_assignment_id
7656: and NVL(ra.rate_based_flag,'N') = 'N'
7657: and NOT EXISTS ( select /*+ INDEX(BL PA_BUDGET_LINES_U1) */ null

Line 8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

7997: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7998: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7999:
8000: --pa_resource_assignemts local variables--
8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

7998: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7999:
8000: --pa_resource_assignemts local variables--
8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

Line 8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;

7999:
8000: --pa_resource_assignemts local variables--
8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;

8000: --pa_resource_assignemts local variables--
8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8008: -- end of pa_resource_assignemts local variables--

Line 8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

8001: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8008: -- end of pa_resource_assignemts local variables--
8009:

Line 8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

8002: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8008: -- end of pa_resource_assignemts local variables--
8009:
8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total

Line 8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

8003: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
8004: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
8005: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
8006: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
8007: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
8008: -- end of pa_resource_assignemts local variables--
8009:
8010: --bug#14398131 :: added the following 3 variables l_txn_raw_cost_total, l_txn_burdened_cost_total and l_txn_revenue_total
8011: l_txn_raw_cost_total pa_fp_res_assignments_tmp.txn_raw_cost%TYPE;

Line 8139: FROM pa_resource_assignments ra

8135: ,ra.mfc_cost_type_id
8136: ,ra.sp_fixed_date
8137: ,ra.rate_based_flag
8138: ,rl.alias Resource_Name
8139: FROM pa_resource_assignments ra
8140: ,pa_resource_list_members rl
8141: WHERE ra.resource_assignment_id = p_resource_asg_id
8142: AND ra.resource_list_member_id = rl.resource_list_member_id ;
8143: ResAsgnRec get_resource_asn_csr%ROWTYPE;

Line 8181: ,pa_resource_assignments ra

8177: ,tmp.txn_init_revenue
8178: -- End for 6781055
8179: FROM pa_fp_rollup_tmp tmp
8180: ,pa_budget_versions bv
8181: ,pa_resource_assignments ra
8182: ,pa_resource_list_members rl
8183: WHERE bv.budget_version_id = p_budget_version_id
8184: AND ra.budget_version_id = bv.budget_version_id
8185: AND tmp.resource_assignment_id = ra.resource_assignment_id

Line 8198: ,pa_resource_assignments pra

8194: SELECT pt.name task_name
8195: ,prl.alias resource_name
8196: FROM pa_proj_elements pt
8197: ,pa_resource_list_members prl
8198: ,pa_resource_assignments pra
8199: WHERE pra.resource_assignment_id = p_resource_assignment_id
8200: AND pt.proj_element_id(+) = pra.task_id
8201: AND prl.resource_list_member_id = pra.resource_list_member_id;
8202:

Line 8614: populate with values from pa_resource_assignments using

8610: l_rlm_id_change_flag_tab := p_rlm_id_change_flag_tab;
8611: l_fp_task_billable_flag_tab := p_fp_task_billable_flag_tab;
8612: /*
8613: Check if p_resource_assignment_tab has values. If not try to
8614: populate with values from pa_resource_assignments using
8615: the budget_version_id. If there is still no values for
8616: resource assignment error and return. Else assign
8617: resource_assignment_ids to local variable l_resource_assignment_tab.
8618: l_resource_assignment_tab will be used instead of p_resource_assignment_tab

Line 11173: -- ROLLUP PC and PFC numbers to pa_resource_assignments

11169: END If;
11170:
11171:
11172: /*
11173: -- ROLLUP PC and PFC numbers to pa_resource_assignments
11174: -- For each resource_assignment in the l_resource_assignment_tab the
11175: -- numbers must be rolled up. Therefore a loop is required.
11176: */
11177: IF NVL(l_entire_return_status,'S') = 'S' Then

Line 11768: ,pa_resource_assignments ra

11764: ,caltmp.task_name
11765: ,caltmp.resource_name
11766: ,caltmp.billable_flag
11767: FROM pa_fp_spread_calc_tmp caltmp
11768: ,pa_resource_assignments ra
11769: WHERE caltmp.budget_version_id = p_budget_version_id
11770: AND caltmp.resource_assignment_id = ra.resource_assignment_id
11771: AND ( NVL(caltmp.skip_record_flag,'N') <> 'Y'
11772: OR

Line 11843: FROM pa_resource_assignments ra

11839: ,tmp.txn_init_revenue
11840: /* Bug fix:4294287 */
11841: ,tmp.bill_markup_percentage
11842: ,NVL(tmp.system_reference6,'Y') markup_calculation_flag
11843: FROM pa_resource_assignments ra
11844: ,pa_fp_rollup_tmp tmp
11845: ,pa_resource_list_members rl
11846: WHERE tmp.resource_assignment_id = p_resource_assignment_id
11847: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 15920: ,pa_resource_assignments ra

15916: ,bl.project_init_burdened_cost
15917: ,bl.project_init_revenue
15918: ,tmp.billable_flag
15919: FROM pa_budget_lines bl
15920: ,pa_resource_assignments ra
15921: ,pa_fp_spread_calc_tmp tmp
15922: ,pa_fp_rollup_tmp rlp --Bug 5203868
15923: WHERE tmp.budget_version_id = p_budget_version_id
15924: AND tmp.resource_assignment_id = ra.resource_assignment_id