DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT_W dependencies on JTF_VARCHAR2_TABLE_200

Line 23: , a1 JTF_VARCHAR2_TABLE_200

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p17(t out nocopy okl_am_create_quote_pvt.assn_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: ) as

Line 26: , a4 JTF_VARCHAR2_TABLE_200

22: procedure rosetta_table_copy_in_p17(t out nocopy okl_am_create_quote_pvt.assn_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_200
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_200
27: ) as
28: ddindx binary_integer; indx binary_integer;
29: begin
30: if a0 is not null and a0.count > 0 then

Line 50: , a1 out nocopy JTF_VARCHAR2_TABLE_200

46: end if;
47: end if;
48: end rosetta_table_copy_in_p17;
49: procedure rosetta_table_copy_out_p17(t okl_am_create_quote_pvt.assn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
54: ) as

Line 53: , a4 out nocopy JTF_VARCHAR2_TABLE_200

49: procedure rosetta_table_copy_out_p17(t okl_am_create_quote_pvt.assn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
50: , a1 out nocopy JTF_VARCHAR2_TABLE_200
51: , a2 out nocopy JTF_NUMBER_TABLE
52: , a3 out nocopy JTF_NUMBER_TABLE
53: , a4 out nocopy JTF_VARCHAR2_TABLE_200
54: ) as
55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then

Line 59: a1 := JTF_VARCHAR2_TABLE_200();

55: ddindx binary_integer; indx binary_integer;
56: begin
57: if t is null or t.count = 0 then
58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_200();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_200();
63: else

Line 62: a4 := JTF_VARCHAR2_TABLE_200();

58: a0 := JTF_NUMBER_TABLE();
59: a1 := JTF_VARCHAR2_TABLE_200();
60: a2 := JTF_NUMBER_TABLE();
61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_200();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_NUMBER_TABLE();

Line 65: a1 := JTF_VARCHAR2_TABLE_200();

61: a3 := JTF_NUMBER_TABLE();
62: a4 := JTF_VARCHAR2_TABLE_200();
63: else
64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_NUMBER_TABLE();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: if t.count > 0 then

Line 68: a4 := JTF_VARCHAR2_TABLE_200();

64: a0 := JTF_NUMBER_TABLE();
65: a1 := JTF_VARCHAR2_TABLE_200();
66: a2 := JTF_NUMBER_TABLE();
67: a3 := JTF_NUMBER_TABLE();
68: a4 := JTF_VARCHAR2_TABLE_200();
69: if t.count > 0 then
70: a0.extend(t.count);
71: a1.extend(t.count);
72: a2.extend(t.count);

Line 93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200

89: end if;
90: end if;
91: end rosetta_table_copy_out_p17;
92:
93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_NUMBER_TABLE
96: , a3 JTF_VARCHAR2_TABLE_200
97: , a4 JTF_DATE_TABLE

Line 96: , a3 JTF_VARCHAR2_TABLE_200

