eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_JTOT_EXTRACT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 22: procedure rosetta_table_copy_in_p4(t out nocopy okl_jtot_extract.party_tab_type, a0 JTF_VARCHAR2_TABLE_100

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy okl_jtot_extract.party_tab_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_VARCHAR2_TABLE_300

Line 23: , a1 JTF_VARCHAR2_TABLE_100

19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p4(t out nocopy okl_jtot_extract.party_tab_type, a0 JTF_VARCHAR2_TABLE_100
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_VARCHAR2_TABLE_200
25: , a3 JTF_VARCHAR2_TABLE_300
26: , a4 JTF_VARCHAR2_TABLE_300
27: , a5 JTF_VARCHAR2_TABLE_100

Line 27: , a5 JTF_VARCHAR2_TABLE_100

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

Line 51: procedure rosetta_table_copy_out_p4(t okl_jtot_extract.party_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

47: end loop;
48: end if;
49: end if;
50: end rosetta_table_copy_in_p4;
51: procedure rosetta_table_copy_out_p4(t okl_jtot_extract.party_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_300
55: , a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 52: , a1 out nocopy JTF_VARCHAR2_TABLE_100

48: end if;
49: end if;
50: end rosetta_table_copy_in_p4;
51: procedure rosetta_table_copy_out_p4(t okl_jtot_extract.party_tab_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
52: , a1 out nocopy JTF_VARCHAR2_TABLE_100
53: , a2 out nocopy JTF_VARCHAR2_TABLE_200
54: , a3 out nocopy JTF_VARCHAR2_TABLE_300
55: , a4 out nocopy JTF_VARCHAR2_TABLE_300
56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 56: , a5 out nocopy JTF_VARCHAR2_TABLE_100

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

Line 61: a0 := JTF_VARCHAR2_TABLE_100();

57: ) as
58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_VARCHAR2_TABLE_100();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_300();
65: a4 := JTF_VARCHAR2_TABLE_300();

Line 62: a1 := JTF_VARCHAR2_TABLE_100();

58: ddindx binary_integer; indx binary_integer;
59: begin
60: if t is null or t.count = 0 then
61: a0 := JTF_VARCHAR2_TABLE_100();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_200();
64: a3 := JTF_VARCHAR2_TABLE_300();
65: a4 := JTF_VARCHAR2_TABLE_300();
66: a5 := JTF_VARCHAR2_TABLE_100();

Line 66: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 68: a0 := JTF_VARCHAR2_TABLE_100();

64: a3 := JTF_VARCHAR2_TABLE_300();
65: a4 := JTF_VARCHAR2_TABLE_300();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_300();
72: a4 := JTF_VARCHAR2_TABLE_300();

Line 69: a1 := JTF_VARCHAR2_TABLE_100();

65: a4 := JTF_VARCHAR2_TABLE_300();
66: a5 := JTF_VARCHAR2_TABLE_100();
67: else
68: a0 := JTF_VARCHAR2_TABLE_100();
69: a1 := JTF_VARCHAR2_TABLE_100();
70: a2 := JTF_VARCHAR2_TABLE_200();
71: a3 := JTF_VARCHAR2_TABLE_300();
72: a4 := JTF_VARCHAR2_TABLE_300();
73: a5 := JTF_VARCHAR2_TABLE_100();

Line 73: a5 := JTF_VARCHAR2_TABLE_100();

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

Line 100: procedure rosetta_table_copy_in_p6(t out nocopy okl_jtot_extract.rle_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100

96: end if;
97: end if;
98: end rosetta_table_copy_out_p4;
99:
100: procedure rosetta_table_copy_in_p6(t out nocopy okl_jtot_extract.rle_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100
101: , a1 JTF_VARCHAR2_TABLE_100
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin

Line 101: , a1 JTF_VARCHAR2_TABLE_100

97: end if;
98: end rosetta_table_copy_out_p4;
99:
100: procedure rosetta_table_copy_in_p6(t out nocopy okl_jtot_extract.rle_code_tbl_type, a0 JTF_VARCHAR2_TABLE_100
101: , a1 JTF_VARCHAR2_TABLE_100
102: ) as
103: ddindx binary_integer; indx binary_integer;
104: begin
105: if a0 is not null and a0.count > 0 then

Line 121: procedure rosetta_table_copy_out_p6(t okl_jtot_extract.rle_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

117: end loop;
118: end if;
119: end if;
120: end rosetta_table_copy_in_p6;
121: procedure rosetta_table_copy_out_p6(t okl_jtot_extract.rle_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin

Line 122: , a1 out nocopy JTF_VARCHAR2_TABLE_100

118: end if;
119: end if;
120: end rosetta_table_copy_in_p6;
121: procedure rosetta_table_copy_out_p6(t okl_jtot_extract.rle_code_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
122: , a1 out nocopy JTF_VARCHAR2_TABLE_100
123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then

Line 127: a0 := JTF_VARCHAR2_TABLE_100();

123: ) as
124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: else
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_VARCHAR2_TABLE_100();

Line 128: a1 := JTF_VARCHAR2_TABLE_100();

124: ddindx binary_integer; indx binary_integer;
125: begin
126: if t is null or t.count = 0 then
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: else
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_VARCHAR2_TABLE_100();
132: if t.count > 0 then

Line 130: a0 := JTF_VARCHAR2_TABLE_100();

126: if t is null or t.count = 0 then
127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: else
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_VARCHAR2_TABLE_100();
132: if t.count > 0 then
133: a0.extend(t.count);
134: a1.extend(t.count);

Line 131: a1 := JTF_VARCHAR2_TABLE_100();

127: a0 := JTF_VARCHAR2_TABLE_100();
128: a1 := JTF_VARCHAR2_TABLE_100();
129: else
130: a0 := JTF_VARCHAR2_TABLE_100();
131: a1 := JTF_VARCHAR2_TABLE_100();
132: if t.count > 0 then
133: a0.extend(t.count);
134: a1.extend(t.count);
135: ddindx := t.first;

Line 159: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100

155: , p_chr_id VARCHAR2
156: , p_cle_id VARCHAR2
157: , p_role_code VARCHAR2
158: , p_intent VARCHAR2
159: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
162: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_300
163: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_300

Line 160: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100

156: , p_cle_id VARCHAR2
157: , p_role_code VARCHAR2
158: , p_intent VARCHAR2
159: , p9_a0 out nocopy JTF_VARCHAR2_TABLE_100
160: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
162: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_300
163: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_300
164: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 164: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100

160: , p9_a1 out nocopy JTF_VARCHAR2_TABLE_100
161: , p9_a2 out nocopy JTF_VARCHAR2_TABLE_200
162: , p9_a3 out nocopy JTF_VARCHAR2_TABLE_300
163: , p9_a4 out nocopy JTF_VARCHAR2_TABLE_300
164: , p9_a5 out nocopy JTF_VARCHAR2_TABLE_100
165: )
166:
167: as
168: ddx_party_tab okl_jtot_extract.party_tab_type;

Line 220: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

216: , x_return_status out nocopy VARCHAR2
217: , x_msg_count out nocopy NUMBER
218: , x_msg_data out nocopy VARCHAR2
219: , p_scs_code VARCHAR2
220: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
222: )
223:
224: as

Line 221: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

217: , x_msg_count out nocopy NUMBER
218: , x_msg_data out nocopy VARCHAR2
219: , p_scs_code VARCHAR2
220: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
221: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
222: )
223:
224: as
225: ddx_rle_code_tbl okl_jtot_extract.rle_code_tbl_type;

Line 264: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100

260: , x_return_status out nocopy VARCHAR2
261: , x_msg_count out nocopy NUMBER
262: , x_msg_data out nocopy VARCHAR2
263: , p_chr_id VARCHAR2
264: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
266: )
267:
268: as

Line 265: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100

261: , x_msg_count out nocopy NUMBER
262: , x_msg_data out nocopy VARCHAR2
263: , p_chr_id VARCHAR2
264: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
265: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
266: )
267:
268: as
269: ddx_rle_code_tbl okl_jtot_extract.rle_code_tbl_type;