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 2131: from pa_budget_versions

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

Line 2562: update pa_budget_versions v

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

Line 2859: from pa_budget_versions

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

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

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

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

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

Line 3134: FROM pa_budget_versions bv

3130:
3131: begin
3132: SELECT budget_version_id
3133: INTO l_CC_Budget_Version_id
3134: FROM pa_budget_versions bv
3135: WHERE project_id = p_project_id
3136: AND BUDGET_STATUS_CODE = 'S'
3137: AND budget_type_code =
3138: (SELECT budget_type_code

Line 3257: FROM pa_budget_versions

3253: -- Get the baselined budget version for the draft
3254:
3255: SELECT budget_type_code
3256: INTO l_budget_type_code
3257: FROM pa_budget_versions
3258: WHERE budget_version_id = p_draft_version_id
3259: AND budget_status_code = 'S';
3260:
3261: SELECT budget_version_id, version_number

Line 3263: FROM pa_budget_versions

3259: AND budget_status_code = 'S';
3260:
3261: SELECT budget_version_id, version_number
3262: INTo l_baseline_version_id, l_baseline_version_number
3263: FROM pa_budget_versions
3264: WHERE budget_type_code = l_budget_type_code
3265: AND project_id = p_project_id
3266: AND budget_status_code = 'B'
3267: AND current_flag = 'Y';

Line 3304: FROM pa_budget_versions pb

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

Line 3391: from pa_budget_versions

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

Line 3399: FROM pa_budget_versions

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

Line 3408: FROM pa_budget_versions pb

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

Line 3568: from pa_budget_versions

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

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

3793: , x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
3794: )
3795: IS
3796:
3797: l_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE := NULL;
3798: l_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE := NULL;
3799:
3800:
3801: BEGIN

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

3794: )
3795: IS
3796:
3797: l_cost_flag pa_budget_versions.approved_cost_plan_type_flag%TYPE := NULL;
3798: l_rev_flag pa_budget_versions.approved_rev_plan_type_flag%TYPE := NULL;
3799:
3800:
3801: BEGIN
3802:

Line 3811: FROM pa_budget_versions b

3807:
3808:
3809: SELECT b.approved_cost_plan_type_flag, b.approved_rev_plan_type_flag
3810: INTO l_cost_flag, l_rev_flag
3811: FROM pa_budget_versions b
3812: WHERE b.budget_version_id = p_budget_version_id;
3813:
3814:
3815: IF ( nvl(l_cost_flag,'N') = 'Y'

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

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

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

3988:
3989: l_ac_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3990: l_ar_plan_type_id pa_proj_fp_options.fin_plan_type_id%TYPE := NULL;
3991: l_ac_version_type pa_budget_versions.version_type%TYPE := NULL;
3992: l_ar_version_type pa_budget_versions.version_type%TYPE := NULL;
3993:
3994: l_dummy VARCHAR2(1) := 'N';
3995:
3996:

Line 4017: from pa_budget_versions v

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

Line 4049: , pa_budget_versions v

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

Line 4069: , pa_budget_versions v

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

Line 4159: FROM pa_budget_versions pbv,

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