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 PA_BUDGET_LINES

Line 2856: from pa_budget_lines

2852: where project_id = c_project_id;
2853:
2854: CURSOR get_txn_currency_code (p_resource_assignment_id NUMBER) IS
2855: select txn_currency_code
2856: from pa_budget_lines
2857: where resource_assignment_id = p_resource_assignment_id
2858: and rownum = 1;
2859:
2860: l_add_cnt NUMBER := 0;

Line 2913: pa_budget_lines bl,

2909: pa_copy_asgmts_temp temp,
2910: pa_proj_element_versions pev,
2911: pa_resource_assignments ra,
2912: pa_project_assignments asgn,
2913: pa_budget_lines bl,
2914: pa_resource_list_members rlm,
2915: pa_res_formats_b rf
2916: WHERE
2917: pev.element_version_id = temp.src_elem_ver_id AND

Line 3018: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)

3014: ra.resource_class_code IN ( p_res_class1 , p_res_class2 , p_res_class3, p_res_class4 ) AND
3015: rlm.resource_list_member_id = ra.resource_list_member_id AND
3016: rf.res_format_id = rlm.res_format_id AND
3017: NOT EXISTS
3018: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)
3019: ) ORDER BY 5;
3020:
3021: CURSOR c_get_asgmts_for_copy_proj(p_res_class1 VARCHAR2, p_res_class2 VARCHAR2, p_res_class3 VARCHAR2, p_res_class4 VARCHAR2) IS
3022: SELECT * FROM

Line 3069: pa_budget_lines bl,

3065: pa_copy_asgmts_temp temp,
3066: pa_proj_element_versions pev,
3067: pa_resource_assignments ra,
3068: pa_project_assignments asgn,
3069: pa_budget_lines bl,
3070: pa_resource_list_members source_rlm,
3071: pa_resource_list_members target_rlm,
3072: pa_res_formats_b rf
3073: WHERE

Line 3186: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)

3182: decode(ra.project_assignment_id, -1, NULL, ra.project_assignment_id) = asgn.assignment_id(+) AND
3183: ra.resource_class_code IN ( p_res_class1 , p_res_class2 , p_res_class3, p_res_class4 ) AND
3184: rf.res_format_id = target_rlm.res_format_id AND
3185: NOT EXISTS
3186: (SELECT 1 FROM pa_budget_lines bl WHERE bl.resource_assignment_id = ra.resource_assignment_id)
3187: ) ORDER BY 5;
3188:
3189:
3190: l_num_of_tasks NUMBER;

Line 5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

5490: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5491:
5492: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5493:
5494: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5495:
5496: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5497:
5498: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

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 5527: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

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;
5528:
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;

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 5551: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

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);
5554:
5555: l_msg_count NUMBER;

Line 5562: FROM pa_budget_lines bl

5558:
5559:
5560: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5561: SELECT bl.txn_currency_code
5562: FROM pa_budget_lines bl
5563: WHERE bl.resource_assignment_id = p_resource_assignment_id
5564: AND rownum = 1;
5565:
5566:

Line 5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,

5673: p_element_version_id IN pa_proj_element_versions.element_version_id%TYPE,
5674:
5675: p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE,
5676:
5677: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE,
5678:
5679: p_proj_currency_code IN pa_projects_all.project_currency_code%TYPE,
5680:
5681: p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE,

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 5710: l_revenue_txn_cur pa_budget_lines.txn_revenue%TYPE;

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;
5711:
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;

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 5734: l_txn_currency_code pa_budget_lines.txn_currency_code%TYPE;

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);
5737:
5738: l_msg_count NUMBER;

Line 5745: FROM pa_budget_lines bl

5741:
5742:
5743: CURSOR get_txn_currency_code (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5744: SELECT bl.txn_currency_code
5745: FROM pa_budget_lines bl
5746: WHERE bl.resource_assignment_id = p_resource_assignment_id
5747: AND rownum = 1;
5748:
5749:

Line 5880: FROM pa_budget_lines bl

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;
5883:
5884: l_act_bur_cost_pc_cur NUMBER;

Line 5982: FROM pa_budget_lines bl

5978: p_code IN VARCHAR2) RETURN VARCHAR2 IS
5979:
5980: CURSOR get_bl_currency_info (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE) IS
5981: SELECT bl.txn_currency_code as txn_currency_code
5982: FROM pa_budget_lines bl
5983: WHERE bl.resource_assignment_id = p_resource_assignment_id
5984: AND rownum = 1;
5985:
5986: CURSOR get_proj_currency_info (p_project_id IN pa_projects_all.project_id%TYPE) IS