eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.JTF_RS_RES_AVAILABILITY_PUB

Source


1 PACKAGE jtf_rs_res_availability_pub AUTHID CURRENT_USER AS
2 /* $Header: jtfrspzs.pls 120.0 2005/05/11 08:21:32 appldev ship $ */
3 /*#
4  * Resource Availability create, update and delete API
5  * This API contains the procedures to insert, update and delete resource availability record.
6  * @rep:scope internal
7  * @rep:product JTF
8  * @rep:displayname Resource Availability API
9  * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE_AVAILABILITY
10 */
11   /*****************************************************************************************
12    This is a public API that user API will invoke.
13    It provides procedures for managing seed data of jtf_rs_res_availability tables
14    create, update and delete rows
15    Its main procedures are as following:
16    Create res_availability
17    Update res_availability
18    Delete res_availability
19    Calls to these procedures will call procedures of jtf_rs_res_availability_pvt
20    to do inserts, updates and deletes into tables.
21    ******************************************************************************************/
22 
23 
24   /* Procedure to create the resource availability
25 	based on input values passed by calling routines. */
26 
27 /*#
28  * Create Resource Availability API
29  * This procedure allows the user to create resource availability record.
30  * By default, all resource are availabile and if we create a availability record then, that resource is not avilable.
31  * @param p_api_version API version
32  * @param p_init_msg_list Initialization of the message list
33  * @param p_commit Commit
34  * @param p_resource_id Resource Identifier
35  * @param p_available_flag Available Flag.
36  * @param p_reason_code Reason Code
37  * @param p_start_date Date on which the resource is not available.
38  * @param p_end_date Date on which the resource is available.
39  * @param p_mode_of_availability Mode of Availability
40  * @param p_attribute1 Descriptive flexfield Segment 1
41  * @param p_attribute2 Descriptive flexfield Segment 2
42  * @param p_attribute3 Descriptive flexfield Segment 3
43  * @param p_attribute4 Descriptive flexfield Segment 4
44  * @param p_attribute5 Descriptive flexfield Segment 5
45  * @param p_attribute6 Descriptive flexfield Segment 6
46  * @param p_attribute7 Descriptive flexfield Segment 7
47  * @param p_attribute8 Descriptive flexfield Segment 8
48  * @param p_attribute9 Descriptive flexfield Segment 9
49  * @param p_attribute10 Descriptive flexfield Segment 10
50  * @param p_attribute11 Descriptive flexfield Segment 11
51  * @param p_attribute12 Descriptive flexfield Segment 12
52  * @param p_attribute13 Descriptive flexfield Segment 13
53  * @param p_attribute14 Descriptive flexfield Segment 14
54  * @param p_attribute15 Descriptive flexfield Segment 15
55  * @param p_attribute_category Descriptive flexfield structure definition column
56  * @param x_return_status Output parameter for return status
57  * @param x_msg_count Output parameter for number of user messages from this procedure
58  * @param x_msg_data Output parameter containing last user message from this procedure
59  * @param x_availability_id Out parameter for resource availability Identifier
60  * @rep:scope internal
61  * @rep:lifecycle active
62  * @rep:displayname Create Resource Availability API
63 */
64   PROCEDURE  create_res_availability
65   (P_API_VERSION          IN   NUMBER,
66    P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
67    P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
68    P_RESOURCE_ID          IN   JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE,
69    P_AVAILABLE_FLAG       IN   JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE,
70    P_REASON_CODE          IN   JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE  DEFAULT  NULL,
71    P_START_DATE           IN   JTF_RS_RES_AVAILABILITY.START_DATE%TYPE   DEFAULT  NULL,
72    P_END_DATE             IN   JTF_RS_RES_AVAILABILITY.END_DATE%TYPE     DEFAULT  NULL,
73    P_MODE_OF_AVAILABILITY IN   JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE,
74    P_ATTRIBUTE1		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE   DEFAULT  NULL,
75    P_ATTRIBUTE2		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE   DEFAULT  NULL,
76    P_ATTRIBUTE3		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE   DEFAULT  NULL,
77    P_ATTRIBUTE4		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE   DEFAULT  NULL,
78    P_ATTRIBUTE5		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE   DEFAULT  NULL,
79    P_ATTRIBUTE6		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE   DEFAULT  NULL,
80    P_ATTRIBUTE7		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE   DEFAULT  NULL,
81    P_ATTRIBUTE8		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE   DEFAULT  NULL,
82    P_ATTRIBUTE9		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE   DEFAULT  NULL,
83    P_ATTRIBUTE10	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE   DEFAULT  NULL,
84    P_ATTRIBUTE11	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE   DEFAULT  NULL,
85    P_ATTRIBUTE12	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE   DEFAULT  NULL,
86    P_ATTRIBUTE13	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE   DEFAULT  NULL,
87    P_ATTRIBUTE14	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE   DEFAULT  NULL,
88    P_ATTRIBUTE15	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE   DEFAULT  NULL,
89    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE   DEFAULT  NULL,
90    X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
91    X_MSG_COUNT            OUT NOCOPY  NUMBER,
92    X_MSG_DATA             OUT NOCOPY  VARCHAR2,
93    X_AVAILABILITY_ID      OUT NOCOPY  JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE  );
94 
95 
96   /* Procedure to update resource availability
97 	based on input values passed by calling routines. */
98 /*#
99  * Update Resource Availability API
100  * This procedure allows the user to update resource availability record.
101  * @param p_api_version API version
102  * @param p_init_msg_list Initialization of the message list
103  * @param p_commit Commit
104  * @param p_availability_id Availability Identifier
105  * @param p_resource_id Resource Identifier
106  * @param p_available_flag Available Flag.
107  * @param p_reason_code Reason Code
108  * @param p_start_date Date on which the resource is not available.
109  * @param p_end_date Date on which the resource is available.
110  * @param p_mode_of_availability Mode of Availability
111  * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.
112  * @param p_attribute1 Descriptive flexfield Segment 1
113  * @param p_attribute2 Descriptive flexfield Segment 2
114  * @param p_attribute3 Descriptive flexfield Segment 3
115  * @param p_attribute4 Descriptive flexfield Segment 4
116  * @param p_attribute5 Descriptive flexfield Segment 5
117  * @param p_attribute6 Descriptive flexfield Segment 6
118  * @param p_attribute7 Descriptive flexfield Segment 7
119  * @param p_attribute8 Descriptive flexfield Segment 8
120  * @param p_attribute9 Descriptive flexfield Segment 9
121  * @param p_attribute10 Descriptive flexfield Segment 10
122  * @param p_attribute11 Descriptive flexfield Segment 11
123  * @param p_attribute12 Descriptive flexfield Segment 12
124  * @param p_attribute13 Descriptive flexfield Segment 13
125  * @param p_attribute14 Descriptive flexfield Segment 14
126  * @param p_attribute15 Descriptive flexfield Segment 15
127  * @param p_attribute_category Descriptive flexfield structure definition column
128  * @param x_return_status Output parameter for return status
129  * @param x_msg_count Output parameter for number of user messages from this procedure
130  * @param x_msg_data Output parameter containing last user message from this procedure
131  * @rep:scope internal
132  * @rep:lifecycle active
133  * @rep:displayname Update Resource Availability API
134 */
135   PROCEDURE  update_res_availability
136   (P_API_VERSION          IN   NUMBER,
137    P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
138    P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
139    P_AVAILABILITY_ID      IN   JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
140    P_RESOURCE_ID          IN   JTF_RS_RES_AVAILABILITY.RESOURCE_ID%TYPE   DEFAULT  FND_API.G_MISS_NUM,
141    P_AVAILABLE_FLAG       IN   JTF_RS_RES_AVAILABILITY.AVAILABLE_FLAG%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
142    P_REASON_CODE          IN   JTF_RS_RES_AVAILABILITY.REASON_CODE%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
143    P_START_DATE           IN   JTF_RS_RES_AVAILABILITY.START_DATE%TYPE   DEFAULT  FND_API.G_MISS_DATE,
144    P_END_DATE             IN   JTF_RS_RES_AVAILABILITY.END_DATE%TYPE     DEFAULT  FND_API.G_MISS_DATE,
145    P_MODE_OF_AVAILABILITY IN   JTF_RS_RES_AVAILABILITY.MODE_OF_AVAILABILITY%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
146    P_OBJECT_VERSION_NUM   IN OUT NOCOPY JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
147    P_ATTRIBUTE1		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE1%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
148    P_ATTRIBUTE2		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE2%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
149    P_ATTRIBUTE3		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE3%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
150    P_ATTRIBUTE4		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE4%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
151    P_ATTRIBUTE5		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE5%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
152    P_ATTRIBUTE6		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE6%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
153    P_ATTRIBUTE7		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE7%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
154    P_ATTRIBUTE8		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE8%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
155    P_ATTRIBUTE9		  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE9%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
156    P_ATTRIBUTE10	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE10%TYPE DEFAULT  FND_API.G_MISS_CHAR,
157    P_ATTRIBUTE11	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE11%TYPE DEFAULT  FND_API.G_MISS_CHAR,
158    P_ATTRIBUTE12	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE12%TYPE DEFAULT  FND_API.G_MISS_CHAR,
159    P_ATTRIBUTE13	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE13%TYPE DEFAULT  FND_API.G_MISS_CHAR,
160    P_ATTRIBUTE14	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE14%TYPE DEFAULT  FND_API.G_MISS_CHAR,
161    P_ATTRIBUTE15	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE15%TYPE DEFAULT  FND_API.G_MISS_CHAR,
162    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_RES_AVAILABILITY.ATTRIBUTE_CATEGORY%TYPE DEFAULT  FND_API.G_MISS_CHAR,
163    X_RETURN_STATUS       OUT NOCOPY    VARCHAR2,
164    X_MSG_COUNT           OUT NOCOPY    NUMBER,
165    X_MSG_DATA            OUT NOCOPY    VARCHAR2
166   );
167 
168 
169   /* Procedure to delete the resource availability */
170 
171 /*#
172  * Delete Resource Availability API
173  * This procedure allows the user to delete resource availability record.
174  * By default, all resource are availabile and if we delete a availability record then, that resource is avilable.
175  * @param p_api_version API version
176  * @param p_init_msg_list Initialization of the message list
177  * @param p_commit Commit
178  * @param p_availability_id Availability Identifier
179  * @param p_object_version_num The object version number of the resource avilability derives from the jtf_rs_res_availability table.
180  * @param x_return_status Output parameter for return status
181  * @param x_msg_count Output parameter for number of user messages from this procedure
182  * @param x_msg_data Output parameter containing last user message from this procedure
183  * @rep:scope internal
184  * @rep:lifecycle active
185  * @rep:displayname Delete Resource Availability API
186 */
187   PROCEDURE  delete_res_availability
188   (P_API_VERSION          IN     NUMBER,
189    P_INIT_MSG_LIST        IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
190    P_COMMIT               IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
191    P_AVAILABILITY_ID      IN     JTF_RS_RES_AVAILABILITY.AVAILABILITY_ID%TYPE,
192    P_OBJECT_VERSION_NUM   IN     JTF_RS_RES_AVAILABILITY.OBJECT_VERSION_NUMBER%TYPE,
193    X_RETURN_STATUS        OUT NOCOPY    VARCHAR2,
194    X_MSG_COUNT            OUT NOCOPY    NUMBER,
195    X_MSG_DATA             OUT NOCOPY    VARCHAR2
196   );
197 
198 END JTF_RS_RES_AVAILABILITY_PUB;