APPS.PO_WF_REQ_NOTIFICATION_R11 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:

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:
30: PROCEDURE get_po_req_approve_msg(document_id 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:
30: PROCEDURE get_po_req_approve_msg(document_id in varchar2,
31: display_type in varchar2,

Line 1282: l_object_type po_action_history.object_type_code%TYPE;

1278: l_item_type wf_items.item_type%TYPE;
1279: l_item_key wf_items.item_key%TYPE;
1280:
1281: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1282: l_object_type po_action_history.object_type_code%TYPE;
1283: l_org_id po_requisition_lines.org_id%TYPE;
1284:
1285: l_document VARCHAR2(32000) := '';
1286:

Line 1301: from po_action_history poh,

1297: polc.DISPLAYED_FIELD,
1298: poh.ACTION_DATE,
1299: poh.NOTE,
1300: poh.OBJECT_REVISION_NUM
1301: from po_action_history poh,
1302: per_people_f per,
1303: po_lookup_codes polc
1304: where OBJECT_TYPE_CODE = v_object_type
1305: and poh.action_code = polc.lookup_code

Line 1318: from po_action_history poh,

1314: NULL,
1315: poh.ACTION_DATE,
1316: poh.NOTE,
1317: poh.OBJECT_REVISION_NUM
1318: from po_action_history poh,
1319: per_people_f per
1320: where OBJECT_TYPE_CODE = v_object_type
1321: and poh.action_code is null
1322: and per.person_id = poh.employee_id