APPS.OZF_QUOTA_THRESHOLD_PVT dependencies on AMS_ACT_LOGS

Line 18: -- notification information in ams_act_logs

14: -- l_operation_result IF stmt
15:
16: -- NOTE
17: -- Will prcess the quota thresholds and creates
18: -- notification information in ams_act_logs
19: -- table. Will make a call to notification
20: -- package. Will insert alert types for dashboard use.
21: -- End of Comments
22: -- ===============================================================

Line 305: SELECT ams_act_logs_s.NEXTVAL

301: AND report_date = trunc(SYSDATE)
302: ORDER BY sequence_number;
303:
304: CURSOR c_log_seq IS
305: SELECT ams_act_logs_s.NEXTVAL
306: FROM DUAL;
307:
308: CURSOR c_trans_seq IS
309: SELECT ams_act_logs_transaction_id_s.NEXTVAL

Line 309: SELECT ams_act_logs_transaction_id_s.NEXTVAL

305: SELECT ams_act_logs_s.NEXTVAL
306: FROM DUAL;
307:
308: CURSOR c_trans_seq IS
309: SELECT ams_act_logs_transaction_id_s.NEXTVAL
310: FROM DUAL;
311:
312:
313: CURSOR c_log_message (p_trans_id NUMBER)

Line 316: FROM ams_act_logs

312:
313: CURSOR c_log_message (p_trans_id NUMBER)
314: IS
315: SELECT budget_id, log_message_text
316: FROM ams_act_logs
317: WHERE log_transaction_id = p_trans_id;
318:
319: CURSOR c_owner(p_budget_id NUMBER)
320: IS

Line 1104: -- Checks ams_act_logs table if there already is a notification sent to

1100: -- x_msg_data OUT VARCHAR2
1101: -- x_return_status OUT VARCHAR2
1102: -- x_result OUT VARCHAR2 -- NOTIFY OR NO_NOTIFY
1103:
1104: -- Checks ams_act_logs table if there already is a notification sent to
1105: -- the budget owner or not for a threshold rule violation
1106:
1107: -----------------------------------------------------------------------
1108: PROCEDURE verify_notification(

Line 1132: FROM AMS_ACT_LOGS

1128: CURSOR c_notification_exist(x_threshold_id NUMBER,
1129: x_threshold_rule_id NUMBER,
1130: x_budget_id NUMBER) IS
1131: SELECT Max(notification_creation_date)
1132: FROM AMS_ACT_LOGS
1133: WHERE arc_act_log_used_by = 'FTHO'
1134: AND act_log_used_by_id = x_threshold_rule_id
1135: AND budget_id = x_budget_id
1136: AND threshold_id = x_threshold_id;

Line 1182: -- checks entry in the ams_act_logs table for notification_purposes

1178: IF p_frequency_period = 'YEARLY' THEN
1179: l_notify_freq_days := p_repeat_frequency * 365;
1180: END IF;
1181:
1182: -- checks entry in the ams_act_logs table for notification_purposes
1183: OPEN c_notification_exist(p_threshold_id,
1184: p_threshold_rule_id,
1185: p_budget_id);
1186: FETCH c_notification_exist INTO l_notified_date;