PACKAGE: APPS.GMD_ACTIVITIES_PVT

Source

1 PACKAGE GMD_ACTIVITIES_PVT AUTHID CURRENT_USER AS
2 /*  $Header: GMDVACTS.pls 115.3 2002/11/27 16:07:49 txdaniel noship $
3  +=========================================================================+
4  | FILENAME                                                                |
5  |     GMDVACTS.pls                                                        |
6  |                                                                         |
7  | DESCRIPTION                                                             |
8  |     This package contains private definitions for  			   |
9  |     creating, modifying Activities                                      |
10  |                                                                         |
11  | HISTORY                                                                 |
12  |     06-JUN-2002  Sandra Dulyk    Created                                |
13  |     25-NOV-2002  Thomas Daniel   Bug# 2679110                           |
14  |                                  Added further validations and rewrote  |
15  |                                  the update procedure.                  |
16  +=========================================================================+
17   API Name  : GMD_ACTIVITIES_PVT
18   Type      : Private
19   Function  : This package contains private procedures used to create, modify, and delete Activities
20   Pre-reqs  : N/A
21   Parameters: Per function
22 
23   Current Vers  : 1.0
24 
25   Previous Vers : 1.0
26 
27   Initial Vers  : 1.0
28   Notes
29 */
30 
31 PROCEDURE insert_activity
32 (
33   p_api_version 		IN 	NUMBER	DEFAULT	   1
34 , p_init_msg_list 		IN 	BOOLEAN	DEFAULT	  TRUE
35 , p_commit			IN 	BOOLEAN	DEFAULT   FALSE
36 , p_activity_tbl		IN 	gmd_activities_pub.gmd_activities_tbl_type
37 , x_message_count	 	OUT NOCOPY  	NUMBER
38 , x_message_list 		OUT NOCOPY  	VARCHAR2
39 , x_return_status		OUT NOCOPY  	VARCHAR2
40 );
41 
42 PROCEDURE update_activity
43 (
44   p_api_version 		IN 	NUMBER		DEFAULT 1
45 , p_init_msg_list 		IN 	BOOLEAN	DEFAULT TRUE
46 , p_commit			IN 	BOOLEAN	DEFAULT FALSE
47 , p_activity			IN 	gmd_activities.activity%TYPE
48 , p_update_table		IN	gmd_activities_pub.update_tbl_type
49 , x_message_count 		OUT NOCOPY  	NUMBER
50 , x_message_list 		OUT NOCOPY  	VARCHAR2
51 , x_return_status		OUT NOCOPY  	VARCHAR2
52 );
53 
54 END GMD_ACTIVITIES_PVT;