APPS.AHL_VWP_RULES_PVT_W dependencies on JTF_VARCHAR2_TABLE_300

Line 42: , a15 JTF_VARCHAR2_TABLE_300

38: , a11 JTF_NUMBER_TABLE
39: , a12 JTF_VARCHAR2_TABLE_100
40: , a13 JTF_NUMBER_TABLE
41: , a14 JTF_NUMBER_TABLE
42: , a15 JTF_VARCHAR2_TABLE_300
43: , a16 JTF_NUMBER_TABLE
44: , a17 JTF_VARCHAR2_TABLE_100
45: , a18 JTF_NUMBER_TABLE
46: , a19 JTF_NUMBER_TABLE

Line 91: , a64 JTF_VARCHAR2_TABLE_300

87: , a60 JTF_NUMBER_TABLE
88: , a61 JTF_NUMBER_TABLE
89: , a62 JTF_VARCHAR2_TABLE_100
90: , a63 JTF_NUMBER_TABLE
91: , a64 JTF_VARCHAR2_TABLE_300
92: , a65 JTF_VARCHAR2_TABLE_100
93: , a66 JTF_DATE_TABLE
94: , a67 JTF_DATE_TABLE
95: , a68 JTF_VARCHAR2_TABLE_100

Line 121: , a94 JTF_VARCHAR2_TABLE_300

117: , a90 JTF_VARCHAR2_TABLE_100
118: , a91 JTF_VARCHAR2_TABLE_100
119: , a92 JTF_VARCHAR2_TABLE_100
120: , a93 JTF_NUMBER_TABLE
121: , a94 JTF_VARCHAR2_TABLE_300
122: );
123: procedure rosetta_table_copy_out_p5(t ahl_vwp_rules_pvt.task_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
124: , a1 out nocopy JTF_NUMBER_TABLE
125: , a2 out nocopy JTF_NUMBER_TABLE

Line 138: , a15 out nocopy JTF_VARCHAR2_TABLE_300

134: , a11 out nocopy JTF_NUMBER_TABLE
135: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a13 out nocopy JTF_NUMBER_TABLE
137: , a14 out nocopy JTF_NUMBER_TABLE
138: , a15 out nocopy JTF_VARCHAR2_TABLE_300
139: , a16 out nocopy JTF_NUMBER_TABLE
140: , a17 out nocopy JTF_VARCHAR2_TABLE_100
141: , a18 out nocopy JTF_NUMBER_TABLE
142: , a19 out nocopy JTF_NUMBER_TABLE

Line 187: , a64 out nocopy JTF_VARCHAR2_TABLE_300

183: , a60 out nocopy JTF_NUMBER_TABLE
184: , a61 out nocopy JTF_NUMBER_TABLE
185: , a62 out nocopy JTF_VARCHAR2_TABLE_100
186: , a63 out nocopy JTF_NUMBER_TABLE
187: , a64 out nocopy JTF_VARCHAR2_TABLE_300
188: , a65 out nocopy JTF_VARCHAR2_TABLE_100
189: , a66 out nocopy JTF_DATE_TABLE
190: , a67 out nocopy JTF_DATE_TABLE
191: , a68 out nocopy JTF_VARCHAR2_TABLE_100

Line 217: , a94 out nocopy JTF_VARCHAR2_TABLE_300

213: , a90 out nocopy JTF_VARCHAR2_TABLE_100
214: , a91 out nocopy JTF_VARCHAR2_TABLE_100
215: , a92 out nocopy JTF_VARCHAR2_TABLE_100
216: , a93 out nocopy JTF_NUMBER_TABLE
217: , a94 out nocopy JTF_VARCHAR2_TABLE_300
218: );
219:
220: procedure insert_tasks(p_visit_id NUMBER
221: , p_unit_id NUMBER

Line 573: , p5_a15 JTF_VARCHAR2_TABLE_300

569: , p5_a11 JTF_NUMBER_TABLE
570: , p5_a12 JTF_VARCHAR2_TABLE_100
571: , p5_a13 JTF_NUMBER_TABLE
572: , p5_a14 JTF_NUMBER_TABLE
573: , p5_a15 JTF_VARCHAR2_TABLE_300
574: , p5_a16 JTF_NUMBER_TABLE
575: , p5_a17 JTF_VARCHAR2_TABLE_100
576: , p5_a18 JTF_NUMBER_TABLE
577: , p5_a19 JTF_NUMBER_TABLE

Line 622: , p5_a64 JTF_VARCHAR2_TABLE_300

618: , p5_a60 JTF_NUMBER_TABLE
619: , p5_a61 JTF_NUMBER_TABLE
620: , p5_a62 JTF_VARCHAR2_TABLE_100
621: , p5_a63 JTF_NUMBER_TABLE
622: , p5_a64 JTF_VARCHAR2_TABLE_300
623: , p5_a65 JTF_VARCHAR2_TABLE_100
624: , p5_a66 JTF_DATE_TABLE
625: , p5_a67 JTF_DATE_TABLE
626: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 652: , p5_a94 JTF_VARCHAR2_TABLE_300

648: , p5_a90 JTF_VARCHAR2_TABLE_100
649: , p5_a91 JTF_VARCHAR2_TABLE_100
650: , p5_a92 JTF_VARCHAR2_TABLE_100
651: , p5_a93 JTF_NUMBER_TABLE
652: , p5_a94 JTF_VARCHAR2_TABLE_300
653: , x_return_status out nocopy VARCHAR2
654: , x_msg_count out nocopy NUMBER
655: , x_msg_data out nocopy VARCHAR2
656: );

