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 881: l_object_sub_type_code PO_ACTION_HISTORY.OBJECT_SUB_TYPE_CODE%TYPE;

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

Line 882: l_sequence_num PO_ACTION_HISTORY.SEQUENCE_NUM%TYPE;

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

Line 883: l_object_revision_num PO_ACTION_HISTORY.OBJECT_REVISION_NUM%TYPE;

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

Line 884: l_approval_path_id PO_ACTION_HISTORY.APPROVAL_PATH_ID%TYPE;

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

Line 885: l_request_id PO_ACTION_HISTORY.REQUEST_ID%TYPE;

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

Line 886: l_program_application_id PO_ACTION_HISTORY.PROGRAM_APPLICATION_ID%TYPE;

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

Line 887: l_program_date PO_ACTION_HISTORY.PROGRAM_DATE%TYPE;

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

Line 888: l_program_id PO_ACTION_HISTORY.PROGRAM_ID%TYPE;

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

Line 895: FROM PO_ACTION_HISTORY

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

Line 905: FROM PO_ACTION_HISTORY

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

Line 910: /* update po action history */

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1594: UPDATE po_action_history

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

Line 1606: UPDATE po_action_history

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