24: l_syncind VARCHAR2(10) := NULL;
25: l_doc_num VARCHAR2(100);
26: l_clntyp VARCHAR2(30);
27: BEGIN
28: ITG_Debug.setup(
29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
28: ITG_Debug.setup(
29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
29: p_reset => TRUE,
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
30: p_pkg_name => 'TRIGGER',
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
31: p_proc_name => 'itg_ip_releases_all_ARU');
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:
32: ITG_Debug.msg('RA', 'new.cancel_flag', :new.cancel_flag);
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:
40: p_id will always be po_header_id
33: ITG_Debug.msg('RA', 'new.approved_flag', :new.approved_flag);
34: ITG_Debug.msg('RA', 'new.po_header_id', :new.po_header_id);
35: ITG_Debug.msg('RA', 'new.po_release_id', :new.po_release_id);
36: ITG_Debug.msg('RA', 'old.authorization_status', :old.authorization_status);
37: ITG_Debug.msg('RA', 'new.authorization_status', :new.authorization_status);
38:
39: /* Modified all CANCEL PO wf event parms:
40: p_id will always be po_header_id
41: p_param1 will now be po_release_id (formerly, the case code of 1-6)
77: OPEN cur_po_action_history_cnt(:new.po_release_id);
78: FETCH cur_po_action_history_cnt INTO l_action_cnt;
79: CLOSE cur_po_action_history_cnt;
80:
81: ITG_Debug.msg('RA', 'l_action_cnt', l_action_cnt);
82:
83: IF ((l_action_cnt > 1 AND
84: UPPER(:new.authorization_status) = 'APPROVED') OR
85: UPPER(:new.authorization_status) = 'REQUIRES REAPPROVAL') THEN
108: p_param4 => :new.authorization_status);
109: END IF;
110:
111: END IF;
112: ITG_Debug.flush_to_logfile;
113: END;