PACKAGE: APPS.CN_COLLECTION_AIA_OM_PUB

Source

1 PACKAGE CN_COLLECTION_AIA_OM_PUB AUTHID CURRENT_USER AS
2   /* $Header: CNPCLTROMS.pls 120.1 2010/10/26 10:42:25 sseshaiy noship $*/
3 
4 
5   -- Function name  : get_exchange_rate
6   -- Type : Public.
7   -- Pre-reqs :
8 
9   FUNCTION get_exchange_rate(p_from_currency IN cn_aia_order_capture.amt_curcy_cd%TYPE,
10                              p_conversion_date IN cn_aia_order_capture.processed_date%TYPE,
11                              p_org_id IN cn_aia_order_capture.org_id%TYPE)
12                               RETURN cn_aia_order_capture.exchange_rate%TYPE;
13 
14 
15    -- Function name  : get_employee_number
16   -- Type : Public.
17   -- Pre-reqs :
18 
19    FUNCTION get_employee_number(p_salesrep_id IN cn_aia_order_capture.salesrep_id%TYPE,
20                                 p_org_id cn_aia_order_capture.org_id%TYPE)
21                                   RETURN cn_aia_order_capture.employee_number%TYPE;
22 
23    -- API name  : pre_aia_om_load_process
24   -- Type : Public.
25   -- Pre-reqs :
26   -- Usage :
27   --+
28   -- Desc  :
29   --
30   --
31 
32   PROCEDURE pre_aia_om_load_process(errbuf OUT nocopy VARCHAR2,
33                                     retcode OUT nocopy NUMBER,
34                                     p_org_id IN NUMBER
35                                     );
36 
37   -- API name  : post_aia_om_load_process
38   -- Type : Public.
39   -- Pre-reqs :
40   -- Usage :
41   --+
42   -- Desc  :
43   --
44   --
45   PROCEDURE post_aia_om_load_process(x_return_status OUT nocopy VARCHAR2);
46 
47 
48 
49 END CN_COLLECTION_AIA_OM_PUB;