DBA Data[Home] [Help]

APPS.LNS_BILLING_BATCH_PUB_W dependencies on LNS_BILLING_BATCH_PUB

Line 1: package body lns_billing_batch_pub_w as

1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.2 2005/07/13 13:47 scherkas noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE

1: package body lns_billing_batch_pub_w as
2: /* $Header: LNS_BILL_PUBJ_B.pls 120.2 2005/07/13 13:47 scherkas noship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_billing_batch_pub.loans_to_bill_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_300
7: , a4 JTF_NUMBER_TABLE

Line 80: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE

76: end loop;
77: end if;
78: end if;
79: end rosetta_table_copy_in_p1;
80: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
81: , a1 out nocopy JTF_NUMBER_TABLE
82: , a2 out nocopy JTF_VARCHAR2_TABLE_100
83: , a3 out nocopy JTF_VARCHAR2_TABLE_300
84: , a4 out nocopy JTF_NUMBER_TABLE

Line 249: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100

245: end if;
246: end if;
247: end rosetta_table_copy_out_p1;
248:
249: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
250: , a1 JTF_NUMBER_TABLE
251: , a2 JTF_NUMBER_TABLE
252: , a3 JTF_NUMBER_TABLE
253: , a4 JTF_VARCHAR2_TABLE_100

Line 282: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100

278: end loop;
279: end if;
280: end if;
281: end rosetta_table_copy_in_p4;
282: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
283: , a1 out nocopy JTF_NUMBER_TABLE
284: , a2 out nocopy JTF_NUMBER_TABLE
285: , a3 out nocopy JTF_NUMBER_TABLE
286: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 341: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE

337: end if;
338: end if;
339: end rosetta_table_copy_out_p4;
340:
341: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
342: , a1 JTF_NUMBER_TABLE
343: , a2 JTF_NUMBER_TABLE
344: , a3 JTF_DATE_TABLE
345: ) as

Line 366: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE

362: end loop;
363: end if;
364: end if;
365: end rosetta_table_copy_in_p6;
366: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
367: , a1 out nocopy JTF_NUMBER_TABLE
368: , a2 out nocopy JTF_NUMBER_TABLE
369: , a3 out nocopy JTF_DATE_TABLE
370: ) as

Line 405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE

401: end if;
402: end if;
403: end rosetta_table_copy_out_p6;
404:
405: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
406: , a1 JTF_NUMBER_TABLE
407: , a2 JTF_NUMBER_TABLE
408: , a3 JTF_NUMBER_TABLE
409: , a4 JTF_NUMBER_TABLE

Line 448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE

444: end loop;
445: end if;
446: end if;
447: end rosetta_table_copy_in_p8;
448: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
449: , a1 out nocopy JTF_NUMBER_TABLE
450: , a2 out nocopy JTF_NUMBER_TABLE
451: , a3 out nocopy JTF_NUMBER_TABLE
452: , a4 out nocopy JTF_NUMBER_TABLE

Line 559: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;

555: , x_msg_data out nocopy VARCHAR2
556: )
557:
558: as
559: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;
560: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
561: ddindx binary_integer; indx binary_integer;
562: begin
563:

Line 560: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;

556: )
557:
558: as
559: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;
560: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
561: ddindx binary_integer; indx binary_integer;
562: begin
563:
564: -- copy data to the local IN or IN-OUT args, if any

Line 574: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0

570: ddp_bill_header_rec.loan_id := p4_a1;
571: ddp_bill_header_rec.assoc_payment_num := p4_a2;
572: ddp_bill_header_rec.due_date := p4_a3;
573:
574: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0
575: , p5_a1
576: , p5_a2
577: , p5_a3
578: , p5_a4

Line 593: lns_billing_batch_pub.create_single_offcycle_bill(p_api_version,

589:
590:
591:
592: -- here's the delegated call to the old PL/SQL routine
593: lns_billing_batch_pub.create_single_offcycle_bill(p_api_version,
594: p_init_msg_list,
595: p_commit,
596: p_validation_level,
597: ddp_bill_header_rec,

Line 641: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;

637: , x_msg_data out nocopy VARCHAR2
638: )
639:
640: as
641: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
642: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:

Line 642: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;

638: )
639:
640: as
641: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
642: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
643: ddindx binary_integer; indx binary_integer;
644: begin
645:
646: -- copy data to the local IN or IN-OUT args, if any

Line 651: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p4_a0

647:
648:
649:
650:
651: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p4_a0
652: , p4_a1
653: , p4_a2
654: , p4_a3
655: );

Line 657: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0

653: , p4_a2
654: , p4_a3
655: );
656:
657: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0
658: , p5_a1
659: , p5_a2
660: , p5_a3
661: , p5_a4

Line 676: lns_billing_batch_pub.create_offcycle_bills(p_api_version,

672:
673:
674:
675: -- here's the delegated call to the old PL/SQL routine
676: lns_billing_batch_pub.create_offcycle_bills(p_api_version,
677: p_init_msg_list,
678: p_commit,
679: p_validation_level,
680: ddp_bill_headers_tbl,

Line 697: end lns_billing_batch_pub_w;

693:
694:
695: end;
696:
697: end lns_billing_batch_pub_w;