1 PACKAGE GMD_OPERATIONS_PUB AS
2 /* $Header: GMDPOPSS.pls 120.1 2006/10/03 18:11:45 rajreddy noship $ */
3 /*#
4 * This interface is used to create, update and delete operations.
5 * This package defines and implements the procedures and datatypes
6 * required to create, update and delete operations.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Operations Public package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_OPERATION
13 */
14
15 /*
16 +=========================================================================+
17 | FILENAME |
18 | GMDPOPSS.pls |
19 | |
20 | DESCRIPTION |
21 | This package contains public definitions for |
22 | creating, modifying, deleting opeations |
23 | |
24 | HISTORY |
25 | 22-JUNE-2002 Sandra Dulyk Created |
26 | 10-MAR-2004 kkillams New p_oprn_rsrc_tbl input paramter is |
27 | added to proceudre to pass the resource|
28 | details for activities w.r.t. |
29 | bug# 3408799 |
30 +=========================================================================+
31 API Name : GMD_OPERATIONS_PUB
32 Type : Public
33 Function : This package contains public procedures used to create, modify, and delete operations
34 Pre-reqs : N/A
35 Parameters: Per function
36
37 Current Vers : 1.0
38
39 Previous Vers : 1.0
40
41 Initial Vers : 1.0
42 Notes
43 */
44
45 TYPE gmd_oprn_activities_tbl_type IS TABLE OF gmd_operation_activities%ROWTYPE
46 INDEX BY BINARY_INTEGER;
47
48
49 TYPE update_table_rec_type IS RECORD
50 (
51 p_col_to_update VARCHAR2(30)
52 , p_value VARCHAR2(30)
53 );
54
55 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
56
57 /*#
58 * Insert a new Operation
59 * This is a PL/SQL procedure to insert a new Operation in Operations Table
60 * Call is made to insert_operation API of GMD_OPERATIONS_PVT package
61 * @param p_api_version API version field
62 * @param p_init_msg_list Flag to check if message list intialized
63 * @param p_commit Flag to check for commit
64 * @param p_operations Row type of Operations table
65 * @param p_oprn_actv_tbl Table structure of Operation activities table
66 * @param x_message_count Number of msg's on message stack
67 * @param x_message_list Message list
68 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
69 * @param p_oprn_rsrc_tbl Table structure of Operation Resource Table
70 * @rep:scope public
71 * @rep:lifecycle active
72 * @rep:displayname Insert Operation procedure
73 * @rep:compatibility S
74 */
75 PROCEDURE insert_operation
76 ( p_api_version IN NUMBER DEFAULT 1
77 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
78 , p_commit IN BOOLEAN DEFAULT FALSE
79 , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
80 , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
81 , x_message_count OUT NOCOPY NUMBER
82 , x_message_list OUT NOCOPY VARCHAR2
83 , x_return_status OUT NOCOPY VARCHAR2
84 , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type --Added w.r.t. bug 3408799
85 );
86
87 /*#
88 * Update an Operation
89 * This is a PL/SQL procedure to update an Operation in Operations Table
90 * Call is made to update_operation API of GMD_OPERATIONS_PVT package
91 * @param p_api_version API version field
92 * @param p_init_msg_list Flag to check if message list intialized
93 * @param p_commit Flag to check for commit
94 * @param p_oprn_id Operation ID
95 * @param p_oprn_no Operation Number
96 * @param p_oprn_vers Operation Version
97 * @param p_update_table Table structure containing column and table to be updated
98 * @param x_message_count Number of msg's on message stack
99 * @param x_message_list Message list
100 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
101 * @rep:scope public
102 * @rep:lifecycle active
103 * @rep:displayname Update Operation procedure
104 * @rep:compatibility S
105 */
106 PROCEDURE update_operation
107 ( p_api_version IN NUMBER DEFAULT 1
108 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
109 , p_commit IN BOOLEAN DEFAULT FALSE
110 , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
111 , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
112 , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
113 , p_update_table IN gmd_operations_pub.update_tbl_type
114 , x_message_count OUT NOCOPY NUMBER
115 , x_message_list OUT NOCOPY VARCHAR2
116 , x_return_status OUT NOCOPY VARCHAR2
117 );
118
119 /*#
120 * Delete an Operation
121 * This is a PL/SQL procedure to delete an Operation in Operations Table
122 * Call is made to delete_operation API of GMD_OPERATIONS_PVT package
123 * @param p_api_version API version field
124 * @param p_init_msg_list Flag to check if message list intialized
125 * @param p_commit Flag to check for commit
126 * @param p_oprn_id Operation ID
127 * @param p_oprn_no Operation Number
128 * @param p_oprn_vers Operation Version
129 * @param x_message_count Number of msg's on message stack
130 * @param x_message_list Message list
131 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
132 * @rep:scope public
133 * @rep:lifecycle active
134 * @rep:displayname Delete Operation procedure
135 * @rep:compatibility S
136 */
137 PROCEDURE delete_operation
138 ( p_api_version IN NUMBER DEFAULT 1
139 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
140 , p_commit IN BOOLEAN DEFAULT FALSE
141 , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
142 , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
143 , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
144 , x_message_count OUT NOCOPY NUMBER
145 , x_message_list OUT NOCOPY VARCHAR2
146 , x_return_status OUT NOCOPY VARCHAR2
147 );
148
149 END GMD_OPERATIONS_PUB;