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.PA_MULTI_CURRENCY dependencies on PA_MULTI_CURRENCY

Line 1: PACKAGE BODY pa_multi_currency AS

1: PACKAGE BODY pa_multi_currency AS
2: --$Header: PAXTMCTB.pls 120.3.12010000.2 2009/03/12 14:25:06 spasala ship $
3:
4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;
5: ------------------------------------------------------------------------------

Line 6: -- Function pa_multi_currency.check_rate_date_code.

2: --$Header: PAXTMCTB.pls 120.3.12010000.2 2009/03/12 14:25:06 spasala ship $
3:
4: P_DEBUG_MODE BOOLEAN := pa_cc_utils.g_debug_mode;
5: ------------------------------------------------------------------------------
6: -- Function pa_multi_currency.check_rate_date_code.
7: -- Comments for the function are at the package specification level
8: ------------------------------------------------------------------------------
9: FUNCTION check_rate_date_code
10: RETURN varchar2 IS

Line 24: -- Function pa_multi_currency.get_rate_type.

20: RETURN l_rate_date_code ;
21: END check_rate_date_code ;
22:
23: ------------------------------------------------------------------------------
24: -- Function pa_multi_currency.get_rate_type.
25: -- Comments for the function are at the package specification level
26: ------------------------------------------------------------------------------
27: FUNCTION get_rate_type
28: RETURN VARCHAR2 IS

Line 43: -- Function pa_multi_currency.get_acct_currency_code.

39:
40: END get_rate_type ;
41:
42: ------------------------------------------------------------------------------
43: -- Function pa_multi_currency.get_acct_currency_code.
44: -- Comments for the function are at the package specification level
45: ------------------------------------------------------------------------------
46: FUNCTION get_acct_currency_code
47: RETURN varchar2 IS

Line 60: -- Function pa_multi_currency.is_user_rate_type_allowed.

