APPS.OKL_MASS_REBOOK_PUB_W dependencies on JTF_VARCHAR2_TABLE_200

Line 24: , a2 JTF_VARCHAR2_TABLE_200

20: end;
21:
22: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: ) as

Line 25: , a3 JTF_VARCHAR2_TABLE_200

21:
22: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: ) as
29: ddindx binary_integer; indx binary_integer;

Line 26: , a4 JTF_VARCHAR2_TABLE_200

22: procedure rosetta_table_copy_in_p16(t out nocopy okl_mass_rebook_pub.crit_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin

Line 27: , a5 JTF_VARCHAR2_TABLE_200

23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_200
26: , a4 JTF_VARCHAR2_TABLE_200
27: , a5 JTF_VARCHAR2_TABLE_200
28: ) as
29: ddindx binary_integer; indx binary_integer;
30: begin
31: if a0 is not null and a0.count > 0 then

Line 53: , a2 out nocopy JTF_VARCHAR2_TABLE_200

49: end if;
50: end rosetta_table_copy_in_p16;
51: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , a4 out nocopy JTF_VARCHAR2_TABLE_200
56: , a5 out nocopy JTF_VARCHAR2_TABLE_200
57: ) as

Line 54: , a3 out nocopy JTF_VARCHAR2_TABLE_200

50: end rosetta_table_copy_in_p16;
51: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , a4 out nocopy JTF_VARCHAR2_TABLE_200
56: , a5 out nocopy JTF_VARCHAR2_TABLE_200
57: ) as
58: ddindx binary_integer; indx binary_integer;

Line 55: , a4 out nocopy JTF_VARCHAR2_TABLE_200

