DBA Data[Home] [Help]

APPS.OKL_INS_CLAIM_ASSET_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy okl_ins_claim_asset_pvt.stmid_rec_type_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: ) as
25: ddindx binary_integer; indx binary_integer;
26: begin
27: if a0 is not null and a0.count > 0 then

Line 44: , a1 out nocopy JTF_VARCHAR2_TABLE_100

40: end if;
41: end if;
42: end rosetta_table_copy_in_p4;
43: procedure rosetta_table_copy_out_p4(t okl_ins_claim_asset_pvt.stmid_rec_type_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
44: , a1 out nocopy JTF_VARCHAR2_TABLE_100
45: ) as
46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then

Line 50: a1 := JTF_VARCHAR2_TABLE_100();

46: ddindx binary_integer; indx binary_integer;
47: begin
48: if t is null or t.count = 0 then
49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: else
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: if t.count > 0 then

Line 53: a1 := JTF_VARCHAR2_TABLE_100();

49: a0 := JTF_NUMBER_TABLE();
50: a1 := JTF_VARCHAR2_TABLE_100();
51: else
52: a0 := JTF_NUMBER_TABLE();
53: a1 := JTF_VARCHAR2_TABLE_100();
54: if t.count > 0 then
55: a0.extend(t.count);
56: a1.extend(t.count);
57: ddindx := t.first;

Line 81: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100

77: , p5_a0 in out nocopy JTF_NUMBER_TABLE
78: , p5_a1 in out nocopy JTF_NUMBER_TABLE
79: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_300
80: , p5_a3 in out nocopy JTF_NUMBER_TABLE
81: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p5_a7 in out nocopy JTF_DATE_TABLE
85: , p5_a8 in out nocopy JTF_DATE_TABLE

Line 82: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100

78: , p5_a1 in out nocopy JTF_NUMBER_TABLE
79: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_300
80: , p5_a3 in out nocopy JTF_NUMBER_TABLE
81: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p5_a7 in out nocopy JTF_DATE_TABLE
85: , p5_a8 in out nocopy JTF_DATE_TABLE
86: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_2000

Line 83: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100

79: , p5_a2 in out nocopy JTF_VARCHAR2_TABLE_300
80: , p5_a3 in out nocopy JTF_NUMBER_TABLE
81: , p5_a4 in out nocopy JTF_VARCHAR2_TABLE_100
82: , p5_a5 in out nocopy JTF_VARCHAR2_TABLE_100
83: , p5_a6 in out nocopy JTF_VARCHAR2_TABLE_100
84: , p5_a7 in out nocopy JTF_DATE_TABLE
85: , p5_a8 in out nocopy JTF_DATE_TABLE
86: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_2000
87: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300

Line 90: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100

86: , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_2000
87: , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_300
88: , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_300
89: , p5_a12 in out nocopy JTF_NUMBER_TABLE
90: , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_100
91: , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_500
92: , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_500
93: , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_500
94: , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_500

Line 119: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100

115: , p5_a38 in out nocopy JTF_DATE_TABLE
116: , p5_a39 in out nocopy JTF_NUMBER_TABLE
117: , p6_a0 in out nocopy JTF_NUMBER_TABLE
118: , p6_a1 in out nocopy JTF_NUMBER_TABLE
119: , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
120: , p6_a3 in out nocopy JTF_NUMBER_TABLE
121: , p6_a4 in out nocopy JTF_NUMBER_TABLE
122: , p6_a5 in out nocopy JTF_NUMBER_TABLE
123: , p6_a6 in out nocopy JTF_NUMBER_TABLE

Line 125: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100

121: , p6_a4 in out nocopy JTF_NUMBER_TABLE
122: , p6_a5 in out nocopy JTF_NUMBER_TABLE
123: , p6_a6 in out nocopy JTF_NUMBER_TABLE
124: , p6_a7 in out nocopy JTF_DATE_TABLE
125: , p6_a8 in out nocopy JTF_VARCHAR2_TABLE_100
126: , p6_a9 in out nocopy JTF_VARCHAR2_TABLE_500
127: , p6_a10 in out nocopy JTF_VARCHAR2_TABLE_500
128: , p6_a11 in out nocopy JTF_VARCHAR2_TABLE_500
129: , p6_a12 in out nocopy JTF_VARCHAR2_TABLE_500

Line 153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100

149: , p6_a32 in out nocopy JTF_DATE_TABLE
150: , p6_a33 in out nocopy JTF_NUMBER_TABLE
151: , p7_a0 in out nocopy JTF_NUMBER_TABLE
152: , p7_a1 in out nocopy JTF_NUMBER_TABLE
153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100

