APPS.PO_WF_DOCUMENT dependencies on PO_ACTION_HISTORY

Line 22: seq_num po_action_history_v.sequence_num%TYPE,

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,

Line 23: employee_name po_action_history_v.employee_name%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);

Line 24: action po_action_history_v.action_code_dsp%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:

Line 25: action_date po_action_history_v.action_date%TYPE,

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,

Line 26: note po_action_history_v.note%TYPE,

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,

Line 27: revision po_action_history_v.object_revision_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,
31: document in out NOCOPY varchar2,

Line 1024: l_object_type po_action_history.object_type_code%TYPE;

1020: l_item_type wf_items.item_type%TYPE;
1021: l_item_key wf_items.item_key%TYPE;
1022:
1023: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1024: l_object_type po_action_history.object_type_code%TYPE;
1025: l_org_id po_requisition_lines.org_id%TYPE;
1026:
1027: l_document VARCHAR2(32000) := '';
1028:

Line 1041: from po_action_history poh,

1037: polc.DISPLAYED_FIELD,
1038: poh.ACTION_DATE,
1039: poh.NOTE,
1040: poh.OBJECT_REVISION_NUM
1041: from po_action_history poh,
1042: per_people_f per,
1043: po_lookup_codes polc
1044: where OBJECT_TYPE_CODE = v_object_type
1045: and poh.action_code = polc.lookup_code

Line 1058: from po_action_history poh,

1054: NULL,
1055: poh.ACTION_DATE,
1056: poh.NOTE,
1057: poh.OBJECT_REVISION_NUM
1058: from po_action_history poh,
1059: per_people_f per
1060: where OBJECT_TYPE_CODE = 'REQUISITION'
1061: and poh.action_code is null
1062: and per.person_id = poh.employee_id