92:
93: procedure rosetta_table_copy_in_p19(t out nocopy okl_am_create_quote_pvt.achr_tbl_type, a0 JTF_VARCHAR2_TABLE_200
94: , a1 JTF_VARCHAR2_TABLE_100
95: , a2 JTF_NUMBER_TABLE
96: , a3 JTF_VARCHAR2_TABLE_200
97: , a4 JTF_DATE_TABLE
98: , a5 JTF_DATE_TABLE
99: , a6 JTF_DATE_TABLE
100: , a7 JTF_DATE_TABLE

Line 134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

130: end loop;
131: end if;
132: end if;
133: end rosetta_table_copy_in_p19;
134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: , a2 out nocopy JTF_NUMBER_TABLE
137: , a3 out nocopy JTF_VARCHAR2_TABLE_200
138: , a4 out nocopy JTF_DATE_TABLE

Line 137: , a3 out nocopy JTF_VARCHAR2_TABLE_200

133: end rosetta_table_copy_in_p19;
134: procedure rosetta_table_copy_out_p19(t okl_am_create_quote_pvt.achr_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
135: , a1 out nocopy JTF_VARCHAR2_TABLE_100
136: , a2 out nocopy JTF_NUMBER_TABLE
137: , a3 out nocopy JTF_VARCHAR2_TABLE_200
138: , a4 out nocopy JTF_DATE_TABLE
139: , a5 out nocopy JTF_DATE_TABLE
140: , a6 out nocopy JTF_DATE_TABLE
141: , a7 out nocopy JTF_DATE_TABLE

Line 150: a0 := JTF_VARCHAR2_TABLE_200();

146: ) as
147: ddindx binary_integer; indx binary_integer;
148: begin
149: if t is null or t.count = 0 then
150: a0 := JTF_VARCHAR2_TABLE_200();
151: a1 := JTF_VARCHAR2_TABLE_100();
152: a2 := JTF_NUMBER_TABLE();
153: a3 := JTF_VARCHAR2_TABLE_200();
154: a4 := JTF_DATE_TABLE();

Line 153: a3 := JTF_VARCHAR2_TABLE_200();

149: if t is null or t.count = 0 then
150: a0 := JTF_VARCHAR2_TABLE_200();
151: a1 := JTF_VARCHAR2_TABLE_100();
152: a2 := JTF_NUMBER_TABLE();
153: a3 := JTF_VARCHAR2_TABLE_200();
154: a4 := JTF_DATE_TABLE();
155: a5 := JTF_DATE_TABLE();
156: a6 := JTF_DATE_TABLE();
157: a7 := JTF_DATE_TABLE();

Line 163: a0 := JTF_VARCHAR2_TABLE_200();

159: a9 := JTF_VARCHAR2_TABLE_100();
160: a10 := JTF_NUMBER_TABLE();
161: a11 := JTF_VARCHAR2_TABLE_400();
162: else
163: a0 := JTF_VARCHAR2_TABLE_200();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_VARCHAR2_TABLE_200();
167: a4 := JTF_DATE_TABLE();

Line 166: a3 := JTF_VARCHAR2_TABLE_200();

162: else
163: a0 := JTF_VARCHAR2_TABLE_200();
164: a1 := JTF_VARCHAR2_TABLE_100();
165: a2 := JTF_NUMBER_TABLE();
166: a3 := JTF_VARCHAR2_TABLE_200();
167: a4 := JTF_DATE_TABLE();
168: a5 := JTF_DATE_TABLE();
169: a6 := JTF_DATE_TABLE();
170: a7 := JTF_DATE_TABLE();

Line 218: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200

214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
216: , x_msg_count out nocopy NUMBER
217: , x_msg_data out nocopy VARCHAR2
218: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a2 out nocopy JTF_NUMBER_TABLE
221: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
222: , p6_a4 out nocopy JTF_DATE_TABLE

Line 221: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

217: , x_msg_data out nocopy VARCHAR2
218: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_200
219: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
220: , p6_a2 out nocopy JTF_NUMBER_TABLE
221: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
222: , p6_a4 out nocopy JTF_DATE_TABLE
223: , p6_a5 out nocopy JTF_DATE_TABLE
224: , p6_a6 out nocopy JTF_DATE_TABLE
225: , p6_a7 out nocopy JTF_DATE_TABLE

Line 504: , p6_a1 JTF_VARCHAR2_TABLE_200

500: , x_return_status out nocopy VARCHAR2
501: , x_msg_count out nocopy NUMBER
502: , x_msg_data out nocopy VARCHAR2
503: , p6_a0 JTF_NUMBER_TABLE
504: , p6_a1 JTF_VARCHAR2_TABLE_200
505: , p6_a2 JTF_NUMBER_TABLE
506: , p6_a3 JTF_NUMBER_TABLE
507: , p6_a4 JTF_VARCHAR2_TABLE_200
508: , p7_a0 JTF_NUMBER_TABLE

Line 507: , p6_a4 JTF_VARCHAR2_TABLE_200

503: , p6_a0 JTF_NUMBER_TABLE
504: , p6_a1 JTF_VARCHAR2_TABLE_200
505: , p6_a2 JTF_NUMBER_TABLE
506: , p6_a3 JTF_NUMBER_TABLE
507: , p6_a4 JTF_VARCHAR2_TABLE_200
508: , p7_a0 JTF_NUMBER_TABLE
509: , p7_a1 JTF_NUMBER_TABLE
510: , p7_a2 JTF_NUMBER_TABLE
511: , p7_a3 JTF_NUMBER_TABLE

Line 519: , p7_a11 JTF_VARCHAR2_TABLE_200

515: , p7_a7 JTF_NUMBER_TABLE
516: , p7_a8 JTF_VARCHAR2_TABLE_600
517: , p7_a9 JTF_VARCHAR2_TABLE_100
518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100
522: , p7_a14 JTF_VARCHAR2_TABLE_200
523: , p7_a15 JTF_NUMBER_TABLE

Line 522: , p7_a14 JTF_VARCHAR2_TABLE_200

518: , p7_a10 JTF_VARCHAR2_TABLE_100
519: , p7_a11 JTF_VARCHAR2_TABLE_200
520: , p7_a12 JTF_VARCHAR2_TABLE_100
521: , p7_a13 JTF_VARCHAR2_TABLE_100
522: , p7_a14 JTF_VARCHAR2_TABLE_200
523: , p7_a15 JTF_NUMBER_TABLE
524: , p7_a16 JTF_DATE_TABLE
525: , p7_a17 JTF_NUMBER_TABLE
526: , p7_a18 JTF_DATE_TABLE

Line 619: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000

615: , p9_a4 out nocopy JTF_NUMBER_TABLE
616: , p9_a5 out nocopy JTF_NUMBER_TABLE
617: , p9_a6 out nocopy JTF_NUMBER_TABLE
618: , p9_a7 out nocopy JTF_NUMBER_TABLE
619: , p9_a8 out nocopy JTF_VARCHAR2_TABLE_2000
620: , p9_a9 out nocopy JTF_NUMBER_TABLE
621: , p9_a10 out nocopy JTF_VARCHAR2_TABLE_100
622: , p9_a11 out nocopy JTF_VARCHAR2_TABLE_100
623: , p9_a12 out nocopy JTF_VARCHAR2_TABLE_100

Line 655: , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200

651: , p9_a40 out nocopy JTF_VARCHAR2_TABLE_100
652: , p9_a41 out nocopy JTF_NUMBER_TABLE
653: , p9_a42 out nocopy JTF_VARCHAR2_TABLE_100
654: , p9_a43 out nocopy JTF_VARCHAR2_TABLE_100
655: , p9_a44 out nocopy JTF_VARCHAR2_TABLE_200
656: , p9_a45 out nocopy JTF_NUMBER_TABLE
657: , p9_a46 out nocopy JTF_NUMBER_TABLE
658: , p9_a47 out nocopy JTF_NUMBER_TABLE
659: , p9_a48 out nocopy JTF_NUMBER_TABLE

Line 664: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200

660: , p9_a49 out nocopy JTF_NUMBER_TABLE
661: , p9_a50 out nocopy JTF_NUMBER_TABLE
662: , p9_a51 out nocopy JTF_NUMBER_TABLE
663: , p9_a52 out nocopy JTF_NUMBER_TABLE
664: , p9_a53 out nocopy JTF_VARCHAR2_TABLE_200
665: , p9_a54 out nocopy JTF_VARCHAR2_TABLE_100
666: , p9_a55 out nocopy JTF_VARCHAR2_TABLE_100
667: , p9_a56 out nocopy JTF_VARCHAR2_TABLE_100
668: , p9_a57 out nocopy JTF_NUMBER_TABLE

Line 673: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200

669: , p9_a58 out nocopy JTF_DATE_TABLE
670: , p9_a59 out nocopy JTF_DATE_TABLE
671: , p9_a60 out nocopy JTF_NUMBER_TABLE
672: , p10_a0 out nocopy JTF_NUMBER_TABLE
673: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
674: , p10_a2 out nocopy JTF_NUMBER_TABLE
675: , p10_a3 out nocopy JTF_NUMBER_TABLE
676: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
677: , p5_a0 NUMBER := 0-1962.0724

Line 676: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200

672: , p10_a0 out nocopy JTF_NUMBER_TABLE
673: , p10_a1 out nocopy JTF_VARCHAR2_TABLE_200
674: , p10_a2 out nocopy JTF_NUMBER_TABLE
675: , p10_a3 out nocopy JTF_NUMBER_TABLE
676: , p10_a4 out nocopy JTF_VARCHAR2_TABLE_200
677: , p5_a0 NUMBER := 0-1962.0724
678: , p5_a1 NUMBER := 0-1962.0724
679: , p5_a2 VARCHAR2 := fnd_api.g_miss_char
680: , p5_a3 VARCHAR2 := fnd_api.g_miss_char