DBA Data[Home] [Help]

APPS.JTF_ATTACHMENT_GRP_W dependencies on JTF_NUMBER_TABLE

Line 22: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE

18: if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 23: , a1 JTF_NUMBER_TABLE

19: return d;
20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100

Line 25: , a3 JTF_NUMBER_TABLE

21:
22: procedure rosetta_table_copy_in_p1(t out jtf_attachment_grp.attachment_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100

Line 30: , a8 JTF_NUMBER_TABLE

26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_100
28: , a6 JTF_VARCHAR2_TABLE_100
29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE

Line 33: , a11 JTF_NUMBER_TABLE

29: , a7 JTF_VARCHAR2_TABLE_100
30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000

Line 34: , a12 JTF_NUMBER_TABLE

30: , a8 JTF_NUMBER_TABLE
31: , a9 JTF_VARCHAR2_TABLE_100
32: , a10 JTF_VARCHAR2_TABLE_300
33: , a11 JTF_NUMBER_TABLE
34: , a12 JTF_NUMBER_TABLE
35: , a13 JTF_VARCHAR2_TABLE_2000
36: , a14 JTF_VARCHAR2_TABLE_2000
37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100

Line 41: , a19 JTF_NUMBER_TABLE

37: , a15 JTF_VARCHAR2_TABLE_2000
38: , a16 JTF_VARCHAR2_TABLE_100
39: , a17 JTF_VARCHAR2_TABLE_100
40: , a18 JTF_VARCHAR2_TABLE_100
41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100
45: , a23 JTF_NUMBER_TABLE

Line 45: , a23 JTF_NUMBER_TABLE

41: , a19 JTF_NUMBER_TABLE
42: , a20 JTF_VARCHAR2_TABLE_2000
43: , a21 JTF_VARCHAR2_TABLE_300
44: , a22 JTF_VARCHAR2_TABLE_1100
45: , a23 JTF_NUMBER_TABLE
46: , a24 JTF_VARCHAR2_TABLE_300
47: , a25 JTF_VARCHAR2_TABLE_100
48: , a26 JTF_VARCHAR2_TABLE_200
49: , a27 JTF_VARCHAR2_TABLE_200

Line 127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE

123: end loop;
124: end if;
125: end if;
126: end rosetta_table_copy_in_p1;
127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100

Line 128: , a1 out JTF_NUMBER_TABLE

124: end if;
125: end if;
126: end rosetta_table_copy_in_p1;
127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100

Line 130: , a3 out JTF_NUMBER_TABLE

126: end rosetta_table_copy_in_p1;
127: procedure rosetta_table_copy_out_p1(t jtf_attachment_grp.attachment_tbl_type, a0 out JTF_NUMBER_TABLE
128: , a1 out JTF_NUMBER_TABLE
129: , a2 out JTF_VARCHAR2_TABLE_300
130: , a3 out JTF_NUMBER_TABLE
131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100

Line 135: , a8 out JTF_NUMBER_TABLE

131: , a4 out JTF_VARCHAR2_TABLE_100
132: , a5 out JTF_VARCHAR2_TABLE_100
133: , a6 out JTF_VARCHAR2_TABLE_100
134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300
138: , a11 out JTF_NUMBER_TABLE
139: , a12 out JTF_NUMBER_TABLE

Line 138: , a11 out JTF_NUMBER_TABLE

134: , a7 out JTF_VARCHAR2_TABLE_100
135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300
138: , a11 out JTF_NUMBER_TABLE
139: , a12 out JTF_NUMBER_TABLE
140: , a13 out JTF_VARCHAR2_TABLE_2000
141: , a14 out JTF_VARCHAR2_TABLE_2000
142: , a15 out JTF_VARCHAR2_TABLE_2000

Line 139: , a12 out JTF_NUMBER_TABLE

135: , a8 out JTF_NUMBER_TABLE
136: , a9 out JTF_VARCHAR2_TABLE_100
137: , a10 out JTF_VARCHAR2_TABLE_300
138: , a11 out JTF_NUMBER_TABLE
139: , a12 out JTF_NUMBER_TABLE
140: , a13 out JTF_VARCHAR2_TABLE_2000
141: , a14 out JTF_VARCHAR2_TABLE_2000
142: , a15 out JTF_VARCHAR2_TABLE_2000
143: , a16 out JTF_VARCHAR2_TABLE_100

Line 146: , a19 out JTF_NUMBER_TABLE

142: , a15 out JTF_VARCHAR2_TABLE_2000
143: , a16 out JTF_VARCHAR2_TABLE_100
144: , a17 out JTF_VARCHAR2_TABLE_100
145: , a18 out JTF_VARCHAR2_TABLE_100
146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100
150: , a23 out JTF_NUMBER_TABLE

Line 150: , a23 out JTF_NUMBER_TABLE

146: , a19 out JTF_NUMBER_TABLE
147: , a20 out JTF_VARCHAR2_TABLE_2000
148: , a21 out JTF_VARCHAR2_TABLE_300
149: , a22 out JTF_VARCHAR2_TABLE_1100
150: , a23 out JTF_NUMBER_TABLE
151: , a24 out JTF_VARCHAR2_TABLE_300
152: , a25 out JTF_VARCHAR2_TABLE_100
153: , a26 out JTF_VARCHAR2_TABLE_200
154: , a27 out JTF_VARCHAR2_TABLE_200

Line 175: a0 := JTF_NUMBER_TABLE();

171: ) as
172: ddindx binary_integer; indx binary_integer;
173: begin
174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();

Line 176: a1 := JTF_NUMBER_TABLE();

172: ddindx binary_integer; indx binary_integer;
173: begin
174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();

Line 178: a3 := JTF_NUMBER_TABLE();

174: if t is null or t.count = 0 then
175: a0 := JTF_NUMBER_TABLE();
176: a1 := JTF_NUMBER_TABLE();
177: a2 := JTF_VARCHAR2_TABLE_300();
178: a3 := JTF_NUMBER_TABLE();
179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();

Line 183: a8 := JTF_NUMBER_TABLE();

179: a4 := JTF_VARCHAR2_TABLE_100();
180: a5 := JTF_VARCHAR2_TABLE_100();
181: a6 := JTF_VARCHAR2_TABLE_100();
182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_NUMBER_TABLE();

Line 186: a11 := JTF_NUMBER_TABLE();

182: a7 := JTF_VARCHAR2_TABLE_100();
183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_NUMBER_TABLE();
188: a13 := JTF_VARCHAR2_TABLE_2000();
189: a14 := JTF_VARCHAR2_TABLE_2000();
190: a15 := JTF_VARCHAR2_TABLE_2000();

Line 187: a12 := JTF_NUMBER_TABLE();

183: a8 := JTF_NUMBER_TABLE();
184: a9 := JTF_VARCHAR2_TABLE_100();
185: a10 := JTF_VARCHAR2_TABLE_300();
186: a11 := JTF_NUMBER_TABLE();
187: a12 := JTF_NUMBER_TABLE();
188: a13 := JTF_VARCHAR2_TABLE_2000();
189: a14 := JTF_VARCHAR2_TABLE_2000();
190: a15 := JTF_VARCHAR2_TABLE_2000();
191: a16 := JTF_VARCHAR2_TABLE_100();

Line 194: a19 := JTF_NUMBER_TABLE();

190: a15 := JTF_VARCHAR2_TABLE_2000();
191: a16 := JTF_VARCHAR2_TABLE_100();
192: a17 := JTF_VARCHAR2_TABLE_100();
193: a18 := JTF_VARCHAR2_TABLE_100();
194: a19 := JTF_NUMBER_TABLE();
195: a20 := JTF_VARCHAR2_TABLE_2000();
196: a21 := JTF_VARCHAR2_TABLE_300();
197: a22 := JTF_VARCHAR2_TABLE_1100();
198: a23 := JTF_NUMBER_TABLE();

Line 198: a23 := JTF_NUMBER_TABLE();

194: a19 := JTF_NUMBER_TABLE();
195: a20 := JTF_VARCHAR2_TABLE_2000();
196: a21 := JTF_VARCHAR2_TABLE_300();
197: a22 := JTF_VARCHAR2_TABLE_1100();
198: a23 := JTF_NUMBER_TABLE();
199: a24 := JTF_VARCHAR2_TABLE_300();
200: a25 := JTF_VARCHAR2_TABLE_100();
201: a26 := JTF_VARCHAR2_TABLE_200();
202: a27 := JTF_VARCHAR2_TABLE_200();

Line 220: a0 := JTF_NUMBER_TABLE();

216: a41 := JTF_VARCHAR2_TABLE_2000();
217: a42 := JTF_VARCHAR2_TABLE_1000();
218: a43 := JTF_VARCHAR2_TABLE_100();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();

Line 221: a1 := JTF_NUMBER_TABLE();

217: a42 := JTF_VARCHAR2_TABLE_1000();
218: a43 := JTF_VARCHAR2_TABLE_100();
219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();

Line 223: a3 := JTF_NUMBER_TABLE();

219: else
220: a0 := JTF_NUMBER_TABLE();
221: a1 := JTF_NUMBER_TABLE();
222: a2 := JTF_VARCHAR2_TABLE_300();
223: a3 := JTF_NUMBER_TABLE();
224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();

Line 228: a8 := JTF_NUMBER_TABLE();

224: a4 := JTF_VARCHAR2_TABLE_100();
225: a5 := JTF_VARCHAR2_TABLE_100();
226: a6 := JTF_VARCHAR2_TABLE_100();
227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_NUMBER_TABLE();

Line 231: a11 := JTF_NUMBER_TABLE();

227: a7 := JTF_VARCHAR2_TABLE_100();
228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_NUMBER_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_VARCHAR2_TABLE_2000();

Line 232: a12 := JTF_NUMBER_TABLE();

228: a8 := JTF_NUMBER_TABLE();
229: a9 := JTF_VARCHAR2_TABLE_100();
230: a10 := JTF_VARCHAR2_TABLE_300();
231: a11 := JTF_NUMBER_TABLE();
232: a12 := JTF_NUMBER_TABLE();
233: a13 := JTF_VARCHAR2_TABLE_2000();
234: a14 := JTF_VARCHAR2_TABLE_2000();
235: a15 := JTF_VARCHAR2_TABLE_2000();
236: a16 := JTF_VARCHAR2_TABLE_100();

Line 239: a19 := JTF_NUMBER_TABLE();

235: a15 := JTF_VARCHAR2_TABLE_2000();
236: a16 := JTF_VARCHAR2_TABLE_100();
237: a17 := JTF_VARCHAR2_TABLE_100();
238: a18 := JTF_VARCHAR2_TABLE_100();
239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();
243: a23 := JTF_NUMBER_TABLE();

Line 243: a23 := JTF_NUMBER_TABLE();

239: a19 := JTF_NUMBER_TABLE();
240: a20 := JTF_VARCHAR2_TABLE_2000();
241: a21 := JTF_VARCHAR2_TABLE_300();
242: a22 := JTF_VARCHAR2_TABLE_1100();
243: a23 := JTF_NUMBER_TABLE();
244: a24 := JTF_VARCHAR2_TABLE_300();
245: a25 := JTF_VARCHAR2_TABLE_100();
246: a26 := JTF_VARCHAR2_TABLE_200();
247: a27 := JTF_VARCHAR2_TABLE_200();

Line 366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE

362: end if;
363: end if;
364: end rosetta_table_copy_out_p1;
365:
366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_VARCHAR2_TABLE_300
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_VARCHAR2_TABLE_100
370: ) as

