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

Line 880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

876:
877: is
878: pragma AUTONOMOUS_TRANSACTION;
879:
880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

Line 881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

877: is
878: pragma AUTONOMOUS_TRANSACTION;
879:
880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

Line 882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

878: pragma AUTONOMOUS_TRANSACTION;
879:
880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

Line 883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

879:
880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

Line 884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

880: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;
881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
888: l_progress VARCHAR2(100) := '000';

Line 885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

881: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;
882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
888: l_progress VARCHAR2(100) := '000';
889:

Line 886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

882: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;
883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
888: l_progress VARCHAR2(100) := '000';
889:
890: begin

Line 887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

883: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;
884: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;
885: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;
886: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;
887: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;
888: l_progress VARCHAR2(100) := '000';
889:
890: begin
891:

Line 894: FROM PO_ACTION_HISTORY

890: begin
891:
892: SELECT max(sequence_num)
893: INTO l_sequence_num
894: FROM PO_ACTION_HISTORY
895: WHERE object_type_code = 'REQUISITION'
896: AND object_id = p_req_header_id;
897:
898: SELECT object_sub_type_code,

Line 904: FROM PO_ACTION_HISTORY

900: program_application_id, program_date, program_id
901: INTO l_object_sub_type_code,
902: l_object_revision_num, l_approval_path_id, l_request_id,
903: l_program_application_id, l_program_date, l_program_id
904: FROM PO_ACTION_HISTORY
905: WHERE object_type_code = 'REQUISITION'
906: AND object_id = p_req_header_id
907: AND sequence_num = l_sequence_num;
908:

Line 909: /* update po action history */

905: WHERE object_type_code = 'REQUISITION'
906: AND object_id = p_req_header_id
907: AND sequence_num = l_sequence_num;
908:
909: /* update po action history */
910: po_forward_sv1.insert_action_history (
911: p_req_header_id,
912: 'REQUISITION',
913: l_object_sub_type_code,

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

1052: --Locks:
1053: -- None.
1054: --Function:
1055: -- Workflow activity PL/SQL handler.
1056: -- This procedure updates the po_action_history table based on the approvers response.
1057: --Parameters:
1058: --IN:
1059: -- Standard workflow IN parameters
1060: --OUT:

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

1170: --Locks:
1171: -- None.
1172: --Function:
1173: -- Workflow activity PL/SQL handler.
1174: -- This procedure updates the po_action_history table based on the approvers response.
1175: --Parameters:
1176: --IN:
1177: -- Standard workflow IN parameters
1178: --OUT:

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

1288: --Locks:
1289: -- None.
1290: --Function:
1291: -- Workflow activity PL/SQL handler.
1292: -- This procedure updates the po_action_history table based on the approvers response.
1293: --Parameters:
1294: --IN:
1295: -- Standard workflow IN parameters
1296: --OUT:

Line 1404: -- po_action_history table also will be updated based on the approvers response.

1400: -- None.
1401: --Function:
1402: -- Workflow activity PL/SQL handler.
1403: -- This procedure updates the req approval status in po_requistion_headers_all table.
1404: -- po_action_history table also will be updated based on the approvers response.
1405: -- If it is a first responder wins setup in ame, then once the first reponder wins, others will not be able to take decisions.
1406: --Parameters:
1407: --IN:
1408: -- Standard workflow IN parameters

Line 1491: -- po_action_history table also will be updated based on the approvers response.

1487: -- None.
1488: --Function:
1489: -- Workflow activity PL/SQL handler.
1490: -- This procedure updates the req approval status in po_requistion_headers_all table.
1491: -- po_action_history table also will be updated based on the approvers response.
1492: -- If it is a first responder wins setup in ame, then once the first reponder wins, others will not be able to take decisions.
1493: --Parameters:
1494: --IN:
1495: -- Standard workflow IN parameters

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

1567: -- None.
1568: --Locks:
1569: -- None.
1570: --Function:
1571: -- This procedure updates the po_action_history table based on the approvers response.
1572: --Parameters:
1573: --IN:
1574: -- p_document_id : Requisition Header Id
1575: -- p_action : Action

Line 1593: UPDATE po_action_history

1589: BEGIN
1590:
1591: if (p_current_approver is not null) then
1592:
1593: UPDATE po_action_history
1594: SET action_code = p_action,
1595: note = p_note,
1596: action_date = sysdate
1597: WHERE object_id = p_document_id and

Line 1605: UPDATE po_action_history

1601: and rownum=1;
1602:
1603: else
1604:
1605: UPDATE po_action_history
1606: SET action_code = p_action,
1607: note = p_note,
1608: action_date = sysdate
1609: WHERE object_id = p_document_id and