DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on PER_POSITIONS

Line 8: p_position_id IN per_positions.position_id%TYPE,

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,
12: p_value_type IN varchar2 DEFAULT 'T',

Line 43: p_position_id IN per_positions.position_id%TYPE,

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,
47: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 55: p_position_id IN per_positions.position_id%TYPE,

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,
59: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 68: p_position_id IN per_positions.position_id%TYPE,

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,
72: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

Line 80: p_position_id IN per_positions.position_id%TYPE,

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,
84: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 94: p_position_id IN per_positions.position_id%TYPE,

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,
98: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

Line 177: p_position_id IN per_positions.position_id%TYPE,

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,
181: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 190: p_position_id IN per_positions.position_id%TYPE,

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,
194: p_position_type IN VARCHAR2 DEFAULT 'Y',