APPS.JTF_PERZ_LF_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package jtf_perz_lf_pub_w as
2: /* $Header: jtfzwlfs.pls 120.2 2005/11/02 23:01:20 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package jtf_perz_lf_pub_w as
2: /* $Header: jtfzwlfs.pls 120.2 2005/11/02 23:01:20 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_rec_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE

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

5: , a2 JTF_VARCHAR2_TABLE_100
6: );
7: procedure rosetta_table_copy_out_p1(t jtf_perz_lf_pub.attrib_rec_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
8: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
9: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
10: );
11:
12: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_100

Line 13: , a1 JTF_VARCHAR2_TABLE_100

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

Line 14: , a2 JTF_VARCHAR2_TABLE_100

10: );
11:
12: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_100
15: , a3 JTF_VARCHAR2_TABLE_100
16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 15: , a3 JTF_VARCHAR2_TABLE_100

11:
12: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.attrib_value_tbl_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_VARCHAR2_TABLE_100
14: , a2 JTF_VARCHAR2_TABLE_100
15: , a3 JTF_VARCHAR2_TABLE_100
16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
19: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

15: , a3 JTF_VARCHAR2_TABLE_100
16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
19: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
20: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
21: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
22: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
23: );

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

16: , a4 JTF_NUMBER_TABLE
17: );
18: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
19: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
20: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
21: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
22: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
23: );
24:

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

17: );
18: procedure rosetta_table_copy_out_p4(t jtf_perz_lf_pub.attrib_value_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
19: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
20: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
21: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
22: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
23: );
24:
25: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE

Line 28: , a3 JTF_VARCHAR2_TABLE_100

24:
25: procedure rosetta_table_copy_in_p7(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_lf_pub.lf_object_out_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE

Line 31: , a6 JTF_VARCHAR2_TABLE_100

27: , a2 JTF_NUMBER_TABLE
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_VARCHAR2_TABLE_100

Line 33: , a8 JTF_VARCHAR2_TABLE_100

29: , a4 JTF_VARCHAR2_TABLE_300
30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE

Line 34: , a9 JTF_VARCHAR2_TABLE_100

30: , a5 JTF_NUMBER_TABLE
31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE
38: );

Line 35: , a10 JTF_VARCHAR2_TABLE_100

31: , a6 JTF_VARCHAR2_TABLE_100
32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE
38: );
39: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

Line 36: , a11 JTF_VARCHAR2_TABLE_100

32: , a7 JTF_NUMBER_TABLE
33: , a8 JTF_VARCHAR2_TABLE_100
34: , a9 JTF_VARCHAR2_TABLE_100
35: , a10 JTF_VARCHAR2_TABLE_100
36: , a11 JTF_VARCHAR2_TABLE_100
37: , a12 JTF_NUMBER_TABLE
38: );
39: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
40: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

38: );
39: procedure rosetta_table_copy_out_p7(t jtf_perz_lf_pub.lf_object_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
40: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
41: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
42: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
43: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
44: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

41: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
42: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
43: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
44: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

43: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
44: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

44: , a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
45: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52: );

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

45: , a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52: );
53:

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

46: , a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
47: , a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
48: , a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
49: , a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
50: , a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
51: , a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
52: );
53:
54: procedure save_lf_object(p_api_version_number NUMBER

Line 62: , p6_a2 JTF_VARCHAR2_TABLE_100

58: , p_profile_name VARCHAR2
59: , p_profile_type VARCHAR2
60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_VARCHAR2_TABLE_100
63: , p6_a3 JTF_VARCHAR2_TABLE_100
64: , p6_a4 JTF_VARCHAR2_TABLE_100
65: , p_application_id NUMBER
66: , p_parent_id NUMBER

Line 63: , p6_a3 JTF_VARCHAR2_TABLE_100

59: , p_profile_type VARCHAR2
60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_VARCHAR2_TABLE_100
63: , p6_a3 JTF_VARCHAR2_TABLE_100
64: , p6_a4 JTF_VARCHAR2_TABLE_100
65: , p_application_id NUMBER
66: , p_parent_id NUMBER
67: , p_object_type_id NUMBER

Line 64: , p6_a4 JTF_VARCHAR2_TABLE_100

60: , p6_a0 JTF_NUMBER_TABLE
61: , p6_a1 JTF_NUMBER_TABLE
62: , p6_a2 JTF_VARCHAR2_TABLE_100
63: , p6_a3 JTF_VARCHAR2_TABLE_100
64: , p6_a4 JTF_VARCHAR2_TABLE_100
65: , p_application_id NUMBER
66: , p_parent_id NUMBER
67: , p_object_type_id NUMBER
68: , p_object_type VARCHAR2

Line 74: , p15_a1 JTF_VARCHAR2_TABLE_100

70: , p_object_name VARCHAR2
71: , p_object_description VARCHAR2
72: , p_active_flag VARCHAR2
73: , p15_a0 JTF_NUMBER_TABLE
74: , p15_a1 JTF_VARCHAR2_TABLE_100
75: , p15_a2 JTF_VARCHAR2_TABLE_100
76: , p15_a3 JTF_VARCHAR2_TABLE_100
77: , p15_a4 JTF_NUMBER_TABLE
78: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 75: , p15_a2 JTF_VARCHAR2_TABLE_100

71: , p_object_description VARCHAR2
72: , p_active_flag VARCHAR2
73: , p15_a0 JTF_NUMBER_TABLE
74: , p15_a1 JTF_VARCHAR2_TABLE_100
75: , p15_a2 JTF_VARCHAR2_TABLE_100
76: , p15_a3 JTF_VARCHAR2_TABLE_100
77: , p15_a4 JTF_NUMBER_TABLE
78: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
79: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 76: , p15_a3 JTF_VARCHAR2_TABLE_100

72: , p_active_flag VARCHAR2
73: , p15_a0 JTF_NUMBER_TABLE
74: , p15_a1 JTF_VARCHAR2_TABLE_100
75: , p15_a2 JTF_VARCHAR2_TABLE_100
76: , p15_a3 JTF_VARCHAR2_TABLE_100
77: , p15_a4 JTF_NUMBER_TABLE
78: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
79: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
80: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 90: , p6_a1 JTF_VARCHAR2_TABLE_100

86: , p_object_type_id NUMBER
87: , p_object_type VARCHAR2
88: , p_object_type_desc VARCHAR2
89: , p6_a0 JTF_NUMBER_TABLE
90: , p6_a1 JTF_VARCHAR2_TABLE_100
91: , p6_a2 JTF_VARCHAR2_TABLE_100
92: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 91: , p6_a2 JTF_VARCHAR2_TABLE_100

87: , p_object_type VARCHAR2
88: , p_object_type_desc VARCHAR2
89: , p6_a0 JTF_NUMBER_TABLE
90: , p6_a1 JTF_VARCHAR2_TABLE_100
91: , p6_a2 JTF_VARCHAR2_TABLE_100
92: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
93: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
94: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
95: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 109: , p11_a1 JTF_VARCHAR2_TABLE_100

105: , p_object_name VARCHAR2
106: , p_object_type_id NUMBER
107: , p_object_type VARCHAR2
108: , p11_a0 JTF_NUMBER_TABLE
109: , p11_a1 JTF_VARCHAR2_TABLE_100
110: , p11_a2 JTF_VARCHAR2_TABLE_100
111: , p11_a3 JTF_VARCHAR2_TABLE_100
112: , p11_a4 JTF_NUMBER_TABLE
113: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 110: , p11_a2 JTF_VARCHAR2_TABLE_100

106: , p_object_type_id NUMBER
107: , p_object_type VARCHAR2
108: , p11_a0 JTF_NUMBER_TABLE
109: , p11_a1 JTF_VARCHAR2_TABLE_100
110: , p11_a2 JTF_VARCHAR2_TABLE_100
111: , p11_a3 JTF_VARCHAR2_TABLE_100
112: , p11_a4 JTF_NUMBER_TABLE
113: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
114: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 111: , p11_a3 JTF_VARCHAR2_TABLE_100

107: , p_object_type VARCHAR2
108: , p11_a0 JTF_NUMBER_TABLE
109: , p11_a1 JTF_VARCHAR2_TABLE_100
110: , p11_a2 JTF_VARCHAR2_TABLE_100
111: , p11_a3 JTF_VARCHAR2_TABLE_100
112: , p11_a4 JTF_NUMBER_TABLE
113: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
114: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
115: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

121: , p_object_type_id NUMBER
122: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
123: , x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
125: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
126: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
129: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

122: , x_object_type_id OUT NOCOPY /* file.sql.39 change */ NUMBER
123: , x_object_type_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
124: , p6_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
125: , p6_a1 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
126: , p6_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
127: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
128: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
129: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
130: );

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