150: , p6_a33 in out nocopy JTF_NUMBER_TABLE
151: , p7_a0 in out nocopy JTF_NUMBER_TABLE
152: , p7_a1 in out nocopy JTF_NUMBER_TABLE
153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
158: , p7_a7 in out nocopy JTF_NUMBER_TABLE

Line 155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100

151: , p7_a0 in out nocopy JTF_NUMBER_TABLE
152: , p7_a1 in out nocopy JTF_NUMBER_TABLE
153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
158: , p7_a7 in out nocopy JTF_NUMBER_TABLE
159: , p7_a8 in out nocopy JTF_NUMBER_TABLE

Line 156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100

152: , p7_a1 in out nocopy JTF_NUMBER_TABLE
153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
158: , p7_a7 in out nocopy JTF_NUMBER_TABLE
159: , p7_a8 in out nocopy JTF_NUMBER_TABLE
160: , p7_a9 in out nocopy JTF_NUMBER_TABLE

Line 157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100

153: , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a3 in out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a4 in out nocopy JTF_VARCHAR2_TABLE_100
156: , p7_a5 in out nocopy JTF_VARCHAR2_TABLE_100
157: , p7_a6 in out nocopy JTF_VARCHAR2_TABLE_100
158: , p7_a7 in out nocopy JTF_NUMBER_TABLE
159: , p7_a8 in out nocopy JTF_NUMBER_TABLE
160: , p7_a9 in out nocopy JTF_NUMBER_TABLE
161: , p7_a10 in out nocopy JTF_NUMBER_TABLE

Line 168: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100

164: , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_2000
165: , p7_a14 in out nocopy JTF_NUMBER_TABLE
166: , p7_a15 in out nocopy JTF_NUMBER_TABLE
167: , p7_a16 in out nocopy JTF_NUMBER_TABLE
168: , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_100
169: , p7_a18 in out nocopy JTF_DATE_TABLE
170: , p7_a19 in out nocopy JTF_DATE_TABLE
171: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_800
172: , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200

Line 173: , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_100

169: , p7_a18 in out nocopy JTF_DATE_TABLE
170: , p7_a19 in out nocopy JTF_DATE_TABLE
171: , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_800
172: , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
173: , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_100
174: , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_500
175: , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_500
176: , p7_a25 in out nocopy JTF_VARCHAR2_TABLE_500
177: , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_500

Line 199: , p7_a48 in out nocopy JTF_VARCHAR2_TABLE_100

195: , p7_a44 in out nocopy JTF_DATE_TABLE
196: , p7_a45 in out nocopy JTF_NUMBER_TABLE
197: , p7_a46 in out nocopy JTF_DATE_TABLE
198: , p7_a47 in out nocopy JTF_NUMBER_TABLE
199: , p7_a48 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a49 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a50 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a51 in out nocopy JTF_NUMBER_TABLE
203: , p7_a52 in out nocopy JTF_DATE_TABLE

Line 200: , p7_a49 in out nocopy JTF_VARCHAR2_TABLE_100

196: , p7_a45 in out nocopy JTF_NUMBER_TABLE
197: , p7_a46 in out nocopy JTF_DATE_TABLE
198: , p7_a47 in out nocopy JTF_NUMBER_TABLE
199: , p7_a48 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a49 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a50 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a51 in out nocopy JTF_NUMBER_TABLE
203: , p7_a52 in out nocopy JTF_DATE_TABLE
204: )

Line 201: , p7_a50 in out nocopy JTF_VARCHAR2_TABLE_100

197: , p7_a46 in out nocopy JTF_DATE_TABLE
198: , p7_a47 in out nocopy JTF_NUMBER_TABLE
199: , p7_a48 in out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a49 in out nocopy JTF_VARCHAR2_TABLE_100
201: , p7_a50 in out nocopy JTF_VARCHAR2_TABLE_100
202: , p7_a51 in out nocopy JTF_NUMBER_TABLE
203: , p7_a52 in out nocopy JTF_DATE_TABLE
204: )
205:

Line 508: , p5_a1 JTF_VARCHAR2_TABLE_100

504: , x_return_status out nocopy VARCHAR2
505: , x_msg_count out nocopy NUMBER
506: , x_msg_data out nocopy VARCHAR2
507: , p5_a0 JTF_NUMBER_TABLE
508: , p5_a1 JTF_VARCHAR2_TABLE_100
509: )
510:
511: as
512: ddp_lsm_id okl_ins_claim_asset_pvt.stmid_rec_type_tbl_type;