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