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

Line 35: from pa_budget_versions bv , pa_budget_types bt

31:
32:
33: select bv.budget_version_id
34: into x_budget_version_id
35: from pa_budget_versions bv , pa_budget_types bt
36: where bv.project_id = x_project_id
37: and bv.budget_type_code = x_budget_type_code
38: and bv.budget_status_code in ('W', 'S')
39: and bv.budget_type_code = bt.budget_type_code

Line 93: from pa_budget_versions bv, pa_budget_types bt

89: || '><' || x_budget_type_code || '>' ;
90:
91: select bv.budget_version_id
92: into x_budget_version_id
93: from pa_budget_versions bv, pa_budget_types bt
94: where bv.project_id = x_project_id
95: and bv.budget_type_code = x_budget_type_code
96: and bv.current_flag = 'Y'
97: and bv.budget_type_code = bt.budget_type_code

Line 135: from pa_budget_versions bv, pa_budget_types bt

131: || '><' || x_budget_type_code || '>' ;
132:
133: select bv.budget_version_id
134: into x_budget_version_id
135: from pa_budget_versions bv, pa_budget_types bt
136: where bv.project_id = x_project_id
137: and bv.budget_type_code = x_budget_type_code
138: and bv.current_original_flag = 'Y'
139: and bv.budget_type_code = bt.budget_type_code

Line 222: from pa_budget_versions

218: -- baseliend budget exists, use it to get the resource list
219:
220: select resource_list_id
221: into x_resource_list_id
222: from pa_budget_versions
223: where budget_version_id = x_baselined_version_id;
224:
225: elsif (x_err_code > 0) then
226:

Line 528: from pa_budget_versions bv, pa_budget_types bt

