1 Package CUG_PREVENT_SR_UPDATE_PKG AUTHID CURRENT_USER AS
2 /* $Header: CUGPREUS.pls 115.2 2002/12/04 19:59:04 pkesani noship $ */
3 --
4 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
5 -- directory of SQL Navigator
6 --
7 -- Purpose: Briefly explain the functionality of the package
8 --
9 -- MODIFICATION HISTORY
10 -- Person Date Comments
11 -- --------- ------ ------------------------------------------
12 -- Enter package declarations as shown below
13
14 PROCEDURE Update_ServiceRequest_Prevent
15 ( p_api_version IN NUMBER,
16 p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
17 p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
18 p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
19 x_return_status OUT NOCOPY VARCHAR2,
20 x_msg_count OUT NOCOPY NUMBER,
21 x_msg_data OUT NOCOPY VARCHAR2,
22 p_request_id IN NUMBER,
23 p_object_version_number IN NUMBER,
24 p_resp_appl_id IN NUMBER DEFAULT NULL,
25 p_resp_id IN NUMBER DEFAULT NULL,
26 p_last_updated_by IN NUMBER,
27 p_last_update_login IN NUMBER DEFAULT NULL,
28 p_last_update_date IN DATE,
29 p_service_request_rec IN CS_ServiceRequest_PVT.service_request_rec_type,
30 p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
31 p_notes IN CS_ServiceRequest_PVT.notes_table,
32 p_contacts IN CS_ServiceRequest_PVT.contacts_table,
33 p_audit_comments IN VARCHAR2 DEFAULT NULL,
34 p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
35 p_workflow_process_id IN NUMBER DEFAULT NULL,
36 x_workflow_process_id OUT NOCOPY NUMBER,
37 x_interaction_id OUT NOCOPY NUMBER
38 );
39 END; -- Package Specification CUG_PREVENT_SR_UPDATE_PKG