1 PACKAGE GMD_ACTIVITIES_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPACTS.pls 115.4 2004/04/16 14:35:33 srsriran noship $ */
3 /*#
4 * This interface is used to create, update and delete Activities.
5 * This package defines and implements the procedures and datatypes
6 * required to create, update and delete Activities.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Activities package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_ACTIVITIES_PUB
13 */
14
15
16 TYPE activities_rec_type IS RECORD
17 (
18 ACTIVITY gmd_activities.activity%type
19 ,COST_ANALYSIS_CODE gmd_activities.cost_analysis_code%type
20 ,DELETE_MARK gmd_activities.delete_mark%type DEFAULT 0
21 ,TEXT_CODE gmd_activities.text_code%type
22 ,TRANS_CNT gmd_activities.trans_cnt%type
23 ,ACTIVITY_DESC gmd_activities.activity_desc%type
24
25 );
26
27
28 TYPE gmd_activities_tbl_type IS TABLE OF activities_rec_type INDEX BY BINARY_INTEGER;
29
30
31 TYPE update_table_rec_type IS RECORD
32 (
33 p_col_to_update VARCHAR2(80)
34 , p_value VARCHAR2(80)
35
36 );
37
38
39 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
40
41 /*#
42 * Insert a new Activity
43 * This is a PL/SQL procedure to insert a new Activity
44 * Call is made to insert_activity API of GMD_ACTIVITIES_PVT package
45 * @param p_api_version API version field
46 * @param p_init_msg_list Flag to check if message list intialized
47 * @param p_commit Flag to check for commit
48 * @param p_activity_tbl Table structure of Activities table
49 * @param x_message_count Number of msg's on message stack
50 * @param x_message_list Message list
51 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
52 * @rep:scope public
53 * @rep:lifecycle active
54 * @rep:displayname Insert Activity procedure
55 * @rep:compatibility S
56 */
57 PROCEDURE insert_activity
58 (
59 p_api_version IN NUMBER DEFAULT 1
60 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
61 , p_commit IN BOOLEAN DEFAULT FALSE
62 , p_activity_tbl IN gmd_activities_pub.gmd_activities_tbl_type
63 , x_message_count OUT NOCOPY NUMBER
64 , x_message_list OUT NOCOPY VARCHAR2
65 , x_return_status OUT NOCOPY VARCHAR2
66 );
67
68 /*#
69 * Update an Activity
70 * This is a PL/SQL procedure to update an Activity
71 * Call is made to update_activity API of GMD_ACTIVITIES_PVT package
72 * @param p_api_version API version field
73 * @param p_init_msg_list Flag to check if message list intialized
74 * @param p_commit Flag to check for commit
75 * @param p_activity Field to pass activities
76 * @param p_update_table Table structure containing column and table to be updated
77 * @param x_message_count Number of msg's on message stack
78 * @param x_message_list Message list
79 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
80 * @rep:scope public
81 * @rep:lifecycle active
82 * @rep:displayname Update Activity procedure
83 * @rep:compatibility S
84 */
85 PROCEDURE update_activity
86 (
87 p_api_version IN NUMBER DEFAULT 1
88 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
89 , p_commit IN BOOLEAN DEFAULT FALSE
90 , p_activity IN gmd_activities.activity%TYPE
91 , p_update_table IN gmd_activities_pub.update_tbl_type
92 , x_message_count OUT NOCOPY NUMBER
93 , x_message_list OUT NOCOPY VARCHAR2
94 , x_return_status OUT NOCOPY VARCHAR2
95 );
96
97 /*#
98 * Delete an Activity
99 * This is a PL/SQL procedure to delete an Activity
100 * Call is made to delete_activity API of GMD_ACTIVITIES_PVT package
101 * @param p_api_version API version field
102 * @param p_init_msg_list Flag to check if message list intialized
103 * @param p_commit Flag to check for commit
104 * @param p_activity Field to pass activities
105 * @param x_message_count Number of msg's on message stack
106 * @param x_message_list Message list
107 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
108 * @rep:scope public
109 * @rep:lifecycle active
110 * @rep:displayname Delete Activity procedure
111 * @rep:compatibility S
112 */
113 PROCEDURE delete_activity (
114 p_api_version IN NUMBER DEFAULT 1
115 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
116 , p_commit IN BOOLEAN DEFAULT FALSE
117 , p_activity IN gmd_activities.activity%TYPE
118 , x_message_count OUT NOCOPY NUMBER
119 , x_message_list OUT NOCOPY VARCHAR2
120 , x_return_status OUT NOCOPY VARCHAR2
121 );
122
123 END GMD_ACTIVITIES_PUB;