Line 368: , a2 JTF_NUMBER_TABLE

364: end rosetta_table_copy_out_p1;
365:
366: procedure rosetta_table_copy_in_p3(t out jtf_attachment_grp.ath_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
367: , a1 JTF_VARCHAR2_TABLE_300
368: , a2 JTF_NUMBER_TABLE
369: , a3 JTF_VARCHAR2_TABLE_100
370: ) as
371: ddindx binary_integer; indx binary_integer;
372: begin

Line 391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE

387: end loop;
388: end if;
389: end if;
390: end rosetta_table_copy_in_p3;
391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
392: , a1 out JTF_VARCHAR2_TABLE_300
393: , a2 out JTF_NUMBER_TABLE
394: , a3 out JTF_VARCHAR2_TABLE_100
395: ) as

Line 393: , a2 out JTF_NUMBER_TABLE

389: end if;
390: end rosetta_table_copy_in_p3;
391: procedure rosetta_table_copy_out_p3(t jtf_attachment_grp.ath_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
392: , a1 out JTF_VARCHAR2_TABLE_300
393: , a2 out JTF_NUMBER_TABLE
394: , a3 out JTF_VARCHAR2_TABLE_100
395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin

Line 399: a0 := JTF_NUMBER_TABLE();

395: ) as
396: ddindx binary_integer; indx binary_integer;
397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else

