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.POR_AME_REQ_WF_PVT dependencies on PO_ACTION_HISTORY

Line 1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

1440:
1441: is
1442: pragma AUTONOMOUS_TRANSACTION;
1443:
1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

1441: is
1442: pragma AUTONOMOUS_TRANSACTION;
1443:
1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

1442: pragma AUTONOMOUS_TRANSACTION;
1443:
1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

1443:
1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

1444: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
1452: l_progress VARCHAR2(100) := '000';

Line 1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

1445: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
1452: l_progress VARCHAR2(100) := '000';
1453:

Line 1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

1446: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
1452: l_progress VARCHAR2(100) := '000';
1453:
1454: begin

Line 1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

1447: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
1448: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
1449: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
1450: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
1451: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
1452: l_progress VARCHAR2(100) := '000';
1453:
1454: begin
1455:

Line 1458: FROM PO_ACTION_HISTORY

1454: begin
1455:
1456: SELECT max(sequence_num)
1457: INTO l_sequence_num
1458: FROM PO_ACTION_HISTORY
1459: WHERE object_type_code = 'REQUISITION'
1460: AND object_id = p_req_header_id;
1461:
1462: SELECT object_sub_type_code,

Line 1468: FROM PO_ACTION_HISTORY

1464: program_application_id, program_date, program_id
1465: INTO l_object_sub_type_code,
1466: l_object_revision_num, l_approval_path_id, l_request_id,
1467: l_program_application_id, l_program_date, l_program_id
1468: FROM PO_ACTION_HISTORY
1469: WHERE object_type_code = 'REQUISITION'
1470: AND object_id = p_req_header_id
1471: AND sequence_num = l_sequence_num;
1472:

Line 1473: /* update po action history */

1469: WHERE object_type_code = 'REQUISITION'
1470: AND object_id = p_req_header_id
1471: AND sequence_num = l_sequence_num;
1472:
1473: /* update po action history */
1474: po_forward_sv1.insert_action_history (
1475: p_req_header_id,
1476: 'REQUISITION',
1477: l_object_sub_type_code,

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

1616: --Locks:
1617: -- None.
1618: --Function:
1619: -- Workflow activity PL/SQL handler.
1620: -- This procedure updates the po_action_history table based on the approvers response.
1621: --Parameters:
1622: --IN:
1623: -- Standard workflow IN parameters
1624: --OUT:

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

1731: --Locks:
1732: -- None.
1733: --Function:
1734: -- Workflow activity PL/SQL handler.
1735: -- This procedure updates the po_action_history table based on the approvers response.
1736: --Parameters:
1737: --IN:
1738: -- Standard workflow IN parameters
1739: --OUT:

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

1846: --Locks:
1847: -- None.
1848: --Function:
1849: -- Workflow activity PL/SQL handler.
1850: -- This procedure updates the po_action_history table based on the approvers response.
1851: --Parameters:
1852: --IN:
1853: -- Standard workflow IN parameters
1854: --OUT:

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

2055: -- None.
2056: --Locks:
2057: -- None.
2058: --Function:
2059: -- This procedure updates the po_action_history table based on the approvers response.
2060: --Parameters:
2061: --IN:
2062: -- p_document_id : Requisition Header Id
2063: -- p_action : Action

Line 2081: UPDATE po_action_history

2077: BEGIN
2078:
2079: if (p_current_approver is not null) then
2080:
2081: UPDATE po_action_history
2082: SET action_code = p_action,
2083: note = p_note,
2084: action_date = sysdate
2085: WHERE object_id = p_document_id and

Line 2093: UPDATE po_action_history

2089: and rownum=1;
2090:
2091: else
2092:
2093: UPDATE po_action_history
2094: SET action_code = p_action,
2095: note = p_note,
2096: action_date = sysdate
2097: WHERE object_id = p_document_id and