APPS.FWK_TBX_LOOKUP_TYPES_PKG dependencies on FWK_TBX_LOOKUP_TYPES_TL

Line 14: cursor C is select ROWID from FWK_TBX_LOOKUP_TYPES_TL

10: X_LAST_UPDATE_DATE in DATE,
11: X_LAST_UPDATED_BY in NUMBER,
12: X_LAST_UPDATE_LOGIN in NUMBER
13: ) is
14: cursor C is select ROWID from FWK_TBX_LOOKUP_TYPES_TL
15: where LOOKUP_TYPE = X_LOOKUP_TYPE
16: and LANGUAGE = userenv('LANG')
17: ;
18: begin

Line 19: insert into FWK_TBX_LOOKUP_TYPES_TL (

15: where LOOKUP_TYPE = X_LOOKUP_TYPE
16: and LANGUAGE = userenv('LANG')
17: ;
18: begin
19: insert into FWK_TBX_LOOKUP_TYPES_TL (
20: LAST_UPDATE_DATE,
21: LAST_UPDATED_BY,
22: CREATION_DATE,
23: CREATED_BY,

Line 45: from FWK_TBX_LOOKUP_TYPES_TL T

41: from FND_LANGUAGES L
42: where L.INSTALLED_FLAG in ('I', 'B')
43: and not exists
44: (select NULL
45: from FWK_TBX_LOOKUP_TYPES_TL T
46: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
47: and T.LANGUAGE = L.LANGUAGE_CODE);
48:
49: open c;

Line 68: from FWK_TBX_LOOKUP_TYPES_TL

64: cursor c1 is select
65: DISPLAY_NAME,
66: DESCRIPTION,
67: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
68: from FWK_TBX_LOOKUP_TYPES_TL
69: where LOOKUP_TYPE = X_LOOKUP_TYPE
70: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
71: for update of LOOKUP_TYPE nowait;
72: begin

Line 98: update FWK_TBX_LOOKUP_TYPES_TL set

94: X_LAST_UPDATED_BY in NUMBER,
95: X_LAST_UPDATE_LOGIN in NUMBER
96: ) is
97: begin
98: update FWK_TBX_LOOKUP_TYPES_TL set
99: DISPLAY_NAME = X_DISPLAY_NAME,
100: DESCRIPTION = X_DESCRIPTION,
101: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
102: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 117: delete from FWK_TBX_LOOKUP_TYPES_TL

113: procedure DELETE_ROW (
114: X_LOOKUP_TYPE in VARCHAR2
115: ) is
116: begin
117: delete from FWK_TBX_LOOKUP_TYPES_TL
118: where LOOKUP_TYPE = X_LOOKUP_TYPE;
119:
120: if (sql%notfound) then
121: raise no_data_found;

Line 129: update FWK_TBX_LOOKUP_TYPES_TL T set (

125:
126: procedure ADD_LANGUAGE
127: is
128: begin
129: update FWK_TBX_LOOKUP_TYPES_TL T set (
130: DISPLAY_NAME,
131: DESCRIPTION
132: ) = (select
133: B.DISPLAY_NAME,

Line 135: from FWK_TBX_LOOKUP_TYPES_TL B

131: DESCRIPTION
132: ) = (select
133: B.DISPLAY_NAME,
134: B.DESCRIPTION
135: from FWK_TBX_LOOKUP_TYPES_TL B
136: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
137: and B.LANGUAGE = T.SOURCE_LANG)
138: where (
139: T.LOOKUP_TYPE,

Line 144: from FWK_TBX_LOOKUP_TYPES_TL SUBB, FWK_TBX_LOOKUP_TYPES_TL SUBT

140: T.LANGUAGE
141: ) in (select
142: SUBT.LOOKUP_TYPE,
143: SUBT.LANGUAGE
144: from FWK_TBX_LOOKUP_TYPES_TL SUBB, FWK_TBX_LOOKUP_TYPES_TL SUBT
145: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
146: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
147: and (SUBB.DISPLAY_NAME <> SUBT.DISPLAY_NAME
148: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 153: insert into FWK_TBX_LOOKUP_TYPES_TL (

149: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
150: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
151: ));
152:
153: insert into FWK_TBX_LOOKUP_TYPES_TL (
154: LAST_UPDATE_DATE,
155: LAST_UPDATED_BY,
156: CREATION_DATE,
157: CREATED_BY,

Line 175: from FWK_TBX_LOOKUP_TYPES_TL B, FND_LANGUAGES L

171: B.DISPLAY_NAME,
172: B.DESCRIPTION,
173: L.LANGUAGE_CODE,
174: B.SOURCE_LANG
175: from FWK_TBX_LOOKUP_TYPES_TL B, FND_LANGUAGES L
176: where L.INSTALLED_FLAG in ('I', 'B')
177: and B.LANGUAGE = userenv('LANG')
178: and not exists
179: (select NULL

Line 180: from FWK_TBX_LOOKUP_TYPES_TL T

176: where L.INSTALLED_FLAG in ('I', 'B')
177: and B.LANGUAGE = userenv('LANG')
178: and not exists
179: (select NULL
180: from FWK_TBX_LOOKUP_TYPES_TL T
181: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
182: and T.LANGUAGE = L.LANGUAGE_CODE);
183: end ADD_LANGUAGE;
184:

Line 203: from FWK_TBX_LOOKUP_TYPES_TL

199: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
200:
201: select last_updated_by, last_update_date
202: into db_luby, db_ludate
203: from FWK_TBX_LOOKUP_TYPES_TL
204: where lookup_type = X_LOOKUP_TYPE
205: and language = userenv('LANG');
206:
207: -- We want the values from file to be populated, if db has null value

Line 214: update FWK_TBX_LOOKUP_TYPES_TL set

210: db_luby := nvl(db_luby, fnd_load_util.owner_id('SEED'));
211:
212: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
213: db_ludate, X_CUSTOM_MODE)) then
214: update FWK_TBX_LOOKUP_TYPES_TL set
215: display_name = nvl(X_DISPLAY_NAME, display_name),
216: description = nvl(X_DESCRIPTION, description),
217: last_update_date = f_ludate,
218: last_updated_by = f_luby,

Line 250: from FWK_TBX_LOOKUP_TYPES_TL

246: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
247:
248: select last_updated_by, last_update_date
249: into db_luby, db_ludate
250: from FWK_TBX_LOOKUP_TYPES_TL
251: where lookup_type = X_LOOKUP_TYPE
252: and language = userenv('LANG');
253:
254: -- We want the values from file to be populated, if db has null value