[Home] [Help]
PACKAGE: APPS.GMD_OPERATION_RESOURCES_PUB
Source
1 PACKAGE GMD_OPERATION_RESOURCES_PUB AS
2 /* $Header: GMDPOPRS.pls 120.1.12010000.1 2008/07/24 09:56:44 appldev ship $ */
3 /*#
4 * This interface is used to create, update and delete operation resources.
5 * This package defines and implements the procedures and datatypes
6 * required to create, update and delete operation resources.
7 * @rep:scope public
8 * @rep:product GMD
9 * @rep:lifecycle active
10 * @rep:displayname Operation Resources package
11 * @rep:compatibility S
12 * @rep:category BUSINESS_ENTITY GMD_OPERATION
13 */
14
15 TYPE resources_rec_type IS RECORD
16 (
17 OPRN_LINE_ID gmd_operation_resources.oprn_line_id%TYPE
18 ,RESOURCES gmd_operation_resources.resources%TYPE
19 ,RESOURCE_USAGE gmd_operation_resources.resource_usage%TYPE
20 ,RESOURCE_COUNT gmd_operation_resources.resource_count%TYPE DEFAULT 1
21 ,RESOURCE_USAGE_UOM gmd_operation_resources.usage_um%TYPE
22 ,PROCESS_QTY gmd_operation_resources.process_qty%TYPE
23 ,RESOURCE_PROCESS_UOM gmd_operation_resources.process_uom%TYPE
24 ,PRIM_RSRC_IND gmd_operation_resources.prim_rsrc_ind%TYPE
25 ,SCALE_TYPE gmd_operation_resources.scale_type%TYPE DEFAULT 1
26 ,COST_ANALYSIS_CODE gmd_operation_resources.cost_analysis_code%TYPE
27 ,COST_CMPNTCLS_ID gmd_operation_resources.cost_cmpntcls_id%TYPE
28 ,OFFSET_INTERVAL gmd_operation_resources.offset_interval%TYPE DEFAULT 0
29 ,MIN_CAPACITY gmd_operation_resources.min_capacity%TYPE
30 ,MAX_CAPACITY gmd_operation_resources.max_capacity%TYPE
31 ,RESOURCE_CAPACITY_UOM gmd_operation_resources.capacity_uom%TYPE
32 ,ATTRIBUTE_CATEGORY gmd_operation_resources.attribute_category%TYPE
33 ,ATTRIBUTE1 gmd_operation_resources.attribute1%TYPE
34 ,ATTRIBUTE2 gmd_operation_resources.attribute2%TYPE
35 ,ATTRIBUTE3 gmd_operation_resources.attribute3%TYPE
36 ,ATTRIBUTE4 gmd_operation_resources.attribute4%TYPE
37 ,ATTRIBUTE5 gmd_operation_resources.attribute5%TYPE
38 ,ATTRIBUTE6 gmd_operation_resources.attribute6%TYPE
39 ,ATTRIBUTE7 gmd_operation_resources.attribute7%TYPE
40 ,ATTRIBUTE8 gmd_operation_resources.attribute8%TYPE
41 ,ATTRIBUTE9 gmd_operation_resources.attribute9%TYPE
42 ,ATTRIBUTE10 gmd_operation_resources.attribute10%TYPE
43 ,ATTRIBUTE11 gmd_operation_resources.attribute11%TYPE
44 ,ATTRIBUTE12 gmd_operation_resources.attribute12%TYPE
45 ,ATTRIBUTE13 gmd_operation_resources.attribute13%TYPE
46 ,ATTRIBUTE14 gmd_operation_resources.attribute14%TYPE
47 ,ATTRIBUTE15 gmd_operation_resources.attribute15%TYPE
48 ,ATTRIBUTE16 gmd_operation_resources.attribute16%TYPE
49 ,ATTRIBUTE17 gmd_operation_resources.attribute17%TYPE
50 ,ATTRIBUTE18 gmd_operation_resources.attribute18%TYPE
51 ,ATTRIBUTE19 gmd_operation_resources.attribute19%TYPE
52 ,ATTRIBUTE20 gmd_operation_resources.attribute20%TYPE
53 ,ATTRIBUTE21 gmd_operation_resources.attribute21%TYPE
54 ,ATTRIBUTE22 gmd_operation_resources.attribute22%TYPE
55 ,ATTRIBUTE23 gmd_operation_resources.attribute23%TYPE
56 ,ATTRIBUTE24 gmd_operation_resources.attribute24%TYPE
57 ,ATTRIBUTE25 gmd_operation_resources.attribute25%TYPE
58 ,ATTRIBUTE26 gmd_operation_resources.attribute26%TYPE
59 ,ATTRIBUTE27 gmd_operation_resources.attribute27%TYPE
60 ,ATTRIBUTE28 gmd_operation_resources.attribute28%TYPE
61 ,ATTRIBUTE29 gmd_operation_resources.attribute29%TYPE
62 ,ATTRIBUTE30 gmd_operation_resources.attribute30%TYPE
63 ,PROCESS_PARAMETER_1 gmd_operation_resources.process_parameter_1%TYPE
64 ,PROCESS_PARAMETER_2 gmd_operation_resources.process_parameter_2%TYPE
65 ,PROCESS_PARAMETER_3 gmd_operation_resources.process_parameter_3%TYPE
66 ,PROCESS_PARAMETER_4 gmd_operation_resources.process_parameter_4%TYPE
67 ,PROCESS_PARAMETER_5 gmd_operation_resources.process_parameter_5%TYPE
68 ,ACTIVITY gmd_operation_activities.activity%TYPE --added w.r.t. bug 3408799
69 );
70
71 TYPE gmd_oprn_resources_tbl_type IS TABLE OF resources_rec_type INDEX BY BINARY_INTEGER;
72
73
74 TYPE update_table_rec_type IS RECORD
75 (
76 p_col_to_update VARCHAR2(30)
77 , p_value VARCHAR2(30)
78 );
79
80 TYPE update_tbl_type IS TABLE OF update_table_rec_type INDEX BY BINARY_INTEGER;
81
82 /*#
83 * Insert a new Operation Resource
84 * This is a PL/SQL procedure to insert a new Operation Resource
85 * Call is made to insert_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
86 * @param p_api_version API version field
87 * @param p_init_msg_list Flag to check if message list intialized
88 * @param p_commit Flag to check for commit
89 * @param p_oprn_line_id Operation Line ID
90 * @param p_oprn_rsrc_tbl Table structure of Operation resources table
91 * @param x_message_count Number of msg's on message stack
92 * @param x_message_list Message list
93 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
94 * @rep:scope public
95 * @rep:lifecycle active
96 * @rep:displayname Insert Operation Resource procedure
97 * @rep:compatibility S
98 */
99 PROCEDURE insert_operation_resources
100 ( p_api_version IN NUMBER DEFAULT 1
101 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
102 , p_commit IN BOOLEAN DEFAULT FALSE
103 , p_oprn_line_id IN gmd_operation_activities.oprn_line_id%TYPE
104 , p_oprn_rsrc_tbl IN gmd_operation_resources_pub.gmd_oprn_resources_tbl_type
105 , x_message_count OUT NOCOPY NUMBER
106 , x_message_list OUT NOCOPY VARCHAR2
107 , x_return_status OUT NOCOPY VARCHAR2
108 );
109
110 /*#
111 * Update an Operation Resource
112 * This is a PL/SQL procedure to update an Operation Resource
113 * Call is made to update_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
114 * @param p_api_version API version field
115 * @param p_init_msg_list Flag to check if message list intialized
116 * @param p_commit Flag to check for commit
117 * @param p_oprn_line_id Operation Line ID
118 * @param p_resources Field to pass resources
119 * @param p_update_table Table structure containing column and table to be updated
120 * @param x_message_count Number of msg's on message stack
121 * @param x_message_list Message list
122 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
123 * @rep:scope public
124 * @rep:lifecycle active
125 * @rep:displayname Update Operation Resource procedure
126 * @rep:compatibility S
127 */
128 PROCEDURE update_operation_resources
129 ( p_api_version IN NUMBER DEFAULT 1
130 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
131 , p_commit IN BOOLEAN DEFAULT FALSE
132 , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
133 , p_resources IN gmd_operation_resources.resources%TYPE
134 , p_update_table IN gmd_operation_resources_pub.update_tbl_type
135 , x_message_count OUT NOCOPY NUMBER
136 , x_message_list OUT NOCOPY VARCHAR2
137 , x_return_status OUT NOCOPY VARCHAR2
138 );
139
140 /*#
141 * Delete an Operation Resource
142 * This is a PL/SQL procedure to delete an Operation Resource
143 * Call is made to delete_operation_resources API of GMD_OPERATION_RESOURCES_PVT package
144 * @param p_api_version API version field
145 * @param p_init_msg_list Flag to check if message list intialized
146 * @param p_commit Flag to check for commit
147 * @param p_oprn_line_id Operation Line ID
148 * @param p_resources Field to pass resources
149 * @param x_message_count Number of msg's on message stack
150 * @param x_message_list Message list
151 * @param x_return_status 'S'-Success, 'E'-Error, 'U'-Unexpected Error
152 * @rep:scope public
153 * @rep:lifecycle active
154 * @rep:displayname Delete Operation Resource procedure
155 * @rep:compatibility S
156 */
157 PROCEDURE delete_operation_resources
158 ( p_api_version IN NUMBER DEFAULT 1
159 , p_init_msg_list IN BOOLEAN DEFAULT TRUE
160 , p_commit IN BOOLEAN DEFAULT FALSE
161 , p_oprn_line_id IN gmd_operation_resources.oprn_line_id%TYPE
162 , p_resources IN gmd_operation_resources.resources%TYPE
163 , x_message_count OUT NOCOPY NUMBER
164 , x_message_list OUT NOCOPY VARCHAR2
165 , x_return_status OUT NOCOPY VARCHAR2
166 );
167
168 END GMD_OPERATION_RESOURCES_PUB;