DBA Data[Home] [Help]

APPS.AHL_SB_RULES_PVT_W dependencies on JTF_DATE_TABLE

Line 6: , a3 JTF_DATE_TABLE

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
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE

Line 8: , a5 JTF_DATE_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
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_NUMBER_TABLE

Line 16: , a13 JTF_DATE_TABLE

12: , a9 JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 17: , a14 JTF_DATE_TABLE

13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
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

Line 87: , a3 out nocopy JTF_DATE_TABLE

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
90: , a6 out nocopy JTF_NUMBER_TABLE
91: , a7 out nocopy JTF_NUMBER_TABLE

Line 89: , a5 out nocopy JTF_DATE_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
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

Line 97: , a13 out nocopy JTF_DATE_TABLE

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
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

Line 98: , a14 out nocopy JTF_DATE_TABLE

94: , a10 out nocopy JTF_NUMBER_TABLE
95: , a11 out nocopy JTF_NUMBER_TABLE
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

Line 123: a3 := JTF_DATE_TABLE();

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();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();

Line 125: a5 := JTF_DATE_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();
126: a6 := JTF_NUMBER_TABLE();
127: a7 := JTF_NUMBER_TABLE();
128: a8 := JTF_VARCHAR2_TABLE_100();
129: a9 := JTF_NUMBER_TABLE();

Line 133: a13 := JTF_DATE_TABLE();

129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
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();

Line 134: a14 := JTF_DATE_TABLE();

130: a10 := JTF_NUMBER_TABLE();
131: a11 := JTF_NUMBER_TABLE();
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();

Line 156: a3 := JTF_DATE_TABLE();

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();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();

Line 158: a5 := JTF_DATE_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();
159: a6 := JTF_NUMBER_TABLE();
160: a7 := JTF_NUMBER_TABLE();
161: a8 := JTF_VARCHAR2_TABLE_100();
162: a9 := JTF_NUMBER_TABLE();

Line 166: a13 := JTF_DATE_TABLE();

162: a9 := JTF_NUMBER_TABLE();
163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
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();

Line 167: a14 := JTF_DATE_TABLE();

163: a10 := JTF_NUMBER_TABLE();
164: a11 := JTF_NUMBER_TABLE();
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();

Line 266: , a3 JTF_DATE_TABLE

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
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE

Line 268: , a5 JTF_DATE_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
269: , a6 JTF_NUMBER_TABLE
270: , a7 JTF_NUMBER_TABLE
271: , a8 JTF_NUMBER_TABLE
272: , a9 JTF_NUMBER_TABLE

Line 341: , a3 out nocopy JTF_DATE_TABLE

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
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE

Line 343: , a5 out nocopy JTF_DATE_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
344: , a6 out nocopy JTF_NUMBER_TABLE
345: , a7 out nocopy JTF_NUMBER_TABLE
346: , a8 out nocopy JTF_NUMBER_TABLE
347: , a9 out nocopy JTF_NUMBER_TABLE

Line 374: a3 := JTF_DATE_TABLE();

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();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();

Line 376: a5 := JTF_DATE_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();
377: a6 := JTF_NUMBER_TABLE();
378: a7 := JTF_NUMBER_TABLE();
379: a8 := JTF_NUMBER_TABLE();
380: a9 := JTF_NUMBER_TABLE();

Line 404: a3 := JTF_DATE_TABLE();

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();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();

Line 406: a5 := JTF_DATE_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();
407: a6 := JTF_NUMBER_TABLE();
408: a7 := JTF_NUMBER_TABLE();
409: a8 := JTF_NUMBER_TABLE();
410: a9 := JTF_NUMBER_TABLE();