Line 676: , p4_a15 JTF_VARCHAR2_TABLE_300

672: , p4_a11 JTF_NUMBER_TABLE
673: , p4_a12 JTF_VARCHAR2_TABLE_100
674: , p4_a13 JTF_NUMBER_TABLE
675: , p4_a14 JTF_NUMBER_TABLE
676: , p4_a15 JTF_VARCHAR2_TABLE_300
677: , p4_a16 JTF_NUMBER_TABLE
678: , p4_a17 JTF_VARCHAR2_TABLE_100
679: , p4_a18 JTF_NUMBER_TABLE
680: , p4_a19 JTF_NUMBER_TABLE

Line 725: , p4_a64 JTF_VARCHAR2_TABLE_300

721: , p4_a60 JTF_NUMBER_TABLE
722: , p4_a61 JTF_NUMBER_TABLE
723: , p4_a62 JTF_VARCHAR2_TABLE_100
724: , p4_a63 JTF_NUMBER_TABLE
725: , p4_a64 JTF_VARCHAR2_TABLE_300
726: , p4_a65 JTF_VARCHAR2_TABLE_100
727: , p4_a66 JTF_DATE_TABLE
728: , p4_a67 JTF_DATE_TABLE
729: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 755: , p4_a94 JTF_VARCHAR2_TABLE_300

751: , p4_a90 JTF_VARCHAR2_TABLE_100
752: , p4_a91 JTF_VARCHAR2_TABLE_100
753: , p4_a92 JTF_VARCHAR2_TABLE_100
754: , p4_a93 JTF_NUMBER_TABLE
755: , p4_a94 JTF_VARCHAR2_TABLE_300
756: , x_return_status out nocopy VARCHAR2
757: , x_msg_count out nocopy NUMBER
758: , x_msg_data out nocopy VARCHAR2
759: );

Line 779: , p4_a15 JTF_VARCHAR2_TABLE_300

775: , p4_a11 JTF_NUMBER_TABLE
776: , p4_a12 JTF_VARCHAR2_TABLE_100
777: , p4_a13 JTF_NUMBER_TABLE
778: , p4_a14 JTF_NUMBER_TABLE
779: , p4_a15 JTF_VARCHAR2_TABLE_300
780: , p4_a16 JTF_NUMBER_TABLE
781: , p4_a17 JTF_VARCHAR2_TABLE_100
782: , p4_a18 JTF_NUMBER_TABLE
783: , p4_a19 JTF_NUMBER_TABLE

Line 828: , p4_a64 JTF_VARCHAR2_TABLE_300

824: , p4_a60 JTF_NUMBER_TABLE
825: , p4_a61 JTF_NUMBER_TABLE
826: , p4_a62 JTF_VARCHAR2_TABLE_100
827: , p4_a63 JTF_NUMBER_TABLE
828: , p4_a64 JTF_VARCHAR2_TABLE_300
829: , p4_a65 JTF_VARCHAR2_TABLE_100
830: , p4_a66 JTF_DATE_TABLE
831: , p4_a67 JTF_DATE_TABLE
832: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 858: , p4_a94 JTF_VARCHAR2_TABLE_300

