eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on PO_ACTION_HISTORY

Line 233: seq_num po_action_history_v.sequence_num%TYPE,

229: );
230:
231: TYPE history_record IS RECORD (
232:
233: seq_num po_action_history_v.sequence_num%TYPE,
234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,

Line 234: employee_name po_action_history_v.employee_name%TYPE,

230:
231: TYPE history_record IS RECORD (
232:
233: seq_num po_action_history_v.sequence_num%TYPE,
234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,
238: revision po_action_history_v.object_revision_num%TYPE);

Line 235: action po_action_history_v.action_code_dsp%TYPE,

231: TYPE history_record IS RECORD (
232:
233: seq_num po_action_history_v.sequence_num%TYPE,
234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,
238: revision po_action_history_v.object_revision_num%TYPE);
239:

Line 236: action_date po_action_history_v.action_date%TYPE,

232:
233: seq_num po_action_history_v.sequence_num%TYPE,
234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,
238: revision po_action_history_v.object_revision_num%TYPE);
239:
240: L_TABLE_STYLE VARCHAR2(100) := ' style="border-collapse:collapse" cellpadding="1" cellspacing="0" border="0" width="100%" ';

Line 237: note po_action_history_v.note%TYPE,

233: seq_num po_action_history_v.sequence_num%TYPE,
234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,
238: revision po_action_history_v.object_revision_num%TYPE);
239:
240: L_TABLE_STYLE VARCHAR2(100) := ' style="border-collapse:collapse" cellpadding="1" cellspacing="0" border="0" width="100%" ';
241:

Line 238: revision po_action_history_v.object_revision_num%TYPE);

234: employee_name po_action_history_v.employee_name%TYPE,
235: action po_action_history_v.action_code_dsp%TYPE,
236: action_date po_action_history_v.action_date%TYPE,
237: note po_action_history_v.note%TYPE,
238: revision po_action_history_v.object_revision_num%TYPE);
239:
240: L_TABLE_STYLE VARCHAR2(100) := ' style="border-collapse:collapse" cellpadding="1" cellspacing="0" border="0" width="100%" ';
241:
242: L_TABLE_HEADER_STYLE VARCHAR2(100) := ' class="tableheader" style="border-left:1px solid #f7f7e7" ';

Line 286: l_note po_action_history.note%TYPE;

282: l_new_tax_amt number;
283: l_new_tax_amount VARCHAR2(30);
284:
285:
286: l_note po_action_history.note%TYPE;
287:
288: l_document VARCHAR2(32000) := '';
289: l_header_msg VARCHAR2(2225);
290: l_document_2 VARCHAR2(32000) := '';

Line 461: l_note po_action_history.note%TYPE;

457: l_new_req_amount VARCHAR2(30);
458: l_new_tax_amount VARCHAR2(30);
459:
460:
461: l_note po_action_history.note%TYPE;
462:
463: l_document VARCHAR2(32000) := '';
464: l_header_msg VARCHAR2(2225);
465: l_document_2 VARCHAR2(32000) := '';

Line 1632: l_object_type po_action_history.object_type_code%TYPE;

1628: l_item_type wf_items.item_type%TYPE;
1629: l_item_key wf_items.item_key%TYPE;
1630:
1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1632: l_object_type po_action_history.object_type_code%TYPE;
1633: l_org_id po_requisition_lines.org_id%TYPE;
1634:
1635: l_document VARCHAR2(32000) := '';
1636: l_document_hist VARCHAR2(32000) := '';

Line 1656: from po_action_history poh,

1652: polc.DISPLAYED_FIELD,
1653: poh.ACTION_DATE,
1654: poh.NOTE,
1655: poh.OBJECT_REVISION_NUM
1656: from po_action_history poh,
1657: per_people_f per,
1658: po_lookup_codes polc
1659: where OBJECT_TYPE_CODE = v_object_type
1660: and poh.action_code = polc.lookup_code

Line 1673: from po_action_history poh,

1669: NULL,
1670: poh.ACTION_DATE,
1671: poh.NOTE,
1672: poh.OBJECT_REVISION_NUM
1673: from po_action_history poh,
1674: per_people_f per
1675: where OBJECT_TYPE_CODE = v_object_type
1676: and poh.action_code is null
1677: and per.person_id = poh.employee_id

Line 1729: from po_action_history

1725:
1726: /*
1727: select max(sequence_num)
1728: into l_first_seq
1729: from po_action_history
1730: where action_code='SUBMIT CHANGE'
1731: and object_type_code=l_object_type
1732: and object_id=l_document_id;
1733: */

Line 1820: l_object_type po_action_history.object_type_code%TYPE;

1816: max_seqno in number,
1817: p_document out NOCOPY varchar2) IS
1818:
1819: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1820: l_object_type po_action_history.object_type_code%TYPE;
1821: l_org_id po_requisition_lines.org_id%TYPE;
1822:
1823: l_document VARCHAR2(32000) := '';
1824: l_sub_document VARCHAR2(32000) := '';

Line 1940: l_note po_action_history.note%TYPE;

1936: NL VARCHAR2(1) := fnd_global.newline;
1937:
1938: l_base_href VARCHAR(2000) := fnd_profile.value('APPS_FRAMEWORK_AGENT');
1939:
1940: l_note po_action_history.note%TYPE;
1941: l_old_req_amount VARCHAR2(40);
1942: l_old_tax_amount VARCHAR2(40);
1943: l_new_req_amount VARCHAR2(40);
1944: l_new_tax_amount VARCHAR2(40);