APPS.WIP_EAM_WRAPPROVAL_PVT dependencies on WIP_EAM_WORK_REQ_NOTES

Line 82: from WIP_EAM_WORK_REQ_NOTES wrn

78: --added bug 10399281
79:
80: CURSOR desc_history_cur (p_work_request_id IN NUMBER) IS
81: select notes
82: from WIP_EAM_WORK_REQ_NOTES wrn
83: where work_request_id = p_work_request_id
84: order by work_request_note_id;
85:
86:

Line 285: from WIP_EAM_WORK_REQ_NOTES wrn1

281: we insert the header info */
282: l_stmt_number := 76 ;
283: begin
284: /* select notes into l_notes
285: from WIP_EAM_WORK_REQ_NOTES wrn1
286: where work_request_id = p_work_request_id
287: and work_request_note_id in
288: (select min(work_request_note_id)
289: from WIP_EAM_WORK_REQ_NOTES wrn2

Line 289: from WIP_EAM_WORK_REQ_NOTES wrn2

285: from WIP_EAM_WORK_REQ_NOTES wrn1
286: where work_request_id = p_work_request_id
287: and work_request_note_id in
288: (select min(work_request_note_id)
289: from WIP_EAM_WORK_REQ_NOTES wrn2
290: where wrn1.work_request_id = wrn2.work_request_id);
291:
292: If l_notes is not null then
293: l_notes := l_notes || wf_core.newline || p_notes ;

Line 592: select wip_eam_work_req_notes_s.nextval

588:
589:
590: -- If l_comment is not null Then
591: l_stmt_number := 20;
592: select wip_eam_work_req_notes_s.nextval
593: into l_work_request_note_id
594: from dual ;
595:
596: l_comment := ' *** '||

Line 613: Insert into WIP_EAM_WORK_REQ_NOTES

609: -- Assumption For SYSDATE , there is not much time lag betwn
610: -- comments entered on WF and time it reaches the below insert
611:
612: l_stmt_number := 40;
613: Insert into WIP_EAM_WORK_REQ_NOTES
614: (WORK_REQUEST_NOTE_ID ,
615: LAST_UPDATE_DATE ,
616: LAST_UPDATED_BY ,
617: CREATION_DATE,

Line 714: select wip_eam_work_req_notes_s.nextval

710: -- Set the from role to be displayed on notifn summary
711:
712: -- If l_comment is not null Then
713: l_stmt_number := 20;
714: select wip_eam_work_req_notes_s.nextval
715: into l_work_request_note_id
716: from dual ;
717:
718: l_comment := ' *** '||

Line 736: Insert into WIP_EAM_WORK_REQ_NOTES

732: -- Assumption For SYSDATE , there is not much time lag betwn
733: -- comments entered on WF and time it reaches the below insert
734:
735: l_stmt_number := 40;
736: Insert into WIP_EAM_WORK_REQ_NOTES
737: (WORK_REQUEST_NOTE_ID ,
738: LAST_UPDATE_DATE ,
739: LAST_UPDATED_BY ,
740: CREATION_DATE,

Line 864: select wip_eam_work_req_notes_s.nextval

860: Where work_request_id = l_work_request_id ;
861:
862: -- If l_comment is not null Then
863: l_stmt_number := 30;
864: select wip_eam_work_req_notes_s.nextval
865: into l_work_request_note_id
866: from dual ;
867:
868: /* l_stmt_number := 40;

Line 903: Insert into WIP_EAM_WORK_REQ_NOTES

899: -- Assumption For SYSDATE , there is not much time lag betwn
900: -- comments entered on WF and time it reaches the below insert
901:
902: l_stmt_number := 60;
903: Insert into WIP_EAM_WORK_REQ_NOTES
904: (WORK_REQUEST_NOTE_ID ,
905: LAST_UPDATE_DATE ,
906: LAST_UPDATED_BY ,
907: CREATION_DATE,