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.PQH_MGMT_RPT_PKG dependencies on PQH_BUDGET

Line 65: SELECT pqh_budget.get_currency_cd(bvr.budget_id) CURRENCY_CODE

61: FUNCTION get_currency_cd(p_budget_version_id number) return varchar2 is
62: l_proc varchar2(72) := g_package||'get_currency_cd';
63: l_currency_cd varchar2(30);
64: cursor csr_bdgt(p_budget_version_id number) is
65: SELECT pqh_budget.get_currency_cd(bvr.budget_id) CURRENCY_CODE
66: FROM pqh_budget_versions bvr
67: WHERE bvr.budget_version_id = p_budget_version_id;
68: begin
69: hr_utility.set_location('Entering:'||l_proc, 5);

Line 66: FROM pqh_budget_versions bvr

62: l_proc varchar2(72) := g_package||'get_currency_cd';
63: l_currency_cd varchar2(30);
64: cursor csr_bdgt(p_budget_version_id number) is
65: SELECT pqh_budget.get_currency_cd(bvr.budget_id) CURRENCY_CODE
66: FROM pqh_budget_versions bvr
67: WHERE bvr.budget_version_id = p_budget_version_id;
68: begin
69: hr_utility.set_location('Entering:'||l_proc, 5);
70: open csr_bdgt(p_budget_version_id);

Line 79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

75: end;
76: ---------------------------------------------------------------------------------------------------------
77: FUNCTION get_posn_bdgt
78: (
79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_start_date IN pqh_budgets.budget_start_date%TYPE,
81: p_end_date IN pqh_budgets.budget_end_date%TYPE,
82: p_position_id IN per_positions.position_id%TYPE,
83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 80: p_start_date IN pqh_budgets.budget_start_date%TYPE,

76: ---------------------------------------------------------------------------------------------------------
77: FUNCTION get_posn_bdgt
78: (
79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_start_date IN pqh_budgets.budget_start_date%TYPE,
81: p_end_date IN pqh_budgets.budget_end_date%TYPE,
82: p_position_id IN per_positions.position_id%TYPE,
83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
84: )

Line 81: p_end_date IN pqh_budgets.budget_end_date%TYPE,

77: FUNCTION get_posn_bdgt
78: (
79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_start_date IN pqh_budgets.budget_start_date%TYPE,
81: p_end_date IN pqh_budgets.budget_end_date%TYPE,
82: p_position_id IN per_positions.position_id%TYPE,
83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
84: )
85: RETURN NUMBER IS

Line 83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_start_date IN pqh_budgets.budget_start_date%TYPE,
81: p_end_date IN pqh_budgets.budget_end_date%TYPE,
82: p_position_id IN per_positions.position_id%TYPE,
83: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
84: )
85: RETURN NUMBER IS
86: /*
87: This is a private function which will get the budgeted amount for a position given a

Line 99: pqh_budgets bgt,

95:
96: CURSOR csr_posn_bdgt_unit1 IS
97: SELECT bdt.budget_unit1_value
98: FROM
99: pqh_budgets bgt,
100: pqh_budget_versions bvr,
101: pqh_budget_details bdt
102: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
103: pqh_budget_periods bpr,

Line 100: pqh_budget_versions bvr,

96: CURSOR csr_posn_bdgt_unit1 IS
97: SELECT bdt.budget_unit1_value
98: FROM
99: pqh_budgets bgt,
100: pqh_budget_versions bvr,
101: pqh_budget_details bdt
102: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
103: pqh_budget_periods bpr,
104: per_time_periods ptps,

Line 101: pqh_budget_details bdt

97: SELECT bdt.budget_unit1_value
98: FROM
99: pqh_budgets bgt,
100: pqh_budget_versions bvr,
101: pqh_budget_details bdt
102: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
103: pqh_budget_periods bpr,
104: per_time_periods ptps,
105: per_time_periods ptpe

Line 103: pqh_budget_periods bpr,

99: pqh_budgets bgt,
100: pqh_budget_versions bvr,
101: pqh_budget_details bdt
102: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
103: pqh_budget_periods bpr,
104: per_time_periods ptps,
105: per_time_periods ptpe
106: */
107: WHERE

Line 125: pqh_budgets bgt,

121:
122: CURSOR csr_posn_bdgt_unit2 IS
123: SELECT bdt.budget_unit2_value
124: FROM
125: pqh_budgets bgt,
126: pqh_budget_versions bvr,
127: pqh_budget_details bdt
128: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
129: pqh_budget_periods bpr,

Line 126: pqh_budget_versions bvr,

122: CURSOR csr_posn_bdgt_unit2 IS
123: SELECT bdt.budget_unit2_value
124: FROM
125: pqh_budgets bgt,
126: pqh_budget_versions bvr,
127: pqh_budget_details bdt
128: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
129: pqh_budget_periods bpr,
130: per_time_periods ptps,

Line 127: pqh_budget_details bdt

123: SELECT bdt.budget_unit2_value
124: FROM
125: pqh_budgets bgt,
126: pqh_budget_versions bvr,
127: pqh_budget_details bdt
128: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
129: pqh_budget_periods bpr,
130: per_time_periods ptps,
131: per_time_periods ptpe

Line 129: pqh_budget_periods bpr,

125: pqh_budgets bgt,
126: pqh_budget_versions bvr,
127: pqh_budget_details bdt
128: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
129: pqh_budget_periods bpr,
130: per_time_periods ptps,
131: per_time_periods ptpe
132: */
133: WHERE

Line 152: pqh_budgets bgt,

148:
149: CURSOR csr_posn_bdgt_unit3 IS
150: SELECT bdt.budget_unit3_value
151: FROM
152: pqh_budgets bgt,
153: pqh_budget_versions bvr,
154: pqh_budget_details bdt
155: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
156:

Line 153: pqh_budget_versions bvr,

149: CURSOR csr_posn_bdgt_unit3 IS
150: SELECT bdt.budget_unit3_value
151: FROM
152: pqh_budgets bgt,
153: pqh_budget_versions bvr,
154: pqh_budget_details bdt
155: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
156:
157: pqh_budget_periods bpr,

Line 154: pqh_budget_details bdt

150: SELECT bdt.budget_unit3_value
151: FROM
152: pqh_budgets bgt,
153: pqh_budget_versions bvr,
154: pqh_budget_details bdt
155: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
156:
157: pqh_budget_periods bpr,
158: per_time_periods ptps,

Line 157: pqh_budget_periods bpr,

153: pqh_budget_versions bvr,
154: pqh_budget_details bdt
155: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
156:
157: pqh_budget_periods bpr,
158: per_time_periods ptps,
159: per_time_periods ptpe */
160: WHERE
161: bgt.budget_id = bvr.budget_id

Line 203: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

199: --
200: ---------------------------------------------------------------------------------------------------------
201: FUNCTION get_entity_bdgt
202: (
203: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,

Line 204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

200: ---------------------------------------------------------------------------------------------------------
201: FUNCTION get_entity_bdgt
202: (
203: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
208: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 208: p_start_date IN pqh_budgets.budget_start_date%TYPE,

204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
208: p_start_date IN pqh_budgets.budget_start_date%TYPE,
209: p_end_date IN pqh_budgets.budget_end_date%TYPE,
210: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
211: )
212: RETURN NUMBER IS

Line 209: p_end_date IN pqh_budgets.budget_end_date%TYPE,

205: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
208: p_start_date IN pqh_budgets.budget_start_date%TYPE,
209: p_end_date IN pqh_budgets.budget_end_date%TYPE,
210: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
211: )
212: RETURN NUMBER IS
213: /*

Line 210: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

206: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
207: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
208: p_start_date IN pqh_budgets.budget_start_date%TYPE,
209: p_end_date IN pqh_budgets.budget_end_date%TYPE,
210: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
211: )
212: RETURN NUMBER IS
213: /*
214: This is a private function which will get the budgeted amount for an entity given a

Line 226: pqh_budgets bgt,

222:
223: CURSOR csr_job_bdgt_unit1 IS
224: SELECT bdt.budget_unit1_value
225: FROM
226: pqh_budgets bgt,
227: pqh_budget_versions bvr,
228: pqh_budget_details bdt
229: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
230: pqh_budget_periods bpr,

Line 227: pqh_budget_versions bvr,

223: CURSOR csr_job_bdgt_unit1 IS
224: SELECT bdt.budget_unit1_value
225: FROM
226: pqh_budgets bgt,
227: pqh_budget_versions bvr,
228: pqh_budget_details bdt
229: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
230: pqh_budget_periods bpr,
231: per_time_periods ptps,

Line 228: pqh_budget_details bdt

224: SELECT bdt.budget_unit1_value
225: FROM
226: pqh_budgets bgt,
227: pqh_budget_versions bvr,
228: pqh_budget_details bdt
229: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
230: pqh_budget_periods bpr,
231: per_time_periods ptps,
232: per_time_periods ptpe

Line 230: pqh_budget_periods bpr,

226: pqh_budgets bgt,
227: pqh_budget_versions bvr,
228: pqh_budget_details bdt
229: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
230: pqh_budget_periods bpr,
231: per_time_periods ptps,
232: per_time_periods ptpe
233: */
234: WHERE

Line 252: pqh_budgets bgt,

248:
249: CURSOR csr_job_bdgt_unit2 IS
250: SELECT bdt.budget_unit2_value
251: FROM
252: pqh_budgets bgt,
253: pqh_budget_versions bvr,
254: pqh_budget_details bdt
255: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
256: pqh_budget_periods bpr,

Line 253: pqh_budget_versions bvr,

249: CURSOR csr_job_bdgt_unit2 IS
250: SELECT bdt.budget_unit2_value
251: FROM
252: pqh_budgets bgt,
253: pqh_budget_versions bvr,
254: pqh_budget_details bdt
255: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
256: pqh_budget_periods bpr,
257: per_time_periods ptps,

Line 254: pqh_budget_details bdt

250: SELECT bdt.budget_unit2_value
251: FROM
252: pqh_budgets bgt,
253: pqh_budget_versions bvr,
254: pqh_budget_details bdt
255: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
256: pqh_budget_periods bpr,
257: per_time_periods ptps,
258: per_time_periods ptpe

Line 256: pqh_budget_periods bpr,

252: pqh_budgets bgt,
253: pqh_budget_versions bvr,
254: pqh_budget_details bdt
255: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
256: pqh_budget_periods bpr,
257: per_time_periods ptps,
258: per_time_periods ptpe
259: */
260: WHERE

Line 278: pqh_budgets bgt,

274:
275: CURSOR csr_job_bdgt_unit3 IS
276: SELECT bdt.budget_unit3_value
277: FROM
278: pqh_budgets bgt,
279: pqh_budget_versions bvr,
280: pqh_budget_details bdt
281: /*changed for bug#3784023. Now budgeted values will be reported from budget details
282: pqh_budget_periods bpr,

Line 279: pqh_budget_versions bvr,

275: CURSOR csr_job_bdgt_unit3 IS
276: SELECT bdt.budget_unit3_value
277: FROM
278: pqh_budgets bgt,
279: pqh_budget_versions bvr,
280: pqh_budget_details bdt
281: /*changed for bug#3784023. Now budgeted values will be reported from budget details
282: pqh_budget_periods bpr,
283: per_time_periods ptps,

Line 280: pqh_budget_details bdt

276: SELECT bdt.budget_unit3_value
277: FROM
278: pqh_budgets bgt,
279: pqh_budget_versions bvr,
280: pqh_budget_details bdt
281: /*changed for bug#3784023. Now budgeted values will be reported from budget details
282: pqh_budget_periods bpr,
283: per_time_periods ptps,
284: per_time_periods ptpe

Line 282: pqh_budget_periods bpr,

278: pqh_budgets bgt,
279: pqh_budget_versions bvr,
280: pqh_budget_details bdt
281: /*changed for bug#3784023. Now budgeted values will be reported from budget details
282: pqh_budget_periods bpr,
283: per_time_periods ptps,
284: per_time_periods ptpe
285: */
286: WHERE

Line 304: pqh_budgets bgt,

300:
301: CURSOR csr_grade_bdgt_unit1 IS
302: SELECT bdt.budget_unit1_value
303: FROM
304: pqh_budgets bgt,
305: pqh_budget_versions bvr,
306: pqh_budget_details bdt
307: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
308: pqh_budget_periods bpr,

Line 305: pqh_budget_versions bvr,

301: CURSOR csr_grade_bdgt_unit1 IS
302: SELECT bdt.budget_unit1_value
303: FROM
304: pqh_budgets bgt,
305: pqh_budget_versions bvr,
306: pqh_budget_details bdt
307: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
308: pqh_budget_periods bpr,
309: per_time_periods ptps,

Line 306: pqh_budget_details bdt

302: SELECT bdt.budget_unit1_value
303: FROM
304: pqh_budgets bgt,
305: pqh_budget_versions bvr,
306: pqh_budget_details bdt
307: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
308: pqh_budget_periods bpr,
309: per_time_periods ptps,
310: per_time_periods ptpe

Line 308: pqh_budget_periods bpr,

304: pqh_budgets bgt,
305: pqh_budget_versions bvr,
306: pqh_budget_details bdt
307: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
308: pqh_budget_periods bpr,
309: per_time_periods ptps,
310: per_time_periods ptpe
311: */
312: WHERE

Line 330: pqh_budgets bgt,

326:
327: CURSOR csr_grade_bdgt_unit2 IS
328: SELECT bdt.budget_unit2_value
329: FROM
330: pqh_budgets bgt,
331: pqh_budget_versions bvr,
332: pqh_budget_details bdt
333: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
334: pqh_budget_periods bpr,

Line 331: pqh_budget_versions bvr,

327: CURSOR csr_grade_bdgt_unit2 IS
328: SELECT bdt.budget_unit2_value
329: FROM
330: pqh_budgets bgt,
331: pqh_budget_versions bvr,
332: pqh_budget_details bdt
333: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
334: pqh_budget_periods bpr,
335: per_time_periods ptps,

Line 332: pqh_budget_details bdt

328: SELECT bdt.budget_unit2_value
329: FROM
330: pqh_budgets bgt,
331: pqh_budget_versions bvr,
332: pqh_budget_details bdt
333: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
334: pqh_budget_periods bpr,
335: per_time_periods ptps,
336: per_time_periods ptpe

Line 334: pqh_budget_periods bpr,

330: pqh_budgets bgt,
331: pqh_budget_versions bvr,
332: pqh_budget_details bdt
333: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
334: pqh_budget_periods bpr,
335: per_time_periods ptps,
336: per_time_periods ptpe
337: */
338: WHERE

