DBA Data[Home] [Help]

PACKAGE: APPS.CUG_PREVENT_SR_UPDATE_PKG

Source


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