DBA Data[Home] [Help]

APPS.JTF_RS_TABLE_ATTRIBUTES_PUB dependencies on JTF_RS_TABLE_ATTRIBUTES_B

Line 23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,

19: PROCEDURE create_table_attribute
20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,

Line 24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,

20: (P_API_VERSION IN NUMBER,
21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,

Line 25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,

21: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,

Line 26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,

22: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,

Line 27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,

23: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,

Line 28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,

24: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,

Line 29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,

25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT NULL,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,

Line 30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,

26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT NULL,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,

Line 31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,

27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT NULL,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,

Line 32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,

28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT NULL,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,

Line 33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,

29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT NULL,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,

Line 34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,

30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT NULL,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,

Line 35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,

31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT NULL,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,

Line 36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,

32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT NULL,
33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

Line 37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,

33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT NULL,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,

Line 38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,

34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT NULL,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,

35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT NULL,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,

36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT NULL,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT NULL,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT NULL,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT NULL,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT NULL,
41: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 45: X_ATTRIBUTE_ID OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE

41: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
42: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
43: X_MSG_COUNT OUT NOCOPY NUMBER,
44: X_MSG_DATA OUT NOCOPY VARCHAR2,
45: X_ATTRIBUTE_ID OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE
46: )IS
47: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TABLE_ATTRIBUTE';
48: l_api_version CONSTANT NUMBER :=1.0;
49: l_bind_data_id number;

Line 51: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;

47: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_TABLE_ATTRIBUTE';
48: l_api_version CONSTANT NUMBER :=1.0;
49: l_bind_data_id number;
50:
51: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
52: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
53: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
54: l_object_version_number number;
55:

Line 52: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;

48: l_api_version CONSTANT NUMBER :=1.0;
49: l_bind_data_id number;
50:
51: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
52: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
53: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
54: l_object_version_number number;
55:
56: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE;

Line 56: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE;

52: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
53: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
54: l_object_version_number number;
55:
56: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE;
57:
58: l_return_code VARCHAR2(100);
59: l_count NUMBER;
60: l_data VARCHAR2(200);

Line 158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,

154: PROCEDURE update_table_attribute
155: (P_API_VERSION IN NUMBER,
156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,

Line 159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,

155: (P_API_VERSION IN NUMBER,
156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,

156: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
157: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,

158: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,

159: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,

160: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE DEFAULT FND_API.G_MISS_CHAR,
161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,

161: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE DEFAULT FND_API.G_MISS_CHAR,
162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,

162: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,

163: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE DEFAULT FND_API.G_MISS_CHAR,
164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,

164: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE DEFAULT FND_API.G_MISS_CHAR,
165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,

165: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE DEFAULT FND_API.G_MISS_CHAR,
166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,

166: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE DEFAULT FND_API.G_MISS_CHAR,
167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,

167: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE DEFAULT FND_API.G_MISS_CHAR,
168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,

168: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE DEFAULT FND_API.G_MISS_CHAR,
169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,

169: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE DEFAULT FND_API.G_MISS_CHAR,
170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,

170: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE DEFAULT FND_API.G_MISS_CHAR,
171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

Line 175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,

171: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE DEFAULT FND_API.G_MISS_CHAR,
172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,

172: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE DEFAULT FND_API.G_MISS_CHAR,
173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,

173: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE DEFAULT FND_API.G_MISS_CHAR,
174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,
181: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,

174: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE DEFAULT FND_API.G_MISS_CHAR,
175: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE DEFAULT FND_API.G_MISS_CHAR,
176: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE DEFAULT FND_API.G_MISS_CHAR,
177: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE DEFAULT FND_API.G_MISS_CHAR,
178: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE DEFAULT FND_API.G_MISS_CHAR,
179: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
180: X_MSG_COUNT OUT NOCOPY NUMBER,
181: X_MSG_DATA OUT NOCOPY VARCHAR2
182: )IS

Line 191: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;

187: l_return_code VARCHAR2(100);
188: l_count NUMBER;
189: l_data VARCHAR2(200);
190:
191: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
192: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
193: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
194: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
195:

Line 192: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;

188: l_count NUMBER;
189: l_data VARCHAR2(200);
190:
191: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
192: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
193: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
194: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
195:
196: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

Line 193: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;

189: l_data VARCHAR2(200);
190:
191: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
192: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
193: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
194: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
195:
196: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
197:

Line 196: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

192: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
193: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
194: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
195:
196: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
197:
198: l_return_status VARCHAR2(200);
199: l_msg_count NUMBER;
200: l_msg_data VARCHAR2(200);

Line 293: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,

289: PROCEDURE delete_table_attribute
290: (P_API_VERSION IN NUMBER,
291: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
293: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
294: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
295: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
296: X_MSG_COUNT OUT NOCOPY NUMBER,
297: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 294: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,

290: (P_API_VERSION IN NUMBER,
291: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
292: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
293: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
294: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
295: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
296: X_MSG_COUNT OUT NOCOPY NUMBER,
297: X_MSG_DATA OUT NOCOPY VARCHAR2
298: )IS

Line 301: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;

297: X_MSG_DATA OUT NOCOPY VARCHAR2
298: )IS
299:
300:
301: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
302:
303: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TABLE_ATTRIBUTE';
304: l_api_version CONSTANT NUMBER :=1.0;
305: l_bind_data_id number;