APPS.ALR_DBTRIGGER dependencies on ALR_ALERTS

Line 244: from alr_alerts a,

240: no_org_flag varchar2(1);
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,

Line 294: from alr_alerts a,

290: into no_org_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,

Line 649: from alr_alerts a, alr_alert_installations i

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)

Line 727: from alr_alerts a, alr_alert_installations i

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)

Line 1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;

1111: APPL_ID in number,
1112: ALR_ID in number,
1113: OID in number) is
1114:
1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;
1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;

Line 1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;

1112: ALR_ID in number,
1113: OID in number) is
1114:
1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;
1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;
1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;

Line 1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;

1113: OID in number) is
1114:
1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;
1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;
1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;
1121:

Line 1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;

1114:
1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;
1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;
1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;
1121:
1122:

Line 1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;

1115: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;
1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;
1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;
1121:
1122:
1123: begin

Line 1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;

1116: TBL_NAME ALR_ALERTS.TABLE_NAME%type;
1117: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;
1118: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;
1119: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;
1120: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;
1121:
1122:
1123: begin
1124:

Line 1132: from ALR_ALERTS

1128: select TABLE_APPLICATION_ID, TABLE_NAME, INSERT_FLAG,
1129: UPDATE_FLAG, nvl(DELETE_FLAG, 'N'), ENABLED_FLAG
1130: into TBL_APPLID, TBL_NAME, IS_INSERT,
1131: IS_UPDATE, IS_DELETE, IS_ENABLED
1132: from ALR_ALERTS
1133: where ALERT_ID = ALR_ID AND APPLICATION_ID = APPL_ID
1134: and ALERT_CONDITION_TYPE = 'E';
1135:
1136: exception

Line 1175: OLD_TBLAPPLID alr_alerts.table_application_id%type;

1171: NEW_UPDATE_FLAG in varchar2,
1172: NEW_DELETE_FLAG in varchar2,
1173: NEW_IS_ENABLE in varchar2) is
1174:
1175: OLD_TBLAPPLID alr_alerts.table_application_id%type;
1176: OLD_TBLNM alr_alerts.TABLE_NAME%type;
1177: OLD_IFLAG char;
1178: OLD_UFLAG char;
1179: OLD_DFLAG char;

Line 1176: OLD_TBLNM alr_alerts.TABLE_NAME%type;

1172: NEW_DELETE_FLAG in varchar2,
1173: NEW_IS_ENABLE in varchar2) is
1174:
1175: OLD_TBLAPPLID alr_alerts.table_application_id%type;
1176: OLD_TBLNM alr_alerts.TABLE_NAME%type;
1177: OLD_IFLAG char;
1178: OLD_UFLAG char;
1179: OLD_DFLAG char;
1180: OLD_TYPE char;

Line 1192: from ALR_ALERTS

1188: select TABLE_APPLICATION_ID, TABLE_NAME, INSERT_FLAG, UPDATE_FLAG,
1189: nvl(DELETE_FLAG, 'N'), ALERT_CONDITION_TYPE
1190: into OLD_TBLAPPLID, OLD_TBLNM, OLD_IFLAG, OLD_UFLAG,
1191: OLD_DFLAG, OLD_TYPE
1192: from ALR_ALERTS
1193: where APPLICATION_ID=APPL_ID and ALERT_ID=ALR_ID;
1194:
1195: exception
1196: when others then