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_FP_VIEW_PLANS_UTIL dependencies on PA_PROJ_PERIOD_PROFILES

Line 168: (p_period_profile_id1 IN pa_proj_period_profiles.period_profile_id%TYPE,

164: -- 2. They have different period_profile_id's, but have the same
165: -- period type (PA or GL), span the same number of periods, and begin on the
166: -- same date.
167: FUNCTION check_compatible_pd_profiles
168: (p_period_profile_id1 IN pa_proj_period_profiles.period_profile_id%TYPE,
169: p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)
170: return VARCHAR2
171: is
172: l_return_value VARCHAR2(1);

Line 169: p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)

165: -- period type (PA or GL), span the same number of periods, and begin on the
166: -- same date.
167: FUNCTION check_compatible_pd_profiles
168: (p_period_profile_id1 IN pa_proj_period_profiles.period_profile_id%TYPE,
169: p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)
170: return VARCHAR2
171: is
172: l_return_value VARCHAR2(1);
173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;

Line 173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;

169: p_period_profile_id2 IN pa_proj_period_profiles.period_profile_id%TYPE)
170: return VARCHAR2
171: is
172: l_return_value VARCHAR2(1);
173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;
174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;

Line 174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;

170: return VARCHAR2
171: is
172: l_return_value VARCHAR2(1);
173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;
174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;
178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;

Line 175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;

171: is
172: l_return_value VARCHAR2(1);
173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;
174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;
178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;
179: begin

Line 176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;

172: l_return_value VARCHAR2(1);
173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;
174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;
178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;
179: begin
180: if (p_period_profile_id1 is null) or (p_period_profile_id2 is null) then return 'N';

Line 177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;

173: l_plan_period_type1 pa_proj_period_profiles.plan_period_type%TYPE;
174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;
178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;
179: begin
180: if (p_period_profile_id1 is null) or (p_period_profile_id2 is null) then return 'N';
181: elsif p_period_profile_id1 = p_period_profile_id2 then return 'Y';

Line 178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;

174: l_plan_period_type2 pa_proj_period_profiles.plan_period_type%TYPE;
175: l_number_of_periods1 pa_proj_period_profiles.number_of_periods%TYPE;
176: l_number_of_periods2 pa_proj_period_profiles.number_of_periods%TYPE;
177: l_plan_start_date1 pa_proj_period_profiles.period1_start_date%TYPE;
178: l_plan_start_date2 pa_proj_period_profiles.period1_start_date%TYPE;
179: begin
180: if (p_period_profile_id1 is null) or (p_period_profile_id2 is null) then return 'N';
181: elsif p_period_profile_id1 = p_period_profile_id2 then return 'Y';
182: else

Line 190: from pa_proj_period_profiles

186: period1_start_date
187: into l_plan_period_type1,
188: l_number_of_periods1,
189: l_plan_start_date1
190: from pa_proj_period_profiles
191: where period_profile_id = p_period_profile_id1;
192: select plan_period_type,
193: number_of_periods,
194: period1_start_date

Line 198: from pa_proj_period_profiles

194: period1_start_date
195: into l_plan_period_type2,
196: l_number_of_periods2,
197: l_plan_start_date2
198: from pa_proj_period_profiles
199: where period_profile_id = p_period_profile_id2;
200: if (l_plan_period_type1 = l_plan_period_type2) and
201: (l_number_of_periods1 = l_number_of_periods2) and
202: (l_plan_start_date1 = l_plan_start_date2) then

Line 807: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,

803: -- 12/26/02 dlai added two new conditions:
804: -- p_period_number=0 --> preceding_periods_amount
805: -- p_period_number=14 --> succeeding_periods_amount
806: function get_period_n_value
807: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
808: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
809: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
810: p_project_currency_type IN VARCHAR2,
811: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

Line 878: from pa_proj_period_profiles pppp,

874: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
875: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
876: null))
877: into l_return_value
878: from pa_proj_period_profiles pppp,
879: pa_proj_periods_denorm pppd
880: where pppp.period_profile_id = p_period_profile_id and
881: pppp.period_profile_id=pppd.period_profile_id and
882: pppd.budget_version_id = p_budget_version_id and

Line 945: from pa_proj_period_profiles pppp,

941: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
942: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
943: null))
944: into l_return_value
945: from pa_proj_period_profiles pppp,
946: pa_proj_periods_denorm pppd
947: where pppp.period_profile_id = p_period_profile_id and
948: pppp.period_profile_id=pppd.period_profile_id and
949: pppd.budget_version_id = p_budget_version_id and

