APPS.EAM_WORKORDER_WORKFLOW_PVT SQL Statements

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

Line: 89

PROCEDURE Update_Status_Approved( itemtype  in varchar2,
		      itemkey   in varchar2,
		      actid     in number,
		      funcmode  in varchar2,
		      resultout out NOCOPY varchar2) is
   l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
			 itemkey => itemkey, aname => 'WIP_ENTITY_ID');

Line: 146

   l_workorder_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;

Line: 213

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

Line: 216

END Update_Status_Approved;

Line: 221

PROCEDURE Update_Status_Rejected( itemtype  in varchar2,
		      itemkey   in varchar2,
		      actid     in number,
		      funcmode  in varchar2,
		      resultout out NOCOPY varchar2) is
l_wip_entity_id number := wf_engine.GetItemAttrNumber( itemtype => itemtype,
		   itemkey => itemkey, aname => 'WIP_ENTITY_ID');

Line: 274

   l_workorder_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_WF_OPR_UPDATE;

Line: 340

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

Line: 343

END Update_Status_Rejected;

Line: 473

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

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

Line: 518

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

Line: 533

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

Line: 549

END Update_AME_With_Response;

Line: 568

	        ((p_new_wo_rec.transaction_type=EAM_PROCESS_WO_PUB.G_OPR_UPDATE) AND
	         ((p_old_wo_rec.status_type IN (1,17,7) )   OR (p_old_wo_rec.status_type=6 AND p_old_wo_rec.date_released IS NULL) ) ) )
	   )THEN
			     x_approval_required := TRUE;