DBA Data[Home] [Help]

PACKAGE: APPS.AP_WEB_AMOUNT_UTIL

Source


1 PACKAGE ap_web_amount_util AS
2 /* $Header: apwamtus.pls 120.5 2006/07/14 09:41:22 sbalaji noship $ */
3 
4   procedure get_meaningful_rate(
5                p_userid        IN NUMBER,
6                p_date          IN DATE,
7                p_currency_code IN VARCHAR2,
8                p_success_flag       OUT NOCOPY VARCHAR2,    -- Y/N
9                p_conv_date          OUT NOCOPY DATE,
10                p_conv_rate          OUT NOCOPY NUMBER,
11                p_conv_currency_code IN OUT NOCOPY VARCHAR2);
12 
13    procedure get_meaningful_amount(
14                p_userid        IN NUMBER,
15                p_amount        IN NUMBER,
16                p_date          IN DATE,
17                p_currency_code IN VARCHAR2,
18                p_success_flag       OUT NOCOPY VARCHAR2,    -- Y/N
19                p_conv_amount        OUT NOCOPY NUMBER,
20                p_conv_currency_code IN  OUT NOCOPY VARCHAR2);
21 
22    procedure get_meaningful_amount_emp(
23                p_employee_id        IN NUMBER,
24                p_amount        IN NUMBER,
25                p_date          IN DATE,
26                p_currency_code IN VARCHAR2,
27                p_success_flag       OUT NOCOPY VARCHAR2,    -- Y/N
28                p_conv_amount        OUT NOCOPY NUMBER,
29                p_conv_currency_code OUT NOCOPY VARCHAR2);
30 
31    function get_meaningful_amount_msg(
32                p_userid        IN NUMBER,
33                p_amount        IN NUMBER,
34                p_date          IN DATE,
35                p_currency_code IN VARCHAR2,
36                p_out_currency_code IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2;
37 
38    function get_meaningful_amount_msg_emp(
39                p_employee_id   IN NUMBER,
40                p_amount        IN NUMBER,
41                p_date          IN DATE,
42                p_currency_code IN VARCHAR2,
43                p_out_currency_code IN VARCHAR2 DEFAULT NULL ) RETURN VARCHAR2;
44 
45 end ap_web_amount_util;