DBA Data[Home] [Help]

APPS.JTF_DELIVERABLE_GRP_W dependencies on JTF_VARCHAR2_TABLE_300

Line 24: , a2 JTF_VARCHAR2_TABLE_300

20: end;
21:
22: procedure rosetta_table_copy_in_p1(t out jtf_deliverable_grp.deliverable_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_2000

Line 27: , a5 JTF_VARCHAR2_TABLE_300

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_300
25: , a3 JTF_VARCHAR2_TABLE_100
26: , a4 JTF_VARCHAR2_TABLE_100
27: , a5 JTF_VARCHAR2_TABLE_300
28: , a6 JTF_VARCHAR2_TABLE_2000
29: , a7 JTF_NUMBER_TABLE
30: , a8 JTF_VARCHAR2_TABLE_100
31: ) as

Line 59: , a2 out JTF_VARCHAR2_TABLE_300

55: end if;
56: end rosetta_table_copy_in_p1;
57: procedure rosetta_table_copy_out_p1(t jtf_deliverable_grp.deliverable_tbl_type, a0 out JTF_NUMBER_TABLE
58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300
63: , a6 out JTF_VARCHAR2_TABLE_2000

Line 62: , a5 out JTF_VARCHAR2_TABLE_300

58: , a1 out JTF_VARCHAR2_TABLE_100
59: , a2 out JTF_VARCHAR2_TABLE_300
60: , a3 out JTF_VARCHAR2_TABLE_100
61: , a4 out JTF_VARCHAR2_TABLE_100
62: , a5 out JTF_VARCHAR2_TABLE_300
63: , a6 out JTF_VARCHAR2_TABLE_2000
64: , a7 out JTF_NUMBER_TABLE
65: , a8 out JTF_VARCHAR2_TABLE_100
66: ) as

Line 72: a2 := JTF_VARCHAR2_TABLE_300();

68: begin
69: if t is null or t.count = 0 then
70: a0 := JTF_NUMBER_TABLE();
71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_300();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_2000();

Line 75: a5 := JTF_VARCHAR2_TABLE_300();

71: a1 := JTF_VARCHAR2_TABLE_100();
72: a2 := JTF_VARCHAR2_TABLE_300();
73: a3 := JTF_VARCHAR2_TABLE_100();
74: a4 := JTF_VARCHAR2_TABLE_100();
75: a5 := JTF_VARCHAR2_TABLE_300();
76: a6 := JTF_VARCHAR2_TABLE_2000();
77: a7 := JTF_NUMBER_TABLE();
78: a8 := JTF_VARCHAR2_TABLE_100();
79: else

Line 82: a2 := JTF_VARCHAR2_TABLE_300();

78: a8 := JTF_VARCHAR2_TABLE_100();
79: else
80: a0 := JTF_NUMBER_TABLE();
81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_300();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_300();
86: a6 := JTF_VARCHAR2_TABLE_2000();

Line 85: a5 := JTF_VARCHAR2_TABLE_300();

81: a1 := JTF_VARCHAR2_TABLE_100();
82: a2 := JTF_VARCHAR2_TABLE_300();
83: a3 := JTF_VARCHAR2_TABLE_100();
84: a4 := JTF_VARCHAR2_TABLE_100();
85: a5 := JTF_VARCHAR2_TABLE_300();
86: a6 := JTF_VARCHAR2_TABLE_2000();
87: a7 := JTF_NUMBER_TABLE();
88: a8 := JTF_VARCHAR2_TABLE_100();
89: if t.count > 0 then

Line 123: , a2 JTF_VARCHAR2_TABLE_300

119: end rosetta_table_copy_out_p1;
120:
121: procedure rosetta_table_copy_in_p3(t out jtf_deliverable_grp.dlv_ath_tbl_type, a0 JTF_NUMBER_TABLE
122: , a1 JTF_VARCHAR2_TABLE_100
123: , a2 JTF_VARCHAR2_TABLE_300
124: , a3 JTF_VARCHAR2_TABLE_100
125: , a4 JTF_VARCHAR2_TABLE_100
126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000

Line 126: , a5 JTF_VARCHAR2_TABLE_300

122: , a1 JTF_VARCHAR2_TABLE_100
123: , a2 JTF_VARCHAR2_TABLE_300
124: , a3 JTF_VARCHAR2_TABLE_100
125: , a4 JTF_VARCHAR2_TABLE_100
126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000
128: , a7 JTF_NUMBER_TABLE
129: , a8 JTF_VARCHAR2_TABLE_100
130: , a9 JTF_VARCHAR2_TABLE_300

Line 130: , a9 JTF_VARCHAR2_TABLE_300

126: , a5 JTF_VARCHAR2_TABLE_300
127: , a6 JTF_VARCHAR2_TABLE_2000
128: , a7 JTF_NUMBER_TABLE
129: , a8 JTF_VARCHAR2_TABLE_100
130: , a9 JTF_VARCHAR2_TABLE_300
131: , a10 JTF_NUMBER_TABLE
132: , a11 JTF_VARCHAR2_TABLE_100
133: ) as
134: ddindx binary_integer; indx binary_integer;

