[Home] [Help]
241:
242: cursor C is
243: select DISTINCT ORACLE_USERNAME, DATA_GROUP_ID ORG_ID
244: from alr_alerts a,
245: alr_alert_installations i,
246: fnd_oracle_userid o
247: where a.alert_condition_type='E'
248: and 'Y'=decode(EVENT_MODE, 'I', a.insert_flag,
249: 'U', a.update_flag,
291: from dual
292: where exists
293: (select 1
294: from alr_alerts a,
295: alr_alert_installations i
296: where a.alert_condition_type='E'
297: and 'Y'=decode(EVENT_MODE, 'I', a.insert_flag,
298: 'U', a.update_flag,
299: 'D', a.delete_flag)
560:
561: cursor c1 is
562: select DISTINCT
563: ORACLE_USERNAME, O.ORACLE_ID
564: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I
565: where O.ORACLE_ID = NVL(OID, O.ORACLE_ID)
566: and O.ORACLE_ID = I.ORACLE_ID
567: and I.APPLICATION_ID = APPL_ID
568: and I.ALERT_ID = ALR_ID
645: -- Drop trigger if this is the only one alert;
646: -- otherwise, simply attempt to disable.
647:
648: select count(*) into enabled_count
649: from alr_alerts a, alr_alert_installations i
650: where alert_condition_type='E'
651: and 'Y'=decode(EVENT_MODE, 'I', insert_flag,
652: 'U', update_flag,
653: 'D', delete_flag)
723:
724: elsif IS_ENABLE = 'N' and TRG_STATUS <> 'DISABLED' then
725:
726: select count(*) into other_enabled_count
727: from alr_alerts a, alr_alert_installations i
728: where alert_condition_type='E'
729: and 'Y'=decode(EVENT_MODE, 'I', insert_flag,
730: 'U', update_flag,
731: 'D', delete_flag)
957:
958: cursor C is
959: select DISTINCT
960: ORACLE_USERNAME, O.ORACLE_ID, I.ENABLED_FLAG ENABLED_INST
961: from FND_ORACLE_USERID O, ALR_ALERT_INSTALLATIONS I
962: where O.ORACLE_ID = NVL(OID, O.ORACLE_ID)
963: and O.ORACLE_ID = I.ORACLE_ID
964: and I.APPLICATION_ID = NVL(APPL_ID, I.APPLICATION_ID)
965: and I.ALERT_ID = NVL(ALR_ID, I.ALERT_ID)