APPS.IBW_REFERRAL_PVT dependencies on IBW_REFERRAL_CATEGORIES_TL

Line 16: -- Offline engine uses this API to insert records into IBW_REFERRAL_CATEGORIES_B, IBW_REFERRAL_CATEGORIES_TL,

12: -- PURPOSE
13: -- Private API for inserting records into referral categories and also referral patterns. Mainly used by offline engine
14: --
15: -- NOTES
16: -- Offline engine uses this API to insert records into IBW_REFERRAL_CATEGORIES_B, IBW_REFERRAL_CATEGORIES_TL,
17: -- IBW_REFERRAL_PATTERNS_B, IBW_REFERRAL_PATTERNS_TL
18:
19: -- HISTORY
20: -- 05/10/2005 VEKANCHA Created

Line 108: INSERT INTO ibw_referral_categories_tl(referral_category_id, language, source_lang, referral_category_name, description, created_by, creation_date,

104: VALUES (x_ref_cat_id, x_status, x_user_def_flag, created_by, creation_date,
105: last_updated_by, last_update_date, last_update_login, obj_ver_number,
106: program_id, program_login_id, program_app_id, request_id);
107:
108: INSERT INTO ibw_referral_categories_tl(referral_category_id, language, source_lang, referral_category_name, description, created_by, creation_date,
109: last_updated_by, last_update_date, last_update_login, object_version_number,
110: program_id, program_login_id, program_application_id, request_id)
111: SELECT M.referral_category_id, l.language_code, b.language_code, x_referral_category_name, NULL, M.created_by, M.creation_date,
112: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,

Line 152: delete from IBW_REFERRAL_CATEGORIES_TL T

148:
149: procedure ADD_LANGUAGE
150: is
151: begin
152: delete from IBW_REFERRAL_CATEGORIES_TL T
153: where not exists
154: (select NULL
155: from IBW_REFERRAL_CATEGORIES_B B
156: where B.REFERRAL_CATEGORY_ID = T.REFERRAL_CATEGORY_ID

Line 159: update IBW_REFERRAL_CATEGORIES_TL T set (

155: from IBW_REFERRAL_CATEGORIES_B B
156: where B.REFERRAL_CATEGORY_ID = T.REFERRAL_CATEGORY_ID
157: );
158:
159: update IBW_REFERRAL_CATEGORIES_TL T set (
160: REFERRAL_CATEGORY_NAME,
161: DESCRIPTION
162: ) = (select
163: B.REFERRAL_CATEGORY_NAME,

Line 165: from IBW_REFERRAL_CATEGORIES_TL B

161: DESCRIPTION
162: ) = (select
163: B.REFERRAL_CATEGORY_NAME,
164: B.DESCRIPTION
165: from IBW_REFERRAL_CATEGORIES_TL B
166: where B.REFERRAL_CATEGORY_ID = T.REFERRAL_CATEGORY_ID
167: and B.LANGUAGE = T.SOURCE_LANG)
168: where (
169: T.REFERRAL_CATEGORY_ID,

Line 174: from IBW_REFERRAL_CATEGORIES_TL SUBB, IBW_REFERRAL_CATEGORIES_TL SUBT

170: T.LANGUAGE
171: ) in (select
172: SUBT.REFERRAL_CATEGORY_ID,
173: SUBT.LANGUAGE
174: from IBW_REFERRAL_CATEGORIES_TL SUBB, IBW_REFERRAL_CATEGORIES_TL SUBT
175: where SUBB.REFERRAL_CATEGORY_ID = SUBT.REFERRAL_CATEGORY_ID
176: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
177: and (SUBB.REFERRAL_CATEGORY_NAME <> SUBT.REFERRAL_CATEGORY_NAME
178: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 183: insert into IBW_REFERRAL_CATEGORIES_TL (

179: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
180: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
181: ));
182:
183: insert into IBW_REFERRAL_CATEGORIES_TL (
184: REFERRAL_CATEGORY_ID,
185: REFERRAL_CATEGORY_NAME,
186: DESCRIPTION,
187: OBJECT_VERSION_NUMBER,

Line 215: from IBW_REFERRAL_CATEGORIES_TL B, FND_LANGUAGES L

211: B.PROGRAM_APPLICATION_ID,
212: B.REQUEST_ID,
213: L.LANGUAGE_CODE,
214: B.SOURCE_LANG
215: from IBW_REFERRAL_CATEGORIES_TL B, FND_LANGUAGES L
216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL

Line 220: from IBW_REFERRAL_CATEGORIES_TL T

216: where L.INSTALLED_FLAG in ('I', 'B')
217: and B.LANGUAGE = userenv('LANG')
218: and not exists
219: (select NULL
220: from IBW_REFERRAL_CATEGORIES_TL T
221: where T.REFERRAL_CATEGORY_ID = B.REFERRAL_CATEGORY_ID
222: and T.LANGUAGE = L.LANGUAGE_CODE);
223: end ADD_LANGUAGE;
224: