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_TASK_ASSIGNMENT_UTILS dependencies on STANDARD

Line 449: -- Standard

445: --p_old_task_sch_finish DATE, YES Old Task Sch. Finish
446: --p_new_task_sch_start DATE, YES New Task Sch. Start
447: --p_new_task_sch_finish DATE, YES New Task Sch. Finish
448: -- Out parameters
449: -- Standard
450:
451:
452: PROCEDURE Adjust_Asgmt_Dates
453: (

Line 5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5629:
5630: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5631:
5632:
5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5631:
5632:
5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5633: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5634:
5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5640:
5641:

Line 5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5635: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5636:
5637: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5638:
5639: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5640:
5641:
5642:
5643: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5645: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5646:
5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5650:
5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5652:
5653: l_margin_txn_cur NUMBER;

Line 5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5647: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5648:
5649: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5650:
5651: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5652:
5653: l_margin_txn_cur NUMBER;
5654:
5655: l_margin_proj_cur NUMBER;

Line 5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5657: l_margin_proj_func_cur NUMBER;
5658:
5659: l_margin_pct NUMBER;
5660:
5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5659: l_margin_pct NUMBER;
5660:
5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5666:
5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5661: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5662:
5663: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5664:
5665: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5666:
5667: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5668:
5669: l_return_status VARCHAR2(1);

Line 5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5812:
5813: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5814:
5815:
5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5814:
5815:
5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5816: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5817:
5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5823:
5824:

Line 5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5818: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5819:
5820: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5821:
5822: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5823:
5824:
5825:
5826: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5828: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5829:
5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5833:
5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5835:
5836: l_margin_txn_cur NUMBER;

Line 5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5830: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5831:
5832: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5833:
5834: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5835:
5836: l_margin_txn_cur NUMBER;
5837:
5838: l_margin_proj_cur NUMBER;

Line 5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5840: l_margin_proj_func_cur NUMBER;
5841:
5842: l_margin_pct NUMBER;
5843:
5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5842: l_margin_pct NUMBER;
5843:
5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5849:
5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5844: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5845:
5846: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5847:
5848: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5849:
5850: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5851:
5852: l_return_status VARCHAR2(1);

Line 5994: AVG(nvl(bl.txn_cost_rate_override, bl.txn_standard_cost_rate)) as avg_raw_cost_rate,

5990: SUM(bl.project_init_burdened_cost) as act_bur_cost_pc_cur,
5991: SUM(bl.project_init_raw_cost) as act_raw_cost_pc_cur,
5992: SUM(bl.init_burdened_cost) as act_bur_cost_pfc_cur,
5993: SUM(bl.init_raw_cost) as act_raw_cost_pfc_cur,
5994: AVG(nvl(bl.txn_cost_rate_override, bl.txn_standard_cost_rate)) as avg_raw_cost_rate,
5995: AVG(bl.burden_cost_rate) as avg_bur_cost_rate
5996: FROM pa_budget_lines bl
5997: WHERE bl.resource_assignment_id = p_resource_assignment_id
5998: GROUP BY bl.resource_assignment_id;