3:
4:
5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
4:
5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
5: PROCEDURE Create_ServiceRequest_Pre
6: ( p_api_version IN NUMBER,
7: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
9: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
10: x_return_status OUT NOCOPY VARCHAR2,
11: x_msg_count OUT NOCOPY NUMBER,
12: x_msg_data OUT NOCOPY VARCHAR2,
13: p_resp_appl_id IN NUMBER DEFAULT NULL,
31:
32:
33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
32:
33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
33: PROCEDURE Create_ServiceRequest_Post
34: ( p_api_version IN NUMBER,
35: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
36: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
37: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
38: x_return_status OUT NOCOPY VARCHAR2,
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: p_resp_appl_id IN NUMBER DEFAULT NULL,
60:
61:
62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
61:
62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
62: PROCEDURE Update_ServiceRequest_Post
63: ( p_api_version IN NUMBER,
64: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
66: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
67: x_return_status OUT NOCOPY VARCHAR2,
68: x_msg_count OUT NOCOPY NUMBER,
69: x_msg_data OUT NOCOPY VARCHAR2,
70: p_request_id IN NUMBER,
74: p_last_updated_by IN NUMBER,
75: p_last_update_login IN NUMBER DEFAULT NULL,
76: p_last_update_date IN DATE,
77: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
78: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_notes IN CS_ServiceRequest_PVT.notes_table,
80: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
81: p_audit_comments IN VARCHAR2 DEFAULT NULL,
82: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
78: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
79: p_notes IN CS_ServiceRequest_PVT.notes_table,
80: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
81: p_audit_comments IN VARCHAR2 DEFAULT NULL,
82: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
83: p_workflow_process_id IN NUMBER DEFAULT NULL,
84: x_workflow_process_id OUT NOCOPY NUMBER,
85: x_interaction_id OUT NOCOPY NUMBER
86: ) IS
90:
91:
92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
91:
92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
92: PROCEDURE Update_ServiceRequest_Pre
93: ( p_api_version IN NUMBER,
94: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
95: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
96: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
97: x_return_status OUT NOCOPY VARCHAR2,
98: x_msg_count OUT NOCOPY NUMBER,
99: x_msg_data OUT NOCOPY VARCHAR2,
100: p_request_id IN NUMBER,
104: p_last_updated_by IN NUMBER,
105: p_last_update_login IN NUMBER DEFAULT NULL,
106: p_last_update_date IN DATE,
107: p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
108: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
109: p_notes IN CS_ServiceRequest_PVT.notes_table,
110: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
111: p_audit_comments IN VARCHAR2 DEFAULT NULL,
112: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
108: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
109: p_notes IN CS_ServiceRequest_PVT.notes_table,
110: p_contacts IN CS_ServiceRequest_PVT.contacts_table,
111: p_audit_comments IN VARCHAR2 DEFAULT NULL,
112: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
113: p_workflow_process_id IN NUMBER DEFAULT NULL,
114: x_workflow_process_id OUT NOCOPY NUMBER,
115: x_interaction_id OUT NOCOPY NUMBER
116: )
162: x_msg_data := l_msg_data;
163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count;
169: x_msg_data := l_msg_data;
170:
163:
164:
165: EXCEPTION
166: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167: x_return_status := FND_API.G_RET_STS_ERROR;
168: x_msg_count := l_msg_count;
169: x_msg_data := l_msg_data;
170:
171: FND_MSG_PUB.Count_And_Get
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count;
178: x_msg_data := l_msg_data;
179:
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count;
178: x_msg_data := l_msg_data;
179:
180: FND_MSG_PUB.Count_And_Get