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

   l_workorder_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 208

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

Line: 211

END Update_Status_Approved;

Line: 216

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

   l_workorder_rec.transaction_type :=   EAM_PROCESS_WO_PUB.G_OPR_UPDATE;

Line: 333

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

Line: 336

END Update_Status_Rejected;

Line: 415

     ame_api2.updateApprovalStatus2(applicationIdIn=>426,
          transactionTypeIn=>'oracle.apps.eam.workorder.release.approval',
          transactionIdIn=>l_transaction_id,
          approvalStatusIn => ame_util.notifiedStatus,
          approverNameIn => l_next_approver.name);

Line: 431

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

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

END Update_AME_With_Response;

Line: 494

	        ((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;