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

Line 405: FROM pa_resource_assignments pra,

401:
402: -- 4497315.Perf Fix.SELECT query is changed.
403: CURSOR C1(l_budget_version_id number) IS
404: SELECT pt.start_date,pt.completion_date
405: FROM pa_resource_assignments pra,
406: pa_budget_versions pbv,
407: pa_tasks pt
408: WHERE pra.budget_version_id = pbv.budget_version_id
409: AND pbv.budget_version_id = l_budget_version_id

Line 608: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;

604: l_row_id ROWID;
605: ll_error_flag VARCHAR2(1);
606: l_track_as_labor_flag PA_RESOURCE_LIST_MEMBERS.TRACK_AS_LABOR_FLAG%TYPE;
607: l_dummy_res_list_id NUMBER;
608: l_unit_of_measure PA_RESOURCE_ASSIGNMENTS.UNIT_OF_MEASURE%TYPE;
609: l_dummy_id NUMBER;
610: l_return_status VARCHAR2(1);
611: l_msg_count NUMBER;
612: l_msg_data VARCHAR2(240);

Line 734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE

730:
731: END;
732:
733: PROCEDURE GET_RES_ASSIGNMENT_INFO
734: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE
735: ,p_planning_level IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE
736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895

Line 740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895

736: ,x_task_number OUT NOCOPY pa_tasks.task_number%TYPE --File.Sql.39 bug 4440895
737: ,x_task_id OUT NOCOPY pa_tasks.task_id%TYPE --File.Sql.39 bug 4440895
738: ,x_resource_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
739: ,x_resource_group_alias OUT NOCOPY pa_resource_list_members.alias%TYPE --File.Sql.39 bug 4440895
740: ,x_parent_assignment_id OUT NOCOPY pa_resource_assignments.parent_assignment_id%TYPE --File.Sql.39 bug 4440895
741: ,x_resource_list_member_id OUT NOCOPY pa_resource_list_members.resource_list_member_id%TYPE --File.Sql.39 bug 4440895
742: ,x_resource_id OUT NOCOPY pa_resource_list_members.resource_id%TYPE --File.Sql.39 bug 4440895
743: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
744: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 754: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;

750: l_data VARCHAR2(2000);
751: l_msg_data VARCHAR2(2000);
752: l_msg_index_out NUMBER;
753:
754: l_unit_of_measure pa_resource_assignments.unit_of_measure%TYPE;
755:
756: -- Cursor c_task_level_info selects the task_name,resource alias
757: -- and resource group alias for a resource assignment id .
758: -- This is fired when version planning level is not PROJECT

Line 772: ,pa_resource_assignments pra

768: ,pra.parent_assignment_id
769: ,prlm.resource_list_member_id
770: ,prlm.resource_id
771: FROM pa_tasks pt
772: ,pa_resource_assignments pra
773: ,pa_resource_list_members prlm
774: ,pa_resource_list_members prlm_parent
775: ,pa_resource_lists_all_bg prl
776: WHERE pra.resource_assignment_id = c_resource_assignment_id

Line 796: FROM pa_resource_assignments pra

792: ,pra.unit_of_measure
793: ,pra.parent_assignment_id
794: ,prlm.resource_list_member_id
795: ,prlm.resource_id
796: FROM pa_resource_assignments pra
797: ,pa_resource_list_members prlm
798: ,pa_resource_list_members prlm_parent
799: ,pa_resource_lists_all_bg prl
800: WHERE pra.resource_assignment_id = c_resource_assignment_id

Line 2752: p_uom pa_resource_assignments.unit_of_measure%TYPE,

2748: p_project_id NUMBER,
2749: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
2750: p_task_id NUMBER,
2751: p_resource_list_member_id NUMBER,
2752: p_uom pa_resource_assignments.unit_of_measure%TYPE,
2753: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
2754: p_amount VARCHAR2)
2755: RETURN NUMBER
2756: IS

Line 2769: from pa_budget_lines pbl, pa_resource_assignments pra

2765: l_amount number :=null;
2766:
2767: cursor bud_line_exists_cur is
2768: select 1
2769: from pa_budget_lines pbl, pa_resource_assignments pra
2770: where pra.project_id = p_project_id
2771: and pra.task_id = p_task_id
2772: and pra.resource_list_member_id = p_resource_list_member_id
2773: and pra.unit_of_measure = p_uom

Line 2854: pa_resource_assignments pra

