APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 413: update wip_eam_work_requests

409: itemkey => itemkey);
410:
411: /* Set workflow process to background for better performance */
412:
413: update wip_eam_work_requests
414: set wf_item_type = itemtype,
415: wf_item_key = itemkey
416: where work_request_id = p_work_request_id;
417: l_stmt_number := 120 ;

Line 437: /* Update status to 'Awaiting Work Order' in wip_eam_work_requests */

433: raise;
434:
435: END StartWRAProcess;
436:
437: /* Update status to 'Awaiting Work Order' in wip_eam_work_requests */
438: PROCEDURE Update_Status_Await_Wo( itemtype in varchar2,
439: itemkey in varchar2,
440: actid in number,
441: funcmode in varchar2,

Line 469: Update WIP_EAM_WORK_REQUESTS

465: l_stmt_number := 10;
466:
467: If (funcmode = 'RUN') then
468:
469: Update WIP_EAM_WORK_REQUESTS
470: set work_request_status_id = 3 ,
471: last_updated_by = FND_GLOBAL.USER_ID,
472: last_update_date = SYSDATE
473: Where work_request_id = l_work_request_id ;

Line 571: /* update status to Rejected in wip_eam_work_requests */

567:
568: END Update_Status_Await_Wo;
569:
570:
571: /* update status to Rejected in wip_eam_work_requests */
572: PROCEDURE Update_Status_Rejected( itemtype in varchar2,
573: itemkey in varchar2,
574: actid in number,
575: funcmode in varchar2,

Line 603: Update WIP_EAM_WORK_REQUESTS

599: l_stmt_number := 10;
600:
601: If (funcmode = 'RUN') then
602:
603: Update WIP_EAM_WORK_REQUESTS
604: set work_request_status_id = 5,
605: last_updated_by = FND_GLOBAL.USER_ID,
606: last_update_date = SYSDATE
607: Where work_request_id = l_work_request_id ;

Line 699: /*Update status to 'Additional Information' in wip_eam_work_requests */

695: wf_core.context('EAMWRAP','UPDATE_STATUS_REJECTED '|| to_char(l_stmt_number) ,itemtype, itemkey, actid, funcmode);
696: raise;
697: END Update_status_rejected;
698:
699: /*Update status to 'Additional Information' in wip_eam_work_requests */
700:
701: PROCEDURE Update_Status_Add( itemtype in varchar2,
702: itemkey in varchar2,
703: actid in number,

Line 792: Update WIP_EAM_WORK_REQUESTS

788: aname=> 'DEPT_RESPONSIBILTY',
789: avalue=> l_reassign_role_name);
790:
791: l_stmt_number := 20;
792: Update WIP_EAM_WORK_REQUESTS
793: set work_request_status_id = 2,
794: last_updated_by = FND_GLOBAL.USER_ID,
795: last_update_date = SYSDATE
796: Where work_request_id = l_work_request_id ;