140: , p_get_children_flag VARCHAR2
141: , p10_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
142: , p10_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
143: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
144: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

143: , p10_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
144: , p10_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
145: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

145: , p10_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
146: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

146: , p10_a5 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
147: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
154: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

147: , p10_a6 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
154: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

148: , p10_a7 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
149: , p10_a8 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
150: , p10_a9 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
151: , p10_a10 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
152: , p10_a11 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
153: , p10_a12 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
154: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
155: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
156: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 171: , p12_a1 JTF_VARCHAR2_TABLE_100

167: , p_active_flag VARCHAR2
168: , p_object_type_id NUMBER
169: , p_object_type VARCHAR2
170: , p12_a0 JTF_NUMBER_TABLE
171: , p12_a1 JTF_VARCHAR2_TABLE_100
172: , p12_a2 JTF_VARCHAR2_TABLE_100
173: , p12_a3 JTF_VARCHAR2_TABLE_100
174: , p12_a4 JTF_NUMBER_TABLE
175: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 172: , p12_a2 JTF_VARCHAR2_TABLE_100

168: , p_object_type_id NUMBER
169: , p_object_type VARCHAR2
170: , p12_a0 JTF_NUMBER_TABLE
171: , p12_a1 JTF_VARCHAR2_TABLE_100
172: , p12_a2 JTF_VARCHAR2_TABLE_100
173: , p12_a3 JTF_VARCHAR2_TABLE_100
174: , p12_a4 JTF_NUMBER_TABLE
175: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
176: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 173: , p12_a3 JTF_VARCHAR2_TABLE_100

169: , p_object_type VARCHAR2
170: , p12_a0 JTF_NUMBER_TABLE
171: , p12_a1 JTF_VARCHAR2_TABLE_100
172: , p12_a2 JTF_VARCHAR2_TABLE_100
173: , p12_a3 JTF_VARCHAR2_TABLE_100
174: , p12_a4 JTF_NUMBER_TABLE
175: , x_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER
176: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
177: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER