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.

[Home] [Help]

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:
804: /* Added this new function as part of the changes done for View Plan Enhancement 7514054 */
805:
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 976: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,

972: -- 12/26/02 dlai added two new conditions:
973: -- p_period_number=0 --> preceding_periods_amount
974: -- p_period_number=14 --> succeeding_periods_amount
975: function get_period_n_value
976: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
977: p_budget_version_id IN pa_budget_versions.budget_version_id%TYPE,
978: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
979: p_project_currency_type IN VARCHAR2,
980: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,

Line 1047: from pa_proj_period_profiles pppp,

1043: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1044: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1045: null))
1046: into l_return_value
1047: from pa_proj_period_profiles pppp,
1048: pa_proj_periods_denorm pppd
1049: where pppp.period_profile_id = p_period_profile_id and
1050: pppp.period_profile_id=pppd.period_profile_id and
1051: pppd.budget_version_id = p_budget_version_id and

Line 1114: from pa_proj_period_profiles pppp,

1110: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1111: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1112: null))
1113: into l_return_value
1114: from pa_proj_period_profiles pppp,
1115: pa_proj_periods_denorm pppd
1116: where pppp.period_profile_id = p_period_profile_id and
1117: pppp.period_profile_id=pppd.period_profile_id and
1118: pppd.budget_version_id = p_budget_version_id and

Line 1181: from pa_proj_period_profiles pppp,

1177: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1178: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1179: null))
1180: into l_return_value
1181: from pa_proj_period_profiles pppp,
1182: pa_proj_periods_denorm pppd
1183: where pppp.period_profile_id = p_period_profile_id and
1184: pppp.period_profile_id=pppd.period_profile_id and
1185: pppd.budget_version_id = p_budget_version_id and

Line 1248: from pa_proj_period_profiles pppp,

1244: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1245: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1246: null))
1247: into l_return_value
1248: from pa_proj_period_profiles pppp,
1249: pa_proj_periods_denorm pppd
1250: where pppp.period_profile_id = p_period_profile_id and
1251: pppp.period_profile_id=pppd.period_profile_id and
1252: pppd.budget_version_id = p_budget_version_id and

Line 1315: from pa_proj_period_profiles pppp,

1311: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1312: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1313: null))
1314: into l_return_value
1315: from pa_proj_period_profiles pppp,
1316: pa_proj_periods_denorm pppd
1317: where pppp.period_profile_id = p_period_profile_id and
1318: pppp.period_profile_id=pppd.period_profile_id and
1319: pppd.budget_version_id = p_budget_version_id and

Line 1382: from pa_proj_period_profiles pppp,

1378: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1379: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1380: null))
1381: into l_return_value
1382: from pa_proj_period_profiles pppp,
1383: pa_proj_periods_denorm pppd
1384: where pppp.period_profile_id = p_period_profile_id and
1385: pppp.period_profile_id=pppd.period_profile_id and
1386: pppd.budget_version_id = p_budget_version_id and

Line 1449: from pa_proj_period_profiles pppp,

1445: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1446: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1447: null))
1448: into l_return_value
1449: from pa_proj_period_profiles pppp,
1450: pa_proj_periods_denorm pppd
1451: where pppp.period_profile_id = p_period_profile_id and
1452: pppp.period_profile_id=pppd.period_profile_id and
1453: pppd.budget_version_id = p_budget_version_id and

Line 1516: from pa_proj_period_profiles pppp,

1512: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1513: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1514: null))
1515: into l_return_value
1516: from pa_proj_period_profiles pppp,
1517: pa_proj_periods_denorm pppd
1518: where pppp.period_profile_id = p_period_profile_id and
1519: pppp.period_profile_id=pppd.period_profile_id and
1520: pppd.budget_version_id = p_budget_version_id and

Line 1583: from pa_proj_period_profiles pppp,

1579: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1580: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1581: null))
1582: into l_return_value
1583: from pa_proj_period_profiles pppp,
1584: pa_proj_periods_denorm pppd
1585: where pppp.period_profile_id = p_period_profile_id and
1586: pppp.period_profile_id=pppd.period_profile_id and
1587: pppd.budget_version_id = p_budget_version_id and

Line 1650: from pa_proj_period_profiles pppp,

1646: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1647: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1648: null))
1649: into l_return_value
1650: from pa_proj_period_profiles pppp,
1651: pa_proj_periods_denorm pppd
1652: where pppp.period_profile_id = p_period_profile_id and
1653: pppp.period_profile_id=pppd.period_profile_id and
1654: pppd.budget_version_id = p_budget_version_id and

Line 1717: from pa_proj_period_profiles pppp,

1713: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1714: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1715: null))
1716: into l_return_value
1717: from pa_proj_period_profiles pppp,
1718: pa_proj_periods_denorm pppd
1719: where pppp.period_profile_id = p_period_profile_id and
1720: pppp.period_profile_id=pppd.period_profile_id and
1721: pppd.budget_version_id = p_budget_version_id and

Line 1784: from pa_proj_period_profiles pppp,

1780: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1781: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1782: null))
1783: into l_return_value
1784: from pa_proj_period_profiles pppp,
1785: pa_proj_periods_denorm pppd
1786: where pppp.period_profile_id = p_period_profile_id and
1787: pppp.period_profile_id=pppd.period_profile_id and
1788: pppd.budget_version_id = p_budget_version_id and

Line 1851: from pa_proj_period_profiles pppp,

1847: pppp.period51_start_Date, nvl(pppd.period_amount51,0),
1848: pppp.period52_start_Date, nvl(pppd.period_amount52,0),
1849: null))
1850: into l_return_value
1851: from pa_proj_period_profiles pppp,
1852: pa_proj_periods_denorm pppd
1853: where pppp.period_profile_id = p_period_profile_id and
1854: pppp.period_profile_id=pppd.period_profile_id and
1855: pppd.budget_version_id = p_budget_version_id and

Line 1864: from pa_proj_period_profiles pppp,

1860: --group by pppd.amount_subtype_id;
1861: elsif p_period_number = 0 then
1862: select SUM(nvl(pppd.preceding_periods_amount,0))
1863: into l_return_value
1864: from pa_proj_period_profiles pppp,
1865: pa_proj_periods_denorm pppd
1866: where pppp.period_profile_id = p_period_profile_id and
1867: pppp.period_profile_id=pppd.period_profile_id and
1868: pppd.budget_version_id = p_budget_version_id and

Line 1877: from pa_proj_period_profiles pppp,

1873: --group by pppd.amount_subtype_id;
1874: elsif p_period_number = 14 then
1875: select SUM(nvl(pppd.succeeding_periods_amount,0))
1876: into l_return_value
1877: from pa_proj_period_profiles pppp,
1878: pa_proj_periods_denorm pppd
1879: where pppp.period_profile_id = p_period_profile_id and
1880: pppp.period_profile_id=pppd.period_profile_id and
1881: pppd.budget_version_id = p_budget_version_id and

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

