[Home] [Help]
21: -- 12-May-2006 asylvia Bug 5199719 - SQL Repository fixes
22: -- 21-Jul-2006 kpatro Bug 5390527 - fix for 'Validate Budget and Quota Thresholds' conc program
23: -- NOTE
24: -- Will prcess the thresholds and creates
25: -- - notification information in ams_act_logs
26: -- - table. Will make a call to notification
27: -- - package.
28: -- End of Comments
29: -- ===============================================================
748: CURSOR c_notification_exist(x_threshold_id NUMBER,
749: x_threshold_rule_id NUMBER,
750: x_budget_id NUMBER) IS
751: SELECT Max(notification_creation_date)
752: FROM AMS_ACT_LOGS
753: WHERE arc_act_log_used_by = 'FTHO'
754: AND act_log_used_by_id = x_threshold_rule_id
755: AND budget_id = x_budget_id
756: AND threshold_id = x_threshold_id;
798: IF p_frequency_period = 'YEARLY' THEN
799: l_notify_freq_days := p_repeat_frequency * 365;
800: END IF;
801:
802: -- checks entry in the ams_act_logs table for notification_purposes
803: OPEN c_notification_exist(p_threshold_id,
804: p_threshold_rule_id,
805: p_budget_id);
806: FETCH c_notification_exist INTO l_notified_date;
960: AND c.threshold_rule_id = p_threshold_rule_id
961: AND c.end_date >= SYSDATE;
962:
963: CURSOR c_log_seq IS
964: SELECT ams_act_logs_s.NEXTVAL
965: FROM DUAL;
966:
967: CURSOR c_trans_seq IS
968: SELECT ams_act_logs_transaction_id_s.NEXTVAL
964: SELECT ams_act_logs_s.NEXTVAL
965: FROM DUAL;
966:
967: CURSOR c_trans_seq IS
968: SELECT ams_act_logs_transaction_id_s.NEXTVAL
969: FROM DUAL;
970:
971:
972: CURSOR c_log_message (p_trans_id NUMBER)
971:
972: CURSOR c_log_message (p_trans_id NUMBER)
973: IS
974: SELECT budget_id, log_message_text
975: FROM ams_act_logs
976: WHERE log_transaction_id = p_trans_id;
977:
978: CURSOR c_owner(p_budget_id NUMBER)
979: IS