Line 164: , a2 out JTF_VARCHAR2_TABLE_300

160: end if;
161: end rosetta_table_copy_in_p3;
162: procedure rosetta_table_copy_out_p3(t jtf_deliverable_grp.dlv_ath_tbl_type, a0 out JTF_NUMBER_TABLE
163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000

Line 167: , a5 out JTF_VARCHAR2_TABLE_300

163: , a1 out JTF_VARCHAR2_TABLE_100
164: , a2 out JTF_VARCHAR2_TABLE_300
165: , a3 out JTF_VARCHAR2_TABLE_100
166: , a4 out JTF_VARCHAR2_TABLE_100
167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000
169: , a7 out JTF_NUMBER_TABLE
170: , a8 out JTF_VARCHAR2_TABLE_100
171: , a9 out JTF_VARCHAR2_TABLE_300

Line 171: , a9 out JTF_VARCHAR2_TABLE_300

167: , a5 out JTF_VARCHAR2_TABLE_300
168: , a6 out JTF_VARCHAR2_TABLE_2000
169: , a7 out JTF_NUMBER_TABLE
170: , a8 out JTF_VARCHAR2_TABLE_100
171: , a9 out JTF_VARCHAR2_TABLE_300
172: , a10 out JTF_NUMBER_TABLE
173: , a11 out JTF_VARCHAR2_TABLE_100
174: ) as
175: ddindx binary_integer; indx binary_integer;

Line 180: a2 := JTF_VARCHAR2_TABLE_300();

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

Line 183: a5 := JTF_VARCHAR2_TABLE_300();

179: a1 := JTF_VARCHAR2_TABLE_100();
180: a2 := JTF_VARCHAR2_TABLE_300();
181: a3 := JTF_VARCHAR2_TABLE_100();
182: a4 := JTF_VARCHAR2_TABLE_100();
183: a5 := JTF_VARCHAR2_TABLE_300();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_300();

Line 187: a9 := JTF_VARCHAR2_TABLE_300();

183: a5 := JTF_VARCHAR2_TABLE_300();
184: a6 := JTF_VARCHAR2_TABLE_2000();
185: a7 := JTF_NUMBER_TABLE();
186: a8 := JTF_VARCHAR2_TABLE_100();
187: a9 := JTF_VARCHAR2_TABLE_300();
188: a10 := JTF_NUMBER_TABLE();
189: a11 := JTF_VARCHAR2_TABLE_100();
190: else
191: a0 := JTF_NUMBER_TABLE();

Line 193: a2 := JTF_VARCHAR2_TABLE_300();

189: a11 := JTF_VARCHAR2_TABLE_100();
190: else
191: a0 := JTF_NUMBER_TABLE();
192: a1 := JTF_VARCHAR2_TABLE_100();
193: a2 := JTF_VARCHAR2_TABLE_300();
194: a3 := JTF_VARCHAR2_TABLE_100();
195: a4 := JTF_VARCHAR2_TABLE_100();
196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();

Line 196: a5 := JTF_VARCHAR2_TABLE_300();

192: a1 := JTF_VARCHAR2_TABLE_100();
193: a2 := JTF_VARCHAR2_TABLE_300();
194: a3 := JTF_VARCHAR2_TABLE_100();
195: a4 := JTF_VARCHAR2_TABLE_100();
196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();
198: a7 := JTF_NUMBER_TABLE();
199: a8 := JTF_VARCHAR2_TABLE_100();
200: a9 := JTF_VARCHAR2_TABLE_300();

Line 200: a9 := JTF_VARCHAR2_TABLE_300();

196: a5 := JTF_VARCHAR2_TABLE_300();
197: a6 := JTF_VARCHAR2_TABLE_2000();
198: a7 := JTF_NUMBER_TABLE();
199: a8 := JTF_VARCHAR2_TABLE_100();
200: a9 := JTF_VARCHAR2_TABLE_300();
201: a10 := JTF_NUMBER_TABLE();
202: a11 := JTF_VARCHAR2_TABLE_100();
203: if t.count > 0 then
204: a0.extend(t.count);

