1 PACKAGE FA_RATES_PKG AUTHID CURRENT_USER as
2 /* $Header: faxirats.pls 120.6 2009/04/10 07:32:51 deemitta ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_METHOD_ID in NUMBER,
7 X_YEAR in NUMBER,
8 X_PERIOD_PLACED_IN_SERVICE in NUMBER,
9 X_RATE in NUMBER,
10 X_CREATION_DATE in DATE,
11 X_CREATED_BY in NUMBER,
12 X_LAST_UPDATE_DATE in DATE,
13 X_LAST_UPDATED_BY in NUMBER,
14 X_LAST_UPDATE_LOGIN in NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
15 procedure LOCK_ROW (
16 X_METHOD_ID in NUMBER,
17 X_YEAR in NUMBER,
18 X_PERIOD_PLACED_IN_SERVICE in NUMBER,
19 X_RATE in NUMBER
20 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
21 procedure UPDATE_ROW (
22 X_METHOD_ID in NUMBER,
23 X_YEAR in NUMBER,
24 X_PERIOD_PLACED_IN_SERVICE in NUMBER,
25 X_RATE in NUMBER,
26 X_LAST_UPDATE_DATE in DATE,
27 X_LAST_UPDATED_BY in NUMBER,
28 X_LAST_UPDATE_LOGIN in NUMBER
29 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
30 procedure DELETE_ROW (
31 X_METHOD_ID in NUMBER,
32 X_YEAR in NUMBER,
33 X_PERIOD_PLACED_IN_SERVICE in NUMBER
34 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
35
36 procedure LOAD_ROW (
37 X_METHOD_ID in NUMBER,
38 X_OWNER in VARCHAR2,
39 X_YEAR in NUMBER,
40 X_PERIOD_PLACED_IN_SERVICE in NUMBER,
41 X_RATE in NUMBER
42 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
43
44 /*Bug 8355119 overloading function for release specific signatures*/
45 procedure LOAD_ROW (
46 X_CUSTOM_MODE in VARCHAR2,
47 X_METHOD_ID in NUMBER,
48 X_DB_LAST_UPDATED_BY NUMBER,
49 X_DB_LAST_UPDATE_DATE DATE,
50 X_OWNER in VARCHAR2,
51 X_LAST_UPDATE_DATE in DATE,
52 X_YEAR in NUMBER,
53 X_PERIOD_PLACED_IN_SERVICE in NUMBER,
54 X_RATE in NUMBER,
55 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
56 );
57 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
58 procedure LOAD_SEED_ROW (
59 x_upload_mode IN VARCHAR2,
60 x_custom_mode IN VARCHAR2,
61 x_method_code IN VARCHAR2,
62 x_life_in_months IN NUMBER,
63 x_owner IN VARCHAR2,
64 x_last_update_date IN DATE,
65 x_year IN NUMBER,
66 x_period_placed_in_service IN NUMBER,
67 x_rate IN NUMBER);
68
69 END FA_RATES_PKG;