DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on PQH_BUDGET_VERSIONS

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

3: --
4: --
5: FUNCTION get_position_actual_cmmtmnts
6: (
7: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
8: p_position_id IN per_positions.position_id%TYPE,
9: p_start_date IN pqh_budgets.budget_start_date%TYPE,
10: p_end_date IN pqh_budgets.budget_end_date%TYPE,
11: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

38: --
39: --
40: FUNCTION get_position_budget_amt
41: (
42: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
43: p_position_id IN per_positions.position_id%TYPE,
44: p_start_date IN pqh_budgets.budget_start_date%TYPE,
45: p_end_date IN pqh_budgets.budget_end_date%TYPE,
46: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

50: --
51: --
52: FUNCTION get_posn_element_bdgt_amt
53: (
54: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
55: p_position_id IN per_positions.position_id%TYPE,
56: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
57: p_start_date IN pqh_budgets.budget_start_date%TYPE,
58: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

63: --
64: --
65: FUNCTION get_posn_bset_bdgt_amt
66: (
67: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
68: p_position_id IN per_positions.position_id%TYPE,
69: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
70: p_start_date IN pqh_budgets.budget_start_date%TYPE,
71: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

75: --
76: --
77: FUNCTION get_posn_elmnt_actual_cmmtmnts
78: (
79: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
80: p_position_id IN per_positions.position_id%TYPE,
81: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
82: p_start_date IN pqh_budgets.budget_start_date%TYPE,
83: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

89: --
90: --
91: FUNCTION get_posn_bset_actual_cmmtmnts
92: (
93: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
94: p_position_id IN per_positions.position_id%TYPE,
95: p_budget_set_id IN pqh_budget_sets.dflt_budget_set_id%TYPE,
96: p_start_date IN pqh_budgets.budget_start_date%TYPE,
97: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

172: --
173: --
174: FUNCTION get_position_type
175: (
176: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
177: p_position_id IN per_positions.position_id%TYPE,
178: p_start_date IN pqh_budgets.budget_start_date%TYPE,
179: p_end_date IN pqh_budgets.budget_end_date%TYPE,
180: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

185: --
186:
187: FUNCTION check_pos_type_and_variance
188: (
189: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
190: p_position_id IN per_positions.position_id%TYPE,
191: p_start_date IN pqh_budgets.budget_start_date%TYPE,
192: p_end_date IN pqh_budgets.budget_end_date%TYPE,
193: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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

199: --
200: --
201: FUNCTION check_ent_type_and_variance
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_entity_id IN pqh_budget_details.position_id%TYPE,
206: p_start_date IN pqh_budgets.budget_start_date%TYPE,
207: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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

215: --
216:
217: FUNCTION get_ent_element_bdgt_amt
218: (
219: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
220: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
221: p_entity_id IN pqh_budget_details.position_id%TYPE,
222: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
223: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

230: --
231: --
232: FUNCTION get_ent_elmnt_actual_cmmtmnts
233: (
234: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
235: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
236: p_entity_id IN pqh_budget_details.position_id%TYPE,
237: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
238: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

278: --
279: -- mvankada
280: FUNCTION get_entity_actual_cmmtmnts
281: (
282: p_budget_version_id IN pqh_budget_versions.budget_version_id%TYPE DEFAULT NULL,
283: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
284: p_job_id IN per_jobs.job_id%TYPE DEFAULT NULL,
285: p_grade_id IN per_grades.grade_id%TYPE DEFAULT NULL,
286: p_organization_id IN hr_organization_units.organization_id%TYPE DEFAULT NULL,