eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.XTR_REVALUATION_DETAILS_PKG

Source


1 package XTR_REVALUATION_DETAILS_PKG as
2 /* $Header: xtrrdets.pls 120.2 2005/06/29 10:29:07 rjose noship $ */
3 procedure INSERT_ROW (
4   X_ROWID in out NOCOPY VARCHAR2,
5   X_REVALUATION_DETAILS_ID in NUMBER,
6   X_ACCOUNT_NO in VARCHAR2,
7   X_REVAL_CURR_FV_AMOUNT in NUMBER,
8   X_COMPLETE_FLAG in VARCHAR2,
9   X_FAIR_VALUE in NUMBER,
10   X_SWAP_REF in VARCHAR2,
11   X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
12   X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
13   X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
14   X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
15   X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
16   X_EXCHANGE_RATE_TWO in NUMBER,
17   X_ACTION_CODE in VARCHAR2,
18   X_COMPANY_CODE in VARCHAR2,
19   X_CONTRACT_CODE in VARCHAR2,
20   X_CURRENCYA in VARCHAR2,
21   X_CURRENCYB in VARCHAR2,
22   X_DEAL_NO in NUMBER,
23   X_DEAL_SUBTYPE in VARCHAR2,
24   X_DEAL_TYPE in VARCHAR2,
25   X_EFFECTIVE_DATE in DATE,
26   X_EFFECTIVE_DAYS in NUMBER,
27   X_ENTERED_BY in VARCHAR2,
28   X_ENTERED_ON in DATE,
29   X_FACE_VALUE in NUMBER,
30   X_FXO_SELL_REF_AMOUNT in NUMBER,
31   X_PERIOD_FROM in DATE,
32   X_PERIOD_TO in DATE,
33   X_PORTFOLIO_CODE in VARCHAR2,
34   X_PRODUCT_TYPE in VARCHAR2,
35   X_REALISED_PL in NUMBER,
36   X_REVAL_CCY in VARCHAR2,
37   X_REVAL_RATE in NUMBER,
38   X_TRANSACTION_NO in NUMBER,
39   X_TRANSACTION_PERIOD in NUMBER,
40   X_TRANSACTION_RATE in NUMBER,
41   X_UNREALISED_PL in NUMBER,
42   X_UPDATED_BY in VARCHAR2,
43   X_UPDATED_ON in DATE,
44   X_YEAR_BASIS in NUMBER,
45   X_CREATED_ON in DATE,
46   X_EXCHANGE_RATE_ONE in NUMBER,
47   X_REALIZED_FLAG in VARCHAR2,
48   X_OVERWRITE_TYPE in VARCHAR2,
49   X_OVERWRITE_VALUE in NUMBER,
50   X_OVERWRITE_REASON in VARCHAR2,
51   X_BATCH_ID in NUMBER,
52   X_CREATED_BY in NUMBER,
53   X_NI_DISC_AMOUNT in NUMBER,
54   X_AMOUNT_TYPE in VARCHAR2,
55   X_QUANTITY in NUMBER);
56 
57 procedure LOCK_ROW (
58   X_REVALUATION_DETAILS_ID in NUMBER,
59   X_ACCOUNT_NO in VARCHAR2,
60   X_REVAL_CURR_FV_AMOUNT in NUMBER,
61   X_COMPLETE_FLAG in VARCHAR2,
62   X_FAIR_VALUE in NUMBER,
63   X_SWAP_REF in VARCHAR2,
64   X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
65   X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
66   X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
67   X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
68   X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
69   X_EXCHANGE_RATE_TWO in NUMBER,
70   X_ACTION_CODE in VARCHAR2,
71   X_COMPANY_CODE in VARCHAR2,
72   X_CONTRACT_CODE in VARCHAR2,
73   X_CURRENCYA in VARCHAR2,
74   X_CURRENCYB in VARCHAR2,
75   X_DEAL_NO in NUMBER,
76   X_DEAL_SUBTYPE in VARCHAR2,
77   X_DEAL_TYPE in VARCHAR2,
78   X_EFFECTIVE_DATE in DATE,
79   X_EFFECTIVE_DAYS in NUMBER,
80   X_ENTERED_BY in VARCHAR2,
81   X_ENTERED_ON in DATE,
82   X_FACE_VALUE in NUMBER,
83   X_FXO_SELL_REF_AMOUNT in NUMBER,
84   X_PERIOD_FROM in DATE,
85   X_PERIOD_TO in DATE,
86   X_PORTFOLIO_CODE in VARCHAR2,
87   X_PRODUCT_TYPE in VARCHAR2,
88   X_REALISED_PL in NUMBER,
89   X_REVAL_CCY in VARCHAR2,
90   X_REVAL_RATE in NUMBER,
91   X_TRANSACTION_NO in NUMBER,
92   X_TRANSACTION_PERIOD in NUMBER,
93   X_TRANSACTION_RATE in NUMBER,
94   X_UNREALISED_PL in NUMBER,
95   X_UPDATED_BY in VARCHAR2,
96   X_UPDATED_ON in DATE,
97   X_YEAR_BASIS in NUMBER,
98   X_CREATED_ON in DATE,
99   X_EXCHANGE_RATE_ONE in NUMBER,
100   X_REALIZED_FLAG in VARCHAR2,
101   X_OVERWRITE_TYPE in VARCHAR2,
102   X_OVERWRITE_VALUE in NUMBER,
103   X_OVERWRITE_REASON in VARCHAR2,
104   X_BATCH_ID in NUMBER,
105   X_NI_DISC_AMOUNT in NUMBER,
106   X_AMOUNT_TYPE in VARCHAR2,
107   X_QUANTITY in NUMBER
108 );
109 procedure UPDATE_ROW (
110   X_REVALUATION_DETAILS_ID in NUMBER,
111   X_ACCOUNT_NO in VARCHAR2,
112   X_REVAL_CURR_FV_AMOUNT in NUMBER,
113   X_COMPLETE_FLAG in VARCHAR2,
114   X_FAIR_VALUE in NUMBER,
115   X_SWAP_REF in VARCHAR2,
116   X_CUMM_GAIN_LOSS_AMOUNT in NUMBER,
117   X_CURR_GAIN_LOSS_AMOUNT in NUMBER,
118   X_SOB_FV_GAIN_LOSS_AMOUNT in NUMBER,
119   X_SOB_FAIR_VALUE_AMOUNT in NUMBER,
120   X_CTR_CURR_SOB_CURR_FWD_RATE in NUMBER,
121   X_EXCHANGE_RATE_TWO in NUMBER,
122   X_ACTION_CODE in VARCHAR2,
123   X_COMPANY_CODE in VARCHAR2,
124   X_CONTRACT_CODE in VARCHAR2,
125   X_CURRENCYA in VARCHAR2,
126   X_CURRENCYB in VARCHAR2,
127   X_DEAL_NO in NUMBER,
128   X_DEAL_SUBTYPE in VARCHAR2,
129   X_DEAL_TYPE in VARCHAR2,
130   X_EFFECTIVE_DATE in DATE,
131   X_EFFECTIVE_DAYS in NUMBER,
132   X_ENTERED_BY in VARCHAR2,
133   X_ENTERED_ON in DATE,
134   X_FACE_VALUE in NUMBER,
135   X_FXO_SELL_REF_AMOUNT in NUMBER,
136   X_PERIOD_FROM in DATE,
137   X_PERIOD_TO in DATE,
138   X_PORTFOLIO_CODE in VARCHAR2,
139   X_PRODUCT_TYPE in VARCHAR2,
140   X_REALISED_PL in NUMBER,
141   X_REVAL_CCY in VARCHAR2,
142   X_REVAL_RATE in NUMBER,
143   X_TRANSACTION_NO in NUMBER,
144   X_TRANSACTION_PERIOD in NUMBER,
145   X_TRANSACTION_RATE in NUMBER,
146   X_UNREALISED_PL in NUMBER,
147   X_UPDATED_BY in VARCHAR2,
148   X_UPDATED_ON in DATE,
149   X_YEAR_BASIS in NUMBER,
150   X_CREATED_ON in DATE,
151   X_EXCHANGE_RATE_ONE in NUMBER,
152   X_REALIZED_FLAG in VARCHAR2,
153   X_OVERWRITE_TYPE in VARCHAR2,
154   X_OVERWRITE_VALUE in NUMBER,
155   X_OVERWRITE_REASON in VARCHAR2,
156   X_BATCH_ID in NUMBER,
157   X_NI_DISC_AMOUNT in NUMBER,
158   X_AMOUNT_TYPE in VARCHAR2,
159   X_QUANTITY in NUMBER
160 );
161 procedure DELETE_ROW (
162   X_REVALUATION_DETAILS_ID in NUMBER
163 );
164 end XTR_REVALUATION_DETAILS_PKG;