Line 1012: from pa_proj_period_profiles pppp,

1008: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1009: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1010: null))
1011: into l_return_value
1012: from pa_proj_period_profiles pppp,
1013: pa_proj_periods_denorm pppd
1014: where pppp.period_profile_id = p_period_profile_id and
1015: pppp.period_profile_id=pppd.period_profile_id and
1016: pppd.budget_version_id = p_budget_version_id and

Line 1079: from pa_proj_period_profiles pppp,

1075: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1076: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1077: null))
1078: into l_return_value
1079: from pa_proj_period_profiles pppp,
1080: pa_proj_periods_denorm pppd
1081: where pppp.period_profile_id = p_period_profile_id and
1082: pppp.period_profile_id=pppd.period_profile_id and
1083: pppd.budget_version_id = p_budget_version_id and

Line 1146: from pa_proj_period_profiles pppp,

1142: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1143: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1144: null))
1145: into l_return_value
1146: from pa_proj_period_profiles pppp,
1147: pa_proj_periods_denorm pppd
1148: where pppp.period_profile_id = p_period_profile_id and
1149: pppp.period_profile_id=pppd.period_profile_id and
1150: pppd.budget_version_id = p_budget_version_id and

Line 1213: from pa_proj_period_profiles pppp,

1209: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1210: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1211: null))
1212: into l_return_value
1213: from pa_proj_period_profiles pppp,
1214: pa_proj_periods_denorm pppd
1215: where pppp.period_profile_id = p_period_profile_id and
1216: pppp.period_profile_id=pppd.period_profile_id and
1217: pppd.budget_version_id = p_budget_version_id and

Line 1280: from pa_proj_period_profiles pppp,

1276: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1277: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1278: null))
1279: into l_return_value
1280: from pa_proj_period_profiles pppp,
1281: pa_proj_periods_denorm pppd
1282: where pppp.period_profile_id = p_period_profile_id and
1283: pppp.period_profile_id=pppd.period_profile_id and
1284: pppd.budget_version_id = p_budget_version_id and

Line 1347: from pa_proj_period_profiles pppp,

1343: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1344: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1345: null))
1346: into l_return_value
1347: from pa_proj_period_profiles pppp,
1348: pa_proj_periods_denorm pppd
1349: where pppp.period_profile_id = p_period_profile_id and
1350: pppp.period_profile_id=pppd.period_profile_id and
1351: pppd.budget_version_id = p_budget_version_id and

Line 1414: from pa_proj_period_profiles pppp,

1410: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1411: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1412: null))
1413: into l_return_value
1414: from pa_proj_period_profiles pppp,
1415: pa_proj_periods_denorm pppd
1416: where pppp.period_profile_id = p_period_profile_id and
1417: pppp.period_profile_id=pppd.period_profile_id and
1418: pppd.budget_version_id = p_budget_version_id and

Line 1481: from pa_proj_period_profiles pppp,

1477: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1478: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1479: null))
1480: into l_return_value
1481: from pa_proj_period_profiles pppp,
1482: pa_proj_periods_denorm pppd
1483: where pppp.period_profile_id = p_period_profile_id and
1484: pppp.period_profile_id=pppd.period_profile_id and
1485: pppd.budget_version_id = p_budget_version_id and

Line 1548: from pa_proj_period_profiles pppp,

1544: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1545: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1546: null))
1547: into l_return_value
1548: from pa_proj_period_profiles pppp,
1549: pa_proj_periods_denorm pppd
1550: where pppp.period_profile_id = p_period_profile_id and
1551: pppp.period_profile_id=pppd.period_profile_id and
1552: pppd.budget_version_id = p_budget_version_id and

Line 1615: from pa_proj_period_profiles pppp,

1611: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1612: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1613: null))
1614: into l_return_value
1615: from pa_proj_period_profiles pppp,
1616: pa_proj_periods_denorm pppd
1617: where pppp.period_profile_id = p_period_profile_id and
1618: pppp.period_profile_id=pppd.period_profile_id and
1619: pppd.budget_version_id = p_budget_version_id and

Line 1682: from pa_proj_period_profiles pppp,

1678: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1679: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1680: null))
1681: into l_return_value
1682: from pa_proj_period_profiles pppp,
1683: pa_proj_periods_denorm pppd
1684: where pppp.period_profile_id = p_period_profile_id and
1685: pppp.period_profile_id=pppd.period_profile_id and
1686: pppd.budget_version_id = p_budget_version_id and

Line 1695: from pa_proj_period_profiles pppp,

