DBA Data[Home] [Help]

APPS.OKL_ACCT_GEN_RULE_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p4(t out nocopy okl_acct_gen_rule_pvt.acct_tbl_type, a0 JTF_NUMBER_TABLE

1: package okl_acct_gen_rule_pvt_w as
2: /* $Header: OKLEACGS.pls 120.1 2005/07/07 13:32:45 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_acct_gen_rule_pvt.acct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 6: , a3 JTF_NUMBER_TABLE

2: /* $Header: OKLEACGS.pls 120.1 2005/07/07 13:32:45 dkagrawa noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy okl_acct_gen_rule_pvt.acct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100

Line 7: , a4 JTF_NUMBER_TABLE

3: procedure rosetta_table_copy_in_p4(t out nocopy okl_acct_gen_rule_pvt.acct_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_4000
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE

Line 11: , a8 JTF_NUMBER_TABLE

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_VARCHAR2_TABLE_500
13: , a10 JTF_VARCHAR2_TABLE_500
14: , a11 JTF_VARCHAR2_TABLE_500
15: , a12 JTF_VARCHAR2_TABLE_500

Line 28: , a25 JTF_NUMBER_TABLE

24: , a21 JTF_VARCHAR2_TABLE_500
25: , a22 JTF_VARCHAR2_TABLE_500
26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE

Line 30: , a27 JTF_NUMBER_TABLE

26: , a23 JTF_VARCHAR2_TABLE_500
27: , a24 JTF_VARCHAR2_TABLE_500
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 32: , a29 JTF_NUMBER_TABLE

28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_4000

Line 34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: );
34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE

Line 37: , a3 out nocopy JTF_NUMBER_TABLE

33: );
34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , a4 out nocopy JTF_NUMBER_TABLE

34: procedure rosetta_table_copy_out_p4(t okl_acct_gen_rule_pvt.acct_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
35: , a1 out nocopy JTF_VARCHAR2_TABLE_100
36: , a2 out nocopy JTF_VARCHAR2_TABLE_4000
37: , a3 out nocopy JTF_NUMBER_TABLE
38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE

Line 42: , a8 out nocopy JTF_NUMBER_TABLE

38: , a4 out nocopy JTF_NUMBER_TABLE
39: , a5 out nocopy JTF_VARCHAR2_TABLE_100
40: , a6 out nocopy JTF_VARCHAR2_TABLE_100
41: , a7 out nocopy JTF_VARCHAR2_TABLE_100
42: , a8 out nocopy JTF_NUMBER_TABLE
43: , a9 out nocopy JTF_VARCHAR2_TABLE_500
44: , a10 out nocopy JTF_VARCHAR2_TABLE_500
45: , a11 out nocopy JTF_VARCHAR2_TABLE_500
46: , a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 59: , a25 out nocopy JTF_NUMBER_TABLE

55: , a21 out nocopy JTF_VARCHAR2_TABLE_500
56: , a22 out nocopy JTF_VARCHAR2_TABLE_500
57: , a23 out nocopy JTF_VARCHAR2_TABLE_500
58: , a24 out nocopy JTF_VARCHAR2_TABLE_500
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE

Line 61: , a27 out nocopy JTF_NUMBER_TABLE

57: , a23 out nocopy JTF_VARCHAR2_TABLE_500
58: , a24 out nocopy JTF_VARCHAR2_TABLE_500
59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:

Line 63: , a29 out nocopy JTF_NUMBER_TABLE

59: , a25 out nocopy JTF_NUMBER_TABLE
60: , a26 out nocopy JTF_DATE_TABLE
61: , a27 out nocopy JTF_NUMBER_TABLE
62: , a28 out nocopy JTF_DATE_TABLE
63: , a29 out nocopy JTF_NUMBER_TABLE
64: );
65:
66: procedure get_rule_lines(p_api_version NUMBER
67: , p_init_msg_list VARCHAR2

Line 72: , p6_a0 out nocopy JTF_NUMBER_TABLE

68: , x_return_status out nocopy VARCHAR2
69: , x_msg_count out nocopy NUMBER
70: , x_msg_data out nocopy VARCHAR2
71: , p_ae_line_type VARCHAR2
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 75: , p6_a3 out nocopy JTF_NUMBER_TABLE

71: , p_ae_line_type VARCHAR2
72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 76: , p6_a4 out nocopy JTF_NUMBER_TABLE

72: , p6_a0 out nocopy JTF_NUMBER_TABLE
73: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
75: , p6_a3 out nocopy JTF_NUMBER_TABLE
76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a8 out nocopy JTF_NUMBER_TABLE

76: , p6_a4 out nocopy JTF_NUMBER_TABLE
77: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
78: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
79: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a8 out nocopy JTF_NUMBER_TABLE
81: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
82: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
83: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
84: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 97: , p6_a25 out nocopy JTF_NUMBER_TABLE

93: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
94: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
95: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
96: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
97: , p6_a25 out nocopy JTF_NUMBER_TABLE
98: , p6_a26 out nocopy JTF_DATE_TABLE
99: , p6_a27 out nocopy JTF_NUMBER_TABLE
100: , p6_a28 out nocopy JTF_DATE_TABLE
101: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 99: , p6_a27 out nocopy JTF_NUMBER_TABLE

95: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
96: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
97: , p6_a25 out nocopy JTF_NUMBER_TABLE
98: , p6_a26 out nocopy JTF_DATE_TABLE
99: , p6_a27 out nocopy JTF_NUMBER_TABLE
100: , p6_a28 out nocopy JTF_DATE_TABLE
101: , p6_a29 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure updt_rule_lines(p_api_version NUMBER

Line 101: , p6_a29 out nocopy JTF_NUMBER_TABLE

97: , p6_a25 out nocopy JTF_NUMBER_TABLE
98: , p6_a26 out nocopy JTF_DATE_TABLE
99: , p6_a27 out nocopy JTF_NUMBER_TABLE
100: , p6_a28 out nocopy JTF_DATE_TABLE
101: , p6_a29 out nocopy JTF_NUMBER_TABLE
102: );
103: procedure updt_rule_lines(p_api_version NUMBER
104: , p_init_msg_list VARCHAR2
105: , x_return_status out nocopy VARCHAR2

Line 108: , p5_a0 JTF_NUMBER_TABLE

104: , p_init_msg_list VARCHAR2
105: , x_return_status out nocopy VARCHAR2
106: , x_msg_count out nocopy NUMBER
107: , x_msg_data out nocopy VARCHAR2
108: , p5_a0 JTF_NUMBER_TABLE
109: , p5_a1 JTF_VARCHAR2_TABLE_100
110: , p5_a2 JTF_VARCHAR2_TABLE_4000
111: , p5_a3 JTF_NUMBER_TABLE
112: , p5_a4 JTF_NUMBER_TABLE

Line 111: , p5_a3 JTF_NUMBER_TABLE

107: , x_msg_data out nocopy VARCHAR2
108: , p5_a0 JTF_NUMBER_TABLE
109: , p5_a1 JTF_VARCHAR2_TABLE_100
110: , p5_a2 JTF_VARCHAR2_TABLE_4000
111: , p5_a3 JTF_NUMBER_TABLE
112: , p5_a4 JTF_NUMBER_TABLE
113: , p5_a5 JTF_VARCHAR2_TABLE_100
114: , p5_a6 JTF_VARCHAR2_TABLE_100
115: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 112: , p5_a4 JTF_NUMBER_TABLE

108: , p5_a0 JTF_NUMBER_TABLE
109: , p5_a1 JTF_VARCHAR2_TABLE_100
110: , p5_a2 JTF_VARCHAR2_TABLE_4000
111: , p5_a3 JTF_NUMBER_TABLE
112: , p5_a4 JTF_NUMBER_TABLE
113: , p5_a5 JTF_VARCHAR2_TABLE_100
114: , p5_a6 JTF_VARCHAR2_TABLE_100
115: , p5_a7 JTF_VARCHAR2_TABLE_100
116: , p5_a8 JTF_NUMBER_TABLE

Line 116: , p5_a8 JTF_NUMBER_TABLE

112: , p5_a4 JTF_NUMBER_TABLE
113: , p5_a5 JTF_VARCHAR2_TABLE_100
114: , p5_a6 JTF_VARCHAR2_TABLE_100
115: , p5_a7 JTF_VARCHAR2_TABLE_100
116: , p5_a8 JTF_NUMBER_TABLE
117: , p5_a9 JTF_VARCHAR2_TABLE_500
118: , p5_a10 JTF_VARCHAR2_TABLE_500
119: , p5_a11 JTF_VARCHAR2_TABLE_500
120: , p5_a12 JTF_VARCHAR2_TABLE_500

Line 133: , p5_a25 JTF_NUMBER_TABLE

129: , p5_a21 JTF_VARCHAR2_TABLE_500
130: , p5_a22 JTF_VARCHAR2_TABLE_500
131: , p5_a23 JTF_VARCHAR2_TABLE_500
132: , p5_a24 JTF_VARCHAR2_TABLE_500
133: , p5_a25 JTF_NUMBER_TABLE
134: , p5_a26 JTF_DATE_TABLE
135: , p5_a27 JTF_NUMBER_TABLE
136: , p5_a28 JTF_DATE_TABLE
137: , p5_a29 JTF_NUMBER_TABLE

Line 135: , p5_a27 JTF_NUMBER_TABLE

131: , p5_a23 JTF_VARCHAR2_TABLE_500
132: , p5_a24 JTF_VARCHAR2_TABLE_500
133: , p5_a25 JTF_NUMBER_TABLE
134: , p5_a26 JTF_DATE_TABLE
135: , p5_a27 JTF_NUMBER_TABLE
136: , p5_a28 JTF_DATE_TABLE
137: , p5_a29 JTF_NUMBER_TABLE
138: , p6_a0 out nocopy JTF_NUMBER_TABLE
139: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

Line 137: , p5_a29 JTF_NUMBER_TABLE

133: , p5_a25 JTF_NUMBER_TABLE
134: , p5_a26 JTF_DATE_TABLE
135: , p5_a27 JTF_NUMBER_TABLE
136: , p5_a28 JTF_DATE_TABLE
137: , p5_a29 JTF_NUMBER_TABLE
138: , p6_a0 out nocopy JTF_NUMBER_TABLE
139: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
141: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 138: , p6_a0 out nocopy JTF_NUMBER_TABLE

134: , p5_a26 JTF_DATE_TABLE
135: , p5_a27 JTF_NUMBER_TABLE
136: , p5_a28 JTF_DATE_TABLE
137: , p5_a29 JTF_NUMBER_TABLE
138: , p6_a0 out nocopy JTF_NUMBER_TABLE
139: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
141: , p6_a3 out nocopy JTF_NUMBER_TABLE
142: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 141: , p6_a3 out nocopy JTF_NUMBER_TABLE

137: , p5_a29 JTF_NUMBER_TABLE
138: , p6_a0 out nocopy JTF_NUMBER_TABLE
139: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
141: , p6_a3 out nocopy JTF_NUMBER_TABLE
142: , p6_a4 out nocopy JTF_NUMBER_TABLE
143: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 142: , p6_a4 out nocopy JTF_NUMBER_TABLE

138: , p6_a0 out nocopy JTF_NUMBER_TABLE
139: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_4000
141: , p6_a3 out nocopy JTF_NUMBER_TABLE
142: , p6_a4 out nocopy JTF_NUMBER_TABLE
143: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 146: , p6_a8 out nocopy JTF_NUMBER_TABLE

142: , p6_a4 out nocopy JTF_NUMBER_TABLE
143: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
144: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
146: , p6_a8 out nocopy JTF_NUMBER_TABLE
147: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
148: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
149: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
150: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500

Line 163: , p6_a25 out nocopy JTF_NUMBER_TABLE

159: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
160: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
161: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
162: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
163: , p6_a25 out nocopy JTF_NUMBER_TABLE
164: , p6_a26 out nocopy JTF_DATE_TABLE
165: , p6_a27 out nocopy JTF_NUMBER_TABLE
166: , p6_a28 out nocopy JTF_DATE_TABLE
167: , p6_a29 out nocopy JTF_NUMBER_TABLE

Line 165: , p6_a27 out nocopy JTF_NUMBER_TABLE

161: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
162: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
163: , p6_a25 out nocopy JTF_NUMBER_TABLE
164: , p6_a26 out nocopy JTF_DATE_TABLE
165: , p6_a27 out nocopy JTF_NUMBER_TABLE
166: , p6_a28 out nocopy JTF_DATE_TABLE
167: , p6_a29 out nocopy JTF_NUMBER_TABLE
168: );
169: end okl_acct_gen_rule_pvt_w;

Line 167: , p6_a29 out nocopy JTF_NUMBER_TABLE

163: , p6_a25 out nocopy JTF_NUMBER_TABLE
164: , p6_a26 out nocopy JTF_DATE_TABLE
165: , p6_a27 out nocopy JTF_NUMBER_TABLE
166: , p6_a28 out nocopy JTF_DATE_TABLE
167: , p6_a29 out nocopy JTF_NUMBER_TABLE
168: );
169: end okl_acct_gen_rule_pvt_w;