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.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.5.12020000.2 2012/07/19 20:52:53 scherkas ship $ */
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.5.12020000.2 2012/07/19 20:52:53 scherkas ship $ */
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 94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE

90: end loop;
91: end if;
92: end if;
93: end rosetta_table_copy_in_p1;
94: procedure rosetta_table_copy_out_p1(t lns_billing_batch_pub.loans_to_bill_tbl, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_NUMBER_TABLE
96: , a2 out nocopy JTF_VARCHAR2_TABLE_100
97: , a3 out nocopy JTF_VARCHAR2_TABLE_300
98: , a4 out nocopy JTF_NUMBER_TABLE

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

294: end if;
295: end if;
296: end rosetta_table_copy_out_p1;
297:
298: procedure rosetta_table_copy_in_p4(t out nocopy lns_billing_batch_pub.reverse_tbl, a0 JTF_VARCHAR2_TABLE_100
299: , a1 JTF_NUMBER_TABLE
300: , a2 JTF_NUMBER_TABLE
301: , a3 JTF_NUMBER_TABLE
302: , a4 JTF_VARCHAR2_TABLE_100

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

327: end loop;
328: end if;
329: end if;
330: end rosetta_table_copy_in_p4;
331: procedure rosetta_table_copy_out_p4(t lns_billing_batch_pub.reverse_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
332: , a1 out nocopy JTF_NUMBER_TABLE
333: , a2 out nocopy JTF_NUMBER_TABLE
334: , a3 out nocopy JTF_NUMBER_TABLE
335: , a4 out nocopy JTF_VARCHAR2_TABLE_100

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

386: end if;
387: end if;
388: end rosetta_table_copy_out_p4;
389:
390: procedure rosetta_table_copy_in_p6(t out nocopy lns_billing_batch_pub.bill_headers_tbl, a0 JTF_NUMBER_TABLE
391: , a1 JTF_NUMBER_TABLE
392: , a2 JTF_NUMBER_TABLE
393: , a3 JTF_DATE_TABLE
394: , a4 JTF_NUMBER_TABLE

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

415: end loop;
416: end if;
417: end if;
418: end rosetta_table_copy_in_p6;
419: procedure rosetta_table_copy_out_p6(t lns_billing_batch_pub.bill_headers_tbl, a0 out nocopy JTF_NUMBER_TABLE
420: , a1 out nocopy JTF_NUMBER_TABLE
421: , a2 out nocopy JTF_NUMBER_TABLE
422: , a3 out nocopy JTF_DATE_TABLE
423: , a4 out nocopy JTF_NUMBER_TABLE

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

464: end if;
465: end if;
466: end rosetta_table_copy_out_p6;
467:
468: procedure rosetta_table_copy_in_p8(t out nocopy lns_billing_batch_pub.bill_lines_tbl, a0 JTF_NUMBER_TABLE
469: , a1 JTF_NUMBER_TABLE
470: , a2 JTF_NUMBER_TABLE
471: , a3 JTF_NUMBER_TABLE
472: , a4 JTF_NUMBER_TABLE

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

509: end loop;
510: end if;
511: end if;
512: end rosetta_table_copy_in_p8;
513: procedure rosetta_table_copy_out_p8(t lns_billing_batch_pub.bill_lines_tbl, a0 out nocopy JTF_NUMBER_TABLE
514: , a1 out nocopy JTF_NUMBER_TABLE
515: , a2 out nocopy JTF_NUMBER_TABLE
516: , a3 out nocopy JTF_NUMBER_TABLE
517: , a4 out nocopy JTF_NUMBER_TABLE

Line 602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE

598: end if;
599: end if;
600: end rosetta_table_copy_out_p8;
601:
602: procedure rosetta_table_copy_in_p10(t out nocopy lns_billing_batch_pub.invoice_details_tbl, a0 JTF_NUMBER_TABLE
603: , a1 JTF_NUMBER_TABLE
604: , a2 JTF_VARCHAR2_TABLE_100
605: , a3 JTF_NUMBER_TABLE
606: , a4 JTF_VARCHAR2_TABLE_100

Line 649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE

645: end loop;
646: end if;
647: end if;
648: end rosetta_table_copy_in_p10;
649: procedure rosetta_table_copy_out_p10(t lns_billing_batch_pub.invoice_details_tbl, a0 out nocopy JTF_NUMBER_TABLE
650: , a1 out nocopy JTF_NUMBER_TABLE
651: , a2 out nocopy JTF_VARCHAR2_TABLE_100
652: , a3 out nocopy JTF_NUMBER_TABLE
653: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE

739: end if;
740: end if;
741: end rosetta_table_copy_out_p10;
742:
743: procedure rosetta_table_copy_in_p12(t out nocopy lns_billing_batch_pub.cash_receipt_tbl, a0 JTF_NUMBER_TABLE
744: , a1 JTF_NUMBER_TABLE
745: , a2 JTF_VARCHAR2_TABLE_100
746: , a3 JTF_NUMBER_TABLE
747: , a4 JTF_DATE_TABLE

Line 780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE

776: end loop;
777: end if;
778: end if;
779: end rosetta_table_copy_in_p12;
780: procedure rosetta_table_copy_out_p12(t lns_billing_batch_pub.cash_receipt_tbl, a0 out nocopy JTF_NUMBER_TABLE
781: , a1 out nocopy JTF_NUMBER_TABLE
782: , a2 out nocopy JTF_VARCHAR2_TABLE_100
783: , a3 out nocopy JTF_NUMBER_TABLE
784: , a4 out nocopy JTF_DATE_TABLE

Line 849: procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE) as

845: end if;
846: end if;
847: end rosetta_table_copy_out_p12;
848:
849: procedure rosetta_table_copy_in_p13(t out nocopy lns_billing_batch_pub.amortization_sched_tbl, a0 JTF_NUMBER_TABLE) as
850: ddindx binary_integer; indx binary_integer;
851: begin
852: if a0 is not null and a0.count > 0 then
853: if a0.count > 0 then

Line 867: procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE) as

863: end loop;
864: end if;
865: end if;
866: end rosetta_table_copy_in_p13;
867: procedure rosetta_table_copy_out_p13(t lns_billing_batch_pub.amortization_sched_tbl, a0 out nocopy JTF_NUMBER_TABLE) as
868: ddindx binary_integer; indx binary_integer;
869: begin
870: if t is null or t.count = 0 then
871: a0 := JTF_NUMBER_TABLE();

Line 920: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;

916: , x_msg_data out nocopy VARCHAR2
917: )
918:
919: as
920: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;
921: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
922: ddindx binary_integer; indx binary_integer;
923: begin
924:

Line 921: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;

917: )
918:
919: as
920: ddp_bill_header_rec lns_billing_batch_pub.bill_header_rec;
921: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
922: ddindx binary_integer; indx binary_integer;
923: begin
924:
925: -- copy data to the local IN or IN-OUT args, if any

Line 937: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0

933: ddp_bill_header_rec.due_date := p4_a3;
934: ddp_bill_header_rec.cust_account_id := p4_a4;
935: ddp_bill_header_rec.bill_to_address_id := p4_a5;
936:
937: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0
938: , p5_a1
939: , p5_a2
940: , p5_a3
941: , p5_a4

Line 957: lns_billing_batch_pub.create_single_offcycle_bill(p_api_version,

953:
954:
955:
956: -- here's the delegated call to the old PL/SQL routine
957: lns_billing_batch_pub.create_single_offcycle_bill(p_api_version,
958: p_init_msg_list,
959: p_commit,
960: p_validation_level,
961: ddp_bill_header_rec,

Line 1008: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;

1004: , x_msg_data out nocopy VARCHAR2
1005: )
1006:
1007: as
1008: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
1009: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012:

Line 1009: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;

1005: )
1006:
1007: as
1008: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
1009: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
1010: ddindx binary_integer; indx binary_integer;
1011: begin
1012:
1013: -- copy data to the local IN or IN-OUT args, if any

Line 1018: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p4_a0

1014:
1015:
1016:
1017:
1018: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p4_a0
1019: , p4_a1
1020: , p4_a2
1021: , p4_a3
1022: , p4_a4

Line 1026: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0

1022: , p4_a4
1023: , p4_a5
1024: );
1025:
1026: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p5_a0
1027: , p5_a1
1028: , p5_a2
1029: , p5_a3
1030: , p5_a4

Line 1046: lns_billing_batch_pub.create_offcycle_bills(p_api_version,

1042:
1043:
1044:
1045: -- here's the delegated call to the old PL/SQL routine
1046: lns_billing_batch_pub.create_offcycle_bills(p_api_version,
1047: p_init_msg_list,
1048: p_commit,
1049: p_validation_level,
1050: ddp_bill_headers_tbl,

Line 1093: ddx_invoices_tbl lns_billing_batch_pub.invoice_details_tbl;

1089: , x_msg_data out nocopy VARCHAR2
1090: )
1091:
1092: as
1093: ddx_invoices_tbl lns_billing_batch_pub.invoice_details_tbl;
1094: ddindx binary_integer; indx binary_integer;
1095: begin
1096:
1097: -- copy data to the local IN or IN-OUT args, if any

Line 1108: lns_billing_batch_pub.get_next_instal_to_bill(p_api_version,

1104:
1105:
1106:
1107: -- here's the delegated call to the old PL/SQL routine
1108: lns_billing_batch_pub.get_next_instal_to_bill(p_api_version,
1109: p_init_msg_list,
1110: p_commit,
1111: p_validation_level,
1112: p_loan_id,

Line 1124: lns_billing_batch_pub_w.rosetta_table_copy_out_p10(ddx_invoices_tbl, p5_a0

1120:
1121:
1122:
1123:
1124: lns_billing_batch_pub_w.rosetta_table_copy_out_p10(ddx_invoices_tbl, p5_a0
1125: , p5_a1
1126: , p5_a2
1127: , p5_a3
1128: , p5_a4

Line 1166: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;

1162: , x_msg_data out nocopy VARCHAR2
1163: )
1164:
1165: as
1166: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1167: ddindx binary_integer; indx binary_integer;
1168: begin
1169:
1170: -- copy data to the local IN or IN-OUT args, if any

Line 1176: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p5_a0

1172:
1173:
1174:
1175:
1176: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p5_a0
1177: , p5_a1
1178: , p5_a2
1179: , p5_a3
1180: , p5_a4

Line 1192: lns_billing_batch_pub.bill_and_pay_next_instal(p_api_version,

1188:
1189:
1190:
1191: -- here's the delegated call to the old PL/SQL routine
1192: lns_billing_batch_pub.bill_and_pay_next_instal(p_api_version,
1193: p_init_msg_list,
1194: p_commit,
1195: p_validation_level,
1196: p_loan_id,

Line 1235: ddp_am_sched_tbl lns_billing_batch_pub.amortization_sched_tbl;

1231: , x_msg_data out nocopy VARCHAR2
1232: )
1233:
1234: as
1235: ddp_am_sched_tbl lns_billing_batch_pub.amortization_sched_tbl;
1236: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1237: ddindx binary_integer; indx binary_integer;
1238: begin
1239:

Line 1236: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;

1232: )
1233:
1234: as
1235: ddp_am_sched_tbl lns_billing_batch_pub.amortization_sched_tbl;
1236: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1237: ddindx binary_integer; indx binary_integer;
1238: begin
1239:
1240: -- copy data to the local IN or IN-OUT args, if any

Line 1246: lns_billing_batch_pub_w.rosetta_table_copy_in_p13(ddp_am_sched_tbl, p_am_sched_tbl);

1242:
1243:
1244:
1245:
1246: lns_billing_batch_pub_w.rosetta_table_copy_in_p13(ddp_am_sched_tbl, p_am_sched_tbl);
1247:
1248: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p6_a0
1249: , p6_a1
1250: , p6_a2

Line 1248: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p6_a0

1244:
1245:
1246: lns_billing_batch_pub_w.rosetta_table_copy_in_p13(ddp_am_sched_tbl, p_am_sched_tbl);
1247:
1248: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p6_a0
1249: , p6_a1
1250: , p6_a2
1251: , p6_a3
1252: , p6_a4

Line 1264: lns_billing_batch_pub.pay_installments(p_api_version,

1260:
1261:
1262:
1263: -- here's the delegated call to the old PL/SQL routine
1264: lns_billing_batch_pub.pay_installments(p_api_version,
1265: p_init_msg_list,
1266: p_commit,
1267: p_validation_level,
1268: p_loan_id,

Line 1299: ddrosetta_retval := lns_billing_batch_pub.can_bill_next_instal(p_loan_id);

1295:
1296: -- copy data to the local IN or IN-OUT args, if any
1297:
1298: -- here's the delegated call to the old PL/SQL routine
1299: ddrosetta_retval := lns_billing_batch_pub.can_bill_next_instal(p_loan_id);
1300:
1301: -- copy data back from the local variables to OUT or IN-OUT args, if any
1302: if ddrosetta_retval is null
1303: then ddrosetta_retval_bool := null;

Line 1337: ddx_invoices_tbl lns_billing_batch_pub.invoice_details_tbl;

1333: , x_msg_data out nocopy VARCHAR2
1334: )
1335:
1336: as
1337: ddx_invoices_tbl lns_billing_batch_pub.invoice_details_tbl;
1338: ddindx binary_integer; indx binary_integer;
1339: begin
1340:
1341: -- copy data to the local IN or IN-OUT args, if any

Line 1353: lns_billing_batch_pub.get_billed_installment(p_api_version,

1349:
1350:
1351:
1352: -- here's the delegated call to the old PL/SQL routine
1353: lns_billing_batch_pub.get_billed_installment(p_api_version,
1354: p_init_msg_list,
1355: p_commit,
1356: p_validation_level,
1357: p_loan_id,

Line 1371: lns_billing_batch_pub_w.rosetta_table_copy_out_p10(ddx_invoices_tbl, p6_a0

1367:
1368:
1369:
1370:
1371: lns_billing_batch_pub_w.rosetta_table_copy_out_p10(ddx_invoices_tbl, p6_a0
1372: , p6_a1
1373: , p6_a2
1374: , p6_a3
1375: , p6_a4

Line 1433: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;

1429: , x_msg_data out nocopy VARCHAR2
1430: )
1431:
1432: as
1433: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
1434: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
1435: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1436: ddindx binary_integer; indx binary_integer;
1437: begin

Line 1434: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;

1430: )
1431:
1432: as
1433: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
1434: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
1435: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1436: ddindx binary_integer; indx binary_integer;
1437: begin
1438:

Line 1435: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;

1431:
1432: as
1433: ddp_bill_headers_tbl lns_billing_batch_pub.bill_headers_tbl;
1434: ddp_bill_lines_tbl lns_billing_batch_pub.bill_lines_tbl;
1435: ddp_cash_receipts_tbl lns_billing_batch_pub.cash_receipt_tbl;
1436: ddindx binary_integer; indx binary_integer;
1437: begin
1438:
1439: -- copy data to the local IN or IN-OUT args, if any

Line 1445: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p5_a0

1441:
1442:
1443:
1444:
1445: lns_billing_batch_pub_w.rosetta_table_copy_in_p6(ddp_bill_headers_tbl, p5_a0
1446: , p5_a1
1447: , p5_a2
1448: , p5_a3
1449: , p5_a4

Line 1453: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p6_a0

1449: , p5_a4
1450: , p5_a5
1451: );
1452:
1453: lns_billing_batch_pub_w.rosetta_table_copy_in_p8(ddp_bill_lines_tbl, p6_a0
1454: , p6_a1
1455: , p6_a2
1456: , p6_a3
1457: , p6_a4

Line 1469: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p7_a0

1465: , p6_a12
1466: , p6_a13
1467: );
1468:
1469: lns_billing_batch_pub_w.rosetta_table_copy_in_p12(ddp_cash_receipts_tbl, p7_a0
1470: , p7_a1
1471: , p7_a2
1472: , p7_a3
1473: , p7_a4

Line 1485: lns_billing_batch_pub.bill_and_pay_offcycle_bills(p_api_version,

1481:
1482:
1483:
1484: -- here's the delegated call to the old PL/SQL routine
1485: lns_billing_batch_pub.bill_and_pay_offcycle_bills(p_api_version,
1486: p_init_msg_list,
1487: p_commit,
1488: p_validation_level,
1489: p_loan_id,

Line 1510: end lns_billing_batch_pub_w;

1506:
1507:
1508: end;
1509:
1510: end lns_billing_batch_pub_w;