1 PACKAGE GMD_OPERATION_ACTIVITIES_PUB AS
2 /* $Header: GMDPOPAS.pls 120.2 2006/10/03 18:10:56 rajreddy noship $ */
3 /*#
4 * This interface is used to create, update and delete operation activities.
5 * This package defines and implements the procedures and datatypes
6 * required to create, update and delete operation activities.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Operation Activity package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_OPERATION
13 */
14
15
16 TYPE gmd_oprn_activities_tbl_type IS TABLE OF gmd_operation_activities%ROWTYPE
17 INDEX BY BINARY_INTEGER;
18
19 TYPE update_table_rec_type IS RECORD
20 (
21 p_col_to_update VARCHAR2(30)
22 , p_value VARCHAR2(240)
23 );
24
25 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
26
27 /*#
28 * Insert a new Operation Activity
29 * This is a PL/SQL procedure to insert a new Operation Activity
30 * Call is made to insert_operation_activity API of GMD_OPERATION_ACTIVITIES_PVT package
31 * @param p_api_version API version field
32 * @param p_init_msg_list Flag to check if message list intialized
33 * @param p_commit Flag to check for commit
34 * @param p_oprn_no Operation Number
35 * @param p_oprn_vers Operation Version
36 * @param p_oprn_activity Rowtype of Operation activities table
37 * @param p_oprn_rsrc_tbl Table structure of Operation resources table
38 * @param x_message_count Number of msg's on message stack
39 * @param x_message_list Message list
40 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
41 * @rep:scope public
42 * @rep:lifecycle active
43 * @rep:displayname Insert Operation Activity procedure
44 * @rep:compatibility S
45 */
46 PROCEDURE insert_operation_activity
47 ( p_api_version IN NUMBER DEFAULT 1
48 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
49 , p_commit IN BOOLEAN DEFAULT FALSE
50 , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
51 , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
52 , p_oprn_activity IN OUT NOCOPY gmd_operation_activities%ROWTYPE
53 , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
54 , x_message_count OUT NOCOPY NUMBER
55 , x_message_list OUT NOCOPY VARCHAR2
56 , x_return_status OUT NOCOPY VARCHAR2
57 );
58
59 /*#
60 * Update an Operation Activity
61 * This is a PL/SQL procedure to update an Operation Activity
62 * Call is made to update_operation_activity API of GMD_OPERATION_ACTIVITIES_PVT package
63 * @param p_api_version API version field
64 * @param p_init_msg_list Flag to check if message list intialized
65 * @param p_commit Flag to check for commit
66 * @param p_oprn_line_id Operation Line ID
67 * @param p_update_table Table structure containing column and table to be updated
68 * @param x_message_count Number of msg's on message stack
69 * @param x_message_list Message list
70 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
71 * @rep:scope public
72 * @rep:lifecycle active
73 * @rep:displayname Update Operation Activity procedure
74 * @rep:compatibility S
75 */
76 PROCEDURE update_operation_activity
77 ( p_api_version IN NUMBER DEFAULT 1
78 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
79 , p_commit IN BOOLEAN DEFAULT FALSE
80 , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
81 , p_update_table IN gmd_operation_activities_pub.update_tbl_type
82 , x_message_count OUT NOCOPY NUMBER
83 , x_message_list OUT NOCOPY VARCHAR2
84 , x_return_status OUT NOCOPY VARCHAR2
85 );
86
87
88 /*#
89 * Delete an Operation Activity
90 * This is a PL/SQL procedure to delete an Operation Activity
91 * Call is made to delete_operation_activity API of GMD_OPERATION_ACTIVITIES_PVT package
92 * @param p_api_version API version field
93 * @param p_init_msg_list Flag to check if message list intialized
94 * @param p_commit Flag to check for commit
95 * @param p_oprn_line_id Operation Line ID
96 * @param x_message_count Number of msg's on message stack
97 * @param x_message_list Message list
98 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
99 * @rep:scope public
100 * @rep:lifecycle active
101 * @rep:displayname Delete Operation Activity procedure
102 * @rep:compatibility S
103 */
104 PROCEDURE delete_operation_activity
105 ( p_api_version IN NUMBER DEFAULT 1
106 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
107 , p_commit IN BOOLEAN DEFAULT FALSE
108 , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
109 , x_message_count OUT NOCOPY NUMBER
110 , x_message_list OUT NOCOPY VARCHAR2
111 , x_return_status OUT NOCOPY VARCHAR2
112 );
113
114
115 END GMD_OPERATION_ACTIVITIES_PUB;