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.FA_FLAT_RATES_PKG

Source


1 PACKAGE FA_FLAT_RATES_PKG as
2 /* $Header: faxiflrs.pls 120.5 2005/07/25 04:02:58 yyoon ship $ */
3 
4 procedure INSERT_ROW (
5    X_ROWID in out nocopy VARCHAR2,
6    X_METHOD_ID in NUMBER,
7    X_BASIC_RATE in NUMBER,
8    X_ADJUSTED_RATE in NUMBER,
9    X_ADJUSTING_RATE in NUMBER,
10    X_ATTRIBUTE1 in VARCHAR2,
11    X_ATTRIBUTE2 in VARCHAR2,
12    X_ATTRIBUTE3 in VARCHAR2,
13    X_ATTRIBUTE4 in VARCHAR2,
14    X_ATTRIBUTE5 in VARCHAR2,
15    X_ATTRIBUTE6 in VARCHAR2,
16    X_ATTRIBUTE7 in VARCHAR2,
17    X_ATTRIBUTE8 in VARCHAR2,
18    X_ATTRIBUTE9 in VARCHAR2,
19    X_ATTRIBUTE10 in VARCHAR2,
20    X_ATTRIBUTE11 in VARCHAR2,
21    X_ATTRIBUTE12 in VARCHAR2,
22    X_ATTRIBUTE13 in VARCHAR2,
23    X_ATTRIBUTE14 in VARCHAR2,
24    X_ATTRIBUTE15 in VARCHAR2,
25    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
26    X_CREATION_DATE in DATE,
27    X_CREATED_BY in NUMBER,
28    X_LAST_UPDATE_DATE in DATE,
29    X_LAST_UPDATED_BY in NUMBER,
30    X_LAST_UPDATE_LOGIN in NUMBER,
31    p_log_level_rec    in      fa_api_types.log_level_rec_type default null);
32 
33 procedure LOCK_ROW (
34    X_METHOD_ID in NUMBER,
35    X_BASIC_RATE in NUMBER,
36    X_ADJUSTED_RATE in NUMBER,
37    X_ADJUSTING_RATE in NUMBER,
38    X_ATTRIBUTE1 in VARCHAR2,
39    X_ATTRIBUTE2 in VARCHAR2,
40    X_ATTRIBUTE3 in VARCHAR2,
41    X_ATTRIBUTE4 in VARCHAR2,
42    X_ATTRIBUTE5 in VARCHAR2,
43    X_ATTRIBUTE6 in VARCHAR2,
44    X_ATTRIBUTE7 in VARCHAR2,
45    X_ATTRIBUTE8 in VARCHAR2,
46    X_ATTRIBUTE9 in VARCHAR2,
47    X_ATTRIBUTE10 in VARCHAR2,
48    X_ATTRIBUTE11 in VARCHAR2,
49    X_ATTRIBUTE12 in VARCHAR2,
50    X_ATTRIBUTE13 in VARCHAR2,
51    X_ATTRIBUTE14 in VARCHAR2,
52    X_ATTRIBUTE15 in VARCHAR2,
53    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
54    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
55 );
56 
57 procedure UPDATE_ROW (
58    X_METHOD_ID in NUMBER,
59    X_BASIC_RATE in NUMBER,
60    X_ADJUSTED_RATE in NUMBER,
61    X_ADJUSTING_RATE in NUMBER,
62    X_ATTRIBUTE1 in VARCHAR2,
63    X_ATTRIBUTE2 in VARCHAR2,
64    X_ATTRIBUTE3 in VARCHAR2,
65    X_ATTRIBUTE4 in VARCHAR2,
66    X_ATTRIBUTE5 in VARCHAR2,
67    X_ATTRIBUTE6 in VARCHAR2,
68    X_ATTRIBUTE7 in VARCHAR2,
69    X_ATTRIBUTE8 in VARCHAR2,
70    X_ATTRIBUTE9 in VARCHAR2,
71    X_ATTRIBUTE10 in VARCHAR2,
72    X_ATTRIBUTE11 in VARCHAR2,
73    X_ATTRIBUTE12 in VARCHAR2,
74    X_ATTRIBUTE13 in VARCHAR2,
75    X_ATTRIBUTE14 in VARCHAR2,
76    X_ATTRIBUTE15 in VARCHAR2,
77    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
78    X_LAST_UPDATE_DATE in DATE,
79    X_LAST_UPDATED_BY in NUMBER,
80    X_LAST_UPDATE_LOGIN in NUMBER,
81    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
82 );
83 procedure DELETE_ROW (
84    X_METHOD_ID in NUMBER,
85    X_BASIC_RATE in NUMBER,
86    X_ADJUSTED_RATE in NUMBER,
87    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
88 );
89 
90 procedure LOAD_ROW (
91    X_CUSTOM_MODE in VARCHAR2,
92    X_METHOD_ID in NUMBER,
93    X_DB_LAST_UPDATED_BY NUMBER,
94    X_DB_LAST_UPDATE_DATE DATE,
95    X_OWNER in VARCHAR2,
96    X_LAST_UPDATE_DATE in DATE,
97    X_BASIC_RATE in NUMBER,
98    X_ADJUSTING_RATE in NUMBER,
99    X_ADJUSTED_RATE in NUMBER,
100    X_ATTRIBUTE1 in VARCHAR2,
101    X_ATTRIBUTE2 in VARCHAR2,
102    X_ATTRIBUTE3 in VARCHAR2,
103    X_ATTRIBUTE4 in VARCHAR2,
104    X_ATTRIBUTE5 in VARCHAR2,
105    X_ATTRIBUTE6 in VARCHAR2,
106    X_ATTRIBUTE7 in VARCHAR2,
107    X_ATTRIBUTE8 in VARCHAR2,
108    X_ATTRIBUTE9 in VARCHAR2,
109    X_ATTRIBUTE10 in VARCHAR2,
110    X_ATTRIBUTE11 in VARCHAR2,
111    X_ATTRIBUTE12 in VARCHAR2,
112    X_ATTRIBUTE13 in VARCHAR2,
113    X_ATTRIBUTE14 in VARCHAR2,
114    X_ATTRIBUTE15 in VARCHAR2,
115    X_ATTRIBUTE_CATEGORY_CODE in VARCHAR2,
116    p_log_level_rec    in      fa_api_types.log_level_rec_type default null
117 );
118 
119 procedure LOAD_SEED_ROW (
120                x_upload_mode             IN VARCHAR2,
121                x_custom_mode             IN VARCHAR2,
122                x_method_code             IN VARCHAR2,
123                x_life_in_months          IN NUMBER,
124                x_owner                   IN VARCHAR2,
125                x_last_update_date        IN DATE,
126                x_basic_rate              IN NUMBER,
127                x_adjusting_rate          IN NUMBER,
128                x_adjusted_rate           IN NUMBER,
129                x_attribute1              IN VARCHAR2,
130                x_attribute2              IN VARCHAR2,
131                x_attribute3              IN VARCHAR2,
132                x_attribute4              IN VARCHAR2,
133                x_attribute5              IN VARCHAR2,
134                x_attribute6              IN VARCHAR2,
135                x_attribute7              IN VARCHAR2,
136                x_attribute8              IN VARCHAR2,
137                x_attribute9              IN VARCHAR2,
138                x_attribute10             IN VARCHAR2,
139                x_attribute11             IN VARCHAR2,
140                x_attribute12             IN VARCHAR2,
141                x_attribute13             IN VARCHAR2,
142                x_attribute14             IN VARCHAR2,
143                x_attribute15             IN VARCHAR2,
144                x_attribute_category_code IN VARCHAR2,
145                p_log_level_rec    in      fa_api_types.log_level_rec_type default null);
146 
147 END FA_FLAT_RATES_PKG;