19: ); */
20:
21: PROCEDURE Create_ServiceRequest_Pre
22: ( p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
25: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
20:
21: PROCEDURE Create_ServiceRequest_Pre
22: ( p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
25: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
21: PROCEDURE Create_ServiceRequest_Pre
22: ( p_api_version IN NUMBER,
23: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
24: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
25: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
26: x_return_status OUT NOCOPY VARCHAR2,
27: x_msg_count OUT NOCOPY NUMBER,
28: x_msg_data OUT NOCOPY VARCHAR2,
29: p_resp_appl_id IN NUMBER DEFAULT NULL,
57:
58:
59: PROCEDURE Create_ServiceRequest_Post
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
62: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
63: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
58:
59: PROCEDURE Create_ServiceRequest_Post
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
62: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
63: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
59: PROCEDURE Create_ServiceRequest_Post
60: ( p_api_version IN NUMBER,
61: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
62: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
63: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
64: x_return_status OUT NOCOPY VARCHAR2,
65: x_msg_count OUT NOCOPY NUMBER,
66: x_msg_data OUT NOCOPY VARCHAR2,
67: p_resp_appl_id IN NUMBER DEFAULT NULL,
96:
97:
98: PROCEDURE Update_ServiceRequest_Pre
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
101: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
102: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
97:
98: PROCEDURE Update_ServiceRequest_Pre
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
101: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
102: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
98: PROCEDURE Update_ServiceRequest_Pre
99: ( p_api_version IN NUMBER,
100: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
101: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
102: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
103: x_return_status OUT NOCOPY VARCHAR2,
104: x_msg_count OUT NOCOPY NUMBER,
105: x_msg_data OUT NOCOPY VARCHAR2,
106: p_request_id IN NUMBER,
111: p_last_update_login IN NUMBER DEFAULT NULL,
112: p_last_update_date IN DATE,
113: p_invocation_mode IN VARCHAR2 := 'NORMAL',
114: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
115: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_notes IN CS_ServiceRequest_PVT.notes_table,
117: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
118: p_audit_comments IN VARCHAR2 DEFAULT NULL,
119: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
115: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
116: p_notes IN CS_ServiceRequest_PVT.notes_table,
117: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
118: p_audit_comments IN VARCHAR2 DEFAULT NULL,
119: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
120: p_workflow_process_id IN NUMBER DEFAULT NULL,
121: x_workflow_process_id OUT NOCOPY NUMBER,
122: x_interaction_id OUT NOCOPY NUMBER
123: ) ;
136:
137:
138: PROCEDURE Update_ServiceRequest_Post
139: ( p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
141: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
142: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
137:
138: PROCEDURE Update_ServiceRequest_Post
139: ( p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
141: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
142: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
138: PROCEDURE Update_ServiceRequest_Post
139: ( p_api_version IN NUMBER,
140: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
141: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
142: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
143: x_return_status OUT NOCOPY VARCHAR2,
144: x_msg_count OUT NOCOPY NUMBER,
145: x_msg_data OUT NOCOPY VARCHAR2,
146: p_request_id IN NUMBER,
151: p_last_update_login IN NUMBER DEFAULT NULL,
152: p_last_update_date IN DATE,
153: p_invocation_mode IN VARCHAR2 := 'NORMAL',
154: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
155: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
156: p_notes IN CS_ServiceRequest_PVT.notes_table,
157: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
158: p_audit_comments IN VARCHAR2 DEFAULT NULL,
159: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
155: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
156: p_notes IN CS_ServiceRequest_PVT.notes_table,
157: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
158: p_audit_comments IN VARCHAR2 DEFAULT NULL,
159: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
160: p_workflow_process_id IN NUMBER DEFAULT NULL,
161: x_workflow_process_id OUT NOCOPY NUMBER,
162: x_interaction_id OUT NOCOPY NUMBER
163: ) ;