1 package FA_LOOKUP_TYPES_PKG AUTHID CURRENT_USER as
2 /* $Header: faxilts.pls 120.6 2009/04/10 06:34:30 deemitta ship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_LOOKUP_TYPE in VARCHAR2,
6 X_USER_MAINTAINABLE in VARCHAR2,
7 X_MEANING in VARCHAR2,
8 X_DESCRIPTION in VARCHAR2,
9 X_CREATION_DATE in DATE,
10 X_CREATED_BY in NUMBER,
11 X_LAST_UPDATE_DATE in DATE,
12 X_LAST_UPDATED_BY in NUMBER,
13 X_LAST_UPDATE_LOGIN in NUMBER, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
14 procedure LOCK_ROW (
15 X_LOOKUP_TYPE in VARCHAR2,
16 X_USER_MAINTAINABLE in VARCHAR2,
17 X_MEANING in VARCHAR2,
18 X_DESCRIPTION in VARCHAR2
19 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
20 procedure UPDATE_ROW (
21 X_LOOKUP_TYPE in VARCHAR2,
22 X_USER_MAINTAINABLE in VARCHAR2,
23 X_MEANING in VARCHAR2,
24 X_DESCRIPTION in VARCHAR2,
25 X_LAST_UPDATE_DATE in DATE,
26 X_LAST_UPDATED_BY in NUMBER,
27 X_LAST_UPDATE_LOGIN in NUMBER
28 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
29 procedure DELETE_ROW (
30 X_LOOKUP_TYPE in VARCHAR2
31 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
32 /* bug 8355119 procedure ADD_LANGUAGE;*/
33 /*Bug 8355119 overloading function for release specific signatures*/
34 procedure ADD_LANGUAGE(p_log_level_rec in fa_api_types.log_level_rec_type default null);
35 procedure TRANSLATE_ROW (
36 X_LOOKUP_TYPE in VARCHAR2,
37 X_OWNER in VARCHAR2,
38 X_MEANING in VARCHAR2,
39 X_DESCRIPTION in VARCHAR2
40 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
41
42 /*Bug 8355119 overloading function for release specific signatures*/
43 procedure TRANSLATE_ROW (
44 X_CUSTOM_MODE in VARCHAR2,
45 X_LOOKUP_TYPE in VARCHAR2,
46 X_OWNER in VARCHAR2,
47 X_LAST_UPDATE_DATE in DATE,
48 X_MEANING in VARCHAR2,
49 X_DESCRIPTION in VARCHAR2,
50 p_log_level_rec in fa_api_types.log_level_rec_type default null
51 );
52
53 procedure LOAD_ROW (
54 X_LOOKUP_TYPE in VARCHAR2,
55 X_OWNER in VARCHAR2,
56 X_MEANING in VARCHAR2,
57 X_DESCRIPTION in VARCHAR2,
58 X_USER_MAINTAINABLE in VARCHAR2
59 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
60
61 /*Bug 8355119 overloading function for release specific signatures*/
62 procedure LOAD_ROW (
63 X_CUSTOM_MODE in VARCHAR2,
64 X_LOOKUP_TYPE in VARCHAR2,
65 X_OWNER in VARCHAR2,
66 X_LAST_UPDATE_DATE IN DATE,
67 X_MEANING in VARCHAR2,
68 X_DESCRIPTION in VARCHAR2,
69 X_USER_MAINTAINABLE in VARCHAR2,
70 p_log_level_rec in fa_api_types.log_level_rec_type default null
71 );
72
73 /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/
74 procedure LOAD_SEED_ROW (
75 x_upload_mode IN VARCHAR2,
76 x_custom_mode IN VARCHAR2,
77 x_lookup_type IN VARCHAR2,
78 x_owner IN VARCHAR2,
79 x_last_update_date IN DATE,
80 x_meaning IN VARCHAR2,
81 x_description IN VARCHAR2,
82 x_user_maintainable IN VARCHAR2);
83
84
85 end FA_LOOKUP_TYPES_PKG;