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.

[Home] [Help]

APPS.PA_FIN_PLAN_UTILS dependencies on PA_BUDGET_LINES

Line 218: from pa_budget_lines a,

214: begin
215:
216: select 'Y'
217: into l_exists
218: from pa_budget_lines a,
219: pa_resource_assignments b
220: where a.resource_assignment_id = b.resource_assignment_id
221: and b.budget_version_id = p_budget_version_id
222: and rownum < 2;

Line 251: from pa_budget_lines a,

247: begin
248:
249: select 'Y'
250: into l_exists
251: from pa_budget_lines a,
252: pa_resource_assignments b
253: where a.resource_assignment_id = b.resource_assignment_id
254: and b.budget_version_id = p_budget_version_id
255: and b.task_id = Nvl(p_task_id,b.task_id)

Line 2405: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

2401: ===================================================== */
2402:
2403:
2404: PROCEDURE Get_Peceding_Suceeding_Pd_Info
2405: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2406: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2407: ,x_preceding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2408: ,x_preceding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2409: ,x_succeeding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 2406: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

2402:
2403:
2404: PROCEDURE Get_Peceding_Suceeding_Pd_Info
2405: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2406: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2407: ,x_preceding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2408: ,x_preceding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2409: ,x_succeeding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
2410: ,x_succeeding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 2420: FROM pa_budget_lines

2416: CURSOR period_info_cur IS
2417: SELECT start_date
2418: ,end_date
2419: ,bucketing_period_code
2420: FROM pa_budget_lines
2421: WHERE resource_assignment_id = p_resource_assignment_id
2422: AND txn_currency_code = p_txn_currency_code
2423: AND bucketing_period_code in ('SD','PD');
2424:

Line 2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

