DBA Data[Home] [Help]

APPS.OKC_TERMS_MULTIREC_GRP_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okc_terms_multirec_grp_w as
2: /* $Header: OKCWMULS.pls 120.2 2005/09/14 02:34:33 vnanjang noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okc_terms_multirec_grp_w as
2: /* $Header: OKCWMULS.pls 120.2 2005/09/14 02:34:33 vnanjang noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE

Line 6: , a3 JTF_VARCHAR2_TABLE_100

2: /* $Header: OKCWMULS.pls 120.2 2005/09/14 02:34:33 vnanjang noship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 7: , a4 JTF_VARCHAR2_TABLE_100

3: procedure rosetta_table_copy_in_p5(t out nocopy okc_terms_multirec_grp.art_var_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_2000
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );

Line 13: , a1 out nocopy JTF_VARCHAR2_TABLE_100

9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_2000

Line 14: , a2 out nocopy JTF_VARCHAR2_TABLE_100

10: , a7 JTF_NUMBER_TABLE
11: );
12: procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a6 out nocopy JTF_NUMBER_TABLE

Line 15: , a3 out nocopy JTF_VARCHAR2_TABLE_100

11: );
12: procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE

Line 16: , a4 out nocopy JTF_VARCHAR2_TABLE_100

12: procedure rosetta_table_copy_out_p5(t okc_terms_multirec_grp.art_var_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a1 out nocopy JTF_VARCHAR2_TABLE_100
14: , a2 out nocopy JTF_VARCHAR2_TABLE_100
15: , a3 out nocopy JTF_VARCHAR2_TABLE_100
16: , a4 out nocopy JTF_VARCHAR2_TABLE_100
17: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
18: , a6 out nocopy JTF_NUMBER_TABLE
19: , a7 out nocopy JTF_NUMBER_TABLE
20: );

Line 26: , a4 JTF_VARCHAR2_TABLE_100

22: procedure rosetta_table_copy_in_p6(t out nocopy okc_terms_multirec_grp.kart_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_VARCHAR2_TABLE_2000
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_NUMBER_TABLE
28: , a6 JTF_NUMBER_TABLE
29: );
30: procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 34: , a4 out nocopy JTF_VARCHAR2_TABLE_100

30: procedure rosetta_table_copy_out_p6(t okc_terms_multirec_grp.kart_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_NUMBER_TABLE
32: , a2 out nocopy JTF_NUMBER_TABLE
33: , a3 out nocopy JTF_VARCHAR2_TABLE_2000
34: , a4 out nocopy JTF_VARCHAR2_TABLE_100
35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: );
38:

Line 39: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100

35: , a5 out nocopy JTF_NUMBER_TABLE
36: , a6 out nocopy JTF_NUMBER_TABLE
37: );
38:
39: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: , a4 JTF_VARCHAR2_TABLE_100

Line 43: , a4 JTF_VARCHAR2_TABLE_100

39: procedure rosetta_table_copy_in_p7(t out nocopy okc_terms_multirec_grp.structure_tbl_type, a0 JTF_VARCHAR2_TABLE_100
40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: , a4 JTF_VARCHAR2_TABLE_100
44: , a5 JTF_VARCHAR2_TABLE_100
45: , a6 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

Line 44: , a5 JTF_VARCHAR2_TABLE_100

40: , a1 JTF_NUMBER_TABLE
41: , a2 JTF_NUMBER_TABLE
42: , a3 JTF_NUMBER_TABLE
43: , a4 JTF_VARCHAR2_TABLE_100
44: , a5 JTF_VARCHAR2_TABLE_100
45: , a6 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_NUMBER_TABLE

Line 47: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

43: , a4 JTF_VARCHAR2_TABLE_100
44: , a5 JTF_VARCHAR2_TABLE_100
45: , a6 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 51: , a4 out nocopy JTF_VARCHAR2_TABLE_100

47: procedure rosetta_table_copy_out_p7(t okc_terms_multirec_grp.structure_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_VARCHAR2_TABLE_100
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_NUMBER_TABLE
54: );
55:

Line 52: , a5 out nocopy JTF_VARCHAR2_TABLE_100

48: , a1 out nocopy JTF_NUMBER_TABLE
49: , a2 out nocopy JTF_NUMBER_TABLE
50: , a3 out nocopy JTF_NUMBER_TABLE
51: , a4 out nocopy JTF_VARCHAR2_TABLE_100
52: , a5 out nocopy JTF_VARCHAR2_TABLE_100
53: , a6 out nocopy JTF_NUMBER_TABLE
54: );
55:
56: procedure rosetta_table_copy_in_p8(t out nocopy okc_terms_multirec_grp.article_id_tbl_type, a0 JTF_NUMBER_TABLE);

Line 68: procedure rosetta_table_copy_in_p10(t out nocopy okc_terms_multirec_grp.organize_tbl_type, a0 JTF_VARCHAR2_TABLE_100

64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: );
67:
68: procedure rosetta_table_copy_in_p10(t out nocopy okc_terms_multirec_grp.organize_tbl_type, a0 JTF_VARCHAR2_TABLE_100
69: , a1 JTF_NUMBER_TABLE
70: );
71: procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
72: , a1 out nocopy JTF_NUMBER_TABLE

Line 71: procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

67:
68: procedure rosetta_table_copy_in_p10(t out nocopy okc_terms_multirec_grp.organize_tbl_type, a0 JTF_VARCHAR2_TABLE_100
69: , a1 JTF_NUMBER_TABLE
70: );
71: procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
72: , a1 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p11(t out nocopy okc_terms_multirec_grp.merge_review_tbl_type, a0 JTF_VARCHAR2_TABLE_100

Line 75: procedure rosetta_table_copy_in_p11(t out nocopy okc_terms_multirec_grp.merge_review_tbl_type, a0 JTF_VARCHAR2_TABLE_100

71: procedure rosetta_table_copy_out_p10(t okc_terms_multirec_grp.organize_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
72: , a1 out nocopy JTF_NUMBER_TABLE
73: );
74:
75: procedure rosetta_table_copy_in_p11(t out nocopy okc_terms_multirec_grp.merge_review_tbl_type, a0 JTF_VARCHAR2_TABLE_100
76: , a1 JTF_NUMBER_TABLE, a2 JTF_NUMBER_TABLE
77: );
78:
79:

Line 95: , p11_a4 JTF_VARCHAR2_TABLE_100

91: , p11_a0 JTF_NUMBER_TABLE
92: , p11_a1 JTF_NUMBER_TABLE
93: , p11_a2 JTF_NUMBER_TABLE
94: , p11_a3 JTF_VARCHAR2_TABLE_2000
95: , p11_a4 JTF_VARCHAR2_TABLE_100
96: , p11_a5 JTF_NUMBER_TABLE
97: , p11_a6 JTF_NUMBER_TABLE
98: , p12_a0 out nocopy JTF_NUMBER_TABLE
99: , p12_a1 out nocopy JTF_NUMBER_TABLE

Line 102: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

98: , p12_a0 out nocopy JTF_NUMBER_TABLE
99: , p12_a1 out nocopy JTF_NUMBER_TABLE
100: , p12_a2 out nocopy JTF_NUMBER_TABLE
101: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_2000
102: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
103: , p12_a5 out nocopy JTF_NUMBER_TABLE
104: , p12_a6 out nocopy JTF_NUMBER_TABLE
105: , x_return_status out nocopy VARCHAR2
106: , x_msg_count out nocopy NUMBER

Line 116: , p6_a1 JTF_VARCHAR2_TABLE_100

112: , p_validate_commit VARCHAR2
113: , p_validation_string VARCHAR2
114: , p_commit VARCHAR2
115: , p6_a0 JTF_NUMBER_TABLE
116: , p6_a1 JTF_VARCHAR2_TABLE_100
117: , p6_a2 JTF_VARCHAR2_TABLE_100
118: , p6_a3 JTF_VARCHAR2_TABLE_100
119: , p6_a4 JTF_VARCHAR2_TABLE_100
120: , p6_a5 JTF_VARCHAR2_TABLE_2000

Line 117: , p6_a2 JTF_VARCHAR2_TABLE_100

113: , p_validation_string VARCHAR2
114: , p_commit VARCHAR2
115: , p6_a0 JTF_NUMBER_TABLE
116: , p6_a1 JTF_VARCHAR2_TABLE_100
117: , p6_a2 JTF_VARCHAR2_TABLE_100
118: , p6_a3 JTF_VARCHAR2_TABLE_100
119: , p6_a4 JTF_VARCHAR2_TABLE_100
120: , p6_a5 JTF_VARCHAR2_TABLE_2000
121: , p6_a6 JTF_NUMBER_TABLE

Line 118: , p6_a3 JTF_VARCHAR2_TABLE_100

114: , p_commit VARCHAR2
115: , p6_a0 JTF_NUMBER_TABLE
116: , p6_a1 JTF_VARCHAR2_TABLE_100
117: , p6_a2 JTF_VARCHAR2_TABLE_100
118: , p6_a3 JTF_VARCHAR2_TABLE_100
119: , p6_a4 JTF_VARCHAR2_TABLE_100
120: , p6_a5 JTF_VARCHAR2_TABLE_2000
121: , p6_a6 JTF_NUMBER_TABLE
122: , p6_a7 JTF_NUMBER_TABLE

Line 119: , p6_a4 JTF_VARCHAR2_TABLE_100

115: , p6_a0 JTF_NUMBER_TABLE
116: , p6_a1 JTF_VARCHAR2_TABLE_100
117: , p6_a2 JTF_VARCHAR2_TABLE_100
118: , p6_a3 JTF_VARCHAR2_TABLE_100
119: , p6_a4 JTF_VARCHAR2_TABLE_100
120: , p6_a5 JTF_VARCHAR2_TABLE_2000
121: , p6_a6 JTF_NUMBER_TABLE
122: , p6_a7 JTF_NUMBER_TABLE
123: , p_mode VARCHAR2

Line 134: , p6_a0 JTF_VARCHAR2_TABLE_100

130: , p_validation_level NUMBER
131: , p_validate_commit VARCHAR2
132: , p_validation_string VARCHAR2
133: , p_commit VARCHAR2
134: , p6_a0 JTF_VARCHAR2_TABLE_100
135: , p6_a1 JTF_NUMBER_TABLE
136: , p6_a2 JTF_NUMBER_TABLE
137: , p6_a3 JTF_NUMBER_TABLE
138: , p6_a4 JTF_VARCHAR2_TABLE_100

Line 138: , p6_a4 JTF_VARCHAR2_TABLE_100

134: , p6_a0 JTF_VARCHAR2_TABLE_100
135: , p6_a1 JTF_NUMBER_TABLE
136: , p6_a2 JTF_NUMBER_TABLE
137: , p6_a3 JTF_NUMBER_TABLE
138: , p6_a4 JTF_VARCHAR2_TABLE_100
139: , p6_a5 JTF_VARCHAR2_TABLE_100
140: , p6_a6 JTF_NUMBER_TABLE
141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER

Line 139: , p6_a5 JTF_VARCHAR2_TABLE_100

135: , p6_a1 JTF_NUMBER_TABLE
136: , p6_a2 JTF_NUMBER_TABLE
137: , p6_a3 JTF_NUMBER_TABLE
138: , p6_a4 JTF_VARCHAR2_TABLE_100
139: , p6_a5 JTF_VARCHAR2_TABLE_100
140: , p6_a6 JTF_NUMBER_TABLE
141: , x_return_status out nocopy VARCHAR2
142: , x_msg_count out nocopy NUMBER
143: , x_msg_data out nocopy VARCHAR2

Line 180: , p6_a0 JTF_VARCHAR2_TABLE_100

176: , p_validation_level NUMBER
177: , p_validate_commit VARCHAR2
178: , p_validation_string VARCHAR2
179: , p_commit VARCHAR2
180: , p6_a0 JTF_VARCHAR2_TABLE_100
181: , p6_a1 JTF_NUMBER_TABLE
182: , p_ref_point VARCHAR2
183: , p_doc_type VARCHAR2
184: , p_doc_id NUMBER

Line 199: , p6_a0 JTF_VARCHAR2_TABLE_100

195: , p_validation_level NUMBER
196: , p_validate_commit VARCHAR2
197: , p_validation_string VARCHAR2
198: , p_commit VARCHAR2
199: , p6_a0 JTF_VARCHAR2_TABLE_100
200: , p6_a1 JTF_NUMBER_TABLE
201: , p6_a2 JTF_NUMBER_TABLE
202: , p_doc_type VARCHAR2
203: , p_doc_id NUMBER