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_CSH_ORDER_SEQ_PVT_W dependencies on OKL_CSH_ORDER_SEQ_PVT

Line 1: package body okl_csh_order_seq_pvt_w as

1: package body okl_csh_order_seq_pvt_w as
2: /* $Header: OKLESATB.pls 120.1 2005/07/08 10:34:12 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_p4(t out nocopy okl_csh_order_seq_pvt.okl_csh_order_tbl_type, a0 JTF_VARCHAR2_TABLE_200

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

Line 63: procedure rosetta_table_copy_out_p4(t okl_csh_order_seq_pvt.okl_csh_order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200

59: end loop;
60: end if;
61: end if;
62: end rosetta_table_copy_in_p4;
63: procedure rosetta_table_copy_out_p4(t okl_csh_order_seq_pvt.okl_csh_order_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_200
64: , a1 out nocopy JTF_NUMBER_TABLE
65: , a2 out nocopy JTF_NUMBER_TABLE
66: , a3 out nocopy JTF_NUMBER_TABLE
67: , a4 out nocopy JTF_NUMBER_TABLE

Line 174: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;

170: , p5_a11 NUMBER := 0-1962.0724
171: )
172:
173: as
174: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
175: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:

Line 175: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;

171: )
172:
173: as
174: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
175: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
176: ddindx binary_integer; indx binary_integer;
177: begin
178:
179: -- copy data to the local IN or IN-OUT args, if any

Line 200: okl_csh_order_seq_pvt.insert_row(p_api_version,

196: ddp_okl_csh_order_rec.last_update_login := rosetta_g_miss_num_map(p5_a11);
197:
198:
199: -- here's the delegated call to the old PL/SQL routine
200: okl_csh_order_seq_pvt.insert_row(p_api_version,
201: p_init_msg_list,
202: x_return_status,
203: x_msg_count,
204: x_msg_data,

Line 261: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;

257: , p6_a11 out nocopy JTF_NUMBER_TABLE
258: )
259:
260: as
261: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
262: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:

Line 262: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;

258: )
259:
260: as
261: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
262: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
263: ddindx binary_integer; indx binary_integer;
264: begin
265:
266: -- copy data to the local IN or IN-OUT args, if any

Line 272: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0

268:
269:
270:
271:
272: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0
273: , p5_a1
274: , p5_a2
275: , p5_a3
276: , p5_a4

Line 288: okl_csh_order_seq_pvt.insert_row(p_api_version,

284: );
285:
286:
287: -- here's the delegated call to the old PL/SQL routine
288: okl_csh_order_seq_pvt.insert_row(p_api_version,
289: p_init_msg_list,
290: x_return_status,
291: x_msg_count,
292: x_msg_data,

Line 303: okl_csh_order_seq_pvt_w.rosetta_table_copy_out_p4(ddx_okl_csh_order_tbl, p6_a0

299:
300:
301:
302:
303: okl_csh_order_seq_pvt_w.rosetta_table_copy_out_p4(ddx_okl_csh_order_tbl, p6_a0
304: , p6_a1
305: , p6_a2
306: , p6_a3
307: , p6_a4

Line 350: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;

346: , p5_a11 NUMBER := 0-1962.0724
347: )
348:
349: as
350: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
351: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
352: ddindx binary_integer; indx binary_integer;
353: begin
354:

Line 351: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;

347: )
348:
349: as
350: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
351: ddx_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;
352: ddindx binary_integer; indx binary_integer;
353: begin
354:
355: -- copy data to the local IN or IN-OUT args, if any

Line 376: okl_csh_order_seq_pvt.update_row(p_api_version,

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

Line 437: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;

433: , p6_a11 out nocopy JTF_NUMBER_TABLE
434: )
435:
436: as
437: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
438: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:

Line 438: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;

434: )
435:
436: as
437: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
438: ddx_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;
439: ddindx binary_integer; indx binary_integer;
440: begin
441:
442: -- copy data to the local IN or IN-OUT args, if any

Line 448: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0

444:
445:
446:
447:
448: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0
449: , p5_a1
450: , p5_a2
451: , p5_a3
452: , p5_a4

Line 464: okl_csh_order_seq_pvt.update_row(p_api_version,

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

Line 479: okl_csh_order_seq_pvt_w.rosetta_table_copy_out_p4(ddx_okl_csh_order_tbl, p6_a0

475:
476:
477:
478:
479: okl_csh_order_seq_pvt_w.rosetta_table_copy_out_p4(ddx_okl_csh_order_tbl, p6_a0
480: , p6_a1
481: , p6_a2
482: , p6_a3
483: , p6_a4

Line 514: ddp_okl_csh_order_rec okl_csh_order_seq_pvt.okl_csh_order_rec_type;

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

Line 538: okl_csh_order_seq_pvt.delete_row(p_api_version,

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

Line 573: ddp_okl_csh_order_tbl okl_csh_order_seq_pvt.okl_csh_order_tbl_type;

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

Line 583: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0

579:
580:
581:
582:
583: okl_csh_order_seq_pvt_w.rosetta_table_copy_in_p4(ddp_okl_csh_order_tbl, p5_a0
584: , p5_a1
585: , p5_a2
586: , p5_a3
587: , p5_a4

Line 598: okl_csh_order_seq_pvt.delete_row(p_api_version,

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

Line 613: end okl_csh_order_seq_pvt_w;

609:
610:
611: end;
612:
613: end okl_csh_order_seq_pvt_w;