eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_MGMT_RPT_PKG dependencies on PQH_BUDGETS

Line 9: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 10: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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',
13: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
14: )

Line 11: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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',
13: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
14: )
15: RETURN NUMBER;

Line 44: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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
48: )

Line 45: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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
48: )
49: RETURN NUMBER;

Line 46: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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
48: )
49: RETURN NUMBER;
50: --

Line 57: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 58: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
60: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
61: )
62: RETURN NUMBER;

Line 59: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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,
60: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
61: )
62: RETURN NUMBER;
63: --

Line 70: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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
73: )
74: RETURN NUMBER;

Line 71: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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
73: )
74: RETURN NUMBER;
75: --

Line 72: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE

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
73: )
74: RETURN NUMBER;
75: --
76: --

Line 82: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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,
85: p_value_type IN varchar2 DEFAULT 'T',
86: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 83: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
85: p_value_type IN varchar2 DEFAULT 'T',
86: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
87: )

Line 84: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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,
85: p_value_type IN varchar2 DEFAULT 'T',
86: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
87: )
88: RETURN NUMBER;

Line 96: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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

Line 97: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
99: p_value_type IN varchar2 DEFAULT 'T'
100: )
101: RETURN NUMBER;

Line 98: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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,
99: p_value_type IN varchar2 DEFAULT 'T'
100: )
101: RETURN NUMBER;
102: --

Line 108: p_start_date IN pqh_budgets.budget_start_date%TYPE,

104: --
105: FUNCTION get_org_posn_budget_amt
106: (
107: p_organization_id IN pqh_budget_details.organization_id%TYPE,
108: p_start_date IN pqh_budgets.budget_start_date%TYPE,
109: p_end_date IN pqh_budgets.budget_end_date%TYPE,
110: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
111: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
112: )

Line 109: p_end_date IN pqh_budgets.budget_end_date%TYPE,

105: FUNCTION get_org_posn_budget_amt
106: (
107: p_organization_id IN pqh_budget_details.organization_id%TYPE,
108: p_start_date IN pqh_budgets.budget_start_date%TYPE,
109: p_end_date IN pqh_budgets.budget_end_date%TYPE,
110: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
111: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
112: )
113: RETURN NUMBER;

Line 110: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

106: (
107: p_organization_id IN pqh_budget_details.organization_id%TYPE,
108: p_start_date IN pqh_budgets.budget_start_date%TYPE,
109: p_end_date IN pqh_budgets.budget_end_date%TYPE,
110: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
111: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
112: )
113: RETURN NUMBER;
114: --

Line 119: p_start_date IN pqh_budgets.budget_start_date%TYPE,