2850:
2851: if p_amount = 'QUANTITY' THEN
2852: select total_display_quantity into l_quantity
2853: from pa_resource_asgn_curr rac,
2854: pa_resource_assignments pra
2855: where rac.budget_version_id = l_curr_bv_id
2856: and pra.budget_version_id = rac.budget_version_id
2857: and pra.task_id = p_task_id
2858: and pra.resource_list_member_id = p_resource_list_member_id

Line 2867: pa_resource_assignments pra

2863: elsif p_amount ='RAW_COST' then
2864:
2865: select total_txn_raw_cost into l_quantity
2866: from pa_resource_asgn_curr rac,
2867: pa_resource_assignments pra
2868: where rac.budget_version_id = l_curr_bv_id
2869: and pra.budget_version_id = rac.budget_version_id
2870: and pra.task_id = p_task_id
2871: and pra.resource_list_member_id = p_resource_list_member_id

Line 2879: pa_resource_assignments pra

2875:
2876: elsif p_amount = 'BURDENED_COST' then
2877: select total_txn_burdened_cost into l_quantity
2878: from pa_resource_asgn_curr rac,
2879: pa_resource_assignments pra
2880: where rac.budget_version_id = l_curr_bv_id
2881: and pra.budget_version_id = rac.budget_version_id
2882: and pra.task_id = p_task_id
2883: and pra.resource_list_member_id = p_resource_list_member_id

Line 2890: pa_resource_assignments pra

2886: and rac.txn_currency_code = p_txn_curr_code;
2887: elsif p_amount = 'REVENUE' then
2888: select total_txn_revenue into l_quantity
2889: from pa_resource_asgn_curr rac,
2890: pa_resource_assignments pra
2891: where rac.budget_version_id = l_curr_bv_id
2892: and pra.budget_version_id = rac.budget_version_id
2893: and pra.task_id = p_task_id
2894: and pra.resource_list_member_id = p_resource_list_member_id

Line 2911: pa_resource_assignments pra

2907: ,l_txn_raw_cost
2908: ,l_txn_burdened_cost
2909: ,l_txn_revenue
2910: from pa_resource_asgn_curr rac,
2911: pa_resource_assignments pra
2912: where rac.budget_version_id = l_curr_bv_id
2913: and pra.project_id = p_project_id
2914: and pra.budget_version_id = rac.budget_version_id
2915: and pra.task_id = p_task_id

Line 2962: p_uom pa_resource_assignments.unit_of_measure%TYPE,

2958: p_project_id NUMBER,
2959: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
2960: p_task_id NUMBER,
2961: p_resource_list_member_id NUMBER,
2962: p_uom pa_resource_assignments.unit_of_measure%TYPE,
2963: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
2964: p_amount VARCHAR2)
2965: RETURN NUMBER
2966: IS

Line 2973: from pa_budget_lines pbl, pa_resource_assignments pra

2969: l_orig_bv_id number :=null;
2970:
2971: cursor bud_line_exists_cur is
2972: select 1
2973: from pa_budget_lines pbl, pa_resource_assignments pra
2974: where pra.project_id = p_project_id
2975: and pra.task_id = p_task_id
2976: and pra.resource_list_member_id = p_resource_list_member_id
2977: and pra.unit_of_measure = p_uom

Line 3073: pa_resource_assignments pra

3069: */
3070: if p_amount = 'QUANTITY' THEN
3071: select total_display_quantity into l_quantity
3072: from pa_resource_asgn_curr rac,
3073: pa_resource_assignments pra
3074: where rac.budget_version_id = l_orig_bv_id
3075: and pra.budget_version_id = rac.budget_version_id
3076: and pra.task_id = p_task_id
3077: and pra.resource_list_member_id = p_resource_list_member_id

Line 3086: pa_resource_assignments pra

3082: elsif p_amount ='RAW_COST' then
3083:
3084: select total_txn_raw_cost into l_quantity
3085: from pa_resource_asgn_curr rac,
3086: pa_resource_assignments pra
3087: where rac.budget_version_id = l_orig_bv_id
3088: and pra.budget_version_id = rac.budget_version_id
3089: and pra.task_id = p_task_id
3090: and pra.resource_list_member_id = p_resource_list_member_id

Line 3098: pa_resource_assignments pra

