13: create service request */
14:
15: /*
16: PROCEDURE Create_ServiceRequest_Pre
17: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
18: x_return_status OUT NOCOPY VARCHAR2
19: ); */
20:
21: PROCEDURE Create_ServiceRequest_Pre
33: p_org_id IN NUMBER DEFAULT NULL,
34: p_request_id IN NUMBER DEFAULT NULL,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_invocation_mode IN VARCHAR2 := 'NORMAL',
37: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38: p_notes IN CS_ServiceRequest_PVT.notes_table,
39: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40: x_request_id OUT NOCOPY NUMBER,
41: x_request_number OUT NOCOPY VARCHAR2,
34: p_request_id IN NUMBER DEFAULT NULL,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_invocation_mode IN VARCHAR2 := 'NORMAL',
37: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38: p_notes IN CS_ServiceRequest_PVT.notes_table,
39: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40: x_request_id OUT NOCOPY NUMBER,
41: x_request_number OUT NOCOPY VARCHAR2,
42: x_interaction_id OUT NOCOPY NUMBER,
35: p_request_number IN VARCHAR2 DEFAULT NULL,
36: p_invocation_mode IN VARCHAR2 := 'NORMAL',
37: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
38: p_notes IN CS_ServiceRequest_PVT.notes_table,
39: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
40: x_request_id OUT NOCOPY NUMBER,
41: x_request_number OUT NOCOPY VARCHAR2,
42: x_interaction_id OUT NOCOPY NUMBER,
43: x_workflow_process_id OUT NOCOPY NUMBER
48: create service request */
49:
50: /*
51: PROCEDURE Create_ServiceRequest_Post
52: (p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
53: x_return_status OUT NOCOPY VARCHAR2
54: ); */
55:
56:
69: p_org_id IN NUMBER DEFAULT NULL,
70: p_request_id IN NUMBER DEFAULT NULL,
71: p_request_number IN VARCHAR2 DEFAULT NULL,
72: p_invocation_mode IN VARCHAR2 := 'NORMAL',
73: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
74: p_notes IN CS_ServiceRequest_PVT.notes_table,
75: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
76: x_request_id OUT NOCOPY NUMBER,
77: x_request_number OUT NOCOPY VARCHAR2,
70: p_request_id IN NUMBER DEFAULT NULL,
71: p_request_number IN VARCHAR2 DEFAULT NULL,
72: p_invocation_mode IN VARCHAR2 := 'NORMAL',
73: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
74: p_notes IN CS_ServiceRequest_PVT.notes_table,
75: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
76: x_request_id OUT NOCOPY NUMBER,
77: x_request_number OUT NOCOPY VARCHAR2,
78: x_interaction_id OUT NOCOPY NUMBER,
71: p_request_number IN VARCHAR2 DEFAULT NULL,
72: p_invocation_mode IN VARCHAR2 := 'NORMAL',
73: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
74: p_notes IN CS_ServiceRequest_PVT.notes_table,
75: p_contacts IN CS_ServiceRequest_PVT.contacts_table ,
76: x_request_id OUT NOCOPY NUMBER,
77: x_request_number OUT NOCOPY VARCHAR2,
78: x_interaction_id OUT NOCOPY NUMBER,
79: x_workflow_process_id OUT NOCOPY NUMBER
87:
88: /*
89: PROCEDURE Update_ServiceRequest_Pre
90: ( p_request_id IN NUMBER,
91: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
92: x_return_status OUT NOCOPY VARCHAR2
93: ); */
94:
95:
108: p_last_updated_by IN NUMBER,
109: p_last_update_login IN NUMBER DEFAULT NULL,
110: p_last_update_date IN DATE,
111: p_invocation_mode IN VARCHAR2 := 'NORMAL',
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,
110: p_last_update_date IN DATE,
111: p_invocation_mode IN VARCHAR2 := 'NORMAL',
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,
117: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
118: p_workflow_process_id IN NUMBER DEFAULT NULL,
111: p_invocation_mode IN VARCHAR2 := 'NORMAL',
112: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
113: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
114: p_notes IN CS_ServiceRequest_PVT.notes_table,
115: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
116: p_audit_comments IN VARCHAR2 DEFAULT NULL,
117: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
118: p_workflow_process_id IN NUMBER DEFAULT NULL,
119: x_workflow_process_id OUT NOCOPY NUMBER,
127:
128: /*
129: PROCEDURE Update_ServiceRequest_Post
130: ( p_request_id IN NUMBER,
131: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
132: x_return_status OUT NOCOPY VARCHAR2); */
133:
134:
135:
148: p_last_updated_by IN NUMBER,
149: p_last_update_login IN NUMBER DEFAULT NULL,
150: p_last_update_date IN DATE,
151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,
150: p_last_update_date IN DATE,
151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,
157: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
158: p_workflow_process_id IN NUMBER DEFAULT NULL,
151: p_invocation_mode IN VARCHAR2 := 'NORMAL',
152: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
153: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
154: p_notes IN CS_ServiceRequest_PVT.notes_table,
155: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
156: p_audit_comments IN VARCHAR2 DEFAULT NULL,
157: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
158: p_workflow_process_id IN NUMBER DEFAULT NULL,
159: x_workflow_process_id OUT NOCOPY NUMBER,
164:
165:
166: FUNCTION Ok_To_Generate_Msg
167: (p_request_id IN NUMBER,
168: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
169: RETURN BOOLEAN ;
170:
171:
172: FUNCTION Ok_To_Launch_Workflow
170:
171:
172: FUNCTION Ok_To_Launch_Workflow
173: ( p_request_id IN NUMBER,
174: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type)
175: RETURN BOOLEAN ;
176:
177: END cs_servicerequest_cuhk;