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_QPY_PVT_W dependencies on OKL_QPY_PVT

Line 1: package body okl_qpy_pvt_w as

1: package body okl_qpy_pvt_w as
2: /* $Header: OKLIQPYB.pls 115.3 2002/12/04 03:23:24 gkadarka 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_qpy_pvt.qpy_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_qpy_pvt.qpy_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_DATE_TABLE

Line 79: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

75: end loop;
76: end if;
77: end if;
78: end rosetta_table_copy_in_p2;
79: procedure rosetta_table_copy_out_p2(t okl_qpy_pvt.qpy_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
80: , a1 out nocopy JTF_NUMBER_TABLE
81: , a2 out nocopy JTF_NUMBER_TABLE
82: , a3 out nocopy JTF_NUMBER_TABLE
83: , a4 out nocopy JTF_DATE_TABLE

Line 198: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE

194: end if;
195: end if;
196: end rosetta_table_copy_out_p2;
197:
198: procedure rosetta_table_copy_in_p5(t out nocopy okl_qpy_pvt.qpyv_tbl_type, a0 JTF_NUMBER_TABLE
199: , a1 JTF_NUMBER_TABLE
200: , a2 JTF_NUMBER_TABLE
201: , a3 JTF_NUMBER_TABLE
202: , a4 JTF_DATE_TABLE

Line 255: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

251: end loop;
252: end if;
253: end if;
254: end rosetta_table_copy_in_p5;
255: procedure rosetta_table_copy_out_p5(t okl_qpy_pvt.qpyv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
256: , a1 out nocopy JTF_NUMBER_TABLE
257: , a2 out nocopy JTF_NUMBER_TABLE
258: , a3 out nocopy JTF_NUMBER_TABLE
259: , a4 out nocopy JTF_DATE_TABLE

Line 422: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

418: , p5_a19 NUMBER := 0-1962.0724
419: )
420:
421: as
422: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
423: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
424: ddindx binary_integer; indx binary_integer;
425: begin
426:

Line 423: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

419: )
420:
421: as
422: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
423: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
424: ddindx binary_integer; indx binary_integer;
425: begin
426:
427: -- copy data to the local IN or IN-OUT args, if any

Line 456: okl_qpy_pvt.insert_row(p_api_version,

452: ddp_qpyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
453:
454:
455: -- here's the delegated call to the old PL/SQL routine
456: okl_qpy_pvt.insert_row(p_api_version,
457: p_init_msg_list,
458: x_return_status,
459: x_msg_count,
460: x_msg_data,

Line 541: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

537: , p6_a19 out nocopy JTF_NUMBER_TABLE
538: )
539:
540: as
541: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
542: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:

Line 542: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

538: )
539:
540: as
541: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
542: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
543: ddindx binary_integer; indx binary_integer;
544: begin
545:
546: -- copy data to the local IN or IN-OUT args, if any

Line 552: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0

548:
549:
550:
551:
552: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0
553: , p5_a1
554: , p5_a2
555: , p5_a3
556: , p5_a4

Line 576: okl_qpy_pvt.insert_row(p_api_version,

572: );
573:
574:
575: -- here's the delegated call to the old PL/SQL routine
576: okl_qpy_pvt.insert_row(p_api_version,
577: p_init_msg_list,
578: x_return_status,
579: x_msg_count,
580: x_msg_data,

Line 591: okl_qpy_pvt_w.rosetta_table_copy_out_p5(ddx_qpyv_tbl, p6_a0

587:
588:
589:
590:
591: okl_qpy_pvt_w.rosetta_table_copy_out_p5(ddx_qpyv_tbl, p6_a0
592: , p6_a1
593: , p6_a2
594: , p6_a3
595: , p6_a4

Line 642: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

638: , p5_a19 NUMBER := 0-1962.0724
639: )
640:
641: as
642: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:
646: -- copy data to the local IN or IN-OUT args, if any

Line 674: okl_qpy_pvt.lock_row(p_api_version,

670: ddp_qpyv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a18);
671: ddp_qpyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
672:
673: -- here's the delegated call to the old PL/SQL routine
674: okl_qpy_pvt.lock_row(p_api_version,
675: p_init_msg_list,
676: x_return_status,
677: x_msg_count,
678: x_msg_data,

Line 717: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

713: , p5_a19 JTF_NUMBER_TABLE
714: )
715:
716: as
717: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
718: ddindx binary_integer; indx binary_integer;
719: begin
720:
721: -- copy data to the local IN or IN-OUT args, if any

Line 727: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0

723:
724:
725:
726:
727: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0
728: , p5_a1
729: , p5_a2
730: , p5_a3
731: , p5_a4

Line 750: okl_qpy_pvt.lock_row(p_api_version,

746: , p5_a19
747: );
748:
749: -- here's the delegated call to the old PL/SQL routine
750: okl_qpy_pvt.lock_row(p_api_version,
751: p_init_msg_list,
752: x_return_status,
753: x_msg_count,
754: x_msg_data,

Line 813: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

809: , p5_a19 NUMBER := 0-1962.0724
810: )
811:
812: as
813: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
814: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:

Line 814: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

810: )
811:
812: as
813: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
814: ddx_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
815: ddindx binary_integer; indx binary_integer;
816: begin
817:
818: -- copy data to the local IN or IN-OUT args, if any

Line 847: okl_qpy_pvt.update_row(p_api_version,

843: ddp_qpyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
844:
845:
846: -- here's the delegated call to the old PL/SQL routine
847: okl_qpy_pvt.update_row(p_api_version,
848: p_init_msg_list,
849: x_return_status,
850: x_msg_count,
851: x_msg_data,

Line 932: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

928: , p6_a19 out nocopy JTF_NUMBER_TABLE
929: )
930:
931: as
932: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
933: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
934: ddindx binary_integer; indx binary_integer;
935: begin
936:

Line 933: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

929: )
930:
931: as
932: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
933: ddx_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
934: ddindx binary_integer; indx binary_integer;
935: begin
936:
937: -- copy data to the local IN or IN-OUT args, if any

Line 943: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0

939:
940:
941:
942:
943: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0
944: , p5_a1
945: , p5_a2
946: , p5_a3
947: , p5_a4

Line 967: okl_qpy_pvt.update_row(p_api_version,

963: );
964:
965:
966: -- here's the delegated call to the old PL/SQL routine
967: okl_qpy_pvt.update_row(p_api_version,
968: p_init_msg_list,
969: x_return_status,
970: x_msg_count,
971: x_msg_data,

Line 982: okl_qpy_pvt_w.rosetta_table_copy_out_p5(ddx_qpyv_tbl, p6_a0

978:
979:
980:
981:
982: okl_qpy_pvt_w.rosetta_table_copy_out_p5(ddx_qpyv_tbl, p6_a0
983: , p6_a1
984: , p6_a2
985: , p6_a3
986: , p6_a4

Line 1033: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

1029: , p5_a19 NUMBER := 0-1962.0724
1030: )
1031:
1032: as
1033: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
1034: ddindx binary_integer; indx binary_integer;
1035: begin
1036:
1037: -- copy data to the local IN or IN-OUT args, if any

Line 1065: okl_qpy_pvt.delete_row(p_api_version,

1061: ddp_qpyv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a18);
1062: ddp_qpyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
1063:
1064: -- here's the delegated call to the old PL/SQL routine
1065: okl_qpy_pvt.delete_row(p_api_version,
1066: p_init_msg_list,
1067: x_return_status,
1068: x_msg_count,
1069: x_msg_data,

Line 1108: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

1104: , p5_a19 JTF_NUMBER_TABLE
1105: )
1106:
1107: as
1108: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
1109: ddindx binary_integer; indx binary_integer;
1110: begin
1111:
1112: -- copy data to the local IN or IN-OUT args, if any

Line 1118: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0

1114:
1115:
1116:
1117:
1118: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0
1119: , p5_a1
1120: , p5_a2
1121: , p5_a3
1122: , p5_a4

Line 1141: okl_qpy_pvt.delete_row(p_api_version,

1137: , p5_a19
1138: );
1139:
1140: -- here's the delegated call to the old PL/SQL routine
1141: okl_qpy_pvt.delete_row(p_api_version,
1142: p_init_msg_list,
1143: x_return_status,
1144: x_msg_count,
1145: x_msg_data,

Line 1184: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;

1180: , p5_a19 NUMBER := 0-1962.0724
1181: )
1182:
1183: as
1184: ddp_qpyv_rec okl_qpy_pvt.qpyv_rec_type;
1185: ddindx binary_integer; indx binary_integer;
1186: begin
1187:
1188: -- copy data to the local IN or IN-OUT args, if any

Line 1216: okl_qpy_pvt.validate_row(p_api_version,

1212: ddp_qpyv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a18);
1213: ddp_qpyv_rec.last_update_login := rosetta_g_miss_num_map(p5_a19);
1214:
1215: -- here's the delegated call to the old PL/SQL routine
1216: okl_qpy_pvt.validate_row(p_api_version,
1217: p_init_msg_list,
1218: x_return_status,
1219: x_msg_count,
1220: x_msg_data,

Line 1259: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;

1255: , p5_a19 JTF_NUMBER_TABLE
1256: )
1257:
1258: as
1259: ddp_qpyv_tbl okl_qpy_pvt.qpyv_tbl_type;
1260: ddindx binary_integer; indx binary_integer;
1261: begin
1262:
1263: -- copy data to the local IN or IN-OUT args, if any

Line 1269: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0

1265:
1266:
1267:
1268:
1269: okl_qpy_pvt_w.rosetta_table_copy_in_p5(ddp_qpyv_tbl, p5_a0
1270: , p5_a1
1271: , p5_a2
1272: , p5_a3
1273: , p5_a4

Line 1292: okl_qpy_pvt.validate_row(p_api_version,

1288: , p5_a19
1289: );
1290:
1291: -- here's the delegated call to the old PL/SQL routine
1292: okl_qpy_pvt.validate_row(p_api_version,
1293: p_init_msg_list,
1294: x_return_status,
1295: x_msg_count,
1296: x_msg_data,

Line 1307: end okl_qpy_pvt_w;

1303:
1304:
1305: end;
1306:
1307: end okl_qpy_pvt_w;