Line 242: , a1 JTF_VARCHAR2_TABLE_300

238: end if;
239: end rosetta_table_copy_out_p3;
240:
241: procedure rosetta_table_copy_in_p5(t out jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 JTF_NUMBER_TABLE
242: , a1 JTF_VARCHAR2_TABLE_300
243: , a2 JTF_NUMBER_TABLE
244: , a3 JTF_VARCHAR2_TABLE_100
245: ) as
246: ddindx binary_integer; indx binary_integer;

Line 267: , a1 out JTF_VARCHAR2_TABLE_300

263: end if;
264: end if;
265: end rosetta_table_copy_in_p5;
266: procedure rosetta_table_copy_out_p5(t jtf_deliverable_grp.dlv_id_ver_tbl_type, a0 out JTF_NUMBER_TABLE
267: , a1 out JTF_VARCHAR2_TABLE_300
268: , a2 out JTF_NUMBER_TABLE
269: , a3 out JTF_VARCHAR2_TABLE_100
270: ) as
271: ddindx binary_integer; indx binary_integer;

Line 275: a1 := JTF_VARCHAR2_TABLE_300();

271: ddindx binary_integer; indx binary_integer;
272: begin
273: if t is null or t.count = 0 then
274: a0 := JTF_NUMBER_TABLE();
275: a1 := JTF_VARCHAR2_TABLE_300();
276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_VARCHAR2_TABLE_100();
278: else
279: a0 := JTF_NUMBER_TABLE();

Line 280: a1 := JTF_VARCHAR2_TABLE_300();

276: a2 := JTF_NUMBER_TABLE();
277: a3 := JTF_VARCHAR2_TABLE_100();
278: else
279: a0 := JTF_NUMBER_TABLE();
280: a1 := JTF_VARCHAR2_TABLE_300();
281: a2 := JTF_NUMBER_TABLE();
282: a3 := JTF_VARCHAR2_TABLE_100();
283: if t.count > 0 then
284: a0.extend(t.count);

Line 403: procedure rosetta_table_copy_in_p8(t out jtf_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as

399: end if;
400: end if;
401: end rosetta_table_copy_out_p7;
402:
403: procedure rosetta_table_copy_in_p8(t out jtf_deliverable_grp.varchar2_table_300, a0 JTF_VARCHAR2_TABLE_300) as
404: ddindx binary_integer; indx binary_integer;
405: begin
406: if a0 is null then
407: t := null;

Line 427: procedure rosetta_table_copy_out_p8(t jtf_deliverable_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as

423: end loop;
424: end if;
425: end if;
426: end rosetta_table_copy_in_p8;
427: procedure rosetta_table_copy_out_p8(t jtf_deliverable_grp.varchar2_table_300, a0 out JTF_VARCHAR2_TABLE_300) as
428: ddindx binary_integer; indx binary_integer;
429: begin
430: if t is null then
431: a0 := null;

Line 433: a0 := JTF_VARCHAR2_TABLE_300();

429: begin
430: if t is null then
431: a0 := null;
432: elsif t.count = 0 then
433: a0 := JTF_VARCHAR2_TABLE_300();
434: else
435: a0 := JTF_VARCHAR2_TABLE_300();
436: if t.count > 0 then
437: a0.extend(t.count);

Line 435: a0 := JTF_VARCHAR2_TABLE_300();

431: a0 := null;
432: elsif t.count = 0 then
433: a0 := JTF_VARCHAR2_TABLE_300();
434: else
435: a0 := JTF_VARCHAR2_TABLE_300();
436: if t.count > 0 then
437: a0.extend(t.count);
438: ddindx := t.first;
439: indx := 1;

Line 515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300

511: , p_batch_size NUMBER
512: , x_row_count out NUMBER
513: , x_dlv_id_tbl out JTF_NUMBER_TABLE
514: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000

Line 518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300

514: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
515: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
516: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out JTF_NUMBER_TABLE
521: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
522: , x_file_id_tbl out JTF_NUMBER_TABLE

Line 521: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

517: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
518: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
519: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
520: , x_version_tbl out JTF_NUMBER_TABLE
521: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
522: , x_file_id_tbl out JTF_NUMBER_TABLE
523: )
524: as
525: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;

Line 634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300

630: , p_batch_size NUMBER
631: , x_row_count out NUMBER
632: , x_dlv_id_tbl out JTF_NUMBER_TABLE
633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
638: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000

Line 637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300

633: , x_acc_name_tbl out JTF_VARCHAR2_TABLE_100
634: , x_dsp_name_tbl out JTF_VARCHAR2_TABLE_300
635: , x_item_type_tbl out JTF_VARCHAR2_TABLE_100
636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
638: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
639: , x_version_tbl out JTF_NUMBER_TABLE
640: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
641: , x_file_id_tbl out JTF_NUMBER_TABLE

Line 640: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300

636: , x_appl_to_tbl out JTF_VARCHAR2_TABLE_100
637: , x_keyword_tbl out JTF_VARCHAR2_TABLE_300
638: , x_desc_tbl out JTF_VARCHAR2_TABLE_2000
639: , x_version_tbl out JTF_NUMBER_TABLE
640: , x_file_name_tbl out JTF_VARCHAR2_TABLE_300
641: , x_file_id_tbl out JTF_NUMBER_TABLE
642: )
643: as
644: ddx_dlv_id_tbl jtf_deliverable_grp.number_table;

