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 1299: * Based on the statistics collected for the pa_budget_lines and pa_resource_assignments on pjperf table

1295: END CHECK_MRC_INSTALLED;
1296:
1297: /* This API will set the statistics for global tmp tables. Since Gather_statistics and set_table_stats
1298: * does the commit in the main session, this api made as autonomous so that main session should not be impacted.
1299: * Based on the statistics collected for the pa_budget_lines and pa_resource_assignments on pjperf table
1300: * the tmp table stats will be set as follows
1301: * If number of rows < 500 then set the number of rows = 500 and num blocks to number of rows/30
1302: * if number of rows > 500 then set the number of rows to passed in value and block size to numrows / 30
1303: * This API will be called only once for all tmp tables

Line 3323: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3319: FETCH cur_EvenSpCur INTO l_evenSpCurveId;
3320: CLOSE cur_EvenSpCur;
3321:
3322: g_stage :='Reset_Planning_end_date:100';
3323: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3324: SET ra.spread_curve_id = DECODE(ra.spread_curve_id,6
3325: ,decode(sign(nvl(ra.sp_fixed_date,p_etc_start_date) - p_etc_start_date),-1,l_evenSpCurveId,ra.spread_curve_id)
3326: ,ra.spread_curve_id)
3327: ,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 3344: From pa_resource_assignments ra

3340: /* For Non-Time phase budgets, Update the budget lines with planning start and planning end dates */
3341: g_stage :='Reset_Planning_end_date:101';
3342: UPDATE pa_budget_lines bl
3343: SET bl.end_date = (select ra.planning_end_date
3344: From pa_resource_assignments ra
3345: Where ra.resource_assignment_id = bl.resource_assignment_id)
3346: WHERE bl.budget_version_id = p_budget_version_id
3347: AND EXISTS ( SELECT 'Y'
3348: FROM pa_resource_assignments pra

Line 3348: FROM pa_resource_assignments pra

3344: From pa_resource_assignments ra
3345: Where ra.resource_assignment_id = bl.resource_assignment_id)
3346: WHERE bl.budget_version_id = p_budget_version_id
3347: AND EXISTS ( SELECT 'Y'
3348: FROM pa_resource_assignments pra
3349: ,pa_fp_spread_calc_tmp tmp
3350: WHERE pra.resource_assignment_id = bl.resource_assignment_id
3351: AND pra.budget_version_id = bl.budget_version_id
3352: AND tmp.budget_version_id = pra.budget_version_id

Line 3387: ,pa_resource_assignments ra

3383:
3384: CURSOR cur_spbl_chk IS
3385: SELECT tmp.resource_assignment_id
3386: FROM pa_fp_spread_calc_tmp tmp
3387: ,pa_resource_assignments ra
3388: WHERE tmp.budget_version_id = p_budget_version_id
3389: AND tmp.resource_assignment_id = ra.resource_assignment_id
3390: AND NVL(tmp.sp_curve_change_flag,'N') = 'N'
3391: /* Bug fix: AND ra.sp_fixed_date is NOT NULL this is commented as in some ofthe flows,

Line 3500: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3496:
3497: --print_msg('More than one budget Line exists for Spread Curve Fixed Date');
3498: FORALL i IN l_raId_tab.FIRST .. l_raId_tab.LAST
3499: /* update the RA and set sp_fixed_date to null so that spread api will spread the amts evenly */
3500: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3501: SET ra.spread_curve_id = l_evenSpCurveId
3502: ,ra.sp_fixed_date = NULL
3503: /* bug fix:4122400 for fixed date spread curve, change the plan end date as ETC start date */
3504: /* Bug fix: 4247427 ,ra.planning_end_date = p_etc_start_date

Line 3575: ,pa_resource_assignments ra

3571: SELECT 'Y'
3572: FROM DUAL
3573: WHERE EXISTS (select null
3574: from pa_budget_lines bl
3575: ,pa_resource_assignments ra
3576: where ra.resource_assignment_id = p_res_ass_id
3577: and bl.resource_assignment_id = ra.resource_assignment_id
3578: and bl.txn_currency_code = p_txn_currency_code
3579: and ra.sp_fixed_date is NOT NULL

Line 3621: UPDATE PA_RESOURCE_ASSIGNMENTS ra

3617: FETCH cur_EvenSpCur INTO l_evenSpCurveId;
3618: CLOSE cur_EvenSpCur;
3619: --print_msg('More than one budget Line exists for Spread Curve Fixed Date');
3620: /* update the RA and set sp_fixed_date to null so that spread api will spread the amts evenly */
3621: UPDATE PA_RESOURCE_ASSIGNMENTS ra
3622: SET ra.spread_curve_id = l_evenSpCurveId
3623: ,ra.sp_fixed_date = NULL
3624: /* bug fix:4122400 for fixed date spread curve, change the plan end date as ETC start date */
3625: ,ra.planning_end_date = p_etc_start_date

Line 3876: ,pa_resource_assignments ra

3872: ,bl.burden_rejection_code
3873: ,bl.pfc_cur_conv_rejection_code
3874: ,bl.pc_cur_conv_rejection_code
3875: FROM pa_budget_lines bl
3876: ,pa_resource_assignments ra
3877: ,pa_fp_spread_calc_tmp tmp
3878: WHERE tmp.budget_version_id = p_budget_version_id
3879: AND bl.resource_assignment_id = tmp.resource_assignment_id
3880: AND bl.txn_currency_code = tmp.txn_currency_code

Line 4744: ,pa_resource_assignments ra

4740: ,decode(p_generation_context,'REVENUE_MARKUP',
4741: decode(fptmp.revenue_bill_rate,NULL,'Y','N'),'Y') markup_calculation_flag
4742: FROM pa_fp_rollup_tmp tmp
4743: ,pa_fp_gen_rate_tmp fptmp
4744: ,pa_resource_assignments ra
4745: ,pa_fp_spread_calc_tmp caltmp
4746: WHERE caltmp.budget_version_id = p_budget_version_id
4747: AND caltmp.resource_assignment_id = ra.resource_assignment_id
4748: AND nvl(caltmp.skip_record_flag,'N') <> 'Y'

Line 4780: ,pa_resource_assignments ra

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

Line 4984: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

4980: and the budget start date is greater than ETC start date
4981: */
4982: PROCEDURE delete_budget_lines
4983: ( p_budget_version_id IN pa_budget_lines.budget_version_id%type
4984: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
4985: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
4986: ,p_line_start_date IN pa_budget_lines.start_date%TYPE
4987: ,p_line_end_date IN pa_budget_lines.end_date%TYPE
4988: ,p_source_context IN varchar2

Line 5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE

5602:
5603: PROCEDURE chk_req_rate_api_inputs
5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

Line 5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE

5603: PROCEDURE chk_req_rate_api_inputs
5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE

Line 5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE

5604: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE

Line 5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE

5605: ,p_budget_version_type IN pa_budget_versions.version_type%TYPE
5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE
5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

Line 5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE

5606: ,p_person_id IN pa_resource_assignments.person_id%TYPE
5607: ,p_job_id IN pa_resource_assignments.job_id%TYPE
5608: ,p_resource_class IN pa_resource_assignments.resource_class_code%TYPE
5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE
5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5614: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

Line 5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE

5609: ,p_rate_based_flag IN pa_resource_assignments.rate_based_flag%TYPE
5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE
5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5614: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5615: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5616: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5617: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE

Line 5614: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE

5610: ,p_uom IN pa_resource_assignments.unit_of_measure%TYPE
5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE
5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5614: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5615: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5616: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5617: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5618: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE

Line 5615: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE

5611: ,p_quantity IN pa_budget_lines.quantity%TYPE
5612: ,p_item_date IN pa_budget_lines.start_date%TYPE
5613: ,p_non_labor_resource IN pa_resource_assignments.non_labor_resource%TYPE
5614: ,p_expenditure_org_id IN pa_resource_assignments.rate_expenditure_org_id%TYPE
5615: ,p_nlr_organization_id IN pa_resource_assignments.organization_id%TYPE
5616: ,p_cost_override_rate IN pa_fp_res_assignments_tmp.rw_cost_rate_override%TYPE
5617: ,p_revenue_override_rate IN pa_fp_res_assignments_tmp.bill_rate_override%TYPE
5618: ,p_raw_cost IN pa_fp_res_assignments_tmp.txn_raw_cost%TYPE
5619: ,p_burden_cost IN pa_fp_res_assignments_tmp.txn_burdened_cost%TYPE

Line 6091: ,pa_resource_assignments ra

6087: ,decode(NVL(g_wp_version_flag,'N'),'Y','N'
6088: ,decode(nvl(ra.rate_based_flag,'N'),'Y','N'
6089: ,'N',decode(bl.txn_cost_rate_override,0,'Y','N'))))
6090: FROM pa_budget_lines bl
6091: ,pa_resource_assignments ra
6092: ,pa_fp_spread_calc_tmp tmp
6093: WHERE tmp.budget_version_id = p_budget_version_id
6094: AND (NVL(tmp.refresh_rates_flag,'N') in ('Y','R','C')
6095: OR NVL(tmp.refresh_conv_rates_flag,'N') = 'Y'

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

6679: END mass_adjust_new;
6680:
6681: /*
6682: -- FUNCTION get_resource_list_member_id is used to get the resource_list_member_id from
6683: -- pa_resource_assignments based on a resource_assignment_id and txn_currency_code
6684: */
6685:
6686: FUNCTION get_resource_list_member_id
6687: ( p_resource_assignment_id IN NUMBER) RETURN NUMBER IS

Line 6693: FROM pa_resource_assignments

6689: x_resource_list_member_id NUMBER := NULL;
6690:
6691: CURSOR get_res_list_member_csr IS
6692: SELECT resource_list_member_id
6693: FROM pa_resource_assignments
6694: WHERE resource_assignment_id = p_resource_assignment_id;
6695:
6696: get_res_list_member_rec get_res_list_member_csr%ROWTYPE;
6697:

Line 6716: -- pa_budget_line to pa_resource_assignments

6712:
6713: /*
6714: -- PROCEDURE rollup_pf_pfc_to_ra is called from PROCEDURE calculate
6715: -- This procedure is called to Rollup PC and PFC numbers stored in
6716: -- pa_budget_line to pa_resource_assignments
6717: */
6718:
6719: PROCEDURE rollup_pf_pfc_to_ra
6720: ( p_budget_version_id IN NUMBER

Line 6782: UPDATE PA_RESOURCE_ASSIGNMENTS ra

6778: x_return_status := 'S';
6779: l_user_id := fnd_global.user_id;
6780: l_login_id := fnd_global.login_id;
6781: /* Bug fix: 4251858 */
6782: UPDATE PA_RESOURCE_ASSIGNMENTS ra
6783: SET ra.total_plan_quantity = null
6784: ,ra.total_plan_raw_cost = null
6785: ,ra.total_plan_burdened_cost = null
6786: ,ra.total_plan_revenue = null

Line 6821: UPDATE PA_RESOURCE_ASSIGNMENTS ra

6817: CLOSE rollup_bl_csr;
6818:
6819: IF l_resource_assignment_id_tab.COUNT > 0 THEN
6820: FORALL i IN l_resource_assignment_id_tab.FIRST .. l_resource_assignment_id_tab.LAST
6821: UPDATE PA_RESOURCE_ASSIGNMENTS ra
6822: SET ra.total_plan_quantity = l_pfc_quantity_tab(i)
6823: ,ra.total_plan_raw_cost = l_pfc_raw_cost_tab(i)
6824: ,ra.total_plan_burdened_cost = l_pfc_burden_cost_tab(i)
6825: ,ra.total_plan_revenue = l_pfc_revenue_tab(i)

Line 6852: -- pa_resource_assignments to pa_budget_versions

6848:
6849: /*
6850: -- PROCEDURE rollup_pf_pfc_to_bv is called from PROCEDURE calculate
6851: -- This procedure is called to Rollup PC and PFC numbers stored in
6852: -- pa_resource_assignments to pa_budget_versions
6853: */
6854: PROCEDURE rollup_pf_pfc_to_bv ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
6855: ,x_return_status OUT NOCOPY VARCHAR2
6856: ,x_msg_count OUT NOCOPY NUMBER

Line 6904: FROM pa_resource_assignments pra

6900: ,DECODE(sum(total_project_burdened_cost),0,NULL,
6901: sum(total_project_burdened_cost)) total_project_burdened_cost
6902: ,DECODE(sum(total_project_revenue),0,NULL,
6903: sum(total_project_revenue)) total_project_revenue
6904: FROM pa_resource_assignments pra
6905: WHERE pra.budget_version_id = p_budget_version_id
6906: AND pra.project_id = g_project_id;
6907:
6908: rollup_ra_rec rollup_ra_csr%ROWTYPE;

Line 7153: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

7149:
7150:
7151: PROCEDURE convert_ra_txn_currency
7152: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7153: ,p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
7154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
7155: ,p_budget_line_id IN pa_budget_lines.budget_line_id%TYPE
7156: ,p_txn_raw_cost IN pa_fp_rollup_tmp.txn_raw_cost%TYPE
7157: ,p_txn_burdened_cost IN pa_fp_rollup_tmp.txn_burdened_cost%TYPE

Line 7563: ,pa_resource_assignments ra

7559: cursor cur_nullBls is
7560: select tmp1.resource_assignment_id
7561: ,tmp1.txn_currency_code
7562: from pa_fp_spread_calc_tmp tmp1
7563: ,pa_resource_assignments ra
7564: where tmp1.budget_version_id = p_budget_version_id
7565: and ra.resource_assignment_id = tmp1.resource_assignment_id
7566: and NVL(ra.rate_based_flag,'N') = 'N'
7567: and NOT EXISTS ( select /*+ INDEX(BL PA_BUDGET_LINES_U1) */ null

Line 7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;

7907: l_neg_Burd_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:
7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

Line 7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;

7908: l_neg_rev_Changflag_tab SYSTEM.pa_varchar2_1_tbl_type DEFAULT SYSTEM.pa_varchar2_1_tbl_type();
7909:
7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

Line 7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;

7909:
7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

Line 7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;

7910: --pa_resource_assignemts local variables--
7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
7918: -- end of pa_resource_assignemts local variables--

Line 7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;

7911: l_resource_assignment_id pa_resource_assignments.resource_assignment_id%TYPE;
7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
7918: -- end of pa_resource_assignemts local variables--
7919:

Line 7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;

7912: l_planning_start_date pa_resource_assignments.planning_start_date%TYPE;
7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
7918: -- end of pa_resource_assignemts local variables--
7919:
7920: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;

Line 7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;

7913: l_planning_end_date pa_resource_assignments.planning_end_date%TYPE;
7914: l_spread_curve_id pa_resource_assignments.spread_curve_id%TYPE;
7915: l_resource_class_code pa_resource_assignments.resource_class_code%TYPE;
7916: l_sp_fixed_date pa_resource_assignments.sp_fixed_date%TYPE;
7917: l_rate_based_flag pa_resource_assignments.rate_based_flag%TYPE;
7918: -- end of pa_resource_assignemts local variables--
7919:
7920: l_txn_currency_code pa_fp_res_assignments_tmp.txn_currency_code%TYPE;
7921: l_txn_revenue pa_fp_res_assignments_tmp.txn_revenue%TYPE;

Line 8034: FROM pa_resource_assignments ra

8030: ,ra.mfc_cost_type_id
8031: ,ra.sp_fixed_date
8032: ,ra.rate_based_flag
8033: ,rl.alias Resource_Name
8034: FROM pa_resource_assignments ra
8035: ,pa_resource_list_members rl
8036: WHERE ra.resource_assignment_id = p_resource_asg_id
8037: AND ra.resource_list_member_id = rl.resource_list_member_id ;
8038: ResAsgnRec get_resource_asn_csr%ROWTYPE;

Line 8076: ,pa_resource_assignments ra

8072: ,tmp.txn_init_revenue
8073: -- End for 6781055
8074: FROM pa_fp_rollup_tmp tmp
8075: ,pa_budget_versions bv
8076: ,pa_resource_assignments ra
8077: ,pa_resource_list_members rl
8078: WHERE bv.budget_version_id = p_budget_version_id
8079: AND ra.budget_version_id = bv.budget_version_id
8080: AND tmp.resource_assignment_id = ra.resource_assignment_id

Line 8093: ,pa_resource_assignments pra

8089: SELECT pt.name task_name
8090: ,prl.alias resource_name
8091: FROM pa_proj_elements pt
8092: ,pa_resource_list_members prl
8093: ,pa_resource_assignments pra
8094: WHERE pra.resource_assignment_id = p_resource_assignment_id
8095: AND pt.proj_element_id(+) = pra.task_id
8096: AND prl.resource_list_member_id = pra.resource_list_member_id;
8097:

Line 8507: populate with values from pa_resource_assignments using

8503: l_rlm_id_change_flag_tab := p_rlm_id_change_flag_tab;
8504: l_fp_task_billable_flag_tab := p_fp_task_billable_flag_tab;
8505: /*
8506: Check if p_resource_assignment_tab has values. If not try to
8507: populate with values from pa_resource_assignments using
8508: the budget_version_id. If there is still no values for
8509: resource assignment error and return. Else assign
8510: resource_assignment_ids to local variable l_resource_assignment_tab.
8511: l_resource_assignment_tab will be used instead of p_resource_assignment_tab

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

10989: END If;
10990:
10991:
10992: /*
10993: -- ROLLUP PC and PFC numbers to pa_resource_assignments
10994: -- For each resource_assignment in the l_resource_assignment_tab the
10995: -- numbers must be rolled up. Therefore a loop is required.
10996: */
10997: IF NVL(l_entire_return_status,'S') = 'S' Then

Line 11588: ,pa_resource_assignments ra

11584: ,caltmp.task_name
11585: ,caltmp.resource_name
11586: ,caltmp.billable_flag
11587: FROM pa_fp_spread_calc_tmp caltmp
11588: ,pa_resource_assignments ra
11589: WHERE caltmp.budget_version_id = p_budget_version_id
11590: AND caltmp.resource_assignment_id = ra.resource_assignment_id
11591: AND ( NVL(caltmp.skip_record_flag,'N') <> 'Y'
11592: OR

Line 11663: FROM pa_resource_assignments ra

11659: ,tmp.txn_init_revenue
11660: /* Bug fix:4294287 */
11661: ,tmp.bill_markup_percentage
11662: ,NVL(tmp.system_reference6,'Y') markup_calculation_flag
11663: FROM pa_resource_assignments ra
11664: ,pa_fp_rollup_tmp tmp
11665: ,pa_resource_list_members rl
11666: WHERE tmp.resource_assignment_id = p_resource_assignment_id
11667: AND ra.resource_assignment_id = tmp.resource_assignment_id

Line 15708: ,pa_resource_assignments ra

15704: ,bl.project_init_burdened_cost
15705: ,bl.project_init_revenue
15706: ,tmp.billable_flag
15707: FROM pa_budget_lines bl
15708: ,pa_resource_assignments ra
15709: ,pa_fp_spread_calc_tmp tmp
15710: ,pa_fp_rollup_tmp rlp --Bug 5203868
15711: WHERE tmp.budget_version_id = p_budget_version_id
15712: AND tmp.resource_assignment_id = ra.resource_assignment_id