1: PACKAGE BODY CS_ServiceRequest_ENQUEUE_PKG AS
2: /* $Header: CSXSREQB.pls 120.0 2006/02/09 16:58:28 spusegao noship $ */
3:
4: -- Enqueue Service Request, Notes and Contacts
5: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_api_version IN NUMBER,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
9: x_return_status OUT NOCOPY VARCHAR2,
3:
4: -- Enqueue Service Request, Notes and Contacts
5: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_api_version IN NUMBER,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,
4: -- Enqueue Service Request, Notes and Contacts
5: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
6: p_api_version IN NUMBER,
7: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
8: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
9: x_return_status OUT NOCOPY VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,
11: x_msg_data OUT NOCOPY VARCHAR2,
12: p_Request_Id IN NUMBER,
33:
34:
35: -- Enqueue Service Request and Contacts
36:
37: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
40: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
35: -- Enqueue Service Request and Contacts
36:
37: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
40: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
36:
37: PROCEDURE EnqueueSR(p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
38: p_api_version IN NUMBER,
39: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
40: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
41: x_return_status OUT NOCOPY VARCHAR2,
42: x_msg_count OUT NOCOPY NUMBER,
43: x_msg_data OUT NOCOPY VARCHAR2,
44: p_Request_Id IN NUMBER,
60: NULL;
61: END ;
62:
63:
64: PROCEDURE EnqueueSR( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_api_version IN NUMBER,
66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
68: x_return_status OUT NOCOPY VARCHAR2,
62:
63:
64: PROCEDURE EnqueueSR( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_api_version IN NUMBER,
66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
63:
64: PROCEDURE EnqueueSR( p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
65: p_api_version IN NUMBER,
66: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
67: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
68: x_return_status OUT NOCOPY VARCHAR2,
69: x_msg_count OUT NOCOPY NUMBER,
70: x_msg_data OUT NOCOPY VARCHAR2,
71: p_Request_Id IN NUMBER,