56:
57: END get_acct_currency_code ;
58:
59: ------------------------------------------------------------------------------
60: -- Function pa_multi_currency.is_user_rate_type_allowed.
61: -- Comments for the function are at the package specification level
62: ------------------------------------------------------------------------------
63:
64: FUNCTION is_user_rate_type_allowed (P_from_currency VARCHAR2,

Line 100: -- Function pa_multi_currency.convert_amount.

96:
97: END is_user_rate_type_allowed ;
98:
99: ------------------------------------------------------------------------------
100: -- Function pa_multi_currency.convert_amount.
101: -- Comments for the function are at the package specification level
102: ------------------------------------------------------------------------------
103: PROCEDURE convert_amount (
104: P_from_currency IN VARCHAR2,

Line 166: RAISE pa_multi_currency.no_rate ;

162:
163: IF ( V_allow_user_rate_type = 'Y') then
164: /* Bug fix for bug 2753298 Starts Here */
165: IF (P_Rate IS NULL) THEN
166: RAISE pa_multi_currency.no_rate ;
167: END IF;
168: /* Bug fix for bug 2753298 Ends Here Here */
169: P_converted_amount := PA_CURRENCY.round_trans_currency_amt
170: (P_amount * NVL(P_Rate,1),P_to_currency) ;

Line 196: IF (pa_multi_currency_txn.G_calling_module = 'WORKPLAN') OR (pa_multi_currency_txn.G_calling_module = 'ASSIGNMENT') OR (pa_multi_currency_txn.G_calling_module = 'UNASSIGNED') OR (pa_multi_currency_txn.G_calling_module = 'ROLE') then

192: IF ( V_converted_amount = -1 ) THEN
193:
194: /* Bug 6058074 code begins */
195: --Bug 8243561: Modified below If condition to call convert_closest_amount_sql
196: IF (pa_multi_currency_txn.G_calling_module = 'WORKPLAN') OR (pa_multi_currency_txn.G_calling_module = 'ASSIGNMENT') OR (pa_multi_currency_txn.G_calling_module = 'UNASSIGNED') OR (pa_multi_currency_txn.G_calling_module = 'ROLE') then
197:
198: V_converted_amount := GL_CURRENCY_API.convert_closest_amount_sql
199: ( x_from_currency => P_from_currency ,
200: x_to_currency => P_to_currency ,

Line 211: RAISE pa_multi_currency.no_rate ;

207: END IF;
208:
209: /* Bug 6058074 code begins */
210: IF ( V_converted_amount = -1 ) THEN
211: RAISE pa_multi_currency.no_rate ;
212: END IF ;
213: ELSIF ( V_converted_amount = -2 ) THEN
214: RAISE pa_multi_currency.invalid_currency ;
215: END IF ;

Line 214: RAISE pa_multi_currency.invalid_currency ;

210: IF ( V_converted_amount = -1 ) THEN
211: RAISE pa_multi_currency.no_rate ;
212: END IF ;
213: ELSIF ( V_converted_amount = -2 ) THEN
214: RAISE pa_multi_currency.invalid_currency ;
215: END IF ;
216: -- P_converted_amount := V_converted_amount ;
217: P_converted_amount := V_converted_amount * v_factor ; -- Changing Converted Amount to Original Sign Bug 2419636
218:

Line 262: raise pa_multi_currency.invalid_currency;

258: P_rate := P_numerator / P_denominator;
259:
260: ELSE
261: IF (( P_numerator = -2 ) OR (P_denominator = -2 )) THEN
262: raise pa_multi_currency.invalid_currency;
263:
264: ELSE
265: raise pa_multi_currency.no_rate;
266: END IF;

Line 265: raise pa_multi_currency.no_rate;

261: IF (( P_numerator = -2 ) OR (P_denominator = -2 )) THEN
262: raise pa_multi_currency.invalid_currency;
263:
264: ELSE
265: raise pa_multi_currency.no_rate;
266: END IF;
267: END IF;
268:
269:

Line 274: WHEN pa_multi_currency.no_rate THEN

270:
271: END IF ;
272:
273: EXCEPTION
274: WHEN pa_multi_currency.no_rate THEN
275: IF (P_handle_exception_flag = 'Y') THEN
276: X_status := 'PA_NO_EXCH_RATE_EXISTS';
277: ELSE
278: RAISE;

Line 280: WHEN pa_multi_currency.invalid_currency THEN

276: X_status := 'PA_NO_EXCH_RATE_EXISTS';
277: ELSE
278: RAISE;
279: END IF;
280: WHEN pa_multi_currency.invalid_currency THEN
281: IF (P_handle_exception_flag = 'Y') THEN
282: X_status := 'PA_CURR_NOT_VALID';
283: ELSE
284: RAISE;

Line 292: -- Function pa_multi_currency.convert_amount_sql.

288:
289: END convert_amount;
290:
291: ------------------------------------------------------------------------------
292: -- Function pa_multi_currency.convert_amount_sql.
293: -- Comments for the function are at the package specification level
294: ------------------------------------------------------------------------------
295: --
296: -- Function

Line 342: WHEN pa_multi_currency.NO_RATE THEN

338: return( v_converted_amount );
339:
340: EXCEPTION
341:
342: WHEN pa_multi_currency.NO_RATE THEN
343: v_converted_amount := -1;
344: return( v_converted_amount );
345:
346: WHEN pa_multi_currency.INVALID_CURRENCY THEN

Line 346: WHEN pa_multi_currency.INVALID_CURRENCY THEN

342: WHEN pa_multi_currency.NO_RATE THEN
343: v_converted_amount := -1;
344: return( v_converted_amount );
345:
346: WHEN pa_multi_currency.INVALID_CURRENCY THEN
347: v_converted_amount := -2;
348: return( v_converted_amount );
349:
350: END convert_amount_sql;

Line 354: -- Function pa_multi_currency.convert_closest_amount.

350: END convert_amount_sql;
351:
352:
353: ------------------------------------------------------------------------------
354: -- Function pa_multi_currency.convert_closest_amount.
355: -- Comments for the function are at the package specification level
356: ------------------------------------------------------------------------------
357:
358: PROCEDURE convert_closest_amount

Line 481: -- Procedure pa_multi_currency.format_amount.

477: END convert_closest_amount;
478:
479:
480: ------------------------------------------------------------------------------
481: -- Procedure pa_multi_currency.format_amount.
482: -- Comments for the Procedure are at the package specification level
483: ------------------------------------------------------------------------------
484: PROCEDURE format_amount (P_currency IN VARCHAR2,
485: P_amount IN NUMBER,

Line 560: -- Function pa_multi_currency.validate_rate_type.

556: RAISE ;
557: END format_amount ;
558:
559: ------------------------------------------------------------------------------
560: -- Function pa_multi_currency.validate_rate_type.
561: -- Comments for the function are at the package specification level
562: ------------------------------------------------------------------------------
563: FUNCTION validate_rate_type ( P_rate_type VARCHAR2 )
564: RETURN varchar2 IS

Line 614: -- Function pa_multi_currency.validate_currency_code.

610: RAISE ;
611: END validate_rate_type ;
612:
613: ------------------------------------------------------------------------------
614: -- Function pa_multi_currency.validate_currency_code.
615: -- Comments for the function are at the package specification level
616: ------------------------------------------------------------------------------
617: FUNCTION validate_currency_code ( P_Currency_code VARCHAR2,
618: P_EI_date DATE )

Line 807: END pa_multi_currency ;

803: END IF;
804:
805: END Get_User_Conversion_Type ;
806:
807: END pa_multi_currency ;