eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_AGN_PVT_W dependencies on OKL_AGN_PVT

Line 1: package body okl_agn_pvt_w as

1: package body okl_agn_pvt_w as
2: /* $Header: OKLIAGNB.pls 120.2 2006/08/09 11:13:56 abhsaxen 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: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 25: procedure rosetta_table_copy_in_p2(t out nocopy okl_agn_pvt.agn_tbl_type, a0 JTF_NUMBER_TABLE

21: if n=b then return a; end if;
22: return n;
23: end;
24:
25: procedure rosetta_table_copy_in_p2(t out nocopy okl_agn_pvt.agn_tbl_type, a0 JTF_NUMBER_TABLE
26: , a1 JTF_NUMBER_TABLE
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_VARCHAR2_TABLE_100

Line 78: procedure rosetta_table_copy_out_p2(t okl_agn_pvt.agn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

74: end loop;
75: end if;
76: end if;
77: end rosetta_table_copy_in_p2;
78: procedure rosetta_table_copy_out_p2(t okl_agn_pvt.agn_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
79: , a1 out nocopy JTF_NUMBER_TABLE
80: , a2 out nocopy JTF_VARCHAR2_TABLE_100
81: , a3 out nocopy JTF_VARCHAR2_TABLE_100
82: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 187: procedure rosetta_table_copy_in_p5(t out nocopy okl_agn_pvt.agnv_tbl_type, a0 JTF_NUMBER_TABLE

183: end if;
184: end if;
185: end rosetta_table_copy_out_p2;
186:
187: procedure rosetta_table_copy_in_p5(t out nocopy okl_agn_pvt.agnv_tbl_type, a0 JTF_NUMBER_TABLE
188: , a1 JTF_NUMBER_TABLE
189: , a2 JTF_VARCHAR2_TABLE_100
190: , a3 JTF_VARCHAR2_TABLE_100
191: , a4 JTF_VARCHAR2_TABLE_100

Line 240: procedure rosetta_table_copy_out_p5(t okl_agn_pvt.agnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

236: end loop;
237: end if;
238: end if;
239: end rosetta_table_copy_in_p5;
240: procedure rosetta_table_copy_out_p5(t okl_agn_pvt.agnv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
241: , a1 out nocopy JTF_NUMBER_TABLE
242: , a2 out nocopy JTF_VARCHAR2_TABLE_100
243: , a3 out nocopy JTF_VARCHAR2_TABLE_100
244: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 393: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;

389: , p5_a17 NUMBER := 0-1962.0724
390: )
391:
392: as
393: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
394: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;
395: ddindx binary_integer; indx binary_integer;
396: begin
397:

Line 394: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;

390: )
391:
392: as
393: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
394: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;
395: ddindx binary_integer; indx binary_integer;
396: begin
397:
398: -- copy data to the local IN or IN-OUT args, if any

Line 425: okl_agn_pvt.insert_row(p_api_version,

421: ddp_agnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
422:
423:
424: -- here's the delegated call to the old PL/SQL routine
425: okl_agn_pvt.insert_row(p_api_version,
426: p_init_msg_list,
427: x_return_status,
428: x_msg_count,
429: x_msg_data,

Line 504: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;

500: , p6_a17 out nocopy JTF_NUMBER_TABLE
501: )
502:
503: as
504: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
505: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;
506: ddindx binary_integer; indx binary_integer;
507: begin
508:

Line 505: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;

501: )
502:
503: as
504: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
505: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;
506: ddindx binary_integer; indx binary_integer;
507: begin
508:
509: -- copy data to the local IN or IN-OUT args, if any

Line 515: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0

511:
512:
513:
514:
515: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0
516: , p5_a1
517: , p5_a2
518: , p5_a3
519: , p5_a4

Line 537: okl_agn_pvt.insert_row(p_api_version,

533: );
534:
535:
536: -- here's the delegated call to the old PL/SQL routine
537: okl_agn_pvt.insert_row(p_api_version,
538: p_init_msg_list,
539: x_return_status,
540: x_msg_count,
541: x_msg_data,

Line 552: okl_agn_pvt_w.rosetta_table_copy_out_p5(ddx_agnv_tbl, p6_a0

548:
549:
550:
551:
552: okl_agn_pvt_w.rosetta_table_copy_out_p5(ddx_agnv_tbl, p6_a0
553: , p6_a1
554: , p6_a2
555: , p6_a3
556: , p6_a4

Line 599: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;

595: , p5_a17 NUMBER := 0-1962.0724
596: )
597:
598: as
599: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
600: ddindx binary_integer; indx binary_integer;
601: begin
602:
603: -- copy data to the local IN or IN-OUT args, if any

Line 629: okl_agn_pvt.lock_row(p_api_version,

625: ddp_agnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
626: ddp_agnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
627:
628: -- here's the delegated call to the old PL/SQL routine
629: okl_agn_pvt.lock_row(p_api_version,
630: p_init_msg_list,
631: x_return_status,
632: x_msg_count,
633: x_msg_data,

Line 670: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;

666: , p5_a17 JTF_NUMBER_TABLE
667: )
668:
669: as
670: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
671: ddindx binary_integer; indx binary_integer;
672: begin
673:
674: -- copy data to the local IN or IN-OUT args, if any

Line 680: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0

676:
677:
678:
679:
680: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0
681: , p5_a1
682: , p5_a2
683: , p5_a3
684: , p5_a4

Line 701: okl_agn_pvt.lock_row(p_api_version,

697: , p5_a17
698: );
699:
700: -- here's the delegated call to the old PL/SQL routine
701: okl_agn_pvt.lock_row(p_api_version,
702: p_init_msg_list,
703: x_return_status,
704: x_msg_count,
705: x_msg_data,

Line 760: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;

756: , p5_a17 NUMBER := 0-1962.0724
757: )
758:
759: as
760: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
761: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;
762: ddindx binary_integer; indx binary_integer;
763: begin
764:

Line 761: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;

757: )
758:
759: as
760: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
761: ddx_agnv_rec okl_agn_pvt.agnv_rec_type;
762: ddindx binary_integer; indx binary_integer;
763: begin
764:
765: -- copy data to the local IN or IN-OUT args, if any

Line 792: okl_agn_pvt.update_row(p_api_version,

788: ddp_agnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
789:
790:
791: -- here's the delegated call to the old PL/SQL routine
792: okl_agn_pvt.update_row(p_api_version,
793: p_init_msg_list,
794: x_return_status,
795: x_msg_count,
796: x_msg_data,

Line 871: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;

867: , p6_a17 out nocopy JTF_NUMBER_TABLE
868: )
869:
870: as
871: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
872: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:

Line 872: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;

868: )
869:
870: as
871: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
872: ddx_agnv_tbl okl_agn_pvt.agnv_tbl_type;
873: ddindx binary_integer; indx binary_integer;
874: begin
875:
876: -- copy data to the local IN or IN-OUT args, if any

Line 882: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0

878:
879:
880:
881:
882: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0
883: , p5_a1
884: , p5_a2
885: , p5_a3
886: , p5_a4

Line 904: okl_agn_pvt.update_row(p_api_version,

900: );
901:
902:
903: -- here's the delegated call to the old PL/SQL routine
904: okl_agn_pvt.update_row(p_api_version,
905: p_init_msg_list,
906: x_return_status,
907: x_msg_count,
908: x_msg_data,

Line 919: okl_agn_pvt_w.rosetta_table_copy_out_p5(ddx_agnv_tbl, p6_a0

915:
916:
917:
918:
919: okl_agn_pvt_w.rosetta_table_copy_out_p5(ddx_agnv_tbl, p6_a0
920: , p6_a1
921: , p6_a2
922: , p6_a3
923: , p6_a4

Line 966: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;

962: , p5_a17 NUMBER := 0-1962.0724
963: )
964:
965: as
966: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
967: ddindx binary_integer; indx binary_integer;
968: begin
969:
970: -- copy data to the local IN or IN-OUT args, if any

Line 996: okl_agn_pvt.delete_row(p_api_version,

992: ddp_agnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
993: ddp_agnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
994:
995: -- here's the delegated call to the old PL/SQL routine
996: okl_agn_pvt.delete_row(p_api_version,
997: p_init_msg_list,
998: x_return_status,
999: x_msg_count,
1000: x_msg_data,

Line 1037: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;

1033: , p5_a17 JTF_NUMBER_TABLE
1034: )
1035:
1036: as
1037: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
1038: ddindx binary_integer; indx binary_integer;
1039: begin
1040:
1041: -- copy data to the local IN or IN-OUT args, if any

Line 1047: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0

1043:
1044:
1045:
1046:
1047: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0
1048: , p5_a1
1049: , p5_a2
1050: , p5_a3
1051: , p5_a4

Line 1068: okl_agn_pvt.delete_row(p_api_version,

1064: , p5_a17
1065: );
1066:
1067: -- here's the delegated call to the old PL/SQL routine
1068: okl_agn_pvt.delete_row(p_api_version,
1069: p_init_msg_list,
1070: x_return_status,
1071: x_msg_count,
1072: x_msg_data,

Line 1109: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;

1105: , p5_a17 NUMBER := 0-1962.0724
1106: )
1107:
1108: as
1109: ddp_agnv_rec okl_agn_pvt.agnv_rec_type;
1110: ddindx binary_integer; indx binary_integer;
1111: begin
1112:
1113: -- copy data to the local IN or IN-OUT args, if any

Line 1139: okl_agn_pvt.validate_row(p_api_version,

1135: ddp_agnv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a16);
1136: ddp_agnv_rec.last_update_login := rosetta_g_miss_num_map(p5_a17);
1137:
1138: -- here's the delegated call to the old PL/SQL routine
1139: okl_agn_pvt.validate_row(p_api_version,
1140: p_init_msg_list,
1141: x_return_status,
1142: x_msg_count,
1143: x_msg_data,

Line 1180: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;

1176: , p5_a17 JTF_NUMBER_TABLE
1177: )
1178:
1179: as
1180: ddp_agnv_tbl okl_agn_pvt.agnv_tbl_type;
1181: ddindx binary_integer; indx binary_integer;
1182: begin
1183:
1184: -- copy data to the local IN or IN-OUT args, if any

Line 1190: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0

1186:
1187:
1188:
1189:
1190: okl_agn_pvt_w.rosetta_table_copy_in_p5(ddp_agnv_tbl, p5_a0
1191: , p5_a1
1192: , p5_a2
1193: , p5_a3
1194: , p5_a4

Line 1211: okl_agn_pvt.validate_row(p_api_version,

1207: , p5_a17
1208: );
1209:
1210: -- here's the delegated call to the old PL/SQL routine
1211: okl_agn_pvt.validate_row(p_api_version,
1212: p_init_msg_list,
1213: x_return_status,
1214: x_msg_count,
1215: x_msg_data,

Line 1226: end okl_agn_pvt_w;

1222:
1223:
1224: end;
1225:
1226: end okl_agn_pvt_w;