DBA Data[Home] [Help]

APPS.PQH_MGMT_RPT_PKG dependencies on FND_CURRENCIES

Line 13: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 47: p_currency_code IN fnd_currencies.currency_code%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: --
51: --

Line 60: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 86: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 111: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 123: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 134: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 146: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 157: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 169: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 181: p_currency_code IN fnd_currencies.currency_code%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: --
185: --

Line 196: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 211: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 226: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 242: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 254: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 267: p_currency_code IN fnd_currencies.currency_code%TYPE DEFAULT NULL

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

Line 291: p_currency_code IN fnd_currencies.currency_code%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;
294:
295: Function GET_ENTITY_BUDGET_AMT( p_budgeted_entity_cd IN varchar2,