3094:
3095: elsif p_amount = 'BURDENED_COST' then
3096: select total_txn_burdened_cost into l_quantity
3097: from pa_resource_asgn_curr rac,
3098: pa_resource_assignments pra
3099: where rac.budget_version_id = l_orig_bv_id
3100: and pra.budget_version_id = rac.budget_version_id
3101: and pra.task_id = p_task_id
3102: and pra.resource_list_member_id = p_resource_list_member_id

Line 3109: pa_resource_assignments pra

3105: and rac.txn_currency_code = p_txn_curr_code;
3106: elsif p_amount = 'REVENUE' then
3107: select total_txn_revenue into l_quantity
3108: from pa_resource_asgn_curr rac,
3109: pa_resource_assignments pra
3110: where rac.budget_version_id = l_orig_bv_id
3111: and pra.budget_version_id = rac.budget_version_id
3112: and pra.task_id = p_task_id
3113: and pra.resource_list_member_id = p_resource_list_member_id

Line 3150: p_uom pa_resource_assignments.unit_of_measure%TYPE,

3146: p_project_id NUMBER,
3147: p_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE,
3148: p_task_id NUMBER,
3149: p_resource_list_member_id NUMBER,
3150: p_uom pa_resource_assignments.unit_of_measure%TYPE,
3151: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,
3152: p_amount VARCHAR2)
3153: RETURN NUMBER
3154: IS

Line 3161: from pa_budget_lines pbl, pa_resource_assignments pra

3157: l_pf_bv_id number :=null;
3158:
3159: cursor bud_line_exists_cur is
3160: select 1
3161: from pa_budget_lines pbl, pa_resource_assignments pra
3162: where pra.project_id = p_project_id
3163: and pra.task_id = p_task_id
3164: and pra.resource_list_member_id = p_resource_list_member_id
3165: and pra.unit_of_measure = p_uom

Line 3213: pa_resource_assignments pra

3209: */
3210: if p_amount = 'QUANTITY' THEN
3211: select total_display_quantity into l_quantity
3212: from pa_resource_asgn_curr rac,
3213: pa_resource_assignments pra
3214: where rac.budget_version_id = l_pf_bv_id
3215: and pra.budget_version_id = rac.budget_version_id
3216: and pra.task_id = p_task_id
3217: and pra.resource_list_member_id = p_resource_list_member_id

Line 3226: pa_resource_assignments pra

3222: elsif p_amount ='RAW_COST' then
3223:
3224: select total_txn_raw_cost into l_quantity
3225: from pa_resource_asgn_curr rac,
3226: pa_resource_assignments pra
3227: where rac.budget_version_id = l_pf_bv_id
3228: and pra.budget_version_id = rac.budget_version_id
3229: and pra.task_id = p_task_id
3230: and pra.resource_list_member_id = p_resource_list_member_id

Line 3238: pa_resource_assignments pra

3234:
3235: elsif p_amount = 'BURDENED_COST' then
3236: select total_txn_burdened_cost into l_quantity
3237: from pa_resource_asgn_curr rac,
3238: pa_resource_assignments pra
3239: where rac.budget_version_id = l_pf_bv_id
3240: and pra.budget_version_id = rac.budget_version_id
3241: and pra.task_id = p_task_id
3242: and pra.resource_list_member_id = p_resource_list_member_id

Line 3249: pa_resource_assignments pra

3245: and rac.txn_currency_code = p_txn_curr_code;
3246: elsif p_amount = 'REVENUE' then
3247: select total_txn_revenue into l_quantity
3248: from pa_resource_asgn_curr rac,
3249: pa_resource_assignments pra
3250: where rac.budget_version_id = l_pf_bv_id
3251: and pra.budget_version_id = rac.budget_version_id
3252: and pra.task_id = p_task_id
3253: and pra.resource_list_member_id = p_resource_list_member_id

Line 3380: pa_resource_assignments pra

3376: 'ETC_BURDENED_COST',sum(bl.txn_burdened_cost-nvl(bl.txn_init_burdened_cost,0)),
3377: 'ETC_REVENUE', sum(bl.txn_revenue-nvl(bl.txn_init_revenue,0)))
3378: into l_return
3379: from pa_budget_lines bl,
3380: pa_resource_assignments pra
3381: where bl.budget_version_id = p_budget_version_id
3382: and bl.resource_assignment_id = p_resource_assignment_id
3383: and bl.txn_currency_code = p_txn_currency_code
3384: and pra.resource_assignment_id = bl.resource_assignment_id