18: sugg_site po_requisition_lines.suggested_vendor_location%TYPE);
19:
20: TYPE history_record IS RECORD (
21:
22: seq_num po_action_history_v.sequence_num%TYPE,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
19:
20: TYPE history_record IS RECORD (
21:
22: seq_num po_action_history_v.sequence_num%TYPE,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
27: revision po_action_history_v.object_revision_num%TYPE);
20: TYPE history_record IS RECORD (
21:
22: seq_num po_action_history_v.sequence_num%TYPE,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
27: revision po_action_history_v.object_revision_num%TYPE);
28:
21:
22: seq_num po_action_history_v.sequence_num%TYPE,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
27: revision po_action_history_v.object_revision_num%TYPE);
28:
29: PROCEDURE get_po_req_approve_msg(document_id in varchar2,
22: seq_num po_action_history_v.sequence_num%TYPE,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
27: revision po_action_history_v.object_revision_num%TYPE);
28:
29: PROCEDURE get_po_req_approve_msg(document_id in varchar2,
30: display_type in varchar2,
23: employee_name po_action_history_v.employee_name%TYPE,
24: action po_action_history_v.action_code_dsp%TYPE,
25: action_date po_action_history_v.action_date%TYPE,
26: note po_action_history_v.note%TYPE,
27: revision po_action_history_v.object_revision_num%TYPE);
28:
29: PROCEDURE get_po_req_approve_msg(document_id in varchar2,
30: display_type in varchar2,
31: document in out NOCOPY varchar2,