28: l_syncind VARCHAR2(10);
29: l_clntyp VARCHAR2(30);
30:
31: BEGIN
32: ITG_Debug.setup(
33: p_reset => TRUE,
34: p_pkg_name => 'TRIGGER',
35: p_proc_name => 'itg_ip_headers_all_ARU');
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
32: ITG_Debug.setup(
33: p_reset => TRUE,
34: p_pkg_name => 'TRIGGER',
35: p_proc_name => 'itg_ip_headers_all_ARU');
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
33: p_reset => TRUE,
34: p_pkg_name => 'TRIGGER',
35: p_proc_name => 'itg_ip_headers_all_ARU');
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
34: p_pkg_name => 'TRIGGER',
35: p_proc_name => 'itg_ip_headers_all_ARU');
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
35: p_proc_name => 'itg_ip_headers_all_ARU');
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
36: ITG_Debug.msg('HA', 'new.type_lookup_code', :new.type_lookup_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
44: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
37: ITG_Debug.msg('HA', 'old.cancel_flag', :old.cancel_flag);
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
44: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
45:
38: ITG_Debug.msg('HA', 'new.cancel_flag', :new.cancel_flag);
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
44: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
45:
46: /* Modified all CANCEL PO wf event parms:
39: ITG_Debug.msg('HA', 'old.authorization_status', :old.authorization_status);
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
44: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
45:
46: /* Modified all CANCEL PO wf event parms:
47: p_id will always be po_header_id
40: ITG_Debug.msg('HA', 'new.authorization_status', :new.authorization_status);
41: ITG_Debug.msg('HA', 'new.revision_num', :new.revision_num);
42: ITG_Debug.msg('HA', 'new.po_header_id', :new.po_header_id);
43: ITG_Debug.msg('HA', 'old.closed_code', :old.closed_code);
44: ITG_Debug.msg('HA', 'new.closed_code', :new.closed_code);
45:
46: /* Modified all CANCEL PO wf event parms:
47: p_id will always be po_header_id
48: p_param1 will now be po_release_id (formerly, the case code of 1-6)
99: OPEN cur_po_action_history_cnt(:new.po_header_id);
100: FETCH cur_po_action_history_cnt INTO l_action_cnt;
101: CLOSE cur_po_action_history_cnt;
102:
103: ITG_Debug.msg('HA-1', 'l_action_code', l_action_code);
104: ITG_Debug.msg('HA-1', 'l_action_cnt', l_action_cnt);
105:
106: IF l_action_code = 'RELEASE HOLD' OR l_action_cnt > 1 THEN
107: l_syncind := 'C';
100: FETCH cur_po_action_history_cnt INTO l_action_cnt;
101: CLOSE cur_po_action_history_cnt;
102:
103: ITG_Debug.msg('HA-1', 'l_action_code', l_action_code);
104: ITG_Debug.msg('HA-1', 'l_action_cnt', l_action_cnt);
105:
106: IF l_action_code = 'RELEASE HOLD' OR l_action_cnt > 1 THEN
107: l_syncind := 'C';
108: l_clntyp := 'ITG_SYNC_PO_CHANGE';
127: OPEN cur_po_action_history(:new.po_header_id);
128: FETCH cur_po_action_history INTO l_action_code;
129: CLOSE cur_po_action_history;
130:
131: ITG_Debug.msg('HA-2', 'l_action_code', l_action_code);
132:
133: IF l_action_code <> 'HOLD' THEN
134: itg_outbound_utils.raise_wf_event(
135: p_bsr => 'SYNC_PO',
160:
161: END IF;
162:
163: END IF;
164: ITG_Debug.flush_to_logfile;
165: END;