DBA Data[Home] [Help]

APPS.OKS_ENTITLEMENTS_WEB_W dependencies on JTF_VARCHAR2_TABLE_400

Line 98: , a3 JTF_VARCHAR2_TABLE_400

94:
95: procedure rosetta_table_copy_in_p37(t out nocopy oks_entitlements_web.party_tbl_type, a0 JTF_NUMBER_TABLE
96: , a1 JTF_VARCHAR2_TABLE_100
97: , a2 JTF_VARCHAR2_TABLE_100
98: , a3 JTF_VARCHAR2_TABLE_400
99: , a4 JTF_VARCHAR2_TABLE_100
100: , a5 JTF_VARCHAR2_TABLE_100
101: , a6 JTF_VARCHAR2_TABLE_100
102: );

Line 106: , a3 out nocopy JTF_VARCHAR2_TABLE_400

102: );
103: procedure rosetta_table_copy_out_p37(t oks_entitlements_web.party_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
104: , a1 out nocopy JTF_VARCHAR2_TABLE_100
105: , a2 out nocopy JTF_VARCHAR2_TABLE_100
106: , a3 out nocopy JTF_VARCHAR2_TABLE_400
107: , a4 out nocopy JTF_VARCHAR2_TABLE_100
108: , a5 out nocopy JTF_VARCHAR2_TABLE_100
109: , a6 out nocopy JTF_VARCHAR2_TABLE_100
110: );

Line 123: , a11 JTF_VARCHAR2_TABLE_400

119: , a7 JTF_VARCHAR2_TABLE_300
120: , a8 JTF_VARCHAR2_TABLE_500
121: , a9 JTF_VARCHAR2_TABLE_500
122: , a10 JTF_VARCHAR2_TABLE_2000
123: , a11 JTF_VARCHAR2_TABLE_400
124: , a12 JTF_VARCHAR2_TABLE_400
125: , a13 JTF_NUMBER_TABLE
126: , a14 JTF_NUMBER_TABLE
127: , a15 JTF_VARCHAR2_TABLE_200

Line 124: , a12 JTF_VARCHAR2_TABLE_400

120: , a8 JTF_VARCHAR2_TABLE_500
121: , a9 JTF_VARCHAR2_TABLE_500
122: , a10 JTF_VARCHAR2_TABLE_2000
123: , a11 JTF_VARCHAR2_TABLE_400
124: , a12 JTF_VARCHAR2_TABLE_400
125: , a13 JTF_NUMBER_TABLE
126: , a14 JTF_NUMBER_TABLE
127: , a15 JTF_VARCHAR2_TABLE_200
128: , a16 JTF_VARCHAR2_TABLE_100

Line 129: , a17 JTF_VARCHAR2_TABLE_400

125: , a13 JTF_NUMBER_TABLE
126: , a14 JTF_NUMBER_TABLE
127: , a15 JTF_VARCHAR2_TABLE_200
128: , a16 JTF_VARCHAR2_TABLE_100
129: , a17 JTF_VARCHAR2_TABLE_400
130: , a18 JTF_VARCHAR2_TABLE_300
131: , a19 JTF_VARCHAR2_TABLE_100
132: , a20 JTF_VARCHAR2_TABLE_100
133: , a21 JTF_VARCHAR2_TABLE_400

Line 133: , a21 JTF_VARCHAR2_TABLE_400

