APPS.EAM_ISOLATION_WORKFLOW_PVT SQL Statements

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

Line: 107

* Procedure     : Update_Status_Approved
* Purpose       : Procedure called from Isolation Release Approval when the workflow is approved
*********************************************************************/
PROCEDURE Update_Status_Approved
                  ( itemtype  in varchar2
                    , itemkey   in varchar2
                    , actid     in number
                    , funcmode  in varchar2
                    , resultout out NOCOPY varchar2
                  )IS

                  l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
                      itemkey => itemkey, aname => 'ISOLATION_ID');

Line: 154

   l_isolation_header_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 218

    wf_core.context('EAMWIREL','UPDATE_STATUS_APPROVED',
      itemtype, itemkey, actid, funcmode);

Line: 221

END Update_Status_Approved;

Line: 226

* Procedure     : Update_Status_Rejected
* Purpose       : Procedure called from Isolation Release Approval when the workflow is Rejected
*********************************************************************/
PROCEDURE Update_Status_Rejected
                      ( itemtype  in varchar2
                      ,	itemkey   in varchar2
                      , actid     in number
                      , funcmode  in varchar2
                      , resultout out NOCOPY varchar2
                      )IS

                  l_isolation_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
                      itemkey => itemkey, aname => 'ISOLATION_ID');

Line: 273

      l_isolation_header_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 325

    wf_core.context('EAMWIREL','UPDATE_STATUS_REJECTED',
      itemtype, itemkey, actid, funcmode);

Line: 328

END Update_Status_Rejected;

Line: 464

* Procedure     : Update_AME_With_Response
* Purpose       : Procedure called from Isolation Release Approval when an approver
                  responds to a notification
*********************************************************************/
procedure Update_AME_With_Response
                          ( itemtype        in varchar2,
                            itemkey         in varchar2,
                            actid           in number,
                            funcmode        in varchar2,
                            resultout       out NOCOPY varchar2
                          ) IS
                            E_FAILURE                   EXCEPTION;

Line: 492

                   SELECT responder,notification_id
                   into  l_approver_name,l_nid
                   FROM wf_notifications
                   WHERE group_id=l_gid
                   AND status = 'CLOSED';

Line: 510

				   ame_api2.updateApprovalStatus2(applicationIdIn=>426,
					transactionTypeIn=>'oracle.apps.eam.isolation.release.approval',
					transactionIdIn=>l_transaction_id,
					approvalStatusIn => l_ame_status,
					approverNameIn => l_approver_name);

Line: 523

          ame_api2.updateApprovalStatus2(applicationIdIn=>426,
					transactionTypeIn=>'oracle.apps.eam.isolation.release.approval',
					transactionIdIn=>l_transaction_id,
					approvalStatusIn => 'FORWARD',
					approverNameIn => l_original_approver_name,
          forwardeeIn => l_forwardeeIn );

Line: 537

END Update_AME_With_Response;

Line: 558

	         (p_new_isolation_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE AND
	         p_old_isolation_rec.system_status IN (17,7)) )
	   )THEN
			     x_approval_required := TRUE;