1 PACKAGE XTR_FX_TRANSFERS_PKG AS
2 /* $Header: xtrimfxs.pls 120.4 2005/06/29 09:26:11 badiredd ship $*/
3
4 procedure TRANSFER_FX_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
5 user_error OUT NOCOPY BOOLEAN,
6 mandatory_error OUT NOCOPY BOOLEAN,
7 validation_error OUT NOCOPY BOOLEAN,
8 limit_error OUT NOCOPY BOOLEAN);
9
10 procedure TRANSFER_FX_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
11 user_error OUT NOCOPY BOOLEAN,
12 mandatory_error OUT NOCOPY BOOLEAN,
13 validation_error OUT NOCOPY BOOLEAN,
14 limit_error OUT NOCOPY BOOLEAN,
15 deal_num OUT NOCOPY NUMBER);
16
17 /* Moved to xtrimddb.pls
18 procedure CHECK_USER_AUTH( p_external_deal_id IN VARCHAR2,
19 p_deal_type IN VARCHAR2,
20 p_company_code IN VARCHAR2,
21 error OUT NOCOPY BOOLEAN);
22 */
23
24 procedure CHECK_MANDATORY_FIELDS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
25 error OUT NOCOPY BOOLEAN);
26
27 procedure VALIDATE_DEALS(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
28 error OUT NOCOPY BOOLEAN);
29
30 procedure CALC_RATES(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
31 error OUT NOCOPY boolean);
32
33 procedure CHECK_VALIDITY(ARec_Interface IN XTR_DEALS_INTERFACE%ROWTYPE,
34 error OUT NOCOPY BOOLEAN) ;
35
36 function val_deal_date (p_date_a IN date) return BOOLEAN;
37
38 function val_value_date (p_date_a IN date,
39 p_date_b IN date) return BOOLEAN;
40
41 function val_client_code(p_client_code IN varchar2) return BOOLEAN;
42
43 function val_portfolio_code(p_company_code IN varchar2,
44 p_cparty_code IN varchar2,
45 p_portfolio_code IN varchar2) return BOOLEAN;
46
47 function val_limit_code( p_company_code IN varchar2,
48 p_cparty_code IN varchar2,
49 p_limit_code IN varchar2) return BOOLEAN;
50
51 function val_buy_sell_curr_comb( p_buy_currency IN varchar2,
52 p_sell_currency IN varchar2) return BOOLEAN ;
53
54 function val_currencies( p_currency IN varchar2) return BOOLEAN;
55
56 function val_comp_acct_no(p_company_code IN varchar2,
57 p_currency IN varchar2,
58 p_account_no IN varchar2) return BOOLEAN;
59
60 function val_cparty_ref( p_cparty_account_no IN varchar2,
61 p_cparty_ref IN varchar2,
62 p_cparty_code IN varchar2,
63 p_currency_b IN varchar2) return BOOLEAN;
64
65 function val_deal_linking_code( p_deal_linking_code IN varchar2) return BOOLEAN;
66
67 function val_brokerage_code( p_brokerage_code IN varchar2) return BOOLEAN;
68
69 function val_dealer_code(p_dealer_code IN VARCHAR2) return BOOLEAN;
70
71 function val_cparty_code(p_company_code IN VARCHAR2,
72 p_cparty_code IN VARCHAR2) return BOOLEAN;
73
74 function val_deal_subtype(p_deal_subtype IN VARCHAR2,
75 p_deal_type IN VARCHAR2) return BOOLEAN;
76
77 function val_product_type(p_product_type IN VARCHAR2,
78 p_deal_subtype IN VARCHAR2,
79 p_deal_type IN VARCHAR2) return BOOLEAN;
80
81 function val_pricing_model(p_pricing_model IN VARCHAR2) return BOOLEAN ;
82
83 function val_market_data_set(p_market_data_set IN VARCHAR2) return BOOLEAN ;
84
85 function val_brokerage_currency(p_brokerage_currency IN VARCHAR2,
86 p_deal_type IN VARCHAR2,
87 p_currency_a IN VARCHAR2,
88 p_currency_b IN VARCHAR2,
89 p_brokerage_code IN VARCHAR2) return BOOLEAN ;
90
91 /* Moved to xtrimdds.pls
92 function val_desc_flex( p_Interface_Rec IN XTR_DEALS_INTERFACE%ROWTYPE,
93 p_error_segment IN OUT NOCOPY VARCHAR2) return BOOLEAN;
94 */
95
96 Procedure copy_from_interface_to_fx(ARec_Interface IN xtr_deals_interface%rowtype );
97
98 procedure calc_hce_amounts (p_user_deal_type IN VARCHAR2, p_error OUT NOCOPY boolean);
99
100 procedure calc_brokerage_amt(p_user_deal_type IN VARCHAR2, p_bkr_amt_type IN varchar2, p_error OUT NOCOPY boolean);
101
102 procedure validate_buy_sell_amount (p_user_deal_type IN VARCHAR2, p_error OUT NOCOPY boolean);
103
104 procedure chk_buy_sell_amount(p_user_deal_type IN VARCHAR2,
105 p_currency_first IN varchar2,
106 p_error IN OUT NOCOPY boolean);
107
108 procedure create_fx_deal(ARec_Fx IN xtr_deals%rowtype,
109 p_deal_no IN number);
110
111 procedure check_for_error(p_user_deal_type IN VARCHAR2, l_err_code IN NUMBER, l_level IN VARCHAR2 );
112
113
114 g_fx_main_rec xtr_deals%rowtype;
115 g_currency_first varchar2(30);
116 g_currency_second varchar2(30);
117 G_User_Id Number Default 0;
118 G_Curr_Date Date;
119 G_Fx_Deal_Type Xtr_Deals.Deal_Type%Type Default 'FX';
120 G_Pricing_model Xtr_Deals.pricing_model%Type;
121
122 END XTR_FX_TRANSFERS_PKG;