1 PACKAGE FA_FORMULAS_PKG as
2 /* $Header: faxifors.pls 120.5.12010000.1 2008/07/28 13:25:31 appldev ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out nocopy VARCHAR2,
6 X_METHOD_ID in NUMBER,
7 X_FORMULA_ACTUAL in VARCHAR2,
8 X_FORMULA_DISPLAYED in VARCHAR2,
9 X_FORMULA_PARSED in VARCHAR2,
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,
15 X_ORIGINAL_RATE IN NUMBER DEFAULT NULL,
16 X_REVISED_RATE IN NUMBER DEFAULT NULL,
17 X_GUARANTEE_RATE IN NUMBER DEFAULT NULL,
18 p_log_level_rec in fa_api_types.log_level_rec_type default null);
19 procedure LOCK_ROW (
20 X_METHOD_ID in NUMBER,
21 X_FORMULA_ACTUAL in VARCHAR2,
22 X_FORMULA_DISPLAYED in VARCHAR2,
23 X_FORMULA_PARSED in VARCHAR2,
24 X_ORIGINAL_RATE IN NUMBER,
25 X_REVISED_RATE IN NUMBER,
26 X_GUARANTEE_RATE IN NUMBER,
27 p_log_level_rec in fa_api_types.log_level_rec_type default null
28 );
29 procedure UPDATE_ROW (
30 X_METHOD_ID in NUMBER,
31 X_FORMULA_ACTUAL in VARCHAR2,
32 X_FORMULA_DISPLAYED in VARCHAR2,
33 X_FORMULA_PARSED in VARCHAR2,
34 X_LAST_UPDATE_DATE in DATE,
35 X_LAST_UPDATED_BY in NUMBER,
36 X_LAST_UPDATE_LOGIN in NUMBER,
37 X_ORIGINAL_RATE IN NUMBER,
38 X_REVISED_RATE IN NUMBER,
39 X_GUARANTEE_RATE IN NUMBER,
40 p_log_level_rec in fa_api_types.log_level_rec_type default null
41 );
42 procedure DELETE_ROW (
43 X_METHOD_ID in NUMBER
44 ,p_log_level_rec in fa_api_types.log_level_rec_type default null
45 );
46
47 procedure LOAD_ROW (
48 X_CUSTOM_MODE in VARCHAR2,
49 X_METHOD_ID in NUMBER,
50 X_DB_LAST_UPDATED_BY NUMBER,
51 X_DB_LAST_UPDATE_DATE DATE,
52 X_OWNER in VARCHAR2,
53 X_LAST_UPDATE_DATE in DATE,
54 X_FORMULA_ACTUAL in VARCHAR2,
55 X_FORMULA_DISPLAYED in VARCHAR2,
56 X_FORMULA_PARSED in VARCHAR2,
57 X_ORIGINAL_RATE IN NUMBER DEFAULT NULL,
58 X_REVISED_RATE IN NUMBER DEFAULT NULL,
59 X_GUARANTEE_RATE IN NUMBER DEFAULT NULL,
60 p_log_level_rec in fa_api_types.log_level_rec_type default null
61 );
62
63 procedure LOAD_SEED_ROW (
64 x_upload_mode IN VARCHAR2,
65 x_custom_mode IN VARCHAR2,
66 x_method_code IN VARCHAR2,
67 x_life_in_months IN NUMBER,
68 x_owner IN VARCHAR2,
69 x_last_update_date IN DATE,
70 x_formula_actual IN VARCHAR2,
71 x_formula_displayed IN VARCHAR2,
72 x_formula_parsed IN VARCHAR2,
73 x_original_rate IN NUMBER DEFAULT NULL,
74 x_revised_rate IN NUMBER DEFAULT NULL,
75 x_guarantee_rate IN NUMBER DEFAULT NULL);
76
77 END FA_FORMULAS_PKG;