1909: /* THIS IMPLEMENTATION IS INCORRECT BECAUSE WE'RE TRYING TO INCORPORATE
1910: * ORG FORECASTING VALUES
1911:
1912: function get_period_n_value
1913: (p_period_profile_id IN pa_proj_period_profiles.period_profile_id%TYPE,
1914: p_resource_assignment_id IN pa_proj_periods_denorm.resource_assignment_id%TYPE,
1915: p_project_currency_type IN VARCHAR2,
1916: p_amount_type_id IN pa_proj_periods_denorm.amount_type_id%TYPE,
1917: p_period_number IN NUMBER) return NUMBER

Line 2139: from pa_proj_period_profiles pppp,

2135: 185, -pppd.period_amount52,
2136: 120, -pppd.period_amount52,
2137: pppd.period_amount52),0))
2138: into l_return_value
2139: from pa_proj_period_profiles pppp,
2140: pa_proj_periods_denorm pppd
2141: where pppp.period_profile_id = p_period_profile_id and
2142: pppp.period_profile_id=pppd.period_profile_id and
2143: pppd.amount_type_id = p_amount_type_id and

Line 2359: from pa_proj_period_profiles pppp,

2355: 185, -pppd.period_amount52,
2356: 120, -pppd.period_amount52,
2357: pppd.period_amount52),0))
2358: into l_return_value
2359: from pa_proj_period_profiles pppp,
2360: pa_proj_periods_denorm pppd
2361: where pppp.period_profile_id = p_period_profile_id and
2362: pppp.period_profile_id=pppd.period_profile_id and
2363: pppd.amount_type_id = p_amount_type_id and

Line 2579: from pa_proj_period_profiles pppp,

2575: 185, -pppd.period_amount52,
2576: 120, -pppd.period_amount52,
2577: pppd.period_amount52),0))
2578: into l_return_value
2579: from pa_proj_period_profiles pppp,
2580: pa_proj_periods_denorm pppd
2581: where pppp.period_profile_id = p_period_profile_id and
2582: pppp.period_profile_id=pppd.period_profile_id and
2583: pppd.amount_type_id = p_amount_type_id and

Line 2799: from pa_proj_period_profiles pppp,

2795: 185, -pppd.period_amount52,
2796: 120, -pppd.period_amount52,
2797: pppd.period_amount52),0))
2798: into l_return_value
2799: from pa_proj_period_profiles pppp,
2800: pa_proj_periods_denorm pppd
2801: where pppp.period_profile_id = p_period_profile_id and
2802: pppp.period_profile_id=pppd.period_profile_id and
2803: pppd.amount_type_id = p_amount_type_id and

Line 3019: from pa_proj_period_profiles pppp,

3015: 185, -pppd.period_amount52,
3016: 120, -pppd.period_amount52,
3017: pppd.period_amount52),0))
3018: into l_return_value
3019: from pa_proj_period_profiles pppp,
3020: pa_proj_periods_denorm pppd
3021: where pppp.period_profile_id = p_period_profile_id and
3022: pppp.period_profile_id=pppd.period_profile_id and
3023: pppd.amount_type_id = p_amount_type_id and

Line 3239: from pa_proj_period_profiles pppp,

3235: 185, -pppd.period_amount52,
3236: 120, -pppd.period_amount52,
3237: pppd.period_amount52),0))
3238: into l_return_value
3239: from pa_proj_period_profiles pppp,
3240: pa_proj_periods_denorm pppd
3241: where pppp.period_profile_id = p_period_profile_id and
3242: pppp.period_profile_id=pppd.period_profile_id and
3243: pppd.amount_type_id = p_amount_type_id and

Line 3459: from pa_proj_period_profiles pppp,

3455: 185, -pppd.period_amount52,
3456: 120, -pppd.period_amount52,
3457: pppd.period_amount52),0))
3458: into l_return_value
3459: from pa_proj_period_profiles pppp,
3460: pa_proj_periods_denorm pppd
3461: where pppp.period_profile_id = p_period_profile_id and
3462: pppp.period_profile_id=pppd.period_profile_id and
3463: pppd.amount_type_id = p_amount_type_id and

Line 3679: from pa_proj_period_profiles pppp,

3675: 185, -pppd.period_amount52,
3676: 120, -pppd.period_amount52,
3677: pppd.period_amount52),0))
3678: into l_return_value
3679: from pa_proj_period_profiles pppp,
3680: pa_proj_periods_denorm pppd
3681: where pppp.period_profile_id = p_period_profile_id and
3682: pppp.period_profile_id=pppd.period_profile_id and
3683: pppd.amount_type_id = p_amount_type_id and

Line 3899: from pa_proj_period_profiles pppp,

3895: 185, -pppd.period_amount52,
3896: 120, -pppd.period_amount52,
3897: pppd.period_amount52),0))
3898: into l_return_value
3899: from pa_proj_period_profiles pppp,
3900: pa_proj_periods_denorm pppd
3901: where pppp.period_profile_id = p_period_profile_id and
3902: pppp.period_profile_id=pppd.period_profile_id and
3903: pppd.amount_type_id = p_amount_type_id and

Line 4119: from pa_proj_period_profiles pppp,

4115: 185, -pppd.period_amount52,
4116: 120, -pppd.period_amount52,
4117: pppd.period_amount52),0))
4118: into l_return_value
4119: from pa_proj_period_profiles pppp,
4120: pa_proj_periods_denorm pppd
4121: where pppp.period_profile_id = p_period_profile_id and
4122: pppp.period_profile_id=pppd.period_profile_id and
4123: pppd.amount_type_id = p_amount_type_id and

Line 4339: from pa_proj_period_profiles pppp,

4335: 185, -pppd.period_amount52,
4336: 120, -pppd.period_amount52,
4337: pppd.period_amount52),0))
4338: into l_return_value
4339: from pa_proj_period_profiles pppp,
4340: pa_proj_periods_denorm pppd
4341: where pppp.period_profile_id = p_period_profile_id and
4342: pppp.period_profile_id=pppd.period_profile_id and
4343: pppd.amount_type_id = p_amount_type_id and

Line 4559: from pa_proj_period_profiles pppp,

4555: 185, -pppd.period_amount52,
4556: 120, -pppd.period_amount52,
4557: pppd.period_amount52),0))
4558: into l_return_value
4559: from pa_proj_period_profiles pppp,
4560: pa_proj_periods_denorm pppd
4561: where pppp.period_profile_id = p_period_profile_id and
4562: pppp.period_profile_id=pppd.period_profile_id and
4563: pppd.amount_type_id = p_amount_type_id and

Line 4779: from pa_proj_period_profiles pppp,

4775: 185, -pppd.period_amount52,
4776: 120, -pppd.period_amount52,
4777: pppd.period_amount52),0))
4778: into l_return_value
4779: from pa_proj_period_profiles pppp,
4780: pa_proj_periods_denorm pppd
4781: where pppp.period_profile_id = p_period_profile_id and
4782: pppp.period_profile_id=pppd.period_profile_id and
4783: pppd.amount_type_id = p_amount_type_id and

Line 4821: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

4817: x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
4818: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4819: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4820: is
4821: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4822: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4823: l_rpt_request_id NUMBER;
4824: x_conc_req_id NUMBER;
4825:

Line 4822: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;

4818: x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
4819: x_msg_data OUT NOCOPY VARCHAR2) --File.Sql.39 bug 4440895
4820: is
4821: l_gl_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4822: l_pa_pd_profile_id pa_proj_period_profiles.period_profile_id%TYPE;
4823: l_rpt_request_id NUMBER;
4824: x_conc_req_id NUMBER;
4825:
4826: -- error-handling variables

Line 4831: from pa_proj_period_profiles

4827: l_debug_mode VARCHAR2(1) := 'Y';
4828:
4829: cursor GL_ppId is
4830: select period_profile_id
4831: from pa_proj_period_profiles
4832: where project_id = p_project_id and
4833: plan_period_type = 'GL' and
4834: current_flag ='Y';
4835: GL_ppId_rec GL_ppId%ROWTYPE;

Line 4839: from pa_proj_period_profiles

4835: GL_ppId_rec GL_ppId%ROWTYPE;
4836:
4837: cursor PA_ppId is
4838: select period_profile_id
4839: from pa_proj_period_profiles
4840: where project_id = p_project_id and
4841: plan_period_type = 'PA' and
4842: current_flag ='Y';
4843: PA_ppId_rec GL_ppId%ROWTYPE;