PACKAGE: APPS.XTR_IAC_TRANSFERS_PKG

Source

1 PACKAGE XTR_IAC_TRANSFERS_PKG AUTHID CURRENT_USER AS
2 /* $Header: xtrimias.pls 120.1 2005/06/29 12:25:25 rjose noship $ */
3 --------------------------------------------------------------------------
4 
5   Procedure Log_IAC_Errors(p_Error_Code    In Varchar2,
6                            p_Field_Name    In Varchar2 DEFAULT NULL);
7 
8   function VALID_CURRENCY(p_curr IN VARCHAR2) return boolean;
9 
10 
11   function VALID_PARTY_ACCT(p_party      IN VARCHAR2,
12                             p_party_acct IN VARCHAR2,
13                             p_curr       IN VARCHAR2) return varchar2;
14 
15   function VALID_PRODUCT(p_product IN VARCHAR2) return boolean;
16 
17   function VALID_PORTFOLIO(p_comp      IN VARCHAR2,
18                            p_portfolio IN VARCHAR2) return boolean;
19 
20 
21   function VALID_DEALER_CODE(p_dealer_code IN varchar2) return boolean;
22 
23   function VALID_TRANSFER_AMOUNT (p_value IN NUMBER) return boolean;
24 
25   function VALID_DEAL_DATE (p_value IN DATE) return boolean;
26 
27   procedure CHECK_MANDATORY_FIELDS(
28 				ARec_IAC IN XTR_INTERACCT_TRANSFERS%rowtype,
29 				p_error OUT NOCOPY BOOLEAN);
30 
31   procedure VALIDATE_DEALS(ARec_IAC         IN  XTR_INTERACCT_TRANSFERS%rowtype,
32                            p_Bank_Code_From OUT NOCOPY VARCHAR2,
33                            p_Bank_Code_To   OUT NOCOPY VARCHAR2,
34                            p_error          OUT NOCOPY BOOLEAN);
35 
36   procedure VALIDATE_SETTLE_DDA (p_validate_flag IN  BOOLEAN,
37                                  p_settle_flag   IN  BOOLEAN,
38                                  p_actual_settle IN  DATE,
39                                  p_dual_auth_by  OUT NOCOPY VARCHAR2,
40                                  p_dual_auth_on  OUT NOCOPY DATE,
41                                  p_settle        OUT NOCOPY VARCHAR2,
42                                  p_settle_no     OUT NOCOPY NUMBER,
43                                  p_settle_no2    OUT NOCOPY NUMBER,
44                                  p_settle_auth   OUT NOCOPY VARCHAR2,
45                                  p_settle_date   OUT NOCOPY DATE,
46                                  p_trans_mts     OUT NOCOPY VARCHAR2,
47                                  p_audit_indic   OUT NOCOPY VARCHAR2);
48 
49 
50   procedure INS_DEAL_DATE_AMTS (
51 		ARec_IAC      IN  XTR_INTERACCT_TRANSFERS%rowtype,
52                 p_From_Bank   IN  XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
53                 p_To_Bank     IN  XTR_DEAL_DATE_AMOUNTS.LIMIT_PARTY%TYPE,
54                 p_tran_num    IN  NUMBER,
55                 p_Validated   IN  BOOLEAN,
56                 p_Settled     IN  BOOLEAN );
57 
58   procedure CREATE_IAC_DEAL(ARec_IAC      IN  XTR_INTERACCT_TRANSFERS%rowtype,
59                             p_Validated   IN  BOOLEAN,
60                             p_tran_num    IN  NUMBER);
61 
62   procedure TRANSFER_IAC_DEALS(
63 			ARec_IAC           IN  XTR_INTERACCT_TRANSFERS%rowtype,
64                         p_Validated        IN  BOOLEAN,
65                         p_Settled          IN  BOOLEAN,
66                         user_error         OUT NOCOPY BOOLEAN,
67                         mandatory_error    OUT NOCOPY BOOLEAN,
68                         validation_error   OUT NOCOPY BOOLEAN,
69                         p_tran_num         OUT NOCOPY NUMBER);
70 
71   G_iac_user   xtr_dealer_codes.dealer_code%TYPE;
72   G_iac_date   DATE;
73   G_sys_date   DATE;
74 
75  -- Constants  ----------------------------------------------------------------
76   C_iac_type       constant VARCHAR2(3)  := 'IAC';
77   C_ZBA            constant VARCHAR2(3)  := 'ZBA';
78   C_CL             constant VARCHAR2(3)  := 'CL';
79 
80 
81 END;