APPS.JTF_MENU_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package jtf_menu_pub_w as
2: /* $Header: jtfmenws.pls 120.2 2005/10/25 05:23:56 psanyal ship $ */
3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p3(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.menu_table, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300

Line 9: , a6 JTF_VARCHAR2_TABLE_100

5: , a2 JTF_VARCHAR2_TABLE_300
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100

Line 10: , a7 JTF_VARCHAR2_TABLE_100

6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100

Line 12: , a9 JTF_VARCHAR2_TABLE_100

8: , a5 JTF_VARCHAR2_TABLE_300
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100

Line 13: , a10 JTF_VARCHAR2_TABLE_100

9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE

Line 14: , a11 JTF_VARCHAR2_TABLE_100

10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_300
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE

Line 16: , a13 JTF_VARCHAR2_TABLE_100

12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_300
22: );
23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 20: , a17 JTF_VARCHAR2_TABLE_100

16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_DATE_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_300
22: );
23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_300
22: );
23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
25: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

23: procedure rosetta_table_copy_out_p3(t jtf_menu_pub.menu_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
24: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
25: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

25: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

26: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

28: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

29: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

30: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

32: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
34: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
39: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
40: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 39: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

35: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
39: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
40: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
41: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
42: );
43:

Line 40: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

36: , a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
37: , a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
38: , a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
39: , a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
40: , a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
41: , a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
42: );
43:
44: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.number_table, a0 JTF_NUMBER_TABLE);

Line 48: , a1 JTF_VARCHAR2_TABLE_100

44: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.number_table, a0 JTF_NUMBER_TABLE);
45: procedure rosetta_table_copy_out_p4(t jtf_menu_pub.number_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE);
46:
47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100
49: );
50: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: );

Line 51: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

