1 PACKAGE XTR_MAINTAIN_DDA_P AUTHID CURRENT_USER AS
2 /* $Header: xtrprc1s.pls 115.11 2003/04/29 23:08:51 tkkim ship $ */
3 --
4 -- Stored procedures/functions
5 --
6 procedure MAINTAIN_DDA_PROC (
7 P_ACTION IN VARCHAR2,
8 P_DEAL_TYPE IN VARCHAR2,
9 P_DEAL_NO IN NUMBER,
10 P_TRANSACTION_NUMBER IN NUMBER,
11 P_STATUS_CODE IN VARCHAR2,
12 P_DEAL_SUBTYPE IN VARCHAR2,
13 P_COMPANY_CODE IN VARCHAR2,
14 P_CPARTY_CODE IN VARCHAR2,
15 P_CLIENT_CODE IN VARCHAR2,
16 P_LIMIT_CODE IN VARCHAR2,
17 P_PRODUCT_TYPE IN VARCHAR2,
18 P_PORTFOLIO_CODE IN VARCHAR2,
19 P_CURRENCY IN VARCHAR2,
20 P_CURRENCY_BUY IN VARCHAR2,
21 P_CURRENCY_SELL IN VARCHAR2,
22 P_SWAP_DEPO_FLAG IN VARCHAR2,
23 P_DEALER_CODE IN VARCHAR2,
24 P_DEAL_DATE IN DATE,
25 P_START_DATE IN DATE,
26 P_MATURITY_DATE IN DATE,
27 P_INTEREST_RATE IN NUMBER,
28 P_FACE_VALUE_AMOUNT IN NUMBER,
29 P_FACE_VALUE_HCE_AMOUNT IN NUMBER,
30 P_CPARTY_ACCOUNT_NO IN VARCHAR2,
31 P_OLD_CPARTY_ACCOUNT_NO IN VARCHAR2,
32 P_SETTLE_ACCOUNT_NO IN VARCHAR2,
33 P_OLD_SETTLE_ACCOUNT_NO IN VARCHAR2,
34 P_SETTLE_ACTION IN VARCHAR2,
35 P_SETTLE_AMOUNT IN NUMBER,
36 P_SETTLE_HCE_AMOUNT IN NUMBER,
37 P_SETTLE_RATE IN NUMBER,
38 P_EXERCISE_PRICE IN NUMBER,
39 P_SETTLE_DATE IN DATE,
40 P_PREMIUM_ACTION IN VARCHAR2,
41 P_PREMIUM_DATE IN DATE,
42 P_PREMIUM_AMOUNT IN NUMBER,
43 P_PREMIUM_HCE_AMOUNT IN NUMBER,
44 P_PREMIUM_ACCOUNT_NO IN VARCHAR2,
45 P_OLD_PREMIUM_ACCOUNT_NO IN VARCHAR2,
46 P_TRANSACTION_RATE IN NUMBER,
47 P_INSERT_FOR_CASHFLOW IN VARCHAR2,
48 P_KNOCK_TYPE IN VARCHAR2,
49 P_KNOCK_INSERT_TYPE IN VARCHAR2,
50 P_SELL_AMOUNT IN NUMBER,
51 P_BUY_AMOUNT IN NUMBER,
52 P_SELL_HCE_AMOUNT IN NUMBER,
53 P_BUY_HCE_AMOUNT IN NUMBER,
54 P_SELL_ACCOUNT_NO IN VARCHAR2,
55 P_OLD_SELL_ACCOUNT_NO IN VARCHAR2,
56 P_BUY_ACCOUNT_NO IN VARCHAR2,
57 P_OLD_BUY_ACCOUNT_NO IN VARCHAR2,
58 P_VALUE_DATE IN DATE,
59 P_EXPIRY_DATE IN DATE,
60 P_OPTION_COMMENCEMENT IN DATE,
61 P_COMMENTS IN VARCHAR2,
62 P_OLD_STATUS_CODE IN VARCHAR2,
63 P_QUICK_INPUT IN VARCHAR2,
64 P_START_AMOUNT IN NUMBER,
65 P_START_HCE_AMOUNT IN NUMBER,
66 P_MATURITY_AMOUNT IN NUMBER,
67 P_MATURITY_HCE_AMOUNT IN NUMBER,
68 P_MATURITY_ACCOUNT_NO IN VARCHAR2,
69 P_OLD_MATURITY_ACCOUNT_NO IN VARCHAR2,
70 P_MATURITY_BALANCE_AMOUNT IN NUMBER,
71 P_MATURITY_BALANCE_HCE_AMOUNT IN NUMBER,
72 P_INTEREST_AMOUNT IN NUMBER,
73 P_INTEREST_HCE_AMOUNT IN NUMBER,
74 P_RISKPARTY_LIMIT_CODE IN VARCHAR2,
75 P_RISKPARTY_CODE IN VARCHAR2,
76 P_BOND_ISSUE IN VARCHAR2,
77 P_COUPON_ACTION IN VARCHAR2,
78 P_ACCRUED_INTEREST_PRICE IN NUMBER,
79 P_CUM_COUPON_DATE IN DATE,
80 P_NEXT_COUPON_DATE IN DATE,
81 P_COUPON_RATE IN NUMBER,
82 P_FREQUENCY IN NUMBER,
83 P_ACCEPTOR_CODE IN VARCHAR2,
84 P_CAPITAL_PRICE IN NUMBER,
85 P_PREMIUM_CURRENCY IN VARCHAR2,
86 P_CONTRACT_RATE IN NUMBER,
87 P_CONTRACT_COMMISSION IN NUMBER,
88 P_CONTRACT_FEES IN NUMBER,
89 P_BASE_RATE IN NUMBER,
90 P_NI_PROFIT_LOSS IN NUMBER,
91 P_RATE_FIXING_DATE IN DATE,
92 P_PROFIT_LOSS IN NUMBER DEFAULT NULL,
93 P_OLD_PROFIT_LOSS IN NUMBER DEFAULT NULL,
94 P_FX_RO_PD_RATE IN NUMBER DEFAULT NULL,
95 P_OLD_FX_RO_PD_RATE IN NUMBER DEFAULT NULL,
96 P_FX_M1_DEAL_NO IN NUMBER DEFAULT NULL,
97 P_OLD_FX_M1_DEAL_NO IN NUMBER DEFAULT NULL);
98
99
100 END XTR_MAINTAIN_DDA_P;