DBA Data[Home] [Help]

APPS.HZ_FORMAT_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 56: , a2 JTF_VARCHAR2_TABLE_100

52: end rosetta_table_copy_out_p0;
53:
54: procedure rosetta_table_copy_in_p2(t out nocopy hz_format_pub.layout_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_VARCHAR2_TABLE_100
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100

Line 57: , a3 JTF_VARCHAR2_TABLE_100

53:
54: procedure rosetta_table_copy_in_p2(t out nocopy hz_format_pub.layout_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_VARCHAR2_TABLE_100
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_VARCHAR2_TABLE_100

Line 58: , a4 JTF_VARCHAR2_TABLE_100

54: procedure rosetta_table_copy_in_p2(t out nocopy hz_format_pub.layout_tbl_type, a0 JTF_NUMBER_TABLE
55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_VARCHAR2_TABLE_100
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_VARCHAR2_TABLE_100
62: , a8 JTF_NUMBER_TABLE

Line 59: , a5 JTF_VARCHAR2_TABLE_100

55: , a1 JTF_NUMBER_TABLE
56: , a2 JTF_VARCHAR2_TABLE_100
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_VARCHAR2_TABLE_100
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE

Line 60: , a6 JTF_VARCHAR2_TABLE_100

56: , a2 JTF_VARCHAR2_TABLE_100
57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_VARCHAR2_TABLE_100
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_VARCHAR2_TABLE_300

Line 61: , a7 JTF_VARCHAR2_TABLE_100

57: , a3 JTF_VARCHAR2_TABLE_100
58: , a4 JTF_VARCHAR2_TABLE_100
59: , a5 JTF_VARCHAR2_TABLE_100
60: , a6 JTF_VARCHAR2_TABLE_100
61: , a7 JTF_VARCHAR2_TABLE_100
62: , a8 JTF_NUMBER_TABLE
63: , a9 JTF_NUMBER_TABLE
64: , a10 JTF_VARCHAR2_TABLE_300
65: ) as

Line 95: , a2 out nocopy JTF_VARCHAR2_TABLE_100

91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t hz_format_pub.layout_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 96: , a3 out nocopy JTF_VARCHAR2_TABLE_100

92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t hz_format_pub.layout_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 97: , a4 out nocopy JTF_VARCHAR2_TABLE_100

93: procedure rosetta_table_copy_out_p2(t hz_format_pub.layout_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_100
101: , a8 out nocopy JTF_NUMBER_TABLE

Line 98: , a5 out nocopy JTF_VARCHAR2_TABLE_100

94: , a1 out nocopy JTF_NUMBER_TABLE
95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_100
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE

Line 99: , a6 out nocopy JTF_VARCHAR2_TABLE_100

95: , a2 out nocopy JTF_VARCHAR2_TABLE_100
96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_100
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: , a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 100: , a7 out nocopy JTF_VARCHAR2_TABLE_100

96: , a3 out nocopy JTF_VARCHAR2_TABLE_100
97: , a4 out nocopy JTF_VARCHAR2_TABLE_100
98: , a5 out nocopy JTF_VARCHAR2_TABLE_100
99: , a6 out nocopy JTF_VARCHAR2_TABLE_100
100: , a7 out nocopy JTF_VARCHAR2_TABLE_100
101: , a8 out nocopy JTF_NUMBER_TABLE
102: , a9 out nocopy JTF_NUMBER_TABLE
103: , a10 out nocopy JTF_VARCHAR2_TABLE_300
104: ) as

Line 110: a2 := JTF_VARCHAR2_TABLE_100();

106: begin
107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();

Line 111: a3 := JTF_VARCHAR2_TABLE_100();

107: if t is null or t.count = 0 then
108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();
115: a7 := JTF_VARCHAR2_TABLE_100();

Line 112: a4 := JTF_VARCHAR2_TABLE_100();

108: a0 := JTF_NUMBER_TABLE();
109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_NUMBER_TABLE();

Line 113: a5 := JTF_VARCHAR2_TABLE_100();

109: a1 := JTF_NUMBER_TABLE();
110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_NUMBER_TABLE();
117: a9 := JTF_NUMBER_TABLE();

Line 114: a6 := JTF_VARCHAR2_TABLE_100();

110: a2 := JTF_VARCHAR2_TABLE_100();
111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_NUMBER_TABLE();
117: a9 := JTF_NUMBER_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_300();

Line 115: a7 := JTF_VARCHAR2_TABLE_100();

111: a3 := JTF_VARCHAR2_TABLE_100();
112: a4 := JTF_VARCHAR2_TABLE_100();
113: a5 := JTF_VARCHAR2_TABLE_100();
114: a6 := JTF_VARCHAR2_TABLE_100();
115: a7 := JTF_VARCHAR2_TABLE_100();
116: a8 := JTF_NUMBER_TABLE();
117: a9 := JTF_NUMBER_TABLE();
118: a10 := JTF_VARCHAR2_TABLE_300();
119: else

Line 122: a2 := JTF_VARCHAR2_TABLE_100();

118: a10 := JTF_VARCHAR2_TABLE_300();
119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();

Line 123: a3 := JTF_VARCHAR2_TABLE_100();

119: else
120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();

Line 124: a4 := JTF_VARCHAR2_TABLE_100();

120: a0 := JTF_NUMBER_TABLE();
121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_NUMBER_TABLE();

Line 125: a5 := JTF_VARCHAR2_TABLE_100();

121: a1 := JTF_NUMBER_TABLE();
122: a2 := JTF_VARCHAR2_TABLE_100();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_NUMBER_TABLE();
129: a9 := JTF_NUMBER_TABLE();

Line 126: a6 := JTF_VARCHAR2_TABLE_100();

122: a2 := JTF_VARCHAR2_TABLE_100();
123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_NUMBER_TABLE();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_VARCHAR2_TABLE_300();

Line 127: a7 := JTF_VARCHAR2_TABLE_100();

123: a3 := JTF_VARCHAR2_TABLE_100();
124: a4 := JTF_VARCHAR2_TABLE_100();
125: a5 := JTF_VARCHAR2_TABLE_100();
126: a6 := JTF_VARCHAR2_TABLE_100();
127: a7 := JTF_VARCHAR2_TABLE_100();
128: a8 := JTF_NUMBER_TABLE();
129: a9 := JTF_NUMBER_TABLE();
130: a10 := JTF_VARCHAR2_TABLE_300();
131: if t.count > 0 then

Line 359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100

355: , x_msg_data out nocopy VARCHAR2
356: , x_layout_tbl_cnt out nocopy NUMBER
357: , p12_a0 out nocopy JTF_NUMBER_TABLE
358: , p12_a1 out nocopy JTF_NUMBER_TABLE
359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100

356: , x_layout_tbl_cnt out nocopy NUMBER
357: , p12_a0 out nocopy JTF_NUMBER_TABLE
358: , p12_a1 out nocopy JTF_NUMBER_TABLE
359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100

357: , p12_a0 out nocopy JTF_NUMBER_TABLE
358: , p12_a1 out nocopy JTF_NUMBER_TABLE
359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
365: , p12_a8 out nocopy JTF_NUMBER_TABLE

Line 362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100

358: , p12_a1 out nocopy JTF_NUMBER_TABLE
359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
365: , p12_a8 out nocopy JTF_NUMBER_TABLE
366: , p12_a9 out nocopy JTF_NUMBER_TABLE

Line 363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100

359: , p12_a2 out nocopy JTF_VARCHAR2_TABLE_100
360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
365: , p12_a8 out nocopy JTF_NUMBER_TABLE
366: , p12_a9 out nocopy JTF_NUMBER_TABLE
367: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100

360: , p12_a3 out nocopy JTF_VARCHAR2_TABLE_100
361: , p12_a4 out nocopy JTF_VARCHAR2_TABLE_100
362: , p12_a5 out nocopy JTF_VARCHAR2_TABLE_100
363: , p12_a6 out nocopy JTF_VARCHAR2_TABLE_100
364: , p12_a7 out nocopy JTF_VARCHAR2_TABLE_100
365: , p12_a8 out nocopy JTF_NUMBER_TABLE
366: , p12_a9 out nocopy JTF_NUMBER_TABLE
367: , p12_a10 out nocopy JTF_VARCHAR2_TABLE_300
368: )

Line 455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100

451: , x_msg_data out nocopy VARCHAR2
452: , x_layout_tbl_cnt out nocopy NUMBER
453: , p22_a0 out nocopy JTF_NUMBER_TABLE
454: , p22_a1 out nocopy JTF_NUMBER_TABLE
455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100

452: , x_layout_tbl_cnt out nocopy NUMBER
453: , p22_a0 out nocopy JTF_NUMBER_TABLE
454: , p22_a1 out nocopy JTF_NUMBER_TABLE
455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100

Line 457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100

453: , p22_a0 out nocopy JTF_NUMBER_TABLE
454: , p22_a1 out nocopy JTF_NUMBER_TABLE
455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100
461: , p22_a8 out nocopy JTF_NUMBER_TABLE

Line 458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100

454: , p22_a1 out nocopy JTF_NUMBER_TABLE
455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100
461: , p22_a8 out nocopy JTF_NUMBER_TABLE
462: , p22_a9 out nocopy JTF_NUMBER_TABLE

Line 459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100

455: , p22_a2 out nocopy JTF_VARCHAR2_TABLE_100
456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100
461: , p22_a8 out nocopy JTF_NUMBER_TABLE
462: , p22_a9 out nocopy JTF_NUMBER_TABLE
463: , p22_a10 out nocopy JTF_VARCHAR2_TABLE_300

Line 460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100

456: , p22_a3 out nocopy JTF_VARCHAR2_TABLE_100
457: , p22_a4 out nocopy JTF_VARCHAR2_TABLE_100
458: , p22_a5 out nocopy JTF_VARCHAR2_TABLE_100
459: , p22_a6 out nocopy JTF_VARCHAR2_TABLE_100
460: , p22_a7 out nocopy JTF_VARCHAR2_TABLE_100
461: , p22_a8 out nocopy JTF_NUMBER_TABLE
462: , p22_a9 out nocopy JTF_NUMBER_TABLE
463: , p22_a10 out nocopy JTF_VARCHAR2_TABLE_300
464: )