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_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 2403: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

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

Line 2404: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

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

Line 2418: FROM pa_budget_lines

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

Line 2550: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

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

Line 2551: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2628: FROM pa_budget_lines

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

Line 3555: from pa_budget_lines bl,

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

Line 3585: from pa_budget_lines bl,

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

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

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

Line 5881: RETURN pa_budget_lines.quantity%TYPE is

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

Line 6154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE

6150: ,p_projfunc_rev_rate_type IN pa_proj_fp_options.projfunc_rev_rate_type%TYPE
6151: ,p_projfunc_rev_rate_date_typ IN pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE
6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6153: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6154: ,p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE
6155: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6156: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
6157: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6158: ) IS

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

6335: PROCEDURE VALIDATE_CONV_ATTRIBUTES
6336: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6337: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6338: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6339: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6340: ,p_amount_type_code IN VARCHAR2
6341: ,p_currency_type_code IN VARCHAR2
6342: ,p_calling_context IN VARCHAR2
6343: ,x_first_error_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

6654: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
6655: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6656: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6657: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

6658: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6659: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
6660: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
6661: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

6662: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
6663: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6664: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6665: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6670: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

6666: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6667: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
6668: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
6669: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
6670: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
6671: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
6672: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6673: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
6674: ,p_context IN VARCHAR2

Line 6692: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;

6688: l_loop_count NUMBER;
6689: l_rate_type pa_proj_fp_options.project_cost_rate_type%TYPE;
6690: l_rate_date_type pa_proj_fp_options.project_cost_rate_date_type%TYPE;
6691: l_rate_date pa_proj_fp_options.project_cost_rate_date%TYPE;
6692: l_rate pa_budget_lines.project_rev_exchange_rate%TYPE ;
6693: l_validity_code VARCHAR2(30);*/
6694: l_pc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6695: l_pc_rev_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;
6696: l_pfc_cost_validity_code VARCHAR2(30) := PA_FP_CONSTANTS_PKG.G_VALID_CONV_ATTR;

Line 9605: , pa_budget_lines l

9601: SELECT sum(l.raw_cost)
9602: , sum(l.burdened_cost)
9603: FROM pa_budget_versions v
9604: , pa_resource_assignments a
9605: , pa_budget_lines l
9606: WHERE v.project_id = p_project_id
9607: AND v.budget_type_code = p_budget_type_code
9608: AND v.current_flag = 'Y'
9609: AND v.budget_version_id = a.budget_version_id

Line 9638: , pa_budget_lines l

9634: SELECT sum(l.raw_cost)
9635: , sum(l.burdened_cost)
9636: FROM pa_budget_versions v
9637: , pa_resource_assignments a
9638: , pa_budget_lines l
9639: WHERE v.project_id = p_project_id
9640: AND v.budget_type_code = p_budget_type_code
9641: AND v.current_flag = 'Y'
9642: AND v.budget_version_id = a.budget_version_id

Line 11810: from pa_budget_lines

11806: into l_exists
11807: from dual
11808: where exists
11809: (select 1
11810: from pa_budget_lines
11811: where budget_version_id = p_budget_version_id
11812: and (cost_rejection_code IS NOT NULL
11813: OR revenue_rejection_code IS NOT NULL
11814: OR burden_rejection_code IS NOT NULL

Line 12049: pa_budget_lines bl

12045: INTO is_valid_flag
12046: FROM dual
12047: WHERE EXISTS (SELECT 1
12048: FROM pa_budget_versions bv,
12049: pa_budget_lines bl
12050: WHERE bv.project_id = p_project_id
12051: AND bv.wp_version_flag = 'Y'
12052: AND bv.budget_version_id = bl.budget_version_id
12053: AND bl.txn_currency_code <> l_currency_code);

Line 12064: FROM pa_budget_lines

12060: SELECT 'N'
12061: INTO is_valid_flag
12062: FROM dual
12063: WHERE EXISTS (SELECT 1
12064: FROM pa_budget_lines
12065: WHERE budget_version_id = p_budget_version_id
12066: AND txn_currency_code <> l_currency_code);
12067: EXCEPTION
12068: WHEN NO_DATA_FOUND THEN

Line 12188: ( select 1 from pa_budget_lines bl

12184: BEGIN
12185: SELECT 'N' INTO l_delete_ok_flag
12186: FROM DUAL
12187: WHERE EXISTS
12188: ( select 1 from pa_budget_lines bl
12189: where bl.budget_version_id = p_fin_plan_version_id
12190: and bl.txn_currency_code = p_txn_currency_code
12191: );
12192: EXCEPTION

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

12204: BEGIN
12205: SELECT 'N' INTO l_delete_ok_flag
12206: FROM DUAL
12207: WHERE EXISTS
12208: ( select 1 from pa_budget_versions bv, pa_budget_lines bl
12209: where bv.project_id = p_project_id
12210: and bv.wp_version_flag = 'Y'
12211: and bl.budget_version_id = bv.budget_version_id
12212: and bl.txn_currency_code = p_txn_currency_code

Line 12292: FROM pa_budget_lines bl,

12288: Begin
12289: SELECT 'Y' INTO l_amounts_exist_flag
12290: FROM dual WHERE EXISTS
12291: (SELECT 1
12292: FROM pa_budget_lines bl,
12293: pa_budget_versions bv
12294: WHERE bv.project_id = p_project_id
12295: AND bv.wp_version_flag = 'Y'
12296: AND bl.budget_version_id = bv.budget_version_id);

Line 12460: FROM pa_budget_lines bl,

12456: Begin
12457: SELECT 'Y' INTO l_amounts_exist_flag
12458: FROM dual WHERE EXISTS
12459: (SELECT 1
12460: FROM pa_budget_lines bl,
12461: pa_budget_versions bv
12462: WHERE bv.project_id = p_project_id
12463: AND bv.fin_plan_type_id = p_fin_plan_type_id
12464: AND bl.budget_version_id = bv.budget_version_id);

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

13523: */
13524:
13525: FUNCTION Get_NP_RA_Description
13526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
13528: ) RETURN VARCHAR2
13529: IS
13530: l_description pa_budget_lines.description%TYPE;
13531: begin

Line 13530: l_description pa_budget_lines.description%TYPE;

13526: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13527: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
13528: ) RETURN VARCHAR2
13529: IS
13530: l_description pa_budget_lines.description%TYPE;
13531: begin
13532:
13533: select description
13534: into l_description

Line 13535: from pa_budget_lines

13531: begin
13532:
13533: select description
13534: into l_description
13535: from pa_budget_lines
13536: where resource_assignment_id = p_resource_assignment_id
13537: and txn_currency_code = p_txn_currency_code;
13538:
13539: return l_description;

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

13552: */
13553:
13554: FUNCTION Get_Change_Reason
13555: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
13556: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
13557: p_time_phased_code IN varchar2
13558: ) RETURN VARCHAR2
13559: IS
13560: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;

Line 13560: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;

13556: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
13557: p_time_phased_code IN varchar2
13558: ) RETURN VARCHAR2
13559: IS
13560: l_chg_rsn_code pa_budget_lines.change_reason_code%TYPE;
13561: l_chg_rsn varchar2(80) := null;
13562: begin
13563:
13564: If p_time_phased_code <> 'N' Then

Line 13577: from pa_budget_lines

13573: End if;
13574:
13575: select change_reason_code
13576: into l_chg_rsn_code
13577: from pa_budget_lines
13578: where resource_assignment_id = p_resource_assignment_id
13579: and txn_currency_code = p_txn_currency_code;
13580:
13581: IF l_chg_rsn_code is not null Then