1 PACKAGE GMD_OPERATIONS_PUB AUTHID CURRENT_USER AS
2 /* $Header: GMDPOPSS.pls 120.1.12020000.2 2012/10/25 07:22:21 yanpewan ship $ */
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 | 25-OCT-2012 James Wang Bug#14797714 p_col_to_update & p_value |
31 | should be changed to support 240 |
32 | characters for update operation |
33 | description through api. |
34 | |
35 +=========================================================================+
36 API Name : GMD_OPERATIONS_PUB
37 Type : Public
38 Function : This package contains public procedures used to create, modify, and delete operations
39 Pre-reqs : N/A
40 Parameters: Per function
41
42 Current Vers : 1.0
43
44 Previous Vers : 1.0
45
46 Initial Vers : 1.0
47 Notes
48 */
49
50 TYPE gmd_oprn_activities_tbl_type IS TABLE OF gmd_operation_activities%ROWTYPE
51 INDEX BY BINARY_INTEGER;
52
53
54 TYPE update_table_rec_type IS RECORD
55 (
56 p_col_to_update VARCHAR2(240) --Bug#14797714
57 , p_value VARCHAR2(240) --Bug#14797714
58 );
59
60 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
61
62 /*#
63 * Insert a new Operation
64 * This is a PL/SQL procedure to insert a new Operation in Operations Table
65 * Call is made to insert_operation API of GMD_OPERATIONS_PVT package
66 * @param p_api_version API version field
67 * @param p_init_msg_list Flag to check if message list intialized
68 * @param p_commit Flag to check for commit
69 * @param p_operations Row type of Operations table
70 * @param p_oprn_actv_tbl Table structure of Operation activities table
71 * @param x_message_count Number of msg's on message stack
72 * @param x_message_list Message list
73 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
74 * @param p_oprn_rsrc_tbl Table structure of Operation Resource Table
75 * @rep:scope public
76 * @rep:lifecycle active
77 * @rep:displayname Insert Operation procedure
78 * @rep:compatibility S
79 */
80 PROCEDURE insert_operation
81 ( p_api_version IN NUMBER DEFAULT 1
82 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
83 , p_commit IN BOOLEAN DEFAULT FALSE
84 , p_operations IN OUT NOCOPY gmd_operations%ROWTYPE
85 , p_oprn_actv_tbl IN OUT NOCOPY gmd_operations_pub.gmd_oprn_activities_tbl_type
86 , x_message_count OUT NOCOPY NUMBER
87 , x_message_list OUT NOCOPY VARCHAR2
88 , x_return_status OUT NOCOPY VARCHAR2
89 , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type --Added w.r.t. bug 3408799
90 );
91
92 /*#
93 * Update an Operation
94 * This is a PL/SQL procedure to update an Operation in Operations Table
95 * Call is made to update_operation API of GMD_OPERATIONS_PVT package
96 * @param p_api_version API version field
97 * @param p_init_msg_list Flag to check if message list intialized
98 * @param p_commit Flag to check for commit
99 * @param p_oprn_id Operation ID
100 * @param p_oprn_no Operation Number
101 * @param p_oprn_vers Operation Version
102 * @param p_update_table Table structure containing column and table to be updated
103 * @param x_message_count Number of msg's on message stack
104 * @param x_message_list Message list
105 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
106 * @rep:scope public
107 * @rep:lifecycle active
108 * @rep:displayname Update Operation procedure
109 * @rep:compatibility S
110 */
111 PROCEDURE update_operation
112 ( p_api_version IN NUMBER DEFAULT 1
113 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
114 , p_commit IN BOOLEAN DEFAULT FALSE
115 , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
116 , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
117 , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
118 , p_update_table IN gmd_operations_pub.update_tbl_type
119 , x_message_count OUT NOCOPY NUMBER
120 , x_message_list OUT NOCOPY VARCHAR2
121 , x_return_status OUT NOCOPY VARCHAR2
122 );
123
124 /*#
125 * Delete an Operation
126 * This is a PL/SQL procedure to delete an Operation in Operations Table
127 * Call is made to delete_operation API of GMD_OPERATIONS_PVT package
128 * @param p_api_version API version field
129 * @param p_init_msg_list Flag to check if message list intialized
130 * @param p_commit Flag to check for commit
131 * @param p_oprn_id Operation ID
132 * @param p_oprn_no Operation Number
133 * @param p_oprn_vers Operation Version
134 * @param x_message_count Number of msg's on message stack
135 * @param x_message_list Message list
136 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
137 * @rep:scope public
138 * @rep:lifecycle active
139 * @rep:displayname Delete Operation procedure
140 * @rep:compatibility S
141 */
142 PROCEDURE delete_operation
143 ( p_api_version IN NUMBER DEFAULT 1
144 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
145 , p_commit IN BOOLEAN DEFAULT FALSE
146 , p_oprn_id IN gmd_operations.oprn_id%TYPE DEFAULT NULL
147 , p_oprn_no IN gmd_operations.oprn_no%TYPE DEFAULT NULL
148 , p_oprn_vers IN gmd_operations.oprn_vers%TYPE DEFAULT NULL
149 , x_message_count OUT NOCOPY NUMBER
150 , x_message_list OUT NOCOPY VARCHAR2
151 , x_return_status OUT NOCOPY VARCHAR2
152 );
153
154 END GMD_OPERATIONS_PUB;