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 1112: TBL_APPLID ALR_ALERTS.TABLE_APPLICATION_ID%type;

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

Line 1113: TBL_NAME ALR_ALERTS.TABLE_NAME%type;

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

Line 1114: IS_INSERT ALR_ALERTS.INSERT_FLAG%type;

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

Line 1115: IS_UPDATE ALR_ALERTS.UPDATE_FLAG%type;

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

Line 1116: IS_DELETE ALR_ALERTS.DELETE_FLAG%type;

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

Line 1117: IS_ENABLED ALR_ALERTS.ENABLED_FLAG%type;

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

Line 1129: from ALR_ALERTS

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

Line 1172: OLD_TBLAPPLID alr_alerts.table_application_id%type;

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

Line 1173: OLD_TBLNM alr_alerts.TABLE_NAME%type;

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

Line 1189: from ALR_ALERTS

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