APPS.EAM_CLEARANCE_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 Work Clearance 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_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
                      itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');

Line: 155

   l_clearance_header_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 220

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

Line: 223

END Update_Status_Approved;

Line: 228

* Procedure     : Update_Status_Rejected
* Purpose       : Procedure called from Work Clearance 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_work_clearance_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
                      itemkey => itemkey, aname => 'WORK_CLEARANCE_ID');

Line: 276

      l_clearance_header_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 329

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

Line: 332

END Update_Status_Rejected;

Line: 468

* Procedure     : Update_AME_With_Response
* Purpose       : Procedure called from Clearance 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: 496

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

Line: 514

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

Line: 527

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

Line: 541

END Update_AME_With_Response;

Line: 562

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