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_WF_PO_NOTIFICATION dependencies on PO_ACTION_HISTORY

Line 26: l_note po_action_history.note%TYPE;

22: l_forwarded_from per_all_people_f.full_name%TYPE;
23: l_preparer per_all_people_f.full_name%TYPE;
24: --
25: -- l_note VARCHAR2(480); /* < UTF8 FPI - changed from VARCHAR2(240) > */
26: l_note po_action_history.note%TYPE;
27: --
28: l_document VARCHAR2(32000) := '';
29: l_tax_amt NUMBER;
30:

Line 980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;

976:
977: -- Declare TABLEs for each column that is selected
978: -- from history_csr cursor.
979: --
980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;

Line 983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;

979: --
980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;

Line 984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;

980: TYPE sequence_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.sequence_num%TYPE;
981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
988:

Line 985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;

981: TYPE full_name_tbl_type IS TABLE OF PER_ALL_PEOPLE_F.full_name%TYPE;
982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
988:
989: l_sequence_num_tbl sequence_num_tbl_type;

Line 986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;

982: TYPE displayed_field_tbl_type IS TABLE OF PO_LOOKUP_CODES.displayed_field%TYPE;
983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
988:
989: l_sequence_num_tbl sequence_num_tbl_type;
990: l_employee_name_tbl full_name_tbl_type;

Line 987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;

983: TYPE action_date_tbl_type IS TABLE OF PO_ACTION_HISTORY.action_date%TYPE;
984: TYPE note_tbl_type IS TABLE OF PO_ACTION_HISTORY.note%TYPE;
985: TYPE object_revision_num_tbl_type IS TABLE OF PO_ACTION_HISTORY.object_revision_num%TYPE;
986: TYPE employee_id_tbl_type IS TABLE OF PO_ACTION_HISTORY.employee_id%TYPE;
987: TYPE created_by_tbl_type IS TABLE OF PO_ACTION_HISTORY.created_by%TYPE;
988:
989: l_sequence_num_tbl sequence_num_tbl_type;
990: l_employee_name_tbl full_name_tbl_type;
991: l_action_tbl displayed_field_tbl_type;

Line 1011: from po_action_history poh,

1007: poh.NOTE,
1008: poh.OBJECT_REVISION_NUM,
1009: poh.employee_id, /* bug 2788683 */
1010: poh.created_by /* bug 2788683 */
1011: from po_action_history poh,
1012: per_all_people_f per, -- Bug 3404451
1013: po_lookup_codes polc
1014: where OBJECT_TYPE_CODE = v_doc_type_code
1015: and poh.action_code = polc.lookup_code

Line 1030: from po_action_history poh,

1026: poh.NOTE,
1027: poh.OBJECT_REVISION_NUM,
1028: poh.employee_id, /* bug 2788683 */
1029: poh.created_by /* bug 2788683 */
1030: from po_action_history poh,
1031: per_all_people_f per -- Bug 3404451
1032: where OBJECT_TYPE_CODE = v_doc_type_code
1033: and poh.action_code is null
1034: and per.person_id(+) = poh.employee_id /* bug 2788683 */