854: , p4_a90 JTF_VARCHAR2_TABLE_100
855: , p4_a91 JTF_VARCHAR2_TABLE_100
856: , p4_a92 JTF_VARCHAR2_TABLE_100
857: , p4_a93 JTF_NUMBER_TABLE
858: , p4_a94 JTF_VARCHAR2_TABLE_300
859: , x_return_status out nocopy VARCHAR2
860: , x_msg_count out nocopy NUMBER
861: , x_msg_data out nocopy VARCHAR2
862: );

Line 882: , p4_a15 JTF_VARCHAR2_TABLE_300

878: , p4_a11 JTF_NUMBER_TABLE
879: , p4_a12 JTF_VARCHAR2_TABLE_100
880: , p4_a13 JTF_NUMBER_TABLE
881: , p4_a14 JTF_NUMBER_TABLE
882: , p4_a15 JTF_VARCHAR2_TABLE_300
883: , p4_a16 JTF_NUMBER_TABLE
884: , p4_a17 JTF_VARCHAR2_TABLE_100
885: , p4_a18 JTF_NUMBER_TABLE
886: , p4_a19 JTF_NUMBER_TABLE

Line 931: , p4_a64 JTF_VARCHAR2_TABLE_300

927: , p4_a60 JTF_NUMBER_TABLE
928: , p4_a61 JTF_NUMBER_TABLE
929: , p4_a62 JTF_VARCHAR2_TABLE_100
930: , p4_a63 JTF_NUMBER_TABLE
931: , p4_a64 JTF_VARCHAR2_TABLE_300
932: , p4_a65 JTF_VARCHAR2_TABLE_100
933: , p4_a66 JTF_DATE_TABLE
934: , p4_a67 JTF_DATE_TABLE
935: , p4_a68 JTF_VARCHAR2_TABLE_100

Line 961: , p4_a94 JTF_VARCHAR2_TABLE_300

957: , p4_a90 JTF_VARCHAR2_TABLE_100
958: , p4_a91 JTF_VARCHAR2_TABLE_100
959: , p4_a92 JTF_VARCHAR2_TABLE_100
960: , p4_a93 JTF_NUMBER_TABLE
961: , p4_a94 JTF_VARCHAR2_TABLE_300
962: , x_return_status out nocopy VARCHAR2
963: , x_msg_count out nocopy NUMBER
964: , x_msg_data out nocopy VARCHAR2
965: );

Line 987: , p6_a15 JTF_VARCHAR2_TABLE_300

983: , p6_a11 JTF_NUMBER_TABLE
984: , p6_a12 JTF_VARCHAR2_TABLE_100
985: , p6_a13 JTF_NUMBER_TABLE
986: , p6_a14 JTF_NUMBER_TABLE
987: , p6_a15 JTF_VARCHAR2_TABLE_300
988: , p6_a16 JTF_NUMBER_TABLE
989: , p6_a17 JTF_VARCHAR2_TABLE_100
990: , p6_a18 JTF_NUMBER_TABLE
991: , p6_a19 JTF_NUMBER_TABLE

Line 1036: , p6_a64 JTF_VARCHAR2_TABLE_300

1032: , p6_a60 JTF_NUMBER_TABLE
1033: , p6_a61 JTF_NUMBER_TABLE
1034: , p6_a62 JTF_VARCHAR2_TABLE_100
1035: , p6_a63 JTF_NUMBER_TABLE
1036: , p6_a64 JTF_VARCHAR2_TABLE_300
1037: , p6_a65 JTF_VARCHAR2_TABLE_100
1038: , p6_a66 JTF_DATE_TABLE
1039: , p6_a67 JTF_DATE_TABLE
1040: , p6_a68 JTF_VARCHAR2_TABLE_100

Line 1066: , p6_a94 JTF_VARCHAR2_TABLE_300