115: --
116: FUNCTION get_org_posn_actual_cmmtmnts
117: (
118: p_organization_id IN pqh_budget_details.organization_id%TYPE,
119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
122: p_value_type IN varchar2 DEFAULT 'T',
123: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 120: p_end_date IN pqh_budgets.budget_end_date%TYPE,

116: FUNCTION get_org_posn_actual_cmmtmnts
117: (
118: p_organization_id IN pqh_budget_details.organization_id%TYPE,
119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
122: p_value_type IN varchar2 DEFAULT 'T',
123: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
124: )

Line 121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

117: (
118: p_organization_id IN pqh_budget_details.organization_id%TYPE,
119: p_start_date IN pqh_budgets.budget_start_date%TYPE,
120: p_end_date IN pqh_budgets.budget_end_date%TYPE,
121: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
122: p_value_type IN varchar2 DEFAULT 'T',
123: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
124: )
125: RETURN NUMBER;

Line 130: p_business_group_id IN pqh_budgets.business_group_id%TYPE,

126: --
127: --
128: FUNCTION get_bgrp_posn_budget_amt
129: (
130: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
131: p_start_date IN pqh_budgets.budget_start_date%TYPE,
132: p_end_date IN pqh_budgets.budget_end_date%TYPE,
133: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
134: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 131: p_start_date IN pqh_budgets.budget_start_date%TYPE,

127: --
128: FUNCTION get_bgrp_posn_budget_amt
129: (
130: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
131: p_start_date IN pqh_budgets.budget_start_date%TYPE,
132: p_end_date IN pqh_budgets.budget_end_date%TYPE,
133: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
134: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
135: )

Line 132: p_end_date IN pqh_budgets.budget_end_date%TYPE,

128: FUNCTION get_bgrp_posn_budget_amt
129: (
130: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
131: p_start_date IN pqh_budgets.budget_start_date%TYPE,
132: p_end_date IN pqh_budgets.budget_end_date%TYPE,
133: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
134: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
135: )
136: RETURN NUMBER;

Line 133: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

129: (
130: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
131: p_start_date IN pqh_budgets.budget_start_date%TYPE,
132: p_end_date IN pqh_budgets.budget_end_date%TYPE,
133: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
134: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
135: )
136: RETURN NUMBER;
137: --

Line 141: p_business_group_id IN pqh_budgets.business_group_id%TYPE,

137: --
138: --
139: FUNCTION get_bgrp_posn_actual_cmmtmnts
140: (
141: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
142: p_start_date IN pqh_budgets.budget_start_date%TYPE,
143: p_end_date IN pqh_budgets.budget_end_date%TYPE,
144: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
145: p_value_type IN varchar2 DEFAULT 'T',

Line 142: p_start_date IN pqh_budgets.budget_start_date%TYPE,

138: --
139: FUNCTION get_bgrp_posn_actual_cmmtmnts
140: (
141: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
142: p_start_date IN pqh_budgets.budget_start_date%TYPE,
143: p_end_date IN pqh_budgets.budget_end_date%TYPE,
144: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
145: p_value_type IN varchar2 DEFAULT 'T',
146: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 143: p_end_date IN pqh_budgets.budget_end_date%TYPE,

139: FUNCTION get_bgrp_posn_actual_cmmtmnts
140: (
141: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
142: p_start_date IN pqh_budgets.budget_start_date%TYPE,
143: p_end_date IN pqh_budgets.budget_end_date%TYPE,
144: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
145: p_value_type IN varchar2 DEFAULT 'T',
146: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
147: )

Line 144: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

140: (
141: p_business_group_id IN pqh_budgets.business_group_id%TYPE,
142: p_start_date IN pqh_budgets.budget_start_date%TYPE,
143: p_end_date IN pqh_budgets.budget_end_date%TYPE,
144: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
145: p_value_type IN varchar2 DEFAULT 'T',
146: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
147: )
148: RETURN NUMBER;

Line 154: p_start_date IN pqh_budgets.budget_start_date%TYPE,

150: --
151: FUNCTION get_elem_posn_budget_amt
152: (
153: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
154: p_start_date IN pqh_budgets.budget_start_date%TYPE,
155: p_end_date IN pqh_budgets.budget_end_date%TYPE,
156: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
157: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
158: )

Line 155: p_end_date IN pqh_budgets.budget_end_date%TYPE,

151: FUNCTION get_elem_posn_budget_amt
152: (
153: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
154: p_start_date IN pqh_budgets.budget_start_date%TYPE,
155: p_end_date IN pqh_budgets.budget_end_date%TYPE,
156: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
157: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
158: )
159: RETURN NUMBER;

Line 156: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

152: (
153: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
154: p_start_date IN pqh_budgets.budget_start_date%TYPE,
155: p_end_date IN pqh_budgets.budget_end_date%TYPE,
156: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
157: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
158: )
159: RETURN NUMBER;
160: --

Line 165: p_start_date IN pqh_budgets.budget_start_date%TYPE,

161: --
162: FUNCTION get_elem_posn_actual_cmmtmnts
163: (
164: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
165: p_start_date IN pqh_budgets.budget_start_date%TYPE,
166: p_end_date IN pqh_budgets.budget_end_date%TYPE,
167: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
168: p_value_type IN varchar2 DEFAULT 'T',
169: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 166: p_end_date IN pqh_budgets.budget_end_date%TYPE,

162: FUNCTION get_elem_posn_actual_cmmtmnts
163: (
164: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
165: p_start_date IN pqh_budgets.budget_start_date%TYPE,
166: p_end_date IN pqh_budgets.budget_end_date%TYPE,
167: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
168: p_value_type IN varchar2 DEFAULT 'T',
169: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
170: )

Line 167: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

163: (
164: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
165: p_start_date IN pqh_budgets.budget_start_date%TYPE,
166: p_end_date IN pqh_budgets.budget_end_date%TYPE,
167: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
168: p_value_type IN varchar2 DEFAULT 'T',
169: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
170: )
171: RETURN NUMBER;

Line 178: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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
182: )

Line 179: p_end_date IN pqh_budgets.budget_end_date%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
182: )
183: RETURN VARCHAR2;

Line 180: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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
182: )
183: RETURN VARCHAR2;
184: --

Line 191: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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',
195: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 192: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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',
195: p_variance_prcnt IN NUMBER DEFAULT 0,
196: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 193: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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',
195: p_variance_prcnt IN NUMBER DEFAULT 0,
196: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
197: )

Line 204: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

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

Line 206: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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,
208: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
209: p_entity_type IN VARCHAR2 DEFAULT 'Y',
210: p_variance_prcnt IN NUMBER DEFAULT 0,

Line 207: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
208: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
209: p_entity_type IN VARCHAR2 DEFAULT 'Y',
210: p_variance_prcnt IN NUMBER DEFAULT 0,
211: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 208: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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,
208: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
209: p_entity_type IN VARCHAR2 DEFAULT 'Y',
210: p_variance_prcnt IN NUMBER DEFAULT 0,
211: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
212: )

Line 220: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

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,
224: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 223: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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,
224: p_end_date IN pqh_budgets.budget_end_date%TYPE,
225: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
226: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
227: )

