APPS.FND_OAM_DSCRAM dependencies on FND_OAM_DS_PSETS_TL

Line 183: insert into FND_OAM_DS_PSETS_TL (

179: (psetid, l_created_by, sysdate,
180: l_last_updated_by, sysdate, l_last_update_login);
181:
182:
183: insert into FND_OAM_DS_PSETS_TL (
184: policyset_id,
185: policyset_name,
186: description,
187: CREATED_BY,

Line 205: from FND_OAM_DS_PSETS_TL T

201: from FND_LANGUAGES L
202: where L.INSTALLED_FLAG in ('I', 'B')
203: and not exists
204: (select NULL
205: from FND_OAM_DS_PSETS_TL T
206: where T.POLICYSET_ID = psetid
207: and T.LANGUAGE = L.LANGUAGE_CODE);
208:
209: commit;

Line 240: delete from FND_OAM_DS_PSETS_TL

236: where policyset_id = psetid;
237:
238:
239: /* Make sure no bad data in tl table */
240: delete from FND_OAM_DS_PSETS_TL
241: where policyset_id = psetid
242: and language in (select l.language_code
243: from fnd_languages l
244: where l.installed_flag in ('I', 'B'));

Line 247: insert into FND_OAM_DS_PSETS_TL (

243: from fnd_languages l
244: where l.installed_flag in ('I', 'B'));
245:
246:
247: insert into FND_OAM_DS_PSETS_TL (
248: policyset_id,
249: policyset_name,
250: description,
251: CREATED_BY,

Line 269: from FND_OAM_DS_PSETS_TL T

265: from FND_LANGUAGES L
266: where L.INSTALLED_FLAG in ('I', 'B')
267: and not exists
268: (select NULL
269: from FND_OAM_DS_PSETS_TL T
270: where T.POLICYSET_ID = psetid
271: and T.LANGUAGE = L.LANGUAGE_CODE);
272:
273: /* Delete all policy set elements for this policy set. */

Line 660: delete from FND_OAM_DS_PSETS_TL where policyset_id = pset_id;

656:
657: begin
658:
659: delete from FND_OAM_DS_PSETS_B where policyset_id = pset_id;
660: delete from FND_OAM_DS_PSETS_TL where policyset_id = pset_id;
661: delete from FND_OAM_DS_PSET_ELMNTS where policyset_id = pset_id;
662:
663: commit;
664: EXCEPTION