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_PQY_VALUES_PUB_W dependencies on OKL_PQY_VALUES_PUB

Line 1: package body okl_pqy_values_pub_w as

1: package body okl_pqy_values_pub_w as
2: /* $Header: OKLUPQVB.pls 115.9 2002/12/24 04:15:42 sgorantl 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 54: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

50: , p5_a11 NUMBER := 0-1962.0724
51: )
52:
53: as
54: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
55: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin
58:

Line 55: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

51: )
52:
53: as
54: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
55: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
56: ddindx binary_integer; indx binary_integer;
57: begin
58:
59: -- copy data to the local IN or IN-OUT args, if any

Line 80: okl_pqy_values_pub.insert_pqy_values(p_api_version,

76: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
77:
78:
79: -- here's the delegated call to the old PL/SQL routine
80: okl_pqy_values_pub.insert_pqy_values(p_api_version,
81: p_init_msg_list,
82: x_return_status,
83: x_msg_count,
84: x_msg_data,

Line 141: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

137: , p6_a11 out nocopy JTF_NUMBER_TABLE
138: )
139:
140: as
141: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
142: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:

Line 142: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

138: )
139:
140: as
141: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
142: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
143: ddindx binary_integer; indx binary_integer;
144: begin
145:
146: -- copy data to the local IN or IN-OUT args, if any

Line 168: okl_pqy_values_pub.insert_pqy_values(p_api_version,

164: );
165:
166:
167: -- here's the delegated call to the old PL/SQL routine
168: okl_pqy_values_pub.insert_pqy_values(p_api_version,
169: p_init_msg_list,
170: x_return_status,
171: x_msg_count,
172: x_msg_data,

Line 218: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

214: , p5_a11 NUMBER := 0-1962.0724
215: )
216:
217: as
218: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
219: ddindx binary_integer; indx binary_integer;
220: begin
221:
222: -- copy data to the local IN or IN-OUT args, if any

Line 242: okl_pqy_values_pub.lock_pqy_values(p_api_version,

238: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
239: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
240:
241: -- here's the delegated call to the old PL/SQL routine
242: okl_pqy_values_pub.lock_pqy_values(p_api_version,
243: p_init_msg_list,
244: x_return_status,
245: x_msg_count,
246: x_msg_data,

Line 277: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

273: , p5_a11 JTF_NUMBER_TABLE
274: )
275:
276: as
277: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
278: ddindx binary_integer; indx binary_integer;
279: begin
280:
281: -- copy data to the local IN or IN-OUT args, if any

Line 302: okl_pqy_values_pub.lock_pqy_values(p_api_version,

298: , p5_a11
299: );
300:
301: -- here's the delegated call to the old PL/SQL routine
302: okl_pqy_values_pub.lock_pqy_values(p_api_version,
303: p_init_msg_list,
304: x_return_status,
305: x_msg_count,
306: x_msg_data,

Line 349: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

345: , p5_a11 NUMBER := 0-1962.0724
346: )
347:
348: as
349: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
350: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
351: ddindx binary_integer; indx binary_integer;
352: begin
353:

Line 350: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

346: )
347:
348: as
349: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
350: ddx_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
351: ddindx binary_integer; indx binary_integer;
352: begin
353:
354: -- copy data to the local IN or IN-OUT args, if any

Line 375: okl_pqy_values_pub.update_pqy_values(p_api_version,

371: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
372:
373:
374: -- here's the delegated call to the old PL/SQL routine
375: okl_pqy_values_pub.update_pqy_values(p_api_version,
376: p_init_msg_list,
377: x_return_status,
378: x_msg_count,
379: x_msg_data,

Line 436: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

432: , p6_a11 out nocopy JTF_NUMBER_TABLE
433: )
434:
435: as
436: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
437: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
438: ddindx binary_integer; indx binary_integer;
439: begin
440:

Line 437: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

433: )
434:
435: as
436: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
437: ddx_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
438: ddindx binary_integer; indx binary_integer;
439: begin
440:
441: -- copy data to the local IN or IN-OUT args, if any

Line 463: okl_pqy_values_pub.update_pqy_values(p_api_version,

459: );
460:
461:
462: -- here's the delegated call to the old PL/SQL routine
463: okl_pqy_values_pub.update_pqy_values(p_api_version,
464: p_init_msg_list,
465: x_return_status,
466: x_msg_count,
467: x_msg_data,

Line 513: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

509: , p5_a11 NUMBER := 0-1962.0724
510: )
511:
512: as
513: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
514: ddindx binary_integer; indx binary_integer;
515: begin
516:
517: -- copy data to the local IN or IN-OUT args, if any

Line 537: okl_pqy_values_pub.delete_pqy_values(p_api_version,

533: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
534: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
535:
536: -- here's the delegated call to the old PL/SQL routine
537: okl_pqy_values_pub.delete_pqy_values(p_api_version,
538: p_init_msg_list,
539: x_return_status,
540: x_msg_count,
541: x_msg_data,

Line 572: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

568: , p5_a11 JTF_NUMBER_TABLE
569: )
570:
571: as
572: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
573: ddindx binary_integer; indx binary_integer;
574: begin
575:
576: -- copy data to the local IN or IN-OUT args, if any

Line 597: okl_pqy_values_pub.delete_pqy_values(p_api_version,

593: , p5_a11
594: );
595:
596: -- here's the delegated call to the old PL/SQL routine
597: okl_pqy_values_pub.delete_pqy_values(p_api_version,
598: p_init_msg_list,
599: x_return_status,
600: x_msg_count,
601: x_msg_data,

Line 632: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;

628: , p5_a11 NUMBER := 0-1962.0724
629: )
630:
631: as
632: ddp_pqvv_rec okl_pqy_values_pub.pqvv_rec_type;
633: ddindx binary_integer; indx binary_integer;
634: begin
635:
636: -- copy data to the local IN or IN-OUT args, if any

Line 656: okl_pqy_values_pub.validate_pqy_values(p_api_version,

652: ddp_pqvv_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a10);
653: ddp_pqvv_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
654:
655: -- here's the delegated call to the old PL/SQL routine
656: okl_pqy_values_pub.validate_pqy_values(p_api_version,
657: p_init_msg_list,
658: x_return_status,
659: x_msg_count,
660: x_msg_data,

Line 691: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;

687: , p5_a11 JTF_NUMBER_TABLE
688: )
689:
690: as
691: ddp_pqvv_tbl okl_pqy_values_pub.pqvv_tbl_type;
692: ddindx binary_integer; indx binary_integer;
693: begin
694:
695: -- copy data to the local IN or IN-OUT args, if any

Line 716: okl_pqy_values_pub.validate_pqy_values(p_api_version,

712: , p5_a11
713: );
714:
715: -- here's the delegated call to the old PL/SQL routine
716: okl_pqy_values_pub.validate_pqy_values(p_api_version,
717: p_init_msg_list,
718: x_return_status,
719: x_msg_count,
720: x_msg_data,

Line 731: end okl_pqy_values_pub_w;

727:
728:
729: end;
730:
731: end okl_pqy_values_pub_w;