Line 401: a2 := JTF_NUMBER_TABLE();

397: begin
398: if t is null or t.count = 0 then
399: a0 := JTF_NUMBER_TABLE();
400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();

Line 404: a0 := JTF_NUMBER_TABLE();

400: a1 := JTF_VARCHAR2_TABLE_300();
401: a2 := JTF_NUMBER_TABLE();
402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();
406: a2 := JTF_NUMBER_TABLE();
407: a3 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then

Line 406: a2 := JTF_NUMBER_TABLE();

402: a3 := JTF_VARCHAR2_TABLE_100();
403: else
404: a0 := JTF_NUMBER_TABLE();
405: a1 := JTF_VARCHAR2_TABLE_300();
406: a2 := JTF_NUMBER_TABLE();
407: a3 := JTF_VARCHAR2_TABLE_100();
408: if t.count > 0 then
409: a0.extend(t.count);
410: a1.extend(t.count);

Line 430: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as

426: end if;
427: end if;
428: end rosetta_table_copy_out_p3;
429:
430: procedure rosetta_table_copy_in_p4(t out jtf_attachment_grp.number_table, a0 JTF_NUMBER_TABLE) as
431: ddindx binary_integer; indx binary_integer;
432: begin
433: if a0 is null then
434: t := null;

Line 454: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE) as