Line 224: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
224: p_end_date IN pqh_budgets.budget_end_date%TYPE,
225: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
226: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
227: )
228:

Line 225: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%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,
224: p_end_date IN pqh_budgets.budget_end_date%TYPE,
225: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
226: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
227: )
228:
229: RETURN NUMBER;

Line 235: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

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,
239: p_end_date IN pqh_budgets.budget_end_date%TYPE,

Line 238: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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,
239: p_end_date IN pqh_budgets.budget_end_date%TYPE,
240: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
241: p_value_type IN varchar2 DEFAULT 'T',
242: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 239: p_end_date IN pqh_budgets.budget_end_date%TYPE,

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,
239: p_end_date IN pqh_budgets.budget_end_date%TYPE,
240: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
241: p_value_type IN varchar2 DEFAULT 'T',
242: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
243: )

Line 240: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%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,
239: p_end_date IN pqh_budgets.budget_end_date%TYPE,
240: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
241: p_value_type IN varchar2 DEFAULT 'T',
242: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
243: )
244: RETURN NUMBER;

Line 250: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

246: --
247: FUNCTION get_elem_ent_budget_amt
248: (
249: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
250: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
251: p_start_date IN pqh_budgets.budget_start_date%TYPE,
252: p_end_date IN pqh_budgets.budget_end_date%TYPE,
253: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
254: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 251: p_start_date IN pqh_budgets.budget_start_date%TYPE,

247: FUNCTION get_elem_ent_budget_amt
248: (
249: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
250: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
251: p_start_date IN pqh_budgets.budget_start_date%TYPE,
252: p_end_date IN pqh_budgets.budget_end_date%TYPE,
253: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
254: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
255: )

Line 252: p_end_date IN pqh_budgets.budget_end_date%TYPE,

248: (
249: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
250: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
251: p_start_date IN pqh_budgets.budget_start_date%TYPE,
252: p_end_date IN pqh_budgets.budget_end_date%TYPE,
253: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
254: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
255: )
256: RETURN NUMBER;

Line 253: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

249: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
250: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
251: p_start_date IN pqh_budgets.budget_start_date%TYPE,
252: p_end_date IN pqh_budgets.budget_end_date%TYPE,
253: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
254: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
255: )
256: RETURN NUMBER;
257: --

Line 262: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

258: --
259: FUNCTION get_elem_ent_actual_cmmtmnts
260: (
261: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
262: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
263: p_start_date IN pqh_budgets.budget_start_date%TYPE,
264: p_end_date IN pqh_budgets.budget_end_date%TYPE,
265: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
266: p_value_type IN varchar2 DEFAULT 'T',

Line 263: p_start_date IN pqh_budgets.budget_start_date%TYPE,

259: FUNCTION get_elem_ent_actual_cmmtmnts
260: (
261: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
262: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
263: p_start_date IN pqh_budgets.budget_start_date%TYPE,
264: p_end_date IN pqh_budgets.budget_end_date%TYPE,
265: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
266: p_value_type IN varchar2 DEFAULT 'T',
267: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 264: p_end_date IN pqh_budgets.budget_end_date%TYPE,

260: (
261: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
262: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
263: p_start_date IN pqh_budgets.budget_start_date%TYPE,
264: p_end_date IN pqh_budgets.budget_end_date%TYPE,
265: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
266: p_value_type IN varchar2 DEFAULT 'T',
267: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
268: )

Line 265: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

261: p_element_type_id IN pqh_budget_elements.element_type_id%TYPE,
262: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,
263: p_start_date IN pqh_budgets.budget_start_date%TYPE,
264: p_end_date IN pqh_budgets.budget_end_date%TYPE,
265: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
266: p_value_type IN varchar2 DEFAULT 'T',
267: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
268: )
269: RETURN NUMBER;

Line 283: p_budgeted_entity_cd IN pqh_budgets.budgeted_entity_cd%TYPE,

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,
287: p_start_date IN pqh_budgets.budget_start_date%TYPE,

Line 287: p_start_date IN pqh_budgets.budget_start_date%TYPE,

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,
287: p_start_date IN pqh_budgets.budget_start_date%TYPE,
288: p_end_date IN pqh_budgets.budget_end_date%TYPE,
289: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
290: p_value_type IN varchar2 DEFAULT 'T',
291: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

Line 288: p_end_date IN pqh_budgets.budget_end_date%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,
287: p_start_date IN pqh_budgets.budget_start_date%TYPE,
288: p_end_date IN pqh_budgets.budget_end_date%TYPE,
289: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
290: p_value_type IN varchar2 DEFAULT 'T',
291: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
292: )

Line 289: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,

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,
287: p_start_date IN pqh_budgets.budget_start_date%TYPE,
288: p_end_date IN pqh_budgets.budget_end_date%TYPE,
289: p_unit_of_measure_id IN pqh_budgets.budget_unit1_id%TYPE,
290: p_value_type IN varchar2 DEFAULT 'T',
291: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL
292: )
293: RETURN NUMBER;