APPS.IBC_FILE_EXTN_MAPPINGS_PKG dependencies on IBC_FILE_EXTN_MAPPINGS_TL

Line 37: insert into IBC_FILE_EXTN_MAPPINGS_TL (

33: X_LAST_UPDATED_BY,
34: X_LAST_UPDATE_LOGIN
35: );
36:
37: insert into IBC_FILE_EXTN_MAPPINGS_TL (
38: LAST_UPDATE_DATE,
39: LAST_UPDATE_LOGIN,
40: LAST_UPDATED_BY,
41: MAPPING_ID,

Line 63: from IBC_FILE_EXTN_MAPPINGS_TL T

59: from FND_LANGUAGES L
60: where L.INSTALLED_FLAG in ('I', 'B')
61: and not exists
62: (select NULL
63: from IBC_FILE_EXTN_MAPPINGS_TL T
64: where T.MAPPING_ID = X_MAPPING_ID
65: and T.LANGUAGE = L.LANGUAGE_CODE);
66:
67: open c;

Line 94: from IBC_FILE_EXTN_MAPPINGS_TL

90: cursor c1 is select
91: EXTENSION,
92: DESCRIPTION,
93: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
94: from IBC_FILE_EXTN_MAPPINGS_TL
95: where MAPPING_ID = X_MAPPING_ID
96: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
97: for update of MAPPING_ID nowait;
98: begin

Line 152: update IBC_FILE_EXTN_MAPPINGS_TL set

148: if (sql%notfound) then
149: raise no_data_found;
150: end if;
151:
152: update IBC_FILE_EXTN_MAPPINGS_TL set
153: EXTENSION = X_EXTENSION,
154: DESCRIPTION = X_DESCRIPTION,
155: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
156: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 171: delete from IBC_FILE_EXTN_MAPPINGS_TL

167: procedure DELETE_ROW (
168: X_MAPPING_ID in NUMBER
169: ) is
170: begin
171: delete from IBC_FILE_EXTN_MAPPINGS_TL
172: where MAPPING_ID = X_MAPPING_ID;
173:
174: if (sql%notfound) then
175: raise no_data_found;

Line 189: delete from IBC_FILE_EXTN_MAPPINGS_TL T

185:
186: procedure ADD_LANGUAGE
187: is
188: begin
189: delete from IBC_FILE_EXTN_MAPPINGS_TL T
190: where not exists
191: (select NULL
192: from IBC_FILE_EXTN_MAPPINGS_B B
193: where B.MAPPING_ID = T.MAPPING_ID

Line 196: update IBC_FILE_EXTN_MAPPINGS_TL T set (

192: from IBC_FILE_EXTN_MAPPINGS_B B
193: where B.MAPPING_ID = T.MAPPING_ID
194: );
195:
196: update IBC_FILE_EXTN_MAPPINGS_TL T set (
197: EXTENSION,
198: DESCRIPTION
199: ) = (select
200: B.EXTENSION,

Line 202: from IBC_FILE_EXTN_MAPPINGS_TL B

198: DESCRIPTION
199: ) = (select
200: B.EXTENSION,
201: B.DESCRIPTION
202: from IBC_FILE_EXTN_MAPPINGS_TL B
203: where B.MAPPING_ID = T.MAPPING_ID
204: and B.LANGUAGE = T.SOURCE_LANG)
205: where (
206: T.MAPPING_ID,

Line 211: from IBC_FILE_EXTN_MAPPINGS_TL SUBB, IBC_FILE_EXTN_MAPPINGS_TL SUBT

207: T.LANGUAGE
208: ) in (select
209: SUBT.MAPPING_ID,
210: SUBT.LANGUAGE
211: from IBC_FILE_EXTN_MAPPINGS_TL SUBB, IBC_FILE_EXTN_MAPPINGS_TL SUBT
212: where SUBB.MAPPING_ID = SUBT.MAPPING_ID
213: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
214: and (SUBB.EXTENSION <> SUBT.EXTENSION
215: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 220: insert into IBC_FILE_EXTN_MAPPINGS_TL (

216: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
217: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
218: ));
219:
220: insert into IBC_FILE_EXTN_MAPPINGS_TL (
221: LAST_UPDATE_DATE,
222: LAST_UPDATE_LOGIN,
223: LAST_UPDATED_BY,
224: MAPPING_ID,

Line 242: from IBC_FILE_EXTN_MAPPINGS_TL B, FND_LANGUAGES L

238: B.CREATED_BY,
239: B.CREATION_DATE,
240: L.LANGUAGE_CODE,
241: B.SOURCE_LANG
242: from IBC_FILE_EXTN_MAPPINGS_TL B, FND_LANGUAGES L
243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL

Line 247: from IBC_FILE_EXTN_MAPPINGS_TL T

243: where L.INSTALLED_FLAG in ('I', 'B')
244: and B.LANGUAGE = userenv('LANG')
245: and not exists
246: (select NULL
247: from IBC_FILE_EXTN_MAPPINGS_TL T
248: where T.MAPPING_ID = B.MAPPING_ID
249: and T.LANGUAGE = L.LANGUAGE_CODE);
250: end ADD_LANGUAGE;
251:

Line 363: FROM IBC_FILE_EXTN_MAPPINGS_TL

359: l_last_update_date := nvl(TO_DATE(p_last_update_date, 'YYYY/MM/DD'),SYSDATE);
360:
361: -- get updatedby and update_date values if existing in db
362: SELECT LAST_UPDATED_BY, LAST_UPDATE_DATE INTO db_user_id, db_last_update_date
363: FROM IBC_FILE_EXTN_MAPPINGS_TL
364: WHERE MAPPING_ID = p_mapping_id
365: AND USERENV('LANG') IN (LANGUAGE, source_lang);
366:
367: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,

Line 370: UPDATE IBC_FILE_EXTN_MAPPINGS_TL

366:
367: IF (FND_LOAD_UTIL.UPLOAD_TEST(l_user_id, l_last_update_date,
368: db_user_id, db_last_update_date, p_upload_mode )) THEN
369: -- Only update rows which have not been altered by user
370: UPDATE IBC_FILE_EXTN_MAPPINGS_TL
371: SET description = p_description,
372: Extension = p_Extension,
373: source_lang = USERENV('LANG'),
374: last_update_date = l_last_update_date,