1 package FND_PROFILE_CAT_OPTIONS_PKG as
2 /* $Header: FNDPRCTS.pls 120.5 2006/05/12 02:40:53 stadepal noship $ */
3 procedure INSERT_ROW (
4 X_ROWID in out nocopy VARCHAR2,
5 X_PROFILE_OPTION_ID in NUMBER,
6 X_CATEGORY_NAME in VARCHAR2,
7 X_PROFILE_OPTION_APPLICATION_I in NUMBER,
8 X_DISPLAY_SEQUENCE in NUMBER,
9 X_DISPLAY_TYPE 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_APPLICATION_ID in NUMBER);
16 procedure LOCK_ROW (
17 X_PROFILE_OPTION_ID in NUMBER,
18 X_CATEGORY_NAME in VARCHAR2,
19 X_PROFILE_OPTION_APPLICATION_I in NUMBER,
20 X_DISPLAY_SEQUENCE in NUMBER,
21 X_DISPLAY_TYPE in VARCHAR2,
22 X_APPLICATION_ID in NUMBER
23 );
24 procedure UPDATE_ROW (
25 X_PROFILE_OPTION_ID in NUMBER,
26 X_CATEGORY_NAME in VARCHAR2,
27 X_PROFILE_OPTION_APPLICATION_I in NUMBER,
28 X_DISPLAY_SEQUENCE in NUMBER,
29 X_DISPLAY_TYPE in VARCHAR2,
30 X_LAST_UPDATE_DATE in DATE,
31 X_LAST_UPDATED_BY in NUMBER,
32 X_LAST_UPDATE_LOGIN in NUMBER,
33 X_APPLICATION_ID in NUMBER
34 );
35 procedure DELETE_ROW (
36 X_PROFILE_OPTION_ID in NUMBER,
37 X_CATEGORY_NAME in VARCHAR2,
38 X_PROFILE_OPTION_APPLICATION_I in NUMBER,
39 X_APPLICATION_ID in NUMBER
40 );
41 /** Uncommented ADD_LANGUAGE api to remove the dependency between dropping
42 ** this api and FNDNLINS.sql
43 **/
44 procedure ADD_LANGUAGE;
45 /**** Not Required as TL table is dropped
46 procedure TRANSLATE_ROW (
47 X_PROFILE_OPTION_APP_NAME in VARCHAR2,
48 X_PROFILE_OPTION_NAME in VARCHAR2,
49 X_CATEGORY_NAME in VARCHAR2,
50 X_DESCRIPTION_OVERRIDE in VARCHAR2,
51 X_CUSTOM_MODE in VARCHAR2,
52 X_OWNER in VARCHAR2,
53 X_LAST_UPDATE_DATE in VARCHAR2);
54 *************/
55
56 /*** Bug 5060938. Added default param X_PROF_APPL_SHORT_NAME to LOAD_ROW api.
57 *** This is required to create a Dummy profile option in Fnd_Profile_Options
58 *** table when category ldt is uploaded before it's corresponding profile ldt
59 *** to handle No-Data-Found issues.
60 ***/
61 procedure LOAD_ROW (
62 X_PROFILE_OPTION_NAME in VARCHAR2,
63 X_CATEGORY_NAME in VARCHAR2,
64 X_DISPLAY_SEQUENCE in VARCHAR2,
65 X_DISPLAY_TYPE in VARCHAR2,
66 X_OWNER in VARCHAR2,
67 X_CUSTOM_MODE in VARCHAR2,
68 X_LAST_UPDATE_DATE in VARCHAR2,
69 X_APPLICATION_SHORT_NAME in VARCHAR2,
70 X_PROF_APPL_SHORT_NAME in VARCHAR2 default NULL);
71 end FND_PROFILE_CAT_OPTIONS_PKG;