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_TABLE_ATTRIBUTES_PUB

Source


1 PACKAGE jtf_rs_table_attributes_pub AUTHID CURRENT_USER AS
2  /* $Header: jtfrspws.pls 120.0 2005/05/11 08:21:28 appldev ship $ */
3 /*#
4  * Package containing procedures to maintain resource attributes for
5  * giving access rights to non-admin user
6  * @rep:scope private
7  * @rep:product JTF
8  * @rep:displayname Resource Attributes Package
9  * @rep:category BUSINESS_ENTITY JTF_RS_RESOURCE
10  */
11 
12   /*****************************************************************************************
13    This is a public API that user API will invoke.
14    It provides procedures for managing seed data of jtf_rs_table_attributes_b/tl tables
15    create, update and delete rows
16    Its main procedures are as following:
17    Create table attribute
18    Update  table attribute
19    Delete  table attribute
20    Calls to these procedures will call procedures of jtf_rs_table_attributes_pvt
21    to do inserts, updates and deletes into tables.
22    ******************************************************************************************/
23 
24 
25   /* Procedure to create the table attribute
26 	based on input values passed by calling routines. */
27 
28 /*#
29  * Procedure to create resource attribute
30  * @param P_API_VERSION API version number
31  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
32  * @param P_COMMIT Flag to commit at the end of the procedure
33  * @param P_ATTRIBUTE_NAME Attribute Name for the resource attribute
34  * @param P_ATTRIBUTE_ACCESS_LEVEL Attribute access level (No Update/Full Update/Update With Approval/Update With Notification)
35  * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
36  * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
37  * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
38  * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
39  * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
40  * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
41  * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
42  * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
43  * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
44  * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
45  * @param P_ATTRIBUTE11	Descriptive flexfield Attribute 11
46  * @param P_ATTRIBUTE12	Descriptive flexfield Attribute 12
47  * @param P_ATTRIBUTE13	Descriptive flexfield Attribute 13
48  * @param P_ATTRIBUTE14	Descriptive flexfield Attribute 14
49  * @param P_ATTRIBUTE15	Descriptive flexfield Attribute 14
50  * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
51  * @param P_USER_ATTRIBUTE_NAME Name of the attribute for display to user
52  * @param X_RETURN_STATUS Output parameter for return status
53  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
54  * @param X_MSG_DATA Output parameter containing last user message from this procedure
55  * @param X_ATTRIBUTE_ID Output parameter containing internal unique id of the created resource attribute
56  * @rep:scope private
57  * @rep:displayname Create Resource Attribute
58  */
59   PROCEDURE  create_table_attribute
60   (P_API_VERSION          IN   NUMBER,
61    P_INIT_MSG_LIST        IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
62    P_COMMIT               IN   VARCHAR2   DEFAULT  FND_API.G_FALSE,
63    P_ATTRIBUTE_NAME       IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
64    P_ATTRIBUTE_ACCESS_LEVEL IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
65    P_ATTRIBUTE1		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE   DEFAULT  NULL,
66    P_ATTRIBUTE2		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE   DEFAULT  NULL,
67    P_ATTRIBUTE3		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE   DEFAULT  NULL,
68    P_ATTRIBUTE4		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE   DEFAULT  NULL,
69    P_ATTRIBUTE5		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE   DEFAULT  NULL,
70    P_ATTRIBUTE6		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE   DEFAULT  NULL,
71    P_ATTRIBUTE7		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE   DEFAULT  NULL,
72    P_ATTRIBUTE8		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE   DEFAULT  NULL,
73    P_ATTRIBUTE9		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE   DEFAULT  NULL,
74    P_ATTRIBUTE10	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE   DEFAULT  NULL,
75    P_ATTRIBUTE11	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE   DEFAULT  NULL,
76    P_ATTRIBUTE12	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE   DEFAULT  NULL,
77    P_ATTRIBUTE13	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE   DEFAULT  NULL,
78    P_ATTRIBUTE14	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE   DEFAULT  NULL,
79    P_ATTRIBUTE15	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE   DEFAULT  NULL,
80    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE   DEFAULT  NULL,
81    P_USER_ATTRIBUTE_NAME  IN   JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
82    X_RETURN_STATUS        OUT NOCOPY  VARCHAR2,
83    X_MSG_COUNT            OUT NOCOPY  NUMBER,
84    X_MSG_DATA             OUT NOCOPY  VARCHAR2,
85    X_ATTRIBUTE_ID       OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE
86   );
87 
88 
89   /* Procedure to update table attribute
90 	based on input values passed by calling routines. */
91 
92 /*#
93  * Procedure to update resource attribute
94  * @param P_API_VERSION API version number
95  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
96  * @param P_COMMIT Flag to commit at the end of the procedure
97  * @param P_ATTRIBUTE_ID Internal unique id for the resource attribute
98  * @param P_ATTRIBUTE_NAME Attribute Name for the resource attribute
99  * @param P_ATTRIBUTE_ACCESS_LEVEL Attribute access level (No Update/Full Update/Update With Approval/Update With Notification)
100  * @param P_OBJECT_VERSION_NUM Object version number for the record to update
101  * @param P_ATTRIBUTE1 Descriptive flexfield Attribute 1
102  * @param P_ATTRIBUTE2 Descriptive flexfield Attribute 2
103  * @param P_ATTRIBUTE3 Descriptive flexfield Attribute 3
104  * @param P_ATTRIBUTE4 Descriptive flexfield Attribute 4
105  * @param P_ATTRIBUTE5 Descriptive flexfield Attribute 5
106  * @param P_ATTRIBUTE6 Descriptive flexfield Attribute 6
107  * @param P_ATTRIBUTE7 Descriptive flexfield Attribute 7
108  * @param P_ATTRIBUTE8 Descriptive flexfield Attribute 8
109  * @param P_ATTRIBUTE9 Descriptive flexfield Attribute 9
110  * @param P_ATTRIBUTE10 Descriptive flexfield Attribute 10
111  * @param P_ATTRIBUTE11	Descriptive flexfield Attribute 11
112  * @param P_ATTRIBUTE12	Descriptive flexfield Attribute 12
113  * @param P_ATTRIBUTE13	Descriptive flexfield Attribute 13
114  * @param P_ATTRIBUTE14	Descriptive flexfield Attribute 14
115  * @param P_ATTRIBUTE15	Descriptive flexfield Attribute 14
116  * @param P_ATTRIBUTE_CATEGORY Descriptive flexfield attribute category
117  * @param P_USER_ATTRIBUTE_NAME Name of the attribute for display to user
118  * @param X_RETURN_STATUS Output parameter for return status
119  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
120  * @param X_MSG_DATA Output parameter containing last user message from this procedure
121  * @rep:scope private
122  * @rep:displayname Update Resource Attribute
123  */
124   PROCEDURE  update_table_attribute
125   (P_API_VERSION         IN     NUMBER,
126    P_INIT_MSG_LIST       IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
127    P_COMMIT              IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
128    P_ATTRIBUTE_ID         IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
129    P_ATTRIBUTE_NAME       IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT  FND_API.G_MISS_CHAR,
130    P_ATTRIBUTE_ACCESS_LEVEL IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT  FND_API.G_MISS_CHAR,
131    P_USER_ATTRIBUTE_NAME  IN   JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT  FND_API.G_MISS_CHAR,
132    P_OBJECT_VERSION_NUM  IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
133    P_ATTRIBUTE1		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
134    P_ATTRIBUTE2		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
135    P_ATTRIBUTE3		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
136    P_ATTRIBUTE4		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
137    P_ATTRIBUTE5		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
138    P_ATTRIBUTE6		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
139    P_ATTRIBUTE7		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
140    P_ATTRIBUTE8		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
141    P_ATTRIBUTE9		  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE  DEFAULT  FND_API.G_MISS_CHAR,
142    P_ATTRIBUTE10	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT  FND_API.G_MISS_CHAR,
143    P_ATTRIBUTE11	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT  FND_API.G_MISS_CHAR,
144    P_ATTRIBUTE12	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT  FND_API.G_MISS_CHAR,
145    P_ATTRIBUTE13	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT  FND_API.G_MISS_CHAR,
146    P_ATTRIBUTE14	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT  FND_API.G_MISS_CHAR,
147    P_ATTRIBUTE15	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT  FND_API.G_MISS_CHAR,
148    P_ATTRIBUTE_CATEGORY	  IN   JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT  FND_API.G_MISS_CHAR,
149    X_RETURN_STATUS       OUT NOCOPY    VARCHAR2,
150    X_MSG_COUNT           OUT NOCOPY    NUMBER,
151    X_MSG_DATA            OUT NOCOPY    VARCHAR2
152   );
153 
154 
155   /* Procedure to delete the table attribute */
156 
157 /*#
158  * Procedure to delete resource attribute
159  * @param P_API_VERSION API version number
160  * @param P_INIT_MSG_LIST Flag to start with clearing messages from database
161  * @param P_COMMIT Flag to commit at the end of the procedure
162  * @param P_ATTRIBUTE_ID Internal unique id for the resource attribute
163  * @param P_OBJECT_VERSION_NUM Object version number for the record to update
164  * @param X_RETURN_STATUS Output parameter for return status
165  * @param X_MSG_COUNT Output parameter for number of user messages from this procedure
166  * @param X_MSG_DATA Output parameter containing last user message from this procedure
167  * @rep:scope private
168  * @rep:displayname Delete Resource Attribute
169  */
170   PROCEDURE  delete_table_attribute
171   (P_API_VERSION          IN     NUMBER,
172    P_INIT_MSG_LIST        IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
173    P_COMMIT               IN     VARCHAR2   DEFAULT  FND_API.G_FALSE,
174    P_ATTRIBUTE_ID         IN     JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
175    P_OBJECT_VERSION_NUM   IN     JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
176    X_RETURN_STATUS        OUT NOCOPY    VARCHAR2,
177    X_MSG_COUNT            OUT NOCOPY    NUMBER,
178    X_MSG_DATA             OUT NOCOPY    VARCHAR2
179   );
180 
181 END jtf_rs_table_attributes_pub;