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: /* Added for bug 8708651 */

Line 1256: pa_budget_versions

1252: /* Added for bug 8708651 */
1253: if PJI_PA_DEL_MAIN.g_from_conc is null then
1254: delete
1255: from
1256: pa_budget_versions
1257: where
1258: budget_version_id=p_budget_version_id AND
1259: project_id=nvl(p_project_id,project_id) AND
1260: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1265: update PA_BUDGET_VERSIONS

1261: returning budget_version_id
1262: bulk collect into l_budget_version_id_tbl ;
1263:
1264: else
1265: update PA_BUDGET_VERSIONS
1266: set PURGED_FLAG = 'Y',
1267: last_update_date = sysdate,
1268: last_updated_by = FND_GLOBAL.USER_ID,
1269: request_id = FND_GLOBAL.CONC_REQUEST_ID /* Added for bug 9049425 */

Line 1280: pa_budget_versions

1276:
1277: elsif p_project_id is not null then
1278: delete
1279: from
1280: pa_budget_versions
1281: where
1282: budget_version_id=nvl(p_budget_version_id,budget_version_id) AND
1283: project_id=p_project_id AND
1284: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1295: pa_budget_versions

1291: * future cases, in case this logic changes or addtl parameters are included.
1292: */
1293: delete
1294: from
1295: pa_budget_versions
1296: where
1297: budget_version_id=nvl(p_budget_version_id,budget_version_id) AND
1298: project_id=nvl(p_project_id,project_id) AND
1299: fin_plan_type_id = nvl(l_wp_fin_plan_type_id,fin_plan_type_id)

Line 1318: pa_budget_versions

1314: nvl(max(version_number), 0)
1315: into
1316: l_max_version
1317: from
1318: pa_budget_versions
1319: where
1320: project_id = p_project_id and
1321: fin_plan_type_id = l_fin_plan_type_id and
1322: budget_status_code = 'W' and

Line 1330: pa_budget_versions

1326:
1327: /* make it the Current Working version */
1328: if (l_max_version <> 0) then
1329: update
1330: pa_budget_versions
1331: set
1332: current_working_flag = 'Y',
1333: last_update_date=SYSDATE,
1334: last_updated_by=FND_GLOBAL.user_id,

Line 1353: (X_entity_name => 'PA_BUDGET_VERSIONS',

1349: -- only for BUDGET Context -- CHECK FOR CURRENT WORKING VERSIONS ENDS
1350: ----------------------------------------------------------------------
1351: -- Delete attachements which are associated with the budget version
1352: fnd_attached_documents2_pkg.delete_attachments
1353: (X_entity_name => 'PA_BUDGET_VERSIONS',
1354: X_pk1_value => to_char(p_budget_version_id),
1355: X_delete_document_flag => 'Y');
1356:
1357: /* FP M - Reporting lines integration */

Line 1433: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

1429: --is passed. Otherwise when p_project_id is passed data for the entire project will be deleted.
1430: procedure Delete_Version_Helper
1431: (p_project_id IN pa_projects_all.project_id%TYPE ,
1432: p_context IN VARCHAR2 ,
1433: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
1434: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1435: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1436: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1437: is

Line 1446: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

1442: l_msg_index_out NUMBER;
1443: l_return_status VARCHAR2(2000);
1444:
1445: l_valid_flag VARCHAR2(1);
1446: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1447: l_max_version NUMBER;
1448:
1449: l_project_id pa_budget_versions.project_id%TYPE;
1450: l_ci_id pa_budget_versions.ci_id%TYPE;

Line 1449: l_project_id pa_budget_versions.project_id%TYPE;

1445: l_valid_flag VARCHAR2(1);
1446: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1447: l_max_version NUMBER;
1448:
1449: l_project_id pa_budget_versions.project_id%TYPE;
1450: l_ci_id pa_budget_versions.ci_id%TYPE;
1451: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1452: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1453: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';

Line 1450: l_ci_id pa_budget_versions.ci_id%TYPE;

1446: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
1447: l_max_version NUMBER;
1448:
1449: l_project_id pa_budget_versions.project_id%TYPE;
1450: l_ci_id pa_budget_versions.ci_id%TYPE;
1451: l_budget_version_id_tbl pa_plsql_datatypes.idTabTyp;
1452: l_proj_fp_options_id_tbl pa_plsql_datatypes.idTabTyp;
1453: l_module_name VARCHAR2(100):='PAFPPUBB.Delete_Version_Helper';
1454: i NUMBER;

Line 1758: FROM pa_budget_versions

1754: SELECT project_id,
1755: ci_id
1756: INTO l_project_id,
1757: l_ci_id
1758: FROM pa_budget_versions
1759: WHERE budget_version_id = p_budget_version_id;
1760: EXCEPTION
1761: WHEN OTHERS THEN
1762: pa_debug.g_err_stage:= 'Error while Fetching the data for '||p_budget_version_id;

Line 1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,

1846: p_source_project_id IN pa_projects_all.project_id%TYPE,
1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1852: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1853: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1854: )

Line 1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,

1847: p_target_project_id IN pa_projects_all.project_id%TYPE,
1848: p_source_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1849: p_target_plan_class_code IN pa_fin_plan_types_b.plan_class_code%TYPE,
1850: p_source_version_type IN pa_budget_versions.version_type%TYPE,
1851: p_target_version_type IN pa_budget_versions.version_type%TYPE,
1852: x_copy_actuals_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1853: x_derv_rates_missing_amts_flag OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
1854: )
1855: IS

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