Line 356: pqh_budgets bgt,

352:
353: CURSOR csr_grade_bdgt_unit3 IS
354: SELECT bdt.budget_unit3_value
355: FROM
356: pqh_budgets bgt,
357: pqh_budget_versions bvr,
358: pqh_budget_details bdt
359: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
360: pqh_budget_periods bpr,

Line 357: pqh_budget_versions bvr,

353: CURSOR csr_grade_bdgt_unit3 IS
354: SELECT bdt.budget_unit3_value
355: FROM
356: pqh_budgets bgt,
357: pqh_budget_versions bvr,
358: pqh_budget_details bdt
359: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
360: pqh_budget_periods bpr,
361: per_time_periods ptps,

Line 358: pqh_budget_details bdt

354: SELECT bdt.budget_unit3_value
355: FROM
356: pqh_budgets bgt,
357: pqh_budget_versions bvr,
358: pqh_budget_details bdt
359: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
360: pqh_budget_periods bpr,
361: per_time_periods ptps,
362: per_time_periods ptpe

Line 360: pqh_budget_periods bpr,

356: pqh_budgets bgt,
357: pqh_budget_versions bvr,
358: pqh_budget_details bdt
359: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
360: pqh_budget_periods bpr,
361: per_time_periods ptps,
362: per_time_periods ptpe
363: */
364: WHERE

Line 383: pqh_budgets bgt,

379:
380: CURSOR csr_org_bdgt_unit1 IS
381: SELECT bdt.budget_unit1_value
382: FROM
383: pqh_budgets bgt,
384: pqh_budget_versions bvr,
385: pqh_budget_details bdt
386: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
387:

Line 384: pqh_budget_versions bvr,

380: CURSOR csr_org_bdgt_unit1 IS
381: SELECT bdt.budget_unit1_value
382: FROM
383: pqh_budgets bgt,
384: pqh_budget_versions bvr,
385: pqh_budget_details bdt
386: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
387:
388: pqh_budget_periods bpr,

Line 385: pqh_budget_details bdt

381: SELECT bdt.budget_unit1_value
382: FROM
383: pqh_budgets bgt,
384: pqh_budget_versions bvr,
385: pqh_budget_details bdt
386: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
387:
388: pqh_budget_periods bpr,
389: per_time_periods ptps,

Line 388: pqh_budget_periods bpr,

384: pqh_budget_versions bvr,
385: pqh_budget_details bdt
386: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
387:
388: pqh_budget_periods bpr,
389: per_time_periods ptps,
390: per_time_periods ptpe
391: */
392: WHERE

Line 410: pqh_budgets bgt,

406:
407: CURSOR csr_org_bdgt_unit2 IS
408: SELECT bdt.budget_unit2_value
409: FROM
410: pqh_budgets bgt,
411: pqh_budget_versions bvr,
412: pqh_budget_details bdt
413: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
414: pqh_budget_periods bpr,

Line 411: pqh_budget_versions bvr,

407: CURSOR csr_org_bdgt_unit2 IS
408: SELECT bdt.budget_unit2_value
409: FROM
410: pqh_budgets bgt,
411: pqh_budget_versions bvr,
412: pqh_budget_details bdt
413: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
414: pqh_budget_periods bpr,
415: per_time_periods ptps,

Line 412: pqh_budget_details bdt

408: SELECT bdt.budget_unit2_value
409: FROM
410: pqh_budgets bgt,
411: pqh_budget_versions bvr,
412: pqh_budget_details bdt
413: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
414: pqh_budget_periods bpr,
415: per_time_periods ptps,
416: per_time_periods ptpe

Line 414: pqh_budget_periods bpr,

410: pqh_budgets bgt,
411: pqh_budget_versions bvr,
412: pqh_budget_details bdt
413: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
414: pqh_budget_periods bpr,
415: per_time_periods ptps,
416: per_time_periods ptpe
417: */
418: WHERE

Line 437: pqh_budgets bgt,

433:
434: CURSOR csr_org_bdgt_unit3 IS
435: SELECT bdt.budget_unit3_value
436: FROM
437: pqh_budgets bgt,
438: pqh_budget_versions bvr,
439: pqh_budget_details bdt
440: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
441: pqh_budget_periods bpr,

Line 438: pqh_budget_versions bvr,

434: CURSOR csr_org_bdgt_unit3 IS
435: SELECT bdt.budget_unit3_value
436: FROM
437: pqh_budgets bgt,
438: pqh_budget_versions bvr,
439: pqh_budget_details bdt
440: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
441: pqh_budget_periods bpr,
442: per_time_periods ptps,

Line 439: pqh_budget_details bdt

435: SELECT bdt.budget_unit3_value
436: FROM
437: pqh_budgets bgt,
438: pqh_budget_versions bvr,
439: pqh_budget_details bdt
440: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
441: pqh_budget_periods bpr,
442: per_time_periods ptps,
443: per_time_periods ptpe

Line 441: pqh_budget_periods bpr,

437: pqh_budgets bgt,
438: pqh_budget_versions bvr,
439: pqh_budget_details bdt
440: /*changed for bug#3784023. Now budgeted values will be reported from budget details.
441: pqh_budget_periods bpr,
442: per_time_periods ptps,
443: per_time_periods ptpe
444: */
445: WHERE

Line 522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