47: procedure rosetta_table_copy_in_p5(t OUT NOCOPY /* file.sql.39 change */ jtf_menu_pub.responsibility_table, a0 JTF_NUMBER_TABLE
48: , a1 JTF_VARCHAR2_TABLE_100
49: );
50: procedure rosetta_table_copy_out_p5(t jtf_menu_pub.responsibility_table, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
51: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
52: );
53:
54: procedure get_excl_entire_menu_tree_tl(p_lang VARCHAR2
55: , p_respid NUMBER

Line 59: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

55: , p_respid NUMBER
56: , p_appid NUMBER
57: , p_max_depth NUMBER
58: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
59: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
60: , p5_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
61: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p5_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 65: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

61: , p5_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
62: , p5_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p5_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
64: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
65: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

64: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
65: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

66: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

67: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
68: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

69: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

70: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

71: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
72: , p6_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
79: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

73: , p6_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
74: , p6_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
75: , p6_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
79: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
80: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 80: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

76: , p6_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
79: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
80: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

77: , p6_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
78: , p6_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
79: , p6_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
80: , p6_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

81: , p6_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
82: , p6_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
83: , p_kids_menu_ids OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

84: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
85: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

86: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

87: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
88: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

89: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

90: , p8_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

91: , p8_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
92: , p8_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
99: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

93: , p8_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
94: , p8_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
95: , p8_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
99: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
100: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
101: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 100: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

96: , p8_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
99: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
100: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
101: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
102: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
103: );
104: procedure get_excluded_root_menu_tl(p_lang VARCHAR2

Line 101: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

97: , p8_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
98: , p8_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
99: , p8_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
100: , p8_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
101: , p8_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
102: , p8_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
103: );
104: procedure get_excluded_root_menu_tl(p_lang VARCHAR2
105: , p_respid NUMBER

Line 108: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

104: procedure get_excluded_root_menu_tl(p_lang VARCHAR2
105: , p_respid NUMBER
106: , p_appid NUMBER
107: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
108: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
109: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
110: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 114: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

110: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
111: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
112: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
115: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

113: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
115: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

115: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

116: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
117: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

118: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

119: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

120: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
121: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
128: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

122: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
123: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
124: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
128: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
129: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
130: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 129: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

125: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
128: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
129: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
130: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
131: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
132: );
133: procedure get_root_menu_tl(p_lang VARCHAR2

Line 130: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

126: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
128: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
129: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
130: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
131: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
132: );
133: procedure get_root_menu_tl(p_lang VARCHAR2
134: , p_respid NUMBER

Line 137: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

133: procedure get_root_menu_tl(p_lang VARCHAR2
134: , p_respid NUMBER
135: , p_appid NUMBER
136: , p3_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
137: , p3_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
138: , p4_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
139: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 143: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

139: , p4_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
140: , p4_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
141: , p4_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
142: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

142: , p5_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p5_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
144: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

144: , p5_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

145: , p5_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
146: , p5_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

147: , p5_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

148: , p5_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

149: , p5_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p5_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
157: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

151: , p5_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p5_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p5_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
157: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
158: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
159: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 158: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

154: , p5_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
157: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
158: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
159: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
160: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
161: );
162: procedure get_root_menu(p_respid NUMBER

Line 159: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

155: , p5_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
156: , p5_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
157: , p5_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
158: , p5_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
159: , p5_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
160: , p5_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
161: );
162: procedure get_root_menu(p_respid NUMBER
163: , p_appid NUMBER

Line 165: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

161: );
162: procedure get_root_menu(p_respid NUMBER
163: , p_appid NUMBER
164: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
165: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
166: , p3_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
167: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169: , p3_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 171: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

167: , p3_a1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
168: , p3_a2 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
169: , p3_a3 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
170: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
171: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
172: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

170: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
171: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
172: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

172: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

173: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
174: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

175: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

176: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

177: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
178: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

179: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
180: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
181: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
186: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 186: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

182: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
186: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
188: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
189: );
190: procedure get_excluded_menu_entries_tl(p_lang VARCHAR2

Line 187: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

183: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
184: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
185: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
186: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
187: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
188: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
189: );
190: procedure get_excluded_menu_entries_tl(p_lang VARCHAR2
191: , p_menu_id NUMBER

Line 195: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

191: , p_menu_id NUMBER
192: , p_respid NUMBER
193: , p_appid NUMBER
194: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
195: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
196: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

194: , p4_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
195: , p4_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
196: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

196: , p4_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

197: , p4_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
198: , p4_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

199: , p4_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

200: , p4_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

201: , p4_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
202: , p4_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
209: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

203: , p4_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
204: , p4_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
205: , p4_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
209: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
210: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 210: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

206: , p4_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
209: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
210: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
212: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
213: );
214: procedure get_menu_entries_tl(p_lang VARCHAR2

Line 211: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

207: , p4_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
208: , p4_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
209: , p4_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
210: , p4_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
211: , p4_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
212: , p4_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
213: );
214: procedure get_menu_entries_tl(p_lang VARCHAR2
215: , p_menu_id NUMBER

Line 217: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

213: );
214: procedure get_menu_entries_tl(p_lang VARCHAR2
215: , p_menu_id NUMBER
216: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
217: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

216: , p2_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
217: , p2_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
218: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

218: , p2_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

219: , p2_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
220: , p2_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

221: , p2_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

222: , p2_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

223: , p2_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
224: , p2_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

225: , p2_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
226: , p2_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
227: , p2_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
232: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
233: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 232: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

228: , p2_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
232: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
233: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
234: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
235: );
236: procedure get_menu_entries(p_menu_id NUMBER

Line 233: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

229: , p2_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
230: , p2_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
231: , p2_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
232: , p2_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
233: , p2_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
234: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
235: );
236: procedure get_menu_entries(p_menu_id NUMBER
237: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

234: , p2_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
235: );
236: procedure get_menu_entries(p_menu_id NUMBER
237: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
239: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

237: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
238: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
239: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

239: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

240: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
241: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

242: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

243: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

244: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
245: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

246: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
247: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
248: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
253: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
254: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 253: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

249: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
253: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
254: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
255: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
256: );
257: procedure get_func_entries(p_menu_id NUMBER

Line 254: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

250: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
251: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
252: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
253: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
254: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
255: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
256: );
257: procedure get_func_entries(p_menu_id NUMBER
258: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

255: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
256: );
257: procedure get_func_entries(p_menu_id NUMBER
258: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

258: , p1_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
259: , p1_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
260: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

260: , p1_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

261: , p1_a3 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
262: , p1_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

263: , p1_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

264: , p1_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

265: , p1_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
266: , p1_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
273: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE

Line 271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

267: , p1_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
268: , p1_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
269: , p1_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
273: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
274: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 274: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

270: , p1_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
273: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
274: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
277: );
278: end jtf_menu_pub_w;

Line 275: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

271: , p1_a13 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
272: , p1_a14 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
273: , p1_a15 OUT NOCOPY /* file.sql.39 change */ JTF_DATE_TABLE
274: , p1_a16 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
275: , p1_a17 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
276: , p1_a18 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
277: );
278: end jtf_menu_pub_w;