450: end loop;
451: end if;
452: end if;
453: end rosetta_table_copy_in_p4;
454: procedure rosetta_table_copy_out_p4(t jtf_attachment_grp.number_table, a0 out JTF_NUMBER_TABLE) as
455: ddindx binary_integer; indx binary_integer;
456: begin
457: if t is null then
458: a0 := null;

Line 460: a0 := JTF_NUMBER_TABLE();

456: begin
457: if t is null then
458: a0 := null;
459: elsif t.count = 0 then
460: a0 := JTF_NUMBER_TABLE();
461: else
462: a0 := JTF_NUMBER_TABLE();
463: if t.count > 0 then
464: a0.extend(t.count);

Line 462: a0 := JTF_NUMBER_TABLE();

458: a0 := null;
459: elsif t.count = 0 then
460: a0 := JTF_NUMBER_TABLE();
461: else
462: a0 := JTF_NUMBER_TABLE();
463: if t.count > 0 then
464: a0.extend(t.count);
465: ddindx := t.first;
466: indx := 1;

Line 587: , x_ath_id_tbl out JTF_NUMBER_TABLE

583: , p_deliverable_id NUMBER
584: , p_start_id NUMBER
585: , p_batch_size NUMBER
586: , x_row_count out NUMBER
587: , x_ath_id_tbl out JTF_NUMBER_TABLE
588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100

Line 588: , x_dlv_id_tbl out JTF_NUMBER_TABLE

584: , p_start_id NUMBER
585: , p_batch_size NUMBER
586: , x_row_count out NUMBER
587: , x_ath_id_tbl out JTF_NUMBER_TABLE
588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE

Line 590: , x_file_id_tbl out JTF_NUMBER_TABLE

586: , x_row_count out NUMBER
587: , x_ath_id_tbl out JTF_NUMBER_TABLE
588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE

Line 592: , x_dsp_width_tbl out JTF_NUMBER_TABLE

588: , x_dlv_id_tbl out JTF_NUMBER_TABLE
589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE
595: )
596: as

Line 593: , x_dsp_height_tbl out JTF_NUMBER_TABLE

589: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE
595: )
596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;

Line 594: , x_version_tbl out JTF_NUMBER_TABLE

590: , x_file_id_tbl out JTF_NUMBER_TABLE
591: , x_file_ext_tbl out JTF_VARCHAR2_TABLE_100
592: , x_dsp_width_tbl out JTF_NUMBER_TABLE
593: , x_dsp_height_tbl out JTF_NUMBER_TABLE
594: , x_version_tbl out JTF_NUMBER_TABLE
595: )
596: as
597: ddx_ath_id_tbl jtf_attachment_grp.number_table;
598: ddx_dlv_id_tbl jtf_attachment_grp.number_table;