1691: --group by pppd.amount_subtype_id;
1692: elsif p_period_number = 0 then
1693: select SUM(nvl(pppd.preceding_periods_amount,0))
1694: into l_return_value
1695: from pa_proj_period_profiles pppp,
1696: pa_proj_periods_denorm pppd
1697: where pppp.period_profile_id = p_period_profile_id and
1698: pppp.period_profile_id=pppd.period_profile_id and
1699: pppd.budget_version_id = p_budget_version_id and

Line 1708: from pa_proj_period_profiles pppp,

1704: --group by pppd.amount_subtype_id;
1705: elsif p_period_number = 14 then
1706: select SUM(nvl(pppd.succeeding_periods_amount,0))
1707: into l_return_value
1708: from pa_proj_period_profiles pppp,
1709: pa_proj_periods_denorm pppd
1710: where pppp.period_profile_id = p_period_profile_id and
1711: pppp.period_profile_id=pppd.period_profile_id and
1712: pppd.budget_version_id = p_budget_version_id and

Line 1743: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,

1739: /* THIS IMPLEMENTATION IS INCORRECT BECAUSE WE'RE TRYING TO INCORPORATE
1740: * ORG FORECASTING VALUES
1741:
1742: function get_period_n_value
1743: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1744: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1745: p_project_currency_type IN VARCHAR2,
1746: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1747: p_period_number IN NUMBER) return NUMBER

Line 1969: from pa_proj_period_profiles pppp,

1965: 185, -pppd.period_amount52,
1966: 120, -pppd.period_amount52,
1967: pppd.period_amount52),0))
1968: into l_return_value
1969: from pa_proj_period_profiles pppp,
1970: pa_proj_periods_denorm pppd
1971: where pppp.period_profile_id = p_period_profile_id and
1972: pppp.period_profile_id=pppd.period_profile_id and
1973: pppd.amount_type_id = p_amount_type_id and

Line 2189: from pa_proj_period_profiles pppp,

2185: 185, -pppd.period_amount52,
2186: 120, -pppd.period_amount52,
2187: pppd.period_amount52),0))
2188: into l_return_value
2189: from pa_proj_period_profiles pppp,
2190: pa_proj_periods_denorm pppd
2191: where pppp.period_profile_id = p_period_profile_id and
2192: pppp.period_profile_id=pppd.period_profile_id and
2193: pppd.amount_type_id = p_amount_type_id and

Line 2409: from pa_proj_period_profiles pppp,

2405: 185, -pppd.period_amount52,
2406: 120, -pppd.period_amount52,
2407: pppd.period_amount52),0))
2408: into l_return_value
2409: from pa_proj_period_profiles pppp,
2410: pa_proj_periods_denorm pppd
2411: where pppp.period_profile_id = p_period_profile_id and
2412: pppp.period_profile_id=pppd.period_profile_id and
2413: pppd.amount_type_id = p_amount_type_id and

Line 2629: from pa_proj_period_profiles pppp,

2625: 185, -pppd.period_amount52,
2626: 120, -pppd.period_amount52,
2627: pppd.period_amount52),0))
2628: into l_return_value
2629: from pa_proj_period_profiles pppp,
2630: pa_proj_periods_denorm pppd
2631: where pppp.period_profile_id = p_period_profile_id and
2632: pppp.period_profile_id=pppd.period_profile_id and
2633: pppd.amount_type_id = p_amount_type_id and

Line 2849: from pa_proj_period_profiles pppp,

2845: 185, -pppd.period_amount52,
2846: 120, -pppd.period_amount52,
2847: pppd.period_amount52),0))
2848: into l_return_value
2849: from pa_proj_period_profiles pppp,
2850: pa_proj_periods_denorm pppd
2851: where pppp.period_profile_id = p_period_profile_id and
2852: pppp.period_profile_id=pppd.period_profile_id and
2853: pppd.amount_type_id = p_amount_type_id and

Line 3069: from pa_proj_period_profiles pppp,

3065: 185, -pppd.period_amount52,
3066: 120, -pppd.period_amount52,
3067: pppd.period_amount52),0))
3068: into l_return_value
3069: from pa_proj_period_profiles pppp,
3070: pa_proj_periods_denorm pppd
3071: where pppp.period_profile_id = p_period_profile_id and
3072: pppp.period_profile_id=pppd.period_profile_id and
3073: pppd.amount_type_id = p_amount_type_id and

Line 3289: from pa_proj_period_profiles pppp,

3285: 185, -pppd.period_amount52,
3286: 120, -pppd.period_amount52,
3287: pppd.period_amount52),0))
3288: into l_return_value
3289: from pa_proj_period_profiles pppp,
3290: pa_proj_periods_denorm pppd
3291: where pppp.period_profile_id = p_period_profile_id and
3292: pppp.period_profile_id=pppd.period_profile_id and
3293: pppd.amount_type_id = p_amount_type_id and

Line 3509: from pa_proj_period_profiles pppp,

3505: 185, -pppd.period_amount52,
3506: 120, -pppd.period_amount52,
3507: pppd.period_amount52),0))
3508: into l_return_value
3509: from pa_proj_period_profiles pppp,
3510: pa_proj_periods_denorm pppd
3511: where pppp.period_profile_id = p_period_profile_id and
3512: pppp.period_profile_id=pppd.period_profile_id and
3513: pppd.amount_type_id = p_amount_type_id and

Line 3729: from pa_proj_period_profiles pppp,

3725: 185, -pppd.period_amount52,
3726: 120, -pppd.period_amount52,
3727: pppd.period_amount52),0))
3728: into l_return_value
3729: from pa_proj_period_profiles pppp,
3730: pa_proj_periods_denorm pppd
3731: where pppp.period_profile_id = p_period_profile_id and
3732: pppp.period_profile_id=pppd.period_profile_id and
3733: pppd.amount_type_id = p_amount_type_id and

Line 3949: from pa_proj_period_profiles pppp,

3945: 185, -pppd.period_amount52,
3946: 120, -pppd.period_amount52,
3947: pppd.period_amount52),0))
3948: into l_return_value
3949: from pa_proj_period_profiles pppp,
3950: pa_proj_periods_denorm pppd
3951: where pppp.period_profile_id = p_period_profile_id and
3952: pppp.period_profile_id=pppd.period_profile_id and
3953: pppd.amount_type_id = p_amount_type_id and

Line 4169: from pa_proj_period_profiles pppp,

4165: 185, -pppd.period_amount52,
4166: 120, -pppd.period_amount52,
4167: pppd.period_amount52),0))
4168: into l_return_value
4169: from pa_proj_period_profiles pppp,
4170: pa_proj_periods_denorm pppd
4171: where pppp.period_profile_id = p_period_profile_id and
4172: pppp.period_profile_id=pppd.period_profile_id and
4173: pppd.amount_type_id = p_amount_type_id and

Line 4389: from pa_proj_period_profiles pppp,

4385: 185, -pppd.period_amount52,
4386: 120, -pppd.period_amount52,
4387: pppd.period_amount52),0))
4388: into l_return_value
4389: from pa_proj_period_profiles pppp,
4390: pa_proj_periods_denorm pppd
4391: where pppp.period_profile_id = p_period_profile_id and
4392: pppp.period_profile_id=pppd.period_profile_id and
4393: pppd.amount_type_id = p_amount_type_id and

Line 4609: from pa_proj_period_profiles pppp,

4605: 185, -pppd.period_amount52,
4606: 120, -pppd.period_amount52,
4607: pppd.period_amount52),0))
4608: into l_return_value
4609: from pa_proj_period_profiles pppp,
4610: pa_proj_periods_denorm pppd
4611: where pppp.period_profile_id = p_period_profile_id and
4612: pppp.period_profile_id=pppd.period_profile_id and
4613: pppd.amount_type_id = p_amount_type_id and

Line 4651: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

4647: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4649: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4650: is
4651: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4652: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4653: l_rpt_request_id NUMBER;
4654: x_conc_req_id NUMBER;
4655:

Line 4652: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

4648: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4649: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4650: is
4651: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4652: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4653: l_rpt_request_id NUMBER;
4654: x_conc_req_id NUMBER;
4655:
4656: -- error-handling variables

Line 4661: from pa_proj_period_profiles

4657: l_debug_mode VARCHAR2(1) := 'Y';
4658:
4659: cursor GL_ppId is
4660: select period_profile_id
4661: from pa_proj_period_profiles
4662: where project_id = p_project_id and
4663: plan_period_type = 'GL' and
4664: current_flag ='Y';
4665: GL_ppId_rec GL_ppId%ROWTYPE;

Line 4669: from pa_proj_period_profiles

4665: GL_ppId_rec GL_ppId%ROWTYPE;
4666:
4667: cursor PA_ppId is
4668: select period_profile_id
4669: from pa_proj_period_profiles
4670: where project_id = p_project_id and
4671: plan_period_type = 'PA' and
4672: current_flag ='Y';
4673: PA_ppId_rec GL_ppId%ROWTYPE;