129: , a17 JTF_VARCHAR2_TABLE_400
130: , a18 JTF_VARCHAR2_TABLE_300
131: , a19 JTF_VARCHAR2_TABLE_100
132: , a20 JTF_VARCHAR2_TABLE_100
133: , a21 JTF_VARCHAR2_TABLE_400
134: , a22 JTF_VARCHAR2_TABLE_300
135: , a23 JTF_VARCHAR2_TABLE_100
136: );
137: procedure rosetta_table_copy_out_p39(t oks_entitlements_web.line_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 148: , a11 out nocopy JTF_VARCHAR2_TABLE_400

144: , a7 out nocopy JTF_VARCHAR2_TABLE_300
145: , a8 out nocopy JTF_VARCHAR2_TABLE_500
146: , a9 out nocopy JTF_VARCHAR2_TABLE_500
147: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a11 out nocopy JTF_VARCHAR2_TABLE_400
149: , a12 out nocopy JTF_VARCHAR2_TABLE_400
150: , a13 out nocopy JTF_NUMBER_TABLE
151: , a14 out nocopy JTF_NUMBER_TABLE
152: , a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 149: , a12 out nocopy JTF_VARCHAR2_TABLE_400

145: , a8 out nocopy JTF_VARCHAR2_TABLE_500
146: , a9 out nocopy JTF_VARCHAR2_TABLE_500
147: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
148: , a11 out nocopy JTF_VARCHAR2_TABLE_400
149: , a12 out nocopy JTF_VARCHAR2_TABLE_400
150: , a13 out nocopy JTF_NUMBER_TABLE
151: , a14 out nocopy JTF_NUMBER_TABLE
152: , a15 out nocopy JTF_VARCHAR2_TABLE_200
153: , a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 154: , a17 out nocopy JTF_VARCHAR2_TABLE_400

150: , a13 out nocopy JTF_NUMBER_TABLE
151: , a14 out nocopy JTF_NUMBER_TABLE
152: , a15 out nocopy JTF_VARCHAR2_TABLE_200
153: , a16 out nocopy JTF_VARCHAR2_TABLE_100
154: , a17 out nocopy JTF_VARCHAR2_TABLE_400
155: , a18 out nocopy JTF_VARCHAR2_TABLE_300
156: , a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , a21 out nocopy JTF_VARCHAR2_TABLE_400

Line 158: , a21 out nocopy JTF_VARCHAR2_TABLE_400

154: , a17 out nocopy JTF_VARCHAR2_TABLE_400
155: , a18 out nocopy JTF_VARCHAR2_TABLE_300
156: , a19 out nocopy JTF_VARCHAR2_TABLE_100
157: , a20 out nocopy JTF_VARCHAR2_TABLE_100
158: , a21 out nocopy JTF_VARCHAR2_TABLE_400
159: , a22 out nocopy JTF_VARCHAR2_TABLE_300
160: , a23 out nocopy JTF_VARCHAR2_TABLE_100
161: );
162:

Line 169: , a6 JTF_VARCHAR2_TABLE_400

165: , a2 JTF_VARCHAR2_TABLE_100
166: , a3 JTF_VARCHAR2_TABLE_100
167: , a4 JTF_DATE_TABLE
168: , a5 JTF_DATE_TABLE
169: , a6 JTF_VARCHAR2_TABLE_400
170: , a7 JTF_VARCHAR2_TABLE_100
171: , a8 JTF_VARCHAR2_TABLE_100
172: );
173: procedure rosetta_table_copy_out_p41(t oks_entitlements_web.party_contact_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

Line 179: , a6 out nocopy JTF_VARCHAR2_TABLE_400

175: , a2 out nocopy JTF_VARCHAR2_TABLE_100
176: , a3 out nocopy JTF_VARCHAR2_TABLE_100
177: , a4 out nocopy JTF_DATE_TABLE
178: , a5 out nocopy JTF_DATE_TABLE
179: , a6 out nocopy JTF_VARCHAR2_TABLE_400
180: , a7 out nocopy JTF_VARCHAR2_TABLE_100
181: , a8 out nocopy JTF_VARCHAR2_TABLE_100
182: );
183:

Line 312: , a1 JTF_VARCHAR2_TABLE_400

308: , a10 out nocopy JTF_VARCHAR2_TABLE_100
309: );
310:
311: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100
312: , a1 JTF_VARCHAR2_TABLE_400
313: );
314: procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
315: , a1 out nocopy JTF_VARCHAR2_TABLE_400
316: );

Line 315: , a1 out nocopy JTF_VARCHAR2_TABLE_400

