APPS.OKL_AEH_PVT_W dependencies on OKL_AEH_PVT

Line 1: package body okl_aeh_pvt_w as

1: package body okl_aeh_pvt_w as
2: /* $Header: OKLIAEHB.pls 120.2 2005/12/02 12:57:39 dkagrawa noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_aeh_pvt.aeh_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_VARCHAR2_TABLE_100
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

89: end loop;
90: end if;
91: end if;
92: end rosetta_table_copy_in_p2;
93: procedure rosetta_table_copy_out_p2(t okl_aeh_pvt.aeh_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
94: , a1 out nocopy JTF_VARCHAR2_TABLE_100
95: , a2 out nocopy JTF_NUMBER_TABLE
96: , a3 out nocopy JTF_NUMBER_TABLE
97: , a4 out nocopy JTF_NUMBER_TABLE

Line 247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100

243: end if;
244: end if;
245: end rosetta_table_copy_out_p2;
246:
247: procedure rosetta_table_copy_in_p5(t out nocopy okl_aeh_pvt.aehv_tbl_type, a0 JTF_VARCHAR2_TABLE_100
248: , a1 JTF_NUMBER_TABLE
249: , a2 JTF_NUMBER_TABLE
250: , a3 JTF_NUMBER_TABLE
251: , a4 JTF_NUMBER_TABLE

Line 318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

314: end loop;
315: end if;
316: end if;
317: end rosetta_table_copy_in_p5;
318: procedure rosetta_table_copy_out_p5(t okl_aeh_pvt.aehv_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
319: , a1 out nocopy JTF_NUMBER_TABLE
320: , a2 out nocopy JTF_NUMBER_TABLE
321: , a3 out nocopy JTF_NUMBER_TABLE
322: , a4 out nocopy JTF_NUMBER_TABLE

Line 472: procedure rosetta_table_copy_in_p6(t out nocopy okl_aeh_pvt.ae_header_id_typ, a0 JTF_NUMBER_TABLE) as

468: end if;
469: end if;
470: end rosetta_table_copy_out_p5;
471:
472: procedure rosetta_table_copy_in_p6(t out nocopy okl_aeh_pvt.ae_header_id_typ, a0 JTF_NUMBER_TABLE) as
473: ddindx binary_integer; indx binary_integer;
474: begin
475: if a0 is not null and a0.count > 0 then
476: if a0.count > 0 then

Line 490: procedure rosetta_table_copy_out_p6(t okl_aeh_pvt.ae_header_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

486: end loop;
487: end if;
488: end if;
489: end rosetta_table_copy_in_p6;
490: procedure rosetta_table_copy_out_p6(t okl_aeh_pvt.ae_header_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
491: ddindx binary_integer; indx binary_integer;
492: begin
493: if t is null or t.count = 0 then
494: a0 := JTF_NUMBER_TABLE();

Line 513: procedure rosetta_table_copy_in_p7(t out nocopy okl_aeh_pvt.post_to_gl_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as

509: end if;
510: end if;
511: end rosetta_table_copy_out_p6;
512:
513: procedure rosetta_table_copy_in_p7(t out nocopy okl_aeh_pvt.post_to_gl_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as
514: ddindx binary_integer; indx binary_integer;
515: begin
516: if a0 is not null and a0.count > 0 then
517: if a0.count > 0 then

Line 531: procedure rosetta_table_copy_out_p7(t okl_aeh_pvt.post_to_gl_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

527: end loop;
528: end if;
529: end if;
530: end rosetta_table_copy_in_p7;
531: procedure rosetta_table_copy_out_p7(t okl_aeh_pvt.post_to_gl_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
532: ddindx binary_integer; indx binary_integer;
533: begin
534: if t is null or t.count = 0 then
535: a0 := JTF_VARCHAR2_TABLE_100();

Line 554: procedure rosetta_table_copy_in_p8(t out nocopy okl_aeh_pvt.set_of_books_id_typ, a0 JTF_NUMBER_TABLE) as

550: end if;
551: end if;
552: end rosetta_table_copy_out_p7;
553:
554: procedure rosetta_table_copy_in_p8(t out nocopy okl_aeh_pvt.set_of_books_id_typ, a0 JTF_NUMBER_TABLE) as
555: ddindx binary_integer; indx binary_integer;
556: begin
557: if a0 is not null and a0.count > 0 then
558: if a0.count > 0 then

Line 572: procedure rosetta_table_copy_out_p8(t okl_aeh_pvt.set_of_books_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

568: end loop;
569: end if;
570: end if;
571: end rosetta_table_copy_in_p8;
572: procedure rosetta_table_copy_out_p8(t okl_aeh_pvt.set_of_books_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
573: ddindx binary_integer; indx binary_integer;
574: begin
575: if t is null or t.count = 0 then
576: a0 := JTF_NUMBER_TABLE();

Line 595: procedure rosetta_table_copy_in_p9(t out nocopy okl_aeh_pvt.accounting_event_id_typ, a0 JTF_NUMBER_TABLE) as

591: end if;
592: end if;
593: end rosetta_table_copy_out_p8;
594:
595: procedure rosetta_table_copy_in_p9(t out nocopy okl_aeh_pvt.accounting_event_id_typ, a0 JTF_NUMBER_TABLE) as
596: ddindx binary_integer; indx binary_integer;
597: begin
598: if a0 is not null and a0.count > 0 then
599: if a0.count > 0 then

Line 613: procedure rosetta_table_copy_out_p9(t okl_aeh_pvt.accounting_event_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

609: end loop;
610: end if;
611: end if;
612: end rosetta_table_copy_in_p9;
613: procedure rosetta_table_copy_out_p9(t okl_aeh_pvt.accounting_event_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
614: ddindx binary_integer; indx binary_integer;
615: begin
616: if t is null or t.count = 0 then
617: a0 := JTF_NUMBER_TABLE();

Line 636: procedure rosetta_table_copy_in_p10(t out nocopy okl_aeh_pvt.object_version_number_typ, a0 JTF_NUMBER_TABLE) as

632: end if;
633: end if;
634: end rosetta_table_copy_out_p9;
635:
636: procedure rosetta_table_copy_in_p10(t out nocopy okl_aeh_pvt.object_version_number_typ, a0 JTF_NUMBER_TABLE) as
637: ddindx binary_integer; indx binary_integer;
638: begin
639: if a0 is not null and a0.count > 0 then
640: if a0.count > 0 then

Line 654: procedure rosetta_table_copy_out_p10(t okl_aeh_pvt.object_version_number_typ, a0 out nocopy JTF_NUMBER_TABLE) as

650: end loop;
651: end if;
652: end if;
653: end rosetta_table_copy_in_p10;
654: procedure rosetta_table_copy_out_p10(t okl_aeh_pvt.object_version_number_typ, a0 out nocopy JTF_NUMBER_TABLE) as
655: ddindx binary_integer; indx binary_integer;
656: begin
657: if t is null or t.count = 0 then
658: a0 := JTF_NUMBER_TABLE();

Line 677: procedure rosetta_table_copy_in_p11(t out nocopy okl_aeh_pvt.ae_category_typ, a0 JTF_VARCHAR2_TABLE_100) as

673: end if;
674: end if;
675: end rosetta_table_copy_out_p10;
676:
677: procedure rosetta_table_copy_in_p11(t out nocopy okl_aeh_pvt.ae_category_typ, a0 JTF_VARCHAR2_TABLE_100) as
678: ddindx binary_integer; indx binary_integer;
679: begin
680: if a0 is not null and a0.count > 0 then
681: if a0.count > 0 then

Line 695: procedure rosetta_table_copy_out_p11(t okl_aeh_pvt.ae_category_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

691: end loop;
692: end if;
693: end if;
694: end rosetta_table_copy_in_p11;
695: procedure rosetta_table_copy_out_p11(t okl_aeh_pvt.ae_category_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
696: ddindx binary_integer; indx binary_integer;
697: begin
698: if t is null or t.count = 0 then
699: a0 := JTF_VARCHAR2_TABLE_100();

Line 718: procedure rosetta_table_copy_in_p12(t out nocopy okl_aeh_pvt.period_name_typ, a0 JTF_VARCHAR2_TABLE_100) as

714: end if;
715: end if;
716: end rosetta_table_copy_out_p11;
717:
718: procedure rosetta_table_copy_in_p12(t out nocopy okl_aeh_pvt.period_name_typ, a0 JTF_VARCHAR2_TABLE_100) as
719: ddindx binary_integer; indx binary_integer;
720: begin
721: if a0 is not null and a0.count > 0 then
722: if a0.count > 0 then

Line 736: procedure rosetta_table_copy_out_p12(t okl_aeh_pvt.period_name_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

732: end loop;
733: end if;
734: end if;
735: end rosetta_table_copy_in_p12;
736: procedure rosetta_table_copy_out_p12(t okl_aeh_pvt.period_name_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
737: ddindx binary_integer; indx binary_integer;
738: begin
739: if t is null or t.count = 0 then
740: a0 := JTF_VARCHAR2_TABLE_100();

Line 759: procedure rosetta_table_copy_in_p13(t out nocopy okl_aeh_pvt.accounting_date_typ, a0 JTF_DATE_TABLE) as

755: end if;
756: end if;
757: end rosetta_table_copy_out_p12;
758:
759: procedure rosetta_table_copy_in_p13(t out nocopy okl_aeh_pvt.accounting_date_typ, a0 JTF_DATE_TABLE) as
760: ddindx binary_integer; indx binary_integer;
761: begin
762: if a0 is not null and a0.count > 0 then
763: if a0.count > 0 then

Line 777: procedure rosetta_table_copy_out_p13(t okl_aeh_pvt.accounting_date_typ, a0 out nocopy JTF_DATE_TABLE) as

773: end loop;
774: end if;
775: end if;
776: end rosetta_table_copy_in_p13;
777: procedure rosetta_table_copy_out_p13(t okl_aeh_pvt.accounting_date_typ, a0 out nocopy JTF_DATE_TABLE) as
778: ddindx binary_integer; indx binary_integer;
779: begin
780: if t is null or t.count = 0 then
781: a0 := JTF_DATE_TABLE();

Line 800: procedure rosetta_table_copy_in_p14(t out nocopy okl_aeh_pvt.gl_transfer_run_id_typ, a0 JTF_NUMBER_TABLE) as

796: end if;
797: end if;
798: end rosetta_table_copy_out_p13;
799:
800: procedure rosetta_table_copy_in_p14(t out nocopy okl_aeh_pvt.gl_transfer_run_id_typ, a0 JTF_NUMBER_TABLE) as
801: ddindx binary_integer; indx binary_integer;
802: begin
803: if a0 is not null and a0.count > 0 then
804: if a0.count > 0 then

Line 818: procedure rosetta_table_copy_out_p14(t okl_aeh_pvt.gl_transfer_run_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

814: end loop;
815: end if;
816: end if;
817: end rosetta_table_copy_in_p14;
818: procedure rosetta_table_copy_out_p14(t okl_aeh_pvt.gl_transfer_run_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
819: ddindx binary_integer; indx binary_integer;
820: begin
821: if t is null or t.count = 0 then
822: a0 := JTF_NUMBER_TABLE();

Line 841: procedure rosetta_table_copy_in_p15(t out nocopy okl_aeh_pvt.cross_currency_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as

837: end if;
838: end if;
839: end rosetta_table_copy_out_p14;
840:
841: procedure rosetta_table_copy_in_p15(t out nocopy okl_aeh_pvt.cross_currency_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as
842: ddindx binary_integer; indx binary_integer;
843: begin
844: if a0 is not null and a0.count > 0 then
845: if a0.count > 0 then

Line 859: procedure rosetta_table_copy_out_p15(t okl_aeh_pvt.cross_currency_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

855: end loop;
856: end if;
857: end if;
858: end rosetta_table_copy_in_p15;
859: procedure rosetta_table_copy_out_p15(t okl_aeh_pvt.cross_currency_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
860: ddindx binary_integer; indx binary_integer;
861: begin
862: if t is null or t.count = 0 then
863: a0 := JTF_VARCHAR2_TABLE_100();

Line 882: procedure rosetta_table_copy_in_p16(t out nocopy okl_aeh_pvt.gl_transfer_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as

878: end if;
879: end if;
880: end rosetta_table_copy_out_p15;
881:
882: procedure rosetta_table_copy_in_p16(t out nocopy okl_aeh_pvt.gl_transfer_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as
883: ddindx binary_integer; indx binary_integer;
884: begin
885: if a0 is not null and a0.count > 0 then
886: if a0.count > 0 then

Line 900: procedure rosetta_table_copy_out_p16(t okl_aeh_pvt.gl_transfer_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

896: end loop;
897: end if;
898: end if;
899: end rosetta_table_copy_in_p16;
900: procedure rosetta_table_copy_out_p16(t okl_aeh_pvt.gl_transfer_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
901: ddindx binary_integer; indx binary_integer;
902: begin
903: if t is null or t.count = 0 then
904: a0 := JTF_VARCHAR2_TABLE_100();

Line 923: procedure rosetta_table_copy_in_p17(t out nocopy okl_aeh_pvt.sequence_id_typ, a0 JTF_NUMBER_TABLE) as

919: end if;
920: end if;
921: end rosetta_table_copy_out_p16;
922:
923: procedure rosetta_table_copy_in_p17(t out nocopy okl_aeh_pvt.sequence_id_typ, a0 JTF_NUMBER_TABLE) as
924: ddindx binary_integer; indx binary_integer;
925: begin
926: if a0 is not null and a0.count > 0 then
927: if a0.count > 0 then

Line 941: procedure rosetta_table_copy_out_p17(t okl_aeh_pvt.sequence_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

937: end loop;
938: end if;
939: end if;
940: end rosetta_table_copy_in_p17;
941: procedure rosetta_table_copy_out_p17(t okl_aeh_pvt.sequence_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
942: ddindx binary_integer; indx binary_integer;
943: begin
944: if t is null or t.count = 0 then
945: a0 := JTF_NUMBER_TABLE();

Line 964: procedure rosetta_table_copy_in_p18(t out nocopy okl_aeh_pvt.sequence_value_typ, a0 JTF_NUMBER_TABLE) as

960: end if;
961: end if;
962: end rosetta_table_copy_out_p17;
963:
964: procedure rosetta_table_copy_in_p18(t out nocopy okl_aeh_pvt.sequence_value_typ, a0 JTF_NUMBER_TABLE) as
965: ddindx binary_integer; indx binary_integer;
966: begin
967: if a0 is not null and a0.count > 0 then
968: if a0.count > 0 then

Line 982: procedure rosetta_table_copy_out_p18(t okl_aeh_pvt.sequence_value_typ, a0 out nocopy JTF_NUMBER_TABLE) as

978: end loop;
979: end if;
980: end if;
981: end rosetta_table_copy_in_p18;
982: procedure rosetta_table_copy_out_p18(t okl_aeh_pvt.sequence_value_typ, a0 out nocopy JTF_NUMBER_TABLE) as
983: ddindx binary_integer; indx binary_integer;
984: begin
985: if t is null or t.count = 0 then
986: a0 := JTF_NUMBER_TABLE();

Line 1005: procedure rosetta_table_copy_in_p19(t out nocopy okl_aeh_pvt.description_typ, a0 JTF_VARCHAR2_TABLE_800) as

1001: end if;
1002: end if;
1003: end rosetta_table_copy_out_p18;
1004:
1005: procedure rosetta_table_copy_in_p19(t out nocopy okl_aeh_pvt.description_typ, a0 JTF_VARCHAR2_TABLE_800) as
1006: ddindx binary_integer; indx binary_integer;
1007: begin
1008: if a0 is not null and a0.count > 0 then
1009: if a0.count > 0 then

Line 1023: procedure rosetta_table_copy_out_p19(t okl_aeh_pvt.description_typ, a0 out nocopy JTF_VARCHAR2_TABLE_800) as

1019: end loop;
1020: end if;
1021: end if;
1022: end rosetta_table_copy_in_p19;
1023: procedure rosetta_table_copy_out_p19(t okl_aeh_pvt.description_typ, a0 out nocopy JTF_VARCHAR2_TABLE_800) as
1024: ddindx binary_integer; indx binary_integer;
1025: begin
1026: if t is null or t.count = 0 then
1027: a0 := JTF_VARCHAR2_TABLE_800();

Line 1046: procedure rosetta_table_copy_in_p20(t out nocopy okl_aeh_pvt.accounting_error_code_typ, a0 JTF_VARCHAR2_TABLE_100) as

1042: end if;
1043: end if;
1044: end rosetta_table_copy_out_p19;
1045:
1046: procedure rosetta_table_copy_in_p20(t out nocopy okl_aeh_pvt.accounting_error_code_typ, a0 JTF_VARCHAR2_TABLE_100) as
1047: ddindx binary_integer; indx binary_integer;
1048: begin
1049: if a0 is not null and a0.count > 0 then
1050: if a0.count > 0 then

Line 1064: procedure rosetta_table_copy_out_p20(t okl_aeh_pvt.accounting_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

1060: end loop;
1061: end if;
1062: end if;
1063: end rosetta_table_copy_in_p20;
1064: procedure rosetta_table_copy_out_p20(t okl_aeh_pvt.accounting_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
1065: ddindx binary_integer; indx binary_integer;
1066: begin
1067: if t is null or t.count = 0 then
1068: a0 := JTF_VARCHAR2_TABLE_100();

Line 1087: procedure rosetta_table_copy_in_p21(t out nocopy okl_aeh_pvt.gl_transfer_error_code_typ, a0 JTF_VARCHAR2_TABLE_100) as

1083: end if;
1084: end if;
1085: end rosetta_table_copy_out_p20;
1086:
1087: procedure rosetta_table_copy_in_p21(t out nocopy okl_aeh_pvt.gl_transfer_error_code_typ, a0 JTF_VARCHAR2_TABLE_100) as
1088: ddindx binary_integer; indx binary_integer;
1089: begin
1090: if a0 is not null and a0.count > 0 then
1091: if a0.count > 0 then

Line 1105: procedure rosetta_table_copy_out_p21(t okl_aeh_pvt.gl_transfer_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

1101: end loop;
1102: end if;
1103: end if;
1104: end rosetta_table_copy_in_p21;
1105: procedure rosetta_table_copy_out_p21(t okl_aeh_pvt.gl_transfer_error_code_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
1106: ddindx binary_integer; indx binary_integer;
1107: begin
1108: if t is null or t.count = 0 then
1109: a0 := JTF_VARCHAR2_TABLE_100();

Line 1128: procedure rosetta_table_copy_in_p22(t out nocopy okl_aeh_pvt.gl_reversal_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as

1124: end if;
1125: end if;
1126: end rosetta_table_copy_out_p21;
1127:
1128: procedure rosetta_table_copy_in_p22(t out nocopy okl_aeh_pvt.gl_reversal_flag_typ, a0 JTF_VARCHAR2_TABLE_100) as
1129: ddindx binary_integer; indx binary_integer;
1130: begin
1131: if a0 is not null and a0.count > 0 then
1132: if a0.count > 0 then

Line 1146: procedure rosetta_table_copy_out_p22(t okl_aeh_pvt.gl_reversal_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

1142: end loop;
1143: end if;
1144: end if;
1145: end rosetta_table_copy_in_p22;
1146: procedure rosetta_table_copy_out_p22(t okl_aeh_pvt.gl_reversal_flag_typ, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
1147: ddindx binary_integer; indx binary_integer;
1148: begin
1149: if t is null or t.count = 0 then
1150: a0 := JTF_VARCHAR2_TABLE_100();

Line 1169: procedure rosetta_table_copy_in_p23(t out nocopy okl_aeh_pvt.org_id_typ, a0 JTF_NUMBER_TABLE) as

1165: end if;
1166: end if;
1167: end rosetta_table_copy_out_p22;
1168:
1169: procedure rosetta_table_copy_in_p23(t out nocopy okl_aeh_pvt.org_id_typ, a0 JTF_NUMBER_TABLE) as
1170: ddindx binary_integer; indx binary_integer;
1171: begin
1172: if a0 is not null and a0.count > 0 then
1173: if a0.count > 0 then

Line 1187: procedure rosetta_table_copy_out_p23(t okl_aeh_pvt.org_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1183: end loop;
1184: end if;
1185: end if;
1186: end rosetta_table_copy_in_p23;
1187: procedure rosetta_table_copy_out_p23(t okl_aeh_pvt.org_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1188: ddindx binary_integer; indx binary_integer;
1189: begin
1190: if t is null or t.count = 0 then
1191: a0 := JTF_NUMBER_TABLE();

Line 1210: procedure rosetta_table_copy_in_p24(t out nocopy okl_aeh_pvt.program_id_typ, a0 JTF_NUMBER_TABLE) as

1206: end if;
1207: end if;
1208: end rosetta_table_copy_out_p23;
1209:
1210: procedure rosetta_table_copy_in_p24(t out nocopy okl_aeh_pvt.program_id_typ, a0 JTF_NUMBER_TABLE) as
1211: ddindx binary_integer; indx binary_integer;
1212: begin
1213: if a0 is not null and a0.count > 0 then
1214: if a0.count > 0 then

Line 1228: procedure rosetta_table_copy_out_p24(t okl_aeh_pvt.program_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1224: end loop;
1225: end if;
1226: end if;
1227: end rosetta_table_copy_in_p24;
1228: procedure rosetta_table_copy_out_p24(t okl_aeh_pvt.program_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1229: ddindx binary_integer; indx binary_integer;
1230: begin
1231: if t is null or t.count = 0 then
1232: a0 := JTF_NUMBER_TABLE();

Line 1251: procedure rosetta_table_copy_in_p25(t out nocopy okl_aeh_pvt.program_application_id_typ, a0 JTF_NUMBER_TABLE) as

1247: end if;
1248: end if;
1249: end rosetta_table_copy_out_p24;
1250:
1251: procedure rosetta_table_copy_in_p25(t out nocopy okl_aeh_pvt.program_application_id_typ, a0 JTF_NUMBER_TABLE) as
1252: ddindx binary_integer; indx binary_integer;
1253: begin
1254: if a0 is not null and a0.count > 0 then
1255: if a0.count > 0 then

Line 1269: procedure rosetta_table_copy_out_p25(t okl_aeh_pvt.program_application_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1265: end loop;
1266: end if;
1267: end if;
1268: end rosetta_table_copy_in_p25;
1269: procedure rosetta_table_copy_out_p25(t okl_aeh_pvt.program_application_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1270: ddindx binary_integer; indx binary_integer;
1271: begin
1272: if t is null or t.count = 0 then
1273: a0 := JTF_NUMBER_TABLE();

Line 1292: procedure rosetta_table_copy_in_p26(t out nocopy okl_aeh_pvt.program_update_date_typ, a0 JTF_DATE_TABLE) as

1288: end if;
1289: end if;
1290: end rosetta_table_copy_out_p25;
1291:
1292: procedure rosetta_table_copy_in_p26(t out nocopy okl_aeh_pvt.program_update_date_typ, a0 JTF_DATE_TABLE) as
1293: ddindx binary_integer; indx binary_integer;
1294: begin
1295: if a0 is not null and a0.count > 0 then
1296: if a0.count > 0 then

Line 1310: procedure rosetta_table_copy_out_p26(t okl_aeh_pvt.program_update_date_typ, a0 out nocopy JTF_DATE_TABLE) as

1306: end loop;
1307: end if;
1308: end if;
1309: end rosetta_table_copy_in_p26;
1310: procedure rosetta_table_copy_out_p26(t okl_aeh_pvt.program_update_date_typ, a0 out nocopy JTF_DATE_TABLE) as
1311: ddindx binary_integer; indx binary_integer;
1312: begin
1313: if t is null or t.count = 0 then
1314: a0 := JTF_DATE_TABLE();

Line 1333: procedure rosetta_table_copy_in_p27(t out nocopy okl_aeh_pvt.request_id_typ, a0 JTF_NUMBER_TABLE) as

1329: end if;
1330: end if;
1331: end rosetta_table_copy_out_p26;
1332:
1333: procedure rosetta_table_copy_in_p27(t out nocopy okl_aeh_pvt.request_id_typ, a0 JTF_NUMBER_TABLE) as
1334: ddindx binary_integer; indx binary_integer;
1335: begin
1336: if a0 is not null and a0.count > 0 then
1337: if a0.count > 0 then

Line 1351: procedure rosetta_table_copy_out_p27(t okl_aeh_pvt.request_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1347: end loop;
1348: end if;
1349: end if;
1350: end rosetta_table_copy_in_p27;
1351: procedure rosetta_table_copy_out_p27(t okl_aeh_pvt.request_id_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1352: ddindx binary_integer; indx binary_integer;
1353: begin
1354: if t is null or t.count = 0 then
1355: a0 := JTF_NUMBER_TABLE();

Line 1374: procedure rosetta_table_copy_in_p28(t out nocopy okl_aeh_pvt.created_by_typ, a0 JTF_NUMBER_TABLE) as

1370: end if;
1371: end if;
1372: end rosetta_table_copy_out_p27;
1373:
1374: procedure rosetta_table_copy_in_p28(t out nocopy okl_aeh_pvt.created_by_typ, a0 JTF_NUMBER_TABLE) as
1375: ddindx binary_integer; indx binary_integer;
1376: begin
1377: if a0 is not null and a0.count > 0 then
1378: if a0.count > 0 then

Line 1392: procedure rosetta_table_copy_out_p28(t okl_aeh_pvt.created_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1388: end loop;
1389: end if;
1390: end if;
1391: end rosetta_table_copy_in_p28;
1392: procedure rosetta_table_copy_out_p28(t okl_aeh_pvt.created_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1393: ddindx binary_integer; indx binary_integer;
1394: begin
1395: if t is null or t.count = 0 then
1396: a0 := JTF_NUMBER_TABLE();

Line 1415: procedure rosetta_table_copy_in_p29(t out nocopy okl_aeh_pvt.creation_date_typ, a0 JTF_DATE_TABLE) as

1411: end if;
1412: end if;
1413: end rosetta_table_copy_out_p28;
1414:
1415: procedure rosetta_table_copy_in_p29(t out nocopy okl_aeh_pvt.creation_date_typ, a0 JTF_DATE_TABLE) as
1416: ddindx binary_integer; indx binary_integer;
1417: begin
1418: if a0 is not null and a0.count > 0 then
1419: if a0.count > 0 then

Line 1433: procedure rosetta_table_copy_out_p29(t okl_aeh_pvt.creation_date_typ, a0 out nocopy JTF_DATE_TABLE) as

1429: end loop;
1430: end if;
1431: end if;
1432: end rosetta_table_copy_in_p29;
1433: procedure rosetta_table_copy_out_p29(t okl_aeh_pvt.creation_date_typ, a0 out nocopy JTF_DATE_TABLE) as
1434: ddindx binary_integer; indx binary_integer;
1435: begin
1436: if t is null or t.count = 0 then
1437: a0 := JTF_DATE_TABLE();

Line 1456: procedure rosetta_table_copy_in_p30(t out nocopy okl_aeh_pvt.last_updated_by_typ, a0 JTF_NUMBER_TABLE) as

1452: end if;
1453: end if;
1454: end rosetta_table_copy_out_p29;
1455:
1456: procedure rosetta_table_copy_in_p30(t out nocopy okl_aeh_pvt.last_updated_by_typ, a0 JTF_NUMBER_TABLE) as
1457: ddindx binary_integer; indx binary_integer;
1458: begin
1459: if a0 is not null and a0.count > 0 then
1460: if a0.count > 0 then

Line 1474: procedure rosetta_table_copy_out_p30(t okl_aeh_pvt.last_updated_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1470: end loop;
1471: end if;
1472: end if;
1473: end rosetta_table_copy_in_p30;
1474: procedure rosetta_table_copy_out_p30(t okl_aeh_pvt.last_updated_by_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1475: ddindx binary_integer; indx binary_integer;
1476: begin
1477: if t is null or t.count = 0 then
1478: a0 := JTF_NUMBER_TABLE();

Line 1497: procedure rosetta_table_copy_in_p31(t out nocopy okl_aeh_pvt.last_update_date_typ, a0 JTF_DATE_TABLE) as

1493: end if;
1494: end if;
1495: end rosetta_table_copy_out_p30;
1496:
1497: procedure rosetta_table_copy_in_p31(t out nocopy okl_aeh_pvt.last_update_date_typ, a0 JTF_DATE_TABLE) as
1498: ddindx binary_integer; indx binary_integer;
1499: begin
1500: if a0 is not null and a0.count > 0 then
1501: if a0.count > 0 then

Line 1515: procedure rosetta_table_copy_out_p31(t okl_aeh_pvt.last_update_date_typ, a0 out nocopy JTF_DATE_TABLE) as

1511: end loop;
1512: end if;
1513: end if;
1514: end rosetta_table_copy_in_p31;
1515: procedure rosetta_table_copy_out_p31(t okl_aeh_pvt.last_update_date_typ, a0 out nocopy JTF_DATE_TABLE) as
1516: ddindx binary_integer; indx binary_integer;
1517: begin
1518: if t is null or t.count = 0 then
1519: a0 := JTF_DATE_TABLE();

Line 1538: procedure rosetta_table_copy_in_p32(t out nocopy okl_aeh_pvt.last_update_login_typ, a0 JTF_NUMBER_TABLE) as

1534: end if;
1535: end if;
1536: end rosetta_table_copy_out_p31;
1537:
1538: procedure rosetta_table_copy_in_p32(t out nocopy okl_aeh_pvt.last_update_login_typ, a0 JTF_NUMBER_TABLE) as
1539: ddindx binary_integer; indx binary_integer;
1540: begin
1541: if a0 is not null and a0.count > 0 then
1542: if a0.count > 0 then

Line 1556: procedure rosetta_table_copy_out_p32(t okl_aeh_pvt.last_update_login_typ, a0 out nocopy JTF_NUMBER_TABLE) as

1552: end loop;
1553: end if;
1554: end if;
1555: end rosetta_table_copy_in_p32;
1556: procedure rosetta_table_copy_out_p32(t okl_aeh_pvt.last_update_login_typ, a0 out nocopy JTF_NUMBER_TABLE) as
1557: ddindx binary_integer; indx binary_integer;
1558: begin
1559: if t is null or t.count = 0 then
1560: a0 := JTF_NUMBER_TABLE();

Line 1641: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;

1637: , p5_a26 NUMBER := 0-1962.0724
1638: )
1639:
1640: as
1641: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
1642: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;
1643: ddindx binary_integer; indx binary_integer;
1644: begin
1645:

Line 1642: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;

1638: )
1639:
1640: as
1641: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
1642: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;
1643: ddindx binary_integer; indx binary_integer;
1644: begin
1645:
1646: -- copy data to the local IN or IN-OUT args, if any

Line 1682: okl_aeh_pvt.insert_row(p_api_version,

1678: ddp_aehv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
1679:
1680:
1681: -- here's the delegated call to the old PL/SQL routine
1682: okl_aeh_pvt.insert_row(p_api_version,
1683: p_init_msg_list,
1684: x_return_status,
1685: x_msg_count,
1686: x_msg_data,

Line 1788: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

1784: , p6_a26 out nocopy JTF_NUMBER_TABLE
1785: )
1786:
1787: as
1788: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1789: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1790: ddindx binary_integer; indx binary_integer;
1791: begin
1792:

Line 1789: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

1785: )
1786:
1787: as
1788: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1789: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1790: ddindx binary_integer; indx binary_integer;
1791: begin
1792:
1793: -- copy data to the local IN or IN-OUT args, if any

Line 1799: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

1795:
1796:
1797:
1798:
1799: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
1800: , p5_a1
1801: , p5_a2
1802: , p5_a3
1803: , p5_a4

Line 1830: okl_aeh_pvt.insert_row(p_api_version,

1826: );
1827:
1828:
1829: -- here's the delegated call to the old PL/SQL routine
1830: okl_aeh_pvt.insert_row(p_api_version,
1831: p_init_msg_list,
1832: x_return_status,
1833: x_msg_count,
1834: x_msg_data,

Line 1845: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0

1841:
1842:
1843:
1844:
1845: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0
1846: , p6_a1
1847: , p6_a2
1848: , p6_a3
1849: , p6_a4

Line 1937: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

1933: , p6_a26 out nocopy JTF_NUMBER_TABLE
1934: )
1935:
1936: as
1937: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1938: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1939: ddindx binary_integer; indx binary_integer;
1940: begin
1941:

Line 1938: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

1934: )
1935:
1936: as
1937: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1938: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
1939: ddindx binary_integer; indx binary_integer;
1940: begin
1941:
1942: -- copy data to the local IN or IN-OUT args, if any

Line 1948: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

1944:
1945:
1946:
1947:
1948: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
1949: , p5_a1
1950: , p5_a2
1951: , p5_a3
1952: , p5_a4

Line 1979: okl_aeh_pvt.insert_row_perf(p_api_version,

1975: );
1976:
1977:
1978: -- here's the delegated call to the old PL/SQL routine
1979: okl_aeh_pvt.insert_row_perf(p_api_version,
1980: p_init_msg_list,
1981: x_return_status,
1982: x_msg_count,
1983: x_msg_data,

Line 1994: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0

1990:
1991:
1992:
1993:
1994: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0
1995: , p6_a1
1996: , p6_a2
1997: , p6_a3
1998: , p6_a4

Line 2059: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;

2055: , p5_a26 NUMBER := 0-1962.0724
2056: )
2057:
2058: as
2059: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
2060: ddindx binary_integer; indx binary_integer;
2061: begin
2062:
2063: -- copy data to the local IN or IN-OUT args, if any

Line 2098: okl_aeh_pvt.lock_row(p_api_version,

2094: ddp_aehv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
2095: ddp_aehv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
2096:
2097: -- here's the delegated call to the old PL/SQL routine
2098: okl_aeh_pvt.lock_row(p_api_version,
2099: p_init_msg_list,
2100: x_return_status,
2101: x_msg_count,
2102: x_msg_data,

Line 2148: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

2144: , p5_a26 JTF_NUMBER_TABLE
2145: )
2146:
2147: as
2148: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2149: ddindx binary_integer; indx binary_integer;
2150: begin
2151:
2152: -- copy data to the local IN or IN-OUT args, if any

Line 2158: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

2154:
2155:
2156:
2157:
2158: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
2159: , p5_a1
2160: , p5_a2
2161: , p5_a3
2162: , p5_a4

Line 2188: okl_aeh_pvt.lock_row(p_api_version,

2184: , p5_a26
2185: );
2186:
2187: -- here's the delegated call to the old PL/SQL routine
2188: okl_aeh_pvt.lock_row(p_api_version,
2189: p_init_msg_list,
2190: x_return_status,
2191: x_msg_count,
2192: x_msg_data,

Line 2265: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;

2261: , p5_a26 NUMBER := 0-1962.0724
2262: )
2263:
2264: as
2265: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
2266: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;
2267: ddindx binary_integer; indx binary_integer;
2268: begin
2269:

Line 2266: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;

2262: )
2263:
2264: as
2265: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
2266: ddx_aehv_rec okl_aeh_pvt.aehv_rec_type;
2267: ddindx binary_integer; indx binary_integer;
2268: begin
2269:
2270: -- copy data to the local IN or IN-OUT args, if any

Line 2306: okl_aeh_pvt.update_row(p_api_version,

2302: ddp_aehv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
2303:
2304:
2305: -- here's the delegated call to the old PL/SQL routine
2306: okl_aeh_pvt.update_row(p_api_version,
2307: p_init_msg_list,
2308: x_return_status,
2309: x_msg_count,
2310: x_msg_data,

Line 2412: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

2408: , p6_a26 out nocopy JTF_NUMBER_TABLE
2409: )
2410:
2411: as
2412: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2413: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2414: ddindx binary_integer; indx binary_integer;
2415: begin
2416:

Line 2413: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

2409: )
2410:
2411: as
2412: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2413: ddx_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2414: ddindx binary_integer; indx binary_integer;
2415: begin
2416:
2417: -- copy data to the local IN or IN-OUT args, if any

Line 2423: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

2419:
2420:
2421:
2422:
2423: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
2424: , p5_a1
2425: , p5_a2
2426: , p5_a3
2427: , p5_a4

Line 2454: okl_aeh_pvt.update_row(p_api_version,

2450: );
2451:
2452:
2453: -- here's the delegated call to the old PL/SQL routine
2454: okl_aeh_pvt.update_row(p_api_version,
2455: p_init_msg_list,
2456: x_return_status,
2457: x_msg_count,
2458: x_msg_data,

Line 2469: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0

2465:
2466:
2467:
2468:
2469: okl_aeh_pvt_w.rosetta_table_copy_out_p5(ddx_aehv_tbl, p6_a0
2470: , p6_a1
2471: , p6_a2
2472: , p6_a3
2473: , p6_a4

Line 2534: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;

2530: , p5_a26 NUMBER := 0-1962.0724
2531: )
2532:
2533: as
2534: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
2535: ddindx binary_integer; indx binary_integer;
2536: begin
2537:
2538: -- copy data to the local IN or IN-OUT args, if any

Line 2573: okl_aeh_pvt.delete_row(p_api_version,

2569: ddp_aehv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
2570: ddp_aehv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
2571:
2572: -- here's the delegated call to the old PL/SQL routine
2573: okl_aeh_pvt.delete_row(p_api_version,
2574: p_init_msg_list,
2575: x_return_status,
2576: x_msg_count,
2577: x_msg_data,

Line 2623: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

2619: , p5_a26 JTF_NUMBER_TABLE
2620: )
2621:
2622: as
2623: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2624: ddindx binary_integer; indx binary_integer;
2625: begin
2626:
2627: -- copy data to the local IN or IN-OUT args, if any

Line 2633: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

2629:
2630:
2631:
2632:
2633: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
2634: , p5_a1
2635: , p5_a2
2636: , p5_a3
2637: , p5_a4

Line 2663: okl_aeh_pvt.delete_row(p_api_version,

2659: , p5_a26
2660: );
2661:
2662: -- here's the delegated call to the old PL/SQL routine
2663: okl_aeh_pvt.delete_row(p_api_version,
2664: p_init_msg_list,
2665: x_return_status,
2666: x_msg_count,
2667: x_msg_data,

Line 2713: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;

2709: , p5_a26 NUMBER := 0-1962.0724
2710: )
2711:
2712: as
2713: ddp_aehv_rec okl_aeh_pvt.aehv_rec_type;
2714: ddindx binary_integer; indx binary_integer;
2715: begin
2716:
2717: -- copy data to the local IN or IN-OUT args, if any

Line 2752: okl_aeh_pvt.validate_row(p_api_version,

2748: ddp_aehv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a25);
2749: ddp_aehv_rec.last_update_login := rosetta_g_miss_num_map(p5_a26);
2750:
2751: -- here's the delegated call to the old PL/SQL routine
2752: okl_aeh_pvt.validate_row(p_api_version,
2753: p_init_msg_list,
2754: x_return_status,
2755: x_msg_count,
2756: x_msg_data,

Line 2802: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;

2798: , p5_a26 JTF_NUMBER_TABLE
2799: )
2800:
2801: as
2802: ddp_aehv_tbl okl_aeh_pvt.aehv_tbl_type;
2803: ddindx binary_integer; indx binary_integer;
2804: begin
2805:
2806: -- copy data to the local IN or IN-OUT args, if any

Line 2812: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0

2808:
2809:
2810:
2811:
2812: okl_aeh_pvt_w.rosetta_table_copy_in_p5(ddp_aehv_tbl, p5_a0
2813: , p5_a1
2814: , p5_a2
2815: , p5_a3
2816: , p5_a4

Line 2842: okl_aeh_pvt.validate_row(p_api_version,

2838: , p5_a26
2839: );
2840:
2841: -- here's the delegated call to the old PL/SQL routine
2842: okl_aeh_pvt.validate_row(p_api_version,
2843: p_init_msg_list,
2844: x_return_status,
2845: x_msg_count,
2846: x_msg_data,

Line 2857: end okl_aeh_pvt_w;

2853:
2854:
2855: end;
2856:
2857: end okl_aeh_pvt_w;