DBA Data[Home] [Help]

APPS.OKL_CREDIT_MEMO_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package okl_credit_memo_pvt_w as
2: /* $Header: OKLECRMS.pls 120.4 2007/11/06 07:32:05 veramach noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_credit_memo_pvt.credit_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200

Line 5: , a2 JTF_VARCHAR2_TABLE_100

1: package okl_credit_memo_pvt_w as
2: /* $Header: OKLECRMS.pls 120.4 2007/11/06 07:32:05 veramach noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy okl_credit_memo_pvt.credit_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t okl_credit_memo_pvt.credit_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 14: , a1 out nocopy JTF_VARCHAR2_TABLE_100

10: , a7 JTF_DATE_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t okl_credit_memo_pvt.credit_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_200

Line 15: , a2 out nocopy JTF_VARCHAR2_TABLE_100

11: , a8 JTF_VARCHAR2_TABLE_100
12: );
13: procedure rosetta_table_copy_out_p1(t okl_credit_memo_pvt.credit_tbl, a0 out nocopy JTF_NUMBER_TABLE
14: , a1 out nocopy JTF_VARCHAR2_TABLE_100
15: , a2 out nocopy JTF_VARCHAR2_TABLE_100
16: , a3 out nocopy JTF_NUMBER_TABLE
17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_200
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 21: , a8 out nocopy JTF_VARCHAR2_TABLE_100

17: , a4 out nocopy JTF_NUMBER_TABLE
18: , a5 out nocopy JTF_VARCHAR2_TABLE_200
19: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a7 out nocopy JTF_DATE_TABLE
21: , a8 out nocopy JTF_VARCHAR2_TABLE_100
22: );
23:
24: procedure insert_request(p_api_version NUMBER
25: , p_init_msg_list VARCHAR2

Line 116: , p2_a1 JTF_VARCHAR2_TABLE_100

112: );
113: procedure insert_request(p_api_version NUMBER
114: , p_init_msg_list VARCHAR2
115: , p2_a0 JTF_NUMBER_TABLE
116: , p2_a1 JTF_VARCHAR2_TABLE_100
117: , p2_a2 JTF_VARCHAR2_TABLE_100
118: , p2_a3 JTF_NUMBER_TABLE
119: , p2_a4 JTF_NUMBER_TABLE
120: , p2_a5 JTF_VARCHAR2_TABLE_200

Line 117: , p2_a2 JTF_VARCHAR2_TABLE_100

113: procedure insert_request(p_api_version NUMBER
114: , p_init_msg_list VARCHAR2
115: , p2_a0 JTF_NUMBER_TABLE
116: , p2_a1 JTF_VARCHAR2_TABLE_100
117: , p2_a2 JTF_VARCHAR2_TABLE_100
118: , p2_a3 JTF_NUMBER_TABLE
119: , p2_a4 JTF_NUMBER_TABLE
120: , p2_a5 JTF_VARCHAR2_TABLE_200
121: , p2_a6 JTF_VARCHAR2_TABLE_2000

Line 123: , p2_a8 JTF_VARCHAR2_TABLE_100

119: , p2_a4 JTF_NUMBER_TABLE
120: , p2_a5 JTF_VARCHAR2_TABLE_200
121: , p2_a6 JTF_VARCHAR2_TABLE_2000
122: , p2_a7 JTF_DATE_TABLE
123: , p2_a8 JTF_VARCHAR2_TABLE_100
124: , p_transaction_source VARCHAR2
125: , p_source_trx_number VARCHAR2
126: , p5_a0 out nocopy JTF_NUMBER_TABLE
127: , p5_a1 out nocopy JTF_NUMBER_TABLE

Line 128: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100

124: , p_transaction_source VARCHAR2
125: , p_source_trx_number VARCHAR2
126: , p5_a0 out nocopy JTF_NUMBER_TABLE
127: , p5_a1 out nocopy JTF_NUMBER_TABLE
128: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
131: , p5_a5 out nocopy JTF_NUMBER_TABLE
132: , p5_a6 out nocopy JTF_DATE_TABLE

Line 129: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100

125: , p_source_trx_number VARCHAR2
126: , p5_a0 out nocopy JTF_NUMBER_TABLE
127: , p5_a1 out nocopy JTF_NUMBER_TABLE
128: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
131: , p5_a5 out nocopy JTF_NUMBER_TABLE
132: , p5_a6 out nocopy JTF_DATE_TABLE
133: , p5_a7 out nocopy JTF_NUMBER_TABLE

Line 130: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100

126: , p5_a0 out nocopy JTF_NUMBER_TABLE
127: , p5_a1 out nocopy JTF_NUMBER_TABLE
128: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
129: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_100
130: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
131: , p5_a5 out nocopy JTF_NUMBER_TABLE
132: , p5_a6 out nocopy JTF_DATE_TABLE
133: , p5_a7 out nocopy JTF_NUMBER_TABLE
134: , p5_a8 out nocopy JTF_NUMBER_TABLE

Line 140: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100

136: , p5_a10 out nocopy JTF_NUMBER_TABLE
137: , p5_a11 out nocopy JTF_NUMBER_TABLE
138: , p5_a12 out nocopy JTF_NUMBER_TABLE
139: , p5_a13 out nocopy JTF_NUMBER_TABLE
140: , p5_a14 out nocopy JTF_VARCHAR2_TABLE_100
141: , p5_a15 out nocopy JTF_NUMBER_TABLE
142: , p5_a16 out nocopy JTF_NUMBER_TABLE
143: , p5_a17 out nocopy JTF_NUMBER_TABLE
144: , p5_a18 out nocopy JTF_NUMBER_TABLE

Line 156: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100

152: , p5_a26 out nocopy JTF_VARCHAR2_TABLE_300
153: , p5_a27 out nocopy JTF_NUMBER_TABLE
154: , p5_a28 out nocopy JTF_NUMBER_TABLE
155: , p5_a29 out nocopy JTF_NUMBER_TABLE
156: , p5_a30 out nocopy JTF_VARCHAR2_TABLE_100
157: , p5_a31 out nocopy JTF_VARCHAR2_TABLE_500
158: , p5_a32 out nocopy JTF_VARCHAR2_TABLE_500
159: , p5_a33 out nocopy JTF_VARCHAR2_TABLE_500
160: , p5_a34 out nocopy JTF_VARCHAR2_TABLE_500

Line 186: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100

182: , p5_a56 out nocopy JTF_NUMBER_TABLE
183: , p5_a57 out nocopy JTF_NUMBER_TABLE
184: , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
185: , p5_a59 out nocopy JTF_VARCHAR2_TABLE_400
186: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
187: , p5_a61 out nocopy JTF_NUMBER_TABLE
188: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
189: , p5_a63 out nocopy JTF_DATE_TABLE
190: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100

Line 188: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100

184: , p5_a58 out nocopy JTF_VARCHAR2_TABLE_200
185: , p5_a59 out nocopy JTF_VARCHAR2_TABLE_400
186: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
187: , p5_a61 out nocopy JTF_NUMBER_TABLE
188: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
189: , p5_a63 out nocopy JTF_DATE_TABLE
190: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100
191: , p5_a65 out nocopy JTF_NUMBER_TABLE
192: , p5_a66 out nocopy JTF_NUMBER_TABLE

Line 190: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100

186: , p5_a60 out nocopy JTF_VARCHAR2_TABLE_100
187: , p5_a61 out nocopy JTF_NUMBER_TABLE
188: , p5_a62 out nocopy JTF_VARCHAR2_TABLE_100
189: , p5_a63 out nocopy JTF_DATE_TABLE
190: , p5_a64 out nocopy JTF_VARCHAR2_TABLE_100
191: , p5_a65 out nocopy JTF_NUMBER_TABLE
192: , p5_a66 out nocopy JTF_NUMBER_TABLE
193: , p5_a67 out nocopy JTF_NUMBER_TABLE
194: , p5_a68 out nocopy JTF_NUMBER_TABLE

Line 195: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100

191: , p5_a65 out nocopy JTF_NUMBER_TABLE
192: , p5_a66 out nocopy JTF_NUMBER_TABLE
193: , p5_a67 out nocopy JTF_NUMBER_TABLE
194: , p5_a68 out nocopy JTF_NUMBER_TABLE
195: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100
196: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100
197: , p5_a71 out nocopy JTF_NUMBER_TABLE
198: , p5_a72 out nocopy JTF_VARCHAR2_TABLE_4000
199: , p5_a73 out nocopy JTF_DATE_TABLE

Line 196: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100

192: , p5_a66 out nocopy JTF_NUMBER_TABLE
193: , p5_a67 out nocopy JTF_NUMBER_TABLE
194: , p5_a68 out nocopy JTF_NUMBER_TABLE
195: , p5_a69 out nocopy JTF_VARCHAR2_TABLE_100
196: , p5_a70 out nocopy JTF_VARCHAR2_TABLE_100
197: , p5_a71 out nocopy JTF_NUMBER_TABLE
198: , p5_a72 out nocopy JTF_VARCHAR2_TABLE_4000
199: , p5_a73 out nocopy JTF_DATE_TABLE
200: , x_return_status out nocopy VARCHAR2