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_PERZ_PROFILE_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package jtf_perz_profile_pub_w as
2: /* $Header: jtfzwpfs.pls 120.2 2005/11/02 23:48:15 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: jtfzwpfs.pls 120.2 2005/11/02 23:48:15 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_attrib_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

7: , a4 JTF_VARCHAR2_TABLE_100
8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
15:

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

8: );
9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE

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

9: procedure rosetta_table_copy_out_p1(t jtf_perz_profile_pub.profile_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
10: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
11: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
12: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100

Line 17: , a1 JTF_VARCHAR2_TABLE_100

13: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
14: );
15:
16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100

Line 18: , a2 JTF_VARCHAR2_TABLE_100

14: );
15:
16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100

Line 20: , a4 JTF_VARCHAR2_TABLE_100

16: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_profile_pub.profile_out_tbl_type, a0 JTF_NUMBER_TABLE
17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );

Line 21: , a5 JTF_VARCHAR2_TABLE_100

17: , a1 JTF_VARCHAR2_TABLE_100
18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 22: , a6 JTF_VARCHAR2_TABLE_100

18: , a2 JTF_VARCHAR2_TABLE_100
19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 23: , a7 JTF_VARCHAR2_TABLE_100

19: , a3 JTF_VARCHAR2_TABLE_300
20: , a4 JTF_VARCHAR2_TABLE_100
21: , a5 JTF_VARCHAR2_TABLE_100
22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

22: , a6 JTF_VARCHAR2_TABLE_100
23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

23: , a7 JTF_VARCHAR2_TABLE_100
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

25: procedure rosetta_table_copy_out_p4(t jtf_perz_profile_pub.profile_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: );

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

26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: );
34:

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

27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: );
34:
35: procedure create_profile(p_api_version_number NUMBER

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

28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
30: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
31: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
32: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
33: );
34:
35: procedure create_profile(p_api_version_number NUMBER
36: , p_init_msg_list VARCHAR2

Line 44: , p7_a2 JTF_VARCHAR2_TABLE_100

40: , p_profile_type VARCHAR2
41: , p_profile_desc VARCHAR2
42: , p7_a0 JTF_NUMBER_TABLE
43: , p7_a1 JTF_NUMBER_TABLE
44: , p7_a2 JTF_VARCHAR2_TABLE_100
45: , p7_a3 JTF_VARCHAR2_TABLE_100
46: , p7_a4 JTF_VARCHAR2_TABLE_100
47: , x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 45: , p7_a3 JTF_VARCHAR2_TABLE_100

41: , p_profile_desc VARCHAR2
42: , p7_a0 JTF_NUMBER_TABLE
43: , p7_a1 JTF_NUMBER_TABLE
44: , p7_a2 JTF_VARCHAR2_TABLE_100
45: , p7_a3 JTF_VARCHAR2_TABLE_100
46: , p7_a4 JTF_VARCHAR2_TABLE_100
47: , x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
49: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 46: , p7_a4 JTF_VARCHAR2_TABLE_100

42: , p7_a0 JTF_NUMBER_TABLE
43: , p7_a1 JTF_NUMBER_TABLE
44: , p7_a2 JTF_VARCHAR2_TABLE_100
45: , p7_a3 JTF_VARCHAR2_TABLE_100
46: , p7_a4 JTF_VARCHAR2_TABLE_100
47: , x_profile_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
48: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
49: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 60: , p5_a2 JTF_VARCHAR2_TABLE_100

56: , p_profile_name VARCHAR2
57: , p_profile_type VARCHAR2
58: , p5_a0 JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
63: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
64: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 61: , p5_a3 JTF_VARCHAR2_TABLE_100

57: , p_profile_type VARCHAR2
58: , p5_a0 JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
63: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
64: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
65: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 62: , p5_a4 JTF_VARCHAR2_TABLE_100

58: , p5_a0 JTF_NUMBER_TABLE
59: , p5_a1 JTF_NUMBER_TABLE
60: , p5_a2 JTF_VARCHAR2_TABLE_100
61: , p5_a3 JTF_VARCHAR2_TABLE_100
62: , p5_a4 JTF_VARCHAR2_TABLE_100
63: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
64: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
65: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

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

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

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

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

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

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

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

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

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

65: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
66: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
68: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
70: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
73: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

66: , p6_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
67: , p6_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
68: , p6_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
69: , p6_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
70: , p6_a7 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
71: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
72: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
73: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
74: );

Line 85: , p8_a2 JTF_VARCHAR2_TABLE_100

81: , p_profile_desc VARCHAR2
82: , p_active_flag VARCHAR2
83: , p8_a0 JTF_NUMBER_TABLE
84: , p8_a1 JTF_NUMBER_TABLE
85: , p8_a2 JTF_VARCHAR2_TABLE_100
86: , p8_a3 JTF_VARCHAR2_TABLE_100
87: , p8_a4 JTF_VARCHAR2_TABLE_100
88: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 86: , p8_a3 JTF_VARCHAR2_TABLE_100

82: , p_active_flag VARCHAR2
83: , p8_a0 JTF_NUMBER_TABLE
84: , p8_a1 JTF_NUMBER_TABLE
85: , p8_a2 JTF_VARCHAR2_TABLE_100
86: , p8_a3 JTF_VARCHAR2_TABLE_100
87: , p8_a4 JTF_VARCHAR2_TABLE_100
88: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 87: , p8_a4 JTF_VARCHAR2_TABLE_100

83: , p8_a0 JTF_NUMBER_TABLE
84: , p8_a1 JTF_NUMBER_TABLE
85: , p8_a2 JTF_VARCHAR2_TABLE_100
86: , p8_a3 JTF_VARCHAR2_TABLE_100
87: , p8_a4 JTF_VARCHAR2_TABLE_100
88: , x_profile_id OUT NOCOPY /* file.sql.39 change */ NUMBER
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
91: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2