DBA Data[Home] [Help]

APPS.AHL_SB_RULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_100

Line 4: , a1 JTF_VARCHAR2_TABLE_100

1: package body ahl_sb_rules_pvt_w as
2: /* $Header: AHLWSBRB.pls 120.0.12020000.2 2012/12/14 06:28:47 shnatu noship $ */
3: procedure rosetta_table_copy_in_p4(t out nocopy ahl_sb_rules_pvt.sb_rule_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE

Line 11: , a8 JTF_VARCHAR2_TABLE_100

7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_DATE_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE

Line 19: , a16 JTF_VARCHAR2_TABLE_100

15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_DATE_TABLE
17: , a14 JTF_DATE_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_200
22: , a19 JTF_VARCHAR2_TABLE_200
23: , a20 JTF_VARCHAR2_TABLE_200

Line 85: , a1 out nocopy JTF_VARCHAR2_TABLE_100

81: end if;
82: end if;
83: end rosetta_table_copy_in_p4;
84: procedure rosetta_table_copy_out_p4(t ahl_sb_rules_pvt.sb_rule_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
85: , a1 out nocopy JTF_VARCHAR2_TABLE_100
86: , a2 out nocopy JTF_NUMBER_TABLE
87: , a3 out nocopy JTF_DATE_TABLE
88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE

Line 92: , a8 out nocopy JTF_VARCHAR2_TABLE_100

88: , a4 out nocopy JTF_NUMBER_TABLE
89: , a5 out nocopy JTF_DATE_TABLE
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE
92: , a8 out nocopy JTF_VARCHAR2_TABLE_100
93: , a9 out nocopy JTF_NUMBER_TABLE
94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
96: , a12 out nocopy JTF_NUMBER_TABLE

Line 100: , a16 out nocopy JTF_VARCHAR2_TABLE_100

96: , a12 out nocopy JTF_NUMBER_TABLE
97: , a13 out nocopy JTF_DATE_TABLE
98: , a14 out nocopy JTF_DATE_TABLE
99: , a15 out nocopy JTF_NUMBER_TABLE
100: , a16 out nocopy JTF_VARCHAR2_TABLE_100
101: , a17 out nocopy JTF_VARCHAR2_TABLE_200
102: , a18 out nocopy JTF_VARCHAR2_TABLE_200
103: , a19 out nocopy JTF_VARCHAR2_TABLE_200
104: , a20 out nocopy JTF_VARCHAR2_TABLE_200

Line 121: a1 := JTF_VARCHAR2_TABLE_100();

117: ddindx binary_integer; indx binary_integer;
118: begin
119: if t is null or t.count = 0 then
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_VARCHAR2_TABLE_100();
122: a2 := JTF_NUMBER_TABLE();
123: a3 := JTF_DATE_TABLE();
124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();

Line 128: a8 := JTF_VARCHAR2_TABLE_100();

124: a4 := JTF_NUMBER_TABLE();
125: a5 := JTF_DATE_TABLE();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
132: a12 := JTF_NUMBER_TABLE();

Line 136: a16 := JTF_VARCHAR2_TABLE_100();

132: a12 := JTF_NUMBER_TABLE();
133: a13 := JTF_DATE_TABLE();
134: a14 := JTF_DATE_TABLE();
135: a15 := JTF_NUMBER_TABLE();
136: a16 := JTF_VARCHAR2_TABLE_100();
137: a17 := JTF_VARCHAR2_TABLE_200();
138: a18 := JTF_VARCHAR2_TABLE_200();
139: a19 := JTF_VARCHAR2_TABLE_200();
140: a20 := JTF_VARCHAR2_TABLE_200();

Line 154: a1 := JTF_VARCHAR2_TABLE_100();

150: a30 := JTF_VARCHAR2_TABLE_200();
151: a31 := JTF_VARCHAR2_TABLE_200();
152: else
153: a0 := JTF_NUMBER_TABLE();
154: a1 := JTF_VARCHAR2_TABLE_100();
155: a2 := JTF_NUMBER_TABLE();
156: a3 := JTF_DATE_TABLE();
157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();

Line 161: a8 := JTF_VARCHAR2_TABLE_100();

157: a4 := JTF_NUMBER_TABLE();
158: a5 := JTF_DATE_TABLE();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
165: a12 := JTF_NUMBER_TABLE();

Line 169: a16 := JTF_VARCHAR2_TABLE_100();

165: a12 := JTF_NUMBER_TABLE();
166: a13 := JTF_DATE_TABLE();
167: a14 := JTF_DATE_TABLE();
168: a15 := JTF_NUMBER_TABLE();
169: a16 := JTF_VARCHAR2_TABLE_100();
170: a17 := JTF_VARCHAR2_TABLE_200();
171: a18 := JTF_VARCHAR2_TABLE_200();
172: a19 := JTF_VARCHAR2_TABLE_200();
173: a20 := JTF_VARCHAR2_TABLE_200();

Line 264: , a1 JTF_VARCHAR2_TABLE_100

260: end if;
261: end rosetta_table_copy_out_p4;
262:
263: procedure rosetta_table_copy_in_p6(t out nocopy ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 JTF_NUMBER_TABLE
264: , a1 JTF_VARCHAR2_TABLE_100
265: , a2 JTF_NUMBER_TABLE
266: , a3 JTF_DATE_TABLE
267: , a4 JTF_NUMBER_TABLE
268: , a5 JTF_DATE_TABLE

Line 274: , a11 JTF_VARCHAR2_TABLE_100

270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE
276: , a13 JTF_VARCHAR2_TABLE_100
277: , a14 JTF_VARCHAR2_TABLE_200
278: , a15 JTF_VARCHAR2_TABLE_200

Line 276: , a13 JTF_VARCHAR2_TABLE_100

272: , a9 JTF_NUMBER_TABLE
273: , a10 JTF_NUMBER_TABLE
274: , a11 JTF_VARCHAR2_TABLE_100
275: , a12 JTF_NUMBER_TABLE
276: , a13 JTF_VARCHAR2_TABLE_100
277: , a14 JTF_VARCHAR2_TABLE_200
278: , a15 JTF_VARCHAR2_TABLE_200
279: , a16 JTF_VARCHAR2_TABLE_200
280: , a17 JTF_VARCHAR2_TABLE_200

Line 339: , a1 out nocopy JTF_VARCHAR2_TABLE_100

335: end if;
336: end if;
337: end rosetta_table_copy_in_p6;
338: procedure rosetta_table_copy_out_p6(t ahl_sb_rules_pvt.sb_rule_items_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
339: , a1 out nocopy JTF_VARCHAR2_TABLE_100
340: , a2 out nocopy JTF_NUMBER_TABLE
341: , a3 out nocopy JTF_DATE_TABLE
342: , a4 out nocopy JTF_NUMBER_TABLE
343: , a5 out nocopy JTF_DATE_TABLE

Line 349: , a11 out nocopy JTF_VARCHAR2_TABLE_100

345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE
351: , a13 out nocopy JTF_VARCHAR2_TABLE_100
352: , a14 out nocopy JTF_VARCHAR2_TABLE_200
353: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 351: , a13 out nocopy JTF_VARCHAR2_TABLE_100

347: , a9 out nocopy JTF_NUMBER_TABLE
348: , a10 out nocopy JTF_NUMBER_TABLE
349: , a11 out nocopy JTF_VARCHAR2_TABLE_100
350: , a12 out nocopy JTF_NUMBER_TABLE
351: , a13 out nocopy JTF_VARCHAR2_TABLE_100
352: , a14 out nocopy JTF_VARCHAR2_TABLE_200
353: , a15 out nocopy JTF_VARCHAR2_TABLE_200
354: , a16 out nocopy JTF_VARCHAR2_TABLE_200
355: , a17 out nocopy JTF_VARCHAR2_TABLE_200

Line 372: a1 := JTF_VARCHAR2_TABLE_100();

368: ddindx binary_integer; indx binary_integer;
369: begin
370: if t is null or t.count = 0 then
371: a0 := JTF_NUMBER_TABLE();
372: a1 := JTF_VARCHAR2_TABLE_100();
373: a2 := JTF_NUMBER_TABLE();
374: a3 := JTF_DATE_TABLE();
375: a4 := JTF_NUMBER_TABLE();
376: a5 := JTF_DATE_TABLE();

Line 382: a11 := JTF_VARCHAR2_TABLE_100();

378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();
384: a13 := JTF_VARCHAR2_TABLE_100();
385: a14 := JTF_VARCHAR2_TABLE_200();
386: a15 := JTF_VARCHAR2_TABLE_200();

Line 384: a13 := JTF_VARCHAR2_TABLE_100();

380: a9 := JTF_NUMBER_TABLE();
381: a10 := JTF_NUMBER_TABLE();
382: a11 := JTF_VARCHAR2_TABLE_100();
383: a12 := JTF_NUMBER_TABLE();
384: a13 := JTF_VARCHAR2_TABLE_100();
385: a14 := JTF_VARCHAR2_TABLE_200();
386: a15 := JTF_VARCHAR2_TABLE_200();
387: a16 := JTF_VARCHAR2_TABLE_200();
388: a17 := JTF_VARCHAR2_TABLE_200();

Line 402: a1 := JTF_VARCHAR2_TABLE_100();

398: a27 := JTF_VARCHAR2_TABLE_200();
399: a28 := JTF_VARCHAR2_TABLE_200();
400: else
401: a0 := JTF_NUMBER_TABLE();
402: a1 := JTF_VARCHAR2_TABLE_100();
403: a2 := JTF_NUMBER_TABLE();
404: a3 := JTF_DATE_TABLE();
405: a4 := JTF_NUMBER_TABLE();
406: a5 := JTF_DATE_TABLE();

Line 412: a11 := JTF_VARCHAR2_TABLE_100();

408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();
414: a13 := JTF_VARCHAR2_TABLE_100();
415: a14 := JTF_VARCHAR2_TABLE_200();
416: a15 := JTF_VARCHAR2_TABLE_200();

Line 414: a13 := JTF_VARCHAR2_TABLE_100();

410: a9 := JTF_NUMBER_TABLE();
411: a10 := JTF_NUMBER_TABLE();
412: a11 := JTF_VARCHAR2_TABLE_100();
413: a12 := JTF_NUMBER_TABLE();
414: a13 := JTF_VARCHAR2_TABLE_100();
415: a14 := JTF_VARCHAR2_TABLE_200();
416: a15 := JTF_VARCHAR2_TABLE_200();
417: a16 := JTF_VARCHAR2_TABLE_200();
418: a17 := JTF_VARCHAR2_TABLE_200();