1 PACKAGE XTR_EXP_TRANSFERS_PKG AS
2 /* $Header: xtrimexs.pls 120.6 2005/06/29 09:20:34 badiredd ship $ */
3 --------------------------------------------------------------------------
4
5 procedure LOG_ERRORS(p_Ext_Deal_Id In Varchar2,
6 p_Deal_Type In Varchar2,
7 p_Error_Column In Varchar2,
8 p_Error_Code In Varchar2,
9 p_Field_Name In Varchar2 DEFAULT NULL);
10
11 function VALID_COMPANY_CODE(p_comp IN VARCHAR2) return boolean;
12
13 function VALID_STATUS_CODE(p_status_code IN VARCHAR2) return boolean;
14
15 function VALID_EXPOSURE_TYPE(p_comp IN VARCHAR2,
16 p_exposure_type IN VARCHAR2) return boolean;
17
18 function VALID_DEAL_SUBTYPE(p_deal_type IN VARCHAR2,
19 p_deal_subtype IN VARCHAR2) return boolean;
20
21 function VALID_PORTFOLIO(p_comp IN VARCHAR2,
22 p_portfolio IN VARCHAR2) return boolean;
23
24 function VALID_ACTION(p_action IN VARCHAR2,
25 p_deal_type IN VARCHAR2) return boolean;
26
27 function VALID_CURRENCY(p_curr IN VARCHAR2) return boolean;
28
29 function VALID_COMP_ACCT(p_comp IN VARCHAR2,
30 p_comp_acct IN VARCHAR2,
31 p_curr IN VARCHAR2) return boolean;
32
33 function VALID_SETTLE_ACTION(p_settle_action IN VARCHAR2,
34 p_deal_subtype IN VARCHAR2,
35 p_act_amount IN NUMBER,
36 p_act_date IN DATE,
37 p_cparty_code IN VARCHAR2) return boolean;
38
39 function VALID_CPARTY_CODE(p_comp IN VARCHAR2,
40 p_cparty IN VARCHAR2) return boolean;
41
42 function VALID_CPARTY_REF( p_cparty_account_no IN VARCHAR2,
43 p_cparty_ref IN VARCHAR2,
44 p_cparty IN VARCHAR2,
45 p_curr IN VARCHAR2) return boolean;
46
47 function VALID_DEALER_CODE(p_dealer_code IN VARCHAR2) return boolean;
48
49 procedure COPY_FROM_INTERFACE_TO_EXP
50 (ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
51 p_error OUT NOCOPY BOOLEAN);
52
53 PROCEDURE INS_DEAL_DATE_AMOUNTS (ARec_Exp IN XTR_EXPOSURE_TRANSACTIONS%rowtype);
54
55 procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN);
56
57 procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%rowtype, p_error OUT NOCOPY BOOLEAN);
58
59 function GET_TRANSACTION_NUMBER return number;
60
61 function GET_CPARTY_ACCOUNT(p_cparty_code IN VARCHAR2,
62 p_curr IN VARCHAR2,
63 p_cparty_ref IN VARCHAR2) return varchar2;
64
65 procedure CREATE_EXP_DEAL(ARec_EXP IN XTR_EXPOSURE_TRANSACTIONS%rowtype);
66
67 procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
68 p_source IN VARCHAR2,
69 user_error OUT NOCOPY BOOLEAN,
70 mandatory_error OUT NOCOPY BOOLEAN,
71 validation_error OUT NOCOPY BOOLEAN,
72 limit_error OUT NOCOPY BOOLEAN);
73
74 procedure TRANSFER_EXP_DEALS( ARec_Interface IN XTR_DEALS_INTERFACE%rowtype,
75 p_source IN VARCHAR2,
76 user_error OUT NOCOPY BOOLEAN,
77 mandatory_error OUT NOCOPY BOOLEAN,
78 validation_error OUT NOCOPY BOOLEAN,
79 limit_error OUT NOCOPY BOOLEAN,
80 deal_num OUT NOCOPY NUMBER);
81
82 procedure TRANSFER_EXP_DEALS(
83 ARec IN OUT NOCOPY XTR_EXPOSURE_TRANSACTIONS%rowtype,
84 p_source IN VARCHAR2,
85 user_error OUT NOCOPY BOOLEAN,
86 mandatory_error OUT NOCOPY BOOLEAN,
87 validation_error OUT NOCOPY BOOLEAN,
88 limit_error OUT NOCOPY BOOLEAN);
89
90 --* Public Variables
91 G_curr_date DATE;
92 G_user_id NUMBER;
93 G_user xtr_dealer_codes.dealer_code%TYPE;
94 G_Main_Rec XTR_EXPOSURE_TRANSACTIONS%rowtype;
95 G_Source VARCHAR2(10);
96 G_cparty_account VARCHAR2(20);
97
98 END;