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.CN_PAY_GROUP_DTLS_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 14: , a1 JTF_VARCHAR2_TABLE_100

10: return d;
11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE

Line 15: , a2 JTF_VARCHAR2_TABLE_100

11: end;
12:
13: procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE

Line 16: , a3 JTF_VARCHAR2_TABLE_100

12:
13: procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE

Line 17: , a4 JTF_VARCHAR2_TABLE_100

13: procedure rosetta_table_copy_in_p3(t out nocopy cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 JTF_NUMBER_TABLE
14: , a1 JTF_VARCHAR2_TABLE_100
15: , a2 JTF_VARCHAR2_TABLE_100
16: , a3 JTF_VARCHAR2_TABLE_100
17: , a4 JTF_VARCHAR2_TABLE_100
18: , a5 JTF_NUMBER_TABLE
19: , a6 JTF_NUMBER_TABLE
20: , a7 JTF_DATE_TABLE
21: , a8 JTF_DATE_TABLE

Line 49: , a1 out nocopy JTF_VARCHAR2_TABLE_100

45: end if;
46: end if;
47: end rosetta_table_copy_in_p3;
48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE

Line 50: , a2 out nocopy JTF_VARCHAR2_TABLE_100

46: end if;
47: end rosetta_table_copy_in_p3;
48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE

Line 51: , a3 out nocopy JTF_VARCHAR2_TABLE_100

47: end rosetta_table_copy_in_p3;
48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE

Line 52: , a4 out nocopy JTF_VARCHAR2_TABLE_100

48: procedure rosetta_table_copy_out_p3(t cn_pay_group_dtls_pvt.pay_group_dtls_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a1 out nocopy JTF_VARCHAR2_TABLE_100
50: , a2 out nocopy JTF_VARCHAR2_TABLE_100
51: , a3 out nocopy JTF_VARCHAR2_TABLE_100
52: , a4 out nocopy JTF_VARCHAR2_TABLE_100
53: , a5 out nocopy JTF_NUMBER_TABLE
54: , a6 out nocopy JTF_NUMBER_TABLE
55: , a7 out nocopy JTF_DATE_TABLE
56: , a8 out nocopy JTF_DATE_TABLE

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_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();

Line 63: a2 := JTF_VARCHAR2_TABLE_100();

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_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();

Line 64: a3 := JTF_VARCHAR2_TABLE_100();

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_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();

Line 65: a4 := JTF_VARCHAR2_TABLE_100();

61: a0 := JTF_NUMBER_TABLE();
62: a1 := JTF_VARCHAR2_TABLE_100();
63: a2 := JTF_VARCHAR2_TABLE_100();
64: a3 := JTF_VARCHAR2_TABLE_100();
65: a4 := JTF_VARCHAR2_TABLE_100();
66: a5 := JTF_NUMBER_TABLE();
67: a6 := JTF_NUMBER_TABLE();
68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();

Line 72: a1 := JTF_VARCHAR2_TABLE_100();

68: a7 := JTF_DATE_TABLE();
69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();

Line 73: a2 := JTF_VARCHAR2_TABLE_100();

69: a8 := JTF_DATE_TABLE();
70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();

Line 74: a3 := JTF_VARCHAR2_TABLE_100();

70: else
71: a0 := JTF_NUMBER_TABLE();
72: a1 := JTF_VARCHAR2_TABLE_100();
73: a2 := JTF_VARCHAR2_TABLE_100();
74: a3 := JTF_VARCHAR2_TABLE_100();
75: a4 := JTF_VARCHAR2_TABLE_100();
76: a5 := JTF_NUMBER_TABLE();
77: a6 := JTF_NUMBER_TABLE();
78: a7 := JTF_DATE_TABLE();

Line 75: a4 := JTF_VARCHAR2_TABLE_100();

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

Line 113: , a1 JTF_VARCHAR2_TABLE_100

109: end if;
110: end rosetta_table_copy_out_p3;
111:
112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100

Line 114: , a2 JTF_VARCHAR2_TABLE_100

110: end rosetta_table_copy_out_p3;
111:
112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_DATE_TABLE

Line 115: , a3 JTF_VARCHAR2_TABLE_100

111:
112: procedure rosetta_table_copy_in_p4(t out nocopy cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 JTF_NUMBER_TABLE
113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_DATE_TABLE
119: , a7 JTF_DATE_TABLE

Line 117: , a5 JTF_VARCHAR2_TABLE_100

113: , a1 JTF_VARCHAR2_TABLE_100
114: , a2 JTF_VARCHAR2_TABLE_100
115: , a3 JTF_VARCHAR2_TABLE_100
116: , a4 JTF_VARCHAR2_TABLE_400
117: , a5 JTF_VARCHAR2_TABLE_100
118: , a6 JTF_DATE_TABLE
119: , a7 JTF_DATE_TABLE
120: ) as
121: ddindx binary_integer; indx binary_integer;

Line 146: , a1 out nocopy JTF_VARCHAR2_TABLE_100

142: end if;
143: end if;
144: end rosetta_table_copy_in_p4;
145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 147: , a2 out nocopy JTF_VARCHAR2_TABLE_100

143: end if;
144: end rosetta_table_copy_in_p4;
145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100
151: , a6 out nocopy JTF_DATE_TABLE

Line 148: , a3 out nocopy JTF_VARCHAR2_TABLE_100

144: end rosetta_table_copy_in_p4;
145: procedure rosetta_table_copy_out_p4(t cn_pay_group_dtls_pvt.pay_group_sales_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100
151: , a6 out nocopy JTF_DATE_TABLE
152: , a7 out nocopy JTF_DATE_TABLE

Line 150: , a5 out nocopy JTF_VARCHAR2_TABLE_100

146: , a1 out nocopy JTF_VARCHAR2_TABLE_100
147: , a2 out nocopy JTF_VARCHAR2_TABLE_100
148: , a3 out nocopy JTF_VARCHAR2_TABLE_100
149: , a4 out nocopy JTF_VARCHAR2_TABLE_400
150: , a5 out nocopy JTF_VARCHAR2_TABLE_100
151: , a6 out nocopy JTF_DATE_TABLE
152: , a7 out nocopy JTF_DATE_TABLE
153: ) as
154: ddindx binary_integer; indx binary_integer;

Line 158: a1 := JTF_VARCHAR2_TABLE_100();

154: ddindx binary_integer; indx binary_integer;
155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();

Line 159: a2 := JTF_VARCHAR2_TABLE_100();

155: begin
156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();

Line 160: a3 := JTF_VARCHAR2_TABLE_100();

156: if t is null or t.count = 0 then
157: a0 := JTF_NUMBER_TABLE();
158: a1 := JTF_VARCHAR2_TABLE_100();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();
164: a7 := JTF_DATE_TABLE();

Line 162: a5 := JTF_VARCHAR2_TABLE_100();

158: a1 := JTF_VARCHAR2_TABLE_100();
159: a2 := JTF_VARCHAR2_TABLE_100();
160: a3 := JTF_VARCHAR2_TABLE_100();
161: a4 := JTF_VARCHAR2_TABLE_400();
162: a5 := JTF_VARCHAR2_TABLE_100();
163: a6 := JTF_DATE_TABLE();
164: a7 := JTF_DATE_TABLE();
165: else
166: a0 := JTF_NUMBER_TABLE();

Line 167: a1 := JTF_VARCHAR2_TABLE_100();

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

Line 168: a2 := JTF_VARCHAR2_TABLE_100();

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

Line 169: a3 := JTF_VARCHAR2_TABLE_100();

165: else
166: a0 := JTF_NUMBER_TABLE();
167: a1 := JTF_VARCHAR2_TABLE_100();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_400();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_DATE_TABLE();
173: a7 := JTF_DATE_TABLE();

Line 171: a5 := JTF_VARCHAR2_TABLE_100();

167: a1 := JTF_VARCHAR2_TABLE_100();
168: a2 := JTF_VARCHAR2_TABLE_100();
169: a3 := JTF_VARCHAR2_TABLE_100();
170: a4 := JTF_VARCHAR2_TABLE_400();
171: a5 := JTF_VARCHAR2_TABLE_100();
172: a6 := JTF_DATE_TABLE();
173: a7 := JTF_DATE_TABLE();
174: if t.count > 0 then
175: a0.extend(t.count);

Line 205: , a1 JTF_VARCHAR2_TABLE_100

201: end if;
202: end rosetta_table_copy_out_p4;
203:
204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE

Line 206: , a2 JTF_VARCHAR2_TABLE_100

202: end rosetta_table_copy_out_p4;
203:
204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE

Line 207: , a3 JTF_VARCHAR2_TABLE_100

203:
204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE
211: , a7 JTF_DATE_TABLE

Line 208: , a4 JTF_VARCHAR2_TABLE_100

204: procedure rosetta_table_copy_in_p5(t out nocopy cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 JTF_NUMBER_TABLE
205: , a1 JTF_VARCHAR2_TABLE_100
206: , a2 JTF_VARCHAR2_TABLE_100
207: , a3 JTF_VARCHAR2_TABLE_100
208: , a4 JTF_VARCHAR2_TABLE_100
209: , a5 JTF_NUMBER_TABLE
210: , a6 JTF_DATE_TABLE
211: , a7 JTF_DATE_TABLE
212: ) as

Line 238: , a1 out nocopy JTF_VARCHAR2_TABLE_100

234: end if;
235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE

Line 239: , a2 out nocopy JTF_VARCHAR2_TABLE_100

235: end if;
236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE

Line 240: , a3 out nocopy JTF_VARCHAR2_TABLE_100

236: end rosetta_table_copy_in_p5;
237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE
244: , a7 out nocopy JTF_DATE_TABLE

Line 241: , a4 out nocopy JTF_VARCHAR2_TABLE_100

237: procedure rosetta_table_copy_out_p5(t cn_pay_group_dtls_pvt.pay_group_roles_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
238: , a1 out nocopy JTF_VARCHAR2_TABLE_100
239: , a2 out nocopy JTF_VARCHAR2_TABLE_100
240: , a3 out nocopy JTF_VARCHAR2_TABLE_100
241: , a4 out nocopy JTF_VARCHAR2_TABLE_100
242: , a5 out nocopy JTF_NUMBER_TABLE
243: , a6 out nocopy JTF_DATE_TABLE
244: , a7 out nocopy JTF_DATE_TABLE
245: ) as

Line 250: a1 := JTF_VARCHAR2_TABLE_100();

246: ddindx binary_integer; indx binary_integer;
247: begin
248: if t is null or t.count = 0 then
249: a0 := JTF_NUMBER_TABLE();
250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();

Line 251: a2 := JTF_VARCHAR2_TABLE_100();

247: begin
248: if t is null or t.count = 0 then
249: a0 := JTF_NUMBER_TABLE();
250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();

Line 252: a3 := JTF_VARCHAR2_TABLE_100();

248: if t is null or t.count = 0 then
249: a0 := JTF_NUMBER_TABLE();
250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();

Line 253: a4 := JTF_VARCHAR2_TABLE_100();

249: a0 := JTF_NUMBER_TABLE();
250: a1 := JTF_VARCHAR2_TABLE_100();
251: a2 := JTF_VARCHAR2_TABLE_100();
252: a3 := JTF_VARCHAR2_TABLE_100();
253: a4 := JTF_VARCHAR2_TABLE_100();
254: a5 := JTF_NUMBER_TABLE();
255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else

Line 259: a1 := JTF_VARCHAR2_TABLE_100();

255: a6 := JTF_DATE_TABLE();
256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();

Line 260: a2 := JTF_VARCHAR2_TABLE_100();

256: a7 := JTF_DATE_TABLE();
257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();

Line 261: a3 := JTF_VARCHAR2_TABLE_100();

257: else
258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();
265: a7 := JTF_DATE_TABLE();

Line 262: a4 := JTF_VARCHAR2_TABLE_100();

258: a0 := JTF_NUMBER_TABLE();
259: a1 := JTF_VARCHAR2_TABLE_100();
260: a2 := JTF_VARCHAR2_TABLE_100();
261: a3 := JTF_VARCHAR2_TABLE_100();
262: a4 := JTF_VARCHAR2_TABLE_100();
263: a5 := JTF_NUMBER_TABLE();
264: a6 := JTF_DATE_TABLE();
265: a7 := JTF_DATE_TABLE();
266: if t.count > 0 then

Line 304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

300: , p_start_record NUMBER
301: , p_fetch_size NUMBER
302: , p_pay_group_id NUMBER
303: , p7_a0 out nocopy JTF_NUMBER_TABLE
304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

301: , p_fetch_size NUMBER
302: , p_pay_group_id NUMBER
303: , p7_a0 out nocopy JTF_NUMBER_TABLE
304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE

Line 306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

302: , p_pay_group_id NUMBER
303: , p7_a0 out nocopy JTF_NUMBER_TABLE
304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE

Line 307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

303: , p7_a0 out nocopy JTF_NUMBER_TABLE
304: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
305: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
306: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
307: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
308: , p7_a5 out nocopy JTF_NUMBER_TABLE
309: , p7_a6 out nocopy JTF_NUMBER_TABLE
310: , p7_a7 out nocopy JTF_DATE_TABLE
311: , p7_a8 out nocopy JTF_DATE_TABLE

Line 382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

378: , p_start_record NUMBER
379: , p_fetch_size NUMBER
380: , p_pay_group_id NUMBER
381: , p7_a0 out nocopy JTF_NUMBER_TABLE
382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

379: , p_fetch_size NUMBER
380: , p_pay_group_id NUMBER
381: , p7_a0 out nocopy JTF_NUMBER_TABLE
382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a6 out nocopy JTF_DATE_TABLE

Line 384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

380: , p_pay_group_id NUMBER
381: , p7_a0 out nocopy JTF_NUMBER_TABLE
382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a6 out nocopy JTF_DATE_TABLE
388: , p7_a7 out nocopy JTF_DATE_TABLE

Line 386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

382: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
383: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
384: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
385: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_400
386: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
387: , p7_a6 out nocopy JTF_DATE_TABLE
388: , p7_a7 out nocopy JTF_DATE_TABLE
389: , x_total_record out nocopy NUMBER
390: , x_return_status out nocopy VARCHAR2

Line 458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100

454: , p_start_record NUMBER
455: , p_fetch_size NUMBER
456: , p_pay_group_id NUMBER
457: , p7_a0 out nocopy JTF_NUMBER_TABLE
458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE

Line 459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100

455: , p_fetch_size NUMBER
456: , p_pay_group_id NUMBER
457: , p7_a0 out nocopy JTF_NUMBER_TABLE
458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE

Line 460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

456: , p_pay_group_id NUMBER
457: , p7_a0 out nocopy JTF_NUMBER_TABLE
458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE
464: , p7_a7 out nocopy JTF_DATE_TABLE

Line 461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100

457: , p7_a0 out nocopy JTF_NUMBER_TABLE
458: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_100
459: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
460: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
461: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
462: , p7_a5 out nocopy JTF_NUMBER_TABLE
463: , p7_a6 out nocopy JTF_DATE_TABLE
464: , p7_a7 out nocopy JTF_DATE_TABLE
465: , x_total_record out nocopy NUMBER