1 PACKAGE jtf_rs_table_attributes_pvt AUTHID CURRENT_USER AS
2 /* $Header: jtfrsvws.pls 120.0 2005/05/11 08:23:21 appldev ship $ */
3
4 /*****************************************************************************************
5 This is a private API that public API will invoke.
6 It provides procedures for managing seed data of jtf_rs_table_attributes_b/tl tables
7 create, update and delete rows
8 Its main procedures are as following:
9 Create table attribute
10 Update table attribute
11 Delete table attribute
12 Calls to these procedures will invoke procedures from jtf_rs_table_attributes_pub
13 to do business validations and to do actual inserts, updates and deletes into tables.
14 ******************************************************************************************/
15
16
17 /* Procedure to create the table attribute
18 based on input values passed by calling routines. */
19
20 PROCEDURE create_table_attribute
21 (P_API_VERSION IN NUMBER,
22 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
24 P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
25 P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
26 P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
27 P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
28 P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
29 P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
30 P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
31 P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
32 P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
33 P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
34 P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
35 P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
36 P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
37 P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
38 P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
39 P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
40 P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
41 P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
42 P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
43 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
44 X_MSG_COUNT OUT NOCOPY NUMBER,
45 X_MSG_DATA OUT NOCOPY VARCHAR2,
46 X_ATTRIBUTE_ID OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE
47 );
48
49
50 /* Procedure to update table attribute
51 based on input values passed by calling routines. */
52
53 PROCEDURE update_table_attribute
54 (P_API_VERSION IN NUMBER,
55 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
56 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
57 P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
58 P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
59 P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
60 P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
61 P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
62 P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
63 P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
64 P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
65 P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
66 P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
67 P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
68 P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
69 P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
70 P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
71 P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
72 P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
73 P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
74 P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
75 P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
76 P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
77 P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
78 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
79 X_MSG_COUNT OUT NOCOPY NUMBER,
80 X_MSG_DATA OUT NOCOPY VARCHAR2
81 );
82
83
84 /* Procedure to delete the table attribute */
85
86 PROCEDURE delete_table_attribute
87 (P_API_VERSION IN NUMBER,
88 P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
89 P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
90 P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
91 P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
92 X_RETURN_STATUS OUT NOCOPY VARCHAR2,
93 X_MSG_COUNT OUT NOCOPY NUMBER,
94 X_MSG_DATA OUT NOCOPY VARCHAR2
95 );
96
97 END jtf_rs_table_attributes_pvt;