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_PROJECTS_ALL

Line 87: (p_project_id IN pa_projects_all.project_id%TYPE

83: /* This function checks whether a plan type can be added to a project or not
84: This will be called from the Add Plan Type page. This is due to bug
85: 2607945*/
86: FUNCTION Is_Plan_Type_Addition_Allowed
87: (p_project_id IN pa_projects_all.project_id%TYPE
88: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
89: ) RETURN VARCHAR2 IS
90:
91: l_valid_status VARCHAR2(1):='S';

Line 571: (p_project_id IN pa_projects_all.project_id%TYPE)

567: This function will return the approved cost budget current baselined version.
568: If version is not available then it will return null value.
569: ==============================================================================*/
570: FUNCTION Get_app_budget_cost_cb_ver
571: (p_project_id IN pa_projects_all.project_id%TYPE)
572: RETURN NUMBER IS
573:
574: x_app_bdgt_cost_cb_ver pa_budget_versions.budget_version_id%TYPE;
575:

Line 606: p_project_id IN pa_projects_all.project_id%TYPE

602: plan type and version type
603: ==============================================================================*/
604:
605: PROCEDURE Get_Baselined_Version_Info(
606: p_project_id IN pa_projects_all.project_id%TYPE
607: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
608: ,p_version_type IN pa_budget_versions.version_type%TYPE
609: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
610: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

Line 1130: p_project_id IN pa_projects_all.project_id%TYPE

1126: project id and version type
1127: ==============================================================================*/
1128:
1129: PROCEDURE Get_Curr_Working_Version_Info(
1130: p_project_id IN pa_projects_all.project_id%TYPE
1131: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
1132: ,p_version_type IN pa_budget_versions.version_type%TYPE
1133: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
1134: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

Line 1368: p_project_id IN pa_projects_all.project_id%TYPE

1364: ==============================================================================*/
1365:
1366:
1367: PROCEDURE Get_Appr_Cost_Plan_Type_Info(
1368: p_project_id IN pa_projects_all.project_id%TYPE
1369: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
1370: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1371: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1372: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 1524: p_project_id IN pa_projects_all.project_id%TYPE

1520: This api is used to return approved rev plan type for given project
1521: ==============================================================================*/
1522:
1523: PROCEDURE Get_Appr_Rev_Plan_Type_Info(
1524: p_project_id IN pa_projects_all.project_id%TYPE
1525: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
1526: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1527: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
1528: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3535: (p_project_id IN pa_projects_all.project_id%TYPE)

3531:
3532: END Check_Both_Locked_By_User;
3533:
3534: FUNCTION check_budget_trans_exists
3535: (p_project_id IN pa_projects_all.project_id%TYPE)
3536: return VARCHAR2 is
3537: l_return VARCHAR2(1) := 'N';
3538: BEGIN
3539: /* Bug 3106741

Line 3563: pa_projects_all pa where

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
3562: from pa_proj_fp_options pfo,
3563: pa_projects_all pa where
3564: pfo.project_id = pa.project_id and
3565: pa.project_id = p_project_id and
3566: pfo.fin_plan_option_level_code = 'PLAN_TYPE');
3567: /* commented for bug 3224177 starts

Line 3571: pa_projects_all pa

3567: /* commented for bug 3224177 starts
3568: OR exists (Select 'x'
3569: from pa_fp_txn_currencies fpcurr,
3570: pa_proj_fp_options pfo, -- bug 3106741
3571: pa_projects_all pa
3572: where pa.project_currency_code = fpcurr.txn_currency_code
3573: and pa.project_id = fpcurr.project_id
3574: and fpcurr.project_currency_flag = 'Y'
3575: and pfo.proj_fp_options_id = fpcurr.proj_fp_options_id -- bug 3106741

Line 3593: pa_projects_all pa

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
3592: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,
3593: pa_projects_all pa
3594: where pfo.project_id = pa.project_id and
3595: pa.project_id = p_project_id and
3596: /* Commented out the below for bug 5364011*/
3597: -- pfo.fin_plan_option_level_code = 'PLAN_TYPE' and

Line 3611: (p_project_id IN pa_projects_all.project_id%TYPE)

3607: return l_return;
3608: END check_budget_trans_exists;
3609:
3610: FUNCTION enable_auto_baseline
3611: (p_project_id IN pa_projects_all.project_id%TYPE)
3612: return VARCHAR2 is
3613: Cursor c1 is
3614: Select 'Y'
3615: from pa_proj_fp_options po /* Bug# 2665767 - Plan type option alone can be checked */

Line 4010: p_project_id IN pa_projects_all.project_id%TYPE

4006: ==============================================================================*/
4007:
4008:
4009: PROCEDURE Is_AC_PT_Attached_After_UPG(
4010: p_project_id IN pa_projects_all.project_id%TYPE
4011: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
4012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4013: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4014: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4193: p_project_id IN pa_projects_all.project_id%TYPE

4189: a non-negative, non-zero value. else returns NULL.
4190: ==============================================================================*/
4191:
4192: PROCEDURE Is_AR_PT_Attached_After_UPG(
4193: p_project_id IN pa_projects_all.project_id%TYPE
4194: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
4195: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4196: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4197: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 5079: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE

5075: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
5076: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
5077: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
5078: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
5079: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
5080: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
5081: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
5082: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
5083: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

Line 5080: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

5076: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE
5077: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
5078: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
5079: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
5080: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
5081: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
5082: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
5083: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5084: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

Line 5081: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

5077: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE
5078: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE
5079: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE
5080: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE
5081: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE
5082: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895
5083: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5084: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

Line 6158: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

6154: ,p_project_rev_rate_type IN pa_proj_fp_options.project_rev_rate_type%TYPE
6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%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

Line 6159: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

6155: ,p_project_rev_rate_date_typ IN pa_proj_fp_options.project_rev_rate_date_type%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

Line 6677: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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
6681: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH

Line 6678: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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
6681: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH
6682: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 6679: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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
6681: ,p_attrs_to_be_validated IN VARCHAR2 -- valid values are COST, REVENUE , BOTH
6682: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
6683: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7282: If they aren't available at pa_projects_all table, we fetch them from the

7278:
7279: /*============================================================================
7280: This api is used to return the project and projfunc currency codes and the
7281: cost and bill rate types defined for them.
7282: If they aren't available at pa_projects_all table, we fetch them from the
7283: implementations table. If they are not avaialable, null would be returned.
7284: =============================================================================*/
7285:
7286: PROCEDURE Get_Project_Curr_Attributes

Line 7287: ( p_project_id IN pa_projects_all.project_id%TYPE

7283: implementations table. If they are not avaialable, null would be returned.
7284: =============================================================================*/
7285:
7286: PROCEDURE Get_Project_Curr_Attributes
7287: ( p_project_id IN pa_projects_all.project_id%TYPE
7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895

Line 7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895

7284: =============================================================================*/
7285:
7286: PROCEDURE Get_Project_Curr_Attributes
7287: ( p_project_id IN pa_projects_all.project_id%TYPE
7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

Line 7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895

7285:
7286: PROCEDURE Get_Project_Curr_Attributes
7287: ( p_project_id IN pa_projects_all.project_id%TYPE
7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895

Line 7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895

7286: PROCEDURE Get_Project_Curr_Attributes
7287: ( p_project_id IN pa_projects_all.project_id%TYPE
7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895

Line 7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895

7287: ( p_project_id IN pa_projects_all.project_id%TYPE
7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

7288: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7296: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895

7289: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7296: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7297: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895

7290: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7291: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7292: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7293: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7294: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7295: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7296: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7297: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
7298: AS

Line 7348: FROM pa_projects_all p

7344: ,x_project_cost_rate_type
7345: ,x_projfunc_cost_rate_type
7346: ,x_project_bil_rate_type
7347: ,x_projfunc_bil_rate_type
7348: FROM pa_projects_all p
7349: ,pa_implementations_all i
7350: WHERE p.project_id = p_project_id
7351: --AND NVL(p.org_id,-99) = NVL(i.org_id,-99);
7352: AND p.org_id = i.org_id; /* Bug 3174677: Added the NVL ,Refer to Update

Line 7402: ( p_project_id IN pa_projects_all.project_id%TYPE

7398: RAISE;
7399: END Get_Project_Curr_Attributes;
7400:
7401: PROCEDURE IsRevVersionCreationAllowed
7402: ( p_project_id IN pa_projects_all.project_id%TYPE
7403: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
7404: ,x_creation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7405: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7406: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7423: FROM pa_projects_all pr, pa_proj_fp_options pfo,

7419:
7420: cursor autobaseline_appr_rev_info_cur is
7421: SELECT nvl(pr.baseline_funding_flag,'N') baseline_funding_flag, pfo.approved_rev_plan_type_flag,
7422: pft.use_for_workplan_flag -- Added for FP.M ,Tracking Bug No - 3354518
7423: FROM pa_projects_all pr, pa_proj_fp_options pfo,
7424: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518
7425: WHERE pr.project_id = pfo.project_id
7426: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7427: AND pfo.fin_plan_type_id = p_fin_plan_type_id

Line 7714: ( p_project_id IN pa_projects_all.project_id%TYPE

7710: --derives the version type if it is not passed
7711: --Vesion type should be passed when the preference code of the plan type is
7712: --COST_AND_REV_SEP, else an error will be thrown
7713: PROCEDURE get_version_type
7714: ( p_project_id IN pa_projects_all.project_id%TYPE
7715: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
7716: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895
7717: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7718: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7743: l_segment1 pa_projects_all.segment1%TYPE;

7739: l_debug_level3 CONSTANT NUMBER := 3;
7740: l_debug_level4 CONSTANT NUMBER := 4;
7741: l_debug_level5 CONSTANT NUMBER := 5;
7742: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
7743: l_segment1 pa_projects_all.segment1%TYPE;
7744:
7745: BEGIN
7746:
7747: x_msg_count := 0;

Line 7784: FROM pa_projects_all

7780:
7781: -- Get the segment1 of the project
7782: SELECT segment1
7783: INTO l_segment1
7784: FROM pa_projects_all
7785: WHERE project_id = p_project_id ;
7786:
7787: OPEN l_proj_fp_options_csr;
7788: FETCH l_proj_fp_options_csr

Line 8012: ( p_project_id IN pa_projects_all.project_id%TYPE

8008: -- given the project id ,plan type id, version type and version number
8009: -- If found returns valid budget version id
8010: -- Null is returned other wise
8011: PROCEDURE get_version_id
8012: ( p_project_id IN pa_projects_all.project_id%TYPE
8013: ,p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
8014: ,p_version_type IN pa_budget_Versions.version_type%TYPE
8015: ,p_version_number IN pa_budget_Versions.version_number%TYPE
8016: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

Line 8177: ,pa_projects_all p

8173: ,pfo.approved_rev_plan_type_flag
8174: ,p.baseline_funding_flag
8175: FROM pa_budget_versions pbv
8176: ,pa_proj_fp_options pfo
8177: ,pa_projects_all p
8178: WHERE pbv.budget_version_id=p_budget_version_id
8179: AND pfo.fin_plan_version_id(+)=pbv.budget_version_id
8180: AND p.project_id=pbv.project_id;
8181:

Line 8490: l_project_id pa_projects_all.project_id%TYPE;

8486: l_request_id pa_budget_versions.request_id%TYPE;
8487:
8488: -- Bug 3986129: FP.M Web ADI Dev. Added the followings
8489: l_edit_after_baseline_flag pa_fin_plan_types_b.edit_after_baseline_flag%TYPE;
8490: l_project_id pa_projects_all.project_id%TYPE;
8491: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8492: l_version_type pa_budget_versions.version_type%TYPE;
8493: is_edit_allowed VARCHAR2(1) := 'Y';
8494:

Line 9590: p_project_id IN pa_projects_all.project_id%TYPE

9586:
9587:
9588: FUNCTION Get_Budgeted_Amount
9589: (
9590: p_project_id IN pa_projects_all.project_id%TYPE
9591: , p_task_id IN pa_tasks.task_id%TYPE
9592: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9593: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9594: , p_amount_type IN VARCHAR2

Line 10008: p_project_id IN pa_projects_all.project_id%TYPE

10004: project id and version type
10005: ==============================================================================*/
10006:
10007: PROCEDURE Get_Curr_Original_Version_Info(
10008: p_project_id IN pa_projects_all.project_id%TYPE
10009: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10010: ,p_version_type IN pa_budget_versions.version_type%TYPE
10011: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10012: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

Line 10703: p_project_id IN pa_projects_all.project_id%TYPE

10699: would be returned
10700: ==============================================================================*/
10701:
10702: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
10703: p_project_id IN pa_projects_all.project_id%TYPE
10704: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10705: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10706: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10707: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10826: p_project_id IN pa_projects_all.project_id%TYPE

10822: would be returned
10823: ==============================================================================*/
10824:
10825: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
10826: p_project_id IN pa_projects_all.project_id%TYPE
10827: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10828: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10829: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10830: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10942: (p_project_id IN pa_projects_all.project_id%TYPE

10938: RAISE;
10939: END IS_PRI_FCST_REV_PT_ATTACHED;
10940:
10941: FUNCTION is_wp_resource_list
10942: (p_project_id IN pa_projects_all.project_id%TYPE
10943: ,p_resource_list_id IN
10944: pa_resource_lists_all_bg.resource_list_id%TYPE) RETURN VARCHAR2 IS
10945: l_wp_resource_list_flag VARCHAR2(1);
10946: BEGIN

Line 10968: (p_project_id IN pa_projects_all.project_id%TYPE

10964: return l_wp_resource_list_flag;
10965: END is_wp_resource_list;
10966:
10967: FUNCTION is_fp_resource_list
10968: (p_project_id IN pa_projects_all.project_id%TYPE
10969: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE)
10970: RETURN VARCHAR2 IS
10971: l_fp_resource_list_flag VARCHAR2(1);
10972: BEGIN

Line 11485: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .

11481: -- in separate out params, p_version parameter is no longer required.
11482: -- Commenting out references of p_version_type_below - Bug 3902176
11483:
11484: PROCEDURE GET_SUMMARY_AMOUNTS(p_context IN VARCHAR2
11485: ,P_project_id IN Pa_projects_all.project_id%TYPE -- Id of the project .
11486: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document
11487: ,P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE DEFAULT NULL
11488: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11489: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

Line 11959: p_project_id IN pa_projects_all.project_id%TYPE,

11955: * p_budget_version_id would be null. The api returns 'Y' if the event is valid and allowed
11956: * and returns 'N' otherwise.
11957: *--------------------------------------------------------------------------------------------*/
11958: FUNCTION Validate_Uncheck_MC_Flag (
11959: p_project_id IN pa_projects_all.project_id%TYPE,
11960: p_context IN VARCHAR2,
11961: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
11962: RETURN VARCHAR2
11963: IS

Line 12040: FROM pa_projects_all

12036: END IF;
12037:
12038: SELECT project_currency_code
12039: INTO l_currency_code
12040: FROM pa_projects_all
12041: WHERE project_id = p_project_id;
12042:
12043: IF P_PA_DEBUG_MODE = 'Y' THEN
12044: pa_debug.g_err_stage:='Project Currency Code: ' || l_currency_code;

Line 12119: p_project_id IN pa_projects_all.project_id%TYPE

12115: 3. option is a version and amounts exist against the currency
12116: ==============================================================================*/
12117:
12118: FUNCTION Check_delete_txn_cur_ok(
12119: p_project_id IN pa_projects_all.project_id%TYPE
12120: ,p_context IN VARCHAR2 -- FINPLAN or WORKPLAN
12121: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
12122: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE
12123: ) RETURN VARCHAR2

Line 12130: FROM pa_projects_all

12126:
12127: CURSOR project_info_cur IS
12128: SELECT project_currency_code
12129: ,projfunc_currency_code
12130: FROM pa_projects_all
12131: WHERE project_id = p_project_id;
12132: project_info_rec project_info_cur%ROWTYPE;
12133: BEGIN
12134: -- Set curr function

Line 12259: p_project_id IN pa_projects_all.project_id%TYPE

12255: of the project in budgets data model.
12256: ==============================================================================*/
12257:
12258: FUNCTION check_if_amounts_exist_for_wp(
12259: p_project_id IN pa_projects_all.project_id%TYPE
12260: ) RETURN VARCHAR2
12261: IS
12262: l_amounts_exist_flag VARCHAR2(1) := 'N';
12263: BEGIN

Line 12340: p_project_id IN pa_projects_all.project_id%TYPE

12336: versions of the given project
12337: ==============================================================================*/
12338:
12339: FUNCTION check_if_task_asgmts_exist(
12340: p_project_id IN pa_projects_all.project_id%TYPE
12341: ) RETURN VARCHAR2
12342: IS
12343: l_task_assignments_exist_flag VARCHAR2(1);
12344: BEGIN

Line 12423: p_project_id IN pa_projects_all.project_id%TYPE

12419: RBS change at plan type level.
12420: ==============================================================================*/
12421:
12422: FUNCTION check_if_amounts_exist_for_fp(
12423: p_project_id IN pa_projects_all.project_id%TYPE
12424: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE
12425: ) RETURN VARCHAR2
12426: IS
12427: l_amounts_exist_flag VARCHAR2(1) := 'N';

Line 12896: (p_project_id IN pa_projects_all.project_id%TYPE

12892:
12893: --Bug: 3619687 Added a function to check that the preference code the plan type is not used as a generation source for any other plan type
12894:
12895: FUNCTION Is_source_for_gen_options
12896: (p_project_id IN pa_projects_all.project_id%TYPE
12897: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12898: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
12899: ) RETURN VARCHAR2 IS
12900:

Line 12936: ( p_project_id IN pa_projects_all.project_id%TYPE,

12932: structure_version_id and the status_flags are passed as input. This function
12933: is introduced as part of performance improvement for FP.M excel download.
12934: */
12935: FUNCTION get_physical_pc_complete
12936: ( p_project_id IN pa_projects_all.project_id%TYPE,
12937: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)
12938:
12939: RETURN NUMBER IS
12940:

Line 13027: l_project_id pa_projects_all.project_id%TYPE;

13023: l_data VARCHAR2(2000);
13024: l_msg_data VARCHAR2(2000);
13025: l_msg_index_out NUMBER;
13026: l_debug_level3 CONSTANT NUMBER :=3;
13027: l_project_id pa_projects_all.project_id%TYPE;
13028:
13029:
13030: BEGIN
13031: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 13251: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;

13247: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13248: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13249:
13250: -- Bug 8681652
13251: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
13252: l_budget_version_name pa_budget_versions.version_name%TYPE;
13253:
13254: BEGIN
13255:

Line 13266: from pa_projects_all

13262:
13263: -- Bug 8681652
13264: select baseline_funding_flag
13265: into l_baseline_funding_flag
13266: from pa_projects_all
13267: where project_id = p_pa_project_id;
13268:
13269: IF ( p_budget_version_name IS NULL OR p_budget_version_name = PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR )
13270: AND l_baseline_funding_flag = 'Y'