311: procedure rosetta_table_copy_in_p60(t out nocopy oks_entitlements_web.pref_resource_tbl_type, a0 JTF_VARCHAR2_TABLE_100
312: , a1 JTF_VARCHAR2_TABLE_400
313: );
314: procedure rosetta_table_copy_out_p60(t oks_entitlements_web.pref_resource_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
315: , a1 out nocopy JTF_VARCHAR2_TABLE_400
316: );
317:
318: procedure rosetta_table_copy_in_p62(t out nocopy oks_entitlements_web.bus_proc_bil_typ_tbl_type, a0 JTF_VARCHAR2_TABLE_500
319: , a1 JTF_VARCHAR2_TABLE_500

Line 525: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400

521: , p4_a10 out nocopy VARCHAR2
522: , p5_a0 out nocopy JTF_NUMBER_TABLE
523: , p5_a1 out nocopy JTF_VARCHAR2_TABLE_100
524: , p5_a2 out nocopy JTF_VARCHAR2_TABLE_100
525: , p5_a3 out nocopy JTF_VARCHAR2_TABLE_400
526: , p5_a4 out nocopy JTF_VARCHAR2_TABLE_100
527: , p5_a5 out nocopy JTF_VARCHAR2_TABLE_100
528: , p5_a6 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 540: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400

536: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_300
537: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
538: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
539: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
541: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
542: , p6_a13 out nocopy JTF_NUMBER_TABLE
543: , p6_a14 out nocopy JTF_NUMBER_TABLE
544: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 541: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400

537: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
538: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
539: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_400
541: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_400
542: , p6_a13 out nocopy JTF_NUMBER_TABLE
543: , p6_a14 out nocopy JTF_NUMBER_TABLE
544: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
545: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 546: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400

542: , p6_a13 out nocopy JTF_NUMBER_TABLE
543: , p6_a14 out nocopy JTF_NUMBER_TABLE
544: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_200
545: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
546: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
547: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
548: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400

Line 550: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400

546: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_400
547: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_300
548: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100
549: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_400
551: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
552: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
553: );
554: procedure contract_overview(p_contract_id_arg VARCHAR2

Line 587: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400

583: , p3_a10 out nocopy VARCHAR2
584: , p4_a0 out nocopy JTF_NUMBER_TABLE
585: , p4_a1 out nocopy JTF_VARCHAR2_TABLE_100
586: , p4_a2 out nocopy JTF_VARCHAR2_TABLE_100
587: , p4_a3 out nocopy JTF_VARCHAR2_TABLE_400
588: , p4_a4 out nocopy JTF_VARCHAR2_TABLE_100
589: , p4_a5 out nocopy JTF_VARCHAR2_TABLE_100
590: , p4_a6 out nocopy JTF_VARCHAR2_TABLE_100
591: , p5_a0 out nocopy JTF_NUMBER_TABLE

Line 602: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400

598: , p5_a7 out nocopy JTF_VARCHAR2_TABLE_300
599: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
600: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
601: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
602: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
603: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
604: , p5_a13 out nocopy JTF_NUMBER_TABLE
605: , p5_a14 out nocopy JTF_NUMBER_TABLE
606: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200

Line 603: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400

599: , p5_a8 out nocopy JTF_VARCHAR2_TABLE_500
600: , p5_a9 out nocopy JTF_VARCHAR2_TABLE_500
601: , p5_a10 out nocopy JTF_VARCHAR2_TABLE_2000
602: , p5_a11 out nocopy JTF_VARCHAR2_TABLE_400
603: , p5_a12 out nocopy JTF_VARCHAR2_TABLE_400
604: , p5_a13 out nocopy JTF_NUMBER_TABLE
605: , p5_a14 out nocopy JTF_NUMBER_TABLE
606: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
607: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100

Line 608: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400

604: , p5_a13 out nocopy JTF_NUMBER_TABLE
605: , p5_a14 out nocopy JTF_NUMBER_TABLE
606: , p5_a15 out nocopy JTF_VARCHAR2_TABLE_200
607: , p5_a16 out nocopy JTF_VARCHAR2_TABLE_100
608: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
609: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
610: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
611: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
612: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400

Line 612: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400

608: , p5_a17 out nocopy JTF_VARCHAR2_TABLE_400
609: , p5_a18 out nocopy JTF_VARCHAR2_TABLE_300
610: , p5_a19 out nocopy JTF_VARCHAR2_TABLE_100
611: , p5_a20 out nocopy JTF_VARCHAR2_TABLE_100
612: , p5_a21 out nocopy JTF_VARCHAR2_TABLE_400
613: , p5_a22 out nocopy JTF_VARCHAR2_TABLE_300
614: , p5_a23 out nocopy JTF_VARCHAR2_TABLE_100
615: );
616: procedure party_overview(p_contract_id_arg VARCHAR2

Line 625: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400

621: , p3_a2 out nocopy JTF_VARCHAR2_TABLE_100
622: , p3_a3 out nocopy JTF_VARCHAR2_TABLE_100
623: , p3_a4 out nocopy JTF_DATE_TABLE
624: , p3_a5 out nocopy JTF_DATE_TABLE
625: , p3_a6 out nocopy JTF_VARCHAR2_TABLE_400
626: , p3_a7 out nocopy JTF_VARCHAR2_TABLE_100
627: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_100
628: );
629: procedure party_contacts_overview(p_contact_id_arg VARCHAR2

Line 725: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400

721: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
722: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
723: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
724: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
725: , p7_a1 out nocopy JTF_VARCHAR2_TABLE_400
726: , p8_a0 out nocopy JTF_VARCHAR2_TABLE_500
727: , p8_a1 out nocopy JTF_VARCHAR2_TABLE_500
728: , p8_a2 out nocopy JTF_VARCHAR2_TABLE_500
729: , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500