29:
30: v_action_code po_action_history.action_code%TYPE;
31: v_action_cnt NUMBER;
32: BEGIN
33: ITG_Debug.setup(
34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
34: p_reset => TRUE,
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>
35: p_pkg_name => 'TRIGGER',
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>
43: upper(nvl(:new.authorization_status,'z')) THEN
36: p_proc_name => 'itg_ip_requisition_headers_ARU');
37:
38: ITG_Debug.msg('RH', 'old.authorization_status', :old.authorization_status);
39: ITG_Debug.msg('RH', 'new.authorization_status', :new.authorization_status);
40: ITG_Debug.msg('RH', 'new.requisition_header_id', :new.requisition_header_id);
41:
42: IF upper(nvl(:old.authorization_status,'a')) <>
43: upper(nvl(:new.authorization_status,'z')) THEN
44: IF upper(:new.authorization_status) = 'APPROVED' THEN
49: OPEN cur_req_action_history_cnt(:new.requisition_header_id);
50: FETCH cur_req_action_history_cnt into v_action_cnt;
51: CLOSE cur_req_action_history_cnt;
52:
53: ITG_Debug.msg('RH', 'v_action_code', v_action_code);
54: ITG_Debug.msg('RH', 'v_action_cnt', v_action_cnt);
55:
56: IF v_action_code = 'WITHDRAW' AND v_action_cnt > 1 THEN
57: itg_outbound_utils.raise_wf_event (
50: FETCH cur_req_action_history_cnt into v_action_cnt;
51: CLOSE cur_req_action_history_cnt;
52:
53: ITG_Debug.msg('RH', 'v_action_code', v_action_code);
54: ITG_Debug.msg('RH', 'v_action_cnt', v_action_cnt);
55:
56: IF v_action_code = 'WITHDRAW' AND v_action_cnt > 1 THEN
57: itg_outbound_utils.raise_wf_event (
58: p_bsr => 'CHANGE_REQUISITN',
80: p_doc => :new.segment1,
81: p_param1 => '1');
82: END IF;
83: END IF;
84: ITG_Debug.flush_to_logfile;
85: END;