Line 851: , p6_a0 in out JTF_NUMBER_TABLE

847: , p_commit VARCHAR2
848: , x_return_status out VARCHAR2
849: , x_msg_count out NUMBER
850: , x_msg_data out VARCHAR2
851: , p6_a0 in out JTF_NUMBER_TABLE
852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100

Line 852: , p6_a1 in out JTF_NUMBER_TABLE

848: , x_return_status out VARCHAR2
849: , x_msg_count out NUMBER
850: , x_msg_data out VARCHAR2
851: , p6_a0 in out JTF_NUMBER_TABLE
852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100

Line 854: , p6_a3 in out JTF_NUMBER_TABLE

850: , x_msg_data out VARCHAR2
851: , p6_a0 in out JTF_NUMBER_TABLE
852: , p6_a1 in out JTF_NUMBER_TABLE
853: , p6_a2 in out JTF_VARCHAR2_TABLE_300
854: , p6_a3 in out JTF_NUMBER_TABLE
855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100

Line 859: , p6_a8 in out JTF_NUMBER_TABLE

855: , p6_a4 in out JTF_VARCHAR2_TABLE_100
856: , p6_a5 in out JTF_VARCHAR2_TABLE_100
857: , p6_a6 in out JTF_VARCHAR2_TABLE_100
858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE
863: , p6_a12 in out JTF_NUMBER_TABLE

Line 862: , p6_a11 in out JTF_NUMBER_TABLE

858: , p6_a7 in out JTF_VARCHAR2_TABLE_100
859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE
863: , p6_a12 in out JTF_NUMBER_TABLE
864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000
866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000

Line 863: , p6_a12 in out JTF_NUMBER_TABLE

859: , p6_a8 in out JTF_NUMBER_TABLE
860: , p6_a9 in out JTF_VARCHAR2_TABLE_100
861: , p6_a10 in out JTF_VARCHAR2_TABLE_300
862: , p6_a11 in out JTF_NUMBER_TABLE
863: , p6_a12 in out JTF_NUMBER_TABLE
864: , p6_a13 in out JTF_VARCHAR2_TABLE_2000
865: , p6_a14 in out JTF_VARCHAR2_TABLE_2000
866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000
867: , p6_a16 in out JTF_VARCHAR2_TABLE_100

Line 870: , p6_a19 in out JTF_NUMBER_TABLE

866: , p6_a15 in out JTF_VARCHAR2_TABLE_2000
867: , p6_a16 in out JTF_VARCHAR2_TABLE_100
868: , p6_a17 in out JTF_VARCHAR2_TABLE_100
869: , p6_a18 in out JTF_VARCHAR2_TABLE_100
870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
874: , p6_a23 in out JTF_NUMBER_TABLE

Line 874: , p6_a23 in out JTF_NUMBER_TABLE

870: , p6_a19 in out JTF_NUMBER_TABLE
871: , p6_a20 in out JTF_VARCHAR2_TABLE_2000
872: , p6_a21 in out JTF_VARCHAR2_TABLE_300
873: , p6_a22 in out JTF_VARCHAR2_TABLE_1100
874: , p6_a23 in out JTF_NUMBER_TABLE
875: , p6_a24 in out JTF_VARCHAR2_TABLE_300
876: , p6_a25 in out JTF_VARCHAR2_TABLE_100
877: , p6_a26 in out JTF_VARCHAR2_TABLE_200
878: , p6_a27 in out JTF_VARCHAR2_TABLE_200

Line 1023: , p6_a0 in out JTF_NUMBER_TABLE

1019: , p_commit VARCHAR2
1020: , x_return_status out VARCHAR2
1021: , x_msg_count out NUMBER
1022: , x_msg_data out VARCHAR2
1023: , p6_a0 in out JTF_NUMBER_TABLE
1024: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1025: , p6_a2 in out JTF_NUMBER_TABLE
1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1027: )

Line 1025: , p6_a2 in out JTF_NUMBER_TABLE

1021: , x_msg_count out NUMBER
1022: , x_msg_data out VARCHAR2
1023: , p6_a0 in out JTF_NUMBER_TABLE
1024: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1025: , p6_a2 in out JTF_NUMBER_TABLE
1026: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1027: )
1028: as
1029: ddp_ath_id_ver_tbl jtf_attachment_grp.ath_id_ver_tbl_type;