1: package okl_sfe_pvt_w as
2: /* $Header: OKLISFES.pls 120.3 2005/10/11 06:38:35 rgooty noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sfe_pvt.sfe_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLISFES.pls 120.3 2005/10/11 06:38:35 rgooty noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sfe_pvt.sfe_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_DATE_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_2000
50: , a47 JTF_VARCHAR2_TABLE_500
51: , a48 JTF_VARCHAR2_TABLE_500
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
54: , a51 JTF_DATE_TABLE
55: , a52 JTF_DATE_TABLE
56: , a53 JTF_NUMBER_TABLE
57: , a54 JTF_NUMBER_TABLE
58: );
51: , a48 JTF_VARCHAR2_TABLE_500
52: , a49 JTF_NUMBER_TABLE
53: , a50 JTF_NUMBER_TABLE
54: , a51 JTF_DATE_TABLE
55: , a52 JTF_DATE_TABLE
56: , a53 JTF_NUMBER_TABLE
57: , a54 JTF_NUMBER_TABLE
58: );
59: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
57: , a54 JTF_NUMBER_TABLE
58: );
59: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_DATE_TABLE
62: , a3 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_NUMBER_TABLE
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
58: );
59: procedure rosetta_table_copy_out_p2(t okl_sfe_pvt.sfe_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
60: , a1 out nocopy JTF_VARCHAR2_TABLE_100
61: , a2 out nocopy JTF_DATE_TABLE
62: , a3 out nocopy JTF_DATE_TABLE
63: , a4 out nocopy JTF_NUMBER_TABLE
64: , a5 out nocopy JTF_VARCHAR2_TABLE_100
65: , a6 out nocopy JTF_VARCHAR2_TABLE_100
66: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
106: , a47 out nocopy JTF_VARCHAR2_TABLE_500
107: , a48 out nocopy JTF_VARCHAR2_TABLE_500
108: , a49 out nocopy JTF_NUMBER_TABLE
109: , a50 out nocopy JTF_NUMBER_TABLE
110: , a51 out nocopy JTF_DATE_TABLE
111: , a52 out nocopy JTF_DATE_TABLE
112: , a53 out nocopy JTF_NUMBER_TABLE
113: , a54 out nocopy JTF_NUMBER_TABLE
114: );
107: , a48 out nocopy JTF_VARCHAR2_TABLE_500
108: , a49 out nocopy JTF_NUMBER_TABLE
109: , a50 out nocopy JTF_NUMBER_TABLE
110: , a51 out nocopy JTF_DATE_TABLE
111: , a52 out nocopy JTF_DATE_TABLE
112: , a53 out nocopy JTF_NUMBER_TABLE
113: , a54 out nocopy JTF_NUMBER_TABLE
114: );
115:
114: );
115:
116: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_VARCHAR2_TABLE_100
118: , a2 JTF_DATE_TABLE
119: , a3 JTF_DATE_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
115:
116: procedure rosetta_table_copy_in_p5(t out nocopy okl_sfe_pvt.sfev_tbl_type, a0 JTF_NUMBER_TABLE
117: , a1 JTF_VARCHAR2_TABLE_100
118: , a2 JTF_DATE_TABLE
119: , a3 JTF_DATE_TABLE
120: , a4 JTF_NUMBER_TABLE
121: , a5 JTF_VARCHAR2_TABLE_100
122: , a6 JTF_VARCHAR2_TABLE_100
123: , a7 JTF_VARCHAR2_TABLE_2000
163: , a47 JTF_VARCHAR2_TABLE_500
164: , a48 JTF_VARCHAR2_TABLE_500
165: , a49 JTF_NUMBER_TABLE
166: , a50 JTF_NUMBER_TABLE
167: , a51 JTF_DATE_TABLE
168: , a52 JTF_DATE_TABLE
169: , a53 JTF_NUMBER_TABLE
170: , a54 JTF_NUMBER_TABLE
171: );
164: , a48 JTF_VARCHAR2_TABLE_500
165: , a49 JTF_NUMBER_TABLE
166: , a50 JTF_NUMBER_TABLE
167: , a51 JTF_DATE_TABLE
168: , a52 JTF_DATE_TABLE
169: , a53 JTF_NUMBER_TABLE
170: , a54 JTF_NUMBER_TABLE
171: );
172: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
170: , a54 JTF_NUMBER_TABLE
171: );
172: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
173: , a1 out nocopy JTF_VARCHAR2_TABLE_100
174: , a2 out nocopy JTF_DATE_TABLE
175: , a3 out nocopy JTF_DATE_TABLE
176: , a4 out nocopy JTF_NUMBER_TABLE
177: , a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , a6 out nocopy JTF_VARCHAR2_TABLE_100
171: );
172: procedure rosetta_table_copy_out_p5(t okl_sfe_pvt.sfev_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
173: , a1 out nocopy JTF_VARCHAR2_TABLE_100
174: , a2 out nocopy JTF_DATE_TABLE
175: , a3 out nocopy JTF_DATE_TABLE
176: , a4 out nocopy JTF_NUMBER_TABLE
177: , a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , a6 out nocopy JTF_VARCHAR2_TABLE_100
179: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
219: , a47 out nocopy JTF_VARCHAR2_TABLE_500
220: , a48 out nocopy JTF_VARCHAR2_TABLE_500
221: , a49 out nocopy JTF_NUMBER_TABLE
222: , a50 out nocopy JTF_NUMBER_TABLE
223: , a51 out nocopy JTF_DATE_TABLE
224: , a52 out nocopy JTF_DATE_TABLE
225: , a53 out nocopy JTF_NUMBER_TABLE
226: , a54 out nocopy JTF_NUMBER_TABLE
227: );
220: , a48 out nocopy JTF_VARCHAR2_TABLE_500
221: , a49 out nocopy JTF_NUMBER_TABLE
222: , a50 out nocopy JTF_NUMBER_TABLE
223: , a51 out nocopy JTF_DATE_TABLE
224: , a52 out nocopy JTF_DATE_TABLE
225: , a53 out nocopy JTF_NUMBER_TABLE
226: , a54 out nocopy JTF_NUMBER_TABLE
227: );
228:
348: , x_msg_count out nocopy NUMBER
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_VARCHAR2_TABLE_100
352: , p5_a2 JTF_DATE_TABLE
353: , p5_a3 JTF_DATE_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_VARCHAR2_TABLE_100
356: , p5_a6 JTF_VARCHAR2_TABLE_100
349: , x_msg_data out nocopy VARCHAR2
350: , p5_a0 JTF_NUMBER_TABLE
351: , p5_a1 JTF_VARCHAR2_TABLE_100
352: , p5_a2 JTF_DATE_TABLE
353: , p5_a3 JTF_DATE_TABLE
354: , p5_a4 JTF_NUMBER_TABLE
355: , p5_a5 JTF_VARCHAR2_TABLE_100
356: , p5_a6 JTF_VARCHAR2_TABLE_100
357: , p5_a7 JTF_VARCHAR2_TABLE_2000
397: , p5_a47 JTF_VARCHAR2_TABLE_500
398: , p5_a48 JTF_VARCHAR2_TABLE_500
399: , p5_a49 JTF_NUMBER_TABLE
400: , p5_a50 JTF_NUMBER_TABLE
401: , p5_a51 JTF_DATE_TABLE
402: , p5_a52 JTF_DATE_TABLE
403: , p5_a53 JTF_NUMBER_TABLE
404: , p5_a54 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
398: , p5_a48 JTF_VARCHAR2_TABLE_500
399: , p5_a49 JTF_NUMBER_TABLE
400: , p5_a50 JTF_NUMBER_TABLE
401: , p5_a51 JTF_DATE_TABLE
402: , p5_a52 JTF_DATE_TABLE
403: , p5_a53 JTF_NUMBER_TABLE
404: , p5_a54 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
403: , p5_a53 JTF_NUMBER_TABLE
404: , p5_a54 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
407: , p6_a2 out nocopy JTF_DATE_TABLE
408: , p6_a3 out nocopy JTF_DATE_TABLE
409: , p6_a4 out nocopy JTF_NUMBER_TABLE
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
404: , p5_a54 JTF_NUMBER_TABLE
405: , p6_a0 out nocopy JTF_NUMBER_TABLE
406: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
407: , p6_a2 out nocopy JTF_DATE_TABLE
408: , p6_a3 out nocopy JTF_DATE_TABLE
409: , p6_a4 out nocopy JTF_NUMBER_TABLE
410: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
411: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
412: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
452: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
453: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
454: , p6_a49 out nocopy JTF_NUMBER_TABLE
455: , p6_a50 out nocopy JTF_NUMBER_TABLE
456: , p6_a51 out nocopy JTF_DATE_TABLE
457: , p6_a52 out nocopy JTF_DATE_TABLE
458: , p6_a53 out nocopy JTF_NUMBER_TABLE
459: , p6_a54 out nocopy JTF_NUMBER_TABLE
460: );
453: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
454: , p6_a49 out nocopy JTF_NUMBER_TABLE
455: , p6_a50 out nocopy JTF_NUMBER_TABLE
456: , p6_a51 out nocopy JTF_DATE_TABLE
457: , p6_a52 out nocopy JTF_DATE_TABLE
458: , p6_a53 out nocopy JTF_NUMBER_TABLE
459: , p6_a54 out nocopy JTF_NUMBER_TABLE
460: );
461: procedure lock_row(p_api_version NUMBER
525: , x_msg_count out nocopy NUMBER
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_VARCHAR2_TABLE_100
529: , p5_a2 JTF_DATE_TABLE
530: , p5_a3 JTF_DATE_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
533: , p5_a6 JTF_VARCHAR2_TABLE_100
526: , x_msg_data out nocopy VARCHAR2
527: , p5_a0 JTF_NUMBER_TABLE
528: , p5_a1 JTF_VARCHAR2_TABLE_100
529: , p5_a2 JTF_DATE_TABLE
530: , p5_a3 JTF_DATE_TABLE
531: , p5_a4 JTF_NUMBER_TABLE
532: , p5_a5 JTF_VARCHAR2_TABLE_100
533: , p5_a6 JTF_VARCHAR2_TABLE_100
534: , p5_a7 JTF_VARCHAR2_TABLE_2000
574: , p5_a47 JTF_VARCHAR2_TABLE_500
575: , p5_a48 JTF_VARCHAR2_TABLE_500
576: , p5_a49 JTF_NUMBER_TABLE
577: , p5_a50 JTF_NUMBER_TABLE
578: , p5_a51 JTF_DATE_TABLE
579: , p5_a52 JTF_DATE_TABLE
580: , p5_a53 JTF_NUMBER_TABLE
581: , p5_a54 JTF_NUMBER_TABLE
582: );
575: , p5_a48 JTF_VARCHAR2_TABLE_500
576: , p5_a49 JTF_NUMBER_TABLE
577: , p5_a50 JTF_NUMBER_TABLE
578: , p5_a51 JTF_DATE_TABLE
579: , p5_a52 JTF_DATE_TABLE
580: , p5_a53 JTF_NUMBER_TABLE
581: , p5_a54 JTF_NUMBER_TABLE
582: );
583: procedure update_row(p_api_version NUMBER
702: , x_msg_count out nocopy NUMBER
703: , x_msg_data out nocopy VARCHAR2
704: , p5_a0 JTF_NUMBER_TABLE
705: , p5_a1 JTF_VARCHAR2_TABLE_100
706: , p5_a2 JTF_DATE_TABLE
707: , p5_a3 JTF_DATE_TABLE
708: , p5_a4 JTF_NUMBER_TABLE
709: , p5_a5 JTF_VARCHAR2_TABLE_100
710: , p5_a6 JTF_VARCHAR2_TABLE_100
703: , x_msg_data out nocopy VARCHAR2
704: , p5_a0 JTF_NUMBER_TABLE
705: , p5_a1 JTF_VARCHAR2_TABLE_100
706: , p5_a2 JTF_DATE_TABLE
707: , p5_a3 JTF_DATE_TABLE
708: , p5_a4 JTF_NUMBER_TABLE
709: , p5_a5 JTF_VARCHAR2_TABLE_100
710: , p5_a6 JTF_VARCHAR2_TABLE_100
711: , p5_a7 JTF_VARCHAR2_TABLE_2000
751: , p5_a47 JTF_VARCHAR2_TABLE_500
752: , p5_a48 JTF_VARCHAR2_TABLE_500
753: , p5_a49 JTF_NUMBER_TABLE
754: , p5_a50 JTF_NUMBER_TABLE
755: , p5_a51 JTF_DATE_TABLE
756: , p5_a52 JTF_DATE_TABLE
757: , p5_a53 JTF_NUMBER_TABLE
758: , p5_a54 JTF_NUMBER_TABLE
759: , p6_a0 out nocopy JTF_NUMBER_TABLE
752: , p5_a48 JTF_VARCHAR2_TABLE_500
753: , p5_a49 JTF_NUMBER_TABLE
754: , p5_a50 JTF_NUMBER_TABLE
755: , p5_a51 JTF_DATE_TABLE
756: , p5_a52 JTF_DATE_TABLE
757: , p5_a53 JTF_NUMBER_TABLE
758: , p5_a54 JTF_NUMBER_TABLE
759: , p6_a0 out nocopy JTF_NUMBER_TABLE
760: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
757: , p5_a53 JTF_NUMBER_TABLE
758: , p5_a54 JTF_NUMBER_TABLE
759: , p6_a0 out nocopy JTF_NUMBER_TABLE
760: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a2 out nocopy JTF_DATE_TABLE
762: , p6_a3 out nocopy JTF_DATE_TABLE
763: , p6_a4 out nocopy JTF_NUMBER_TABLE
764: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
758: , p5_a54 JTF_NUMBER_TABLE
759: , p6_a0 out nocopy JTF_NUMBER_TABLE
760: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
761: , p6_a2 out nocopy JTF_DATE_TABLE
762: , p6_a3 out nocopy JTF_DATE_TABLE
763: , p6_a4 out nocopy JTF_NUMBER_TABLE
764: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
765: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
766: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
806: , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
807: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a49 out nocopy JTF_NUMBER_TABLE
809: , p6_a50 out nocopy JTF_NUMBER_TABLE
810: , p6_a51 out nocopy JTF_DATE_TABLE
811: , p6_a52 out nocopy JTF_DATE_TABLE
812: , p6_a53 out nocopy JTF_NUMBER_TABLE
813: , p6_a54 out nocopy JTF_NUMBER_TABLE
814: );
807: , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
808: , p6_a49 out nocopy JTF_NUMBER_TABLE
809: , p6_a50 out nocopy JTF_NUMBER_TABLE
810: , p6_a51 out nocopy JTF_DATE_TABLE
811: , p6_a52 out nocopy JTF_DATE_TABLE
812: , p6_a53 out nocopy JTF_NUMBER_TABLE
813: , p6_a54 out nocopy JTF_NUMBER_TABLE
814: );
815: procedure delete_row(p_api_version NUMBER
879: , x_msg_count out nocopy NUMBER
880: , x_msg_data out nocopy VARCHAR2
881: , p5_a0 JTF_NUMBER_TABLE
882: , p5_a1 JTF_VARCHAR2_TABLE_100
883: , p5_a2 JTF_DATE_TABLE
884: , p5_a3 JTF_DATE_TABLE
885: , p5_a4 JTF_NUMBER_TABLE
886: , p5_a5 JTF_VARCHAR2_TABLE_100
887: , p5_a6 JTF_VARCHAR2_TABLE_100
880: , x_msg_data out nocopy VARCHAR2
881: , p5_a0 JTF_NUMBER_TABLE
882: , p5_a1 JTF_VARCHAR2_TABLE_100
883: , p5_a2 JTF_DATE_TABLE
884: , p5_a3 JTF_DATE_TABLE
885: , p5_a4 JTF_NUMBER_TABLE
886: , p5_a5 JTF_VARCHAR2_TABLE_100
887: , p5_a6 JTF_VARCHAR2_TABLE_100
888: , p5_a7 JTF_VARCHAR2_TABLE_2000
928: , p5_a47 JTF_VARCHAR2_TABLE_500
929: , p5_a48 JTF_VARCHAR2_TABLE_500
930: , p5_a49 JTF_NUMBER_TABLE
931: , p5_a50 JTF_NUMBER_TABLE
932: , p5_a51 JTF_DATE_TABLE
933: , p5_a52 JTF_DATE_TABLE
934: , p5_a53 JTF_NUMBER_TABLE
935: , p5_a54 JTF_NUMBER_TABLE
936: );
929: , p5_a48 JTF_VARCHAR2_TABLE_500
930: , p5_a49 JTF_NUMBER_TABLE
931: , p5_a50 JTF_NUMBER_TABLE
932: , p5_a51 JTF_DATE_TABLE
933: , p5_a52 JTF_DATE_TABLE
934: , p5_a53 JTF_NUMBER_TABLE
935: , p5_a54 JTF_NUMBER_TABLE
936: );
937: procedure validate_row(p_api_version NUMBER
1001: , x_msg_count out nocopy NUMBER
1002: , x_msg_data out nocopy VARCHAR2
1003: , p5_a0 JTF_NUMBER_TABLE
1004: , p5_a1 JTF_VARCHAR2_TABLE_100
1005: , p5_a2 JTF_DATE_TABLE
1006: , p5_a3 JTF_DATE_TABLE
1007: , p5_a4 JTF_NUMBER_TABLE
1008: , p5_a5 JTF_VARCHAR2_TABLE_100
1009: , p5_a6 JTF_VARCHAR2_TABLE_100
1002: , x_msg_data out nocopy VARCHAR2
1003: , p5_a0 JTF_NUMBER_TABLE
1004: , p5_a1 JTF_VARCHAR2_TABLE_100
1005: , p5_a2 JTF_DATE_TABLE
1006: , p5_a3 JTF_DATE_TABLE
1007: , p5_a4 JTF_NUMBER_TABLE
1008: , p5_a5 JTF_VARCHAR2_TABLE_100
1009: , p5_a6 JTF_VARCHAR2_TABLE_100
1010: , p5_a7 JTF_VARCHAR2_TABLE_2000
1050: , p5_a47 JTF_VARCHAR2_TABLE_500
1051: , p5_a48 JTF_VARCHAR2_TABLE_500
1052: , p5_a49 JTF_NUMBER_TABLE
1053: , p5_a50 JTF_NUMBER_TABLE
1054: , p5_a51 JTF_DATE_TABLE
1055: , p5_a52 JTF_DATE_TABLE
1056: , p5_a53 JTF_NUMBER_TABLE
1057: , p5_a54 JTF_NUMBER_TABLE
1058: );
1051: , p5_a48 JTF_VARCHAR2_TABLE_500
1052: , p5_a49 JTF_NUMBER_TABLE
1053: , p5_a50 JTF_NUMBER_TABLE
1054: , p5_a51 JTF_DATE_TABLE
1055: , p5_a52 JTF_DATE_TABLE
1056: , p5_a53 JTF_NUMBER_TABLE
1057: , p5_a54 JTF_NUMBER_TABLE
1058: );
1059: end okl_sfe_pvt_w;