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,
55:
56:
57: PROCEDURE Create_ServiceRequest_Post
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
56:
57: PROCEDURE Create_ServiceRequest_Post
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
57: PROCEDURE Create_ServiceRequest_Post
58: ( p_api_version IN NUMBER,
59: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
60: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
61: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
62: x_return_status OUT NOCOPY VARCHAR2,
63: x_msg_count OUT NOCOPY NUMBER,
64: x_msg_data OUT NOCOPY VARCHAR2,
65: p_resp_appl_id IN NUMBER DEFAULT NULL,
94:
95:
96: PROCEDURE Update_ServiceRequest_Pre
97: ( p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
100: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
95:
96: PROCEDURE Update_ServiceRequest_Pre
97: ( p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
100: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
96: PROCEDURE Update_ServiceRequest_Pre
97: ( p_api_version IN NUMBER,
98: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
99: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
100: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
101: x_return_status OUT NOCOPY VARCHAR2,
102: x_msg_count OUT NOCOPY NUMBER,
103: x_msg_data OUT NOCOPY VARCHAR2,
104: p_request_id 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,
117: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
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,
120: x_interaction_id OUT NOCOPY NUMBER
121: ) ;
134:
135:
136: PROCEDURE Update_ServiceRequest_Post
137: ( p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
139: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
140: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
135:
136: PROCEDURE Update_ServiceRequest_Post
137: ( p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
139: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
140: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
136: PROCEDURE Update_ServiceRequest_Post
137: ( p_api_version IN NUMBER,
138: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
139: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
140: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
141: x_return_status OUT NOCOPY VARCHAR2,
142: x_msg_count OUT NOCOPY NUMBER,
143: x_msg_data OUT NOCOPY VARCHAR2,
144: p_request_id 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,
157: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
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,
160: x_interaction_id OUT NOCOPY NUMBER
161: ) ;