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;
16: --
17: --
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: --
51: --
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: --
64: --
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;
89: --
90: --
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: --
115: --
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;
126: --
127: --
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: --
138: --
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;
149: --
150: --
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: --
161: --
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;
172: --
173: --
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: --
185: --
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: )
198: RETURN VARCHAR2;
199: --
200: --
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: )
213: RETURN VARCHAR2;
214: --
215: --
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;
230: --
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;
245: --
246: --
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: --
258: --
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;
270: --
271: --
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;
294:
295: Function GET_ENTITY_BUDGET_AMT( p_budgeted_entity_cd IN varchar2,