[Home] [Help]
PACKAGE: APPS.XTR_IAC_TRANSFERS_PKG
Source
1 PACKAGE XTR_IAC_TRANSFERS_PKG 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;