1 PACKAGE FA_FORMULAS_PKG AUTHID CURRENT_USER as
2 /* $Header: faxifors.pls 120.7.12020000.2 2012/07/19 12:36:19 dvjoshi 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, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
18 procedure LOCK_ROW (
19 X_METHOD_ID IN NUMBER,
20 X_FORMULA_ACTUAL IN VARCHAR2,
21 X_FORMULA_DISPLAYED IN VARCHAR2,
22 X_FORMULA_PARSED IN VARCHAR2,
23 X_ORIGINAL_RATE IN NUMBER,
24 X_REVISED_RATE IN NUMBER,
25 X_GUARANTEE_RATE IN NUMBER
26 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
27 procedure UPDATE_ROW (
28 X_METHOD_ID IN NUMBER,
29 X_FORMULA_ACTUAL IN VARCHAR2,
30 X_FORMULA_DISPLAYED IN VARCHAR2,
31 X_FORMULA_PARSED IN VARCHAR2,
32 X_LAST_UPDATE_DATE IN DATE,
33 X_LAST_UPDATED_BY IN NUMBER,
34 X_LAST_UPDATE_LOGIN IN NUMBER,
35 X_ORIGINAL_RATE IN NUMBER,
36 X_REVISED_RATE IN NUMBER,
37 X_GUARANTEE_RATE IN NUMBER
38 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
39 procedure DELETE_ROW (
40 X_METHOD_ID in NUMBER
41 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
42
43 procedure LOAD_ROW (
44 X_METHOD_ID IN NUMBER,
45 X_OWNER IN VARCHAR2,
46 X_FORMULA_ACTUAL IN VARCHAR2,
47 X_FORMULA_DISPLAYED IN VARCHAR2,
48 X_FORMULA_PARSED IN VARCHAR2,
49 X_ORIGINAL_RATE IN NUMBER DEFAULT NULL,
50 X_REVISED_RATE IN NUMBER DEFAULT NULL,
51 X_GUARANTEE_RATE IN NUMBER DEFAULT NULL
52 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null);
53
54 /*Bug 8355119 overloading function for release specific signatures*/
55 procedure LOAD_ROW (
56 X_CUSTOM_MODE in VARCHAR2,
57 X_METHOD_ID in NUMBER,
58 X_DB_LAST_UPDATED_BY NUMBER,
59 X_DB_LAST_UPDATE_DATE DATE,
60 X_OWNER in VARCHAR2,
61 X_LAST_UPDATE_DATE in DATE,
62 X_FORMULA_ACTUAL in VARCHAR2,
63 X_FORMULA_DISPLAYED in VARCHAR2,
64 X_FORMULA_PARSED in VARCHAR2,
65 X_ORIGINAL_RATE IN NUMBER DEFAULT NULL,
66 X_REVISED_RATE IN NUMBER DEFAULT NULL,
67 X_GUARANTEE_RATE IN NUMBER DEFAULT NULL,
68 p_log_level_rec in fa_api_types.log_level_rec_type default null
69 );
70 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
71 procedure LOAD_SEED_ROW (
72 x_upload_mode IN VARCHAR2,
73 x_custom_mode IN VARCHAR2,
74 x_method_code IN VARCHAR2,
75 x_life_in_months IN NUMBER,
76 x_owner IN VARCHAR2,
77 x_last_update_date IN DATE,
78 x_formula_actual IN VARCHAR2,
79 x_formula_displayed IN VARCHAR2,
80 x_formula_parsed IN VARCHAR2,
81 x_original_rate IN NUMBER DEFAULT NULL,
82 x_revised_rate IN NUMBER DEFAULT NULL,
83 x_guarantee_rate IN NUMBER DEFAULT NULL);
84
85 END FA_FORMULAS_PKG;