524: into dummy
525: from dual
526: where exists
527: (select 1
528: from pa_budget_versions bv, pa_budget_types bt
529: where bv.project_id = x_project_id
530: and bv.budget_type_code is NOT NULL -- This must be specified for r11.5.7 Budgets Model
531: and bv.budget_type_code = bt.budget_type_code
532: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 560: from pa_budget_versions bv

556: into dummy
557: from dual
558: where exists
559: (select 1
560: from pa_budget_versions bv
561: where bv.project_id = x_project_id
562: and bv.fin_plan_type_id is NOT NULL -- Specified for FP Model
563: and nvl(bv.wp_version_flag,'N') = 'N' -- (Added for Patchset M,Tracking Bug No - 3354518)
564: );

Line 585: from pa_budget_versions bv, pa_budget_types bt

581: into dummy
582: from dual
583: where exists
584: (select 1
585: from pa_budget_versions bv, pa_budget_types bt
586: where bv.project_id = x_project_id
587: and bv.budget_type_code = x_budget_type_code
588: and bv.budget_type_code = bt.budget_type_code
589: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 610: from pa_budget_versions bv

606: into dummy
607: from dual
608: where exists
609: (select 1
610: from pa_budget_versions bv
611: where bv.project_id = x_project_id
612: and bv.fin_plan_type_id = x_fin_plan_type_id
613: and bv.version_type = nvl(x_version_type, bv.version_type)
614: );

Line 635: from pa_budget_versions bv, pa_budget_types bt

631: into dummy
632: from dual
633: where exists
634: (select 1
635: from pa_budget_versions bv, pa_budget_types bt
636: where bv.project_id = x_project_id
637: and bv.budget_type_code = x_budget_type_code
638: and bv.budget_type_code = bt.budget_type_code
639: and nvl(bt.plan_type,'BUDGET') = 'BUDGET');

Line 660: from pa_budget_versions bv

656: into dummy
657: from dual
658: where exists
659: (select 1
660: from pa_budget_versions bv
661: where bv.project_id = x_project_id
662: and bv.fin_plan_type_id = x_fin_plan_type_id
663: and bv.version_type = nvl(x_version_type, bv.version_type)
664: );

Line 713: from pa_budget_versions bv

709: into dummy
710: from dual
711: where exists
712: (select 1
713: from pa_budget_versions bv
714: where bv.project_id = x_project_id
715: and bv.approved_cost_plan_type_flag = 'Y'
716: and bv.current_flag = 'Y'
717: );

Line 729: from pa_budget_versions bv

725: into dummy
726: from dual
727: where exists
728: (select 1
729: from pa_budget_versions bv
730: where bv.project_id = x_project_id
731: and bv.approved_rev_plan_type_flag = 'Y'
732: and bv.current_flag = 'Y'
733: );

Line 759: from pa_budget_versions bv

755: into dummy
756: from dual
757: where exists
758: (select 1
759: from pa_budget_versions bv
760: where bv.project_id = x_project_id
761: and bv.fin_plan_type_id = x_fin_plan_type_id
762: and bv.version_type = nvl(x_version_type, bv.version_type)
763: and bv.approved_cost_plan_type_flag = 'Y'

Line 775: from pa_budget_versions bv

771: into dummy
772: from dual
773: where exists
774: (select 1
775: from pa_budget_versions bv
776: where bv.project_id = x_project_id
777: and bv.fin_plan_type_id = x_fin_plan_type_id
778: and bv.version_type = nvl(x_version_type, bv.version_type)
779: and bv.approved_rev_plan_type_flag = 'Y'

Line 809: from pa_budget_versions bv, pa_budget_types bt

805: into dummy
806: from dual
807: where exists
808: (select 1
809: from pa_budget_versions bv, pa_budget_types bt
810: where bv.project_id = x_project_id
811: and bv.budget_type_code = x_budget_type_code
812: and bv.budget_type_code = bt.budget_type_code
813: and nvl(bt.plan_type,'BUDGET') = 'BUDGET'

Line 835: from pa_budget_versions bv

831: into dummy
832: from dual
833: where exists
834: (select 1
835: from pa_budget_versions bv
836: where bv.project_id = x_project_id
837: and bv.fin_plan_type_id = x_fin_plan_type_id
838: and bv.version_type = nvl(x_version_type, bv.version_type)
839: and bV.current_flag = 'Y'

Line 954: from pa_budget_versions bv

950: into dummy
951: from dual
952: where exists
953: (select 1
954: from pa_budget_versions bv
955: , pa_budget_types bt
956: , pa_resource_assignments a
957: where a.task_id = x_task_id
958: and bv.budget_version_id = a.budget_version_id

Line 990: from pa_budget_versions bv

986: into dummy
987: from dual
988: where exists
989: (select 1
990: from pa_budget_versions bv
991: , pa_resource_assignments a
992: where a.task_id = x_task_id
993: and bv.budget_version_id = a.budget_version_id
994: and bv.fin_plan_type_id is NOT NULL -- Specified for FP Model

Line 1018: from pa_budget_versions bv

1014: into dummy
1015: from dual
1016: where exists
1017: (select 1
1018: from pa_budget_versions bv
1019: , pa_budget_types bt
1020: , pa_resource_assignments a
1021: where a.task_id = x_task_id
1022: and bv.budget_version_id = a.budget_version_id

Line 1047: from pa_budget_versions bv

1043: into dummy
1044: from dual
1045: where exists
1046: (select 1
1047: from pa_budget_versions bv
1048: , pa_resource_assignments a
1049: where a.task_id = x_task_id
1050: and bv.budget_version_id = a.budget_version_id
1051: and bv.fin_plan_type_id = x_fin_plan_type_id

Line 1074: from pa_budget_versions bv

1070: into dummy
1071: from dual
1072: where exists
1073: (select 1
1074: from pa_budget_versions bv
1075: , pa_budget_types bt
1076: , pa_resource_assignments a
1077: where a.task_id = x_task_id
1078: and bv.budget_version_id = a.budget_version_id

Line 1103: from pa_budget_versions bv

1099: into dummy
1100: from dual
1101: where exists
1102: (select 1
1103: from pa_budget_versions bv
1104: , pa_resource_assignments a
1105: where a.task_id = x_task_id
1106: and bv.budget_version_id = a.budget_version_id
1107: and bv.fin_plan_type_id = x_fin_plan_type_id

Line 1155: from pa_budget_versions bv

1151: into dummy
1152: from dual
1153: where exists
1154: (select 1
1155: from pa_budget_versions bv
1156: , pa_tasks t
1157: , pa_resource_assignments a
1158: where a.budget_version_id = bv.budget_version_id
1159: and a.task_id = t.task_id

Line 1173: from pa_budget_versions bv

1169: into dummy
1170: from dual
1171: where exists
1172: (select 1
1173: from pa_budget_versions bv
1174: , pa_tasks t
1175: , pa_resource_assignments a
1176: where a.budget_version_id = bv.budget_version_id
1177: and a.task_id = t.task_id

Line 1211: from pa_budget_versions bv

1207: into dummy
1208: from dual
1209: where exists
1210: (select 1
1211: from pa_budget_versions bv
1212: ,pa_tasks t --Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1213: -- , pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1214: ,pa_resource_assignments a
1215: where a.budget_version_id = bv.budget_version_id

Line 1238: from pa_budget_versions bv

1234: into dummy
1235: from dual
1236: where exists
1237: (select 1
1238: from pa_budget_versions bv
1239: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1240: --, pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1241: ,pa_resource_assignments a
1242: where a.budget_version_id = bv.budget_version_id

Line 1277: from pa_budget_versions bv

1273: into dummy
1274: from dual
1275: where exists
1276: (select 1
1277: from pa_budget_versions bv
1278: , pa_budget_types bt
1279: , pa_tasks t
1280: , pa_resource_assignments a
1281: where a.budget_version_id = bv.budget_version_id

Line 1314: from pa_budget_versions bv

1310: into dummy
1311: from dual
1312: where exists
1313: (select 1
1314: from pa_budget_versions bv
1315: ,pa_tasks t -- Bug 4176059: Performance Fix: FP.M -B12: re-used pa_tasks
1316: --, pa_struct_task_wbs_v t -- Adding for FP.M, Tracking Bug No - 3354518.
1317: ,pa_resource_assignments a
1318: where a.budget_version_id = bv.budget_version_id

Line 1485: FROM pa_budget_versions b

1481: INTO raw_cost,
1482: burdened_cost,
1483: labor_qty,
1484: revenue_amount
1485: FROM pa_budget_versions b
1486: WHERE b.project_id = x_project_id
1487: AND b.budget_type_code = x_budget_type
1488: AND b.budget_status_code = decode(budget_status, 'B', 'B',
1489: b.budget_status_code)

Line 1553: pa_budget_versions v

1549: revenue_amount
1550: FROM pa_budget_lines l,
1551: pa_resource_assignments a,
1552: pa_tasks t,
1553: pa_budget_versions v
1554: WHERE v.project_id = x_project_id
1555: AND v.budget_type_code = x_budget_type
1556: AND v.budget_status_code = decode(budget_status, 'B', 'B',
1557: v.budget_status_code)

Line 1606: pa_budget_versions v

1602: into x_project_id,
1603: x_budget_type_code,
1604: x_resource_list_assgmt_id
1605: from pa_resource_list_assignments la,
1606: pa_budget_versions v
1607: where v.budget_version_id = x_budget_version_id
1608: and v.project_id = la.project_id
1609: and v.resource_list_id = la.resource_list_id;
1610: ********/

Line 1670: delete pa_budget_versions

1666: -- Delete version
1667: x_err_stage := 'delete budget version <' || to_char(x_budget_version_id)
1668: || '>';
1669:
1670: delete pa_budget_versions
1671: where budget_version_id = x_budget_version_id;
1672:
1673: fnd_attached_documents2_pkg.delete_attachments('PA_BUDGET_VERSIONS',
1674: x_budget_version_id,

Line 1673: fnd_attached_documents2_pkg.delete_attachments('PA_BUDGET_VERSIONS',

1669:
1670: delete pa_budget_versions
1671: where budget_version_id = x_budget_version_id;
1672:
1673: fnd_attached_documents2_pkg.delete_attachments('PA_BUDGET_VERSIONS',
1674: x_budget_version_id,
1675: null, null, null, null,
1676: 'Y') ;
1677: x_err_stack := old_stack;

Line 1811: from pa_budget_versions

1807: -- resource list used in accumulation
1808:
1809: select resource_list_id
1810: into x_baselined_resource_list_id
1811: from pa_budget_versions
1812: where budget_version_id = x_baselined_version_id;
1813:
1814: if (x_resource_list_id <> x_baselined_resource_list_id) then
1815: x_err_code := 10;

Line 1920: SELECT pa_budget_versions_s.nextval

1916: end if;
1917: */
1918:
1919: -- Included this select to return the newly create budget version id
1920: SELECT pa_budget_versions_s.nextval
1921: INTO x_budget_version_id
1922: FROM dual;
1923: insert into pa_budget_versions(
1924: budget_version_id,

Line 1923: insert into pa_budget_versions(

1919: -- Included this select to return the newly create budget version id
1920: SELECT pa_budget_versions_s.nextval
1921: INTO x_budget_version_id
1922: FROM dual;
1923: insert into pa_budget_versions(
1924: budget_version_id,
1925: project_id,
1926: budget_type_code,
1927: version_number,

Line 2130: from pa_budget_versions

2126: v_budget_type_code varchar2(30);
2127:
2128: cursor get_budget_type_code is
2129: select budget_type_code
2130: from pa_budget_versions
2131: where budget_version_id = x_budget_version_id;
2132:
2133:
2134: l_Projfunc_Currency_Code pa_projects_all.projfunc_currency_code%TYPE := NULL;

Line 2558: update pa_budget_versions v

2554: pa_debug.g_err_stage:= 'In summerize_project_amounts';
2555: pa_debug.write('summerize_project_totals: ' || g_module_name,pa_debug.g_err_stage,PA_FP_CONSTANTS_PKG.G_DEBUG_LEVEL3);
2556: END IF;
2557:
2558: update pa_budget_versions v
2559: set (labor_quantity,
2560: labor_unit_of_measure,
2561: raw_cost,
2562: burdened_cost,

Line 2855: from pa_budget_versions

2851:
2852: -- get the sum of revenue budget for this p_draft_version_id
2853: select nvl(revenue,0) -- Bug 3142016
2854: into l_budget_total
2855: from pa_budget_versions
2856: where budget_version_id = p_draft_version_id;
2857:
2858: -- call pa_billing_core.verify_baseline_funding to check the funding revenue
2859: pa_billing_core.verify_baseline_funding(

Line 3060: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE :=NULL;

3056: l_msg_index_out NUMBER := 0;
3057: l_data VARCHAR2(2000) :=NULL;
3058:
3059: --R12 SLA Effort
3060: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE :=NULL;
3061: l_budget_type_code pa_budget_versions.budget_type_code%TYPE :=NULL;
3062:
3063: --Federal Uptake Bug 5522880
3064: l_federal_enabled VARCHAR2(1) := NULL;

Line 3061: l_budget_type_code pa_budget_versions.budget_type_code%TYPE :=NULL;

3057: l_data VARCHAR2(2000) :=NULL;
3058:
3059: --R12 SLA Effort
3060: l_baseline_version_id pa_budget_versions.budget_version_id%TYPE :=NULL;
3061: l_budget_type_code pa_budget_versions.budget_type_code%TYPE :=NULL;
3062:
3063: --Federal Uptake Bug 5522880
3064: l_federal_enabled VARCHAR2(1) := NULL;
3065: l_bem_failed EXCEPTION;

Line 3130: FROM pa_budget_versions bv

3126:
3127: begin
3128: SELECT budget_version_id
3129: INTO l_CC_Budget_Version_id
3130: FROM pa_budget_versions bv
3131: WHERE project_id = p_project_id
3132: AND BUDGET_STATUS_CODE = 'S'
3133: AND budget_type_code =
3134: (SELECT budget_type_code

Line 3253: FROM pa_budget_versions

3249: -- Get the baselined budget version for the draft
3250:
3251: SELECT budget_type_code
3252: INTO l_budget_type_code
3253: FROM pa_budget_versions
3254: WHERE budget_version_id = p_draft_version_id
3255: AND budget_status_code = 'S';
3256:
3257: SELECT budget_version_id, version_number

Line 3259: FROM pa_budget_versions

3255: AND budget_status_code = 'S';
3256:
3257: SELECT budget_version_id, version_number
3258: INTo l_baseline_version_id, l_baseline_version_number
3259: FROM pa_budget_versions
3260: WHERE budget_type_code = l_budget_type_code
3261: AND project_id = p_project_id
3262: AND budget_status_code = 'B'
3263: AND current_flag = 'Y';

Line 3300: FROM pa_budget_versions pb

3296:
3297: Begin
3298: SELECT budget_version_id
3299: INTo l_pre_baseline_version_id
3300: FROM pa_budget_versions pb
3301: WHERE pb.budget_type_code = l_budget_type_code
3302: AND pb.project_id = p_project_id
3303: AND pb.budget_status_code='B'
3304: AND pb.version_number = (l_baseline_version_number - 1);

Line 3387: from pa_budget_versions

3383: l_federal_enabled := NVL(FND_PROFILE.value('FV_ENABLED'), 'N');
3384:
3385: Select budget_type_code
3386: into l_budget_type_code
3387: from pa_budget_versions
3388: where budget_version_id = p_draft_version_id;
3389:
3390:
3391: If(l_federal_enabled = 'Y' AND l_budget_type_code is NOT NULL) then

Line 3395: FROM pa_budget_versions

3391: If(l_federal_enabled = 'Y' AND l_budget_type_code is NOT NULL) then
3392:
3393: SELECT budget_version_id, version_number
3394: INTo l_baseline_version_id, l_baseline_version_number
3395: FROM pa_budget_versions
3396: WHERE budget_type_code = l_budget_type_code
3397: AND project_id = p_project_id
3398: AND budget_status_code='B'
3399: AND current_flag = 'Y';

Line 3404: FROM pa_budget_versions pb

3400:
3401: Begin
3402: SELECT budget_version_id
3403: INTo l_pre_baseline_version_id
3404: FROM pa_budget_versions pb
3405: WHERE pb.budget_type_code = l_budget_type_code
3406: AND pb.project_id = p_project_id
3407: AND pb.budget_status_code = 'B'
3408: AND pb.version_number = (l_baseline_version_number - 1);

Line 3564: from pa_budget_versions

3560: select labor_quantity,
3561: raw_cost,
3562: burdened_cost,
3563: revenue
3564: from pa_budget_versions
3565: where v_rollup_flag = 'P' -- Project Level
3566: and budget_version_id = x_budget_version_id;
3567:
3568: --Bug 4176059: Performance Fix: FP.M-B12

Line 3793: l_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE := NULL;

3789: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3790: )
3791: IS
3792:
3793: l_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE := NULL;
3794: l_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE := NULL;
3795:
3796:
3797: BEGIN

Line 3794: l_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE := NULL;

3790: )
3791: IS
3792:
3793: l_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE := NULL;
3794: l_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE := NULL;
3795:
3796:
3797: BEGIN
3798:

Line 3807: FROM pa_budget_versions b

3803:
3804:
3805: SELECT b.approved_cost_plan_type_flag, b.approved_rev_plan_type_flag
3806: INTO l_cost_flag, l_rev_flag
3807: FROM pa_budget_versions b
3808: WHERE b.budget_version_id = p_budget_version_id;
3809:
3810:
3811: IF ( nvl(l_cost_flag,'N') = 'Y'

Line 3987: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;

3983:
3984:
3985: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3986: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3987: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;
3988: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;
3989:
3990: l_dummy VARCHAR2(1) := 'N';
3991:

Line 3988: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;

3984:
3985: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3986: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3987: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;
3988: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;
3989:
3990: l_dummy VARCHAR2(1) := 'N';
3991:
3992:

Line 4013: from pa_budget_versions v

4009: SELECT 'Y'
4010: INTO l_dummy
4011: FROM dual
4012: WHERE EXISTS (select '1'
4013: from pa_budget_versions v
4014: where v.project_id = p_project_id
4015: and v.budget_type_code IN ('AC','AR')
4016: );
4017:

Line 4045: , pa_budget_versions v

4041: -- AC
4042: SELECT o.fin_plan_type_id, v.version_type
4043: INTO l_ac_plan_type_id, l_ac_version_type
4044: FROM pa_proj_fp_options o
4045: , pa_budget_versions v
4046: WHERE o.fin_plan_version_id = v.budget_version_id
4047: AND v.approved_cost_plan_type_flag = 'Y'
4048: AND v.current_flag = 'Y'
4049: AND v.project_id = p_project_id;

Line 4065: , pa_budget_versions v

4061: -- AR
4062: SELECT o.fin_plan_type_id, v.version_type
4063: INTO l_ar_plan_type_id, l_ar_version_type
4064: FROM pa_proj_fp_options o
4065: , pa_budget_versions v
4066: WHERE o.fin_plan_version_id = v.budget_version_id
4067: AND v.approved_rev_plan_type_flag = 'Y'
4068: AND v.current_flag = 'Y'
4069: AND v.project_id = p_project_id;

Line 4155: FROM pa_budget_versions pbv,

4151: SELECT 1
4152: INTO dummy
4153: FROM dual
4154: WHERE EXISTS( SELECT 1
4155: FROM pa_budget_versions pbv,
4156: pa_resource_lists prl
4157: WHERE (pbv.budget_type_code = 'AR' OR -- old model
4158: pbv.budget_type_code IS NULL AND
4159: approved_rev_plan_type_flag = 'Y') -- new model