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

Line 83: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

79: p_action IN VARCHAR2,
80: p_note IN VARCHAR2 default null)
81: IS
82: PRAGMA AUTONOMOUS_TRANSACTION;
83: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
84: BEGIN
85:
86: -----------------------------------------------------------------------
87: -- SQL What: Get the document information from the latest action history record.

Line 93: FROM PO_ACTION_HISTORY

89: -- inserting the action history record.
90: -----------------------------------------------------------------------
91: SELECT MAX(sequence_num)
92: INTO l_sequence_num
93: FROM PO_ACTION_HISTORY
94: WHERE object_type_code = p_document_type --'PO'
95: AND object_sub_type_code = p_document_subtype --'STANDARD'
96: AND object_id = p_document_id;
97:

Line 134: -- This procedure updates the po_action_history table based on the approvers response.

130: -- None.
131: --Locks:
132: -- None.
133: --Function:
134: -- This procedure updates the po_action_history table based on the approvers response.
135: --Parameters:
136: --IN:
137: -- p_document_id
138: -- p_draft_id

Line 168: UPDATE po_action_history

164: -- without the validation.
165: -----------------------------------------------------------------------
166: IF (p_current_approver IS NOT NULL) THEN
167:
168: UPDATE po_action_history
169: SET action_code = p_action,
170: note = p_note,
171: action_date = sysdate
172: WHERE object_id = p_document_id

Line 181: UPDATE po_action_history

177: AND rownum =1;
178:
179: ELSE
180:
181: UPDATE po_action_history
182: SET action_code = p_action, note = p_note, action_date = sysdate
183: WHERE object_id = p_document_id
184: AND action_code IS NULL
185: AND object_type_code = p_document_type

Line 1544: -- This procedure updates the po_action_history table based on the approvers response.

1540: --Locks:
1541: -- None.
1542: --Function:
1543: -- Workflow activity PL/SQL handler.
1544: -- This procedure updates the po_action_history table based on the approvers response.
1545: --Parameters:
1546: --IN:
1547: -- Standard workflow IN parameters
1548: --OUT:

Line 1593: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.

1589:
1590: -- Logic :
1591: -- + Fetch worklfow attributes required for updating NULL action to FORWARD action in
1592: -- action history against current approver.
1593: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1594: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'FORWARD'
1595:
1596: l_progress := '010';
1597: IF (g_po_wf_debug = 'Y') THEN

Line 1650: -- This procedure updates the po_action_history table based on the approvers response.

1646: --Locks:
1647: -- None.
1648: --Function:
1649: -- Workflow activity PL/SQL handler.
1650: -- This procedure updates the po_action_history table based on the approvers response.
1651: --Parameters:
1652: --IN:
1653: -- Standard workflow IN parameters
1654: --OUT:

Line 1700: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.

1696: -- Logic :
1697: -- + Fetch worklfow attributes required for updating NULL action to APPROVE for approver,
1698: -- REVIEW ACCEPTED for Reviewer into action history, SIGNED for ESIGNER
1699: -- against current approver/reviewer/esigner.
1700: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1701: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'APPROVE'
1702:
1703: l_progress := '010';
1704: IF (g_po_wf_debug = 'Y') THEN

Line 1774: -- This procedure updates the po_action_history table based on the approvers response.

1770: --Locks:
1771: -- None.
1772: --Function:
1773: -- Workflow activity PL/SQL handler.
1774: -- This procedure updates the po_action_history table based on the approvers response.
1775: --Parameters:
1776: --IN:
1777: -- Standard workflow IN parameters
1778: --OUT:

Line 1828: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.

1824: -- Logic :
1825: -- + Fetch worklfow attributes required for updating NULL action to REJECT for approver,
1826: -- REVIEW REJECTED for Reviewer into action history, SIGNER REJECTED for ESIGNER
1827: -- against current approver/reviewer/esigner.
1828: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1829: -- + Also set 'APPROVER_RESPONSE' workflow attribute with value 'REJECTED'
1830:
1831: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1832: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');

Line 1896: -- This procedure updates the po_action_history table based on the approvers response.

1892: --Locks:
1893: -- None.
1894: --Function:
1895: -- Workflow activity PL/SQL handler.
1896: -- This procedure updates the po_action_history table based on the approvers response.
1897: --Parameters:
1898: --IN:
1899: -- Standard workflow IN parameters
1900: --OUT:

Line 1948: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.

