APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on WIP_EAM_WORK_REQUESTS

Line 431: WHERE user_id in (select created_by FROM wip_eam_work_requests where work_request_id = p_work_request_id);

427: BEGIN
428: SELECT user_name
429: INTO l_user_name
430: FROM fnd_user
431: WHERE user_id in (select created_by FROM wip_eam_work_requests where work_request_id = p_work_request_id);
432: EXCEPTION
433: When NO_DATA_FOUND then
434: l_user_name := FND_GLOBAL.USER_NAME ;
435: END;

Line 462: update wip_eam_work_requests

458: itemkey => itemkey);
459:
460: /* Set workflow process to background for better performance */
461:
462: update wip_eam_work_requests
463: set wf_item_type = itemtype,
464: wf_item_key = itemkey
465: where work_request_id = p_work_request_id;
466: l_stmt_number := 120 ;

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

541:
542: END Update_FROM_ROLE;
543:
544:
545: /* Update status to 'Awaiting Work Order' in wip_eam_work_requests */
546: PROCEDURE Update_Status_Await_Wo( itemtype in varchar2,
547: itemkey in varchar2,
548: actid in number,
549: funcmode in varchar2,

Line 580: Update WIP_EAM_WORK_REQUESTS

576: l_stmt_number := 10;
577:
578: If (funcmode = 'RUN') then
579:
580: Update WIP_EAM_WORK_REQUESTS
581: set work_request_status_id = 3 ,
582: last_updated_by = FND_GLOBAL.USER_ID,
583: last_update_date = SYSDATE
584: Where work_request_id = l_work_request_id ;

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

665:
666: END Update_Status_Await_Wo;
667:
668:
669: /* update status to Rejected in wip_eam_work_requests */
670: PROCEDURE Update_Status_Rejected( itemtype in varchar2,
671: itemkey in varchar2,
672: actid in number,
673: funcmode in varchar2,

Line 704: Update WIP_EAM_WORK_REQUESTS

700: l_stmt_number := 10;
701:
702: If (funcmode = 'RUN') then
703:
704: Update WIP_EAM_WORK_REQUESTS
705: set work_request_status_id = 5,
706: last_updated_by = FND_GLOBAL.USER_ID,
707: last_update_date = SYSDATE
708: Where work_request_id = l_work_request_id ;

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

784: wf_core.context('EAMWRAP','UPDATE_STATUS_REJECTED '|| to_char(l_stmt_number) ,itemtype, itemkey, actid, funcmode);
785: raise;
786: END Update_status_rejected;
787:
788: /*Update status to 'Additional Information' in wip_eam_work_requests */
789:
790: PROCEDURE Update_Status_Add( itemtype in varchar2,
791: itemkey in varchar2,
792: actid in number,

Line 856: Update WIP_EAM_WORK_REQUESTS

852: aname=> 'DEPT_RESPONSIBILTY',
853: avalue=> l_reassign_role_name);
854:
855: l_stmt_number := 20;
856: Update WIP_EAM_WORK_REQUESTS
857: set work_request_status_id = 2,
858: last_updated_by = FND_GLOBAL.USER_ID,
859: last_update_date = SYSDATE
860: Where work_request_id = l_work_request_id ;