APPS.PQH_MGMT_RPT_PKG dependencies on PQH_BUDGETS

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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