Line 814: , p6_a2 in out JTF_VARCHAR2_TABLE_300

810: , x_msg_count out NUMBER
811: , x_msg_data out VARCHAR2
812: , p6_a0 in out JTF_NUMBER_TABLE
813: , p6_a1 in out JTF_VARCHAR2_TABLE_100
814: , p6_a2 in out JTF_VARCHAR2_TABLE_300
815: , p6_a3 in out JTF_VARCHAR2_TABLE_100
816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300
818: , p6_a6 in out JTF_VARCHAR2_TABLE_2000

Line 817: , p6_a5 in out JTF_VARCHAR2_TABLE_300

813: , p6_a1 in out JTF_VARCHAR2_TABLE_100
814: , p6_a2 in out JTF_VARCHAR2_TABLE_300
815: , p6_a3 in out JTF_VARCHAR2_TABLE_100
816: , p6_a4 in out JTF_VARCHAR2_TABLE_100
817: , p6_a5 in out JTF_VARCHAR2_TABLE_300
818: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
819: , p6_a7 in out JTF_NUMBER_TABLE
820: , p6_a8 in out JTF_VARCHAR2_TABLE_100
821: )

Line 955: , p6_a2 in out JTF_VARCHAR2_TABLE_300

951: , x_msg_count out NUMBER
952: , x_msg_data out VARCHAR2
953: , p6_a0 in out JTF_NUMBER_TABLE
954: , p6_a1 in out JTF_VARCHAR2_TABLE_100
955: , p6_a2 in out JTF_VARCHAR2_TABLE_300
956: , p6_a3 in out JTF_VARCHAR2_TABLE_100
957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000

Line 958: , p6_a5 in out JTF_VARCHAR2_TABLE_300

954: , p6_a1 in out JTF_VARCHAR2_TABLE_100
955: , p6_a2 in out JTF_VARCHAR2_TABLE_300
956: , p6_a3 in out JTF_VARCHAR2_TABLE_100
957: , p6_a4 in out JTF_VARCHAR2_TABLE_100
958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
960: , p6_a7 in out JTF_NUMBER_TABLE
961: , p6_a8 in out JTF_VARCHAR2_TABLE_100
962: , p6_a9 in out JTF_VARCHAR2_TABLE_300

Line 962: , p6_a9 in out JTF_VARCHAR2_TABLE_300

958: , p6_a5 in out JTF_VARCHAR2_TABLE_300
959: , p6_a6 in out JTF_VARCHAR2_TABLE_2000
960: , p6_a7 in out JTF_NUMBER_TABLE
961: , p6_a8 in out JTF_VARCHAR2_TABLE_100
962: , p6_a9 in out JTF_VARCHAR2_TABLE_300
963: , p6_a10 in out JTF_NUMBER_TABLE
964: , p6_a11 in out JTF_VARCHAR2_TABLE_100
965: )
966: as

Line 1030: , p6_a1 in out JTF_VARCHAR2_TABLE_300

1026: , x_return_status out VARCHAR2
1027: , x_msg_count out NUMBER
1028: , x_msg_data out VARCHAR2
1029: , p6_a0 in out JTF_NUMBER_TABLE
1030: , p6_a1 in out JTF_VARCHAR2_TABLE_300
1031: , p6_a2 in out JTF_NUMBER_TABLE
1032: , p6_a3 in out JTF_VARCHAR2_TABLE_100
1033: )
1034: as