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.

APPS.JTF_RS_TABLE_ATTRIBUTES_PVT 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,
22: P_COMMIT IN VARCHAR2,
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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,

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,
22: P_COMMIT IN VARCHAR2,
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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,

Line 25: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,

21: P_INIT_MSG_LIST IN VARCHAR2,
22: P_COMMIT IN VARCHAR2,
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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,

Line 26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,

22: P_COMMIT IN VARCHAR2,
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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,

Line 27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,

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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,

Line 28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%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,
26: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
27: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
28: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,

Line 29: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,

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

Line 30: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,

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

Line 31: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,

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

Line 32: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,

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

Line 33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,

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

Line 34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,

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

Line 35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,

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

Line 36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,

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

Line 37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,

33: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
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,

34: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
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,

35: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%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,

Line 40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,

36: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
37: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
38: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
39: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
40: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%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,

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_go_ahead VARCHAR2(5);
59: l_return_code VARCHAR2(100);
60: l_count NUMBER;

Line 69: CURSOR attribute_dup_cur(ll_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE)

65: l_msg_data VARCHAR2(200);
66: l_rowid VARCHAR2(200);
67:
68:
69: CURSOR attribute_dup_cur(ll_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE)
70: IS
71: SELECT attribute_access_level,
72: attribute_id
73: FROM jtf_rs_table_attributes_b

Line 73: FROM jtf_rs_table_attributes_b

69: CURSOR attribute_dup_cur(ll_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE)
70: IS
71: SELECT attribute_access_level,
72: attribute_id
73: FROM jtf_rs_table_attributes_b
74: WHERE attribute_name = ll_attribute_name;
75:
76: attribute_dup_rec attribute_dup_cur%rowtype;
77:

Line 210: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,

206: PROCEDURE update_table_attribute
207: (P_API_VERSION IN NUMBER,
208: P_INIT_MSG_LIST IN VARCHAR2,
209: P_COMMIT IN VARCHAR2,
210: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,

Line 211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,

207: (P_API_VERSION IN NUMBER,
208: P_INIT_MSG_LIST IN VARCHAR2,
209: P_COMMIT IN VARCHAR2,
210: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,

Line 212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,

208: P_INIT_MSG_LIST IN VARCHAR2,
209: P_COMMIT IN VARCHAR2,
210: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,

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

210: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,

Line 215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,

211: P_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE,
212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,

Line 216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,

212: P_ATTRIBUTE_ACCESS_LEVEL IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE,
213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,

Line 217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,

213: P_USER_ATTRIBUTE_NAME IN JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE,
214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,

Line 218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,

214: P_OBJECT_VERSION_NUM IN OUT NOCOPY JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,

Line 219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,

215: P_ATTRIBUTE1 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE,
216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,

Line 220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,

216: P_ATTRIBUTE2 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE,
217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,

Line 221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,

217: P_ATTRIBUTE3 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE,
218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,

Line 222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,

218: P_ATTRIBUTE4 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE,
219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,

Line 223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,

219: P_ATTRIBUTE5 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE,
220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,

Line 224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,

220: P_ATTRIBUTE6 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE,
221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,

Line 225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,

221: P_ATTRIBUTE7 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE,
222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,

Line 226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,

222: P_ATTRIBUTE8 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE,
223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,

Line 227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,

223: P_ATTRIBUTE9 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE,
224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
231: X_RETURN_STATUS OUT NOCOPY VARCHAR2,

Line 228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,

224: P_ATTRIBUTE10 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE,
225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
231: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
232: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,

225: P_ATTRIBUTE11 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE,
226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
231: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
232: X_MSG_COUNT OUT NOCOPY NUMBER,
233: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,

226: P_ATTRIBUTE12 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE,
227: P_ATTRIBUTE13 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE,
228: P_ATTRIBUTE14 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE,
229: P_ATTRIBUTE15 IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE,
230: P_ATTRIBUTE_CATEGORY IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE,
231: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
232: X_MSG_COUNT OUT NOCOPY NUMBER,
233: X_MSG_DATA OUT NOCOPY VARCHAR2
234: )IS

Line 244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;

240: l_count NUMBER;
241: l_data VARCHAR2(200);
242:
243:
244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;
245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;

Line 245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;

241: l_data VARCHAR2(200);
242:
243:
244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;
245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;

Line 246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;

242:
243:
244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;
245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;

Line 247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;

243:
244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;
245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;

Line 248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;

244: L_ATTRIBUTE1 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE1%TYPE;
245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;

Line 249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;

245: L_ATTRIBUTE2 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE2%TYPE;
246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;

Line 250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;

246: L_ATTRIBUTE3 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE3%TYPE;
247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;

Line 251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;

247: L_ATTRIBUTE4 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE4%TYPE;
248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;

Line 252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;

248: L_ATTRIBUTE5 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE5%TYPE;
249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;

Line 253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;

249: L_ATTRIBUTE6 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE6%TYPE;
250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;

Line 254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;

250: L_ATTRIBUTE7 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE7%TYPE;
251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;

Line 255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;

251: L_ATTRIBUTE8 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE8%TYPE;
252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;

Line 256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;

252: L_ATTRIBUTE9 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE9%TYPE;
253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;
260:

Line 257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;

253: L_ATTRIBUTE10 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE10%TYPE;
254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;
260:
261:

Line 258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;

254: L_ATTRIBUTE11 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE11%TYPE;
255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;
260:
261:
262: CURSOR table_attribute_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)

