[Home] [Help]
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,
113: M.program_id, M.program_login_id, M.program_application_id, M.request_id
114: FROM ibw_referral_categories_b M, fnd_languages l, fnd_languages b
115: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.referral_category_id=x_ref_cat_id;
116:
117:
118: INSERT INTO ibw_url_patterns_b (url_pattern_id, url_pattern, type_id, type, created_by, creation_date,
127: program_id, program_login_id, program_application_id, request_id)
128: SELECT M.url_pattern_id, l.language_code, b.language_code, NULL, M.created_by, M.creation_date,
129: M.last_updated_by, M.last_update_date, M.last_update_login, M.object_version_number,
130: M.program_id, M.program_login_id, M.program_application_id, M.request_id
131: FROM ibw_url_patterns_b M, fnd_languages l, fnd_languages b
132: WHERE l.installed_flag IN ('I','B') AND b.installed_flag='B' AND M.url_pattern_id=x_ref_pat_id;
133:
134:
135: OPEN c2;
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