22: p_org_id IN NUMBER ,
23: p_request_id IN NUMBER ,
24: p_request_number IN VARCHAR2 ,
25: p_invocation_mode IN VARCHAR2 := 'NORMAL',
26: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
27: p_notes IN CS_ServiceRequest_PVT.notes_table,
28: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
29: x_request_id OUT NOCOPY NUMBER,
30: x_request_number OUT NOCOPY VARCHAR2,
23: p_request_id IN NUMBER ,
24: p_request_number IN VARCHAR2 ,
25: p_invocation_mode IN VARCHAR2 := 'NORMAL',
26: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
27: p_notes IN CS_ServiceRequest_PVT.notes_table,
28: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
29: x_request_id OUT NOCOPY NUMBER,
30: x_request_number OUT NOCOPY VARCHAR2,
31: x_interaction_id OUT NOCOPY NUMBER,
24: p_request_number IN VARCHAR2 ,
25: p_invocation_mode IN VARCHAR2 := 'NORMAL',
26: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
27: p_notes IN CS_ServiceRequest_PVT.notes_table,
28: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
29: x_request_id OUT NOCOPY NUMBER,
30: x_request_number OUT NOCOPY VARCHAR2,
31: x_interaction_id OUT NOCOPY NUMBER,
32: x_workflow_process_id OUT NOCOPY NUMBER
149: p_org_id IN NUMBER ,
150: p_request_id IN NUMBER ,
151: p_request_number IN VARCHAR2 ,
152: p_invocation_mode IN VARCHAR2 := 'NORMAL',
153: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
156: x_request_id OUT NOCOPY NUMBER,
157: x_request_number OUT NOCOPY VARCHAR2,
150: p_request_id IN NUMBER ,
151: p_request_number IN VARCHAR2 ,
152: p_invocation_mode IN VARCHAR2 := 'NORMAL',
153: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
156: x_request_id OUT NOCOPY NUMBER,
157: x_request_number OUT NOCOPY VARCHAR2,
158: x_interaction_id OUT NOCOPY NUMBER,
151: p_request_number IN VARCHAR2 ,
152: p_invocation_mode IN VARCHAR2 := 'NORMAL',
153: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
156: x_request_id OUT NOCOPY NUMBER,
157: x_request_number OUT NOCOPY VARCHAR2,
158: x_interaction_id OUT NOCOPY NUMBER,
159: x_workflow_process_id OUT NOCOPY NUMBER
245:
246: /*
247: PROCEDURE Update_ServiceRequest_Pre
248: ( p_request_id IN NUMBER,
249: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
250: x_return_status OUT NOCOPY VARCHAR2
251: ); */
252:
253:
266: p_last_updated_by IN NUMBER,
267: p_last_update_login IN NUMBER ,
268: p_last_update_date IN DATE,
269: p_invocation_mode IN VARCHAR2 := 'NORMAL',
270: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
271: p_update_desc_flex IN VARCHAR2 ,
272: p_notes IN CS_ServiceRequest_PVT.notes_table,
273: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
274: p_audit_comments IN VARCHAR2 ,
268: p_last_update_date IN DATE,
269: p_invocation_mode IN VARCHAR2 := 'NORMAL',
270: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
271: p_update_desc_flex IN VARCHAR2 ,
272: p_notes IN CS_ServiceRequest_PVT.notes_table,
273: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
274: p_audit_comments IN VARCHAR2 ,
275: p_called_by_workflow IN VARCHAR2 ,
276: p_workflow_process_id IN NUMBER ,
269: p_invocation_mode IN VARCHAR2 := 'NORMAL',
270: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
271: p_update_desc_flex IN VARCHAR2 ,
272: p_notes IN CS_ServiceRequest_PVT.notes_table,
273: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
274: p_audit_comments IN VARCHAR2 ,
275: p_called_by_workflow IN VARCHAR2 ,
276: p_workflow_process_id IN NUMBER ,
277: x_workflow_process_id OUT NOCOPY NUMBER,
386:
387: /*
388: PROCEDURE Update_ServiceRequest_Post
389: ( p_request_id IN NUMBER,
390: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
391: x_return_status OUT NOCOPY VARCHAR2); */
392:
393:
394:
407: p_last_updated_by IN NUMBER,
408: p_last_update_login IN NUMBER ,
409: p_last_update_date IN DATE,
410: p_invocation_mode IN VARCHAR2 := 'NORMAL',
411: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
412: p_update_desc_flex IN VARCHAR2 ,
413: p_notes IN CS_ServiceRequest_PVT.notes_table,
414: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
415: p_audit_comments IN VARCHAR2 ,
409: p_last_update_date IN DATE,
410: p_invocation_mode IN VARCHAR2 := 'NORMAL',
411: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
412: p_update_desc_flex IN VARCHAR2 ,
413: p_notes IN CS_ServiceRequest_PVT.notes_table,
414: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
415: p_audit_comments IN VARCHAR2 ,
416: p_called_by_workflow IN VARCHAR2 ,
417: p_workflow_process_id IN NUMBER ,
410: p_invocation_mode IN VARCHAR2 := 'NORMAL',
411: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
412: p_update_desc_flex IN VARCHAR2 ,
413: p_notes IN CS_ServiceRequest_PVT.notes_table,
414: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
415: p_audit_comments IN VARCHAR2 ,
416: p_called_by_workflow IN VARCHAR2 ,
417: p_workflow_process_id IN NUMBER ,
418: x_workflow_process_id OUT NOCOPY NUMBER,
503: END;
504:
505: FUNCTION Ok_To_Generate_Msg
506: (p_request_id IN NUMBER,
507: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
508: RETURN BOOLEAN IS
509: Begin
510: --Return IBU_SR_CUHK.Ok_To_Generate_Msg(p_request_id, p_service_request_rec);
511: NULL;
512: End;
513:
514: FUNCTION Ok_To_Launch_Workflow
515: ( p_request_id IN NUMBER,
516: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
517: RETURN BOOLEAN IS
518: Begin
519: return false;
520: End;