Line 259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;

255: L_ATTRIBUTE12 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE12%TYPE;
256: L_ATTRIBUTE13 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE13%TYPE;
257: L_ATTRIBUTE14 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE14%TYPE;
258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;
260:
261:
262: CURSOR table_attribute_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)
263: IS

Line 262: CURSOR table_attribute_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)

258: L_ATTRIBUTE15 JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE15%TYPE;
259: L_ATTRIBUTE_CATEGORY JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_CATEGORY%TYPE;
260:
261:
262: CURSOR table_attribute_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)
263: IS
264: SELECT attribute_id,
265: attribute_name,
266: attribute_access_level,

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

286: WHERE attribute_id = ll_attribute_id;
287:
288: table_attribute_rec table_attribute_cur%rowtype;
289:
290: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
291: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
292: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
293: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
294:

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

287:
288: table_attribute_rec table_attribute_cur%rowtype;
289:
290: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
291: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
292: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
293: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
294:
295: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;

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

288: table_attribute_rec table_attribute_cur%rowtype;
289:
290: l_attribute_name JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_NAME%TYPE := p_attribute_name;
291: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
292: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
293: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
294:
295: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
296:

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

291: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
292: l_attribute_access_level JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ACCESS_LEVEL%TYPE := p_attribute_access_level;
293: l_user_attribute_name JTF_RS_TABLE_ATTRIBUTES_TL.USER_ATTRIBUTE_NAME%TYPE := p_user_attribute_name;
294:
295: l_object_version_number JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE := P_OBJECT_VERSION_NUM;
296:
297: l_return_status VARCHAR2(200);
298: l_msg_count NUMBER;
299: l_msg_data VARCHAR2(200);

Line 544: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,

540: PROCEDURE delete_table_attribute
541: (P_API_VERSION IN NUMBER,
542: P_INIT_MSG_LIST IN VARCHAR2,
543: P_COMMIT IN VARCHAR2,
544: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
545: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
546: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
547: X_MSG_COUNT OUT NOCOPY NUMBER,
548: X_MSG_DATA OUT NOCOPY VARCHAR2

Line 545: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,

541: (P_API_VERSION IN NUMBER,
542: P_INIT_MSG_LIST IN VARCHAR2,
543: P_COMMIT IN VARCHAR2,
544: P_ATTRIBUTE_ID IN JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE,
545: P_OBJECT_VERSION_NUM IN JTF_RS_TABLE_ATTRIBUTES_B.OBJECT_VERSION_NUMBER%TYPE,
546: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
547: X_MSG_COUNT OUT NOCOPY NUMBER,
548: X_MSG_DATA OUT NOCOPY VARCHAR2
549: )IS

Line 552: CURSOR chk_att_exist_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)

548: X_MSG_DATA OUT NOCOPY VARCHAR2
549: )IS
550:
551:
552: CURSOR chk_att_exist_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)
553: IS
554: SELECT attribute_name
555: FROM jtf_rs_table_attributes_b
556: WHERE attribute_id = ll_attribute_id;

Line 555: FROM jtf_rs_table_attributes_b

551:
552: CURSOR chk_att_exist_cur(ll_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE)
553: IS
554: SELECT attribute_name
555: FROM jtf_rs_table_attributes_b
556: WHERE attribute_id = ll_attribute_id;
557:
558: chk_att_exist_rec chk_att_exist_cur%rowtype;
559:

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

556: WHERE attribute_id = ll_attribute_id;
557:
558: chk_att_exist_rec chk_att_exist_cur%rowtype;
559:
560: l_attribute_id JTF_RS_TABLE_ATTRIBUTES_B.ATTRIBUTE_ID%TYPE := p_attribute_id;
561:
562: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TABLE_ATTRIBUTE';
563: l_api_version CONSTANT NUMBER :=1.0;
564: l_bind_data_id number;