51: procedure rosetta_table_copy_out_p16(t okl_mass_rebook_pub.crit_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , a4 out nocopy JTF_VARCHAR2_TABLE_200
56: , a5 out nocopy JTF_VARCHAR2_TABLE_200
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin

Line 56: , a5 out nocopy JTF_VARCHAR2_TABLE_200

52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_200
55: , a4 out nocopy JTF_VARCHAR2_TABLE_200
56: , a5 out nocopy JTF_VARCHAR2_TABLE_200
57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then

Line 63: a2 := JTF_VARCHAR2_TABLE_200();

59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();
66: a5 := JTF_VARCHAR2_TABLE_200();
67: else

Line 64: a3 := JTF_VARCHAR2_TABLE_200();

60: if t is null or t.count = 0 then
61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();
66: a5 := JTF_VARCHAR2_TABLE_200();
67: else
68: a0 := JTF_NUMBER_TABLE();

Line 65: a4 := JTF_VARCHAR2_TABLE_200();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();
66: a5 := JTF_VARCHAR2_TABLE_200();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := JTF_VARCHAR2_TABLE_200();

62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_200();
65: a4 := JTF_VARCHAR2_TABLE_200();
66: a5 := JTF_VARCHAR2_TABLE_200();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();

Line 70: a2 := JTF_VARCHAR2_TABLE_200();

66: a5 := JTF_VARCHAR2_TABLE_200();
67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_200();
72: a4 := JTF_VARCHAR2_TABLE_200();
73: a5 := JTF_VARCHAR2_TABLE_200();
74: if t.count > 0 then

Line 71: a3 := JTF_VARCHAR2_TABLE_200();

67: else
68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_200();
72: a4 := JTF_VARCHAR2_TABLE_200();
73: a5 := JTF_VARCHAR2_TABLE_200();
74: if t.count > 0 then
75: a0.extend(t.count);

Line 72: a4 := JTF_VARCHAR2_TABLE_200();

68: a0 := JTF_NUMBER_TABLE();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_200();
72: a4 := JTF_VARCHAR2_TABLE_200();
73: a5 := JTF_VARCHAR2_TABLE_200();
74: if t.count > 0 then
75: a0.extend(t.count);
76: a1.extend(t.count);

Line 73: a5 := JTF_VARCHAR2_TABLE_200();

69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_200();
72: a4 := JTF_VARCHAR2_TABLE_200();
73: a5 := JTF_VARCHAR2_TABLE_200();
74: if t.count > 0 then
75: a0.extend(t.count);
76: a1.extend(t.count);
77: a2.extend(t.count);

Line 115: , p6_a9 JTF_VARCHAR2_TABLE_2000

111: , p6_a5 JTF_VARCHAR2_TABLE_100
112: , p6_a6 JTF_VARCHAR2_TABLE_600
113: , p6_a7 JTF_VARCHAR2_TABLE_600
114: , p6_a8 JTF_VARCHAR2_TABLE_600
115: , p6_a9 JTF_VARCHAR2_TABLE_2000
116: , p6_a10 JTF_VARCHAR2_TABLE_100
117: , p6_a11 JTF_VARCHAR2_TABLE_100
118: , p6_a12 JTF_VARCHAR2_TABLE_500
119: , p6_a13 JTF_VARCHAR2_TABLE_500

Line 139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200

135: , p6_a29 JTF_NUMBER_TABLE
136: , p6_a30 JTF_DATE_TABLE
137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
143: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200

137: , p6_a31 JTF_NUMBER_TABLE
138: , p7_a0 out nocopy JTF_NUMBER_TABLE
139: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_200
140: , p7_a2 out nocopy JTF_NUMBER_TABLE
141: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_200
142: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_600
143: , p7_a5 out nocopy JTF_NUMBER_TABLE
144: , p7_a6 out nocopy JTF_NUMBER_TABLE
145: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 281: , p5_a1 JTF_VARCHAR2_TABLE_200

277: , x_return_status out nocopy VARCHAR2
278: , x_msg_count out nocopy NUMBER
279: , x_msg_data out nocopy VARCHAR2
280: , p5_a0 JTF_NUMBER_TABLE
281: , p5_a1 JTF_VARCHAR2_TABLE_200
282: , p5_a2 JTF_NUMBER_TABLE
283: , p5_a3 JTF_VARCHAR2_TABLE_600
284: , p_deprn_method_code VARCHAR2
285: , p_in_service_date date

Line 309: , p12_a19 JTF_VARCHAR2_TABLE_200

305: , p12_a15 JTF_VARCHAR2_TABLE_500
306: , p12_a16 JTF_VARCHAR2_TABLE_500
307: , p12_a17 JTF_VARCHAR2_TABLE_100
308: , p12_a18 JTF_VARCHAR2_TABLE_100
309: , p12_a19 JTF_VARCHAR2_TABLE_200
310: , p12_a20 JTF_VARCHAR2_TABLE_100
311: , p12_a21 JTF_VARCHAR2_TABLE_200
312: , p12_a22 JTF_VARCHAR2_TABLE_100
313: , p12_a23 JTF_VARCHAR2_TABLE_200

Line 311: , p12_a21 JTF_VARCHAR2_TABLE_200

307: , p12_a17 JTF_VARCHAR2_TABLE_100
308: , p12_a18 JTF_VARCHAR2_TABLE_100
309: , p12_a19 JTF_VARCHAR2_TABLE_200
310: , p12_a20 JTF_VARCHAR2_TABLE_100
311: , p12_a21 JTF_VARCHAR2_TABLE_200
312: , p12_a22 JTF_VARCHAR2_TABLE_100
313: , p12_a23 JTF_VARCHAR2_TABLE_200
314: , p12_a24 JTF_VARCHAR2_TABLE_100
315: , p12_a25 JTF_VARCHAR2_TABLE_100

Line 313: , p12_a23 JTF_VARCHAR2_TABLE_200

309: , p12_a19 JTF_VARCHAR2_TABLE_200
310: , p12_a20 JTF_VARCHAR2_TABLE_100
311: , p12_a21 JTF_VARCHAR2_TABLE_200
312: , p12_a22 JTF_VARCHAR2_TABLE_100
313: , p12_a23 JTF_VARCHAR2_TABLE_200
314: , p12_a24 JTF_VARCHAR2_TABLE_100
315: , p12_a25 JTF_VARCHAR2_TABLE_100
316: , p12_a26 JTF_VARCHAR2_TABLE_100
317: )

Line 410: , p5_a1 JTF_VARCHAR2_TABLE_200

406: , x_return_status out nocopy VARCHAR2
407: , x_msg_count out nocopy NUMBER
408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_VARCHAR2_TABLE_200
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600
414: , p5_a5 JTF_NUMBER_TABLE

Line 412: , p5_a3 JTF_VARCHAR2_TABLE_200

408: , x_msg_data out nocopy VARCHAR2
409: , p5_a0 JTF_NUMBER_TABLE
410: , p5_a1 JTF_VARCHAR2_TABLE_200
411: , p5_a2 JTF_NUMBER_TABLE
412: , p5_a3 JTF_VARCHAR2_TABLE_200
413: , p5_a4 JTF_VARCHAR2_TABLE_600
414: , p5_a5 JTF_NUMBER_TABLE
415: , p5_a6 JTF_NUMBER_TABLE
416: , p5_a7 JTF_VARCHAR2_TABLE_100

Line 441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

437: , p5_a28 JTF_DATE_TABLE
438: , p5_a29 JTF_NUMBER_TABLE
439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
445: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200

439: , p5_a30 JTF_DATE_TABLE
440: , p6_a0 out nocopy JTF_NUMBER_TABLE
441: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
442: , p6_a2 out nocopy JTF_NUMBER_TABLE
443: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_200
444: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_600
445: , p6_a5 out nocopy JTF_NUMBER_TABLE
446: , p6_a6 out nocopy JTF_NUMBER_TABLE
447: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100