518: --
519: ---------------------------------------------------------------------------------------------------------
520: FUNCTION get_posn_element_bdgt
521: (
522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,

Line 523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

519: ---------------------------------------------------------------------------------------------------------
520: FUNCTION get_posn_element_bdgt
521: (
522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 524: p_start_date IN pqh_budgets.budget_start_date%TYPE,

520: FUNCTION get_posn_element_bdgt
521: (
522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
528: )

Line 525: p_end_date IN pqh_budgets.budget_end_date%TYPE,

521: (
522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
528: )
529: RETURN NUMBER IS

Line 527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

523: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
524: p_start_date IN pqh_budgets.budget_start_date%TYPE,
525: p_end_date IN pqh_budgets.budget_end_date%TYPE,
526: p_position_id IN per_positions.position_id%TYPE,
527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
528: )
529: RETURN NUMBER IS
530: /*
531: This is a private function which will get the budgeted amount for a position given a

Line 544: pqh_budgets bgt,

540: CURSOR csr_posn_bdgt_unit1 IS
541: SELECT
542: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
543: FROM
544: pqh_budgets bgt,
545: pqh_budget_versions bvr,
546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,

Line 545: pqh_budget_versions bvr,

541: SELECT
542: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
543: FROM
544: pqh_budgets bgt,
545: pqh_budget_versions bvr,
546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,

Line 546: pqh_budget_details bdt,

542: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
543: FROM
544: pqh_budgets bgt,
545: pqh_budget_versions bvr,
546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,
550: pqh_budget_sets bst,

Line 547: pqh_budget_periods bpr,

543: FROM
544: pqh_budgets bgt,
545: pqh_budget_versions bvr,
546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,
550: pqh_budget_sets bst,
551: pqh_budget_elements bel

Line 550: pqh_budget_sets bst,

546: pqh_budget_details bdt,
547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,
550: pqh_budget_sets bst,
551: pqh_budget_elements bel
552: WHERE
553: bgt.budget_id = bvr.budget_id
554: AND bvr.budget_version_id = bdt.budget_version_id

Line 551: pqh_budget_elements bel

547: pqh_budget_periods bpr,
548: per_time_periods ptps,
549: per_time_periods ptpe,
550: pqh_budget_sets bst,
551: pqh_budget_elements bel
552: WHERE
553: bgt.budget_id = bvr.budget_id
554: AND bvr.budget_version_id = bdt.budget_version_id
555: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 572: pqh_budgets bgt,

568: CURSOR csr_posn_bdgt_unit2 IS
569: SELECT
570: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
571: FROM
572: pqh_budgets bgt,
573: pqh_budget_versions bvr,
574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,

Line 573: pqh_budget_versions bvr,

569: SELECT
570: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
571: FROM
572: pqh_budgets bgt,
573: pqh_budget_versions bvr,
574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,

Line 574: pqh_budget_details bdt,

570: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
571: FROM
572: pqh_budgets bgt,
573: pqh_budget_versions bvr,
574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,
578: pqh_budget_sets bst,

Line 575: pqh_budget_periods bpr,

571: FROM
572: pqh_budgets bgt,
573: pqh_budget_versions bvr,
574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,
578: pqh_budget_sets bst,
579: pqh_budget_elements bel

Line 578: pqh_budget_sets bst,

574: pqh_budget_details bdt,
575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,
578: pqh_budget_sets bst,
579: pqh_budget_elements bel
580: WHERE
581: bgt.budget_id = bvr.budget_id
582: AND bvr.budget_version_id = bdt.budget_version_id

Line 579: pqh_budget_elements bel

575: pqh_budget_periods bpr,
576: per_time_periods ptps,
577: per_time_periods ptpe,
578: pqh_budget_sets bst,
579: pqh_budget_elements bel
580: WHERE
581: bgt.budget_id = bvr.budget_id
582: AND bvr.budget_version_id = bdt.budget_version_id
583: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 600: pqh_budgets bgt,

596: CURSOR csr_posn_bdgt_unit3 IS
597: SELECT
598: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
599: FROM
600: pqh_budgets bgt,
601: pqh_budget_versions bvr,
602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,

Line 601: pqh_budget_versions bvr,

597: SELECT
598: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
599: FROM
600: pqh_budgets bgt,
601: pqh_budget_versions bvr,
602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,

Line 602: pqh_budget_details bdt,

598: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
599: FROM
600: pqh_budgets bgt,
601: pqh_budget_versions bvr,
602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,
606: pqh_budget_sets bst,

Line 603: pqh_budget_periods bpr,

599: FROM
600: pqh_budgets bgt,
601: pqh_budget_versions bvr,
602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,
606: pqh_budget_sets bst,
607: pqh_budget_elements bel

Line 606: pqh_budget_sets bst,

602: pqh_budget_details bdt,
603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,
606: pqh_budget_sets bst,
607: pqh_budget_elements bel
608: WHERE
609: bgt.budget_id = bvr.budget_id
610: AND bvr.budget_version_id = bdt.budget_version_id

Line 607: pqh_budget_elements bel

603: pqh_budget_periods bpr,
604: per_time_periods ptps,
605: per_time_periods ptpe,
606: pqh_budget_sets bst,
607: pqh_budget_elements bel
608: WHERE
609: bgt.budget_id = bvr.budget_id
610: AND bvr.budget_version_id = bdt.budget_version_id
611: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

648: --
649: ---------------------------------------------------------------------------------------------------------
650: FUNCTION get_posn_bset_bdgt
651: (
652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,

Line 653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

649: ---------------------------------------------------------------------------------------------------------
650: FUNCTION get_posn_bset_bdgt
651: (
652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 654: p_start_date IN pqh_budgets.budget_start_date%TYPE,

650: FUNCTION get_posn_bset_bdgt
651: (
652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
658: )

Line 655: p_end_date IN pqh_budgets.budget_end_date%TYPE,

651: (
652: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
658: )
659: RETURN NUMBER IS

Line 657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

653: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
654: p_start_date IN pqh_budgets.budget_start_date%TYPE,
655: p_end_date IN pqh_budgets.budget_end_date%TYPE,
656: p_position_id IN per_positions.position_id%TYPE,
657: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
658: )
659: RETURN NUMBER IS
660: /*
661: This is a private function which will get the budgeted amount for a position given a

Line 674: pqh_budgets bgt,

670: CURSOR csr_posn_bdgt_unit1 IS
671: SELECT
672: SUM(bst.budget_unit1_value)
673: FROM
674: pqh_budgets bgt,
675: pqh_budget_versions bvr,
676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,

Line 675: pqh_budget_versions bvr,

671: SELECT
672: SUM(bst.budget_unit1_value)
673: FROM
674: pqh_budgets bgt,
675: pqh_budget_versions bvr,
676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,
679: per_time_periods ptpe,

Line 676: pqh_budget_details bdt,

672: SUM(bst.budget_unit1_value)
673: FROM
674: pqh_budgets bgt,
675: pqh_budget_versions bvr,
676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,
679: per_time_periods ptpe,
680: pqh_budget_sets bst

Line 677: pqh_budget_periods bpr,

673: FROM
674: pqh_budgets bgt,
675: pqh_budget_versions bvr,
676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,
679: per_time_periods ptpe,
680: pqh_budget_sets bst
681: WHERE

Line 680: pqh_budget_sets bst

676: pqh_budget_details bdt,
677: pqh_budget_periods bpr,
678: per_time_periods ptps,
679: per_time_periods ptpe,
680: pqh_budget_sets bst
681: WHERE
682: bgt.budget_id = bvr.budget_id
683: AND bvr.budget_version_id = bdt.budget_version_id
684: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 700: pqh_budgets bgt,

696: CURSOR csr_posn_bdgt_unit2 IS
697: SELECT
698: SUM(bst.budget_unit2_value )
699: FROM
700: pqh_budgets bgt,
701: pqh_budget_versions bvr,
702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,

Line 701: pqh_budget_versions bvr,

697: SELECT
698: SUM(bst.budget_unit2_value )
699: FROM
700: pqh_budgets bgt,
701: pqh_budget_versions bvr,
702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,
705: per_time_periods ptpe,

Line 702: pqh_budget_details bdt,

698: SUM(bst.budget_unit2_value )
699: FROM
700: pqh_budgets bgt,
701: pqh_budget_versions bvr,
702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,
705: per_time_periods ptpe,
706: pqh_budget_sets bst

Line 703: pqh_budget_periods bpr,

699: FROM
700: pqh_budgets bgt,
701: pqh_budget_versions bvr,
702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,
705: per_time_periods ptpe,
706: pqh_budget_sets bst
707: WHERE

Line 706: pqh_budget_sets bst

702: pqh_budget_details bdt,
703: pqh_budget_periods bpr,
704: per_time_periods ptps,
705: per_time_periods ptpe,
706: pqh_budget_sets bst
707: WHERE
708: bgt.budget_id = bvr.budget_id
709: AND bvr.budget_version_id = bdt.budget_version_id
710: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 726: pqh_budgets bgt,

722: CURSOR csr_posn_bdgt_unit3 IS
723: SELECT
724: SUM(bst.budget_unit3_value)
725: FROM
726: pqh_budgets bgt,
727: pqh_budget_versions bvr,
728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,

Line 727: pqh_budget_versions bvr,

723: SELECT
724: SUM(bst.budget_unit3_value)
725: FROM
726: pqh_budgets bgt,
727: pqh_budget_versions bvr,
728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,
731: per_time_periods ptpe,

Line 728: pqh_budget_details bdt,

724: SUM(bst.budget_unit3_value)
725: FROM
726: pqh_budgets bgt,
727: pqh_budget_versions bvr,
728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,
731: per_time_periods ptpe,
732: pqh_budget_sets bst

Line 729: pqh_budget_periods bpr,

725: FROM
726: pqh_budgets bgt,
727: pqh_budget_versions bvr,
728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,
731: per_time_periods ptpe,
732: pqh_budget_sets bst
733: WHERE

Line 732: pqh_budget_sets bst

728: pqh_budget_details bdt,
729: pqh_budget_periods bpr,
730: per_time_periods ptps,
731: per_time_periods ptpe,
732: pqh_budget_sets bst
733: WHERE
734: bgt.budget_id = bvr.budget_id
735: AND bvr.budget_version_id = bdt.budget_version_id
736: AND bdt.budget_detail_id = bpr.budget_detail_id

Line 800: nvl(p_currency_code,'X') = nvl(pqh_budget.get_currency_cd(p_budget_id),'X'))) then

796: l_budget_measurement_type := get_budget_measurement_type(p_unit_of_measure_id);
797: --
798: if (( l_budget_measurement_type <> 'MONEY') OR
799: ( l_budget_measurement_type = 'MONEY' and
800: nvl(p_currency_code,'X') = nvl(pqh_budget.get_currency_cd(p_budget_id),'X'))) then
801:
802: if (p_summarize_by = 'BUDGET' and p_budgeted_or_cmmt = 'BUDGETED') then
803: l_curr_ver_tot := get_posn_bdgt
804: (

Line 871: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

867: RETURN NUMBER IS
868: l_proc varchar2(72) := g_package||'get_position_actual_cmmtmnts';
869: l_total_amt NUMBER := 0;
870: l_curr_ver_tot NUMBER := 0;
871: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
872: l_budget_id pqh_budget_versions.budget_id%TYPE;
873: l_business_group_id number;
874:
875: cursor csr_bdgt(p_budget_version_id number) is

Line 872: l_budget_id pqh_budget_versions.budget_id%TYPE;

868: l_proc varchar2(72) := g_package||'get_position_actual_cmmtmnts';
869: l_total_amt NUMBER := 0;
870: l_curr_ver_tot NUMBER := 0;
871: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
872: l_budget_id pqh_budget_versions.budget_id%TYPE;
873: l_business_group_id number;
874:
875: cursor csr_bdgt(p_budget_version_id number) is
876: SELECT bvr.budget_id

Line 877: FROM pqh_budget_versions bvr

873: l_business_group_id number;
874:
875: cursor csr_bdgt(p_budget_version_id number) is
876: SELECT bvr.budget_id
877: FROM pqh_budget_versions bvr
878: WHERE bvr.budget_version_id = p_budget_version_id;
879:
880: CURSOR csr_bdgt_positions(p_business_group_id number) IS
881: SELECT DISTINCT

Line 885: pqh_budgets bgt,

881: SELECT DISTINCT
882: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
883: bgt.budget_id
884: FROM
885: pqh_budgets bgt,
886: pqh_budget_versions bvr,
887: pqh_budget_details bdt
888: WHERE
889: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 886: pqh_budget_versions bvr,

882: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
883: bgt.budget_id
884: FROM
885: pqh_budgets bgt,
886: pqh_budget_versions bvr,
887: pqh_budget_details bdt
888: WHERE
889: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
890: AND bgt.budget_id = bvr.budget_id

Line 887: pqh_budget_details bdt

883: bgt.budget_id
884: FROM
885: pqh_budgets bgt,
886: pqh_budget_versions bvr,
887: pqh_budget_details bdt
888: WHERE
889: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
890: AND bgt.budget_id = bvr.budget_id
891: AND bvr.budget_version_id = bdt.budget_version_id

Line 974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

970: --
971: ---------------------------------------------------------------------------------------------------------
972: FUNCTION get_position_actual_cmmtmnts
973: (
974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
975: p_position_id IN per_positions.position_id%TYPE,
976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 976: p_start_date IN pqh_budgets.budget_start_date%TYPE,

972: FUNCTION get_position_actual_cmmtmnts
973: (
974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
975: p_position_id IN per_positions.position_id%TYPE,
976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
979: p_value_type IN varchar2 DEFAULT 'T',
980: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 977: p_end_date IN pqh_budgets.budget_end_date%TYPE,

973: (
974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
975: p_position_id IN per_positions.position_id%TYPE,
976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
979: p_value_type IN varchar2 DEFAULT 'T',
980: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
981: )

Line 978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

974: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
975: p_position_id IN per_positions.position_id%TYPE,
976: p_start_date IN pqh_budgets.budget_start_date%TYPE,
977: p_end_date IN pqh_budgets.budget_end_date%TYPE,
978: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
979: p_value_type IN varchar2 DEFAULT 'T',
980: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
981: )
982: RETURN NUMBER is

Line 1015: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1011: --
1012: ---------------------------------------------------------------------------------------------------------
1013: FUNCTION get_entity_actual_cmmtmnts
1014: (
1015: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1016: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,

Line 1016: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

1012: ---------------------------------------------------------------------------------------------------------
1013: FUNCTION get_entity_actual_cmmtmnts
1014: (
1015: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1016: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1016: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1022: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1023: p_value_type IN varchar2 DEFAULT 'T',
1024: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1017: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1022: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1023: p_value_type IN varchar2 DEFAULT 'T',
1024: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1025: )

Line 1022: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1018: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1019: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1022: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1023: p_value_type IN varchar2 DEFAULT 'T',
1024: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1025: )
1026: RETURN NUMBER IS

Line 1041: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

1037:
1038: l_proc varchar2(72) := g_package||'get_entity_actual_cmmtmnts';
1039: l_total_amt NUMBER := 0;
1040: l_curr_ver_tot NUMBER := 0;
1041: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1042: l_currency_code fnd_currencies.currency_code%TYPE;
1043: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1044: l_business_group_id number;
1045:

Line 1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1045:
1046: CURSOR csr_bdgts_job(p_business_group_id number) IS
1047: SELECT
1048: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1050: FROM
1051: pqh_budgets bgt,
1052: pqh_budget_versions bvr,
1053: pqh_budget_details bdt

Line 1051: pqh_budgets bgt,

1047: SELECT
1048: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1050: FROM
1051: pqh_budgets bgt,
1052: pqh_budget_versions bvr,
1053: pqh_budget_details bdt
1054: WHERE
1055: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1052: pqh_budget_versions bvr,

1048: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1050: FROM
1051: pqh_budgets bgt,
1052: pqh_budget_versions bvr,
1053: pqh_budget_details bdt
1054: WHERE
1055: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1056: AND bgt.budget_id = bvr.budget_id

Line 1053: pqh_budget_details bdt

1049: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1050: FROM
1051: pqh_budgets bgt,
1052: pqh_budget_versions bvr,
1053: pqh_budget_details bdt
1054: WHERE
1055: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1056: AND bgt.budget_id = bvr.budget_id
1057: AND bvr.budget_version_id = bdt.budget_version_id

Line 1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1065: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1066: CURSOR csr_bdgts_grade(p_business_group_id number) IS
1067: SELECT
1068: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1070: FROM
1071: pqh_budgets bgt,
1072: pqh_budget_versions bvr,
1073: pqh_budget_details bdt

Line 1071: pqh_budgets bgt,

1067: SELECT
1068: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1070: FROM
1071: pqh_budgets bgt,
1072: pqh_budget_versions bvr,
1073: pqh_budget_details bdt
1074: WHERE
1075: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1072: pqh_budget_versions bvr,

1068: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1070: FROM
1071: pqh_budgets bgt,
1072: pqh_budget_versions bvr,
1073: pqh_budget_details bdt
1074: WHERE
1075: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1076: AND bgt.budget_id = bvr.budget_id

Line 1073: pqh_budget_details bdt

1069: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1070: FROM
1071: pqh_budgets bgt,
1072: pqh_budget_versions bvr,
1073: pqh_budget_details bdt
1074: WHERE
1075: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1076: AND bgt.budget_id = bvr.budget_id
1077: AND bvr.budget_version_id = bdt.budget_version_id

Line 1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1085: OR p_start_date BETWEEN bgt.budget_start_date AND bgt.budget_end_date );
1086: CURSOR csr_bdgts_org(p_business_group_id number) IS
1087: SELECT
1088: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1090: FROM
1091: pqh_budgets bgt,
1092: pqh_budget_versions bvr,
1093: pqh_budget_details bdt

Line 1091: pqh_budgets bgt,

1087: SELECT
1088: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1090: FROM
1091: pqh_budgets bgt,
1092: pqh_budget_versions bvr,
1093: pqh_budget_details bdt
1094: WHERE
1095: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1092: pqh_budget_versions bvr,

1088: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1090: FROM
1091: pqh_budgets bgt,
1092: pqh_budget_versions bvr,
1093: pqh_budget_details bdt
1094: WHERE
1095: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1096: AND bgt.budget_id = bvr.budget_id

Line 1093: pqh_budget_details bdt

1089: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1090: FROM
1091: pqh_budgets bgt,
1092: pqh_budget_versions bvr,
1093: pqh_budget_details bdt
1094: WHERE
1095: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1096: AND bgt.budget_id = bvr.budget_id
1097: AND bvr.budget_version_id = bdt.budget_version_id

Line 1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1317: --
1318: ---------------------------------------------------------------------------------------------------------
1319: FUNCTION get_position_budget_amt
1320: (
1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1319: FUNCTION get_position_budget_amt
1320: (
1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1327: )

Line 1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1320: (
1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1327: )
1328: RETURN NUMBER IS

Line 1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1321: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1322: p_position_id IN per_positions.position_id%TYPE,
1323: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1324: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1325: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1326: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1327: )
1328: RETURN NUMBER IS
1329: /*

Line 1355: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1351: --
1352: ---------------------------------------------------------------------------------------------------------
1353: FUNCTION get_entity_budget_amt
1354: (
1355: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1356: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,

Line 1356: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

1352: ---------------------------------------------------------------------------------------------------------
1353: FUNCTION get_entity_budget_amt
1354: (
1355: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1356: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1356: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1362: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1363: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1364: )

Line 1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1357: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1362: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1363: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1364: )
1365: RETURN NUMBER IS

Line 1362: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1358: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
1359: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,
1360: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1361: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1362: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1363: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1364: )
1365: RETURN NUMBER IS
1366:

Line 1377: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

1373:
1374: l_proc varchar2(72) := g_package||'get_entity_budget_amt';
1375: l_total_amt NUMBER := 0;
1376: l_curr_ver_tot NUMBER := 0;
1377: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1378: l_currency_code fnd_currencies.currency_code%TYPE;
1379: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1380: l_business_group_id number;
1381:

Line 1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1381:
1382: CURSOR csr_bdgts_job(p_business_group_id number) IS
1383: SELECT
1384: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1386: FROM
1387: pqh_budgets bgt,
1388: pqh_budget_versions bvr,
1389: pqh_budget_details bdt

Line 1387: pqh_budgets bgt,

1383: SELECT
1384: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1386: FROM
1387: pqh_budgets bgt,
1388: pqh_budget_versions bvr,
1389: pqh_budget_details bdt
1390: WHERE
1391: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1388: pqh_budget_versions bvr,

1384: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1386: FROM
1387: pqh_budgets bgt,
1388: pqh_budget_versions bvr,
1389: pqh_budget_details bdt
1390: WHERE
1391: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1392: AND bgt.budget_id = bvr.budget_id

Line 1389: pqh_budget_details bdt

1385: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1386: FROM
1387: pqh_budgets bgt,
1388: pqh_budget_versions bvr,
1389: pqh_budget_details bdt
1390: WHERE
1391: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1392: AND bgt.budget_id = bvr.budget_id
1393: AND bvr.budget_version_id = bdt.budget_version_id

Line 1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1402:
1403: CURSOR csr_bdgts_grade(p_business_group_id number) IS
1404: SELECT
1405: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1407: FROM
1408: pqh_budgets bgt,
1409: pqh_budget_versions bvr,
1410: pqh_budget_details bdt

Line 1408: pqh_budgets bgt,

1404: SELECT
1405: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1407: FROM
1408: pqh_budgets bgt,
1409: pqh_budget_versions bvr,
1410: pqh_budget_details bdt
1411: WHERE
1412: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1409: pqh_budget_versions bvr,

1405: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1407: FROM
1408: pqh_budgets bgt,
1409: pqh_budget_versions bvr,
1410: pqh_budget_details bdt
1411: WHERE
1412: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1413: AND bgt.budget_id = bvr.budget_id

Line 1410: pqh_budget_details bdt

1406: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1407: FROM
1408: pqh_budgets bgt,
1409: pqh_budget_versions bvr,
1410: pqh_budget_details bdt
1411: WHERE
1412: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1413: AND bgt.budget_id = bvr.budget_id
1414: AND bvr.budget_version_id = bdt.budget_version_id

Line 1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1423:
1424: CURSOR csr_bdgts_org(p_business_group_id number) IS
1425: SELECT
1426: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1428: FROM
1429: pqh_budgets bgt,
1430: pqh_budget_versions bvr,
1431: pqh_budget_details bdt

Line 1429: pqh_budgets bgt,

1425: SELECT
1426: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1428: FROM
1429: pqh_budgets bgt,
1430: pqh_budget_versions bvr,
1431: pqh_budget_details bdt
1432: WHERE
1433: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 1430: pqh_budget_versions bvr,

1426: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1428: FROM
1429: pqh_budgets bgt,
1430: pqh_budget_versions bvr,
1431: pqh_budget_details bdt
1432: WHERE
1433: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1434: AND bgt.budget_id = bvr.budget_id

Line 1431: pqh_budget_details bdt

1427: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1428: FROM
1429: pqh_budgets bgt,
1430: pqh_budget_versions bvr,
1431: pqh_budget_details bdt
1432: WHERE
1433: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
1434: AND bgt.budget_id = bvr.budget_id
1435: AND bvr.budget_version_id = bdt.budget_version_id

Line 1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1511:
1512: ---------------------------------------------------------------------------------------------------------
1513: FUNCTION get_posn_element_bdgt_amt
1514: (
1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1513: FUNCTION get_posn_element_bdgt_amt
1514: (
1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1514: (
1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1522: )

Line 1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1515: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1522: )
1523: RETURN NUMBER IS

Line 1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1516: p_position_id IN per_positions.position_id%TYPE,
1517: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1518: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1519: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1520: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1521: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1522: )
1523: RETURN NUMBER IS
1524: BEGIN

Line 1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1541: --
1542: --
1543: FUNCTION get_job_element_bdgt
1544: (
1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,

Line 1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1542: --
1543: FUNCTION get_job_element_bdgt
1544: (
1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1543: FUNCTION get_job_element_bdgt
1544: (
1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1551: )

Line 1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1544: (
1545: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1551: )
1552: RETURN NUMBER IS

Line 1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

1546: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1547: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1548: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1549: p_job_id IN per_jobs.job_id%TYPE,
1550: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1551: )
1552: RETURN NUMBER IS
1553: /*
1554: This is a private function which will get the budgeted amount for a job given a

Line 1567: pqh_budgets bgt,

1563: CURSOR csr_job_bdgt_unit1 IS
1564: SELECT
1565: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1566: FROM
1567: pqh_budgets bgt,
1568: pqh_budget_versions bvr,
1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,

Line 1568: pqh_budget_versions bvr,

1564: SELECT
1565: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1566: FROM
1567: pqh_budgets bgt,
1568: pqh_budget_versions bvr,
1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,

Line 1569: pqh_budget_details bdt,

1565: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1566: FROM
1567: pqh_budgets bgt,
1568: pqh_budget_versions bvr,
1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,
1573: pqh_budget_sets bst,

Line 1570: pqh_budget_periods bpr,

1566: FROM
1567: pqh_budgets bgt,
1568: pqh_budget_versions bvr,
1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,
1573: pqh_budget_sets bst,
1574: pqh_budget_elements bel

Line 1573: pqh_budget_sets bst,

1569: pqh_budget_details bdt,
1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,
1573: pqh_budget_sets bst,
1574: pqh_budget_elements bel
1575:
1576: WHERE
1577: bgt.budget_id = bvr.budget_id

Line 1574: pqh_budget_elements bel

1570: pqh_budget_periods bpr,
1571: per_time_periods ptps,
1572: per_time_periods ptpe,
1573: pqh_budget_sets bst,
1574: pqh_budget_elements bel
1575:
1576: WHERE
1577: bgt.budget_id = bvr.budget_id
1578: AND bvr.budget_version_id = bdt.budget_version_id

Line 1596: pqh_budgets bgt,

1592: CURSOR csr_job_bdgt_unit2 IS
1593: SELECT
1594: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1595: FROM
1596: pqh_budgets bgt,
1597: pqh_budget_versions bvr,
1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,

Line 1597: pqh_budget_versions bvr,

1593: SELECT
1594: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1595: FROM
1596: pqh_budgets bgt,
1597: pqh_budget_versions bvr,
1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,

Line 1598: pqh_budget_details bdt,

1594: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1595: FROM
1596: pqh_budgets bgt,
1597: pqh_budget_versions bvr,
1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,
1602: pqh_budget_sets bst,

Line 1599: pqh_budget_periods bpr,

1595: FROM
1596: pqh_budgets bgt,
1597: pqh_budget_versions bvr,
1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,
1602: pqh_budget_sets bst,
1603: pqh_budget_elements bel

Line 1602: pqh_budget_sets bst,

1598: pqh_budget_details bdt,
1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,
1602: pqh_budget_sets bst,
1603: pqh_budget_elements bel
1604:
1605:
1606: WHERE

Line 1603: pqh_budget_elements bel

1599: pqh_budget_periods bpr,
1600: per_time_periods ptps,
1601: per_time_periods ptpe,
1602: pqh_budget_sets bst,
1603: pqh_budget_elements bel
1604:
1605:
1606: WHERE
1607: bgt.budget_id = bvr.budget_id

Line 1627: pqh_budgets bgt,

1623: CURSOR csr_job_bdgt_unit3 IS
1624: SELECT
1625: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1626: FROM
1627: pqh_budgets bgt,
1628: pqh_budget_versions bvr,
1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,

Line 1628: pqh_budget_versions bvr,

1624: SELECT
1625: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1626: FROM
1627: pqh_budgets bgt,
1628: pqh_budget_versions bvr,
1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,

Line 1629: pqh_budget_details bdt,

1625: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1626: FROM
1627: pqh_budgets bgt,
1628: pqh_budget_versions bvr,
1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,
1633: pqh_budget_sets bst,

Line 1630: pqh_budget_periods bpr,

1626: FROM
1627: pqh_budgets bgt,
1628: pqh_budget_versions bvr,
1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,
1633: pqh_budget_sets bst,
1634: pqh_budget_elements bel

Line 1633: pqh_budget_sets bst,

1629: pqh_budget_details bdt,
1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,
1633: pqh_budget_sets bst,
1634: pqh_budget_elements bel
1635:
1636:
1637: WHERE

Line 1634: pqh_budget_elements bel

1630: pqh_budget_periods bpr,
1631: per_time_periods ptps,
1632: per_time_periods ptpe,
1633: pqh_budget_sets bst,
1634: pqh_budget_elements bel
1635:
1636:
1637: WHERE
1638: bgt.budget_id = bvr.budget_id

Line 1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1687: -- calls another function which calculates the budgeted amount.
1688: --
1689: FUNCTION get_job_element_bdgt_amt
1690: (
1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1689: FUNCTION get_job_element_bdgt_amt
1690: (
1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1690: (
1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1698: )

Line 1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1691: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1698: )
1699: RETURN NUMBER IS

Line 1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1692: p_job_id IN per_jobs.job_id%TYPE,
1693: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1694: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1695: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1696: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1697: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1698: )
1699: RETURN NUMBER IS
1700: l_proc varchar2(72) := g_package||'get_job_element_bdgt_amt';

Line 1703: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

1699: RETURN NUMBER IS
1700: l_proc varchar2(72) := g_package||'get_job_element_bdgt_amt';
1701: l_total_amt NUMBER := 0;
1702: l_curr_ver_tot NUMBER := 0;
1703: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1704: l_currency_code fnd_currencies.currency_code%TYPE;
1705: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1706: l_business_group_id number;
1707:

Line 1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1707:
1708: CURSOR csr_bdgt_jobs IS
1709: SELECT
1710: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1712: FROM
1713: pqh_budgets bgt,
1714: pqh_budget_versions bvr,
1715: pqh_budget_details bdt

Line 1713: pqh_budgets bgt,

1709: SELECT
1710: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1712: FROM
1713: pqh_budgets bgt,
1714: pqh_budget_versions bvr,
1715: pqh_budget_details bdt
1716: WHERE
1717: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 1714: pqh_budget_versions bvr,

1710: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1712: FROM
1713: pqh_budgets bgt,
1714: pqh_budget_versions bvr,
1715: pqh_budget_details bdt
1716: WHERE
1717: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1718: AND bgt.budget_id = bvr.budget_id

Line 1715: pqh_budget_details bdt

1711: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1712: FROM
1713: pqh_budgets bgt,
1714: pqh_budget_versions bvr,
1715: pqh_budget_details bdt
1716: WHERE
1717: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1718: AND bgt.budget_id = bvr.budget_id
1719: AND bvr.budget_version_id = bdt.budget_version_id

Line 1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1776: --
1777: --
1778: FUNCTION get_grde_element_bdgt
1779: (
1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,

Line 1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1777: --
1778: FUNCTION get_grde_element_bdgt
1779: (
1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,
1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1778: FUNCTION get_grde_element_bdgt
1779: (
1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,
1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1786: )

Line 1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1779: (
1780: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,
1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1786: )
1787: RETURN NUMBER IS

Line 1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

1781: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1782: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1783: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1784: p_grade_id IN per_grades.grade_id%TYPE,
1785: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
1786: )
1787: RETURN NUMBER IS
1788: /*
1789: This is a private function which will get the budgeted amount for a grade given a

Line 1802: pqh_budgets bgt,

1798: CURSOR csr_grade_bdgt_unit1 IS
1799: SELECT
1800: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1801: FROM
1802: pqh_budgets bgt,
1803: pqh_budget_versions bvr,
1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,

Line 1803: pqh_budget_versions bvr,

1799: SELECT
1800: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1801: FROM
1802: pqh_budgets bgt,
1803: pqh_budget_versions bvr,
1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,

Line 1804: pqh_budget_details bdt,

1800: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
1801: FROM
1802: pqh_budgets bgt,
1803: pqh_budget_versions bvr,
1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,
1808: pqh_budget_sets bst,

Line 1805: pqh_budget_periods bpr,

1801: FROM
1802: pqh_budgets bgt,
1803: pqh_budget_versions bvr,
1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,
1808: pqh_budget_sets bst,
1809: pqh_budget_elements bel

Line 1808: pqh_budget_sets bst,

1804: pqh_budget_details bdt,
1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,
1808: pqh_budget_sets bst,
1809: pqh_budget_elements bel
1810:
1811: WHERE
1812: bgt.budget_id = bvr.budget_id

Line 1809: pqh_budget_elements bel

1805: pqh_budget_periods bpr,
1806: per_time_periods ptps,
1807: per_time_periods ptpe,
1808: pqh_budget_sets bst,
1809: pqh_budget_elements bel
1810:
1811: WHERE
1812: bgt.budget_id = bvr.budget_id
1813: AND bvr.budget_version_id = bdt.budget_version_id

Line 1831: pqh_budgets bgt,

1827: CURSOR csr_grade_bdgt_unit2 IS
1828: SELECT
1829: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1830: FROM
1831: pqh_budgets bgt,
1832: pqh_budget_versions bvr,
1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,

Line 1832: pqh_budget_versions bvr,

1828: SELECT
1829: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1830: FROM
1831: pqh_budgets bgt,
1832: pqh_budget_versions bvr,
1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,

Line 1833: pqh_budget_details bdt,

1829: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
1830: FROM
1831: pqh_budgets bgt,
1832: pqh_budget_versions bvr,
1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,
1837: pqh_budget_sets bst,

Line 1834: pqh_budget_periods bpr,

1830: FROM
1831: pqh_budgets bgt,
1832: pqh_budget_versions bvr,
1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,
1837: pqh_budget_sets bst,
1838: pqh_budget_elements bel

Line 1837: pqh_budget_sets bst,

1833: pqh_budget_details bdt,
1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,
1837: pqh_budget_sets bst,
1838: pqh_budget_elements bel
1839:
1840:
1841: WHERE

Line 1838: pqh_budget_elements bel

1834: pqh_budget_periods bpr,
1835: per_time_periods ptps,
1836: per_time_periods ptpe,
1837: pqh_budget_sets bst,
1838: pqh_budget_elements bel
1839:
1840:
1841: WHERE
1842: bgt.budget_id = bvr.budget_id

Line 1862: pqh_budgets bgt,

1858: CURSOR csr_grade_bdgt_unit3 IS
1859: SELECT
1860: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1861: FROM
1862: pqh_budgets bgt,
1863: pqh_budget_versions bvr,
1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,

Line 1863: pqh_budget_versions bvr,

1859: SELECT
1860: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1861: FROM
1862: pqh_budgets bgt,
1863: pqh_budget_versions bvr,
1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,

Line 1864: pqh_budget_details bdt,

1860: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
1861: FROM
1862: pqh_budgets bgt,
1863: pqh_budget_versions bvr,
1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,
1868: pqh_budget_sets bst,

Line 1865: pqh_budget_periods bpr,

1861: FROM
1862: pqh_budgets bgt,
1863: pqh_budget_versions bvr,
1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,
1868: pqh_budget_sets bst,
1869: pqh_budget_elements bel

Line 1868: pqh_budget_sets bst,

1864: pqh_budget_details bdt,
1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,
1868: pqh_budget_sets bst,
1869: pqh_budget_elements bel
1870:
1871:
1872: WHERE

Line 1869: pqh_budget_elements bel

1865: pqh_budget_periods bpr,
1866: per_time_periods ptps,
1867: per_time_periods ptpe,
1868: pqh_budget_sets bst,
1869: pqh_budget_elements bel
1870:
1871:
1872: WHERE
1873: bgt.budget_id = bvr.budget_id

Line 1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

1922: -- calls another function which calculates the budgeted amount.
1923: --
1924: FUNCTION get_grde_element_bdgt_amt
1925: (
1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

1924: FUNCTION get_grde_element_bdgt_amt
1925: (
1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,

1925: (
1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1933: )

Line 1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,

1926: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1933: )
1934: RETURN NUMBER IS

Line 1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

1927: p_grade_id IN per_grades.grade_id%TYPE,
1928: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
1929: p_start_date IN pqh_budgets.budget_start_date%TYPE,
1930: p_end_date IN pqh_budgets.budget_end_date%TYPE,
1931: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
1932: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
1933: )
1934: RETURN NUMBER IS
1935:

Line 1942: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

1938:
1939: l_proc varchar2(72) := g_package||'get_grde_element_bdgt_amt';
1940: l_total_amt NUMBER := 0;
1941: l_curr_ver_tot NUMBER := 0;
1942: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
1943: l_currency_code fnd_currencies.currency_code%TYPE;
1944: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
1945: l_business_group_id number;
1946:

Line 1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

1946:
1947: CURSOR csr_bdgt_grades IS
1948: SELECT
1949: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1951: FROM
1952: pqh_budgets bgt,
1953: pqh_budget_versions bvr,
1954: pqh_budget_details bdt

Line 1952: pqh_budgets bgt,

1948: SELECT
1949: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1951: FROM
1952: pqh_budgets bgt,
1953: pqh_budget_versions bvr,
1954: pqh_budget_details bdt
1955: WHERE
1956: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 1953: pqh_budget_versions bvr,

1949: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1951: FROM
1952: pqh_budgets bgt,
1953: pqh_budget_versions bvr,
1954: pqh_budget_details bdt
1955: WHERE
1956: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1957: AND bgt.budget_id = bvr.budget_id

Line 1954: pqh_budget_details bdt

1950: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
1951: FROM
1952: pqh_budgets bgt,
1953: pqh_budget_versions bvr,
1954: pqh_budget_details bdt
1955: WHERE
1956: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
1957: AND bgt.budget_id = bvr.budget_id
1958: AND bvr.budget_version_id = bdt.budget_version_id

Line 2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2014: --
2015: ---------------------------------------------------------------------------------------------------------
2016: FUNCTION get_orgn_element_bdgt
2017: (
2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,

Line 2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2015: ---------------------------------------------------------------------------------------------------------
2016: FUNCTION get_orgn_element_bdgt
2017: (
2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,
2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2016: FUNCTION get_orgn_element_bdgt
2017: (
2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,
2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2024: )

Line 2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2017: (
2018: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,
2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2024: )
2025: RETURN NUMBER IS

Line 2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

2019: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2020: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2021: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2022: p_organization_id IN hr_organization_units.organization_id%TYPE,
2023: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2024: )
2025: RETURN NUMBER IS
2026: /*
2027: This is a private function which will get the budgeted amount for a organization given a

Line 2040: pqh_budgets bgt,

2036: CURSOR csr_orgn_bdgt_unit1 IS
2037: SELECT
2038: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
2039: FROM
2040: pqh_budgets bgt,
2041: pqh_budget_versions bvr,
2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,

Line 2041: pqh_budget_versions bvr,

2037: SELECT
2038: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
2039: FROM
2040: pqh_budgets bgt,
2041: pqh_budget_versions bvr,
2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,

Line 2042: pqh_budget_details bdt,

2038: SUM(bst.budget_unit1_value * NVL(bel.distribution_percentage/100,0))
2039: FROM
2040: pqh_budgets bgt,
2041: pqh_budget_versions bvr,
2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,
2046: pqh_budget_sets bst,

Line 2043: pqh_budget_periods bpr,

2039: FROM
2040: pqh_budgets bgt,
2041: pqh_budget_versions bvr,
2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,
2046: pqh_budget_sets bst,
2047: pqh_budget_elements bel

Line 2046: pqh_budget_sets bst,

2042: pqh_budget_details bdt,
2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,
2046: pqh_budget_sets bst,
2047: pqh_budget_elements bel
2048:
2049: WHERE
2050: bgt.budget_id = bvr.budget_id

Line 2047: pqh_budget_elements bel

2043: pqh_budget_periods bpr,
2044: per_time_periods ptps,
2045: per_time_periods ptpe,
2046: pqh_budget_sets bst,
2047: pqh_budget_elements bel
2048:
2049: WHERE
2050: bgt.budget_id = bvr.budget_id
2051: AND bvr.budget_version_id = bdt.budget_version_id

Line 2069: pqh_budgets bgt,

2065: CURSOR csr_orgn_bdgt_unit2 IS
2066: SELECT
2067: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
2068: FROM
2069: pqh_budgets bgt,
2070: pqh_budget_versions bvr,
2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,

Line 2070: pqh_budget_versions bvr,

2066: SELECT
2067: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
2068: FROM
2069: pqh_budgets bgt,
2070: pqh_budget_versions bvr,
2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,

Line 2071: pqh_budget_details bdt,

2067: SUM(bst.budget_unit2_value * NVL(bel.distribution_percentage/100,0))
2068: FROM
2069: pqh_budgets bgt,
2070: pqh_budget_versions bvr,
2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,
2075: pqh_budget_sets bst,

Line 2072: pqh_budget_periods bpr,

2068: FROM
2069: pqh_budgets bgt,
2070: pqh_budget_versions bvr,
2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,
2075: pqh_budget_sets bst,
2076: pqh_budget_elements bel

Line 2075: pqh_budget_sets bst,

2071: pqh_budget_details bdt,
2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,
2075: pqh_budget_sets bst,
2076: pqh_budget_elements bel
2077:
2078:
2079: WHERE

Line 2076: pqh_budget_elements bel

2072: pqh_budget_periods bpr,
2073: per_time_periods ptps,
2074: per_time_periods ptpe,
2075: pqh_budget_sets bst,
2076: pqh_budget_elements bel
2077:
2078:
2079: WHERE
2080: bgt.budget_id = bvr.budget_id

Line 2100: pqh_budgets bgt,

2096: CURSOR csr_orgn_bdgt_unit3 IS
2097: SELECT
2098: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
2099: FROM
2100: pqh_budgets bgt,
2101: pqh_budget_versions bvr,
2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,

Line 2101: pqh_budget_versions bvr,

2097: SELECT
2098: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
2099: FROM
2100: pqh_budgets bgt,
2101: pqh_budget_versions bvr,
2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,

Line 2102: pqh_budget_details bdt,

2098: SUM(bst.budget_unit3_value * NVL(bel.distribution_percentage/100,0))
2099: FROM
2100: pqh_budgets bgt,
2101: pqh_budget_versions bvr,
2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,
2106: pqh_budget_sets bst,

Line 2103: pqh_budget_periods bpr,

2099: FROM
2100: pqh_budgets bgt,
2101: pqh_budget_versions bvr,
2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,
2106: pqh_budget_sets bst,
2107: pqh_budget_elements bel

Line 2106: pqh_budget_sets bst,

2102: pqh_budget_details bdt,
2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,
2106: pqh_budget_sets bst,
2107: pqh_budget_elements bel
2108:
2109:
2110: WHERE

Line 2107: pqh_budget_elements bel

2103: pqh_budget_periods bpr,
2104: per_time_periods ptps,
2105: per_time_periods ptpe,
2106: pqh_budget_sets bst,
2107: pqh_budget_elements bel
2108:
2109:
2110: WHERE
2111: bgt.budget_id = bvr.budget_id

Line 2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2160: -- calls another function which calculates the budgeted amount.
2161: --
2162: FUNCTION get_orgn_element_bdgt_amt
2163: (
2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2162: FUNCTION get_orgn_element_bdgt_amt
2163: (
2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2163: (
2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2171: )

Line 2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2164: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2171: )
2172: RETURN NUMBER IS

Line 2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2165: p_organization_id IN hr_organization_units.organization_id%TYPE,
2166: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2167: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2168: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2169: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2170: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2171: )
2172: RETURN NUMBER IS
2173: l_proc varchar2(72) := g_package||'get_orgn_element_bdgt_amt';

Line 2176: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2172: RETURN NUMBER IS
2173: l_proc varchar2(72) := g_package||'get_orgn_element_bdgt_amt';
2174: l_total_amt NUMBER := 0;
2175: l_curr_ver_tot NUMBER := 0;
2176: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2177: l_currency_code fnd_currencies.currency_code%TYPE;
2178: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2179: l_business_group_id number;
2180:

Line 2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2180:
2181: CURSOR csr_bdgt_orgs IS
2182: SELECT
2183: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2185: FROM
2186: pqh_budgets bgt,
2187: pqh_budget_versions bvr,
2188: pqh_budget_details bdt

Line 2186: pqh_budgets bgt,

2182: SELECT
2183: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2185: FROM
2186: pqh_budgets bgt,
2187: pqh_budget_versions bvr,
2188: pqh_budget_details bdt
2189: WHERE
2190: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2187: pqh_budget_versions bvr,

2183: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2185: FROM
2186: pqh_budgets bgt,
2187: pqh_budget_versions bvr,
2188: pqh_budget_details bdt
2189: WHERE
2190: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2191: AND bgt.budget_id = bvr.budget_id

Line 2188: pqh_budget_details bdt

2184: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2185: FROM
2186: pqh_budgets bgt,
2187: pqh_budget_versions bvr,
2188: pqh_budget_details bdt
2189: WHERE
2190: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2191: AND bgt.budget_id = bvr.budget_id
2192: AND bvr.budget_version_id = bdt.budget_version_id

Line 2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2253:
2254: ---------------------------------------------------------------------------------------------------------
2255: FUNCTION get_posn_bset_bdgt_amt
2256: (
2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

2255: FUNCTION get_posn_bset_bdgt_amt
2256: (
2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2263: )

Line 2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2256: (
2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2263: )
2264: RETURN NUMBER IS

Line 2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2257: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2263: )
2264: RETURN NUMBER IS
2265: BEGIN

Line 2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

2258: p_position_id IN per_positions.position_id%TYPE,
2259: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2260: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2261: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2262: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE
2263: )
2264: RETURN NUMBER IS
2265: BEGIN
2266: return get_position_budgeted_or_cmmt

Line 2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2282: --
2283: ---------------------------------------------------------------------------------------------------------
2284: FUNCTION get_posn_elmnt_actual_cmmtmnts
2285: (
2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2284: FUNCTION get_posn_elmnt_actual_cmmtmnts
2285: (
2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',

Line 2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2285: (
2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',
2293: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2286: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',
2293: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2294: )

Line 2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2287: p_position_id IN per_positions.position_id%TYPE,
2288: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2289: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2290: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2291: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2292: p_value_type IN varchar2 DEFAULT 'T',
2293: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2294: )
2295: RETURN NUMBER IS

Line 2312: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2308:
2309: l_proc varchar2(72) := g_package||'get_posn_elmnt_actual_cmmtmnts';
2310: l_total_amt NUMBER := 0;
2311: l_curr_ver_tot NUMBER := 0;
2312: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2313: l_currency_code fnd_currencies.currency_code%TYPE;
2314: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2315: l_business_group_id number;
2316:

Line 2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2316:
2317: CURSOR csr_bdgt_positions IS
2318: SELECT DISTINCT
2319: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,

Line 2322: pqh_budgets bgt,

2318: SELECT DISTINCT
2319: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,

Line 2323: pqh_budget_versions bvr,

2319: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel

Line 2324: pqh_budget_details bdt,

2320: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel
2328: WHERE

Line 2325: pqh_budget_periods bpr,

2321: FROM
2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel
2328: WHERE
2329: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2326: pqh_budget_sets bst,

2322: pqh_budgets bgt,
2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel
2328: WHERE
2329: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2330: AND bgt.budget_id = bvr.budget_id

Line 2327: pqh_budget_elements bel

2323: pqh_budget_versions bvr,
2324: pqh_budget_details bdt,
2325: pqh_budget_periods bpr,
2326: pqh_budget_sets bst,
2327: pqh_budget_elements bel
2328: WHERE
2329: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2330: AND bgt.budget_id = bvr.budget_id
2331: AND bvr.budget_version_id = bdt.budget_version_id

Line 2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2401: --
2402: ---------------------------------------------------------------------------------------------------------
2403: FUNCTION get_job_elmnt_actual_cmmtmnts
2404: (
2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2403: FUNCTION get_job_elmnt_actual_cmmtmnts
2404: (
2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',

Line 2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2404: (
2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',
2412: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2405: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',
2412: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2413: )

Line 2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2406: p_job_id IN per_jobs.job_id%TYPE,
2407: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2408: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2409: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2410: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2411: p_value_type IN varchar2 DEFAULT 'T',
2412: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2413: )
2414: RETURN NUMBER IS

Line 2431: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2427:
2428: l_proc varchar2(72) := g_package||'get_job_elmnt_actual_cmmtmnts';
2429: l_total_amt NUMBER := 0;
2430: l_curr_ver_tot NUMBER := 0;
2431: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2432: l_currency_code fnd_currencies.currency_code%TYPE;
2433: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2434: l_business_group_id number;
2435:

Line 2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2435:
2436: CURSOR csr_bdgt_jobs IS
2437: SELECT DISTINCT
2438: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,

Line 2441: pqh_budgets bgt,

2437: SELECT DISTINCT
2438: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,

Line 2442: pqh_budget_versions bvr,

2438: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel

Line 2443: pqh_budget_details bdt,

2439: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel
2447: WHERE

Line 2444: pqh_budget_periods bpr,

2440: FROM
2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel
2447: WHERE
2448: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2445: pqh_budget_sets bst,

2441: pqh_budgets bgt,
2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel
2447: WHERE
2448: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2449: AND bgt.budget_id = bvr.budget_id

Line 2446: pqh_budget_elements bel

2442: pqh_budget_versions bvr,
2443: pqh_budget_details bdt,
2444: pqh_budget_periods bpr,
2445: pqh_budget_sets bst,
2446: pqh_budget_elements bel
2447: WHERE
2448: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2449: AND bgt.budget_id = bvr.budget_id
2450: AND bvr.budget_version_id = bdt.budget_version_id

Line 2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2518: --
2519: ---------------------------------------------------------------------------------------------------------
2520: FUNCTION get_grde_elmnt_actual_cmmtmnts
2521: (
2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2520: FUNCTION get_grde_elmnt_actual_cmmtmnts
2521: (
2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',

Line 2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2521: (
2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',
2529: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2522: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',
2529: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2530: )

Line 2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2523: p_grade_id IN per_grades.grade_id%TYPE,
2524: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2525: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2526: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2527: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2528: p_value_type IN varchar2 DEFAULT 'T',
2529: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2530: )
2531: RETURN NUMBER IS

Line 2548: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2544:
2545: l_proc varchar2(72) := g_package||'get_grde_elmnt_actual_cmmtmnts';
2546: l_total_amt NUMBER := 0;
2547: l_curr_ver_tot NUMBER := 0;
2548: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2549: l_currency_code fnd_currencies.currency_code%TYPE;
2550: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2551: l_business_group_id number;
2552:

Line 2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2552:
2553: CURSOR csr_bdgt_grades IS
2554: SELECT DISTINCT
2555: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,

Line 2558: pqh_budgets bgt,

2554: SELECT DISTINCT
2555: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,

Line 2559: pqh_budget_versions bvr,

2555: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel

Line 2560: pqh_budget_details bdt,

2556: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel
2564: WHERE

Line 2561: pqh_budget_periods bpr,

2557: FROM
2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel
2564: WHERE
2565: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2562: pqh_budget_sets bst,

2558: pqh_budgets bgt,
2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel
2564: WHERE
2565: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2566: AND bgt.budget_id = bvr.budget_id

Line 2563: pqh_budget_elements bel

2559: pqh_budget_versions bvr,
2560: pqh_budget_details bdt,
2561: pqh_budget_periods bpr,
2562: pqh_budget_sets bst,
2563: pqh_budget_elements bel
2564: WHERE
2565: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2566: AND bgt.budget_id = bvr.budget_id
2567: AND bvr.budget_version_id = bdt.budget_version_id

Line 2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2634: --
2635: ---------------------------------------------------------------------------------------------------------
2636: FUNCTION get_orgn_elmnt_actual_cmmtmnts
2637: (
2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

2636: FUNCTION get_orgn_elmnt_actual_cmmtmnts
2637: (
2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',

Line 2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2637: (
2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',
2645: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2638: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',
2645: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2646: )

Line 2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2639: p_organization_id IN hr_organization_units.organization_id%TYPE,
2640: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
2641: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2642: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2643: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2644: p_value_type IN varchar2 DEFAULT 'T',
2645: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2646: )
2647: RETURN NUMBER IS

Line 2664: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2660:
2661: l_proc varchar2(72) := g_package||'get_orgn_elmnt_actual_cmmtmnts';
2662: l_total_amt NUMBER := 0;
2663: l_curr_ver_tot NUMBER := 0;
2664: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2665: l_currency_code fnd_currencies.currency_code%TYPE;
2666: l_budget_measurement_type per_shared_types.system_type_cd%TYPE;
2667: l_business_group_id number;
2668:

Line 2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2668:
2669: CURSOR csr_bdgt_orgs IS
2670: SELECT DISTINCT
2671: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,

Line 2674: pqh_budgets bgt,

2670: SELECT DISTINCT
2671: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,

Line 2675: pqh_budget_versions bvr,

2671: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel

Line 2676: pqh_budget_details bdt,

2672: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel
2680: WHERE

Line 2677: pqh_budget_periods bpr,

2673: FROM
2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel
2680: WHERE
2681: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2678: pqh_budget_sets bst,

2674: pqh_budgets bgt,
2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel
2680: WHERE
2681: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2682: AND bgt.budget_id = bvr.budget_id

Line 2679: pqh_budget_elements bel

2675: pqh_budget_versions bvr,
2676: pqh_budget_details bdt,
2677: pqh_budget_periods bpr,
2678: pqh_budget_sets bst,
2679: pqh_budget_elements bel
2680: WHERE
2681: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2682: AND bgt.budget_id = bvr.budget_id
2683: AND bvr.budget_version_id = bdt.budget_version_id

Line 2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

2751:
2752: ---------------------------------------------------------------------------------------------------------
2753: FUNCTION get_posn_bset_actual_cmmtmnts
2754: (
2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,

2753: FUNCTION get_posn_bset_actual_cmmtmnts
2754: (
2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2761: p_value_type IN varchar2 DEFAULT 'T'

Line 2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2754: (
2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2761: p_value_type IN varchar2 DEFAULT 'T'
2762: )

Line 2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2755: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2761: p_value_type IN varchar2 DEFAULT 'T'
2762: )
2763: RETURN NUMBER IS

Line 2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2756: p_position_id IN per_positions.position_id%TYPE,
2757: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
2758: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2759: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2760: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2761: p_value_type IN varchar2 DEFAULT 'T'
2762: )
2763: RETURN NUMBER IS
2764:

Line 2768: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2764:
2765: l_proc varchar2(72) := g_package||'get_posn_bset_actual_cmmtmnts';
2766: l_total_amt NUMBER := 0;
2767: l_curr_ver_tot NUMBER := 0;
2768: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2769: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
2770: l_business_group_id number;
2771:
2772: CURSOR csr_bdgt_positions IS

Line 2769: l_element_type_id pqh_budget_elements.element_type_id%TYPE;

2765: l_proc varchar2(72) := g_package||'get_posn_bset_actual_cmmtmnts';
2766: l_total_amt NUMBER := 0;
2767: l_curr_ver_tot NUMBER := 0;
2768: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2769: l_element_type_id pqh_budget_elements.element_type_id%TYPE;
2770: l_business_group_id number;
2771:
2772: CURSOR csr_bdgt_positions IS
2773: SELECT DISTINCT

Line 2776: pqh_budgets bgt,

2772: CURSOR csr_bdgt_positions IS
2773: SELECT DISTINCT
2774: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID
2775: FROM
2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst

Line 2777: pqh_budget_versions bvr,

2773: SELECT DISTINCT
2774: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID
2775: FROM
2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst
2781: WHERE

Line 2778: pqh_budget_details bdt,

2774: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID
2775: FROM
2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst
2781: WHERE
2782: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )

Line 2779: pqh_budget_periods bpr,

2775: FROM
2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst
2781: WHERE
2782: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2783: AND bgt.budget_id = bvr.budget_id

Line 2780: pqh_budget_sets bst

2776: pqh_budgets bgt,
2777: pqh_budget_versions bvr,
2778: pqh_budget_details bdt,
2779: pqh_budget_periods bpr,
2780: pqh_budget_sets bst
2781: WHERE
2782: bgt.business_group_id = NVL(l_business_group_id, bgt.business_group_id )
2783: AND bgt.budget_id = bvr.budget_id
2784: AND bvr.budget_version_id = bdt.budget_version_id

Line 2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,

2855: END get_posn_bset_actual_cmmtmnts;
2856: ---------------------------------------------------------------------------------------------------------
2857: FUNCTION get_org_posn_budget_amt
2858: (
2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2856: ---------------------------------------------------------------------------------------------------------
2857: FUNCTION get_org_posn_budget_amt
2858: (
2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2864: )

Line 2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2857: FUNCTION get_org_posn_budget_amt
2858: (
2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2864: )
2865: RETURN NUMBER IS

Line 2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2858: (
2859: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2860: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2861: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2862: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2863: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2864: )
2865: RETURN NUMBER IS
2866: /*

Line 2869: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2865: RETURN NUMBER IS
2866: /*
2867: */
2868: l_proc varchar2(72) := g_package||'get_org_posn_budget_amt';
2869: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2870: l_position_id pqh_budget_details.position_id%TYPE;
2871: l_total_amt NUMBER := 0;
2872: l_curr_posn_tot NUMBER := 0;
2873:

Line 2870: l_position_id pqh_budget_details.position_id%TYPE;

2866: /*
2867: */
2868: l_proc varchar2(72) := g_package||'get_org_posn_budget_amt';
2869: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2870: l_position_id pqh_budget_details.position_id%TYPE;
2871: l_total_amt NUMBER := 0;
2872: l_curr_posn_tot NUMBER := 0;
2873:
2874: l_currency_code fnd_currencies.currency_code%TYPE;

Line 2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2878: CURSOR csr_bdgt_positions(p_business_group_id number) IS
2879: SELECT DISTINCT
2880: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2881: bdt.position_id position_id,
2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2883: FROM
2884: pqh_budgets bgt,
2885: pqh_budget_versions bvr,
2886: pqh_budget_details bdt

Line 2884: pqh_budgets bgt,

2880: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2881: bdt.position_id position_id,
2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2883: FROM
2884: pqh_budgets bgt,
2885: pqh_budget_versions bvr,
2886: pqh_budget_details bdt
2887: WHERE
2888: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 2885: pqh_budget_versions bvr,

2881: bdt.position_id position_id,
2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2883: FROM
2884: pqh_budgets bgt,
2885: pqh_budget_versions bvr,
2886: pqh_budget_details bdt
2887: WHERE
2888: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2889: AND bgt.budget_id = bvr.budget_id

Line 2886: pqh_budget_details bdt

2882: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2883: FROM
2884: pqh_budgets bgt,
2885: pqh_budget_versions bvr,
2886: pqh_budget_details bdt
2887: WHERE
2888: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2889: AND bgt.budget_id = bvr.budget_id
2890: AND bvr.budget_version_id = bdt.budget_version_id

Line 2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,

2943:
2944: ---------------------------------------------------------------------------------------------------------
2945: FUNCTION get_org_posn_actual_cmmtmnts
2946: (
2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',

Line 2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,

2944: ---------------------------------------------------------------------------------------------------------
2945: FUNCTION get_org_posn_actual_cmmtmnts
2946: (
2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',
2952: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,

2945: FUNCTION get_org_posn_actual_cmmtmnts
2946: (
2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',
2952: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2953: )

Line 2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

2946: (
2947: p_organization_id IN pqh_budget_details.organization_id%TYPE,
2948: p_start_date IN pqh_budgets.budget_start_date%TYPE,
2949: p_end_date IN pqh_budgets.budget_end_date%TYPE,
2950: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
2951: p_value_type IN varchar2 DEFAULT 'T',
2952: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
2953: )
2954: RETURN NUMBER IS

Line 2959: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

2955: /*
2956: */
2957:
2958: l_proc varchar2(72) := g_package||'get_org_posn_actual_cmmtmnts';
2959: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2960: l_position_id pqh_budget_details.position_id%TYPE;
2961: l_total_amt NUMBER := 0;
2962: l_curr_posn_tot NUMBER := 0;
2963:

Line 2960: l_position_id pqh_budget_details.position_id%TYPE;

2956: */
2957:
2958: l_proc varchar2(72) := g_package||'get_org_posn_actual_cmmtmnts';
2959: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
2960: l_position_id pqh_budget_details.position_id%TYPE;
2961: l_total_amt NUMBER := 0;
2962: l_curr_posn_tot NUMBER := 0;
2963:
2964: l_currency_code fnd_currencies.currency_code%TYPE;

Line 2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

2968: CURSOR csr_bdgt_positions(p_business_group_id number) IS
2969: SELECT DISTINCT
2970: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2971: bdt.position_id position_id,
2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2973: FROM
2974: pqh_budgets bgt,
2975: pqh_budget_versions bvr,
2976: pqh_budget_details bdt

Line 2974: pqh_budgets bgt,

2970: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
2971: bdt.position_id position_id,
2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2973: FROM
2974: pqh_budgets bgt,
2975: pqh_budget_versions bvr,
2976: pqh_budget_details bdt
2977: WHERE
2978: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 2975: pqh_budget_versions bvr,

2971: bdt.position_id position_id,
2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2973: FROM
2974: pqh_budgets bgt,
2975: pqh_budget_versions bvr,
2976: pqh_budget_details bdt
2977: WHERE
2978: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2979: AND bgt.budget_id = bvr.budget_id

Line 2976: pqh_budget_details bdt

2972: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
2973: FROM
2974: pqh_budgets bgt,
2975: pqh_budget_versions bvr,
2976: pqh_budget_details bdt
2977: WHERE
2978: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
2979: AND bgt.budget_id = bvr.budget_id
2980: AND bvr.budget_version_id = bdt.budget_version_id

Line 3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,

3035: ---------------------------------------------------------------------------------------------------------
3036:
3037: FUNCTION get_bgrp_posn_budget_amt
3038: (
3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3036:
3037: FUNCTION get_bgrp_posn_budget_amt
3038: (
3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3044: )

Line 3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3037: FUNCTION get_bgrp_posn_budget_amt
3038: (
3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3044: )
3045: RETURN NUMBER IS

Line 3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3038: (
3039: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3040: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3041: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3042: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3043: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3044: )
3045: RETURN NUMBER IS
3046:

Line 3048: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3044: )
3045: RETURN NUMBER IS
3046:
3047: l_proc varchar2(72) := g_package||'get_bgrp_posn_budget_amt';
3048: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3049: l_position_id pqh_budget_details.position_id%TYPE;
3050: l_total_amt NUMBER := 0;
3051: l_curr_posn_tot NUMBER := 0;
3052:

Line 3049: l_position_id pqh_budget_details.position_id%TYPE;

3045: RETURN NUMBER IS
3046:
3047: l_proc varchar2(72) := g_package||'get_bgrp_posn_budget_amt';
3048: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3049: l_position_id pqh_budget_details.position_id%TYPE;
3050: l_total_amt NUMBER := 0;
3051: l_curr_posn_tot NUMBER := 0;
3052:
3053: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3056: CURSOR csr_bdgt_positions IS
3057: SELECT DISTINCT
3058: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3059: bdt.position_id position_id,
3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3061: FROM
3062: pqh_budgets bgt,
3063: pqh_budget_versions bvr,
3064: pqh_budget_details bdt

Line 3062: pqh_budgets bgt,

3058: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3059: bdt.position_id position_id,
3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3061: FROM
3062: pqh_budgets bgt,
3063: pqh_budget_versions bvr,
3064: pqh_budget_details bdt
3065: WHERE bgt.business_group_id = p_business_group_id
3066: AND bgt.budget_id = bvr.budget_id

Line 3063: pqh_budget_versions bvr,

3059: bdt.position_id position_id,
3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3061: FROM
3062: pqh_budgets bgt,
3063: pqh_budget_versions bvr,
3064: pqh_budget_details bdt
3065: WHERE bgt.business_group_id = p_business_group_id
3066: AND bgt.budget_id = bvr.budget_id
3067: AND bvr.budget_version_id = bdt.budget_version_id

Line 3064: pqh_budget_details bdt

3060: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3061: FROM
3062: pqh_budgets bgt,
3063: pqh_budget_versions bvr,
3064: pqh_budget_details bdt
3065: WHERE bgt.business_group_id = p_business_group_id
3066: AND bgt.budget_id = bvr.budget_id
3067: AND bvr.budget_version_id = bdt.budget_version_id
3068: AND (bgt.budget_unit1_id = p_unit_of_measure_id or

Line 3121: p_business_group_id IN pqh_budgets.business_group_id%TYPE,

3117: END get_bgrp_posn_budget_amt;
3118: ---------------------------------------------------------------------------------------------------------
3119: FUNCTION get_bgrp_posn_actual_cmmtmnts
3120: (
3121: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3125: p_value_type IN varchar2 DEFAULT 'T',

Line 3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3118: ---------------------------------------------------------------------------------------------------------
3119: FUNCTION get_bgrp_posn_actual_cmmtmnts
3120: (
3121: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3125: p_value_type IN varchar2 DEFAULT 'T',
3126: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3119: FUNCTION get_bgrp_posn_actual_cmmtmnts
3120: (
3121: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3125: p_value_type IN varchar2 DEFAULT 'T',
3126: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3127: )

Line 3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3120: (
3121: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
3122: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3123: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3124: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3125: p_value_type IN varchar2 DEFAULT 'T',
3126: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3127: )
3128: RETURN NUMBER IS

Line 3131: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3127: )
3128: RETURN NUMBER IS
3129:
3130: l_proc varchar2(72) := g_package||'get_bgrp_posn_actual_cmmtmnts';
3131: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3132: l_position_id pqh_budget_details.position_id%TYPE;
3133: l_total_amt NUMBER := 0;
3134: l_curr_posn_tot NUMBER := 0;
3135:

Line 3132: l_position_id pqh_budget_details.position_id%TYPE;

3128: RETURN NUMBER IS
3129:
3130: l_proc varchar2(72) := g_package||'get_bgrp_posn_actual_cmmtmnts';
3131: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3132: l_position_id pqh_budget_details.position_id%TYPE;
3133: l_total_amt NUMBER := 0;
3134: l_curr_posn_tot NUMBER := 0;
3135:
3136: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3139: CURSOR csr_bdgt_positions IS
3140: SELECT DISTINCT
3141: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3142: bdt.position_id position_id,
3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3144: FROM
3145: pqh_budgets bgt,
3146: pqh_budget_versions bvr,
3147: pqh_budget_details bdt

Line 3145: pqh_budgets bgt,

3141: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3142: bdt.position_id position_id,
3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3144: FROM
3145: pqh_budgets bgt,
3146: pqh_budget_versions bvr,
3147: pqh_budget_details bdt
3148: WHERE
3149: bgt.business_group_id = p_business_group_id

Line 3146: pqh_budget_versions bvr,

3142: bdt.position_id position_id,
3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3144: FROM
3145: pqh_budgets bgt,
3146: pqh_budget_versions bvr,
3147: pqh_budget_details bdt
3148: WHERE
3149: bgt.business_group_id = p_business_group_id
3150: AND bgt.budget_id = bvr.budget_id

Line 3147: pqh_budget_details bdt

3143: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3144: FROM
3145: pqh_budgets bgt,
3146: pqh_budget_versions bvr,
3147: pqh_budget_details bdt
3148: WHERE
3149: bgt.business_group_id = p_business_group_id
3150: AND bgt.budget_id = bvr.budget_id
3151: AND bvr.budget_version_id = bdt.budget_version_id

Line 3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3204: --
3205: ---------------------------------------------------------------------------------------------------------
3206: FUNCTION get_elem_posn_budget_amt
3207: (
3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3205: ---------------------------------------------------------------------------------------------------------
3206: FUNCTION get_elem_posn_budget_amt
3207: (
3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3213: )

Line 3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3206: FUNCTION get_elem_posn_budget_amt
3207: (
3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3213: )
3214: RETURN NUMBER IS

Line 3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3207: (
3208: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3209: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3210: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3211: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3212: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3213: )
3214: RETURN NUMBER IS
3215:

Line 3217: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3213: )
3214: RETURN NUMBER IS
3215:
3216: l_proc varchar2(72) := g_package||'get_elem_posn_budget_amt';
3217: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3218: l_position_id pqh_budget_details.position_id%TYPE;
3219: l_total_amt NUMBER := 0;
3220: l_curr_posn_tot NUMBER := 0;
3221:

Line 3218: l_position_id pqh_budget_details.position_id%TYPE;

3214: RETURN NUMBER IS
3215:
3216: l_proc varchar2(72) := g_package||'get_elem_posn_budget_amt';
3217: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3218: l_position_id pqh_budget_details.position_id%TYPE;
3219: l_total_amt NUMBER := 0;
3220: l_curr_posn_tot NUMBER := 0;
3221:
3222: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3226: CURSOR csr_bdgt_positions(p_business_group_id number) IS
3227: SELECT DISTINCT
3228: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3229: bdt.position_id,
3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3231: FROM
3232: pqh_budgets bgt,
3233: pqh_budget_versions bvr,
3234: pqh_budget_details bdt

Line 3232: pqh_budgets bgt,

3228: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3229: bdt.position_id,
3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3231: FROM
3232: pqh_budgets bgt,
3233: pqh_budget_versions bvr,
3234: pqh_budget_details bdt
3235: WHERE
3236: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3233: pqh_budget_versions bvr,

3229: bdt.position_id,
3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3231: FROM
3232: pqh_budgets bgt,
3233: pqh_budget_versions bvr,
3234: pqh_budget_details bdt
3235: WHERE
3236: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3237: AND bgt.budget_id = bvr.budget_id

Line 3234: pqh_budget_details bdt

3230: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3231: FROM
3232: pqh_budgets bgt,
3233: pqh_budget_versions bvr,
3234: pqh_budget_details bdt
3235: WHERE
3236: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3237: AND bgt.budget_id = bvr.budget_id
3238: AND bvr.budget_version_id = bdt.budget_version_id

Line 3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3300: -- JOB
3301: --
3302: FUNCTION get_elem_job_budget_amt
3303: (
3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3301: --
3302: FUNCTION get_elem_job_budget_amt
3303: (
3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3309: )

Line 3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3302: FUNCTION get_elem_job_budget_amt
3303: (
3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3309: )
3310: RETURN NUMBER IS

Line 3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3303: (
3304: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3305: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3306: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3307: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3308: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3309: )
3310: RETURN NUMBER IS
3311:

Line 3313: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3309: )
3310: RETURN NUMBER IS
3311:
3312: l_proc varchar2(72) := g_package||'get_elem_job_budget_amt';
3313: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3314: l_job_id pqh_budget_details.job_id%TYPE;
3315: l_total_amt NUMBER := 0;
3316: l_curr_posn_tot NUMBER := 0;
3317:

Line 3314: l_job_id pqh_budget_details.job_id%TYPE;

3310: RETURN NUMBER IS
3311:
3312: l_proc varchar2(72) := g_package||'get_elem_job_budget_amt';
3313: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3314: l_job_id pqh_budget_details.job_id%TYPE;
3315: l_total_amt NUMBER := 0;
3316: l_curr_posn_tot NUMBER := 0;
3317:
3318: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3322: CURSOR csr_bdgt_jobs(p_business_group_id number) IS
3323: SELECT DISTINCT
3324: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3325: bdt.job_id,
3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3327: FROM
3328: pqh_budgets bgt,
3329: pqh_budget_versions bvr,
3330: pqh_budget_details bdt

Line 3328: pqh_budgets bgt,

3324: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3325: bdt.job_id,
3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3327: FROM
3328: pqh_budgets bgt,
3329: pqh_budget_versions bvr,
3330: pqh_budget_details bdt
3331: WHERE
3332: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3329: pqh_budget_versions bvr,

3325: bdt.job_id,
3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3327: FROM
3328: pqh_budgets bgt,
3329: pqh_budget_versions bvr,
3330: pqh_budget_details bdt
3331: WHERE
3332: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3333: AND bgt.budget_id = bvr.budget_id

Line 3330: pqh_budget_details bdt

3326: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3327: FROM
3328: pqh_budgets bgt,
3329: pqh_budget_versions bvr,
3330: pqh_budget_details bdt
3331: WHERE
3332: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3333: AND bgt.budget_id = bvr.budget_id
3334: AND bvr.budget_version_id = bdt.budget_version_id

Line 3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3397: -- GRADE
3398: --
3399: FUNCTION get_elem_grde_budget_amt
3400: (
3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3398: --
3399: FUNCTION get_elem_grde_budget_amt
3400: (
3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3406: )

Line 3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3399: FUNCTION get_elem_grde_budget_amt
3400: (
3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3406: )
3407: RETURN NUMBER IS

Line 3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3400: (
3401: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3402: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3403: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3404: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3405: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3406: )
3407: RETURN NUMBER IS
3408:

Line 3410: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3406: )
3407: RETURN NUMBER IS
3408:
3409: l_proc varchar2(72) := g_package||'get_elem_grd_budget_amt';
3410: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3411: l_grade_id pqh_budget_details.grade_id%TYPE;
3412: l_total_amt NUMBER := 0;
3413: l_curr_posn_tot NUMBER := 0;
3414:

Line 3411: l_grade_id pqh_budget_details.grade_id%TYPE;

3407: RETURN NUMBER IS
3408:
3409: l_proc varchar2(72) := g_package||'get_elem_grd_budget_amt';
3410: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3411: l_grade_id pqh_budget_details.grade_id%TYPE;
3412: l_total_amt NUMBER := 0;
3413: l_curr_posn_tot NUMBER := 0;
3414:
3415: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3418: CURSOR csr_bdgt_grades(p_business_group_id number) IS
3419: SELECT DISTINCT
3420: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3421: bdt.grade_id,
3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3423: FROM
3424: pqh_budgets bgt,
3425: pqh_budget_versions bvr,
3426: pqh_budget_details bdt

Line 3424: pqh_budgets bgt,

3420: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3421: bdt.grade_id,
3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3423: FROM
3424: pqh_budgets bgt,
3425: pqh_budget_versions bvr,
3426: pqh_budget_details bdt
3427: WHERE
3428: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3425: pqh_budget_versions bvr,

3421: bdt.grade_id,
3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3423: FROM
3424: pqh_budgets bgt,
3425: pqh_budget_versions bvr,
3426: pqh_budget_details bdt
3427: WHERE
3428: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3429: AND bgt.budget_id = bvr.budget_id

Line 3426: pqh_budget_details bdt

3422: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3423: FROM
3424: pqh_budgets bgt,
3425: pqh_budget_versions bvr,
3426: pqh_budget_details bdt
3427: WHERE
3428: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3429: AND bgt.budget_id = bvr.budget_id
3430: AND bvr.budget_version_id = bdt.budget_version_id

Line 3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3492: -- ORGANIZATION
3493: --
3494: FUNCTION get_elem_orgn_budget_amt
3495: (
3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3493: --
3494: FUNCTION get_elem_orgn_budget_amt
3495: (
3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3501: )

Line 3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3494: FUNCTION get_elem_orgn_budget_amt
3495: (
3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3501: )
3502: RETURN NUMBER IS

Line 3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3495: (
3496: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3497: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3498: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3499: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3500: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3501: )
3502: RETURN NUMBER IS
3503:

Line 3505: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3501: )
3502: RETURN NUMBER IS
3503:
3504: l_proc varchar2(72) := g_package||'get_elem_org_budget_amt';
3505: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3506: l_organization_id pqh_budget_details.organization_id%TYPE;
3507: l_total_amt NUMBER := 0;
3508: l_curr_posn_tot NUMBER := 0;
3509:

Line 3506: l_organization_id pqh_budget_details.organization_id%TYPE;

3502: RETURN NUMBER IS
3503:
3504: l_proc varchar2(72) := g_package||'get_elem_org_budget_amt';
3505: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3506: l_organization_id pqh_budget_details.organization_id%TYPE;
3507: l_total_amt NUMBER := 0;
3508: l_curr_posn_tot NUMBER := 0;
3509:
3510: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3514: CURSOR csr_bdgt_orgs(p_business_group_id number) IS
3515: SELECT DISTINCT
3516: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3517: bdt.organization_id,
3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3519: FROM
3520: pqh_budgets bgt,
3521: pqh_budget_versions bvr,
3522: pqh_budget_details bdt

Line 3520: pqh_budgets bgt,

3516: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3517: bdt.organization_id,
3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3519: FROM
3520: pqh_budgets bgt,
3521: pqh_budget_versions bvr,
3522: pqh_budget_details bdt
3523: WHERE
3524: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3521: pqh_budget_versions bvr,

3517: bdt.organization_id,
3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3519: FROM
3520: pqh_budgets bgt,
3521: pqh_budget_versions bvr,
3522: pqh_budget_details bdt
3523: WHERE
3524: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3525: AND bgt.budget_id = bvr.budget_id

Line 3522: pqh_budget_details bdt

3518: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3519: FROM
3520: pqh_budgets bgt,
3521: pqh_budget_versions bvr,
3522: pqh_budget_details bdt
3523: WHERE
3524: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3525: AND bgt.budget_id = bvr.budget_id
3526: AND bvr.budget_version_id = bdt.budget_version_id

Line 3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3587:
3588: ---------------------------------------------------------------------------------------------------------
3589: FUNCTION get_elem_posn_actual_cmmtmnts
3590: (
3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',

Line 3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3588: ---------------------------------------------------------------------------------------------------------
3589: FUNCTION get_elem_posn_actual_cmmtmnts
3590: (
3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',
3596: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3589: FUNCTION get_elem_posn_actual_cmmtmnts
3590: (
3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',
3596: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3597: )

Line 3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3590: (
3591: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3592: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3593: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3594: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3595: p_value_type IN varchar2 DEFAULT 'T',
3596: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3597: )
3598: RETURN NUMBER IS

Line 3603: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3599: /*
3600: */
3601:
3602: l_proc varchar2(72) := g_package||'get_elem_posn_actual_cmmtmnts';
3603: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3604: l_position_id pqh_budget_details.position_id%TYPE;
3605: l_total_amt NUMBER := 0;
3606: l_curr_posn_tot NUMBER := 0;
3607:

Line 3604: l_position_id pqh_budget_details.position_id%TYPE;

3600: */
3601:
3602: l_proc varchar2(72) := g_package||'get_elem_posn_actual_cmmtmnts';
3603: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3604: l_position_id pqh_budget_details.position_id%TYPE;
3605: l_total_amt NUMBER := 0;
3606: l_curr_posn_tot NUMBER := 0;
3607:
3608: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3612: CURSOR csr_bdgt_positions(p_business_group_id number) IS
3613: SELECT DISTINCT
3614: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3615: bdt.position_id,
3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,

Line 3618: pqh_budgets bgt,

3614: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3615: bdt.position_id,
3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,

Line 3619: pqh_budget_versions bvr,

3615: bdt.position_id,
3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel

Line 3620: pqh_budget_details bdt,

3616: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel
3624: WHERE

Line 3621: pqh_budget_periods bpr,

3617: FROM
3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel
3624: WHERE
3625: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3622: pqh_budget_sets bst,

3618: pqh_budgets bgt,
3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel
3624: WHERE
3625: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3626: AND bgt.budget_id = bvr.budget_id

Line 3623: pqh_budget_elements bel

3619: pqh_budget_versions bvr,
3620: pqh_budget_details bdt,
3621: pqh_budget_periods bpr,
3622: pqh_budget_sets bst,
3623: pqh_budget_elements bel
3624: WHERE
3625: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3626: AND bgt.budget_id = bvr.budget_id
3627: AND bvr.budget_version_id = bdt.budget_version_id

Line 3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3695: -- JOB
3696: --
3697: FUNCTION get_elem_job_actual_cmmtmnts
3698: (
3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',

Line 3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3696: --
3697: FUNCTION get_elem_job_actual_cmmtmnts
3698: (
3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',
3704: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3697: FUNCTION get_elem_job_actual_cmmtmnts
3698: (
3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',
3704: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3705: )

Line 3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3698: (
3699: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3700: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3701: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3702: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3703: p_value_type IN varchar2 DEFAULT 'T',
3704: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3705: )
3706: RETURN NUMBER IS

Line 3711: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3707: /*
3708: */
3709:
3710: l_proc varchar2(72) := g_package||'get_elem_job_actual_cmmtmnts';
3711: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3712: l_job_id pqh_budget_details.job_id%TYPE;
3713: l_total_amt NUMBER := 0;
3714: l_curr_job_tot NUMBER := 0;
3715:

Line 3712: l_job_id pqh_budget_details.job_id%TYPE;

3708: */
3709:
3710: l_proc varchar2(72) := g_package||'get_elem_job_actual_cmmtmnts';
3711: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3712: l_job_id pqh_budget_details.job_id%TYPE;
3713: l_total_amt NUMBER := 0;
3714: l_curr_job_tot NUMBER := 0;
3715:
3716: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3720: CURSOR csr_bdgt_jobs(p_business_group_id number) IS
3721: SELECT DISTINCT
3722: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3723: bdt.job_id,
3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,

Line 3726: pqh_budgets bgt,

3722: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3723: bdt.job_id,
3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,

Line 3727: pqh_budget_versions bvr,

3723: bdt.job_id,
3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel

Line 3728: pqh_budget_details bdt,

3724: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel
3732: WHERE

Line 3729: pqh_budget_periods bpr,

3725: FROM
3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel
3732: WHERE
3733: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3730: pqh_budget_sets bst,

3726: pqh_budgets bgt,
3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel
3732: WHERE
3733: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3734: AND bgt.budget_id = bvr.budget_id

Line 3731: pqh_budget_elements bel

3727: pqh_budget_versions bvr,
3728: pqh_budget_details bdt,
3729: pqh_budget_periods bpr,
3730: pqh_budget_sets bst,
3731: pqh_budget_elements bel
3732: WHERE
3733: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3734: AND bgt.budget_id = bvr.budget_id
3735: AND bvr.budget_version_id = bdt.budget_version_id

Line 3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3802: -- GRADE
3803: --
3804: FUNCTION get_elem_grde_actual_cmmtmnts
3805: (
3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',

Line 3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3803: --
3804: FUNCTION get_elem_grde_actual_cmmtmnts
3805: (
3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',
3811: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3804: FUNCTION get_elem_grde_actual_cmmtmnts
3805: (
3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',
3811: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3812: )

Line 3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3805: (
3806: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3807: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3808: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3809: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3810: p_value_type IN varchar2 DEFAULT 'T',
3811: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3812: )
3813: RETURN NUMBER IS

Line 3818: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3814: /*
3815: */
3816:
3817: l_proc varchar2(72) := g_package||'get_elem_grde_actual_cmmtmnts';
3818: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3819: l_grade_id pqh_budget_details.grade_id%TYPE;
3820: l_total_amt NUMBER := 0;
3821: l_curr_grade_tot NUMBER := 0;
3822:

Line 3819: l_grade_id pqh_budget_details.grade_id%TYPE;

3815: */
3816:
3817: l_proc varchar2(72) := g_package||'get_elem_grde_actual_cmmtmnts';
3818: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3819: l_grade_id pqh_budget_details.grade_id%TYPE;
3820: l_total_amt NUMBER := 0;
3821: l_curr_grade_tot NUMBER := 0;
3822:
3823: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3827: CURSOR csr_bdgt_grades(p_business_group_id number) IS
3828: SELECT DISTINCT
3829: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3830: bdt.grade_id,
3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,

Line 3833: pqh_budgets bgt,

3829: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3830: bdt.grade_id,
3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,

Line 3834: pqh_budget_versions bvr,

3830: bdt.grade_id,
3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel

Line 3835: pqh_budget_details bdt,

3831: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel
3839: WHERE

Line 3836: pqh_budget_periods bpr,

3832: FROM
3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel
3839: WHERE
3840: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3837: pqh_budget_sets bst,

3833: pqh_budgets bgt,
3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel
3839: WHERE
3840: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3841: AND bgt.budget_id = bvr.budget_id

Line 3838: pqh_budget_elements bel

3834: pqh_budget_versions bvr,
3835: pqh_budget_details bdt,
3836: pqh_budget_periods bpr,
3837: pqh_budget_sets bst,
3838: pqh_budget_elements bel
3839: WHERE
3840: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3841: AND bgt.budget_id = bvr.budget_id
3842: AND bvr.budget_version_id = bdt.budget_version_id

Line 3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

3909: -- ORGANIZATION
3910: --
3911: FUNCTION get_elem_orgn_actual_cmmtmnts
3912: (
3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',

Line 3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,

3910: --
3911: FUNCTION get_elem_orgn_actual_cmmtmnts
3912: (
3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',
3918: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,

3911: FUNCTION get_elem_orgn_actual_cmmtmnts
3912: (
3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',
3918: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3919: )

Line 3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

3912: (
3913: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
3914: p_start_date IN pqh_budgets.budget_start_date%TYPE,
3915: p_end_date IN pqh_budgets.budget_end_date%TYPE,
3916: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
3917: p_value_type IN varchar2 DEFAULT 'T',
3918: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
3919: )
3920: RETURN NUMBER IS

Line 3925: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;

3921: /*
3922: */
3923:
3924: l_proc varchar2(72) := g_package||'get_elem_orgn_actual_cmmtmnts';
3925: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3926: l_organization_id pqh_budget_details.organization_id%TYPE;
3927: l_total_amt NUMBER := 0;
3928: l_curr_orgn_tot NUMBER := 0;
3929:

Line 3926: l_organization_id pqh_budget_details.organization_id%TYPE;

3922: */
3923:
3924: l_proc varchar2(72) := g_package||'get_elem_orgn_actual_cmmtmnts';
3925: l_budget_version_id pqh_budget_versions.budget_version_id%TYPE;
3926: l_organization_id pqh_budget_details.organization_id%TYPE;
3927: l_total_amt NUMBER := 0;
3928: l_curr_orgn_tot NUMBER := 0;
3929:
3930: l_currency_code fnd_currencies.currency_code%TYPE;

Line 3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE

3934: CURSOR csr_bdgt_orgs(p_business_group_id number) IS
3935: SELECT DISTINCT
3936: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3937: bdt.organization_id,
3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,

Line 3940: pqh_budgets bgt,

3936: bvr.BUDGET_VERSION_ID BUDGET_VERSION_ID,
3937: bdt.organization_id,
3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,

Line 3941: pqh_budget_versions bvr,

3937: bdt.organization_id,
3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel

Line 3942: pqh_budget_details bdt,

3938: pqh_budget.get_currency_cd(bgt.budget_id) CURRENCY_CODE
3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel
3946: WHERE

Line 3943: pqh_budget_periods bpr,

3939: FROM
3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel
3946: WHERE
3947: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )

Line 3944: pqh_budget_sets bst,

3940: pqh_budgets bgt,
3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel
3946: WHERE
3947: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3948: AND bgt.budget_id = bvr.budget_id

Line 3945: pqh_budget_elements bel

3941: pqh_budget_versions bvr,
3942: pqh_budget_details bdt,
3943: pqh_budget_periods bpr,
3944: pqh_budget_sets bst,
3945: pqh_budget_elements bel
3946: WHERE
3947: bgt.business_group_id = NVL(p_business_group_id, bgt.business_group_id )
3948: AND bgt.budget_id = bvr.budget_id
3949: AND bvr.budget_version_id = bdt.budget_version_id

Line 4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4016:
4017: ---------------------------------------------------------------------------------------------------------
4018: FUNCTION get_position_type
4019: (
4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4018: FUNCTION get_position_type
4019: (
4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4026: )

Line 4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4019: (
4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4026: )
4027: RETURN VARCHAR2 IS

Line 4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4020: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4021: p_position_id IN per_positions.position_id%TYPE,
4022: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4023: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4024: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4025: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4026: )
4027: RETURN VARCHAR2 IS
4028: /*

Line 4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4113: --
4114: --
4115: FUNCTION check_pos_type_and_variance
4116: (
4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4118: p_position_id IN per_positions.position_id%TYPE,
4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4115: FUNCTION check_pos_type_and_variance
4116: (
4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4118: p_position_id IN per_positions.position_id%TYPE,
4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4122: p_position_type IN VARCHAR2 DEFAULT 'Y',
4123: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4116: (
4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4118: p_position_id IN per_positions.position_id%TYPE,
4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4122: p_position_type IN VARCHAR2 DEFAULT 'Y',
4123: p_variance_prcnt IN NUMBER DEFAULT 0,
4124: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4117: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4118: p_position_id IN per_positions.position_id%TYPE,
4119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4122: p_position_type IN VARCHAR2 DEFAULT 'Y',
4123: p_variance_prcnt IN NUMBER DEFAULT 0,
4124: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4125: )

Line 4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4247: -- This function checks whether a job is Under or Over budgeted and returns the type 'U' or 'O' or 'A'
4248: --
4249: FUNCTION check_job_type_and_variance
4250: (
4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4252: p_job_id IN per_jobs.job_id%TYPE,
4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4249: FUNCTION check_job_type_and_variance
4250: (
4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4252: p_job_id IN per_jobs.job_id%TYPE,
4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4256: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4257: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4250: (
4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4252: p_job_id IN per_jobs.job_id%TYPE,
4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4256: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4257: p_variance_prcnt IN NUMBER DEFAULT 0,
4258: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4251: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4252: p_job_id IN per_jobs.job_id%TYPE,
4253: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4254: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4255: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4256: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4257: p_variance_prcnt IN NUMBER DEFAULT 0,
4258: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4259: )

Line 4390: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4386: --
4387:
4388: FUNCTION check_grde_type_and_variance
4389: (
4390: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4391: p_grade_id IN per_grades.grade_id%TYPE,
4392: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4392: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4388: FUNCTION check_grde_type_and_variance
4389: (
4390: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4391: p_grade_id IN per_grades.grade_id%TYPE,
4392: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4395: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4396: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4389: (
4390: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4391: p_grade_id IN per_grades.grade_id%TYPE,
4392: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4395: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4396: p_variance_prcnt IN NUMBER DEFAULT 0,
4397: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4390: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4391: p_grade_id IN per_grades.grade_id%TYPE,
4392: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4393: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4394: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4395: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4396: p_variance_prcnt IN NUMBER DEFAULT 0,
4397: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4398: )

Line 4527: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4523: -- This function checks whether an organization is Under or Over budgeted and returns the type 'U' or 'O' or 'A'
4524: --
4525: FUNCTION check_orgn_type_and_variance
4526: (
4527: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4528: p_organization_id IN hr_organization_units.organization_id%TYPE,
4529: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4529: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4525: FUNCTION check_orgn_type_and_variance
4526: (
4527: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4528: p_organization_id IN hr_organization_units.organization_id%TYPE,
4529: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4532: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4533: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4526: (
4527: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4528: p_organization_id IN hr_organization_units.organization_id%TYPE,
4529: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4532: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4533: p_variance_prcnt IN NUMBER DEFAULT 0,
4534: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4527: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4528: p_organization_id IN hr_organization_units.organization_id%TYPE,
4529: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4530: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4531: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4532: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4533: p_variance_prcnt IN NUMBER DEFAULT 0,
4534: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4535: )

Line 4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4660: -- This function is a wrapper which calls other functions depending on the budgeted entity code.
4661: --
4662: FUNCTION check_ent_type_and_variance
4663: (
4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

4661: --
4662: FUNCTION check_ent_type_and_variance
4663: (
4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4666: p_entity_id IN pqh_budget_details.position_id%TYPE,

4662: FUNCTION check_ent_type_and_variance
4663: (
4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',

Line 4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4663: (
4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4671: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4664: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4671: p_variance_prcnt IN NUMBER DEFAULT 0,
4672: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4665: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4666: p_entity_id IN pqh_budget_details.position_id%TYPE,
4667: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4668: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4669: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4670: p_entity_type IN VARCHAR2 DEFAULT 'Y',
4671: p_variance_prcnt IN NUMBER DEFAULT 0,
4672: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4673: )

Line 4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4755: --
4756:
4757: FUNCTION get_ent_element_bdgt_amt
4758: (
4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

4756:
4757: FUNCTION get_ent_element_bdgt_amt
4758: (
4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 4761: p_entity_id IN pqh_budget_details.position_id%TYPE,

4757: FUNCTION get_ent_element_bdgt_amt
4758: (
4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

4758: (
4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4759: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4767: )

Line 4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4760: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4767: )
4768:

Line 4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4761: p_entity_id IN pqh_budget_details.position_id%TYPE,
4762: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4763: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4764: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4765: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4766: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4767: )
4768:
4769: RETURN NUMBER IS

Line 4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,

4841: -- ENTITY
4842: --
4843: FUNCTION get_ent_elmnt_actual_cmmtmnts
4844: (
4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

4842: --
4843: FUNCTION get_ent_elmnt_actual_cmmtmnts
4844: (
4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 4847: p_entity_id IN pqh_budget_details.position_id%TYPE,

4843: FUNCTION get_ent_elmnt_actual_cmmtmnts
4844: (
4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

4844: (
4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4852: p_value_type IN varchar2 DEFAULT 'T',

Line 4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4845: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4852: p_value_type IN varchar2 DEFAULT 'T',
4853: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4846: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4852: p_value_type IN varchar2 DEFAULT 'T',
4853: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4854: )

Line 4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4847: p_entity_id IN pqh_budget_details.position_id%TYPE,
4848: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4849: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4850: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4851: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4852: p_value_type IN varchar2 DEFAULT 'T',
4853: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4854: )
4855: RETURN NUMBER IS

Line 4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

4932: -- ENTITY
4933: --
4934: FUNCTION get_elem_ent_budget_amt
4935: (
4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

4933: --
4934: FUNCTION get_elem_ent_budget_amt
4935: (
4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,

4934: FUNCTION get_elem_ent_budget_amt
4935: (
4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4942: )

Line 4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,

4935: (
4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4942: )
4943: RETURN NUMBER IS

Line 4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

4936: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
4937: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
4938: p_start_date IN pqh_budgets.budget_start_date%TYPE,
4939: p_end_date IN pqh_budgets.budget_end_date%TYPE,
4940: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
4941: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
4942: )
4943: RETURN NUMBER IS
4944:

Line 5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,

5002: --
5003: --
5004: FUNCTION get_elem_ent_actual_cmmtmnts
5005: (
5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

5003: --
5004: FUNCTION get_elem_ent_actual_cmmtmnts
5005: (
5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
5011: p_value_type IN varchar2 DEFAULT 'T',

Line 5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,

5004: FUNCTION get_elem_ent_actual_cmmtmnts
5005: (
5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
5011: p_value_type IN varchar2 DEFAULT 'T',
5012: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,

5005: (
5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
5011: p_value_type IN varchar2 DEFAULT 'T',
5012: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
5013: )

Line 5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

5006: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
5007: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
5008: p_start_date IN pqh_budgets.budget_start_date%TYPE,
5009: p_end_date IN pqh_budgets.budget_end_date%TYPE,
5010: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
5011: p_value_type IN varchar2 DEFAULT 'T',
5012: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
5013: )
5014: RETURN NUMBER IS