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 569: (p_project_id IN pa_projects_all.project_id%TYPE)

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

Line 604: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 1128: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 1366: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 1522: p_project_id IN pa_projects_all.project_id%TYPE

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

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

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

Line 3561: pa_projects_all pa where

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

Line 3569: pa_projects_all pa

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

Line 3591: pa_projects_all pa

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

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

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

Line 4008: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 4191: p_project_id IN pa_projects_all.project_id%TYPE

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

Line 5077: ,p_txn_currency_Code IN pa_projects_all.project_currency_code%TYPE

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

Line 5078: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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

Line 5079: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

Line 6152: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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

Line 6153: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

Line 6671: ,p_project_currency_code IN pa_projects_all.project_currency_code%TYPE

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

Line 6672: ,p_projfunc_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

Line 6673: ,p_txn_currency_code IN pa_projects_all.projfunc_currency_code%TYPE

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

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

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

Line 7281: ( p_project_id IN pa_projects_all.project_id%TYPE

7277: implementations table. If they are not avaialable, null would be returned.
7278: =============================================================================*/
7279:
7280: PROCEDURE Get_Project_Curr_Attributes
7281: ( p_project_id IN pa_projects_all.project_id%TYPE
7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895

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

7278: =============================================================================*/
7279:
7280: PROCEDURE Get_Project_Curr_Attributes
7281: ( p_project_id IN pa_projects_all.project_id%TYPE
7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895

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

7279:
7280: PROCEDURE Get_Project_Curr_Attributes
7281: ( p_project_id IN pa_projects_all.project_id%TYPE
7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895

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

7280: PROCEDURE Get_Project_Curr_Attributes
7281: ( p_project_id IN pa_projects_all.project_id%TYPE
7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7288: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895

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

7281: ( p_project_id IN pa_projects_all.project_id%TYPE
7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7288: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7289: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

7282: ,x_multi_currency_billing_flag OUT NOCOPY pa_projects_all.multi_currency_billing_flag%TYPE --File.Sql.39 bug 4440895
7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7288: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7289: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7290: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

7283: ,x_project_currency_code OUT NOCOPY pa_projects_all.project_currency_code%TYPE --File.Sql.39 bug 4440895
7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7288: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7289: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7290: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7291: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

7284: ,x_projfunc_currency_code OUT NOCOPY pa_projects_all.projfunc_currency_code%TYPE --File.Sql.39 bug 4440895
7285: ,x_project_cost_rate_type OUT NOCOPY pa_projects_all.project_rate_type%TYPE --File.Sql.39 bug 4440895
7286: ,x_projfunc_cost_rate_type OUT NOCOPY pa_projects_all.projfunc_cost_rate_type%TYPE --File.Sql.39 bug 4440895
7287: ,x_project_bil_rate_type OUT NOCOPY pa_projects_all.project_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7288: ,x_projfunc_bil_rate_type OUT NOCOPY pa_projects_all.projfunc_bil_rate_type%TYPE --File.Sql.39 bug 4440895
7289: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7290: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7291: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
7292: AS

Line 7342: FROM pa_projects_all p

7338: ,x_project_cost_rate_type
7339: ,x_projfunc_cost_rate_type
7340: ,x_project_bil_rate_type
7341: ,x_projfunc_bil_rate_type
7342: FROM pa_projects_all p
7343: ,pa_implementations_all i
7344: WHERE p.project_id = p_project_id
7345: --AND NVL(p.org_id,-99) = NVL(i.org_id,-99);
7346: AND p.org_id = i.org_id; /* Bug 3174677: Added the NVL ,Refer to Update

Line 7396: ( p_project_id IN pa_projects_all.project_id%TYPE

7392: RAISE;
7393: END Get_Project_Curr_Attributes;
7394:
7395: PROCEDURE IsRevVersionCreationAllowed
7396: ( p_project_id IN pa_projects_all.project_id%TYPE
7397: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
7398: ,x_creation_allowed OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7399: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7400: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 7417: FROM pa_projects_all pr, pa_proj_fp_options pfo,

7413:
7414: cursor autobaseline_appr_rev_info_cur is
7415: SELECT nvl(pr.baseline_funding_flag,'N') baseline_funding_flag, pfo.approved_rev_plan_type_flag,
7416: pft.use_for_workplan_flag -- Added for FP.M ,Tracking Bug No - 3354518
7417: FROM pa_projects_all pr, pa_proj_fp_options pfo,
7418: pa_fin_plan_types_b pft -- Added for FP.M ,Tracking Bug No - 3354518
7419: WHERE pr.project_id = pfo.project_id
7420: AND pfo.fin_plan_option_level_code = PA_FP_CONSTANTS_PKG.G_OPTION_LEVEL_PLAN_TYPE
7421: AND pfo.fin_plan_type_id = p_fin_plan_type_id

Line 7708: ( p_project_id IN pa_projects_all.project_id%TYPE

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

Line 7737: l_segment1 pa_projects_all.segment1%TYPE;

7733: l_debug_level3 CONSTANT NUMBER := 3;
7734: l_debug_level4 CONSTANT NUMBER := 4;
7735: l_debug_level5 CONSTANT NUMBER := 5;
7736: l_fin_plan_type_name pa_fin_plan_types_tl.name%TYPE;
7737: l_segment1 pa_projects_all.segment1%TYPE;
7738:
7739: BEGIN
7740:
7741: x_msg_count := 0;

Line 7778: FROM pa_projects_all

7774:
7775: -- Get the segment1 of the project
7776: SELECT segment1
7777: INTO l_segment1
7778: FROM pa_projects_all
7779: WHERE project_id = p_project_id ;
7780:
7781: OPEN l_proj_fp_options_csr;
7782: FETCH l_proj_fp_options_csr

Line 8006: ( p_project_id IN pa_projects_all.project_id%TYPE

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

Line 8171: ,pa_projects_all p

8167: ,pfo.approved_rev_plan_type_flag
8168: ,p.baseline_funding_flag
8169: FROM pa_budget_versions pbv
8170: ,pa_proj_fp_options pfo
8171: ,pa_projects_all p
8172: WHERE pbv.budget_version_id=p_budget_version_id
8173: AND pfo.fin_plan_version_id(+)=pbv.budget_version_id
8174: AND p.project_id=pbv.project_id;
8175:

Line 8484: l_project_id pa_projects_all.project_id%TYPE;

8480: l_request_id pa_budget_versions.request_id%TYPE;
8481:
8482: -- Bug 3986129: FP.M Web ADI Dev. Added the followings
8483: l_edit_after_baseline_flag pa_fin_plan_types_b.edit_after_baseline_flag%TYPE;
8484: l_project_id pa_projects_all.project_id%TYPE;
8485: l_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
8486: l_version_type pa_budget_versions.version_type%TYPE;
8487: is_edit_allowed VARCHAR2(1) := 'Y';
8488:

Line 9584: p_project_id IN pa_projects_all.project_id%TYPE

9580:
9581:
9582: FUNCTION Get_Budgeted_Amount
9583: (
9584: p_project_id IN pa_projects_all.project_id%TYPE
9585: , p_task_id IN pa_tasks.task_id%TYPE
9586: , p_fin_plan_type_id IN pa_proj_fp_options.fin_plan_type_id%TYPE
9587: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
9588: , p_amount_type IN VARCHAR2

Line 10002: p_project_id IN pa_projects_all.project_id%TYPE

9998: project id and version type
9999: ==============================================================================*/
10000:
10001: PROCEDURE Get_Curr_Original_Version_Info(
10002: p_project_id IN pa_projects_all.project_id%TYPE
10003: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
10004: ,p_version_type IN pa_budget_versions.version_type%TYPE
10005: ,x_fp_options_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
10006: ,x_fin_plan_version_id OUT NOCOPY pa_proj_fp_options.fin_plan_version_id%TYPE --File.Sql.39 bug 4440895

Line 10697: p_project_id IN pa_projects_all.project_id%TYPE

10693: would be returned
10694: ==============================================================================*/
10695:
10696: PROCEDURE IS_PRI_FCST_COST_PT_ATTACHED(
10697: p_project_id IN pa_projects_all.project_id%TYPE
10698: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10699: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10700: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10701: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10820: p_project_id IN pa_projects_all.project_id%TYPE

10816: would be returned
10817: ==============================================================================*/
10818:
10819: PROCEDURE IS_PRI_FCST_REV_PT_ATTACHED(
10820: p_project_id IN pa_projects_all.project_id%TYPE
10821: ,x_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
10822: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10823: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
10824: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 10936: (p_project_id IN pa_projects_all.project_id%TYPE

10932: RAISE;
10933: END IS_PRI_FCST_REV_PT_ATTACHED;
10934:
10935: FUNCTION is_wp_resource_list
10936: (p_project_id IN pa_projects_all.project_id%TYPE
10937: ,p_resource_list_id IN
10938: pa_resource_lists_all_bg.resource_list_id%TYPE) RETURN VARCHAR2 IS
10939: l_wp_resource_list_flag VARCHAR2(1);
10940: BEGIN

Line 10962: (p_project_id IN pa_projects_all.project_id%TYPE

10958: return l_wp_resource_list_flag;
10959: END is_wp_resource_list;
10960:
10961: FUNCTION is_fp_resource_list
10962: (p_project_id IN pa_projects_all.project_id%TYPE
10963: ,p_resource_list_id IN pa_resource_lists_all_bg.resource_list_id%TYPE)
10964: RETURN VARCHAR2 IS
10965: l_fp_resource_list_flag VARCHAR2(1);
10966: BEGIN

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

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

Line 11953: p_project_id IN pa_projects_all.project_id%TYPE,

11949: * p_budget_version_id would be null. The api returns 'Y' if the event is valid and allowed
11950: * and returns 'N' otherwise.
11951: *--------------------------------------------------------------------------------------------*/
11952: FUNCTION Validate_Uncheck_MC_Flag (
11953: p_project_id IN pa_projects_all.project_id%TYPE,
11954: p_context IN VARCHAR2,
11955: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
11956: RETURN VARCHAR2
11957: IS

Line 12034: FROM pa_projects_all

12030: END IF;
12031:
12032: SELECT project_currency_code
12033: INTO l_currency_code
12034: FROM pa_projects_all
12035: WHERE project_id = p_project_id;
12036:
12037: IF P_PA_DEBUG_MODE = 'Y' THEN
12038: pa_debug.g_err_stage:='Project Currency Code: ' || l_currency_code;

Line 12113: p_project_id IN pa_projects_all.project_id%TYPE

12109: 3. option is a version and amounts exist against the currency
12110: ==============================================================================*/
12111:
12112: FUNCTION Check_delete_txn_cur_ok(
12113: p_project_id IN pa_projects_all.project_id%TYPE
12114: ,p_context IN VARCHAR2 -- FINPLAN or WORKPLAN
12115: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE
12116: ,p_txn_currency_code IN fnd_currencies.currency_code%TYPE
12117: ) RETURN VARCHAR2

Line 12124: FROM pa_projects_all

12120:
12121: CURSOR project_info_cur IS
12122: SELECT project_currency_code
12123: ,projfunc_currency_code
12124: FROM pa_projects_all
12125: WHERE project_id = p_project_id;
12126: project_info_rec project_info_cur%ROWTYPE;
12127: BEGIN
12128: -- Set curr function

Line 12253: p_project_id IN pa_projects_all.project_id%TYPE

12249: of the project in budgets data model.
12250: ==============================================================================*/
12251:
12252: FUNCTION check_if_amounts_exist_for_wp(
12253: p_project_id IN pa_projects_all.project_id%TYPE
12254: ) RETURN VARCHAR2
12255: IS
12256: l_amounts_exist_flag VARCHAR2(1) := 'N';
12257: BEGIN

Line 12334: p_project_id IN pa_projects_all.project_id%TYPE

12330: versions of the given project
12331: ==============================================================================*/
12332:
12333: FUNCTION check_if_task_asgmts_exist(
12334: p_project_id IN pa_projects_all.project_id%TYPE
12335: ) RETURN VARCHAR2
12336: IS
12337: l_task_assignments_exist_flag VARCHAR2(1);
12338: BEGIN

Line 12417: p_project_id IN pa_projects_all.project_id%TYPE

12413: RBS change at plan type level.
12414: ==============================================================================*/
12415:
12416: FUNCTION check_if_amounts_exist_for_fp(
12417: p_project_id IN pa_projects_all.project_id%TYPE
12418: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id %TYPE
12419: ) RETURN VARCHAR2
12420: IS
12421: l_amounts_exist_flag VARCHAR2(1) := 'N';

Line 12890: (p_project_id IN pa_projects_all.project_id%TYPE

12886:
12887: --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
12888:
12889: FUNCTION Is_source_for_gen_options
12890: (p_project_id IN pa_projects_all.project_id%TYPE
12891: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE
12892: ,p_preference_code IN pa_proj_fp_options.fin_plan_preference_code%TYPE
12893: ) RETURN VARCHAR2 IS
12894:

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

12926: structure_version_id and the status_flags are passed as input. This function
12927: is introduced as part of performance improvement for FP.M excel download.
12928: */
12929: FUNCTION get_physical_pc_complete
12930: ( p_project_id IN pa_projects_all.project_id%TYPE,
12931: p_proj_element_id IN pa_proj_element_versions.proj_element_id%TYPE)
12932:
12933: RETURN NUMBER IS
12934:

Line 13021: l_project_id pa_projects_all.project_id%TYPE;

13017: l_data VARCHAR2(2000);
13018: l_msg_data VARCHAR2(2000);
13019: l_msg_index_out NUMBER;
13020: l_debug_level3 CONSTANT NUMBER :=3;
13021: l_project_id pa_projects_all.project_id%TYPE;
13022:
13023:
13024: BEGIN
13025: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);