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

235: ) RETURN VARCHAR2 ;
236:
237:
238: PROCEDURE Get_Peceding_Suceeding_Pd_Info
239: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
240: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
241: ,x_preceding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
242: ,x_preceding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
243: ,x_succeeding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 240: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

236:
237:
238: PROCEDURE Get_Peceding_Suceeding_Pd_Info
239: ( p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
240: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
241: ,x_preceding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
242: ,x_preceding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
243: ,x_succeeding_prd_start_date OUT NOCOPY DATE --File.Sql.39 bug 4440895
244: ,x_succeeding_prd_end_date OUT NOCOPY DATE --File.Sql.39 bug 4440895

Line 252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE

248: ) ;
249:
250: PROCEDURE Get_Element_Proj_PF_Amounts
251: (
252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

Line 253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE

249:
250: PROCEDURE Get_Element_Proj_PF_Amounts
251: (
252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

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

250: PROCEDURE Get_Element_Proj_PF_Amounts
251: (
252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895

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

251: (
252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895

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

252: p_resource_assignment_id IN pa_budget_lines.RESOURCE_ASSIGNMENT_ID%TYPE
253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
260: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895

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

253: ,p_txn_currency_code IN pa_budget_lines.TXN_CURRENCY_CODE%TYPE
254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
260: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
261: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

254: ,x_quantity OUT NOCOPY pa_budget_lines.QUANTITY%TYPE --File.Sql.39 bug 4440895
255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
260: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
261: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
262: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

255: ,x_project_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
260: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
261: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
262: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
263: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

256: ,x_project_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
257: ,x_project_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
258: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_lines.TXN_RAW_COST%TYPE --File.Sql.39 bug 4440895
259: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_lines.TXN_BURDENED_COST%TYPE --File.Sql.39 bug 4440895
260: ,x_projfunc_revenue OUT NOCOPY pa_budget_lines.TXN_REVENUE%TYPE --File.Sql.39 bug 4440895
261: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
262: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
263: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
264: );

Line 552: ,p_ci_id IN NUMBER DEFAULT NULL) RETURN pa_budget_lines.quantity%TYPE;

548: FUNCTION Get_Approved_Budget_Ver_Qty (
549: p_project_id IN NUMBER
550: ,p_version_code IN VARCHAR2
551: ,p_quantity_type IN VARCHAR2
552: ,p_ci_id IN NUMBER DEFAULT NULL) RETURN pa_budget_lines.quantity%TYPE;
553:
554: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895

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

554: PROCEDURE VALIDATE_CURRENCY_ATTRIBUTES
555: ( px_project_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_type%TYPE --File.Sql.39 bug 4440895
556: ,px_project_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
557: ,px_project_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.project_cost_rate_date%TYPE --File.Sql.39 bug 4440895
558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

558: ,px_project_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
559: ,px_projfunc_cost_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
560: ,px_projfunc_cost_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
561: ,px_projfunc_cost_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

562: ,px_projfunc_cost_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
563: ,px_project_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_type%TYPE --File.Sql.39 bug 4440895
564: ,px_project_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
565: ,px_project_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.project_rev_rate_date%TYPE --File.Sql.39 bug 4440895
566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895

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

566: ,px_project_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.project_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
567: ,px_projfunc_rev_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_type%TYPE --File.Sql.39 bug 4440895
568: ,px_projfunc_rev_rate_date_typ IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date_type%TYPE --File.Sql.39 bug 4440895
569: ,px_projfunc_rev_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_rev_rate_date%TYPE --File.Sql.39 bug 4440895
570: ,px_projfunc_rev_exchange_rate IN OUT NOCOPY pa_budget_lines.projfunc_rev_exchange_rate%TYPE --File.Sql.39 bug 4440895
571: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
572: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
573: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE DEFAULT NULL
574: ,p_context IN VARCHAR2

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

580: PROCEDURE VALIDATE_CONV_ATTRIBUTES
581: ( px_rate_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
582: ,px_rate_date_type IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date_type%TYPE --File.Sql.39 bug 4440895
583: ,px_rate_date IN OUT NOCOPY pa_proj_fp_options.projfunc_cost_rate_date%TYPE --File.Sql.39 bug 4440895
584: ,px_rate IN OUT NOCOPY pa_budget_lines.project_cost_exchange_rate%TYPE --File.Sql.39 bug 4440895
585: ,p_amount_type_code IN VARCHAR2
586: ,p_currency_type_code IN VARCHAR2
587: ,p_calling_context IN VARCHAR2
588: ,x_first_error_code OUT NOCOPY VARCHAR2 -- Removed validate code and introduce this parameter for WEBADI. --File.Sql.39 bug 4440895

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

1202: */
1203:
1204: FUNCTION Get_NP_RA_Description
1205: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
1206: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null
1207: ) RETURN VARCHAR2;
1208:
1209: /*
1210: API Name : Get_Change_Reason

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

1214: */
1215:
1216: FUNCTION Get_Change_Reason
1217: (p_resource_assignment_id IN pa_resource_assignments.resource_assignment_id%TYPE Default Null,
1218: p_txn_currency_code IN pa_budget_lines.txn_currency_code%TYPE Default Null,
1219: p_time_phased_code IN varchar2
1220: ) RETURN VARCHAR2;
1221:
1222: