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_APPROVAL_LIST_WF1S SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 45


PROCEDURE updateApprovalListResponse(itemtype        in varchar2,
                                        itemkey         in varchar2,
                                        p_transaction_type IN VARCHAR2,
                                        p_document_id      IN  NUMBER,
                                        p_approver_id      IN  NUMBER,
                                        p_insertion_type   IN VARCHAR2 default null,
                                        p_authority_type   IN VARCHAR2 default null,
                                        p_forward_to_id    IN  NUMBER default null,
                                        p_response         IN  VARCHAR2);

Line: 105


           /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 129


                      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 142


                      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 165


             /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 227


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 239


    SELECT ame_transaction_type
      INTO l_transaction_type
      FROM po_document_types
     WHERE document_type_code = l_document_type
       and document_subtype = l_document_subtype;

Line: 323


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 328


       SELECT ame_transaction_type
       INTO l_transaction_type
       FROM po_document_types
       WHERE document_type_code = 'CHANGE_REQUEST'
          and document_subtype = 'REQUISITION' ;

Line: 344


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 429


  l_insertion_type            VARCHAR2(30);

Line: 438


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 461


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 469


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 478


     (l_next_approver.api_insertion is null) and
     (l_next_approver.authority is null) and
     (l_next_approver.approval_status is null)) THEN
     resultout:='COMPLETE:'||'NO_NEXT_APPROVER';

Line: 485


     l_insertion_type := l_next_approver.api_insertion;

Line: 491


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 506


                              aname      => 'AME_INSERTION_TYPE' ,
                              avalue     => l_insertion_type);

Line: 524


        /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 588


procedure Update_Approval_List_Response(itemtype        in varchar2,
                                itemkey         in varchar2,
                                actid           in number,
                                funcmode        in varchar2,
                                resultout       out NOCOPY varchar2) IS
  l_progress                  VARCHAR2(300) := '000';

Line: 601


  l_insertion_type            VARCHAR2(30);

Line: 615


  l_progress := ' Update_Approval_List_Response: 001- at beginning of function';

Line: 617


     /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 645


      l_insertion_type := wf_engine.GetItemAttrText(itemtype => itemtype,
                                         itemkey  => itemkey,
                                         aname    => 'AME_INSERTION_TYPE');

Line: 653


      l_progress := 'Update_Approval_List_Response: 010 APP'||
                       to_char(l_approver_id) || ' RES'||to_char(l_responder_id);

Line: 657


                    ' RESPONSE' || l_value || ' INSERTION? '||
                    l_insertion_type|| ' AUTHORITY? ' || l_authority_type;

Line: 661


         /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 668


      updateApprovalListResponse(itemtype=>itemtype,
                      itemkey=>itemkey,
                      p_transaction_type=>l_transaction_type,
                      p_document_id=>l_document_id,
                      p_approver_id=>l_approver_id,
                      p_insertion_type=>l_insertion_type,
                      p_authority_type=>l_authority_type,
                      p_forward_to_id=>l_forward_to_id,
                      p_response=>l_value);

Line: 679


         /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 693


                   'Update_Approval_List_Response',l_progress,sqlerrm);

Line: 695


   PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');

Line: 699


END Update_Approval_List_Response;

Line: 723


procedure Update_Approver_Timeout(itemtype        in varchar2,
                                itemkey         in varchar2,
                                actid           in number,
                                funcmode        in varchar2,
                                resultout       out NOCOPY varchar2) IS
  l_progress                  VARCHAR2(300) := '000';

Line: 740


  l_progress := ' Update_Approver_timeout: 001- at beginning of function';

Line: 742


      /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 765


      updateApprovalListResponse(itemtype=>itemtype,
                      itemkey=>itemkey,
                      p_transaction_type=>l_transaction_type,
                      p_document_id=>l_document_id,
                      p_approver_id=>l_approver_id,
                      p_response=>'TIMEOUT');

Line: 772


      l_progress := ' Update_Approver_timeout: 002- at end of function';

Line: 774


         /* DEBUG */  PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);

Line: 788


                   'Update_Approval_List_Response',l_progress,sqlerrm);

Line: 790


   PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'POR_AME_REQAPPRV_PVT.UPDATE_APPROVAL_LIST_RESPONSE');

Line: 794


END Update_Approver_Timeout;

Line: 799


PROCEDURE updateApprovalListResponse(itemtype        in varchar2,
                                        itemkey         in varchar2,
                                        p_transaction_type IN VARCHAR2,
                                        p_document_id      IN  NUMBER,
                                        p_approver_id      IN  NUMBER,
                                        p_insertion_type   IN VARCHAR2 default null,
                                        p_authority_type   IN VARCHAR2 default null,
                                        p_forward_to_id    IN  NUMBER default null,
                                        p_response         IN  VARCHAR2) IS

  l_progress                VARCHAR2(100) := '000';

Line: 817


  currentApprover.api_insertion :=p_insertion_type;

Line: 821


    ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
                            transactionIdIn=>p_document_id,
                            approvalStatusIn=>ame_util.approvedStatus,
                            approverPersonIdIn=>p_approver_id,
                            transactionTypeIn=>p_transaction_type);

Line: 828


    ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
                            transactionIdIn=>p_document_id,
                            approvalStatusIn=>ame_util.rejectStatus,
                            approverPersonIdIn=>p_approver_id,
                            transactionTypeIn=>p_transaction_type);

Line: 838


        (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
         currentApprover.api_insertion = ame_util.oamGenerated)) then
      forwardee.api_insertion := ame_util.apiAuthorityInsertion;

Line: 842


      forwardee.api_insertion := ame_util.apiInsertion;

Line: 846


    ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
                            transactionIdIn=>p_document_id,
                            transactionTypeIn=>p_transaction_type,
                            approverIn=>currentApprover,
                            forwardeeIn=>forwardee);

Line: 857


        (currentApprover.api_insertion = ame_util.apiAuthorityInsertion or
         currentApprover.api_insertion = ame_util.oamGenerated)) then
      forwardee.api_insertion := ame_util.apiAuthorityInsertion;

Line: 861


      forwardee.api_insertion := ame_util.apiInsertion;

Line: 865


    ame_api.updateApprovalStatus(applicationIdIn=>applicationId,
                            transactionIdIn=>p_document_id,
                            transactionTypeIn=>p_transaction_type,
                            approverIn=>currentApprover,
                            forwardeeIn=>forwardee);

Line: 871


    ame_api.updateApprovalStatus2(applicationIdIn=>applicationId,
                            transactionIdIn=>p_document_id,
                            approvalStatusIn=>ame_util.noResponseStatus,
                            approverPersonIdIn=>p_approver_id,
                            transactionTypeIn=>p_transaction_type);

Line: 885


                   'updateApprovalListResponse',l_progress,sqlerrm);

Line: 888


END updateApprovalListResponse;