1 package FND_LANGUAGES_PKG as
2 /* $Header: AFNLDLGS.pls 120.2 2005/09/08 17:37:56 jvalenti ship $ */
3
4 procedure INSERT_ROW (
5 X_ROWID in out NOCOPY VARCHAR2,
6 X_LANGUAGE_CODE in VARCHAR2,
7 X_LANGUAGE_ID in NUMBER,
8 X_NLS_LANGUAGE in VARCHAR2,
9 X_NLS_TERRITORY in VARCHAR2,
10 X_ISO_LANGUAGE in VARCHAR2,
11 X_ISO_TERRITORY in VARCHAR2,
12 X_NLS_CODESET in VARCHAR2,
13 X_INSTALLED_FLAG in VARCHAR2,
14 X_DESCRIPTION in VARCHAR2,
15 X_CREATION_DATE in DATE,
16 X_CREATED_BY in NUMBER,
17 X_LAST_UPDATE_DATE in DATE,
18 X_LAST_UPDATED_BY in NUMBER,
19 X_LAST_UPDATE_LOGIN in NUMBER,
20 X_LOCAL_DATE_LANGUAGE in VARCHAR2,
21 X_UTF8_DATE_LANGUAGE in VARCHAR2,
22 X_ISO_LANGUAGE_3 in VARCHAR2
23 );
24
25 procedure LOCK_ROW (
26 X_LANGUAGE_CODE in VARCHAR2,
27 X_LANGUAGE_ID in NUMBER,
28 X_NLS_LANGUAGE in VARCHAR2,
29 X_NLS_TERRITORY in VARCHAR2,
30 X_ISO_LANGUAGE in VARCHAR2,
31 X_ISO_TERRITORY in VARCHAR2,
32 X_NLS_CODESET in VARCHAR2,
33 X_INSTALLED_FLAG in VARCHAR2,
34 X_DESCRIPTION in VARCHAR2
35 );
36
37 procedure UPDATE_ROW (
38 X_LANGUAGE_CODE in VARCHAR2,
39 X_LANGUAGE_ID in NUMBER,
40 X_NLS_LANGUAGE in VARCHAR2,
41 X_NLS_TERRITORY in VARCHAR2,
42 X_ISO_LANGUAGE in VARCHAR2,
43 X_ISO_TERRITORY in VARCHAR2,
44 X_NLS_CODESET in VARCHAR2,
45 X_INSTALLED_FLAG in VARCHAR2,
46 X_DESCRIPTION in VARCHAR2,
47 X_LAST_UPDATE_DATE in DATE,
48 X_LAST_UPDATED_BY in NUMBER,
49 X_LAST_UPDATE_LOGIN in NUMBER,
50 X_LOCAL_DATE_LANGUAGE in VARCHAR2,
51 X_UTF8_DATE_LANGUAGE in VARCHAR2,
52 X_ISO_LANGUAGE_3 in VARCHAR2
53 );
54
55 procedure DELETE_ROW (
56 X_LANGUAGE_CODE in VARCHAR2
57 );
58 procedure ADD_LANGUAGE;
59 procedure TRANSLATE_ROW (
60 X_LANGUAGE_CODE in VARCHAR2,
61 X_DESCRIPTION in VARCHAR2,
62 X_OWNER in VARCHAR2
63 );
64 procedure LOAD_ROW (
65 X_LANGUAGE_CODE in VARCHAR2,
66 X_DESCRIPTION in VARCHAR2,
67 X_LANGUAGE_ID in NUMBER,
68 X_NLS_LANGUAGE in VARCHAR2,
69 X_NLS_TERRITORY in VARCHAR2,
70 X_ISO_LANGUAGE in VARCHAR2,
71 X_ISO_TERRITORY in VARCHAR2,
72 X_NLS_CODESET in VARCHAR2,
73 X_INSTALLED_FLAG in VARCHAR2,
74 X_LOCAL_DATE_LANGUAGE in VARCHAR2,
75 X_UTF8_DATE_LANGUAGE in VARCHAR2,
76 X_OWNER in VARCHAR2
77 );
78 procedure TRANSLATE_ROW (
79 X_LANGUAGE_CODE in VARCHAR2,
80 X_DESCRIPTION in VARCHAR2,
81 X_OWNER in VARCHAR2,
82 X_LAST_UPDATE_DATE in VARCHAR2,
83 X_CUSTOM_MODE in VARCHAR2);
84
85 procedure LOAD_ROW (
86 X_LANGUAGE_CODE in VARCHAR2,
87 X_DESCRIPTION in VARCHAR2,
88 X_LANGUAGE_ID in NUMBER,
89 X_NLS_LANGUAGE in VARCHAR2,
90 X_NLS_TERRITORY in VARCHAR2,
91 X_ISO_LANGUAGE in VARCHAR2,
92 X_ISO_TERRITORY in VARCHAR2,
93 X_NLS_CODESET in VARCHAR2,
94 X_INSTALLED_FLAG in VARCHAR2,
95 X_LOCAL_DATE_LANGUAGE in VARCHAR2,
96 X_UTF8_DATE_LANGUAGE in VARCHAR2,
97 X_OWNER in VARCHAR2,
98 X_LAST_UPDATE_DATE in VARCHAR2,
99 X_CUSTOM_MODE in VARCHAR2);
100
101 procedure LOAD_ROW (
102 X_LANGUAGE_CODE in VARCHAR2,
103 X_DESCRIPTION in VARCHAR2,
104 X_LANGUAGE_ID in NUMBER,
105 X_NLS_LANGUAGE in VARCHAR2,
106 X_NLS_TERRITORY in VARCHAR2,
107 X_ISO_LANGUAGE in VARCHAR2,
108 X_ISO_TERRITORY in VARCHAR2,
109 X_NLS_CODESET in VARCHAR2,
110 X_INSTALLED_FLAG in VARCHAR2,
111 X_LOCAL_DATE_LANGUAGE in VARCHAR2,
112 X_UTF8_DATE_LANGUAGE in VARCHAR2,
113 X_ISO_LANGUAGE_3 in VARCHAR2,
114 X_OWNER in VARCHAR2,
115 X_LAST_UPDATE_DATE in VARCHAR2,
116 X_CUSTOM_MODE in VARCHAR2);
117
118
119 null_char varchar2(8) := '*NULL*';
120 null_date date := to_date('2', 'J');
121 null_number number := -999;
122
123 end FND_LANGUAGES_PKG;