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