DBA Data[Home] [Help]

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: 125

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

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

                      /* 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: 188

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

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

    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: 346

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

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

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

  l_insertion_type            VARCHAR2(30);
Line: 461

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

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

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

     (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: 508

     l_insertion_type := l_next_approver.api_insertion;
Line: 514

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

                              aname      => 'AME_INSERTION_TYPE' ,
                              avalue     => l_insertion_type);
Line: 547

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

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: 624

  l_insertion_type            VARCHAR2(30);
Line: 638

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

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

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

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

                    ' RESPONSE' || l_value || ' INSERTION? '||
                    l_insertion_type|| ' AUTHORITY? ' || l_authority_type;
Line: 684

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

      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: 702

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

                   'Update_Approval_List_Response',l_progress,sqlerrm);
Line: 718

   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: 722

END Update_Approval_List_Response;
Line: 746

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: 763

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

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

      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: 795

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

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

                   'Update_Approval_List_Response',l_progress,sqlerrm);
Line: 813

   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: 817

END Update_Approver_Timeout;
Line: 822

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: 840

  currentApprover.api_insertion :=p_insertion_type;
Line: 844

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

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

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

      forwardee.api_insertion := ame_util.apiInsertion;
Line: 869

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

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

      forwardee.api_insertion := ame_util.apiInsertion;
Line: 888

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

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

                   'updateApprovalListResponse',l_progress,sqlerrm);
Line: 911

END updateApprovalListResponse;
Line: 937

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

  l_progress := ' DO 2 Roopal Update_Approval_List_Response:- p_itemtype: ' || itemtype || ' l_forward_to_id: ' || l_forward_to_id;
Line: 954

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

     l_progress := ' DO 2 Roopal Update_Approval_List_Response:- l_user_name: ' || l_user_name || ' l_disp_user_name: ' || l_disp_user_name;
Line: 982

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