1944:
1945: -- Logic:
1946: -- + Fetch worklfow attributes required for updating NULL action to NO ACTION action into action history
1947: -- against current approver.
1948: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
1949:
1950: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
1951: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
1952: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

Line 2004: -- This procedure updates the po_action_history table based on the approvers response.

2000: --Locks:
2001: -- None.
2002: --Function:
2003: -- Workflow activity PL/SQL handler.
2004: -- This procedure updates the po_action_history table based on the approvers response.
2005: --Parameters:
2006: --IN:
2007: -- Standard workflow IN parameters
2008: --OUT:

Line 2056: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.

2052:
2053: -- Logic:
2054: -- + Fetch worklfow attributes required for updating NULL action to NO ACTION action into action history
2055: -- against current approver.
2056: -- + Call autonomous transaction UpdateActionHistoryPoAme to update po_action_history.
2057:
2058: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( aname=>'APPROVER_EMPID');
2059: l_document_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DOCUMENT_ID');
2060: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'DRAFT_ID');

Line 2695: l_action po_action_history.action_code%TYPE := NULL;

2691: l_preparer_appl_id NUMBER;
2692: l_preserved_ctx VARCHAR2(5);
2693: l_nid NUMBER;
2694: l_progress VARCHAR2(3);
2695: l_action po_action_history.action_code%TYPE := NULL;
2696: l_new_recipient_id wf_roles.orig_system_id%TYPE;
2697: l_current_recipient_id wf_roles.orig_system_id%TYPE;
2698: l_origsys wf_roles.orig_system%TYPE;
2699: l_document_id NUMBER;

Line 2817: --Update po_action_history NULL record against current approver/l_current_recipient_id with l_action.

2813:
2814: l_progress := '080';
2815:
2816: IF l_new_recipient_id IS NOT NULL THEN
2817: --Update po_action_history NULL record against current approver/l_current_recipient_id with l_action.
2818: UpdateActionHistoryPoAme(
2819: p_document_id => l_document_id,
2820: p_draft_id => l_draft_id,
2821: p_document_type => l_document_type,

Line 4216: -- This procedure updates the po_action_history with REMINDER based on no of reminder.

4212: --Locks:
4213: -- None.
4214: --Function:
4215: -- Workflow activity PL/SQL handler.
4216: -- This procedure updates the po_action_history with REMINDER based on no of reminder.
4217: --Parameters:
4218: --IN:
4219: -- Standard workflow IN parameters
4220: --OUT:

Line 4235: l_action po_action_history.action_code%TYPE := NULL;

4231: resultout OUT NOCOPY VARCHAR2)
4232: IS
4233: l_no_of_reminder NUMBER;
4234: l_progress VARCHAR2(3) := '000';
4235: l_action po_action_history.action_code%TYPE := NULL;
4236: l_current_approver NUMBER;
4237: l_document_id NUMBER;
4238: l_document_type VARCHAR2(25);
4239: l_document_subtype VARCHAR2(25);

Line 4694: FROM po_action_history poh

4690: l_supp_contact_user_name VARCHAR2(100);
4691:
4692: CURSOR employee_to_send_notif(p_po_header_id NUMBER) IS
4693: SELECT DISTINCT poh.employee_id
4694: FROM po_action_history poh
4695: WHERE poh.object_id = p_po_header_id
4696: AND poh.employee_id IS NOT NULL
4697: AND poh.sequence_num >= (SELECT MAX(sequence_num)
4698: FROM po_action_history poh1

Line 4698: FROM po_action_history poh1

4694: FROM po_action_history poh
4695: WHERE poh.object_id = p_po_header_id
4696: AND poh.employee_id IS NOT NULL
4697: AND poh.sequence_num >= (SELECT MAX(sequence_num)
4698: FROM po_action_history poh1
4699: WHERE poh1.object_id = p_po_header_id
4700: AND poh1.action_code = 'SUBMIT')
4701: UNION
4702: SELECT agent_id

Line 4867: l_note po_action_history.note%TYPE;

4863: l_log_head VARCHAR2(50) := g_module_prefix || 'withdraw_document';
4864: l_progress VARCHAR2(10);
4865: l_item_type wf_items.item_type%TYPE;
4866: l_item_key wf_items.item_key%TYPE;
4867: l_note po_action_history.note%TYPE;
4868: l_current_user_name VARCHAR2(100);
4869: l_disp_name VARCHAR2(240);
4870: l_send_notf_flag VARCHAR2(1);
4871: l_view_po_url VARCHAR2(1000);