2548: ===================================================== */
2549:
2550: PROCEDURE Get_Element_Proj_PF_Amounts
2551: (
2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

Line 2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

2549:
2550: PROCEDURE Get_Element_Proj_PF_Amounts
2551: (
2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

Line 2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895

2550: PROCEDURE Get_Element_Proj_PF_Amounts
2551: (
2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895

Line 2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895

2551: (
2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

Line 2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

2552: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

Line 2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

2553: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895

2554: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

2555: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2563: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

2556: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2557: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2558: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
2559: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
2560: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
2561: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2562: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2563: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2564: )

Line 2630: FROM pa_budget_lines

2626: ,x_projfunc_revenue
2627: ,x_project_raw_cost
2628: ,x_project_burdened_cost
2629: ,x_project_revenue
2630: FROM pa_budget_lines
2631: WHERE resource_assignment_id = p_resource_assignment_id
2632: AND txn_currency_code = p_txn_currency_code ;
2633: EXCEPTION
2634:

Line 3557: from pa_budget_lines bl,

3553: Select 'Y'
3554: Into l_return
3555: From dual
3556: Where exists (Select 'x'
3557: from pa_budget_lines bl,
3558: pa_budget_versions bv
3559: where bl.budget_version_id = bv.budget_version_id
3560: and bv.project_id = p_project_id)
3561: OR exists (Select 'x' -- included for bug 3224177

Line 3587: from pa_budget_lines bl,

3583: Select 'Y'
3584: Into l_return
3585: From dual
3586: Where exists (Select 'x'
3587: from pa_budget_lines bl,
3588: pa_budget_versions bv
3589: where bl.budget_version_id = bv.budget_version_id
3590: and bv.project_id = p_project_id)
3591: OR exists (Select 'x' -- included for bug 3224177

Line 5871: /* This function takes the returns est_quantity or labor_quantity (planned qty) from pa_budget_lines

5867: END IF;
5868: RAISE;
5869: END Get_Shifted_Period;
5870:
5871: /* This function takes the returns est_quantity or labor_quantity (planned qty) from pa_budget_lines
5872: based on the parameter p_quantity ('ESTIMATED','PLANNED'). This values are return for CI version
5873: if p_version_code is CTRL_ITEM_VERSION. If p_version_code CURRENT_BASELINED_VERSION then the qty
5874: is returned from the current baselined version */
5875: /* Bug 3749781: New allowed value for p_version_code : CURRENT_WORKING_VERSION

Line 5883: RETURN pa_budget_lines.quantity%TYPE is

5879: p_project_id IN NUMBER
5880: ,p_version_code IN VARCHAR2 /* CTRL_ITEM_VERSION or CURRENT_BASELINED_VERSION or CURRENT_WORKING_VERSION*/
5881: ,p_quantity_type IN VARCHAR2 /* ESTIMATED or PLANNED or EQUIPMENT */
5882: ,p_ci_id IN NUMBER)
5883: RETURN pa_budget_lines.quantity%TYPE is
5884:
5885: /* cur_ci_ver, cur_working_ver and cur_baselined_ver should have the same number and datatype of columns */
5886:
5887: cursor cur_ci_ver(c_version_type pa_budget_versions.version_type%TYPE,

Line 6160: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

6156: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6157: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6159: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6160: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
6161: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6162: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6163: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6164: ) IS

Line 6345: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

6341: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6342: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6343: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6344: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6345: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6346: ,p_amount_type_code IN VARCHAR2
6347: ,p_currency_type_code IN VARCHAR2
6348: ,p_calling_context IN VARCHAR2
6349: ,x_first_error_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

6660: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6661: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6662: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

Line 6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

6664: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6665: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6666: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

Line 6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

6668: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6669: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6670: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6671: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

Line 6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

6672: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6673: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6674: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6675: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6676: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6677: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6678: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6679: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6680: ,p_context IN VARCHAR2

Line 6698: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;

6694: l_loop_count NUMBER;
6695: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6696: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6697: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6698: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6699: l_validity_code VARCHAR2(30);*/
6700: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6701: l_pc_rev_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6702: l_pfc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 9611: , pa_budget_lines l

9607: SELECT sum(l.raw_cost)
9608: , sum(l.burdened_cost)
9609: FROM pa_budget_versions v
9610: , pa_resource_assignments a
9611: , pa_budget_lines l
9612: WHERE v.project_id = p_project_id
9613: AND v.budget_type_code = p_budget_type_code
9614: AND v.current_flag = 'Y'
9615: AND v.budget_version_id = a.budget_version_id

Line 9644: , pa_budget_lines l

9640: SELECT sum(l.raw_cost)
9641: , sum(l.burdened_cost)
9642: FROM pa_budget_versions v
9643: , pa_resource_assignments a
9644: , pa_budget_lines l
9645: WHERE v.project_id = p_project_id
9646: AND v.budget_type_code = p_budget_type_code
9647: AND v.current_flag = 'Y'
9648: AND v.budget_version_id = a.budget_version_id

Line 11816: from pa_budget_lines

11812: into l_exists
11813: from dual
11814: where exists
11815: (select 1
11816: from pa_budget_lines
11817: where budget_version_id = p_budget_version_id
11818: and (cost_rejection_code IS NOT NULL
11819: OR revenue_rejection_code IS NOT NULL
11820: OR burden_rejection_code IS NOT NULL

Line 12055: pa_budget_lines bl

12051: INTO is_valid_flag
12052: FROM dual
12053: WHERE EXISTS (SELECT 1
12054: FROM pa_budget_versions bv,
12055: pa_budget_lines bl
12056: WHERE bv.project_id = p_project_id
12057: AND bv.wp_version_flag = 'Y'
12058: AND bv.budget_version_id = bl.budget_version_id
12059: AND bl.txn_currency_code <> l_currency_code);

Line 12070: FROM pa_budget_lines

12066: SELECT 'N'
12067: INTO is_valid_flag
12068: FROM dual
12069: WHERE EXISTS (SELECT 1
12070: FROM pa_budget_lines
12071: WHERE budget_version_id = p_budget_version_id
12072: AND txn_currency_code <> l_currency_code);
12073: EXCEPTION
12074: WHEN NO_DATA_FOUND THEN

Line 12194: ( select 1 from pa_budget_lines bl

12190: BEGIN
12191: SELECT 'N' INTO l_delete_ok_flag
12192: FROM DUAL
12193: WHERE EXISTS
12194: ( select 1 from pa_budget_lines bl
12195: where bl.budget_version_id = p_fin_plan_version_id
12196: and bl.txn_currency_code = p_txn_currency_code
12197: );
12198: EXCEPTION

Line 12214: ( select 1 from pa_budget_versions bv, pa_budget_lines bl

12210: BEGIN
12211: SELECT 'N' INTO l_delete_ok_flag
12212: FROM DUAL
12213: WHERE EXISTS
12214: ( select 1 from pa_budget_versions bv, pa_budget_lines bl
12215: where bv.project_id = p_project_id
12216: and bv.wp_version_flag = 'Y'
12217: and bl.budget_version_id = bv.budget_version_id
12218: and bl.txn_currency_code = p_txn_currency_code

Line 12298: FROM pa_budget_lines bl,

12294: Begin
12295: SELECT 'Y' INTO l_amounts_exist_flag
12296: FROM dual WHERE EXISTS
12297: (SELECT 1
12298: FROM pa_budget_lines bl,
12299: pa_budget_versions bv
12300: WHERE bv.project_id = p_project_id
12301: AND bv.wp_version_flag = 'Y'
12302: AND bl.budget_version_id = bv.budget_version_id);

Line 12466: FROM pa_budget_lines bl,

12462: Begin
12463: SELECT 'Y' INTO l_amounts_exist_flag
12464: FROM dual WHERE EXISTS
12465: (SELECT 1
12466: FROM pa_budget_lines bl,
12467: pa_budget_versions bv
12468: WHERE bv.project_id = p_project_id
12469: AND bv.fin_plan_type_id = p_fin_plan_type_id
12470: AND bl.budget_version_id = bv.budget_version_id);

Line 13567: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null

13563: */
13564:
13565: FUNCTION Get_NP_RA_Description
13566: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13567: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
13568: ) RETURN VARCHAR2
13569: IS
13570: l_description pa_budget_lines.description%TYPE;
13571: begin

Line 13570: l_description pa_budget_lines.description%TYPE;

13566: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13567: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
13568: ) RETURN VARCHAR2
13569: IS
13570: l_description pa_budget_lines.description%TYPE;
13571: begin
13572:
13573: select description
13574: into l_description

Line 13575: from pa_budget_lines

13571: begin
13572:
13573: select description
13574: into l_description
13575: from pa_budget_lines
13576: where resource_assignment_id = p_resource_assignment_id
13577: and txn_currency_code = p_txn_currency_code;
13578:
13579: return l_description;

Line 13596: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,

13592: */
13593:
13594: FUNCTION Get_Change_Reason
13595: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13596: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
13597: p_time_phased_code IN varchar2
13598: ) RETURN VARCHAR2
13599: IS
13600: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;

Line 13600: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;

13596: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
13597: p_time_phased_code IN varchar2
13598: ) RETURN VARCHAR2
13599: IS
13600: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;
13601: l_chg_rsn varchar2(80) := null;
13602: begin
13603:
13604: If p_time_phased_code <> 'N' Then

Line 13617: from pa_budget_lines

13613: End if;
13614:
13615: select change_reason_code
13616: into l_chg_rsn_code
13617: from pa_budget_lines
13618: where resource_assignment_id = p_resource_assignment_id
13619: and txn_currency_code = p_txn_currency_code;
13620:
13621: IF l_chg_rsn_code is not null Then