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.CN_MULTI_RATE_SCHEDULES_PVT_W dependencies on CN_MULTI_RATE_SCHEDULES_PVT

Line 1: package body cn_multi_rate_schedules_pvt_w as

1: package body cn_multi_rate_schedules_pvt_w as
2: /* $Header: cnwrschb.pls 120.4 2006/01/18 16:13 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE

1: package body cn_multi_rate_schedules_pvt_w as
2: /* $Header: cnwrschb.pls 120.4 2006/01/18 16:13 jxsingh ship $ */
3: procedure rosetta_table_copy_in_p5(t out nocopy cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

26: end loop;
27: end if;
28: end if;
29: end rosetta_table_copy_in_p5;
30: procedure rosetta_table_copy_out_p5(t cn_multi_rate_schedules_pvt.rate_table_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
31: , a1 out nocopy JTF_VARCHAR2_TABLE_100
32: , a2 out nocopy JTF_VARCHAR2_TABLE_100
33: , a3 out nocopy JTF_NUMBER_TABLE
34: , a4 out nocopy JTF_NUMBER_TABLE

Line 74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE

70: end if;
71: end if;
72: end rosetta_table_copy_out_p5;
73:
74: procedure rosetta_table_copy_in_p6(t out nocopy cn_multi_rate_schedules_pvt.dims_tbl_type, a0 JTF_NUMBER_TABLE
75: , a1 JTF_NUMBER_TABLE
76: , a2 JTF_NUMBER_TABLE
77: , a3 JTF_NUMBER_TABLE
78: , a4 JTF_VARCHAR2_TABLE_100

Line 107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

103: end loop;
104: end if;
105: end if;
106: end rosetta_table_copy_in_p6;
107: procedure rosetta_table_copy_out_p6(t cn_multi_rate_schedules_pvt.dims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
108: , a1 out nocopy JTF_NUMBER_TABLE
109: , a2 out nocopy JTF_NUMBER_TABLE
110: , a3 out nocopy JTF_NUMBER_TABLE
111: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 166: procedure rosetta_table_copy_in_p7(t out nocopy cn_multi_rate_schedules_pvt.parents_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as

162: end if;
163: end if;
164: end rosetta_table_copy_out_p6;
165:
166: procedure rosetta_table_copy_in_p7(t out nocopy cn_multi_rate_schedules_pvt.parents_tbl_type, a0 JTF_VARCHAR2_TABLE_100) as
167: ddindx binary_integer; indx binary_integer;
168: begin
169: if a0 is not null and a0.count > 0 then
170: if a0.count > 0 then

Line 184: procedure rosetta_table_copy_out_p7(t cn_multi_rate_schedules_pvt.parents_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as

180: end loop;
181: end if;
182: end if;
183: end rosetta_table_copy_in_p7;
184: procedure rosetta_table_copy_out_p7(t cn_multi_rate_schedules_pvt.parents_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100) as
185: ddindx binary_integer; indx binary_integer;
186: begin
187: if t is null or t.count = 0 then
188: a0 := JTF_VARCHAR2_TABLE_100();

Line 207: procedure rosetta_table_copy_in_p8(t out nocopy cn_multi_rate_schedules_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as

203: end if;
204: end if;
205: end rosetta_table_copy_out_p7;
206:
207: procedure rosetta_table_copy_in_p8(t out nocopy cn_multi_rate_schedules_pvt.num_tbl_type, a0 JTF_NUMBER_TABLE) as
208: ddindx binary_integer; indx binary_integer;
209: begin
210: if a0 is not null and a0.count > 0 then
211: if a0.count > 0 then

Line 225: procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as

221: end loop;
222: end if;
223: end if;
224: end rosetta_table_copy_in_p8;
225: procedure rosetta_table_copy_out_p8(t cn_multi_rate_schedules_pvt.num_tbl_type, a0 out nocopy JTF_NUMBER_TABLE) as
226: ddindx binary_integer; indx binary_integer;
227: begin
228: if t is null or t.count = 0 then
229: a0 := JTF_NUMBER_TABLE();

Line 248: procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE

244: end if;
245: end if;
246: end rosetta_table_copy_out_p8;
247:
248: procedure rosetta_table_copy_in_p9(t out nocopy cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 JTF_NUMBER_TABLE
249: , a1 JTF_VARCHAR2_TABLE_100
250: , a2 JTF_VARCHAR2_TABLE_100
251: , a3 JTF_NUMBER_TABLE
252: , a4 JTF_VARCHAR2_TABLE_100

Line 279: procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

275: end loop;
276: end if;
277: end if;
278: end rosetta_table_copy_in_p9;
279: procedure rosetta_table_copy_out_p9(t cn_multi_rate_schedules_pvt.plan_elt_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
280: , a1 out nocopy JTF_VARCHAR2_TABLE_100
281: , a2 out nocopy JTF_VARCHAR2_TABLE_100
282: , a3 out nocopy JTF_NUMBER_TABLE
283: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 333: procedure rosetta_table_copy_in_p10(t out nocopy cn_multi_rate_schedules_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE

329: end if;
330: end if;
331: end rosetta_table_copy_out_p9;
332:
333: procedure rosetta_table_copy_in_p10(t out nocopy cn_multi_rate_schedules_pvt.formula_tbl_type, a0 JTF_NUMBER_TABLE
334: , a1 JTF_VARCHAR2_TABLE_100
335: , a2 JTF_VARCHAR2_TABLE_100
336: , a3 JTF_DATE_TABLE
337: , a4 JTF_DATE_TABLE

Line 360: procedure rosetta_table_copy_out_p10(t cn_multi_rate_schedules_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

356: end loop;
357: end if;
358: end if;
359: end rosetta_table_copy_in_p10;
360: procedure rosetta_table_copy_out_p10(t cn_multi_rate_schedules_pvt.formula_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
361: , a1 out nocopy JTF_VARCHAR2_TABLE_100
362: , a2 out nocopy JTF_VARCHAR2_TABLE_100
363: , a3 out nocopy JTF_DATE_TABLE
364: , a4 out nocopy JTF_DATE_TABLE

Line 404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE

400: end if;
401: end if;
402: end rosetta_table_copy_out_p10;
403:
404: procedure rosetta_table_copy_in_p11(t out nocopy cn_multi_rate_schedules_pvt.comm_tbl_type, a0 JTF_NUMBER_TABLE
405: , a1 JTF_NUMBER_TABLE
406: , a2 JTF_NUMBER_TABLE
407: , a3 JTF_NUMBER_TABLE
408: ) as

Line 429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

425: end loop;
426: end if;
427: end if;
428: end rosetta_table_copy_in_p11;
429: procedure rosetta_table_copy_out_p11(t cn_multi_rate_schedules_pvt.comm_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
430: , a1 out nocopy JTF_NUMBER_TABLE
431: , a2 out nocopy JTF_NUMBER_TABLE
432: , a3 out nocopy JTF_NUMBER_TABLE
433: ) as

Line 491: ddp_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type;

487: , x_msg_data out nocopy VARCHAR2
488: )
489:
490: as
491: ddp_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type;
492: ddindx binary_integer; indx binary_integer;
493: begin
494:
495: -- copy data to the local IN or IN-OUT args, if any

Line 503: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p6(ddp_dims_tbl, p7_a0

499:
500:
501:
502:
503: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p6(ddp_dims_tbl, p7_a0
504: , p7_a1
505: , p7_a2
506: , p7_a3
507: , p7_a4

Line 519: cn_multi_rate_schedules_pvt.create_schedule(p_api_version,

515:
516:
517:
518: -- here's the delegated call to the old PL/SQL routine
519: cn_multi_rate_schedules_pvt.create_schedule(p_api_version,
520: p_init_msg_list,
521: p_commit,
522: p_validation_level,
523: p_name,

Line 572: ddp_dims_tbl cn_multi_rate_schedules_pvt.dims_tbl_type;

568: , x_msg_data out nocopy VARCHAR2
569: )
570:
571: as
572: ddp_dims_tbl cn_multi_rate_schedules_pvt.dims_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 587: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p6(ddp_dims_tbl, p10_a0

583:
584:
585:
586:
587: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p6(ddp_dims_tbl, p10_a0
588: , p10_a1
589: , p10_a2
590: , p10_a3
591: , p10_a4

Line 601: cn_multi_rate_schedules_pvt.update_schedule(p_api_version,

597:
598:
599:
600: -- here's the delegated call to the old PL/SQL routine
601: cn_multi_rate_schedules_pvt.update_schedule(p_api_version,
602: p_init_msg_list,
603: p_commit,
604: p_validation_level,
605: p_rate_schedule_id,

Line 641: ddp_rate_dim_tier_id_tbl cn_multi_rate_schedules_pvt.num_tbl_type;

637: , x_object_version_number out nocopy NUMBER
638: )
639:
640: as
641: ddp_rate_dim_tier_id_tbl cn_multi_rate_schedules_pvt.num_tbl_type;
642: ddindx binary_integer; indx binary_integer;
643: begin
644:
645: -- copy data to the local IN or IN-OUT args, if any

Line 647: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p8(ddp_rate_dim_tier_id_tbl, p_rate_dim_tier_id_tbl);

643: begin
644:
645: -- copy data to the local IN or IN-OUT args, if any
646:
647: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p8(ddp_rate_dim_tier_id_tbl, p_rate_dim_tier_id_tbl);
648:
649:
650:
651:

Line 654: cn_multi_rate_schedules_pvt.get_rate_tier_info(p_rate_schedule_id,

650:
651:
652:
653: -- here's the delegated call to the old PL/SQL routine
654: cn_multi_rate_schedules_pvt.get_rate_tier_info(p_rate_schedule_id,
655: ddp_rate_dim_tier_id_tbl,
656: x_rate_tier_id,
657: x_rate_sequence,
658: x_commission_amount,

Line 678: ddx_result_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;

674: , p_org_id NUMBER
675: )
676:
677: as
678: ddx_result_tbl cn_multi_rate_schedules_pvt.comm_tbl_type;
679: ddindx binary_integer; indx binary_integer;
680: begin
681:
682: -- copy data to the local IN or IN-OUT args, if any

Line 684: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p11(ddx_result_tbl, p1_a0

680: begin
681:
682: -- copy data to the local IN or IN-OUT args, if any
683:
684: cn_multi_rate_schedules_pvt_w.rosetta_table_copy_in_p11(ddx_result_tbl, p1_a0
685: , p1_a1
686: , p1_a2
687: , p1_a3
688: );

Line 692: cn_multi_rate_schedules_pvt.update_comm_rate(p_rate_schedule_id,

688: );
689:
690:
691: -- here's the delegated call to the old PL/SQL routine
692: cn_multi_rate_schedules_pvt.update_comm_rate(p_rate_schedule_id,
693: ddx_result_tbl,
694: p_org_id);
695:
696: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 701: end cn_multi_rate_schedules_pvt_w;

697:
698:
699: end;
700:
701: end cn_multi_rate_schedules_pvt_w;