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.CSE_DEPLOYMENT_GRP_W dependencies on CSE_DEPLOYMENT_GRP

Line 1: package body cse_deployment_grp_w as

1: package body cse_deployment_grp_w as
2: /* $Header: CSEDPLWB.pls 120.5 2006/07/24 17:08:19 sguthiva 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_p1(t out nocopy cse_deployment_grp.txn_instances_tbl, 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_p1(t out nocopy cse_deployment_grp.txn_instances_tbl, a0 JTF_NUMBER_TABLE
26: , a1 JTF_VARCHAR2_TABLE_100
27: , a2 JTF_VARCHAR2_TABLE_100
28: , a3 JTF_VARCHAR2_TABLE_100
29: , a4 JTF_NUMBER_TABLE

Line 68: procedure rosetta_table_copy_out_p1(t cse_deployment_grp.txn_instances_tbl, a0 out nocopy JTF_NUMBER_TABLE

64: end loop;
65: end if;
66: end if;
67: end rosetta_table_copy_in_p1;
68: procedure rosetta_table_copy_out_p1(t cse_deployment_grp.txn_instances_tbl, a0 out nocopy JTF_NUMBER_TABLE
69: , a1 out nocopy JTF_VARCHAR2_TABLE_100
70: , a2 out nocopy JTF_VARCHAR2_TABLE_100
71: , a3 out nocopy JTF_VARCHAR2_TABLE_100
72: , a4 out nocopy JTF_NUMBER_TABLE

Line 152: procedure rosetta_table_copy_in_p3(t out nocopy cse_deployment_grp.dest_location_tbl, a0 JTF_NUMBER_TABLE

148: end if;
149: end if;
150: end rosetta_table_copy_out_p1;
151:
152: procedure rosetta_table_copy_in_p3(t out nocopy cse_deployment_grp.dest_location_tbl, a0 JTF_NUMBER_TABLE
153: , a1 JTF_VARCHAR2_TABLE_100
154: , a2 JTF_NUMBER_TABLE
155: , a3 JTF_VARCHAR2_TABLE_100
156: , a4 JTF_NUMBER_TABLE

Line 189: procedure rosetta_table_copy_out_p3(t cse_deployment_grp.dest_location_tbl, a0 out nocopy JTF_NUMBER_TABLE

185: end loop;
186: end if;
187: end if;
188: end rosetta_table_copy_in_p3;
189: procedure rosetta_table_copy_out_p3(t cse_deployment_grp.dest_location_tbl, a0 out nocopy JTF_NUMBER_TABLE
190: , a1 out nocopy JTF_VARCHAR2_TABLE_100
191: , a2 out nocopy JTF_NUMBER_TABLE
192: , a3 out nocopy JTF_VARCHAR2_TABLE_100
193: , a4 out nocopy JTF_NUMBER_TABLE

Line 258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE

254: end if;
255: end if;
256: end rosetta_table_copy_out_p3;
257:
258: procedure rosetta_table_copy_in_p5(t out nocopy cse_deployment_grp.txn_ext_attrib_values_tbl, a0 JTF_NUMBER_TABLE
259: , a1 JTF_NUMBER_TABLE
260: , a2 JTF_NUMBER_TABLE
261: , a3 JTF_NUMBER_TABLE
262: , a4 JTF_VARCHAR2_TABLE_100

Line 293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE

289: end loop;
290: end if;
291: end if;
292: end rosetta_table_copy_in_p5;
293: procedure rosetta_table_copy_out_p5(t cse_deployment_grp.txn_ext_attrib_values_tbl, a0 out nocopy JTF_NUMBER_TABLE
294: , a1 out nocopy JTF_NUMBER_TABLE
295: , a2 out nocopy JTF_NUMBER_TABLE
296: , a3 out nocopy JTF_NUMBER_TABLE
297: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 357: procedure rosetta_table_copy_in_p7(t out nocopy cse_deployment_grp.transaction_tbl, a0 JTF_NUMBER_TABLE

353: end if;
354: end if;
355: end rosetta_table_copy_out_p5;
356:
357: procedure rosetta_table_copy_in_p7(t out nocopy cse_deployment_grp.transaction_tbl, a0 JTF_NUMBER_TABLE
358: , a1 JTF_DATE_TABLE
359: , a2 JTF_DATE_TABLE
360: , a3 JTF_NUMBER_TABLE
361: , a4 JTF_NUMBER_TABLE

Line 404: procedure rosetta_table_copy_out_p7(t cse_deployment_grp.transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE

400: end loop;
401: end if;
402: end if;
403: end rosetta_table_copy_in_p7;
404: procedure rosetta_table_copy_out_p7(t cse_deployment_grp.transaction_tbl, a0 out nocopy JTF_NUMBER_TABLE
405: , a1 out nocopy JTF_DATE_TABLE
406: , a2 out nocopy JTF_DATE_TABLE
407: , a3 out nocopy JTF_NUMBER_TABLE
408: , a4 out nocopy JTF_NUMBER_TABLE

Line 550: ddp_instance_tbl cse_deployment_grp.txn_instances_tbl;

546: , x_error_msg out nocopy VARCHAR2
547: )
548:
549: as
550: ddp_instance_tbl cse_deployment_grp.txn_instances_tbl;
551: ddp_dest_location_tbl cse_deployment_grp.dest_location_tbl;
552: ddp_ext_attrib_values_tbl cse_deployment_grp.txn_ext_attrib_values_tbl;
553: ddp_txn_tbl cse_deployment_grp.transaction_tbl;
554: ddindx binary_integer; indx binary_integer;

Line 551: ddp_dest_location_tbl cse_deployment_grp.dest_location_tbl;

547: )
548:
549: as
550: ddp_instance_tbl cse_deployment_grp.txn_instances_tbl;
551: ddp_dest_location_tbl cse_deployment_grp.dest_location_tbl;
552: ddp_ext_attrib_values_tbl cse_deployment_grp.txn_ext_attrib_values_tbl;
553: ddp_txn_tbl cse_deployment_grp.transaction_tbl;
554: ddindx binary_integer; indx binary_integer;
555: begin

Line 552: ddp_ext_attrib_values_tbl cse_deployment_grp.txn_ext_attrib_values_tbl;

548:
549: as
550: ddp_instance_tbl cse_deployment_grp.txn_instances_tbl;
551: ddp_dest_location_tbl cse_deployment_grp.dest_location_tbl;
552: ddp_ext_attrib_values_tbl cse_deployment_grp.txn_ext_attrib_values_tbl;
553: ddp_txn_tbl cse_deployment_grp.transaction_tbl;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:

Line 553: ddp_txn_tbl cse_deployment_grp.transaction_tbl;

549: as
550: ddp_instance_tbl cse_deployment_grp.txn_instances_tbl;
551: ddp_dest_location_tbl cse_deployment_grp.dest_location_tbl;
552: ddp_ext_attrib_values_tbl cse_deployment_grp.txn_ext_attrib_values_tbl;
553: ddp_txn_tbl cse_deployment_grp.transaction_tbl;
554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any

Line 558: cse_deployment_grp_w.rosetta_table_copy_in_p1(ddp_instance_tbl, p0_a0

554: ddindx binary_integer; indx binary_integer;
555: begin
556:
557: -- copy data to the local IN or IN-OUT args, if any
558: cse_deployment_grp_w.rosetta_table_copy_in_p1(ddp_instance_tbl, p0_a0
559: , p0_a1
560: , p0_a2
561: , p0_a3
562: , p0_a4

Line 573: cse_deployment_grp_w.rosetta_table_copy_in_p3(ddp_dest_location_tbl, p1_a0

569: , p0_a11
570: , p0_a12
571: );
572:
573: cse_deployment_grp_w.rosetta_table_copy_in_p3(ddp_dest_location_tbl, p1_a0
574: , p1_a1
575: , p1_a2
576: , p1_a3
577: , p1_a4

Line 585: cse_deployment_grp_w.rosetta_table_copy_in_p5(ddp_ext_attrib_values_tbl, p2_a0

581: , p1_a8
582: , p1_a9
583: );
584:
585: cse_deployment_grp_w.rosetta_table_copy_in_p5(ddp_ext_attrib_values_tbl, p2_a0
586: , p2_a1
587: , p2_a2
588: , p2_a3
589: , p2_a4

Line 596: cse_deployment_grp_w.rosetta_table_copy_in_p7(ddp_txn_tbl, p3_a0

592: , p2_a7
593: , p2_a8
594: );
595:
596: cse_deployment_grp_w.rosetta_table_copy_in_p7(ddp_txn_tbl, p3_a0
597: , p3_a1
598: , p3_a2
599: , p3_a3
600: , p3_a4

Line 616: cse_deployment_grp.process_transaction(ddp_instance_tbl,

612:
613:
614:
615: -- here's the delegated call to the old PL/SQL routine
616: cse_deployment_grp.process_transaction(ddp_instance_tbl,
617: ddp_dest_location_tbl,
618: ddp_ext_attrib_values_tbl,
619: ddp_txn_tbl,
620: x_return_status,

Line 626: cse_deployment_grp_w.rosetta_table_copy_out_p5(ddp_ext_attrib_values_tbl, p2_a0

622:
623: -- copy data back from the local variables to OUT or IN-OUT args, if any
624:
625:
626: cse_deployment_grp_w.rosetta_table_copy_out_p5(ddp_ext_attrib_values_tbl, p2_a0
627: , p2_a1
628: , p2_a2
629: , p2_a3
630: , p2_a4

Line 637: cse_deployment_grp_w.rosetta_table_copy_out_p7(ddp_txn_tbl, p3_a0

633: , p2_a7
634: , p2_a8
635: );
636:
637: cse_deployment_grp_w.rosetta_table_copy_out_p7(ddp_txn_tbl, p3_a0
638: , p3_a1
639: , p3_a2
640: , p3_a3
641: , p3_a4

Line 657: end cse_deployment_grp_w;

653:
654:
655: end;
656:
657: end cse_deployment_grp_w;