1062: , p6_a90 JTF_VARCHAR2_TABLE_100
1063: , p6_a91 JTF_VARCHAR2_TABLE_100
1064: , p6_a92 JTF_VARCHAR2_TABLE_100
1065: , p6_a93 JTF_NUMBER_TABLE
1066: , p6_a94 JTF_VARCHAR2_TABLE_300
1067: , x_return_status out nocopy VARCHAR2
1068: , x_msg_count out nocopy NUMBER
1069: , x_msg_data out nocopy VARCHAR2
1070: );

Line 1091: , p5_a15 JTF_VARCHAR2_TABLE_300

1087: , p5_a11 JTF_NUMBER_TABLE
1088: , p5_a12 JTF_VARCHAR2_TABLE_100
1089: , p5_a13 JTF_NUMBER_TABLE
1090: , p5_a14 JTF_NUMBER_TABLE
1091: , p5_a15 JTF_VARCHAR2_TABLE_300
1092: , p5_a16 JTF_NUMBER_TABLE
1093: , p5_a17 JTF_VARCHAR2_TABLE_100
1094: , p5_a18 JTF_NUMBER_TABLE
1095: , p5_a19 JTF_NUMBER_TABLE

Line 1140: , p5_a64 JTF_VARCHAR2_TABLE_300

1136: , p5_a60 JTF_NUMBER_TABLE
1137: , p5_a61 JTF_NUMBER_TABLE
1138: , p5_a62 JTF_VARCHAR2_TABLE_100
1139: , p5_a63 JTF_NUMBER_TABLE
1140: , p5_a64 JTF_VARCHAR2_TABLE_300
1141: , p5_a65 JTF_VARCHAR2_TABLE_100
1142: , p5_a66 JTF_DATE_TABLE
1143: , p5_a67 JTF_DATE_TABLE
1144: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 1170: , p5_a94 JTF_VARCHAR2_TABLE_300

1166: , p5_a90 JTF_VARCHAR2_TABLE_100
1167: , p5_a91 JTF_VARCHAR2_TABLE_100
1168: , p5_a92 JTF_VARCHAR2_TABLE_100
1169: , p5_a93 JTF_NUMBER_TABLE
1170: , p5_a94 JTF_VARCHAR2_TABLE_300
1171: , x_return_status out nocopy VARCHAR2
1172: , x_msg_count out nocopy NUMBER
1173: , x_msg_data out nocopy VARCHAR2
1174: );

Line 1195: , p5_a15 JTF_VARCHAR2_TABLE_300

1191: , p5_a11 JTF_NUMBER_TABLE
1192: , p5_a12 JTF_VARCHAR2_TABLE_100
1193: , p5_a13 JTF_NUMBER_TABLE
1194: , p5_a14 JTF_NUMBER_TABLE
1195: , p5_a15 JTF_VARCHAR2_TABLE_300
1196: , p5_a16 JTF_NUMBER_TABLE
1197: , p5_a17 JTF_VARCHAR2_TABLE_100
1198: , p5_a18 JTF_NUMBER_TABLE
1199: , p5_a19 JTF_NUMBER_TABLE

Line 1244: , p5_a64 JTF_VARCHAR2_TABLE_300

1240: , p5_a60 JTF_NUMBER_TABLE
1241: , p5_a61 JTF_NUMBER_TABLE
1242: , p5_a62 JTF_VARCHAR2_TABLE_100
1243: , p5_a63 JTF_NUMBER_TABLE
1244: , p5_a64 JTF_VARCHAR2_TABLE_300
1245: , p5_a65 JTF_VARCHAR2_TABLE_100
1246: , p5_a66 JTF_DATE_TABLE
1247: , p5_a67 JTF_DATE_TABLE
1248: , p5_a68 JTF_VARCHAR2_TABLE_100

Line 1274: , p5_a94 JTF_VARCHAR2_TABLE_300

1270: , p5_a90 JTF_VARCHAR2_TABLE_100
1271: , p5_a91 JTF_VARCHAR2_TABLE_100
1272: , p5_a92 JTF_VARCHAR2_TABLE_100
1273: , p5_a93 JTF_NUMBER_TABLE
1274: , p5_a94 JTF_VARCHAR2_TABLE_300
1275: , x_return_status out nocopy VARCHAR2
1276: , x_msg_count out nocopy NUMBER
1277: , x_msg_data out nocopy VARCHAR2
1278: );