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_BUDGET_LINES

Line 945: (p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE

941: END GET_RES_ASSIGNMENT_INFO ;
942:
943: /* Bug 5350437: Commented the below API
944: PROCEDURE VALIDATE_CHANGE_REASON_CODE
945: (p_change_reason_code IN pa_budget_lines.change_reason_code%TYPE
946: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
947: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
948: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
949: IS

Line 1061: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

1057:
1058: PROCEDURE VALIDATE_TXN_CURRENCY_CODE
1059: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
1060: ,p_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE
1061: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
1062: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1063: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1064: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
1065: IS

Line 1714: FROM PA_BUDGET_LINES bl

1710: AND b.txn_currency_code = a.txn_currency_code
1711: AND a.start_date <= b.end_date
1712: AND a.end_date >= b.start_date )
1713: OR EXISTS (SELECT 'Y'
1714: FROM PA_BUDGET_LINES bl
1715: WHERE bl.budget_version_id = p_budget_version_id
1716: AND bl.resource_assignment_id = a.resource_assignment_id
1717: AND bl.txn_currency_code = a.txn_currency_code
1718: AND bl.start_date <> a.start_date

Line 2753: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

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
2757: l_quantity number :=null;

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 2848: to new entity pa_resource_asgn_curr instead of pa_budget_lines.

2844: l_quantity :=null;
2845: else
2846: begin
2847: /* Bug 5144013 : Changed the following select queries to refer
2848: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
2849: This is done as part of merging the MRUP3 changes done in 11i into R12.
2850:
2851: if p_amount = 'QUANTITY' THEN
2852: select total_display_quantity into l_quantity

Line 2963: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

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
2967: l_quantity number :=null;

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 3067: to new entity pa_resource_asgn_curr instead of pa_budget_lines.

3063: l_quantity :=null;
3064: else
3065: begin
3066: /* Bug 5144013 : Changed the following select queries to refer
3067: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
3068: This is done as part of merging the MRUP3 changes done in 11i into R12.
3069: */
3070: if p_amount = 'QUANTITY' THEN
3071: select total_display_quantity into l_quantity

Line 3151: p_txn_curr_code pa_budget_lines.txn_currency_code%TYPE,

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
3155: l_quantity number :=null;

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 3207: to new entity pa_resource_asgn_curr instead of pa_budget_lines.

3203: l_quantity :=null;
3204: else
3205: begin
3206: /* Bug 5144013 : Changed the following select queries to refer
3207: to new entity pa_resource_asgn_curr instead of pa_budget_lines.
3208: This is done as part of merging the MRUP3 changes done in 11i into R12.
3209: */
3210: if p_amount = 'QUANTITY' THEN
3211: select total_display_quantity into l_quantity

Line 3287: a. display_quantity from pa_budget_lines is refered instead of quantity when p_amount_code

3283: FCST_BURDENED_COST,ACTUAL_QTY,ACTUAL_RAW_COST,ACTUAL_BURD_COST,ACTUAL_REVENUE,ETC_QTY,
3284: ETC_RAW_COST,ETC_BURDENED_COST,ETC_REVENUE
3285: =======================================================================================*/
3286: /* Bug 5144013: The following changes are made as part of merging the MRUP3 changes done in 11i into R12,
3287: a. display_quantity from pa_budget_lines is refered instead of quantity when p_amount_code
3288: is TOTAL_QTY or FCST_QTY.
3289: b. Rates are shown only when the rate_based_flag of the resource assignment is 'Y'.
3290: */
3291: FUNCTION get_period_amounts(

Line 3294: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,

3290: */
3291: FUNCTION get_period_amounts(
3292: p_budget_version_id NUMBER,
3293: p_amount_code VARCHAR2,
3294: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,
3295: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,
3296: p_prd_start_date DATE,
3297: p_prd_end_date DATE,
3298: preceding_date DATE,

Line 3295: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,

3291: FUNCTION get_period_amounts(
3292: p_budget_version_id NUMBER,
3293: p_amount_code VARCHAR2,
3294: p_resource_assignment_id pa_budget_lines.resource_assignment_id%TYPE,
3295: p_txn_currency_code pa_budget_lines.txn_currency_code%TYPE,
3296: p_prd_start_date DATE,
3297: p_prd_end_date DATE,
3298: preceding_date DATE,
3299: succedeing_date DATE)

Line 3379: from pa_budget_lines bl,

3375: 'ETC_RAW_COST',sum(bl.txn_raw_cost-nvl(bl.txn_init_raw_cost,0)),
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