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_PUB dependencies on PA_BUDGET_VERSIONS

Line 25: p_project_id IN pa_budget_versions.project_id%TYPE,

21:
22: --Bug 3964755. Introduced the parameter p_calling_context. Valid values are NULL and 'COPY_PROJECT'
23: procedure Submit_Current_Working
24: (p_calling_context IN VARCHAR2 DEFAULT NULL,
25: p_project_id IN pa_budget_versions.project_id%TYPE,
26: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
27: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 26: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

22: --Bug 3964755. Introduced the parameter p_calling_context. Valid values are NULL and 'COPY_PROJECT'
23: procedure Submit_Current_Working
24: (p_calling_context IN VARCHAR2 DEFAULT NULL,
25: p_project_id IN pa_budget_versions.project_id%TYPE,
26: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
27: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 27: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

23: procedure Submit_Current_Working
24: (p_calling_context IN VARCHAR2 DEFAULT NULL,
25: p_project_id IN pa_budget_versions.project_id%TYPE,
26: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
27: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
28: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
30: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
31: is

Line 34: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

30: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
31: is
32: l_debug_mode VARCHAR2(30);
33: l_valid_flag VARCHAR2(1);
34: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
38: /* Bug# 2661650 - _vl to _b/_tl for performance changes */

Line 35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

31: is
32: l_debug_mode VARCHAR2(30);
33: l_valid_flag VARCHAR2(1);
34: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
38: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
39: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;

Line 36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;

32: l_debug_mode VARCHAR2(30);
33: l_valid_flag VARCHAR2(1);
34: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
38: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
39: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
40:

Line 37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;

33: l_valid_flag VARCHAR2(1);
34: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
35: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
36: l_plan_processing_code pa_budget_versions.plan_processing_code%TYPE;
37: l_locked_by_person_id pa_budget_versions.locked_by_person_id%TYPE;
38: /* Bug# 2661650 - _vl to _b/_tl for performance changes */
39: l_fin_plan_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
40:
41: l_msg_count NUMBER := 0;

Line 79: pa_budget_versions

75: l_budget_status_code,
76: l_plan_processing_code,
77: l_locked_by_person_id
78: from
79: pa_budget_versions
80: where
81: budget_version_id = p_budget_version_id;
82: select pt.fin_plan_type_code
83: into l_fin_plan_type_code

Line 178: pa_budget_versions

174: */
175: if l_fin_plan_type_code = 'ORG_FORECAST' then
176: /* set the BUDGET_STATUS_CODE from 'W' to 'S' */
177: update
178: pa_budget_versions
179: set
180: last_update_date=SYSDATE,
181: last_updated_by=FND_GLOBAL.user_id,
182: last_update_login=FND_GLOBAL.login_id,

Line 248: (p_project_id IN pa_budget_versions.project_id%TYPE,

244: -- FP M -- Resource list is changeable even if baselined version exists. Versions can
245: -- be set as CW, even if the resource list of the version that is being made CW doesnt
246: -- match the resource list of the baselined version.
247: procedure Set_Current_Working
248: (p_project_id IN pa_budget_versions.project_id%TYPE,
249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

245: -- be set as CW, even if the resource list of the version that is being made CW doesnt
246: -- match the resource list of the baselined version.
247: procedure Set_Current_Working
248: (p_project_id IN pa_budget_versions.project_id%TYPE,
249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
253: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

246: -- match the resource list of the baselined version.
247: procedure Set_Current_Working
248: (p_project_id IN pa_budget_versions.project_id%TYPE,
249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
253: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
254: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

247: procedure Set_Current_Working
248: (p_project_id IN pa_budget_versions.project_id%TYPE,
249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
253: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
254: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
255: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

248: (p_project_id IN pa_budget_versions.project_id%TYPE,
249: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
250: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
251: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
252: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
253: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
254: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
255: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
256: is

Line 260: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

256: is
257: l_debug_mode VARCHAR2(30);
258: l_valid1_flag VARCHAR2(1);
259: l_valid2_flag VARCHAR2(1);
260: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
261: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
262: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_msg_count NUMBER := 0;

Line 261: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;

257: l_debug_mode VARCHAR2(30);
258: l_valid1_flag VARCHAR2(1);
259: l_valid2_flag VARCHAR2(1);
260: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
261: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
262: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_msg_count NUMBER := 0;
265: l_data VARCHAR2(2000);

Line 262: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

258: l_valid1_flag VARCHAR2(1);
259: l_valid2_flag VARCHAR2(1);
260: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
261: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
262: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_msg_count NUMBER := 0;
265: l_data VARCHAR2(2000);
266: l_msg_data VARCHAR2(2000);

Line 263: l_version_type pa_budget_versions.version_type%TYPE;

259: l_valid2_flag VARCHAR2(1);
260: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
261: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
262: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
263: l_version_type pa_budget_versions.version_type%TYPE;
264: l_msg_count NUMBER := 0;
265: l_data VARCHAR2(2000);
266: l_msg_data VARCHAR2(2000);
267: l_return_status VARCHAR2(2000);

Line 274: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

270: l_attributes_same_flag VARCHAR2(1);
271: l_exists VARCHAR2(1);
272:
273: -- for BUG FIX 2733848
274: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
275:
276: begin
277: FND_MSG_PUB.initialize;
278: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 335: pa_budget_versions

331: l_budget_status_code
332: ,l_fin_plan_type_id
333: ,l_version_type
334: from
335: pa_budget_versions
336: where
337: budget_version_id=p_orig_budget_version_id;
338: if (l_budget_status_code='S') and (p_budget_version_id <> p_orig_budget_version_id) then
339: x_return_status := FND_API.G_RET_STS_ERROR;

Line 385: from pa_budget_versions bv

381:
382: BEGIN
383: Select budget_version_id
384: into l_cur_work_bv_id
385: from pa_budget_versions bv
386: where bv.project_id = p_project_id
387: and bv.fin_plan_type_id = l_fin_plan_type_id
388: and bv.version_type = l_version_type
389: and bv.current_working_flag = 'Y'

Line 419: from pa_budget_versions bv

415: select 'Y'
416: into l_exists
417: from dual
418: where exists (select 'x'
419: from pa_budget_versions bv
420: ,pa_control_items ci
421: ,pa_ci_impacts cp
422: --For bug 3550073
423: ,pa_ci_statuses_v pcs

Line 471: pa_budget_versions cur_baseline

467: )
468: -- filter cis included in current baseline version
469: and eligible.ci_id not in (select merged.ci_id
470: from pa_fp_merged_ctrl_items merged,
471: pa_budget_versions cur_baseline
472: where cur_baseline.project_id = p_project_id
473: and cur_baseline.fin_plan_type_id = l_fin_plan_type_id
474: and cur_baseline.version_type = l_version_type
475: and cur_baseline.budget_status_code = 'B'

Line 547: pa_budget_versions

543: /* remove the CURRENT_WORKING status from the old current working version */
544: /* ONLY if there is an old current working version */
545: if p_orig_budget_version_id is not null then
546: update
547: pa_budget_versions
548: set
549: last_update_date=SYSDATE,
550: last_updated_by=FND_GLOBAL.user_id,
551: last_update_login=FND_GLOBAL.login_id,

Line 559: pa_budget_versions

555: budget_version_id=p_orig_budget_version_id;
556: end if;
557: /* crown the CURRENT_WORKING status to the new current working version */
558: update
559: pa_budget_versions
560: set
561: last_update_date=SYSDATE,
562: last_updated_by=FND_GLOBAL.user_id,
563: last_update_login=FND_GLOBAL.login_id,

Line 592: (p_project_id IN pa_budget_versions.project_id%TYPE,

588: end Set_Current_Working;
589: /* ------------------------------------------------------------------------- */
590:
591: procedure Rework_Submitted
592: (p_project_id IN pa_budget_versions.project_id%TYPE,
593: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
594: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
595: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
596: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 593: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

589: /* ------------------------------------------------------------------------- */
590:
591: procedure Rework_Submitted
592: (p_project_id IN pa_budget_versions.project_id%TYPE,
593: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
594: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
595: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
596: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
597: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 594: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

590:
591: procedure Rework_Submitted
592: (p_project_id IN pa_budget_versions.project_id%TYPE,
593: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
594: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
595: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
596: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
597: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
598: is

Line 601: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

597: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
598: is
599: l_debug_mode VARCHAR2(30);
600: l_valid_flag VARCHAR2(1);
601: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
602: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
603:
604: l_msg_count NUMBER := 0;
605: l_data VARCHAR2(2000);

Line 602: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

598: is
599: l_debug_mode VARCHAR2(30);
600: l_valid_flag VARCHAR2(1);
601: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
602: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
603:
604: l_msg_count NUMBER := 0;
605: l_data VARCHAR2(2000);
606: l_msg_data VARCHAR2(2000);

Line 639: pa_budget_versions

635: into
636: l_budget_status_code,
637: l_current_working_flag
638: from
639: pa_budget_versions
640: where
641: budget_version_id = p_budget_version_id;
642: if ((l_budget_status_code <> 'S') or (l_current_working_flag <> 'Y')) then
643: IF P_PA_DEBUG_MODE = 'Y' THEN

Line 691: pa_budget_versions

687: END IF;
688: SAVEPOINT PA_FIN_PLAN_PUB_REWORK;
689: /* set the BUDGET_STATUS_CODE from 'W' to 'S' */
690: update
691: pa_budget_versions
692: set
693: last_update_date=SYSDATE,
694: last_updated_by=FND_GLOBAL.user_id,
695: last_update_login=FND_GLOBAL.login_id,

Line 725: (p_project_id IN pa_budget_versions.project_id%TYPE,

721: end Rework_Submitted;
722: /* ------------------------------------------------------------------------- */
723:
724: procedure Mark_As_Original
725: (p_project_id IN pa_budget_versions.project_id%TYPE,
726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

722: /* ------------------------------------------------------------------------- */
723:
724: procedure Mark_As_Original
725: (p_project_id IN pa_budget_versions.project_id%TYPE,
726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
730: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

723:
724: procedure Mark_As_Original
725: (p_project_id IN pa_budget_versions.project_id%TYPE,
726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
730: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
731: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

724: procedure Mark_As_Original
725: (p_project_id IN pa_budget_versions.project_id%TYPE,
726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
730: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
731: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
732: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

725: (p_project_id IN pa_budget_versions.project_id%TYPE,
726: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
727: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
728: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
729: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
730: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
731: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
732: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
733: is

Line 818: update pa_budget_versions a

814:
815: /* Bug # 2639285 - Included the update in case p_orig_budget_version_id is null */
816: IF p_orig_budget_version_id is null THEN
817:
818: update pa_budget_versions a
819: set original_flag = 'Y',
820: current_original_flag = 'N',
821: last_update_date = SYSDATE,
822: last_updated_by=FND_GLOBAL.user_id,

Line 827: from pa_budget_versions b

823: last_update_login=FND_GLOBAL.login_id,
824: record_version_number = record_version_number + 1
825: where (a.project_id,a.fin_plan_type_id,a.version_type) =
826: (select b.project_id,b.fin_plan_type_id,b.version_type
827: from pa_budget_versions b
828: where b.budget_version_id = p_budget_version_id)
829: and a.budget_version_id <> p_budget_version_id
830: and current_original_flag = 'Y';
831: ELSE

Line 833: pa_budget_versions

829: and a.budget_version_id <> p_budget_version_id
830: and current_original_flag = 'Y';
831: ELSE
832: update
833: pa_budget_versions
834: set
835: last_update_date=SYSDATE,
836: last_updated_by=FND_GLOBAL.user_id,
837: last_update_login=FND_GLOBAL.login_id,

Line 846: pa_budget_versions

842: budget_version_id=p_orig_budget_version_id;
843: END IF;
844: /* crown the ORIGINAL status to the new original version */
845: update
846: pa_budget_versions
847: set
848: last_update_date=SYSDATE,
849: last_updated_by=FND_GLOBAL.user_id,
850: last_update_login=FND_GLOBAL.login_id,

Line 909: (p_project_id IN pa_budget_versions.project_id%TYPE,

905: -- FPM onwards. This parameter is defaulted as 'BUGDET' is the spec. So existing calls
906: -- need not be modified
907: ----------------------------------------------------------------------------------------
908: procedure Delete_Version
909: (p_project_id IN pa_budget_versions.project_id%TYPE,
910: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
911: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
912: p_context IN VARCHAR2,
913: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 910: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

906: -- need not be modified
907: ----------------------------------------------------------------------------------------
908: procedure Delete_Version
909: (p_project_id IN pa_budget_versions.project_id%TYPE,
910: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
911: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
912: p_context IN VARCHAR2,
913: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
914: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 911: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

907: ----------------------------------------------------------------------------------------
908: procedure Delete_Version
909: (p_project_id IN pa_budget_versions.project_id%TYPE,
910: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
911: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
912: p_context IN VARCHAR2,
913: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
914: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
915: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 926: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

922: l_msg_index_out NUMBER;
923: l_return_status VARCHAR2(2000);
924:
925: l_valid_flag VARCHAR2(1);
926: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
927: l_version_type pa_budget_versions.version_type%TYPE;
928: l_current_working_flag VARCHAR2(1);
929: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
930: l_max_version NUMBER;

Line 927: l_version_type pa_budget_versions.version_type%TYPE;

923: l_return_status VARCHAR2(2000);
924:
925: l_valid_flag VARCHAR2(1);
926: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
927: l_version_type pa_budget_versions.version_type%TYPE;
928: l_current_working_flag VARCHAR2(1);
929: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
930: l_max_version NUMBER;
931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;

Line 929: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

925: l_valid_flag VARCHAR2(1);
926: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
927: l_version_type pa_budget_versions.version_type%TYPE;
928: l_current_working_flag VARCHAR2(1);
929: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
930: l_max_version NUMBER;
931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
932: l_exists varchar2(1);
933: l_module_name VARCHAR2(100):='PAFPPUBB.delete_version';

Line 931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;

927: l_version_type pa_budget_versions.version_type%TYPE;
928: l_current_working_flag VARCHAR2(1);
929: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
930: l_max_version NUMBER;
931: l_cur_work_bv_id pa_budget_versions.budget_version_id%TYPE;
932: l_exists varchar2(1);
933: l_module_name VARCHAR2(100):='PAFPPUBB.delete_version';
934: l_wp_fin_plan_type_id pa_fin_plan_types_b.fin_plan_type_id%TYPE;
935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;

Line 939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

935: l_budget_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE;
936:
937: /* Bug 2688610 - Add the following two locals*/
938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
940:
941: -- Bug 3354518 FP M Doosan Phase 1 changes
942: l_current_original_flag pa_budget_versions.current_original_flag%TYPE;
943: l_current_flag pa_budget_versions.original_flag%TYPE;

Line 942: l_current_original_flag pa_budget_versions.current_original_flag%TYPE;

938: l_baseline_funding_flag pa_projects_all.baseline_funding_flag%TYPE;
939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
940:
941: -- Bug 3354518 FP M Doosan Phase 1 changes
942: l_current_original_flag pa_budget_versions.current_original_flag%TYPE;
943: l_current_flag pa_budget_versions.original_flag%TYPE;
944:
945: cursor l_resource_assignments_csr is
946: select unique

Line 943: l_current_flag pa_budget_versions.original_flag%TYPE;

939: l_approved_rev_plan_type_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
940:
941: -- Bug 3354518 FP M Doosan Phase 1 changes
942: l_current_original_flag pa_budget_versions.current_original_flag%TYPE;
943: l_current_flag pa_budget_versions.original_flag%TYPE;
944:
945: cursor l_resource_assignments_csr is
946: select unique
947: resource_assignment_id

Line 1047: pa_budget_versions

1043: l_version_type,
1044: l_current_original_flag, -- Bug 3354518 FP M
1045: l_current_flag -- Bug 3354518 FP M
1046: from
1047: pa_budget_versions
1048: where
1049: budget_version_id = p_budget_version_id;
1050:
1051: if l_budget_status_code <> 'W' then

Line 1075: from pa_projects_all p, pa_budget_versions v

1071: */
1072: BEGIN
1073: select p.baseline_funding_flag, v.approved_rev_plan_type_flag
1074: into l_baseline_funding_flag, l_approved_rev_plan_type_flag
1075: from pa_projects_all p, pa_budget_versions v
1076: where p.project_id = v.project_id
1077: and v.budget_version_id = p_budget_version_id;
1078: EXCEPTION
1079: WHEN NO_DATA_FOUND THEN

Line 1095: from pa_budget_versions bv

1091:
1092: BEGIN
1093: Select budget_version_id
1094: into l_cur_work_bv_id
1095: from pa_budget_versions bv
1096: where bv.project_id = p_project_id
1097: and bv.fin_plan_type_id = l_fin_plan_type_id
1098: and bv.version_type = l_version_type
1099: and bv.current_working_flag = 'Y'

Line 1123: WHERE EXISTS ( SELECT 'X' from pa_budget_versions pb,pa_control_items pci -- added pa_control_items pci for bug 3741051

1119:
1120: SELECT 'Y'
1121: INTO l_exists
1122: FROM dual
1123: WHERE EXISTS ( SELECT 'X' from pa_budget_versions pb,pa_control_items pci -- added pa_control_items pci for bug 3741051
1124: WHERE pb.project_id = p_project_id --added the alias name for bug 3741051
1125: AND pb.fin_plan_type_id = l_fin_plan_type_id -- added the alias name for bug 3741051
1126: AND pb.version_type = l_version_type -- added the alias name for bug 3741051
1127: AND pb.project_id = pci.project_id -- added for bug 3741051

Line 1208: /* call Delete_Version_Helper to delete everything but the entry in PA_BUDGET_VERSIONS and PA_PROJ_FP_OPTIONS */

1204:
1205: l_wp_fin_plan_type_id:=NULL;
1206:
1207: END IF;
1208: /* call Delete_Version_Helper to delete everything but the entry in PA_BUDGET_VERSIONS and PA_PROJ_FP_OPTIONS */
1209: pa_fin_plan_pub.Delete_Version_Helper
1210: (p_project_id => p_project_id,
1211: p_context => p_context,
1212: p_budget_version_id => p_budget_version_id,

Line 1248: /* PA_BUDGET_VERSIONS delete row */

1244:
1245:
1246:
1247:
1248: /* PA_BUDGET_VERSIONS delete row */
1249: /* Bug 4873352 - Split this delete based on i/p parameter null condition
1250: * to avoid FTS - Sql id : 14903057 */
1251: if p_budget_version_id is not null then
1252: delete

Line 1254: pa_budget_versions

1250: * to avoid FTS - Sql id : 14903057 */
1251: if p_budget_version_id is not null then
1252: delete
1253: from
1254: pa_budget_versions
1255: where
1256: budget_version_id=p_budget_version_id AND
1257: project_id=nvl(p_project_id,project_id) AND
1258: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1264: pa_budget_versions

1260: bulk collect into l_budget_version_id_tbl ;
1261: elsif p_project_id is not null then
1262: delete
1263: from
1264: pa_budget_versions
1265: where
1266: budget_version_id=nvl(p_budget_version_id,budget_version_id) AND
1267: project_id=p_project_id AND
1268: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1279: pa_budget_versions

1275: * future cases, in case this logic changes or addtl parameters are included.
1276: */
1277: delete
1278: from
1279: pa_budget_versions
1280: where
1281: budget_version_id=nvl(p_budget_version_id,budget_version_id) AND
1282: project_id=nvl(p_project_id,project_id) AND
1283: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1302: pa_budget_versions

1298: nvl(max(version_number), 0)
1299: into
1300: l_max_version
1301: from
1302: pa_budget_versions
1303: where
1304: project_id = p_project_id and
1305: fin_plan_type_id = l_fin_plan_type_id and
1306: budget_status_code = 'W' and

Line 1314: pa_budget_versions

1310:
1311: /* make it the Current Working version */
1312: if (l_max_version <> 0) then
1313: update
1314: pa_budget_versions
1315: set
1316: current_working_flag = 'Y',
1317: last_update_date=SYSDATE,
1318: last_updated_by=FND_GLOBAL.user_id,

Line 1337: (X_entity_name => 'PA_BUDGET_VERSIONS',

1333: -- only for BUDGET Context -- CHECK FOR CURRENT WORKING VERSIONS ENDS
1334: ----------------------------------------------------------------------
1335: -- Delete attachements which are associated with the budget version
1336: fnd_attached_documents2_pkg.delete_attachments
1337: (X_entity_name => 'PA_BUDGET_VERSIONS',
1338: X_pk1_value => to_char(p_budget_version_id),
1339: X_delete_document_flag => 'Y');
1340:
1341: /* FP M - Reporting lines integration */

Line 1417: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

1413: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
1414: procedure Delete_Version_Helper
1415: (p_project_id IN pa_projects_all.project_id%TYPE ,
1416: p_context IN VARCHAR2 ,
1417: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1418: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1419: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1420: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1421: is

Line 1430: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

1426: l_msg_index_out NUMBER;
1427: l_return_status VARCHAR2(2000);
1428:
1429: l_valid_flag VARCHAR2(1);
1430: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1431: l_max_version NUMBER;
1432:
1433: l_project_id pa_budget_versions.project_id%TYPE;
1434: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 1433: l_project_id pa_budget_versions.project_id%TYPE;

1429: l_valid_flag VARCHAR2(1);
1430: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1431: l_max_version NUMBER;
1432:
1433: l_project_id pa_budget_versions.project_id%TYPE;
1434: l_ci_id pa_budget_versions.ci_id%TYPE;
1435: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1436: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1437: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';

Line 1434: l_ci_id pa_budget_versions.ci_id%TYPE;

1430: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1431: l_max_version NUMBER;
1432:
1433: l_project_id pa_budget_versions.project_id%TYPE;
1434: l_ci_id pa_budget_versions.ci_id%TYPE;
1435: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1436: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1437: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';
1438: i NUMBER;

Line 1742: FROM pa_budget_versions

1738: SELECT project_id,
1739: ci_id
1740: INTO l_project_id,
1741: l_ci_id
1742: FROM pa_budget_versions
1743: WHERE budget_version_id = p_budget_version_id;
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: pa_debug.g_err_stage:= 'Error while Fetching the data for '||p_budget_version_id;

Line 1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,

1830: p_source_project_id IN pa_projects_all.project_id%TYPE,
1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1836: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1837: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1838: )

Line 1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,

1831: p_target_project_id IN pa_projects_all.project_id%TYPE,
1832: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1833: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1834: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1835: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1836: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1837: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1838: )
1839: IS

Line 1948: (p_project_id IN pa_budget_versions.project_id%TYPE,

1944: the Optional Upgrade process is run on the source version.
1945: ================================================================================*/
1946:
1947: PROCEDURE Copy_Version
1948: (p_project_id IN pa_budget_versions.project_id%TYPE,
1949: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
1950: p_copy_mode IN VARCHAR2,
1951: p_adj_percentage IN NUMBER DEFAULT 0,
1952: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

Line 1949: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

1945: ================================================================================*/
1946:
1947: PROCEDURE Copy_Version
1948: (p_project_id IN pa_budget_versions.project_id%TYPE,
1949: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
1950: p_copy_mode IN VARCHAR2,
1951: p_adj_percentage IN NUMBER DEFAULT 0,
1952: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
1953: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168

Line 1954: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895

1950: p_copy_mode IN VARCHAR2,
1951: p_adj_percentage IN NUMBER DEFAULT 0,
1952: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
1953: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168
1954: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1955: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1956: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1957: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1958: IS

Line 1974: l_source_profile_id pa_budget_versions.period_profile_id%TYPE;

1970:
1971: l_source_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1972: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1973: l_source_element_type pa_fp_elements.element_type%TYPE;
1974: l_source_profile_id pa_budget_versions.period_profile_id%TYPE;
1975: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1976:
1977:
1978: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 1985: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1981: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1982:
1983: l_target_element_type pa_fp_elements.element_type%TYPE;
1984:
1985: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1986: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
1987: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
1988:
1989: l_project_id pa_projects_all.project_id%TYPE;

Line 1986: l_target_version_id pa_budget_versions.budget_version_id%TYPE;

1982:
1983: l_target_element_type pa_fp_elements.element_type%TYPE;
1984:
1985: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1986: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
1987: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
1988:
1989: l_project_id pa_projects_all.project_id%TYPE;
1990:

Line 1987: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;

1983: l_target_element_type pa_fp_elements.element_type%TYPE;
1984:
1985: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
1986: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
1987: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
1988:
1989: l_project_id pa_projects_all.project_id%TYPE;
1990:
1991: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------

Line 2008: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2004: -- End, Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
2005:
2006: -- Local variables for 3156057
2007:
2008: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2009: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2010: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2011: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2012: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925

Line 2009: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2005:
2006: -- Local variables for 3156057
2007:
2008: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2009: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2010: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2011: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2012: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2013:

Line 2041: from pa_budget_versions pbv

2037: c_source_proj_fp_options_id IN NUMBER) is
2038: Select 'Y' from dual
2039: where EXISTS(
2040: select 1
2041: from pa_budget_versions pbv
2042: where pbv.budget_version_id = p_source_version_id and pbv.prc_generated_flag='M')
2043: and NOT EXISTS(
2044: select 1
2045: from PA_FP_UPGRADE_AUDIT pua

Line 2052: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )

2048: and pua.upgraded_flag = 'Y');
2049:
2050: Cursor chk_tgt_ver_status is
2051: Select 'Y' from dual
2052: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )
2053: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv
2054: where pbv.budget_version_id = px_target_version_id
2055: and pbv.budget_version_id = bl.budget_version_id
2056: and (bl.cost_rejection_code IS NOT NULL

Line 2053: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv

2049:
2050: Cursor chk_tgt_ver_status is
2051: Select 'Y' from dual
2052: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )
2053: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv
2054: where pbv.budget_version_id = px_target_version_id
2055: and pbv.budget_version_id = bl.budget_version_id
2056: and (bl.cost_rejection_code IS NOT NULL
2057: OR bl.revenue_rejection_code IS NOT NULL

Line 2661: FROM PA_BUDGET_VERSIONS

2657: --Fetch source profile id
2658: BEGIN
2659: SELECT period_profile_id
2660: INTO l_source_profile_id
2661: FROM PA_BUDGET_VERSIONS
2662: WHERE budget_version_id = p_source_version_id;
2663: EXCEPTION
2664: WHEN NO_DATA_FOUND THEN
2665: l_source_profile_id := NULL;

Line 2673: FROM PA_BUDGET_VERSIONS

2669:
2670: BEGIN
2671: SELECT period_profile_id
2672: INTO l_target_profile_id
2673: FROM PA_BUDGET_VERSIONS
2674: WHERE budget_version_id = l_budget_version_id;
2675: EXCEPTION
2676: WHEN NO_DATA_FOUND THEN
2677: l_target_profile_id := NULL;

Line 2723: UPDATE pa_budget_versions

2719: to fix this issue */
2720:
2721: --Update the new budget version/target's period profile id as that of the source version
2722:
2723: UPDATE pa_budget_versions
2724: SET period_profile_id = l_source_profile_id
2725: WHERE budget_version_id = l_budget_version_id;
2726:
2727: --Calling copy_periods_denorm api

Line 3052: FROM PA_BUDGET_VERSIONS

3048: BEGIN
3049:
3050: SELECT decode(budget_status_code,'S','W',budget_status_code)
3051: INTO l_source_ver_type_tbl(1)
3052: FROM PA_BUDGET_VERSIONS
3053: WHERE budget_version_id = p_source_version_id;
3054: EXCEPTION
3055: WHEN NO_DATA_FOUND THEN
3056: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 3064: FROM PA_BUDGET_VERSIONS

3060: BEGIN
3061:
3062: SELECT budget_status_code
3063: INTO l_dest_ver_type_tbl(1) /* This should always be W since we are inside "IF p_copy_mode = W" */
3064: FROM PA_BUDGET_VERSIONS
3065: WHERE budget_version_id = l_budget_version_id;
3066: EXCEPTION
3067: WHEN NO_DATA_FOUND THEN
3068: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 3189: (p_project_id IN pa_budget_versions.project_id%TYPE,

3185:
3186: /* ------------------------------------------------------------------------- */
3187:
3188: procedure Baseline
3189: (p_project_id IN pa_budget_versions.project_id%TYPE,
3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3186: /* ------------------------------------------------------------------------- */
3187:
3188: procedure Baseline
3189: (p_project_id IN pa_budget_versions.project_id%TYPE,
3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3194: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

3187:
3188: procedure Baseline
3189: (p_project_id IN pa_budget_versions.project_id%TYPE,
3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3194: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3195: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3188: procedure Baseline
3189: (p_project_id IN pa_budget_versions.project_id%TYPE,
3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3194: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3195: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3196: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

3189: (p_project_id IN pa_budget_versions.project_id%TYPE,
3190: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3191: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3192: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3193: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3194: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3195: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3196: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3197: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3211: l_created_by pa_budget_versions.created_by%TYPE;

3207: l_error_msg_code VARCHAR2(30);
3208: l_return_status VARCHAR2(2000);
3209: l_msg_index_out NUMBER;
3210:
3211: l_created_by pa_budget_versions.created_by%TYPE;
3212: l_emp_id NUMBER;
3213:
3214: --The following varible is added to make program consistent with the
3215: --changed copy_version procedure prototype

Line 3217: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

3213:
3214: --The following varible is added to make program consistent with the
3215: --changed copy_version procedure prototype
3216:
3217: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3218: --Bug 4145705
3219: l_version_type pa_budget_versions.version_type%TYPE;
3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;

Line 3219: l_version_type pa_budget_versions.version_type%TYPE;

3215: --changed copy_version procedure prototype
3216:
3217: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3218: --Bug 4145705
3219: l_version_type pa_budget_versions.version_type%TYPE;
3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3222: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3223: l_temp NUMBER;

Line 3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

3216:
3217: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3218: --Bug 4145705
3219: l_version_type pa_budget_versions.version_type%TYPE;
3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3222: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3223: l_temp NUMBER;
3224:

Line 3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;

3217: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3218: --Bug 4145705
3219: l_version_type pa_budget_versions.version_type%TYPE;
3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3222: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3223: l_temp NUMBER;
3224:
3225: begin

Line 3222: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;

3218: --Bug 4145705
3219: l_version_type pa_budget_versions.version_type%TYPE;
3220: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3221: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3222: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3223: l_temp NUMBER;
3224:
3225: begin
3226: FND_MSG_PUB.initialize;

Line 3328: from pa_budget_versions pbv,

3324: pbv.fin_plan_type_id
3325: into l_fin_plan_type_code,
3326: l_version_type,
3327: l_fin_plan_type_id
3328: from pa_budget_versions pbv,
3329: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3330: where pbv.budget_version_id = p_budget_version_id and
3331: pbv.fin_plan_type_id = pt.fin_plan_type_id ;
3332:

Line 3338: pa_budget_versions

3334: if l_fin_plan_type_code = 'ORG_FORECAST' then
3335:
3336: /* set the status_code back to "Working" from "Submitted" for the version we baseline */
3337: update
3338: pa_budget_versions
3339: set
3340: last_update_date = SYSDATE,
3341: last_updated_by = FND_GLOBAL.user_id,
3342: last_update_login = FND_GLOBAL.login_id,

Line 3349: pa_budget_versions

3345: where
3346: budget_version_id = p_budget_version_id;
3347: /* remove Current Baselined status from current baselined version */
3348: update
3349: pa_budget_versions
3350: set
3351: last_update_date = SYSDATE,
3352: last_updated_by = FND_GLOBAL.user_id,
3353: last_update_login = FND_GLOBAL.login_id,

Line 3399: FROM pa_budget_versions

3395: SELECT budget_version_id,
3396: record_version_number
3397: INTO l_orig_budget_version_id,
3398: l_orig_record_version_number
3399: FROM pa_budget_versions
3400: WHERE project_id=p_project_id
3401: AND fin_plan_type_id=l_fin_plan_type_id
3402: AND version_type=l_version_type
3403: AND current_flag='Y';

Line 3507: FROM pa_budget_versions

3503: end if;
3504: --Bug 4145705
3505: SELECT COUNT(*)
3506: INTO l_temp
3507: FROM pa_budget_versions
3508: WHERE project_id=p_project_id
3509: AND fin_plan_type_id=l_fin_plan_type_id
3510: AND version_type=l_version_type
3511: AND current_flag='Y';

Line 3569: (p_project_id IN pa_budget_versions.project_id%TYPE,

3565: end Baseline;
3566: /* ------------------------------------------------------------------------- */
3567:
3568: procedure Create_Version_OrgFcst
3569: (p_project_id IN pa_budget_versions.project_id%TYPE,
3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,

Line 3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,

3566: /* ------------------------------------------------------------------------- */
3567:
3568: procedure Create_Version_OrgFcst
3569: (p_project_id IN pa_budget_versions.project_id%TYPE,
3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,
3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

Line 3572: p_version_name IN pa_budget_versions.version_name%TYPE,

3568: procedure Create_Version_OrgFcst
3569: (p_project_id IN pa_budget_versions.project_id%TYPE,
3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,
3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3575: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3576: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3573: p_description IN pa_budget_versions.description%TYPE,

3569: (p_project_id IN pa_budget_versions.project_id%TYPE,
3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,
3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3575: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3576: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3577: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

3570: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,
3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3575: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3576: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3577: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3578: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

3571: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3572: p_version_name IN pa_budget_versions.version_name%TYPE,
3573: p_description IN pa_budget_versions.description%TYPE,
3574: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3575: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3576: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3577: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3578: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3579: is

Line 3590: l_version_type pa_budget_versions.version_type%TYPE;

3586: l_error_msg_code VARCHAR2(2000);
3587: l_msg_index_out NUMBER;
3588: l_return_status VARCHAR2(2000);
3589:
3590: l_version_type pa_budget_versions.version_type%TYPE;
3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3592: l_max_version pa_budget_versions.version_number%TYPE;
3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3594:

Line 3592: l_max_version pa_budget_versions.version_number%TYPE;

3588: l_return_status VARCHAR2(2000);
3589:
3590: l_version_type pa_budget_versions.version_type%TYPE;
3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3592: l_max_version pa_budget_versions.version_number%TYPE;
3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3594:
3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3596: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

3589:
3590: l_version_type pa_budget_versions.version_type%TYPE;
3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3592: l_max_version pa_budget_versions.version_number%TYPE;
3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3594:
3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3596: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3597: l_row_id ROWID;

Line 3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */

3591: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3592: l_max_version pa_budget_versions.version_number%TYPE;
3593: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3594:
3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3596: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3597: l_row_id ROWID;
3598: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3599: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;

Line 3598: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

3594:
3595: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3596: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3597: l_row_id ROWID;
3598: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3599: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
3600: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
3601: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3602: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;

Line 3607: l_request_id pa_budget_versions.request_id%TYPE;

3603: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3604: l_act_period_type gl_periods.period_type%TYPE;
3605: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3606: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3607: l_request_id pa_budget_versions.request_id%TYPE;
3608: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
3609: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
3610: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
3611: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;

Line 3711: pa_budget_versions

3707: nvl(max(version_number), 0)
3708: into
3709: l_max_version
3710: from
3711: pa_budget_versions
3712: where
3713: project_id = p_project_id and
3714: fin_plan_type_id = p_fin_plan_type_id and
3715: budget_status_code in ('W', 'S');

Line 3864: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;

3860: /* create the plan version */
3861: IF P_PA_DEBUG_MODE = 'Y' THEN
3862: pa_debug.write_file('Create_Version_OrgFcst: ' || 'calling pa_fp_budget_versions_pkg.Insert_Row to create a budget version');
3863: END IF;
3864: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;
3865: /* the new version is the current working only if it's the ONLY working version */
3866: if (l_max_version = 0) then
3867: l_current_working_flag := 'Y';
3868: else

Line 4103: (p_project_id IN pa_budget_versions.project_id%TYPE,

4099: end Create_Version_OrgFcst;
4100: /* ------------------------------------------------------------------------- */
4101:
4102: procedure Regenerate
4103: (p_project_id IN pa_budget_versions.project_id%TYPE,
4104: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4105: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4106: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4107: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4104: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

4100: /* ------------------------------------------------------------------------- */
4101:
4102: procedure Regenerate
4103: (p_project_id IN pa_budget_versions.project_id%TYPE,
4104: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4105: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4106: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4107: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4108: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4105: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

4101:
4102: procedure Regenerate
4103: (p_project_id IN pa_budget_versions.project_id%TYPE,
4104: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4105: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4106: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4107: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4108: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4109: is

Line 4113: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

4109: is
4110: l_debug_mode VARCHAR2(30);
4111: l_msg_count NUMBER := 0;
4112: l_valid_flag VARCHAR2(1);
4113: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
4114: l_request_id NUMBER;
4115: l_data VARCHAR2(2000);
4116: l_msg_data VARCHAR2(2000);
4117: l_error_msg_code VARCHAR2(30);

Line 4163: pa_budget_versions

4159: budget_status_code
4160: into
4161: l_budget_status_code
4162: from
4163: pa_budget_versions
4164: where
4165: budget_version_id=p_budget_version_id;
4166: **/
4167: -- get org id to initiaize before submit the fnd request

Line 4173: ,pa_budget_versions bv

4169: ,bv.budget_status_code
4170: INTO l_org_id
4171: ,l_budget_status_code
4172: FROM pa_projects_all pp
4173: ,pa_budget_versions bv
4174: WHERE pp.project_id = bv.project_id
4175: AND bv.budget_version_id = p_budget_version_id;
4176: /* End of bug fix:4510784 */
4177:

Line 4267: pa_budget_versions

4263: IF P_PA_DEBUG_MODE = 'Y' THEN
4264: pa_debug.write_file('Regenerate: ' || 'concurrent process submitted successfully; stamping request_id');
4265: END IF;
4266: update
4267: pa_budget_versions
4268: set
4269: request_id = l_request_id,
4270: plan_processing_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, /* "Generation in process" */
4271: record_version_number = record_version_number + 1

Line 4301: (p_project_id IN pa_budget_versions.project_id%TYPE

4297:
4298: /* ------------------------------------------------------------------------- */
4299:
4300: procedure Update_Version
4301: (p_project_id IN pa_budget_versions.project_id%TYPE
4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE

Line 4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4298: /* ------------------------------------------------------------------------- */
4299:
4300: procedure Update_Version
4301: (p_project_id IN pa_budget_versions.project_id%TYPE
4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE

4299:
4300: procedure Update_Version
4301: (p_project_id IN pa_budget_versions.project_id%TYPE
4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010

Line 4304: ,p_version_name IN pa_budget_versions.version_name%TYPE

4300: procedure Update_Version
4301: (p_project_id IN pa_budget_versions.project_id%TYPE
4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

Line 4305: ,p_description IN pa_budget_versions.description%TYPE

4301: (p_project_id IN pa_budget_versions.project_id%TYPE
4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

Line 4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

4302: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4303: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

Line 4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

4304: ,p_version_name IN pa_budget_versions.version_name%TYPE
4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

4305: ,p_description IN pa_budget_versions.description%TYPE
4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

4306: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

4307: -- Start of additional columns for Bug :- 3088010
4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

4308: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

4309: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

4310: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

4311: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

4312: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

4313: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

4314: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

4315: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

4316: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4324: -- End of additional columns for Bug :- 3088010

Line 4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

4317: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4324: -- End of additional columns for Bug :- 3088010
4325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

4318: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4324: -- End of additional columns for Bug :- 3088010
4325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

4319: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4320: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4321: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4322: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4323: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4324: -- End of additional columns for Bug :- 3088010
4325: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4326: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4327: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4331: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

4327: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4328: is
4329: l_debug_mode VARCHAR2(30);
4330: l_valid_flag VARCHAR2(1);
4331: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
4332: l_record_version_number pa_budget_versions.record_version_number%TYPE;
4333:
4334: l_msg_count NUMBER := 0;
4335: l_data VARCHAR2(2000);

Line 4332: l_record_version_number pa_budget_versions.record_version_number%TYPE;

4328: is
4329: l_debug_mode VARCHAR2(30);
4330: l_valid_flag VARCHAR2(1);
4331: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
4332: l_record_version_number pa_budget_versions.record_version_number%TYPE;
4333:
4334: l_msg_count NUMBER := 0;
4335: l_data VARCHAR2(2000);
4336: l_msg_data VARCHAR2(2000);

Line 4398: PA_BUDGET_VERSIONS

4394: SAVEPOINT PA_FIN_PLAN_PUB_UPDATE_VERSION;
4395: l_record_version_number := p_record_version_number + 1;
4396:
4397: UPDATE
4398: PA_BUDGET_VERSIONS
4399: SET
4400: record_version_number = l_record_version_number,
4401: version_name = p_version_name,
4402: description = p_description,

Line 4449: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

4445: ORG_FORECAST'
4446: =========================================================================*/
4447: procedure Create_Org_Fcst_Elements (
4448: p_project_id IN pa_projects_all.project_id%TYPE,
4449: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4450: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4451: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4452: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4453: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4450: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

4446: =========================================================================*/
4447: procedure Create_Org_Fcst_Elements (
4448: p_project_id IN pa_projects_all.project_id%TYPE,
4449: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4450: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4451: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4452: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4453: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4454:

Line 5120: pa_fp_txn_currencies and pa_budget_versions.

5116: Bug No. 2331201 For finplan this api has been added
5117: This api Creates a working fin plan version.The version inherits its
5118: properties from plan type.This api creates records in
5119: pa_proj_fp_options , pa_resource_assignments,
5120: pa_fp_txn_currencies and pa_budget_versions.
5121: If px_budget_version_id is passed it is assumed that new version
5122: id is created and passed to the api, else new value is created.
5123:
5124: -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:

Line 5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL

5170: ,p_element_type IN VARCHAR2
5171: ,p_version_name IN VARCHAR2
5172: ,p_description IN VARCHAR2
5173: -- Start of additional columns for Bug :- 2634900
5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

Line 5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL

5171: ,p_version_name IN VARCHAR2
5172: ,p_description IN VARCHAR2
5173: -- Start of additional columns for Bug :- 2634900
5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M

Line 5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL

5172: ,p_description IN VARCHAR2
5173: -- Start of additional columns for Bug :- 2634900
5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5180: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL

Line 5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL

5173: -- Start of additional columns for Bug :- 2634900
5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5180: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

Line 5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

5174: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5180: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5182: ,p_calling_context IN VARCHAR2 --:= NULL

Line 5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M

5175: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5176: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5180: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5182: ,p_calling_context IN VARCHAR2 --:= NULL
5183: -- End of additional columns for Bug :- 2634900

Line 5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

5177: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5178: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5179: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5180: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5182: ,p_calling_context IN VARCHAR2 --:= NULL
5183: -- End of additional columns for Bug :- 2634900
5184: -- Start of additional columns for Bug :- 2649474
5185: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE --:= NULL

Line 5185: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE --:= NULL

5181: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5182: ,p_calling_context IN VARCHAR2 --:= NULL
5183: -- End of additional columns for Bug :- 2634900
5184: -- Start of additional columns for Bug :- 2649474
5185: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE --:= NULL
5186: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE --:= NULL
5187: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE --:= NULL
5188: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --:= NULL
5189: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL

Line 5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

5188: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --:= NULL
5189: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL
5190: -- End of additional columns for Bug :- 2649474
5191: -- Start of additional columns for Bug :- 3088010
5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

5189: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL
5190: -- End of additional columns for Bug :- 2649474
5191: -- Start of additional columns for Bug :- 3088010
5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

5190: -- End of additional columns for Bug :- 2649474
5191: -- Start of additional columns for Bug :- 3088010
5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

5191: -- Start of additional columns for Bug :- 3088010
5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

5192: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

5193: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

5194: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

5195: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

5196: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

5197: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

5198: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

5199: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

5200: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5208: -- End of additional columns for Bug :- 3088010

Line 5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

5201: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5208: -- End of additional columns for Bug :- 3088010
5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

5202: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5208: -- End of additional columns for Bug :- 3088010
5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5210: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518

Line 5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

5203: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5204: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5205: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5206: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5208: -- End of additional columns for Bug :- 3088010
5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5210: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5211: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL

Line 5211: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL

5207: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5208: -- End of additional columns for Bug :- 3088010
5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5210: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5211: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5212: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5213: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5214: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5215: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5212: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL

5208: -- End of additional columns for Bug :- 3088010
5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5210: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5211: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5212: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5213: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5214: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5215: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5216: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 5213: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL

5209: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5210: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5211: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5212: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5213: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5214: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5215: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5216: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5217: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5235: l_max_version_number pa_budget_versions.version_number%TYPE;

5231: l_debug_mode VARCHAR2(30);
5232:
5233: -- End of variables used for debugging purpose
5234:
5235: l_max_version_number pa_budget_versions.version_number%TYPE;
5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;

5232:
5233: -- End of variables used for debugging purpose
5234:
5235: l_max_version_number pa_budget_versions.version_number%TYPE;
5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

5233: -- End of variables used for debugging purpose
5234:
5235: l_max_version_number pa_budget_versions.version_number%TYPE;
5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;

5234:
5235: l_max_version_number pa_budget_versions.version_number%TYPE;
5236: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5237: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5238: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

5239: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

Line 5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

5240: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

Line 5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

5241: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;

Line 5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

5242: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;

Line 5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

5243: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;
5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

Line 5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

5244: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5245: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5246: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5247: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5248: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5249: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5250: l_agreement_amount pa_agreements_all.amount%TYPE;
5251: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5252:

Line 5293: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;

5289: l_prj_end_date VARCHAR2(100);
5290: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5291:
5292: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5293: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5294:
5295: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5296: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5297:

Line 5376: FROM pa_proj_fp_options pfo, pa_budget_versions bv

5372: , pfo.primary_cost_forecast_flag
5373: , pfo.primary_rev_forecast_flag
5374: , bv.actual_amts_thru_period
5375: , bv.project_structure_version_id
5376: FROM pa_proj_fp_options pfo, pa_budget_versions bv
5377: WHERE pfo.project_id = c_project_id
5378: AND pfo.fin_plan_type_id = c_fin_plan_type_id
5379: AND pfo.fin_plan_version_id = c_fin_plan_version_id
5380: AND bv.budget_version_id = c_fin_plan_version_id

Line 5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE

5395: ,approved_cost_plan_type_flag PA_PROJ_FP_OPTIONS.approved_cost_plan_type_flag%TYPE
5396: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5397: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5398: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE

Line 5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE

5396: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5397: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5398: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5404: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL

Line 5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE

5398: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5404: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5405: );
5406:

Line 5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE

5399: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5404: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5405: );
5406:
5407: new_version_info_rec new_version_rec_type;

Line 5404: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL

5400: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5401: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5402: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5403: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5404: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5405: );
5406:
5407: new_version_info_rec new_version_rec_type;
5408:

Line 5417: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;

5413: l_cw_ver_res_list_id NUMBER;
5414: l_row_id rowid;
5415: l_copy_res_assmt_from_cwv_flag VARCHAR2(1);
5416: -- ---------------------------------------------------------------------------
5417: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5418:
5419: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5420: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5421: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5944: FROM pa_budget_versions

5940: version should also be set as current_working_version. */
5941:
5942: SELECT budget_version_id
5943: INTO l_dummy_version_id
5944: FROM pa_budget_versions
5945: WHERE project_id = p_project_id
5946: AND fin_plan_type_id = p_fin_plan_type_id
5947: AND version_type = new_version_info_rec.version_type -- Bug :- 2668667
5948: AND current_working_flag = 'Y';

Line 5981: SELECT pa_budget_versions_s.NEXTVAL

5977: pa_debug.g_err_stage:='Fetching new budget_version_id';
5978: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5979: END IF;
5980:
5981: SELECT pa_budget_versions_s.NEXTVAL
5982: INTO l_new_budget_version_id
5983: FROM DUAL;
5984: ELSE
5985: l_new_budget_version_id := px_budget_version_id;

Line 5989: --Create a new record in pa_budget_versions using plan type properties

5985: l_new_budget_version_id := px_budget_version_id;
5986: END IF;
5987:
5988:
5989: --Create a new record in pa_budget_versions using plan type properties
5990:
5991: IF P_PA_DEBUG_MODE = 'Y' THEN
5992: pa_debug.g_err_stage:='Calling budget_versions table handler to insert new row ';
5993: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);

Line 5996: -- Getting the Use for workplan flag to populate WP_VERSION_FLAG in pa_budget_versions

5992: pa_debug.g_err_stage:='Calling budget_versions table handler to insert new row ';
5993: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5994: END IF;
5995:
5996: -- Getting the Use for workplan flag to populate WP_VERSION_FLAG in pa_budget_versions
5997: SELECT use_for_workplan_flag
5998: INTO l_wp_version_flag
5999: FROM pa_fin_plan_types_b
6000: WHERE fin_plan_type_id = p_fin_plan_type_id;

Line 6012: From pa_budget_versions

6008: l_exists varchar2(1);
6009: Begin
6010: Select 'Y'
6011: Into l_exists
6012: From pa_budget_versions
6013: Where project_structure_version_id =
6014: nvl(p_struct_elem_version_id,new_version_info_rec.project_structure_version_id)
6015: And wp_version_flag = 'Y'
6016: And exists (select 'x' from pa_budget_versions b

Line 6016: And exists (select 'x' from pa_budget_versions b

6012: From pa_budget_versions
6013: Where project_structure_version_id =
6014: nvl(p_struct_elem_version_id,new_version_info_rec.project_structure_version_id)
6015: And wp_version_flag = 'Y'
6016: And exists (select 'x' from pa_budget_versions b
6017: where b.budget_version_id =
6018: nvl(l_ci_apprv_cw_bv_id,l_fin_plan_version_id)
6019: and b.wp_version_flag = 'Y') ;
6020:

Line 6481: UPDATE Pa_Budget_Versions SET

6477: END IF;
6478:
6479: -- Update the budget versions table with the converted estimated amounts in projfunc currency
6480:
6481: UPDATE Pa_Budget_Versions SET
6482: est_projfunc_raw_cost = l_est_projfunc_raw_cost,
6483: est_projfunc_burdened_cost = l_est_projfunc_bd_cost,
6484: est_projfunc_revenue = l_est_projfunc_revenue
6485: WHERE Budget_Version_Id = l_new_budget_version_id;

Line 7104: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

7100:
7101: l_plan_start_date gl_periods.start_date%TYPE;
7102: l_plan_end_date gl_periods.end_date%TYPE;
7103:
7104: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
7105:
7106: BEGIN
7107:
7108: x_msg_count := 0;

Line 7183: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra

7179: SELECT MIN (pbl.start_date)
7180: ,MAX(pbl.end_date)
7181: INTO l_start_date
7182: ,l_end_date
7183: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7184: ,pa_budget_lines pbl
7185: WHERE pbv.project_id = p_project_id
7186: AND pbl.budget_version_id = pbv.budget_version_id
7187: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)

Line 7637: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7633: Budget Lines with appropriate values and call Maintain Matrix API to update the
7634: USER_ENTERED level records into pa_proj_periods_denorm table.
7635: ---------------------------------------------------------------------------------------------*/
7636: PROCEDURE Call_Maintain_Plan_Matrix (
7637: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7638: ,p_data_source IN VARCHAR2
7639: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7640: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7641: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 7651: l_project_id pa_budget_versions.PROJECT_ID%TYPE;

7647: l_msg_index_out NUMBER;
7648: l_return_status VARCHAR2(2000);
7649: l_debug_mode VARCHAR2(30);
7650:
7651: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7652: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7653: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7654: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7655: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;

Line 7652: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;

7648: l_return_status VARCHAR2(2000);
7649: l_debug_mode VARCHAR2(30);
7650:
7651: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7652: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7653: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7654: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7655: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;
7656:

Line 7653: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;

7649: l_debug_mode VARCHAR2(30);
7650:
7651: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7652: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7653: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7654: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7655: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;
7656:
7657: l_plsql_max_array_size NUMBER := 200;

Line 7868: FROM pa_budget_versions

7864: SELECT project_id,
7865: period_profile_id
7866: INTO l_project_id,
7867: l_period_profile_id
7868: FROM pa_budget_versions
7869: WHERE budget_version_id = p_budget_version_id;
7870:
7871: /* Get the value of the Preference code of the Budget Version. Margin and
7872: Margin % have to be populated only if the Preference code is

Line 8175: FROM PA_BUDGET_VERSIONS

8171: END IF;
8172:
8173: SELECT version_type
8174: INTO l_budget_version_type
8175: FROM PA_BUDGET_VERSIONS
8176: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8177:
8178: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8179: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;

Line 8176: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;

8172:
8173: SELECT version_type
8174: INTO l_budget_version_type
8175: FROM PA_BUDGET_VERSIONS
8176: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8177:
8178: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8179: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8180: amt_rec(l_tbl_index).amount_type_id := pa_fin_plan_utils.get_amttype_id(p_amt_typ_code => PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY);

Line 8278: p_project_id IN pa_budget_versions.project_id%TYPE

8274: resource list.
8275: ==============================================================================*/
8276:
8277: PROCEDURE Refresh_res_list_assignment (
8278: p_project_id IN pa_budget_versions.project_id%TYPE
8279: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
8280: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8281: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8282: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 8279: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

8275: ==============================================================================*/
8276:
8277: PROCEDURE Refresh_res_list_assignment (
8278: p_project_id IN pa_budget_versions.project_id%TYPE
8279: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
8280: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8281: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8282: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
8283: AS

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

8458: */
8459:
8460:
8461: PROCEDURE create_default_plan_txn_rec
8462: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8463: p_calling_module IN VARCHAR2,
8464: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8465: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8466: x_return_status OUT NOCOPY VARCHAR2,

Line 8496: l_ci_id pa_budget_versions.ci_id%TYPE;

8492: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;
8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8499:
8500: -- IPM Arch Enhancement - Bug 4865563

Line 8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;

8493: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;
8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8499:
8500: -- IPM Arch Enhancement - Bug 4865563
8501: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api

Line 8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

8494: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8495:
8496: l_ci_id pa_budget_versions.ci_id%TYPE;
8497: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8498: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8499:
8500: -- IPM Arch Enhancement - Bug 4865563
8501: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
8502: l_debug_level5 NUMBER:=5;

Line 8584: FROM pa_budget_versions pbv,

8580: l_agreement_id,
8581: l_app_rev_flag,
8582: l_proj_curr_code,
8583: l_pfunc_curr_code
8584: FROM pa_budget_versions pbv,
8585: pa_projects_all ppa
8586: WHERE pbv.budget_version_id = p_budget_version_id
8587: AND ppa.project_id = pbv.project_id;
8588: EXCEPTION