DBA Data[Home] [Help]

APPS.JTF_PERZ_DATA_PUB_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_attrib_tbl_type, a0 JTF_NUMBER_TABLE

1: package jtf_perz_data_pub_w as
2: /* $Header: jtfzwpds.pls 120.2 2005/11/02 23:48:00 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_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_300

Line 4: , a1 JTF_NUMBER_TABLE

1: package jtf_perz_data_pub_w as
2: /* $Header: jtfzwpds.pls 120.2 2005/11/02 23:48:00 skothe ship $ */
3: procedure rosetta_table_copy_in_p1(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_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_300
8: , a5 JTF_VARCHAR2_TABLE_100

Line 10: procedure rosetta_table_copy_out_p1(t jtf_perz_data_pub.data_attrib_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 11: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

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

Line 18: procedure rosetta_table_copy_in_p4(t OUT NOCOPY /* file.sql.39 change */ jtf_perz_data_pub.data_out_tbl_type, a0 JTF_NUMBER_TABLE

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

Line 19: , a1 JTF_NUMBER_TABLE

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

Line 20: , a2 JTF_NUMBER_TABLE

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

Line 25: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

21: , a3 JTF_VARCHAR2_TABLE_200
22: , a4 JTF_VARCHAR2_TABLE_100
23: , a5 JTF_VARCHAR2_TABLE_300
24: );
25: procedure rosetta_table_copy_out_p4(t jtf_perz_data_pub.data_out_tbl_type, a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
26: , a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
27: , a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
28: , a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
29: , a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

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

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

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

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

Line 40: , p7_a0 JTF_NUMBER_TABLE

36: , p_application_id NUMBER
37: , p_profile_id NUMBER
38: , p_profile_name VARCHAR2
39: , p_profile_type VARCHAR2
40: , p7_a0 JTF_NUMBER_TABLE
41: , p7_a1 JTF_NUMBER_TABLE
42: , p7_a2 JTF_VARCHAR2_TABLE_100
43: , p7_a3 JTF_VARCHAR2_TABLE_100
44: , p7_a4 JTF_VARCHAR2_TABLE_100

Line 41: , p7_a1 JTF_NUMBER_TABLE

37: , p_profile_id NUMBER
38: , p_profile_name VARCHAR2
39: , p_profile_type VARCHAR2
40: , p7_a0 JTF_NUMBER_TABLE
41: , p7_a1 JTF_NUMBER_TABLE
42: , p7_a2 JTF_VARCHAR2_TABLE_100
43: , p7_a3 JTF_VARCHAR2_TABLE_100
44: , p7_a4 JTF_VARCHAR2_TABLE_100
45: , p_perz_data_id NUMBER

Line 49: , p12_a0 JTF_NUMBER_TABLE

45: , p_perz_data_id NUMBER
46: , p_perz_data_name VARCHAR2
47: , p_perz_data_type VARCHAR2
48: , p_perz_data_desc VARCHAR2
49: , p12_a0 JTF_NUMBER_TABLE
50: , p12_a1 JTF_NUMBER_TABLE
51: , p12_a2 JTF_VARCHAR2_TABLE_100
52: , p12_a3 JTF_VARCHAR2_TABLE_100
53: , p12_a4 JTF_VARCHAR2_TABLE_300

Line 50: , p12_a1 JTF_NUMBER_TABLE

46: , p_perz_data_name VARCHAR2
47: , p_perz_data_type VARCHAR2
48: , p_perz_data_desc VARCHAR2
49: , p12_a0 JTF_NUMBER_TABLE
50: , p12_a1 JTF_NUMBER_TABLE
51: , p12_a2 JTF_VARCHAR2_TABLE_100
52: , p12_a3 JTF_VARCHAR2_TABLE_100
53: , p12_a4 JTF_VARCHAR2_TABLE_300
54: , p12_a5 JTF_VARCHAR2_TABLE_100

Line 70: , p10_a0 JTF_NUMBER_TABLE

66: , p_perz_data_id NUMBER
67: , p_perz_data_name VARCHAR2
68: , p_perz_data_type VARCHAR2
69: , p_perz_data_desc VARCHAR2
70: , p10_a0 JTF_NUMBER_TABLE
71: , p10_a1 JTF_NUMBER_TABLE
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , p10_a3 JTF_VARCHAR2_TABLE_100
74: , p10_a4 JTF_VARCHAR2_TABLE_300

Line 71: , p10_a1 JTF_NUMBER_TABLE

67: , p_perz_data_name VARCHAR2
68: , p_perz_data_type VARCHAR2
69: , p_perz_data_desc VARCHAR2
70: , p10_a0 JTF_NUMBER_TABLE
71: , p10_a1 JTF_NUMBER_TABLE
72: , p10_a2 JTF_VARCHAR2_TABLE_100
73: , p10_a3 JTF_VARCHAR2_TABLE_100
74: , p10_a4 JTF_VARCHAR2_TABLE_300
75: , p10_a5 JTF_VARCHAR2_TABLE_100

Line 93: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

89: , x_perz_data_id OUT NOCOPY /* file.sql.39 change */ NUMBER
90: , x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91: , x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
97: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

90: , x_perz_data_name OUT NOCOPY /* file.sql.39 change */ VARCHAR2
91: , x_perz_data_type OUT NOCOPY /* file.sql.39 change */ VARCHAR2
92: , x_perz_data_desc OUT NOCOPY /* file.sql.39 change */ VARCHAR2
93: , p12_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
94: , p12_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
95: , p12_a2 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
96: , p12_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
97: , p12_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
98: , p12_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 111: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

107: , p_profile_name VARCHAR2
108: , p_perz_data_id NUMBER
109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
111: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
112: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
113: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
115: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100

Line 112: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

108: , p_perz_data_id NUMBER
109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
111: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
112: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
113: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
115: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
116: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300

Line 113: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE

109: , p_perz_data_name VARCHAR2
110: , p_perz_data_type VARCHAR2
111: , p8_a0 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
112: , p8_a1 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
113: , p8_a2 OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE
114: , p8_a3 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_200
115: , p8_a4 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_100
116: , p8_a5 OUT NOCOPY /* file.sql.39 change */ JTF_VARCHAR2_TABLE_300
117: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 130: , p9_a0 JTF_NUMBER_TABLE

126: , p_perz_data_id NUMBER
127: , p_perz_data_name VARCHAR2
128: , p_perz_data_type VARCHAR2
129: , p_perz_data_desc VARCHAR2
130: , p9_a0 JTF_NUMBER_TABLE
131: , p9_a1 JTF_NUMBER_TABLE
132: , p9_a2 JTF_VARCHAR2_TABLE_100
133: , p9_a3 JTF_VARCHAR2_TABLE_100
134: , p9_a4 JTF_VARCHAR2_TABLE_300

Line 131: , p9_a1 JTF_NUMBER_TABLE

127: , p_perz_data_name VARCHAR2
128: , p_perz_data_type VARCHAR2
129: , p_perz_data_desc VARCHAR2
130: , p9_a0 JTF_NUMBER_TABLE
131: , p9_a1 JTF_NUMBER_TABLE
132: , p9_a2 JTF_VARCHAR2_TABLE_100
133: , p9_a3 JTF_VARCHAR2_TABLE_100
134: , p9_a4 JTF_VARCHAR2_TABLE_300
135: , p9_a5 JTF_VARCHAR2_TABLE_100