18: l_ponumber VARCHAR2(100);
19: l_doc_num VARCHAR2(100);
20: l_found BOOLEAN;
21: BEGIN
22: ITG_Debug.setup(
23: p_reset => TRUE,
24: p_pkg_name => 'TRIGGER',
25: p_proc_name => 'itg_ip_lines_all_ARU');
26: ITG_Debug.msg('LA', 'new.cancel_flag', :new.cancel_flag);
22: ITG_Debug.setup(
23: p_reset => TRUE,
24: p_pkg_name => 'TRIGGER',
25: p_proc_name => 'itg_ip_lines_all_ARU');
26: ITG_Debug.msg('LA', 'new.cancel_flag', :new.cancel_flag);
27: ITG_Debug.msg('LA', 'new.po_header_id', :new.po_header_id);
28:
29: /* Modified all CANCEL PO wf event parms:
30: p_id will always be po_header_id
23: p_reset => TRUE,
24: p_pkg_name => 'TRIGGER',
25: p_proc_name => 'itg_ip_lines_all_ARU');
26: ITG_Debug.msg('LA', 'new.cancel_flag', :new.cancel_flag);
27: ITG_Debug.msg('LA', 'new.po_header_id', :new.po_header_id);
28:
29: /* Modified all CANCEL PO wf event parms:
30: p_id will always be po_header_id
31: p_param1 will now be po_release_id or NULL
50: p_doc => l_doc_num,
51: p_param2 => :new.po_line_id);
52: END IF;
53: END IF;
54: ITG_Debug.flush_to_logfile;
55: END;