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 384: -- Standard

380: --p_old_task_sch_finish DATE, YES Old Task Sch. Finish
381: --p_new_task_sch_start DATE, YES New Task Sch. Start
382: --p_new_task_sch_finish DATE, YES New Task Sch. Finish
383: -- Out parameters
384: -- Standard
385:
386:
387: PROCEDURE Adjust_Asgmt_Dates
388: (

Line 5517: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5513:
5514: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5515:
5516:
5517: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5518:
5519: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5520:
5521: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5519: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5515:
5516:
5517: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5518:
5519: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5520:
5521: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5522:
5523: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5521: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5517: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5518:
5519: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5520:
5521: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5522:
5523: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5524:
5525:

Line 5523: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5519: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5520:
5521: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5522:
5523: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5524:
5525:
5526:
5527: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5533: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5529: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5530:
5531: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5532:
5533: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5534:
5535: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5536:
5537: l_margin_txn_cur NUMBER;

Line 5535: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5531: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5532:
5533: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5534:
5535: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5536:
5537: l_margin_txn_cur NUMBER;
5538:
5539: l_margin_proj_cur NUMBER;

Line 5545: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5541: l_margin_proj_func_cur NUMBER;
5542:
5543: l_margin_pct NUMBER;
5544:
5545: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5546:
5547: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5548:
5549: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5547: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5543: l_margin_pct NUMBER;
5544:
5545: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5546:
5547: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5548:
5549: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5550:
5551: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5549: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5545: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5546:
5547: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5548:
5549: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5550:
5551: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5552:
5553: l_return_status VARCHAR2(1);

Line 5700: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5696:
5697: l_planning_end_date pa_resource_assignments.planning_start_date%TYPE;
5698:
5699:
5700: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5701:
5702: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5703:
5704: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5702: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5698:
5699:
5700: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5701:
5702: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5703:
5704: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5705:
5706: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

Line 5704: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5700: l_init_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5701:
5702: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5703:
5704: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5705:
5706: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5707:
5708:

Line 5706: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;

5702: l_avg_raw_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5703:
5704: l_init_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5705:
5706: l_avg_burd_cost_rate pa_budget_lines.txn_standard_cost_rate%TYPE;
5707:
5708:
5709:
5710: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

Line 5716: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5712: l_revenue_proj_cur pa_resource_assignments.total_project_revenue%TYPE;
5713:
5714: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5715:
5716: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5717:
5718: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5719:
5720: l_margin_txn_cur NUMBER;

Line 5718: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5714: l_revenue_proj_func_cur pa_resource_assignments.total_plan_revenue%TYPE;
5715:
5716: l_init_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5717:
5718: l_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5719:
5720: l_margin_txn_cur NUMBER;
5721:
5722: l_margin_proj_cur NUMBER;

Line 5728: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5724: l_margin_proj_func_cur NUMBER;
5725:
5726: l_margin_pct NUMBER;
5727:
5728: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5729:
5730: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5731:
5732: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

Line 5730: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5726: l_margin_pct NUMBER;
5727:
5728: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5729:
5730: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5731:
5732: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5733:
5734: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

Line 5732: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;

5728: l_etc_avg_rev_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5729:
5730: l_etc_avg_raw_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5731:
5732: l_etc_avg_burd_cost_rate pa_budget_lines.txn_standard_bill_rate%TYPE;
5733:
5734: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;
5735:
5736: l_return_status VARCHAR2(1);

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

5874: SUM(bl.project_init_burdened_cost) as act_bur_cost_pc_cur,
5875: SUM(bl.project_init_raw_cost) as act_raw_cost_pc_cur,
5876: SUM(bl.init_burdened_cost) as act_bur_cost_pfc_cur,
5877: SUM(bl.init_raw_cost) as act_raw_cost_pfc_cur,
5878: AVG(nvl(bl.txn_cost_rate_override, bl.txn_standard_cost_rate)) as avg_raw_cost_rate,
5879: AVG(bl.burden_cost_rate) as avg_bur_cost_rate
5880: FROM pa_budget_lines bl
5881: WHERE bl.resource_assignment_id = p_resource_assignment_id
5882: GROUP BY bl.resource_assignment_id;