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_VERSIONS

Line 50: l_record_version_number pa_budget_versions.record_version_number%TYPE;

46: p_record_version_number IN NUMBER,
47: x_valid_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
48: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
49: x_error_msg_code OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895
50: l_record_version_number pa_budget_versions.record_version_number%TYPE;
51: begin
52: x_return_status := FND_API.G_RET_STS_SUCCESS;
53: x_valid_flag := 'Y';
54: select

Line 59: pa_budget_versions

55: record_version_number
56: into
57: l_record_version_number
58: from
59: pa_budget_versions
60: where
61: budget_version_id=p_unique_index;
62: /* compare results */
63: if p_record_version_number is NULL then

Line 95: l_budget_version_id pa_budget_Versions.budget_version_id%TYPE;

91: l_valid_status VARCHAR2(1):='S';
92: l_migrated_frm_bdgt_typ_code pa_fin_plan_types_b.migrated_frm_bdgt_typ_code%TYPE;
93: l_approved_cost_plan_type_flag pa_fin_plan_types_b.approved_cost_plan_type_flag%TYPE;
94: l_approved_rev_plan_type_flag pa_fin_plan_types_b.approved_rev_plan_type_flag%TYPE;
95: l_budget_version_id pa_budget_Versions.budget_version_id%TYPE;
96:
97: BEGIN
98: IF P_PA_DEBUG_MODE = 'Y' THEN
99: pa_debug.init_err_stack ('pa_fin_plan_utils.is_plan_type_addition_allowed');

Line 124: FROM pa_budget_versions

120: IF (l_approved_cost_plan_type_flag ='Y') THEN
121: BEGIN
122: SELECT budget_version_id
123: INTO l_budget_version_id
124: FROM pa_budget_versions
125: WHERE project_id = p_project_id
126: AND budget_type_code=PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AC
127: AND rownum = 1;
128:

Line 141: FROM pa_budget_versions

137: IF (l_approved_rev_plan_type_flag ='Y') THEN
138: BEGIN
139: SELECT budget_version_id
140: INTO l_budget_version_id
141: FROM pa_budget_versions
142: WHERE project_id = p_project_id
143: AND budget_type_code=PA_FP_CONSTANTS_PKG.G_BUDGET_TYPE_CODE_AR
144: AND rownum = 1;
145:

Line 159: FROM pa_budget_versions

155: ELSE
156: BEGIN
157: SELECT budget_version_id
158: INTO l_budget_version_id
159: FROM pa_budget_versions
160: WHERE project_id = p_project_id
161: AND budget_type_code=l_migrated_frm_bdgt_typ_code
162: AND rownum = 1;
163:

Line 193: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

189:
190: END is_plan_type_addition_allowed;
191:
192: function Retrieve_Record_Version_Number
193: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
194: return number
195: is
196: l_record_version_number pa_budget_versions.record_version_number%TYPE;
197:

Line 196: l_record_version_number pa_budget_versions.record_version_number%TYPE;

192: function Retrieve_Record_Version_Number
193: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
194: return number
195: is
196: l_record_version_number pa_budget_versions.record_version_number%TYPE;
197:
198: begin
199: select
200: nvl(record_version_number, 0)

Line 204: pa_budget_versions

200: nvl(record_version_number, 0)
201: into
202: l_record_version_number
203: from
204: pa_budget_versions
205: where
206: budget_version_id=p_budget_version_id;
207: return l_record_version_number;
208: end Retrieve_Record_Version_Number;

Line 211: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

207: return l_record_version_number;
208: end Retrieve_Record_Version_Number;
209:
210: function Plan_Amount_Exists
211: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
212: return varchar2 is
213: l_exists varchar2(1) := 'N';
214: begin
215:

Line 241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,

237: API Creation Date : 15-MAR-2004
238: */
239:
240: FUNCTION Plan_Amount_Exists_Task_Res
241: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE ,
242: p_task_id IN pa_tasks.task_id%TYPE Default Null,
243: p_resource_list_member_id IN pa_resource_list_members.RESOURCE_LIST_MEMBER_ID%TYPE Default Null
244: ) RETURN VARCHAR2
245: IS

Line 304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;

300: p_fin_plan_version_id IN pa_proj_fp_options.fin_plan_version_id %TYPE )
301: RETURN pa_proj_fp_options.all_time_phased_code%TYPE
302: IS
303:
304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
305: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
306:
307: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
308:

Line 305: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;

301: RETURN pa_proj_fp_options.all_time_phased_code%TYPE
302: IS
303:
304: l_budget_entry_method_code pa_budget_versions.budget_entry_method_code%TYPE;
305: l_budget_type_code pa_budget_versions.budget_type_code%TYPE;
306:
307: l_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
308:
309: BEGIN

Line 320: FROM pa_budget_versions

316: SELECT budget_type_code,
317: budget_entry_method_code
318: INTO l_budget_type_code,
319: l_budget_entry_method_code
320: FROM pa_budget_versions
321: WHERE budget_version_id = p_fin_plan_version_id;
322: EXCEPTION
323: WHEN OTHERS THEN
324: RETURN NULL;

Line 418: p_element_type IN pa_budget_versions.version_type%TYPE)

414: FUNCTION GET_OPTION_PLANNING_LEVEL(
415: P_proj_fp_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
416: /* p_element_type IN pa_fp_elements.element_type%TYPE)
417: Modified as part of Changes for FP.M, Tracking Bug No - 3354518*/
418: p_element_type IN pa_budget_versions.version_type%TYPE)
419: RETURN pa_proj_fp_options.all_fin_plan_level_code%TYPE
420: IS
421: l_fin_plan_level_code pa_proj_fp_options.all_fin_plan_level_code%TYPE;
422:

Line 473: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

469: Use: for Create Plan Version page VO query
470: ==============================================================================*/
471:
472: FUNCTION Get_Period_Profile_Start_Date
473: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
474: return pa_proj_period_profiles.period_name1%TYPE is
475: l_start_date pa_proj_period_profiles.period_name1%TYPE;
476: BEGIN
477: l_start_date := null;

Line 497: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)

493: Created: 9/18/02 by dlai
494: Use: for Create Plan Version page VO query
495: ==============================================================================*/
496: FUNCTION Get_Period_Profile_End_Date
497: (p_period_profile_id IN pa_budget_versions.period_profile_id%TYPE)
498: return pa_proj_period_profiles.profile_end_period_name%TYPE is
499: l_end_date pa_proj_period_profiles.profile_end_period_name%TYPE;
500: BEGIN
501: l_end_date := null;

Line 525: FROM pa_budget_versions

521:
522: BEGIN
523: SELECT resource_list_id
524: INTO l_wp_bv_res_list_id
525: FROM pa_budget_versions
526: WHERE project_structure_version_id=p_proj_structure_version_id AND
527: NVL(WP_VERSION_FLAG,'N') = 'Y';
528:
529: RETURN l_wp_bv_res_list_id;

Line 543: (p_wp_structure_version_id IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE)

539: of the budget_version_id for a given wp_structure_version_id.
540: P->PA, G->Gl, N->None
541: ==============================================================================*/
542: FUNCTION Get_wp_bv_time_phase
543: (p_wp_structure_version_id IN PA_BUDGET_VERSIONS.PROJECT_STRUCTURE_VERSION_ID%TYPE)
544: RETURN VARCHAR2 IS
545: x_time_phased_code PA_PROJ_FP_OPTIONS.COST_TIME_PHASED_CODE%TYPE;
546: BEGIN
547: SELECT DECODE(BV.VERSION_TYPE,

Line 552: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT

548: 'COST', OPT.COST_TIME_PHASED_CODE,
549: 'REVENUE',OPT.REVENUE_TIME_PHASED_CODE,
550: 'ALL',OPT.ALL_TIME_PHASED_CODE)
551: INTO x_time_phased_code
552: FROM PA_BUDGET_VERSIONS BV, PA_PROJ_FP_OPTIONS OPT
553: WHERE BV.BUDGET_VERSION_ID = OPT.FIN_PLAN_VERSION_ID
554: AND BV.PROJECT_STRUCTURE_VERSION_ID = p_wp_structure_version_id
555: AND NVL(BV.WP_VERSION_FLAG,'N') = 'Y';
556:

Line 572: x_app_bdgt_cost_cb_ver pa_budget_versions.budget_version_id%TYPE;

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:
574: BEGIN
575:
576: /* Bug 3955810.

Line 582: FROM pa_budget_versions

578: for version_type is not null. In old budget model, version_type was
579: not populated, but APPROVED_COST_PLAN_TYPE_FLAG is populated. */
580: SELECT budget_version_id
581: INTO x_app_bdgt_cost_cb_ver
582: FROM pa_budget_versions
583: WHERE project_id = p_project_id
584: AND nvl(APPROVED_COST_PLAN_TYPE_FLAG,'N') = 'Y'
585: AND budget_status_code = 'B'
586: AND current_flag = 'Y';

Line 605: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%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
609: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 606: ,p_version_type IN pa_budget_versions.version_type%TYPE

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
609: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
610: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 626: l_version_type pa_budget_versions.version_type%TYPE;

622:
623: --End of variables used for debugging
624:
625: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
626: l_version_type pa_budget_versions.version_type%TYPE;
627: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
628: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
629:
630:

Line 627: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

623: --End of variables used for debugging
624:
625: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
626: l_version_type pa_budget_versions.version_type%TYPE;
627: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
628: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
629:
630:
631: BEGIN

Line 739: FROM pa_budget_versions

735: BEGIN
736:
737: SELECT budget_version_id
738: INTO l_baselined_version_id
739: FROM pa_budget_versions
740: WHERE project_id = p_project_id
741: AND fin_plan_type_id = p_fin_plan_type_id
742: AND version_type = NVL(p_version_type,l_version_type)
743: AND current_flag = 'Y'

Line 1129: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%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
1133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 1130: ,p_version_type IN pa_budget_versions.version_type%TYPE

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
1133: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1134: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 1152: l_version_type pa_budget_versions.version_type%TYPE;

1148: --End of variables used for debugging
1149:
1150:
1151: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1152: l_version_type pa_budget_versions.version_type%TYPE;
1153: l_current_working_version_id pa_budget_versions.budget_version_id%TYPE;
1154: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1155:
1156:

Line 1153: l_current_working_version_id pa_budget_versions.budget_version_id%TYPE;

1149:
1150:
1151: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1152: l_version_type pa_budget_versions.version_type%TYPE;
1153: l_current_working_version_id pa_budget_versions.budget_version_id%TYPE;
1154: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1155:
1156:
1157: BEGIN

Line 1265: FROM pa_budget_versions

1261: END IF;
1262:
1263: SELECT budget_version_id
1264: INTO l_current_working_version_id
1265: FROM pa_budget_versions
1266: WHERE project_id = p_project_id
1267: AND fin_plan_type_id = p_fin_plan_type_id
1268: AND version_type = NVL(p_version_type,l_version_type)
1269: AND current_working_flag = 'Y'

Line 2339: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

2335: Takes as input a budget version id, and returns 'Y' if
2336: its PLAN_TYPE_CODE is 'ORG_FORECAST'. Otherwise, returns 'N'
2337: ===================================================== */
2338: FUNCTION is_orgforecast_plan
2339: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
2340: return VARCHAR2
2341: is
2342:
2343: l_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

Line 2349: from pa_budget_versions bv,

2345: BEGIN
2346: l_return_value := 'N';
2347: select pt.fin_plan_type_code
2348: into l_plan_type_code
2349: from pa_budget_versions bv,
2350: pa_fin_plan_types_b pt
2351: where bv.budget_version_id = p_budget_version_id and
2352: bv.fin_plan_type_id = pt.fin_plan_type_id;
2353: if l_plan_type_code = 'ORG_FORECAST' then

Line 2704: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE

2700: END Get_Element_Proj_PF_Amounts ;
2701:
2702: PROCEDURE Check_Version_Name_Or_id
2703: (
2704: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
2705: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
2706: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
2707: ,p_check_id_flag IN VARCHAR2
2708: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895

Line 2705: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562

2701:
2702: PROCEDURE Check_Version_Name_Or_id
2703: (
2704: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
2705: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
2706: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
2707: ,p_check_id_flag IN VARCHAR2
2708: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
2709: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 2706: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE

2702: PROCEDURE Check_Version_Name_Or_id
2703: (
2704: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
2705: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
2706: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
2707: ,p_check_id_flag IN VARCHAR2
2708: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
2709: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2710: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 2708: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895

2704: p_budget_version_id IN pa_budget_versions.BUDGET_VERSION_ID%TYPE
2705: ,p_project_id IN pa_budget_versions.project_id%TYPE -- Bug 2770562
2706: ,p_version_name IN pa_budget_versions.VERSION_NAME%TYPE
2707: ,p_check_id_flag IN VARCHAR2
2708: ,x_budget_version_id OUT NOCOPY pa_budget_versions.BUDGET_VERSION_ID%TYPE --File.Sql.39 bug 4440895
2709: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2710: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
2711: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
2712: )

Line 2752: FROM pa_budget_versions

2748: IF p_budget_version_id IS NOT NULL AND p_budget_version_id <> FND_API.G_MISS_NUM THEN
2749: IF p_check_id_flag = 'Y' THEN
2750: SELECT budget_version_id
2751: INTO x_budget_version_id
2752: FROM pa_budget_versions
2753: WHERE budget_version_id = p_budget_version_id;
2754: ELSIF p_check_id_flag = 'N' THEN
2755: x_budget_version_id := p_budget_version_id;
2756: END IF;

Line 2761: FROM pa_budget_versions

2757: ELSE
2758: IF (p_version_name IS NOT NULL) THEN
2759: SELECT budget_version_id
2760: INTO x_budget_version_id
2761: FROM pa_budget_versions
2762: WHERE version_name = p_version_name
2763: AND project_id = p_project_id ; -- Bug 2770562
2764: ELSE
2765: x_budget_version_id := NULL;

Line 3294: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3290: ==============================================================================*/
3291:
3292: PROCEDURE Check_Locked_By_User
3293: (p_user_id IN NUMBER,
3294: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3295: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3296: x_locked_by_person_id OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3297: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3298: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3305: from pa_budget_versions

3301:
3302: cursor budget_csr is
3303: select locked_by_person_id,
3304: budget_status_code
3305: from pa_budget_versions
3306: where budget_version_id = p_budget_version_id;
3307: budget_rec budget_csr%ROWTYPE;
3308:
3309: l_person_id pa_budget_versions.locked_by_person_id%TYPE;

Line 3309: l_person_id pa_budget_versions.locked_by_person_id%TYPE;

3305: from pa_budget_versions
3306: where budget_version_id = p_budget_version_id;
3307: budget_rec budget_csr%ROWTYPE;
3308:
3309: l_person_id pa_budget_versions.locked_by_person_id%TYPE;
3310: l_resource_id NUMBER;
3311: l_resource_name per_all_people_f.full_name%TYPE; -- VARCHAR2(80); for bug # 2933777
3312:
3313: -- local error handling variables

Line 3460: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,

3456: ==============================================================================*/
3457:
3458: PROCEDURE Check_Both_Locked_By_User
3459: (p_user_id IN NUMBER,
3460: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
3461: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
3462: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3463: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3464: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3461: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,

3457:
3458: PROCEDURE Check_Both_Locked_By_User
3459: (p_user_id IN NUMBER,
3460: p_budget_version_id1 IN pa_budget_versions.budget_version_id%TYPE,
3461: p_budget_version_id2 IN pa_budget_versions.budget_version_id%TYPE,
3462: x_is_locked_by_userid OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3463: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3464: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3465: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3469: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

3465: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3466: IS
3467: l_is_locked_by_userid1 VARCHAR2(1);
3468: l_is_locked_by_userid2 VARCHAR2(1);
3469: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
3470:
3471: -- local error handling variables
3472: l_return_status VARCHAR2(1);
3473: l_msg_count NUMBER := 0;

Line 3556: pa_budget_versions bv

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
3560: from pa_proj_fp_options pfo,

Line 3586: pa_budget_versions bv

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
3590: from pa_proj_fp_options pfo, pa_fin_plan_types_b pft ,

Line 4101: from pa_budget_versions

4097: where bud.budget_type_code = l_ac_budget_type_code --Bug 3764635.
4098: and exists
4099: (
4100: select budget_version_id
4101: from pa_budget_versions
4102: where project_id = p_project_id -- project id.
4103: and budget_type_code = bud.budget_type_code
4104: );
4105:

Line 4283: from pa_budget_versions

4279: where bud.budget_type_code = l_ar_budget_type_code --Bug 3764635.
4280: and exists
4281: (
4282: select budget_version_id
4283: from pa_budget_versions
4284: where project_id = p_project_id -- project id.
4285: and budget_type_code = bud.budget_type_code
4286: );
4287:

Line 4375: (p_project_id IN pa_budget_versions.project_id%TYPE

4371: is passed as 'Y'.
4372: ==============================================================================*/
4373:
4374: PROCEDURE Get_Max_Budget_Version_Number
4375: (p_project_id IN pa_budget_versions.project_id%TYPE
4376: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4377: ,p_version_type IN pa_budget_versions.version_type%TYPE
4378: ,p_copy_mode IN VARCHAR2
4379: ,p_ci_id IN NUMBER

Line 4376: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE

4372: ==============================================================================*/
4373:
4374: PROCEDURE Get_Max_Budget_Version_Number
4375: (p_project_id IN pa_budget_versions.project_id%TYPE
4376: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4377: ,p_version_type IN pa_budget_versions.version_type%TYPE
4378: ,p_copy_mode IN VARCHAR2
4379: ,p_ci_id IN NUMBER
4380: ,p_lock_required_flag IN VARCHAR2

Line 4377: ,p_version_type IN pa_budget_versions.version_type%TYPE

4373:
4374: PROCEDURE Get_Max_Budget_Version_Number
4375: (p_project_id IN pa_budget_versions.project_id%TYPE
4376: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4377: ,p_version_type IN pa_budget_versions.version_type%TYPE
4378: ,p_copy_mode IN VARCHAR2
4379: ,p_ci_id IN NUMBER
4380: ,p_lock_required_flag IN VARCHAR2
4381: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895

Line 4381: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895

4377: ,p_version_type IN pa_budget_versions.version_type%TYPE
4378: ,p_copy_mode IN VARCHAR2
4379: ,p_ci_id IN NUMBER
4380: ,p_lock_required_flag IN VARCHAR2
4381: ,x_version_number OUT NOCOPY pa_budget_versions.version_number%TYPE --File.Sql.39 bug 4440895
4382: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4383: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4384: ,x_msg_data OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
4385:

Line 4394: l_version_number pa_budget_versions.version_number%TYPE;

4390: l_msg_index_out NUMBER;
4391: l_return_status VARCHAR2(2000);
4392: l_debug_mode VARCHAR2(30);
4393:
4394: l_version_number pa_budget_versions.version_number%TYPE;
4395:
4396: BEGIN
4397:
4398: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 4441: FROM pa_budget_versions

4437: IF p_ci_id IS NULL THEN
4438: BEGIN
4439: SELECT NVL(max(version_number),0)
4440: INTO l_version_number
4441: FROM pa_budget_versions
4442: WHERE project_id = p_project_id
4443: AND fin_plan_type_id = p_fin_plan_type_id
4444: AND version_type = p_version_type
4445: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,

Line 4464: FROM pa_budget_versions

4460: IF l_version_number <> 0 AND nvl(p_lock_required_flag, 'N') = 'Y' THEN --bug 3677924
4461: BEGIN
4462: SELECT version_number
4463: INTO l_version_number
4464: FROM pa_budget_versions
4465: WHERE project_id = p_project_id
4466: AND fin_plan_type_id = p_fin_plan_type_id
4467: AND version_type = p_version_type
4468: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,

Line 4488: FROM pa_budget_versions

4484: END IF;
4485: ELSE
4486: SELECT NVL(max(version_number),0)
4487: INTO l_version_number
4488: FROM pa_budget_versions
4489: WHERE project_id = p_project_id
4490: AND fin_plan_type_id = p_fin_plan_type_id
4491: AND version_type = p_version_type
4492: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,

Line 4499: FROM pa_budget_versions

4495:
4496: IF l_version_number <> 0 AND nvl(p_lock_required_flag, 'N') = 'Y' THEN -- bug 3677924
4497: SELECT version_number
4498: INTO l_version_number
4499: FROM pa_budget_versions
4500: WHERE project_id = p_project_id
4501: AND fin_plan_type_id = p_fin_plan_type_id
4502: AND version_type = p_version_type
4503: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_WORKING,

Line 4514: FROM pa_budget_versions

4510: ELSIF p_copy_mode = PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED THEN
4511:
4512: SELECT NVL(max(version_number),0)
4513: INTO l_version_number
4514: FROM pa_budget_versions
4515: WHERE project_id = p_project_id
4516: AND fin_plan_type_id = p_fin_plan_type_id
4517: AND version_type = p_version_type
4518: AND budget_status_code IN (PA_FP_CONSTANTS_PKG.G_BUDGET_STATUS_BASELINED);

Line 4647: ( p_project_id IN pa_budget_versions.project_id%TYPE

4643: 2)If it is COST_ONLY or COST_AND_REV_SEP then it returns 'COST' version
4644: ===============================================================================*/
4645:
4646: PROCEDURE GET_COST_BASE_VERSION_INFO
4647: ( p_project_id IN pa_budget_versions.project_id%TYPE
4648: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4649: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4650: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4648: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE

4644: ===============================================================================*/
4645:
4646: PROCEDURE GET_COST_BASE_VERSION_INFO
4647: ( p_project_id IN pa_budget_versions.project_id%TYPE
4648: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4649: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4650: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4652: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4649: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

4645:
4646: PROCEDURE GET_COST_BASE_VERSION_INFO
4647: ( p_project_id IN pa_budget_versions.project_id%TYPE
4648: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4649: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4650: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4652: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4653: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4650: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

4646: PROCEDURE GET_COST_BASE_VERSION_INFO
4647: ( p_project_id IN pa_budget_versions.project_id%TYPE
4648: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4649: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4650: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4651: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4652: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4653: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4654: AS

Line 4670: l_version_type pa_budget_versions.version_type%TYPE;

4666:
4667: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4668: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4669:
4670: l_version_type pa_budget_versions.version_type%TYPE;
4671:
4672: BEGIN
4673:
4674: x_msg_count := 0;

Line 4847: ( p_project_id IN pa_budget_versions.project_id%TYPE

4843: 2)If it is REVENUE_ONLY or COST_AND_REV_SEP then it returns 'REVENUE' version
4844: ===============================================================================*/
4845:
4846: PROCEDURE GET_REV_BASE_VERSION_INFO
4847: ( p_project_id IN pa_budget_versions.project_id%TYPE
4848: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4849: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4850: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4851: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4848: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE

4844: ===============================================================================*/
4845:
4846: PROCEDURE GET_REV_BASE_VERSION_INFO
4847: ( p_project_id IN pa_budget_versions.project_id%TYPE
4848: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4849: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4850: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4851: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4852: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4849: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

4845:
4846: PROCEDURE GET_REV_BASE_VERSION_INFO
4847: ( p_project_id IN pa_budget_versions.project_id%TYPE
4848: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4849: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4850: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4851: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4852: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4853: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4850: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

4846: PROCEDURE GET_REV_BASE_VERSION_INFO
4847: ( p_project_id IN pa_budget_versions.project_id%TYPE
4848: ,p_fin_plan_Type_id IN pa_budget_versions.fin_plan_type_id%TYPE
4849: ,p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
4850: ,x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE --File.Sql.39 bug 4440895
4851: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4852: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4853: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4854: AS

Line 4870: l_version_type pa_budget_versions.version_type%TYPE;

4866:
4867: l_fin_plan_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
4868: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
4869:
4870: l_version_type pa_budget_versions.version_type%TYPE;
4871:
4872: BEGIN
4873:
4874: x_msg_count := 0;

Line 5073: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

5069: entered in project currency to project functional currency.
5070: ==================================================================*/
5071:
5072: PROCEDURE get_converted_amounts
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

Line 5074: ,p_txn_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE

5070: ==================================================================*/
5071:
5072: PROCEDURE get_converted_amounts
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

Line 5075: ,p_txn_burdened_cost IN pa_budget_versions.est_project_burdened_cost%TYPE

5071:
5072: PROCEDURE get_converted_amounts
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

Line 5076: ,p_txn_revenue IN pa_budget_versions.est_project_revenue%TYPE

5072: PROCEDURE get_converted_amounts
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

Line 5080: ,x_project_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

Line 5081: ,x_project_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

Line 5082: ,x_project_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895

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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
5086: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5083: ,x_projfunc_raw_cost OUT NOCOPY pa_budget_versions.est_projfunc_raw_cost%TYPE --File.Sql.39 bug 4440895

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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
5086: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5087: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895

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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
5086: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5087: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5088: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%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
5084: ,x_projfunc_burdened_cost OUT NOCOPY pa_budget_versions.est_projfunc_burdened_cost%TYPE --File.Sql.39 bug 4440895
5085: ,x_projfunc_revenue OUT NOCOPY pa_budget_versions.est_projfunc_revenue%TYPE --File.Sql.39 bug 4440895
5086: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5087: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5088: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
5089: AS

Line 5314: from pa_budget_versions bv

5310: into dummy
5311: from dual
5312: where exists
5313: (select 1
5314: from pa_budget_versions bv
5315: where bv.project_id = x_project_id
5316: --and bv.fin_plan_type_id = x_fin_plan_type_id
5317: and bv.approved_cost_plan_type_flag = 'Y'
5318: and bV.current_flag = 'Y');

Line 5336: from pa_budget_versions bv

5332: into dummy
5333: from dual
5334: where exists
5335: (select 1
5336: from pa_budget_versions bv
5337: where bv.project_id = x_project_id
5338: --and bv.fin_plan_type_id = x_fin_plan_type_id
5339: and bv.approved_rev_plan_type_flag = 'Y'
5340: and bV.current_flag = 'Y');

Line 5420: from pa_budget_versions bv

5416: into dummy
5417: from dual
5418: where exists
5419: (select 1
5420: from pa_budget_versions bv
5421: , pa_tasks t
5422: , pa_resource_assignments a
5423: where a.budget_version_id = bv.budget_version_id
5424: and a.task_id = t.task_id

Line 5447: from pa_budget_versions bv

5443: into dummy
5444: from dual
5445: where exists
5446: (select 1
5447: from pa_budget_versions bv
5448: , pa_tasks t
5449: , pa_resource_assignments a
5450: where a.budget_version_id = bv.budget_version_id
5451: and a.task_id = t.task_id

Line 5885: cursor cur_ci_ver(c_version_type pa_budget_versions.version_type%TYPE,

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,
5886: c_ci_id pa_budget_versions.ci_id%TYPE) IS
5887: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5888: FROM pa_budget_versions
5889: WHERE project_id = p_project_id

Line 5886: c_ci_id pa_budget_versions.ci_id%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,
5886: c_ci_id pa_budget_versions.ci_id%TYPE) IS
5887: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5888: FROM pa_budget_versions
5889: WHERE project_id = p_project_id
5890: AND version_type = nvl(c_version_type,version_type)

Line 5888: FROM pa_budget_versions

5884:
5885: cursor cur_ci_ver(c_version_type pa_budget_versions.version_type%TYPE,
5886: c_ci_id pa_budget_versions.ci_id%TYPE) IS
5887: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5888: FROM pa_budget_versions
5889: WHERE project_id = p_project_id
5890: AND version_type = nvl(c_version_type,version_type)
5891: AND ci_id = c_ci_id;
5892:

Line 5895: cursor cur_baselined_ver(c_version_type pa_budget_versions.version_type%TYPE) IS

5891: AND ci_id = c_ci_id;
5892:
5893: /* cur_ci_ver and cur_baselined_ver should have the same number and datatype of columns */
5894:
5895: cursor cur_baselined_ver(c_version_type pa_budget_versions.version_type%TYPE) IS
5896: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5897: FROM pa_budget_versions
5898: WHERE project_id = p_project_id
5899: AND current_flag = 'Y'

Line 5897: FROM pa_budget_versions

5893: /* cur_ci_ver and cur_baselined_ver should have the same number and datatype of columns */
5894:
5895: cursor cur_baselined_ver(c_version_type pa_budget_versions.version_type%TYPE) IS
5896: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5897: FROM pa_budget_versions
5898: WHERE project_id = p_project_id
5899: AND current_flag = 'Y'
5900: AND version_type = nvl(c_version_type,version_type)
5901: AND (NVL(Approved_Cost_Plan_Type_Flag ,'N') = 'Y' OR

Line 5904: cursor cur_working_ver(c_version_type pa_budget_versions.version_type%TYPE) IS

5900: AND version_type = nvl(c_version_type,version_type)
5901: AND (NVL(Approved_Cost_Plan_Type_Flag ,'N') = 'Y' OR
5902: NVL(Approved_Rev_Plan_Type_Flag ,'N') = 'Y' );
5903:
5904: cursor cur_working_ver(c_version_type pa_budget_versions.version_type%TYPE) IS
5905: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5906: FROM pa_budget_versions
5907: WHERE project_id = p_project_id
5908: AND current_working_flag = 'Y'

Line 5906: FROM pa_budget_versions

5902: NVL(Approved_Rev_Plan_Type_Flag ,'N') = 'Y' );
5903:
5904: cursor cur_working_ver(c_version_type pa_budget_versions.version_type%TYPE) IS
5905: SELECT budget_version_id, labor_quantity, est_quantity, equipment_quantity
5906: FROM pa_budget_versions
5907: WHERE project_id = p_project_id
5908: AND current_working_flag = 'Y'
5909: AND version_type = nvl(c_version_type,version_type)
5910: AND (NVL(Approved_Cost_Plan_Type_Flag ,'N') = 'Y' OR

Line 5973: FROM pa_budget_versions

5969: If the count is count is one, the qty info should be taken from the available version */
5970:
5971: SELECT count(1)
5972: INTO l_ver_count
5973: FROM pa_budget_versions
5974: WHERE project_id = p_project_id
5975: AND ci_id = p_ci_id;
5976:
5977: IF l_ver_count = 2 THEN

Line 6021: FROM pa_budget_versions

6017: ELSIF p_version_code = C_BASELINED_VERSION THEN
6018:
6019: SELECT count(1)
6020: INTO l_ver_count
6021: FROM pa_budget_versions
6022: WHERE project_id = p_project_id
6023: AND current_flag = 'Y'
6024: AND (Approved_Cost_Plan_Type_Flag = 'Y' OR
6025: Approved_Rev_Plan_Type_Flag = 'Y' );

Line 6056: FROM pa_budget_versions

6052: ELSIF p_version_code = C_WORKING_VERSION THEN
6053:
6054: SELECT count(1)
6055: INTO l_ver_count
6056: FROM pa_budget_versions
6057: WHERE project_id = p_project_id
6058: AND current_working_flag = 'Y'
6059: AND (Approved_Cost_Plan_Type_Flag = 'Y' OR
6060: Approved_Rev_Plan_Type_Flag = 'Y' );

Line 7138: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895

7134: (
7135: p_plan_version_id IN pa_proj_fp_options.fin_plan_version_id%TYPE
7136: ,x_fin_plan_type_id OUT NOCOPY pa_proj_fp_options.fin_plan_type_id%TYPE --File.Sql.39 bug 4440895
7137: ,x_plan_type_option_id OUT NOCOPY pa_proj_fp_options.proj_fp_options_id%TYPE --File.Sql.39 bug 4440895
7138: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
7139: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7140: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7141: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7142:

Line 7154: from pa_proj_fp_options o,pa_budget_versions v

7150: l_debug_mode VARCHAR2(1);
7151:
7152: cursor plan_type_cur(c_version_id pa_proj_fp_options.fin_plan_version_id%TYPE) is
7153: select o.fin_plan_type_id,o.proj_fp_options_id,v.version_type
7154: from pa_proj_fp_options o,pa_budget_versions v
7155: where o.fin_plan_type_id = v.fin_plan_type_id
7156: and o.project_id = v.project_id
7157: and v.budget_version_id = c_version_id
7158: and o.fin_plan_option_level_code = 'PLAN_TYPE';

Line 7680: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

7676:
7677: END GET_LOOKUP_CODE;
7678:
7679: FUNCTION HAS_PLANNABLE_ELEMENTS
7680: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
7681: RETURN VARCHAR2 is
7682:
7683: cursor cur_check_elements is
7684: SELECT 'Y'

Line 7710: ,px_version_type IN OUT NOCOPY pa_budget_Versions.version_type%TYPE --File.Sql.39 bug 4440895

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
7713: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7714: )IS

Line 8008: ,p_version_type IN pa_budget_Versions.version_type%TYPE

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
8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
8012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8009: ,p_version_number IN pa_budget_Versions.version_number%TYPE

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
8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
8012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8013: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 8010: ,x_budget_version_id OUT NOCOPY pa_budget_Versions.budget_version_id%TYPE --File.Sql.39 bug 4440895

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
8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
8012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8013: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8014: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895

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
8011: ,x_ci_id OUT NOCOPY pa_budget_Versions.ci_id%TYPE --File.Sql.39 bug 4440895
8012: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8013: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8014: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8015: )IS

Line 8031: FROM pa_budget_versions

8027: CURSOR l_budget_version_id_csr
8028: IS
8029: SELECT budget_version_id,
8030: ci_id
8031: FROM pa_budget_versions
8032: WHERE project_id=p_project_id
8033: AND fin_plan_type_id=p_fin_plan_type_id
8034: AND version_type=p_version_type
8035: AND version_number=p_version_number

Line 8146: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

8142: -- If both 1 and 2 are met it returns F for the parameter x_result
8143: -- T is returned otherise
8144:
8145: PROCEDURE perform_autobasline_checks
8146: ( p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
8147: ,x_result OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8148: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8149: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8150: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 8169: FROM pa_budget_versions pbv

8165: ,pbv.fin_plan_type_id
8166: ,pbv.version_type
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

Line 8301: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

8297: If the budget amount code is 'ALL' , it returns 'ALL'
8298: ==================================================================*/
8299:
8300: PROCEDURE get_version_type_for_bdgt_type
8301: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
8302: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
8303: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8304: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8305: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 8302: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895

8298: ==================================================================*/
8299:
8300: PROCEDURE get_version_type_for_bdgt_type
8301: ( p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE
8302: ,x_version_type OUT NOCOPY pa_budget_versions.version_type%TYPE --File.Sql.39 bug 4440895
8303: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8304: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8305: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
8306: AS

Line 8453: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

8449: * - Attachments for Financial Planning (Post-K one-off)
8450: * - pa_fp_webadi_pkg.validate_header_info (FP.M)
8451: */
8452: PROCEDURE validate_editable_bv
8453: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8454: p_user_id IN NUMBER,
8455:
8456: --Bug 3986129: FP.M Web ADI Dev changes, a new parameter added
8457: p_context IN VARCHAR2,

Line 8459: x_locked_by_person_id OUT NOCOPY pa_budget_versions.locked_by_person_id%TYPE, --File.Sql.39 bug 4440895

8455:
8456: --Bug 3986129: FP.M Web ADI Dev changes, a new parameter added
8457: p_context IN VARCHAR2,
8458: p_excel_calling_mode IN VARCHAR2,
8459: x_locked_by_person_id OUT NOCOPY pa_budget_versions.locked_by_person_id%TYPE, --File.Sql.39 bug 4440895
8460: x_err_code OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8461: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
8462: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
8463: x_msg_data OUT NOCOPY VARCHAR2) is --File.Sql.39 bug 4440895

Line 8469: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

8465: l_person_id NUMBER(15);
8466: l_resource_id NUMBER(15);
8467: l_resource_name VARCHAR2(240);
8468:
8469: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
8470: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
8471: l_locked_by_name VARCHAR2(240);
8472:
8473: -- error-handling variables

Line 8470: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

8466: l_resource_id NUMBER(15);
8467: l_resource_name VARCHAR2(240);
8468:
8469: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
8470: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
8471: l_locked_by_name VARCHAR2(240);
8472:
8473: -- error-handling variables
8474: l_msg_count NUMBER(15);

Line 8480: l_request_id pa_budget_versions.request_id%TYPE;

8476: l_data VARCHAR2(2000);
8477: l_msg_index_out NUMBER(15);
8478:
8479: -- Bug 3057564, jwhite, 22-JUL-03 -----------------------------
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;

Line 8486: l_version_type pa_budget_versions.version_type%TYPE;

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:
8489: l_debug_mode VARCHAR2(1);
8490: l_debug_level3 CONSTANT NUMBER := 3;

Line 8492: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;

8488:
8489: l_debug_mode VARCHAR2(1);
8490: l_debug_level3 CONSTANT NUMBER := 3;
8491: l_module_name VARCHAR2(100) := 'validate_editable_bv' ;
8492: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
8493:
8494: BEGIN
8495:
8496: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 8529: FROM pa_budget_versions

8525: INTO l_budget_status_code,
8526: x_locked_by_person_id,
8527: l_request_id, -- Bug 3057564
8528: l_plan_processing_code
8529: FROM pa_budget_versions
8530: WHERE budget_version_id = p_budget_version_id;
8531:
8532: if l_budget_status_code = 'S' then
8533: if p_context <> 'WEBADI' then

Line 8812: pa_budget_versions bv

8808: l_project_id,
8809: l_fin_plan_type_id,
8810: l_version_type
8811: FROM pa_fin_plan_types_b fpt,
8812: pa_budget_versions bv
8813: WHERE bv.budget_version_id = p_budget_version_id
8814: AND bv.fin_plan_type_id = fpt.fin_plan_type_id;
8815:
8816: EXCEPTION

Line 8844: FROM pa_budget_versions a

8840: SELECT 'N'
8841: INTO is_edit_allowed
8842: FROM DUAL
8843: WHERE EXISTS ( SELECT 'X'
8844: FROM pa_budget_versions a
8845: WHERE a.project_id = l_project_id
8846: AND a.fin_plan_type_id = l_fin_plan_type_id
8847: AND a.version_type = l_version_type
8848: AND a.budget_status_code = 'B');

Line 8986: /* Bug 2993894 ,pa_budget_versions bv */ -- Commenting out code for FP.M, Tracking Bug No - 3354518

8982: pa_resource_assignments */
8983:
8984: /* SELECT 1
8985: FROM pa_fp_elements fe */
8986: /* Bug 2993894 ,pa_budget_versions bv */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8987: /* WHERE fe.task_id IN
8988: (SELECT pt.task_id
8989: FROM PA_TASKS pt */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8990: /* pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V

Line 8998: pa_budget_versions bv

8994: /* Bug 2993894 AND bv.budget_version_id = fe.fin_plan_version_id */
8995: /* UNION ALL */ -- Commenting out code for FP.M, Tracking Bug No - 3354518
8996: SELECT 1
8997: FROM pa_resource_assignments r,
8998: pa_budget_versions bv
8999: WHERE r.task_id IN
9000: (SELECT pt.task_id /*Changing refernece of pa_struct_task_wbs_v below to pa_tasks*/
9001: FROM PA_TASKS pt /*Reverting changes for FPM, view pa_struct_task_wbs_v cannot be used in connect by clause*/
9002: CONNECT BY PRIOR pt.task_id = pt.parent_task_id

Line 9025: pa_budget_versions bv

9021: WHERE EXISTS (
9022: SELECT 1
9023: FROM -- pa_fp_elements fe Commenting out for to replace pa_fp_elements by PA_RESOURCE_ASSIGNMENTS as part of FP.M, Tracking Bug No - 3354518
9024: pa_resource_assignments fe,
9025: pa_budget_versions bv
9026: WHERE fe.task_id IN
9027: (SELECT pt.task_id
9028: FROM PA_STRUCT_TASK_WBS_V pt
9029: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518

Line 9040: pa_budget_versions bv

9036: AND nvl(bv.wp_version_flag,'N') = 'N' -- Added for FP.M, Tracking Bug No - 3354518
9037: UNION ALL
9038: SELECT 1
9039: FROM pa_resource_assignments r,
9040: pa_budget_versions bv
9041: WHERE r.task_id IN
9042: (SELECT pt.task_id
9043: FROM PA_STRUCT_TASK_WBS_V pt
9044: -- pa_tasks pt Commenting out for to replace pa_tasks by PA_STRUCT_TASK_WBS_V as part of FP.M, Tracking Bug No - 3354518

Line 9552: -- pa_budget_versions denormalized amounts.

9548: -- PROJECT-level amounts:
9549: --
9550: -- 1) The old model SQL is coded in light of historical
9551: -- quality issues with the Budget Form population of the
9552: -- pa_budget_versions denormalized amounts.
9553: --
9554: -- 2) The new model SQL is coded with the assumption that
9555: -- there should be few bugs, if any, for the project-level
9556: -- denormalized columns. Additionally, since there are far more

Line 9587: , p_budget_type_code IN pa_budget_versions.budget_type_code%TYPE

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
9589: ) RETURN NUMBER
9590: IS
9591:

Line 9603: FROM pa_budget_versions v

9599: CURSOR projOld_csr
9600: IS
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

Line 9619: FROM pa_budget_versions

9615: CURSOR projNewFp_csr
9616: IS
9617: SELECT raw_cost
9618: , burdened_cost
9619: FROM pa_budget_versions
9620: WHERE project_id = p_project_id
9621: AND fin_plan_type_id = p_fin_plan_type_id
9622: AND current_flag = 'Y'
9623: AND version_type IN ('COST','ALL');

Line 9636: FROM pa_budget_versions v

9632: CURSOR taskOld_csr
9633: IS
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

Line 9669: FROM pa_budget_versions v

9665: CURSOR taskNewFp_csr
9666: IS
9667: SELECT sum(a.TOTAL_PLAN_RAW_COST)
9668: , sum(a.TOTAL_PLAN_BURDENED_COST)
9669: FROM pa_budget_versions v
9670: , pa_resource_assignments a
9671: WHERE v.project_id = p_project_id
9672: AND v.fin_plan_type_id = p_fin_plan_type_id
9673: AND v.current_flag = 'Y'

Line 9871: from pa_budget_versions

9867: select 'N'
9868: into x_editable_flag
9869: from dual where exists (
9870: select 1
9871: from pa_budget_versions
9872: where project_id = p_project_id
9873: and fin_plan_type_id = p_fin_plan_type_id
9874: and version_type = p_version_type
9875: and budget_status_code = 'B' );

Line 10003: ,p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%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
10007: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 10004: ,p_version_type IN pa_budget_versions.version_type%TYPE

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
10007: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10008: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 10025: l_version_type pa_budget_versions.version_type%TYPE;

10021:
10022: --End of variables used for debugging
10023:
10024: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10025: l_version_type pa_budget_versions.version_type%TYPE;
10026: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10027: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10028:
10029: BEGIN

Line 10026: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;

10022: --End of variables used for debugging
10023:
10024: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
10025: l_version_type pa_budget_versions.version_type%TYPE;
10026: l_current_original_version_id pa_budget_versions.budget_version_id%TYPE;
10027: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
10028:
10029: BEGIN
10030:

Line 10136: FROM pa_budget_versions

10132: END IF;
10133:
10134: SELECT budget_version_id
10135: INTO l_current_original_version_id
10136: FROM pa_budget_versions
10137: WHERE project_id = p_project_id
10138: AND fin_plan_type_id = p_fin_plan_type_id
10139: AND version_type = NVL(p_version_type,l_version_type)
10140: AND budget_status_code = 'B'

Line 10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

10225: from plan setting pages to maintain Include unspent amount through period lov.
10226: ==============================================================================*/
10227:
10228: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10232: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10233: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895

Line 10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895

10226: ==============================================================================*/
10227:
10228: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10232: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10233: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10234: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895

10227:
10228: PROCEDURE GET_ACTUAL_AMTS_THRU_PERIOD(
10229: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10230: ,x_record_version_number OUT NOCOPY pa_budget_versions.record_version_number%TYPE --File.Sql.39 bug 4440895
10231: ,x_actual_amts_thru_period OUT NOCOPY pa_budget_versions.actual_amts_thru_period%TYPE --File.Sql.39 bug 4440895
10232: ,x_first_future_pa_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10233: ,x_first_future_gl_period OUT NOCOPY pa_periods_all.period_name%TYPE --File.Sql.39 bug 4440895
10234: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10235: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 10311: FROM pa_budget_versions

10307: SELECT actual_amts_thru_period
10308: ,record_version_number
10309: INTO x_actual_amts_thru_period
10310: ,x_record_version_number
10311: FROM pa_budget_versions
10312: WHERE budget_version_id = p_budget_version_id;
10313:
10314: -- Fetch first future PA period
10315: IF l_debug_mode = 'Y' THEN

Line 10397: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

10393:
10394: /* To determine if a task is a planning element or not */
10395: -- Modified for Bug 3840993 --sagarwal
10396: FUNCTION IS_TASK_A_PLANNING_ELEMENT(
10397: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10398: ,p_task_id IN pa_tasks.task_id%TYPE)
10399: RETURN VARCHAR2 IS
10400: l_exists VARCHAR2(1);
10401: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

Line 10401: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;

10397: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10398: ,p_task_id IN pa_tasks.task_id%TYPE)
10399: RETURN VARCHAR2 IS
10400: l_exists VARCHAR2(1);
10401: l_structure_version_id pa_budget_versions.project_structure_version_id%TYPE;
10402:
10403: BEGIN
10404: /* Commented and modified for bug#5614245
10405: SELECT NVL(project_structure_version_id, PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )) */

Line 10408: FROM pa_budget_versions

10404: /* Commented and modified for bug#5614245
10405: SELECT NVL(project_structure_version_id, PA_PROJECT_STRUCTURE_UTILS.GET_FIN_STRUC_VER_ID(project_id )) */
10406: SELECT NVL(project_structure_version_id, pa_planning_element_utils.get_fin_struct_id(project_id, budget_version_id) )
10407: INTO l_structure_version_id
10408: FROM pa_budget_versions
10409: WHERE budget_Version_id=p_budget_version_id;
10410:
10411: IF p_task_id <> 0 THEN -- For Task Level Records
10412: SELECT 'Y'

Line 10446: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

10442:
10443: /* To determine if a task has resources attached to it as planning element */
10444:
10445: FUNCTION IS_RESOURCE_ATTACHED_TO_TASK(
10446: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
10447: ,p_task_id IN pa_resource_assignments.task_id%TYPE)
10448: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)
10449: RETURN VARCHAR2 IS
10450: l_exists VARCHAR2(1);

Line 10452: -- sagarwal -- Removed redundant join to pa_budget_versions from select statement below

10448: --,p_wbs_element_version_id IN pa_resource_assignments.wbs_element_version_id%TYPE)
10449: RETURN VARCHAR2 IS
10450: l_exists VARCHAR2(1);
10451: BEGIN
10452: -- sagarwal -- Removed redundant join to pa_budget_versions from select statement below
10453: SELECT 'Y'
10454: INTO l_exists
10455: FROM DUAL
10456: WHERE EXISTS (SELECT 'x'

Line 10491: p_project_id IN pa_budget_versions.project_id%TYPE

10487: b. else allow change
10488: ====================================================================*/
10489:
10490: PROCEDURE IS_WP_RL_UPDATEABLE(
10491: p_project_id IN pa_budget_versions.project_id%TYPE
10492: ,x_wp_rl_update_allowed_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10493: ,x_reason_msg_code OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10494: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
10495: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project

10989: Returns -1 if the plan type cannot have a version of that version type
10990: Returns NULL if no working version exists for the plan type*/
10991:
10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
10997: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895

10990: Returns NULL if no working version exists for the plan type*/
10991:
10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
10997: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
10998: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895

10991:
10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
10997: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
10998: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
10999: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895

Line 10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895

10992: PROCEDURE GET_CURR_WORKING_VERSION_IDS(P_fin_plan_type_id IN Pa_fin_plan_types_b.fin_plan_type_id%TYPE -- Id of the plan types
10993: ,P_project_id IN Pa_budget_versions.project_id%TYPE -- Id of the Project
10994: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI --File.Sql.39 bug 4440895
10995: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI --File.Sql.39 bug 4440895
10996: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI --File.Sql.39 bug 4440895
10997: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
10998: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
10999: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11000: IS

Line 11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI

11193: -- Since cost and revenue quantity figures are now both alreayd being retrieved and are passed
11194: -- in separate out params, p_version parameter is no longer required.
11195: -- Commenting out references of p_version_type_below - Bug 3902176
11196:
11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

Line 11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI

11194: -- in separate out params, p_version parameter is no longer required.
11195: -- Commenting out references of p_version_type_below - Bug 3902176
11196:
11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

Line 11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI

11195: -- Commenting out references of p_version_type_below - Bug 3902176
11196:
11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

Line 11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE

11196:
11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

Line 11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

11197: PROCEDURE GET_PROJ_IMPACT_AMOUNTS(p_cost_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the cost version associated with the CI
11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

Line 11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

11198: ,p_rev_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the revenue version associated with the CI
11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

Line 11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

11199: ,p_all_budget_version_id IN Pa_budget_versions.budget_version_id%TYPE -- ID of the all version associated with the CI
11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

Line 11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

11200: -- ,p_version_type IN pa_budget_versions.version_type%TYPE
11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11208: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895

Line 11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

11201: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895
11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11208: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
11209: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895

Line 11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

11202: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11208: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
11209: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
11210: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895

Line 11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

11203: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11204: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11205: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11206: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11207: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11208: ,X_margin OUT NOCOPY Number -- Margin --File.Sql.39 bug 4440895
11209: ,X_margin_percent OUT NOCOPY Number -- Margin percent --File.Sql.39 bug 4440895
11210: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code - Bug 3734840 --File.Sql.39 bug 4440895
11211: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 11216: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;

11212: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11213: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895
11214: IS
11215: l_margin_derived_from_code pa_proj_fp_options.margin_derived_from_code%TYPE;
11216: l_budget_version_id Pa_budget_versions.budget_version_id%TYPE;
11217:
11218: -- Start of variables used for debugging purpose
11219:
11220: l_msg_count NUMBER :=0;

Line 11344: FROM pa_budget_versions

11340: INTO x_labor_hrs_cost,
11341: x_equipment_hrs_cost,
11342: x_proj_raw_cost,
11343: x_proj_burdened_cost
11344: FROM pa_budget_versions
11345: WHERE budget_version_id = decode(nvl(p_cost_budget_version_id,-1),-1,p_all_budget_version_id,p_cost_budget_version_id);
11346: EXCEPTION
11347: WHEN NO_DATA_FOUND THEN
11348: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 11363: FROM pa_budget_versions

11359: Total_project_revenue
11360: INTO x_labor_hrs_rev,
11361: x_equipment_hrs_rev,
11362: x_proj_revenue
11363: FROM pa_budget_versions
11364: WHERE budget_version_id = decode(nvl(p_rev_budget_version_id,-1),-1,p_all_budget_version_id,p_rev_budget_version_id);
11365: EXCEPTION
11366: WHEN NO_DATA_FOUND THEN
11367: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 11480: ,P_ci_id IN Pa_budget_versions.ci_id%TYPE DEFAULT NULL -- Controm item id of the change document

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
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

Line 11482: -- ,p_version_type IN pa_budget_versions.version_type%TYPE

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
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895

Line 11483: ,X_proj_raw_cost OUT NOCOPY Pa_budget_versions.total_project_raw_cost%TYPE -- Raw Cost in PC --File.Sql.39 bug 4440895

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
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895

Line 11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895

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
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

Line 11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895

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
11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

Line 11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895

11484: ,X_proj_burdened_cost OUT NOCOPY Pa_budget_versions.total_project_burdened_cost%TYPE -- Burdened Cost in PC --File.Sql.39 bug 4440895
11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895

Line 11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895

11485: ,X_proj_revenue OUT NOCOPY Pa_budget_versions.total_project_revenue%TYPE -- Revenue in PC --File.Sql.39 bug 4440895
11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895

Line 11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895

11486: ,X_margin OUT NOCOPY NUMBER -- MARGIN --File.Sql.39 bug 4440895
11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895

Line 11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895

11487: ,X_margin_percent OUT NOCOPY NUMBER -- MARGIN percent --File.Sql.39 bug 4440895
11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11495: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895

Line 11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895

11488: ,X_labor_hrs_cost OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Cost --File.Sql.39 bug 4440895
11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11495: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
11496: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895

Line 11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895

11489: ,X_equipment_hrs_cost OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Cost --File.Sql.39 bug 4440895
11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11495: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
11496: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11497: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895

Line 11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895

11490: ,X_labor_hrs_rev OUT NOCOPY Pa_budget_versions.labor_quantity%TYPE -- Labor Hours Revenue --File.Sql.39 bug 4440895
11491: ,X_equipment_hrs_rev OUT NOCOPY Pa_budget_versions.equipment_quantity%TYPE -- Equipment Hours Revenue --File.Sql.39 bug 4440895
11492: ,X_cost_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Cost Budget Verison Id --File.Sql.39 bug 4440895
11493: ,X_rev_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- Revenue Budget Verison Id --File.Sql.39 bug 4440895
11494: ,X_all_budget_version_id OUT NOCOPY Pa_budget_versions.budget_version_id%TYPE -- All Budget Verison Id --File.Sql.39 bug 4440895
11495: ,X_margin_derived_from_code OUT NOCOPY pa_proj_fp_options.margin_derived_from_code%TYPE -- margin_derived_from_code of cost version - Bug 3734840 --File.Sql.39 bug 4440895
11496: ,x_return_status OUT NOCOPY VARCHAR2 -- Indicates the exit status of the API --File.Sql.39 bug 4440895
11497: ,x_msg_data OUT NOCOPY VARCHAR2 -- Indicates the error occurred --File.Sql.39 bug 4440895
11498: ,X_msg_count OUT NOCOPY NUMBER) -- Indicates the number of error messages --File.Sql.39 bug 4440895

Line 11800: FUNCTION does_bv_have_rej_lines(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

11796: END GET_SUMMARY_AMOUNTS;
11797:
11798:
11799: /* Function returns 'Y' if budget version has budget lines with rejection code. */
11800: FUNCTION does_bv_have_rej_lines(p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)
11801: RETURN VARCHAR2
11802: IS
11803: l_exists varchar2(1) := 'N';
11804: begin

Line 11955: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE)

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
11958: --Start of variables used for debugging
11959: l_debug_mode VARCHAR2(30);

Line 12048: FROM pa_budget_versions bv,

12044: SELECT 'N'
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

Line 12115: ,p_fin_plan_version_id IN pa_budget_versions.budget_version_id%TYPE

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
12118: IS
12119: l_delete_ok_flag varchar2(1);

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 12293: pa_budget_versions bv

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);
12297: Exception

Line 12373: FROM pa_budget_versions bv,

12369: Begin
12370: SELECT 'Y' INTO l_task_assignments_exist_flag
12371: FROM dual WHERE EXISTS
12372: (SELECT 1
12373: FROM pa_budget_versions bv,
12374: pa_resource_assignments ra
12375: WHERE bv.project_id = p_project_id
12376: AND bv.wp_version_flag = 'Y'
12377: AND ra.budget_version_id = bv.budget_version_id

Line 12461: pa_budget_versions bv

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);
12465: Exception

Line 12506: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

12502: PROCEDURE return_and_vldt_plan_prc_code
12503: (
12504: p_add_msg_to_stack IN VARCHAR2
12505: ,p_calling_context IN VARCHAR2
12506: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12507: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type
12508: ,p_target_ci_id IN pa_control_items.ci_id%TYPE
12509: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
12510: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895

Line 12509: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE

12505: ,p_calling_context IN VARCHAR2
12506: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12507: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type
12508: ,p_target_ci_id IN pa_control_items.ci_id%TYPE
12509: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
12510: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
12511: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
12512: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12513: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 12510: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895

12506: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
12507: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type
12508: ,p_target_ci_id IN pa_control_items.ci_id%TYPE
12509: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
12510: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
12511: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
12512: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12513: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
12514: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 12511: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895

12507: ,p_source_ci_id_tbl IN SYSTEM.pa_num_tbl_type
12508: ,p_target_ci_id IN pa_control_items.ci_id%TYPE
12509: ,p_plan_processing_code IN pa_budget_versions.plan_processing_code%TYPE
12510: ,x_final_plan_prc_code OUT NOCOPY pa_budget_versions.plan_processing_code%TYPE --File.Sql.39 bug 4440895
12511: ,x_targ_request_id OUT NOCOPY pa_budget_versions.request_id%TYPE --File.Sql.39 bug 4440895
12512: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12513: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
12514: ,x_msg_data OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
12515: ) IS

Line 12534: l_targ_ci_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;

12530:
12531: l_src_ci_impact_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
12532: l_no_of_targ_ci_version NUMBER;
12533: l_no_of_src_ci_version NUMBER;
12534: l_targ_ci_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;
12535: l_targ_cost_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12536: l_targ_rev_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12537: l_targ_cost_ci_err_flag VARCHAR2(1) := 'N';
12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';

Line 12535: l_targ_cost_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;

12531: l_src_ci_impact_type_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
12532: l_no_of_targ_ci_version NUMBER;
12533: l_no_of_src_ci_version NUMBER;
12534: l_targ_ci_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;
12535: l_targ_cost_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12536: l_targ_rev_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12537: l_targ_cost_ci_err_flag VARCHAR2(1) := 'N';
12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';
12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';

Line 12536: l_targ_rev_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;

12532: l_no_of_targ_ci_version NUMBER;
12533: l_no_of_src_ci_version NUMBER;
12534: l_targ_ci_ver_plan_prc_code pa_budget_versions.plan_processing_code%TYPE;
12535: l_targ_cost_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12536: l_targ_rev_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12537: l_targ_cost_ci_err_flag VARCHAR2(1) := 'N';
12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';
12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';
12540: l_targ_request_id pa_budget_versions.request_id%TYPE;

Line 12540: l_targ_request_id pa_budget_versions.request_id%TYPE;

12536: l_targ_rev_ci_ver_plan_prc_cd pa_budget_versions.plan_processing_code%TYPE;
12537: l_targ_cost_ci_err_flag VARCHAR2(1) := 'N';
12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';
12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';
12540: l_targ_request_id pa_budget_versions.request_id%TYPE;
12541: l_targ_cost_ci_req_id pa_budget_versions.request_id%TYPE;
12542: l_targ_rev_ci_req_id pa_budget_versions.request_id%TYPE;
12543: l_targ_ci_request_id pa_budget_versions.request_id%TYPE;
12544:

Line 12541: l_targ_cost_ci_req_id pa_budget_versions.request_id%TYPE;

12537: l_targ_cost_ci_err_flag VARCHAR2(1) := 'N';
12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';
12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';
12540: l_targ_request_id pa_budget_versions.request_id%TYPE;
12541: l_targ_cost_ci_req_id pa_budget_versions.request_id%TYPE;
12542: l_targ_rev_ci_req_id pa_budget_versions.request_id%TYPE;
12543: l_targ_ci_request_id pa_budget_versions.request_id%TYPE;
12544:
12545: BEGIN

Line 12542: l_targ_rev_ci_req_id pa_budget_versions.request_id%TYPE;

12538: l_targ_rev_ci_err_flag VARCHAR2(1) := 'N';
12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';
12540: l_targ_request_id pa_budget_versions.request_id%TYPE;
12541: l_targ_cost_ci_req_id pa_budget_versions.request_id%TYPE;
12542: l_targ_rev_ci_req_id pa_budget_versions.request_id%TYPE;
12543: l_targ_ci_request_id pa_budget_versions.request_id%TYPE;
12544:
12545: BEGIN
12546:

Line 12543: l_targ_ci_request_id pa_budget_versions.request_id%TYPE;

12539: l_incomp_imapact_exists VARCHAR2(1) := 'N';
12540: l_targ_request_id pa_budget_versions.request_id%TYPE;
12541: l_targ_cost_ci_req_id pa_budget_versions.request_id%TYPE;
12542: l_targ_rev_ci_req_id pa_budget_versions.request_id%TYPE;
12543: l_targ_ci_request_id pa_budget_versions.request_id%TYPE;
12544:
12545: BEGIN
12546:
12547: fnd_profile.get('PA_DEBUG_MODE',l_debug_mode);

Line 12605: FROM pa_budget_versions

12601: SELECT plan_processing_code,
12602: request_id
12603: INTO l_plan_processing_code,
12604: l_targ_request_id
12605: FROM pa_budget_versions
12606: WHERE budget_version_id = p_budget_version_id;
12607: ELSE
12608: l_plan_processing_code := p_plan_processing_code;
12609: END IF;

Line 12631: FROM pa_budget_versions

12627: ELSIF p_calling_context = 'CI' THEN
12628: BEGIN
12629: SELECT COUNT(*)
12630: INTO l_no_of_targ_ci_version
12631: FROM pa_budget_versions
12632: WHERE ci_id = p_target_ci_id;
12633:
12634: IF l_no_of_targ_ci_version = 1 THEN
12635: -- irrespective of the version type for the target CI version

Line 12641: FROM pa_budget_versions

12637: SELECT plan_processing_code,
12638: request_id
12639: INTO l_targ_ci_ver_plan_prc_code,
12640: l_targ_request_id
12641: FROM pa_budget_versions
12642: WHERE ci_id = p_target_ci_id;
12643:
12644: IF p_add_msg_to_stack = 'Y' THEN
12645: IF l_targ_ci_ver_plan_prc_code = 'XLUP' THEN

Line 12666: FROM pa_budget_versions

12662: SELECT plan_processing_code,
12663: request_id
12664: INTO l_targ_cost_ci_ver_plan_prc_cd,
12665: l_targ_cost_ci_req_id
12666: FROM pa_budget_versions
12667: WHERE ci_id = p_target_ci_id
12668: AND version_type = 'COST';
12669:
12670: SELECT plan_processing_code,

Line 12674: FROM pa_budget_versions

12670: SELECT plan_processing_code,
12671: request_id
12672: INTO l_targ_rev_ci_ver_plan_prc_cd,
12673: l_targ_rev_ci_req_id
12674: FROM pa_budget_versions
12675: WHERE ci_id = p_target_ci_id
12676: AND version_type = 'REVENUE';
12677:
12678:

Line 13006: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

13002: /* This procedure is called from FPWebadiAMImpl.java to get the structure version id
13003: * and the structure version status flag to be used as URL parameter for BNE URL
13004: */
13005: PROCEDURE return_struct_ver_info
13006: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
13007: x_struct_version_id OUT NOCOPY pa_proj_element_versions.parent_structure_version_id%TYPE,
13008: x_struct_status_flag OUT NOCOPY VARCHAR2,
13009: x_return_status OUT NOCOPY VARCHAR2,
13010: x_msg_count OUT NOCOPY NUMBER,

Line 13063: FROM pa_budget_versions

13059:
13060: BEGIN
13061: SELECT project_id
13062: INTO l_project_id
13063: FROM pa_budget_versions
13064: WHERE budget_version_id = p_budget_version_id;
13065: EXCEPTION
13066: WHEN NO_DATA_FOUND THEN
13067: IF l_debug_mode = 'Y' THEN

Line 13136: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)

13132: * code for the version and caches it in a package variable for the first time
13133: * and uses it to read and return to avoid select every time for each row
13134: * in the excel download view query
13135: */
13136: FUNCTION get_cached_time_phased_code (bv_id IN pa_budget_versions.budget_version_id%TYPE)
13137: RETURN VARCHAR2
13138: IS
13139: l_time_phased_code pa_proj_fp_options.cost_time_phased_code%TYPE;
13140: BEGIN

Line 13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

13193:
13194: /*Parameters due fin plan model */
13195: ,p_fin_plan_type_id IN pa_fin_plan_types_b.fin_plan_type_id%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
13196: ,p_fin_plan_type_name IN pa_fin_plan_types_vl.name%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13197: ,p_version_type IN pa_budget_versions.version_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13198: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13199: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13200: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR
13201: ,p_projfunc_cost_rate_type IN pa_proj_fp_options.projfunc_cost_rate_type%TYPE := PA_INTERFACE_UTILS_PUB.G_PA_MISS_CHAR

Line 13239: l_version_type pa_budget_versions.version_type%TYPE;

13235: l_workflow_started VARCHAR2(1);
13236: --End of variables used for debugging
13237: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13239: l_version_type pa_budget_versions.version_type%TYPE;
13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13243:

Line 13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;

13236: --End of variables used for debugging
13237: l_budget_lines_out_tbl pa_budget_pub.budget_line_out_tbl_type;
13238: l_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
13239: l_version_type pa_budget_versions.version_type%TYPE;
13240: l_baselined_version_id pa_budget_versions.budget_version_id%TYPE;
13241: l_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
13242: l_approved_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
13243:
13244: BEGIN