1960: the Optional Upgrade process is run on the source version.
1961: ================================================================================*/
1962:
1963: PROCEDURE Copy_Version
1964: (p_project_id IN pa_budget_versions.project_id%TYPE,
1965: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
1966: p_copy_mode IN VARCHAR2,
1967: p_adj_percentage IN NUMBER DEFAULT 0,
1968: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,

Line 1965: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

1961: ================================================================================*/
1962:
1963: PROCEDURE Copy_Version
1964: (p_project_id IN pa_budget_versions.project_id%TYPE,
1965: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
1966: p_copy_mode IN VARCHAR2,
1967: p_adj_percentage IN NUMBER DEFAULT 0,
1968: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
1969: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168

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

1966: p_copy_mode IN VARCHAR2,
1967: p_adj_percentage IN NUMBER DEFAULT 0,
1968: p_calling_module IN VARCHAR2 DEFAULT PA_FP_CONSTANTS_PKG.G_CALLING_MODULE_ORG_FORECAST,
1969: p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y', --Bug 4200168
1970: px_target_version_id IN OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
1971: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
1972: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
1973: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
1974: IS

Line 1990: l_source_profile_id pa_budget_versions.period_profile_id%TYPE;

1986:
1987: l_source_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
1988: l_source_fp_preference_code pa_proj_fp_options.fin_plan_preference_code%TYPE;
1989: l_source_element_type pa_fp_elements.element_type%TYPE;
1990: l_source_profile_id pa_budget_versions.period_profile_id%TYPE;
1991: l_source_fin_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE;
1992:
1993:
1994: l_target_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 2001: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;

1997: l_plan_in_multi_curr_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
1998:
1999: l_target_element_type pa_fp_elements.element_type%TYPE;
2000:
2001: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2002: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
2003: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
2004:
2005: l_project_id pa_projects_all.project_id%TYPE;

Line 2002: l_target_version_id pa_budget_versions.budget_version_id%TYPE;

1998:
1999: l_target_element_type pa_fp_elements.element_type%TYPE;
2000:
2001: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2002: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
2003: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
2004:
2005: l_project_id pa_projects_all.project_id%TYPE;
2006:

Line 2003: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;

1999: l_target_element_type pa_fp_elements.element_type%TYPE;
2000:
2001: l_budget_version_id pa_budget_versions.budget_version_id%TYPE;
2002: l_target_version_id pa_budget_versions.budget_version_id%TYPE;
2003: l_target_profile_id pa_budget_versions.period_profile_id%TYPE;
2004:
2005: l_project_id pa_projects_all.project_id%TYPE;
2006:
2007: -- Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------

Line 2024: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2020: -- End, Bug 3362316, 08-JAN-2003: Local Vars for Populating Reporting Lines --------------------------
2021:
2022: -- Local variables for 3156057
2023:
2024: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2025: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2026: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2027: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2028: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925

Line 2025: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

2021:
2022: -- Local variables for 3156057
2023:
2024: l_target_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2025: l_source_appr_rev_plan_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
2026: l_source_plan_in_mc_flag pa_proj_fp_options.plan_in_multi_curr_flag%TYPE;
2027: l_source_ver_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2028: l_target_pt_lvl_rbs_version_id pa_proj_fp_options.rbs_version_id%TYPE;-- Bug 3731925
2029:

Line 2057: from pa_budget_versions pbv

2053: c_source_proj_fp_options_id IN NUMBER) is
2054: Select 'Y' from dual
2055: where EXISTS(
2056: select 1
2057: from pa_budget_versions pbv
2058: where pbv.budget_version_id = p_source_version_id and pbv.prc_generated_flag='M')
2059: and NOT EXISTS(
2060: select 1
2061: from PA_FP_UPGRADE_AUDIT pua

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

2064: and pua.upgraded_flag = 'Y');
2065:
2066: Cursor chk_tgt_ver_status is
2067: Select 'Y' from dual
2068: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )
2069: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv
2070: where pbv.budget_version_id = px_target_version_id
2071: and pbv.budget_version_id = bl.budget_version_id
2072: and (bl.cost_rejection_code IS NOT NULL

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

2065:
2066: Cursor chk_tgt_ver_status is
2067: Select 'Y' from dual
2068: where exists (select 1 from pa_budget_versions pbv where pbv.budget_version_id = px_target_version_id and pbv.budget_Status_code = 'W' )
2069: and exists (select 1 from pa_budget_lines bl, pa_budget_versions pbv
2070: where pbv.budget_version_id = px_target_version_id
2071: and pbv.budget_version_id = bl.budget_version_id
2072: and (bl.cost_rejection_code IS NOT NULL
2073: OR bl.revenue_rejection_code IS NOT NULL

Line 2677: FROM PA_BUDGET_VERSIONS

2673: --Fetch source profile id
2674: BEGIN
2675: SELECT period_profile_id
2676: INTO l_source_profile_id
2677: FROM PA_BUDGET_VERSIONS
2678: WHERE budget_version_id = p_source_version_id;
2679: EXCEPTION
2680: WHEN NO_DATA_FOUND THEN
2681: l_source_profile_id := NULL;

Line 2689: FROM PA_BUDGET_VERSIONS

2685:
2686: BEGIN
2687: SELECT period_profile_id
2688: INTO l_target_profile_id
2689: FROM PA_BUDGET_VERSIONS
2690: WHERE budget_version_id = l_budget_version_id;
2691: EXCEPTION
2692: WHEN NO_DATA_FOUND THEN
2693: l_target_profile_id := NULL;

Line 2739: UPDATE pa_budget_versions

2735: to fix this issue */
2736:
2737: --Update the new budget version/target's period profile id as that of the source version
2738:
2739: UPDATE pa_budget_versions
2740: SET period_profile_id = l_source_profile_id
2741: WHERE budget_version_id = l_budget_version_id;
2742:
2743: --Calling copy_periods_denorm api

Line 3068: FROM PA_BUDGET_VERSIONS

3064: BEGIN
3065:
3066: SELECT decode(budget_status_code,'S','W',budget_status_code)
3067: INTO l_source_ver_type_tbl(1)
3068: FROM PA_BUDGET_VERSIONS
3069: WHERE budget_version_id = p_source_version_id;
3070: EXCEPTION
3071: WHEN NO_DATA_FOUND THEN
3072: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

Line 3080: FROM PA_BUDGET_VERSIONS

3076: BEGIN
3077:
3078: SELECT budget_status_code
3079: INTO l_dest_ver_type_tbl(1) /* This should always be W since we are inside "IF p_copy_mode = W" */
3080: FROM PA_BUDGET_VERSIONS
3081: WHERE budget_version_id = l_budget_version_id;
3082: EXCEPTION
3083: WHEN NO_DATA_FOUND THEN
3084: RAISE PA_FP_CONSTANTS_PKG.Invalid_Arg_Exc;

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

3201:
3202: /* ------------------------------------------------------------------------- */
3203:
3204: procedure Baseline
3205: (p_project_id IN pa_budget_versions.project_id%TYPE,
3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

Line 3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3202: /* ------------------------------------------------------------------------- */
3203:
3204: procedure Baseline
3205: (p_project_id IN pa_budget_versions.project_id%TYPE,
3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3210: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

3203:
3204: procedure Baseline
3205: (p_project_id IN pa_budget_versions.project_id%TYPE,
3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3210: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3211: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

3204: procedure Baseline
3205: (p_project_id IN pa_budget_versions.project_id%TYPE,
3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3210: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3211: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3212: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,

3205: (p_project_id IN pa_budget_versions.project_id%TYPE,
3206: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3207: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3208: p_orig_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
3209: p_orig_record_version_number IN pa_budget_versions.record_version_number%TYPE,
3210: x_fc_version_created_flag OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3211: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3212: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3213: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 3227: l_created_by pa_budget_versions.created_by%TYPE;

3223: l_error_msg_code VARCHAR2(30);
3224: l_return_status VARCHAR2(2000);
3225: l_msg_index_out NUMBER;
3226:
3227: l_created_by pa_budget_versions.created_by%TYPE;
3228: l_emp_id NUMBER;
3229:
3230: --The following varible is added to make program consistent with the
3231: --changed copy_version procedure prototype

Line 3233: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;

3229:
3230: --The following varible is added to make program consistent with the
3231: --changed copy_version procedure prototype
3232:
3233: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3234: --Bug 4145705
3235: l_version_type pa_budget_versions.version_type%TYPE;
3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;

Line 3235: l_version_type pa_budget_versions.version_type%TYPE;

3231: --changed copy_version procedure prototype
3232:
3233: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3234: --Bug 4145705
3235: l_version_type pa_budget_versions.version_type%TYPE;
3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3238: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3239: l_temp NUMBER;

Line 3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;

3232:
3233: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3234: --Bug 4145705
3235: l_version_type pa_budget_versions.version_type%TYPE;
3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3238: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3239: l_temp NUMBER;
3240:

Line 3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;

3233: l_target_version_id PA_BUDGET_VERSIONS.budget_version_id%TYPE;
3234: --Bug 4145705
3235: l_version_type pa_budget_versions.version_type%TYPE;
3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3238: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3239: l_temp NUMBER;
3240:
3241: begin

Line 3238: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;

3234: --Bug 4145705
3235: l_version_type pa_budget_versions.version_type%TYPE;
3236: l_fin_plan_type_id pa_budget_versions.fin_plan_type_id%TYPE;
3237: l_orig_budget_version_id pa_budget_versions.budget_version_id%TYPE;
3238: l_orig_record_version_number pa_budget_versions.record_Version_number%TYPE;
3239: l_temp NUMBER;
3240:
3241: begin
3242: FND_MSG_PUB.initialize;

Line 3344: from pa_budget_versions pbv,

3340: pbv.fin_plan_type_id
3341: into l_fin_plan_type_code,
3342: l_version_type,
3343: l_fin_plan_type_id
3344: from pa_budget_versions pbv,
3345: pa_fin_plan_types_b pt /* Bug# 2661650 - _vl to _b/_tl for performance changes */
3346: where pbv.budget_version_id = p_budget_version_id and
3347: pbv.fin_plan_type_id = pt.fin_plan_type_id ;
3348:

Line 3354: pa_budget_versions

3350: if l_fin_plan_type_code = 'ORG_FORECAST' then
3351:
3352: /* set the status_code back to "Working" from "Submitted" for the version we baseline */
3353: update
3354: pa_budget_versions
3355: set
3356: last_update_date = SYSDATE,
3357: last_updated_by = FND_GLOBAL.user_id,
3358: last_update_login = FND_GLOBAL.login_id,

Line 3365: pa_budget_versions

3361: where
3362: budget_version_id = p_budget_version_id;
3363: /* remove Current Baselined status from current baselined version */
3364: update
3365: pa_budget_versions
3366: set
3367: last_update_date = SYSDATE,
3368: last_updated_by = FND_GLOBAL.user_id,
3369: last_update_login = FND_GLOBAL.login_id,

Line 3415: FROM pa_budget_versions

3411: SELECT budget_version_id,
3412: record_version_number
3413: INTO l_orig_budget_version_id,
3414: l_orig_record_version_number
3415: FROM pa_budget_versions
3416: WHERE project_id=p_project_id
3417: AND fin_plan_type_id=l_fin_plan_type_id
3418: AND version_type=l_version_type
3419: AND current_flag='Y';

Line 3523: FROM pa_budget_versions

3519: end if;
3520: --Bug 4145705
3521: SELECT COUNT(*)
3522: INTO l_temp
3523: FROM pa_budget_versions
3524: WHERE project_id=p_project_id
3525: AND fin_plan_type_id=l_fin_plan_type_id
3526: AND version_type=l_version_type
3527: AND current_flag='Y';

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

3581: end Baseline;
3582: /* ------------------------------------------------------------------------- */
3583:
3584: procedure Create_Version_OrgFcst
3585: (p_project_id IN pa_budget_versions.project_id%TYPE,
3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,

Line 3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,

3582: /* ------------------------------------------------------------------------- */
3583:
3584: procedure Create_Version_OrgFcst
3585: (p_project_id IN pa_budget_versions.project_id%TYPE,
3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,
3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

Line 3588: p_version_name IN pa_budget_versions.version_name%TYPE,

3584: procedure Create_Version_OrgFcst
3585: (p_project_id IN pa_budget_versions.project_id%TYPE,
3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,
3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3591: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3592: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 3589: p_description IN pa_budget_versions.description%TYPE,

3585: (p_project_id IN pa_budget_versions.project_id%TYPE,
3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,
3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3591: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3592: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3593: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,

3586: p_fin_plan_type_id IN pa_budget_versions.fin_plan_type_id%TYPE,
3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,
3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3591: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3592: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3593: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3594: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

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

3587: p_fin_plan_options_id IN pa_proj_fp_options.proj_fp_options_id%TYPE,
3588: p_version_name IN pa_budget_versions.version_name%TYPE,
3589: p_description IN pa_budget_versions.description%TYPE,
3590: p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE,
3591: x_budget_version_id OUT NOCOPY pa_budget_versions.budget_version_id%TYPE, --File.Sql.39 bug 4440895
3592: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
3593: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
3594: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
3595: is

Line 3606: l_version_type pa_budget_versions.version_type%TYPE;

3602: l_error_msg_code VARCHAR2(2000);
3603: l_msg_index_out NUMBER;
3604: l_return_status VARCHAR2(2000);
3605:
3606: l_version_type pa_budget_versions.version_type%TYPE;
3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3608: l_max_version pa_budget_versions.version_number%TYPE;
3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3610:

Line 3608: l_max_version pa_budget_versions.version_number%TYPE;

3604: l_return_status VARCHAR2(2000);
3605:
3606: l_version_type pa_budget_versions.version_type%TYPE;
3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3608: l_max_version pa_budget_versions.version_number%TYPE;
3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3610:
3611: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3612: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

3605:
3606: l_version_type pa_budget_versions.version_type%TYPE;
3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3608: l_max_version pa_budget_versions.version_number%TYPE;
3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3610:
3611: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3612: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3613: l_row_id ROWID;

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

3607: l_version_type_code pa_fin_plan_types_b.fin_plan_type_code%TYPE;
3608: l_max_version pa_budget_versions.version_number%TYPE;
3609: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
3610:
3611: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3612: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3613: l_row_id ROWID;
3614: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3615: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;

Line 3614: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;

3610:
3611: l_budget_version_id pa_budget_versions.budget_version_id%TYPE; /* newly-created budget_version_id */
3612: l_proj_fin_plan_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
3613: l_row_id ROWID;
3614: l_resource_list_id pa_budget_versions.resource_list_id%TYPE;
3615: l_org_fcst_period_type pa_forecasting_options_all.org_fcst_period_type%TYPE;
3616: l_org_time_phased_code pa_proj_fp_options.all_time_phased_code%TYPE;
3617: l_org_amount_set_id pa_fin_plan_amount_sets.fin_plan_amount_set_id%TYPE;
3618: l_org_structure_version_id pa_implementations_all.org_structure_version_id%TYPE;

Line 3623: l_request_id pa_budget_versions.request_id%TYPE;

3619: l_period_set_name pa_implementations_all.period_set_name%TYPE;
3620: l_act_period_type gl_periods.period_type%TYPE;
3621: l_org_projfunc_currency_code gl_sets_of_books.currency_code%TYPE;
3622: l_number_of_periods pa_forecasting_options_all.number_of_periods%TYPE;
3623: l_request_id pa_budget_versions.request_id%TYPE;
3624: l_weighted_or_full_code pa_forecasting_options_all.weighted_or_full_code%TYPE;
3625: l_fcst_start_date pa_proj_fp_options.fin_plan_start_date%TYPE;
3626: l_fcst_end_date pa_proj_fp_options.fin_plan_end_date%TYPE;
3627: l_org_project_template_id pa_forecasting_options_all.org_fcst_project_template_id%TYPE;

Line 3727: pa_budget_versions

3723: nvl(max(version_number), 0)
3724: into
3725: l_max_version
3726: from
3727: pa_budget_versions
3728: where
3729: project_id = p_project_id and
3730: fin_plan_type_id = p_fin_plan_type_id and
3731: budget_status_code in ('W', 'S');

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

3876: /* create the plan version */
3877: IF P_PA_DEBUG_MODE = 'Y' THEN
3878: pa_debug.write_file('Create_Version_OrgFcst: ' || 'calling pa_fp_budget_versions_pkg.Insert_Row to create a budget version');
3879: END IF;
3880: select pa_budget_versions_s.nextVal into l_budget_version_id from dual;
3881: /* the new version is the current working only if it's the ONLY working version */
3882: if (l_max_version = 0) then
3883: l_current_working_flag := 'Y';
3884: else

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

4115: end Create_Version_OrgFcst;
4116: /* ------------------------------------------------------------------------- */
4117:
4118: procedure Regenerate
4119: (p_project_id IN pa_budget_versions.project_id%TYPE,
4120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4121: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895

Line 4120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,

4116: /* ------------------------------------------------------------------------- */
4117:
4118: procedure Regenerate
4119: (p_project_id IN pa_budget_versions.project_id%TYPE,
4120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4121: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4124: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4121: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,

4117:
4118: procedure Regenerate
4119: (p_project_id IN pa_budget_versions.project_id%TYPE,
4120: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
4121: p_record_version_number IN pa_budget_versions.record_version_number%TYPE,
4122: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4123: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4124: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4125: is

Line 4129: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;

4125: is
4126: l_debug_mode VARCHAR2(30);
4127: l_msg_count NUMBER := 0;
4128: l_valid_flag VARCHAR2(1);
4129: l_budget_status_code pa_budget_versions.budget_status_code%TYPE;
4130: l_request_id NUMBER;
4131: l_data VARCHAR2(2000);
4132: l_msg_data VARCHAR2(2000);
4133: l_error_msg_code VARCHAR2(30);

Line 4179: pa_budget_versions

4175: budget_status_code
4176: into
4177: l_budget_status_code
4178: from
4179: pa_budget_versions
4180: where
4181: budget_version_id=p_budget_version_id;
4182: **/
4183: -- get org id to initiaize before submit the fnd request

Line 4189: ,pa_budget_versions bv

4185: ,bv.budget_status_code
4186: INTO l_org_id
4187: ,l_budget_status_code
4188: FROM pa_projects_all pp
4189: ,pa_budget_versions bv
4190: WHERE pp.project_id = bv.project_id
4191: AND bv.budget_version_id = p_budget_version_id;
4192: /* End of bug fix:4510784 */
4193:

Line 4283: pa_budget_versions

4279: IF P_PA_DEBUG_MODE = 'Y' THEN
4280: pa_debug.write_file('Regenerate: ' || 'concurrent process submitted successfully; stamping request_id');
4281: END IF;
4282: update
4283: pa_budget_versions
4284: set
4285: request_id = l_request_id,
4286: plan_processing_code = PA_FP_CONSTANTS_PKG.G_TIME_PHASED_CODE_P, /* "Generation in process" */
4287: record_version_number = record_version_number + 1

Line 4317: (p_project_id IN pa_budget_versions.project_id%TYPE

4313:
4314: /* ------------------------------------------------------------------------- */
4315:
4316: procedure Update_Version
4317: (p_project_id IN pa_budget_versions.project_id%TYPE
4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE

Line 4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

4314: /* ------------------------------------------------------------------------- */
4315:
4316: procedure Update_Version
4317: (p_project_id IN pa_budget_versions.project_id%TYPE
4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

Line 4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE

4315:
4316: procedure Update_Version
4317: (p_project_id IN pa_budget_versions.project_id%TYPE
4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010

Line 4320: ,p_version_name IN pa_budget_versions.version_name%TYPE

4316: procedure Update_Version
4317: (p_project_id IN pa_budget_versions.project_id%TYPE
4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

Line 4321: ,p_description IN pa_budget_versions.description%TYPE

4317: (p_project_id IN pa_budget_versions.project_id%TYPE
4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

Line 4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE

4318: ,p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
4319: ,p_record_version_number IN pa_budget_versions.record_version_number%TYPE
4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

Line 4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

4320: ,p_version_name IN pa_budget_versions.version_name%TYPE
4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

4321: ,p_description IN pa_budget_versions.description%TYPE
4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

4322: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE
4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

4323: -- Start of additional columns for Bug :- 3088010
4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

4324: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

4325: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

4326: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

4327: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

4328: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

4329: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

4330: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

4331: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

4332: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4340: -- End of additional columns for Bug :- 3088010

Line 4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

4333: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4340: -- End of additional columns for Bug :- 3088010
4341: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

Line 4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

4334: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4340: -- End of additional columns for Bug :- 3088010
4341: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4342: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

4335: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
4336: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
4337: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
4338: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
4339: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
4340: -- End of additional columns for Bug :- 3088010
4341: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
4342: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
4343: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4347: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

4343: ,x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4344: is
4345: l_debug_mode VARCHAR2(30);
4346: l_valid_flag VARCHAR2(1);
4347: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
4348: l_record_version_number pa_budget_versions.record_version_number%TYPE;
4349:
4350: l_msg_count NUMBER := 0;
4351: l_data VARCHAR2(2000);

Line 4348: l_record_version_number pa_budget_versions.record_version_number%TYPE;

4344: is
4345: l_debug_mode VARCHAR2(30);
4346: l_valid_flag VARCHAR2(1);
4347: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
4348: l_record_version_number pa_budget_versions.record_version_number%TYPE;
4349:
4350: l_msg_count NUMBER := 0;
4351: l_data VARCHAR2(2000);
4352: l_msg_data VARCHAR2(2000);

Line 4414: PA_BUDGET_VERSIONS

4410: SAVEPOINT PA_FIN_PLAN_PUB_UPDATE_VERSION;
4411: l_record_version_number := p_record_version_number + 1;
4412:
4413: UPDATE
4414: PA_BUDGET_VERSIONS
4415: SET
4416: record_version_number = l_record_version_number,
4417: version_name = p_version_name,
4418: description = p_description,

Line 4465: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,

4461: ORG_FORECAST'
4462: =========================================================================*/
4463: procedure Create_Org_Fcst_Elements (
4464: p_project_id IN pa_projects_all.project_id%TYPE,
4465: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4466: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895

Line 4466: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,

4462: =========================================================================*/
4463: procedure Create_Org_Fcst_Elements (
4464: p_project_id IN pa_projects_all.project_id%TYPE,
4465: p_source_version_id IN pa_budget_versions.budget_version_id%TYPE,
4466: p_target_version_id IN pa_budget_versions.budget_version_id%TYPE,
4467: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4468: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4469: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4470:

Line 5136: pa_fp_txn_currencies and pa_budget_versions.

5132: Bug No. 2331201 For finplan this api has been added
5133: This api Creates a working fin plan version.The version inherits its
5134: properties from plan type.This api creates records in
5135: pa_proj_fp_options , pa_resource_assignments,
5136: pa_fp_txn_currencies and pa_budget_versions.
5137: If px_budget_version_id is passed it is assumed that new version
5138: id is created and passed to the api, else new value is created.
5139:
5140: -- 26-JUN-2003 jwhite - Plannable Task Dev Effort:

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

5186: ,p_element_type IN VARCHAR2
5187: ,p_version_name IN VARCHAR2
5188: ,p_description IN VARCHAR2
5189: -- Start of additional columns for Bug :- 2634900
5190: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL

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

5187: ,p_version_name IN VARCHAR2
5188: ,p_description IN VARCHAR2
5189: -- Start of additional columns for Bug :- 2634900
5190: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M

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

5188: ,p_description IN VARCHAR2
5189: -- Start of additional columns for Bug :- 2634900
5190: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5196: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL

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

5189: -- Start of additional columns for Bug :- 2634900
5190: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5196: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5197: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL

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

5190: ,p_ci_id IN pa_budget_versions.ci_id%TYPE --:= NULL
5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5196: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5197: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5198: ,p_calling_context IN VARCHAR2 --:= NULL

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

5191: ,p_est_proj_raw_cost IN pa_budget_versions.est_project_raw_cost%TYPE --:= NULL
5192: ,p_est_proj_bd_cost IN pa_budget_versions.est_project_burdened_cost%TYPE--:= NULL
5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5196: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5197: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5198: ,p_calling_context IN VARCHAR2 --:= NULL
5199: -- End of additional columns for Bug :- 2634900

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

5193: ,p_est_proj_revenue IN pa_budget_versions.est_project_revenue%TYPE --:= NULL
5194: ,p_est_qty IN pa_budget_versions.est_quantity%TYPE --:= NULL
5195: ,p_est_equip_qty IN pa_budget_versions.est_equipment_quantity%TYPE --:= NULL FP.M
5196: ,p_impacted_task_id IN pa_tasks.task_id%TYPE --:= NULL
5197: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5198: ,p_calling_context IN VARCHAR2 --:= NULL
5199: -- End of additional columns for Bug :- 2634900
5200: -- Start of additional columns for Bug :- 2649474
5201: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE --:= NULL

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

5197: ,p_agreement_id IN pa_budget_versions.agreement_id%TYPE --:= NULL
5198: ,p_calling_context IN VARCHAR2 --:= NULL
5199: -- End of additional columns for Bug :- 2634900
5200: -- Start of additional columns for Bug :- 2649474
5201: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE --:= NULL
5202: ,p_time_phased_code IN pa_proj_fp_options.cost_time_phased_code%TYPE --:= NULL
5203: ,p_fin_plan_level_code IN pa_proj_fp_options.cost_fin_plan_level_code%TYPE --:= NULL
5204: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --:= NULL
5205: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL

Line 5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE

5204: ,p_plan_in_multi_curr_flag IN pa_proj_fp_options.plan_in_multi_curr_flag%TYPE --:= NULL
5205: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL
5206: -- End of additional columns for Bug :- 2649474
5207: -- Start of additional columns for Bug :- 3088010
5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

Line 5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE

5205: ,p_amount_set_id IN pa_proj_fp_options.cost_amount_set_id%TYPE --:= NULL
5206: -- End of additional columns for Bug :- 2649474
5207: -- Start of additional columns for Bug :- 3088010
5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

Line 5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE

5206: -- End of additional columns for Bug :- 2649474
5207: -- Start of additional columns for Bug :- 3088010
5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

Line 5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE

5207: -- Start of additional columns for Bug :- 3088010
5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

Line 5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE

5208: ,p_attribute_category IN pa_budget_versions.attribute_category%TYPE
5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

Line 5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE

5209: ,p_attribute1 IN pa_budget_versions.attribute1%TYPE
5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

Line 5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE

5210: ,p_attribute2 IN pa_budget_versions.attribute2%TYPE
5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

Line 5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE

5211: ,p_attribute3 IN pa_budget_versions.attribute3%TYPE
5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

Line 5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE

5212: ,p_attribute4 IN pa_budget_versions.attribute4%TYPE
5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

Line 5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE

5213: ,p_attribute5 IN pa_budget_versions.attribute5%TYPE
5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

Line 5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE

5214: ,p_attribute6 IN pa_budget_versions.attribute6%TYPE
5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

Line 5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE

5215: ,p_attribute7 IN pa_budget_versions.attribute7%TYPE
5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

Line 5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE

5216: ,p_attribute8 IN pa_budget_versions.attribute8%TYPE
5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5224: -- End of additional columns for Bug :- 3088010

Line 5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE

5217: ,p_attribute9 IN pa_budget_versions.attribute9%TYPE
5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5224: -- End of additional columns for Bug :- 3088010
5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE

5218: ,p_attribute10 IN pa_budget_versions.attribute10%TYPE
5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5224: -- End of additional columns for Bug :- 3088010
5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5226: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518

Line 5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE

5219: ,p_attribute11 IN pa_budget_versions.attribute11%TYPE
5220: ,p_attribute12 IN pa_budget_versions.attribute12%TYPE
5221: ,p_attribute13 IN pa_budget_versions.attribute13%TYPE
5222: ,p_attribute14 IN pa_budget_versions.attribute14%TYPE
5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5224: -- End of additional columns for Bug :- 3088010
5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5226: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5227: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL

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

5223: ,p_attribute15 IN pa_budget_versions.attribute15%TYPE
5224: -- End of additional columns for Bug :- 3088010
5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5226: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5227: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5228: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5229: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5230: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5231: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

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

5224: -- End of additional columns for Bug :- 3088010
5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5226: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5227: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5228: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5229: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5230: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5231: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5232: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

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

5225: ,px_budget_version_id IN OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5226: ,p_struct_elem_version_id IN pa_proj_element_versions.element_version_id%TYPE --For Bug 3354518
5227: ,p_pm_product_code IN pa_budget_versions.pm_product_code%TYPE DEFAULT NULL
5228: ,p_finplan_reference IN pa_budget_versions.pm_budget_reference%TYPE DEFAULT NULL
5229: ,p_change_reason_code IN pa_budget_versions.change_reason_code%TYPE DEFAULT NULL
5230: ,p_pji_rollup_required IN VARCHAR2 DEFAULT 'Y' --Bug 4200168
5231: ,x_proj_fp_option_id OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
5232: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
5233: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895

Line 5251: l_max_version_number pa_budget_versions.version_number%TYPE;

5247: l_debug_mode VARCHAR2(30);
5248:
5249: -- End of variables used for debugging purpose
5250:
5251: l_max_version_number pa_budget_versions.version_number%TYPE;
5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;

Line 5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;

5248:
5249: -- End of variables used for debugging purpose
5250:
5251: l_max_version_number pa_budget_versions.version_number%TYPE;
5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;

Line 5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;

5249: -- End of variables used for debugging purpose
5250:
5251: l_max_version_number pa_budget_versions.version_number%TYPE;
5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;

5250:
5251: l_max_version_number pa_budget_versions.version_number%TYPE;
5252: l_new_budget_version_id pa_budget_versions.budget_version_id%TYPE;
5253: l_current_working_flag pa_budget_versions.current_working_flag%TYPE;
5254: l_dummy_version_id pa_budget_versions.budget_version_id%TYPE;
5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;

Line 5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;

5255: l_new_proj_fp_options_id pa_proj_fp_options.proj_fp_options_id%TYPE;
5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

Line 5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;

5256: l_project_currency_code pa_projects_all.project_currency_code%TYPE;
5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

Line 5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;

5257: l_projfunc_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;

Line 5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;

5258: l_dummy_currency_code pa_projects_all.projfunc_currency_code%TYPE;
5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;

Line 5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;

5259: l_est_projfunc_raw_cost pa_budget_versions.est_projfunc_raw_cost%TYPE;
5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;
5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;

Line 5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;

5260: l_est_projfunc_bd_cost pa_budget_versions.est_projfunc_burdened_cost%TYPE;
5261: l_est_projfunc_revenue pa_budget_versions.est_projfunc_revenue%TYPE;
5262: l_est_project_raw_cost pa_budget_versions.est_project_raw_cost%TYPE;
5263: l_est_project_bd_cost pa_budget_versions.est_project_burdened_cost%TYPE;
5264: l_est_project_revenue pa_budget_versions.est_project_revenue%TYPE;
5265: l_agreement_num pa_agreements_all.agreement_num%TYPE;
5266: l_agreement_amount pa_agreements_all.amount%TYPE;
5267: l_agreement_currency_code pa_agreements_all.agreement_currency_code%TYPE;
5268:

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

5305: l_prj_end_date VARCHAR2(100);
5306: l_budget_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5307:
5308: -- 01-JUL-2003 Default ci from current working version (bug 2989874)
5309: l_ci_apprv_cw_bv_id pa_budget_versions.budget_version_id%TYPE :=NULL;
5310:
5311: -- Added by pseethar. Used for workplan flag, derivered from pa_fin_plan_types_b
5312: l_WP_VERSION_FLAG pa_fin_plan_types_b.USE_FOR_WORKPLAN_FLAG%TYPE;
5313:

Line 5393: FROM pa_proj_fp_options pfo, pa_budget_versions bv

5389: , pfo.primary_cost_forecast_flag
5390: , pfo.primary_rev_forecast_flag
5391: , bv.actual_amts_thru_period
5392: , bv.project_structure_version_id
5393: FROM pa_proj_fp_options pfo, pa_budget_versions bv
5394: WHERE pfo.project_id = c_project_id
5395: AND pfo.fin_plan_type_id = c_fin_plan_type_id
5396: AND pfo.fin_plan_version_id = c_fin_plan_version_id
5397: AND bv.budget_version_id = c_fin_plan_version_id

Line 5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE

5412: ,approved_cost_plan_type_flag PA_PROJ_FP_OPTIONS.approved_cost_plan_type_flag%TYPE
5413: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5414: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5415: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE

Line 5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE

5413: ,approved_rev_plan_type_flag PA_PROJ_FP_OPTIONS.approved_rev_plan_type_flag%TYPE
5414: ,select_res_auto_flag PA_PROJ_FP_OPTIONS.select_cost_res_auto_flag%TYPE
5415: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5421: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL

Line 5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE

5415: ,source_fp_options_id PA_PROJ_FP_OPTIONS.PROJ_FP_OPTIONS_ID%TYPE
5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5421: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5422: );
5423:

Line 5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE

5416: ,version_type PA_BUDGET_VERSIONS.version_type%TYPE
5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5421: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5422: );
5423:
5424: new_version_info_rec new_version_rec_type;

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

5417: ,project_structure_version_id PA_BUDGET_VERSIONS.project_structure_version_id%TYPE
5418: ,rbs_version_id PA_PROJ_FP_OPTIONS.rbs_version_id%TYPE
5419: ,primary_cost_forecast_flag PA_BUDGET_VERSIONS.primary_cost_forecast_flag%TYPE
5420: ,primary_rev_forecast_flag PA_BUDGET_VERSIONS.primary_rev_forecast_flag%TYPE
5421: ,actual_amts_thru_period PA_BUDGET_VERSIONS.actual_amts_thru_period%TYPE := NULL
5422: );
5423:
5424: new_version_info_rec new_version_rec_type;
5425:

Line 5434: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;

5430: l_cw_ver_res_list_id NUMBER;
5431: l_row_id rowid;
5432: l_copy_res_assmt_from_cwv_flag VARCHAR2(1);
5433: -- ---------------------------------------------------------------------------
5434: l_src_bv_id_for_copying_ra pa_budget_versions.budget_version_id%TYPE;
5435:
5436: l_txn_source_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5437: l_res_list_member_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
5438: l_rbs_element_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 5961: FROM pa_budget_versions

5957: version should also be set as current_working_version. */
5958:
5959: SELECT budget_version_id
5960: INTO l_dummy_version_id
5961: FROM pa_budget_versions
5962: WHERE project_id = p_project_id
5963: AND fin_plan_type_id = p_fin_plan_type_id
5964: AND version_type = new_version_info_rec.version_type -- Bug :- 2668667
5965: AND current_working_flag = 'Y';

Line 5998: SELECT pa_budget_versions_s.NEXTVAL

5994: pa_debug.g_err_stage:='Fetching new budget_version_id';
5995: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
5996: END IF;
5997:
5998: SELECT pa_budget_versions_s.NEXTVAL
5999: INTO l_new_budget_version_id
6000: FROM DUAL;
6001: ELSE
6002: l_new_budget_version_id := px_budget_version_id;

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

6002: l_new_budget_version_id := px_budget_version_id;
6003: END IF;
6004:
6005:
6006: --Create a new record in pa_budget_versions using plan type properties
6007:
6008: IF P_PA_DEBUG_MODE = 'Y' THEN
6009: pa_debug.g_err_stage:='Calling budget_versions table handler to insert new row ';
6010: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);

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

6009: pa_debug.g_err_stage:='Calling budget_versions table handler to insert new row ';
6010: pa_debug.write('Create_Version: ' || l_module_name,pa_debug.g_err_stage,3);
6011: END IF;
6012:
6013: -- Getting the Use for workplan flag to populate WP_VERSION_FLAG in pa_budget_versions
6014: SELECT use_for_workplan_flag
6015: INTO l_wp_version_flag
6016: FROM pa_fin_plan_types_b
6017: WHERE fin_plan_type_id = p_fin_plan_type_id;

Line 6029: From pa_budget_versions

6025: l_exists varchar2(1);
6026: Begin
6027: Select 'Y'
6028: Into l_exists
6029: From pa_budget_versions
6030: Where project_structure_version_id =
6031: nvl(p_struct_elem_version_id,new_version_info_rec.project_structure_version_id)
6032: And wp_version_flag = 'Y'
6033: And exists (select 'x' from pa_budget_versions b

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

6029: From pa_budget_versions
6030: Where project_structure_version_id =
6031: nvl(p_struct_elem_version_id,new_version_info_rec.project_structure_version_id)
6032: And wp_version_flag = 'Y'
6033: And exists (select 'x' from pa_budget_versions b
6034: where b.budget_version_id =
6035: nvl(l_ci_apprv_cw_bv_id,l_fin_plan_version_id)
6036: and b.wp_version_flag = 'Y') ;
6037:

Line 6501: UPDATE Pa_Budget_Versions SET

6497: END IF;
6498:
6499: -- Update the budget versions table with the converted estimated amounts in projfunc currency
6500:
6501: UPDATE Pa_Budget_Versions SET
6502: est_projfunc_raw_cost = l_est_projfunc_raw_cost,
6503: est_projfunc_burdened_cost = l_est_projfunc_bd_cost,
6504: est_projfunc_revenue = l_est_projfunc_revenue
6505: WHERE Budget_Version_Id = l_new_budget_version_id;

Line 7124: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;

7120:
7121: l_plan_start_date gl_periods.start_date%TYPE;
7122: l_plan_end_date gl_periods.end_date%TYPE;
7123:
7124: l_period_profile_id pa_budget_versions.period_profile_id%TYPE;
7125:
7126: BEGIN
7127:
7128: x_msg_count := 0;

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

7199: SELECT MIN (pbl.start_date)
7200: ,MAX(pbl.end_date)
7201: INTO l_start_date
7202: ,l_end_date
7203: FROM pa_budget_versions pbv --bug#2708524 pa_resource_assignments pra
7204: ,pa_budget_lines pbl
7205: WHERE pbv.project_id = p_project_id
7206: AND pbl.budget_version_id = pbv.budget_version_id
7207: AND PA_FIN_PLAN_UTILS.GET_TIME_PHASED_CODE(pbv.budget_version_id)

Line 7657: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE

7653: Budget Lines with appropriate values and call Maintain Matrix API to update the
7654: USER_ENTERED level records into pa_proj_periods_denorm table.
7655: ---------------------------------------------------------------------------------------------*/
7656: PROCEDURE Call_Maintain_Plan_Matrix (
7657: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE
7658: ,p_data_source IN VARCHAR2
7659: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
7660: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
7661: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 7671: l_project_id pa_budget_versions.PROJECT_ID%TYPE;

7667: l_msg_index_out NUMBER;
7668: l_return_status VARCHAR2(2000);
7669: l_debug_mode VARCHAR2(30);
7670:
7671: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7672: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7673: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7674: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7675: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;

Line 7672: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;

7668: l_return_status VARCHAR2(2000);
7669: l_debug_mode VARCHAR2(30);
7670:
7671: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7672: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7673: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7674: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7675: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;
7676:

Line 7673: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;

7669: l_debug_mode VARCHAR2(30);
7670:
7671: l_project_id pa_budget_versions.PROJECT_ID%TYPE;
7672: l_period_profile_id pa_budget_versions.PERIOD_PROFILE_ID%TYPE;
7673: l_budget_version_type pa_budget_versions.VERSION_TYPE%TYPE;
7674: l_fp_preference_code pa_proj_fp_options.FIN_PLAN_PREFERENCE_CODE%TYPE;
7675: l_margin_derived_from_code pa_proj_fp_options.MARGIN_DERIVED_FROM_CODE%TYPE;
7676:
7677: l_plsql_max_array_size NUMBER := 200;

Line 7888: FROM pa_budget_versions

7884: SELECT project_id,
7885: period_profile_id
7886: INTO l_project_id,
7887: l_period_profile_id
7888: FROM pa_budget_versions
7889: WHERE budget_version_id = p_budget_version_id;
7890:
7891: /* Get the value of the Preference code of the Budget Version. Margin and
7892: Margin % have to be populated only if the Preference code is

Line 8195: FROM PA_BUDGET_VERSIONS

8191: END IF;
8192:
8193: SELECT version_type
8194: INTO l_budget_version_type
8195: FROM PA_BUDGET_VERSIONS
8196: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8197:
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;

Line 8196: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;

8192:
8193: SELECT version_type
8194: INTO l_budget_version_type
8195: FROM PA_BUDGET_VERSIONS
8196: WHERE pa_budget_versions.budget_version_id = p_budget_version_id;
8197:
8198: amt_rec(l_tbl_index).amount_type_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8199: amt_rec(l_tbl_index).amount_subtype_code := PA_FP_CONSTANTS_PKG.G_AMOUNT_TYPE_QUANTITY;
8200: 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 8298: p_project_id IN pa_budget_versions.project_id%TYPE

8294: resource list.
8295: ==============================================================================*/
8296:
8297: PROCEDURE Refresh_res_list_assignment (
8298: p_project_id IN pa_budget_versions.project_id%TYPE
8299: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
8300: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8301: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8302: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895

Line 8299: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE

8295: ==============================================================================*/
8296:
8297: PROCEDURE Refresh_res_list_assignment (
8298: p_project_id IN pa_budget_versions.project_id%TYPE
8299: ,p_resource_list_id IN pa_budget_versions.resource_list_id%TYPE
8300: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
8301: ,x_msg_count OUT NOCOPY NUMBER --File.Sql.39 bug 4440895
8302: ,x_msg_data OUT NOCOPY VARCHAR2 ) --File.Sql.39 bug 4440895
8303: AS

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

8478: */
8479:
8480:
8481: PROCEDURE create_default_plan_txn_rec
8482: (p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
8483: p_calling_module IN VARCHAR2,
8484: p_ra_id_tbl IN SYSTEM.PA_NUM_TBL_TYPE DEFAULT SYSTEM.PA_NUM_TBL_TYPE(), /* 7161809 */
8485: p_curr_code_tbl IN SYSTEM.PA_VARCHAR2_15_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_15_TBL_TYPE(), /* 7161809 */
8486: p_expenditure_type_tbl IN SYSTEM.PA_VARCHAR2_30_TBL_TYPE DEFAULT SYSTEM.PA_VARCHAR2_30_TBL_TYPE(), /* Enc */

Line 8529: l_ci_id pa_budget_versions.ci_id%TYPE;

8525: l_agr_curr_code pa_agreements_all.agreement_currency_code%TYPE;
8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;
8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8532:
8533: -- IPM Arch Enhancement - Bug 4865563

Line 8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;

8526: l_proj_curr_code pa_projects_all.project_currency_code%TYPE;
8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;
8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8532:
8533: -- IPM Arch Enhancement - Bug 4865563
8534: 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 8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;

8527: l_pfunc_curr_code pa_projects_all.projfunc_currency_code%TYPE;
8528:
8529: l_ci_id pa_budget_versions.ci_id%TYPE;
8530: l_agreement_id pa_budget_versions.agreement_id%TYPE;
8531: l_app_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE;
8532:
8533: -- IPM Arch Enhancement - Bug 4865563
8534: l_fp_cols_rec PA_FP_GEN_AMOUNT_UTILS.FP_COLS; --This variable will be used to call pa_resource_asgn_curr maintenance api
8535: l_debug_level5 NUMBER:=5;

Line 8625: FROM pa_budget_versions pbv,

8621: l_agreement_id,
8622: l_app_rev_flag,
8623: l_proj_curr_code,
8624: l_pfunc_curr_code
8625: FROM pa_budget_versions pbv,
8626: pa_projects_all ppa
8627: WHERE pbv.budget_version_id = p_budget_version_id
8628: AND ppa.project_id = pbv.project_id;
8629: EXCEPTION