DBA Data[Home] [Help]

APPS.LNS_CUSTOM_PUB_W dependencies on LNS_CUSTOM_PUB

Line 1: package body lns_custom_pub_w as

1: package body lns_custom_pub_w as
2: /* $Header: LNS_CUST_PUBJ_B.pls 120.6.12020000.2 2012/07/19 20:53:54 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_custom_pub.custom_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p1(t out nocopy lns_custom_pub.custom_tbl, a0 JTF_NUMBER_TABLE

1: package body lns_custom_pub_w as
2: /* $Header: LNS_CUST_PUBJ_B.pls 120.6.12020000.2 2012/07/19 20:53:54 scherkas ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy lns_custom_pub.custom_tbl, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_DATE_TABLE
7: , a4 JTF_DATE_TABLE

Line 152: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE

148: end loop;
149: end if;
150: end if;
151: end rosetta_table_copy_in_p1;
152: procedure rosetta_table_copy_out_p1(t lns_custom_pub.custom_tbl, a0 out nocopy JTF_NUMBER_TABLE
153: , a1 out nocopy JTF_NUMBER_TABLE
154: , a2 out nocopy JTF_NUMBER_TABLE
155: , a3 out nocopy JTF_DATE_TABLE
156: , a4 out nocopy JTF_DATE_TABLE

Line 530: lns_custom_pub.resetcustomschedule(p_loan_id,

526:
527:
528:
529: -- here's the delegated call to the old PL/SQL routine
530: lns_custom_pub.resetcustomschedule(p_loan_id,
531: p_init_msg_list,
532: p_commit,
533: ddp_update_header,
534: x_return_status,

Line 623: ddp_custom_tbl lns_custom_pub.custom_tbl;

619: , x_invalid_installment_num out nocopy NUMBER
620: )
621:
622: as
623: ddp_custom_tbl lns_custom_pub.custom_tbl;
624: ddindx binary_integer; indx binary_integer;
625: begin
626:
627: -- copy data to the local IN or IN-OUT args, if any

Line 628: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p0_a0

624: ddindx binary_integer; indx binary_integer;
625: begin
626:
627: -- copy data to the local IN or IN-OUT args, if any
628: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p0_a0
629: , p0_a1
630: , p0_a2
631: , p0_a3
632: , p0_a4

Line 704: lns_custom_pub.createcustomschedule(ddp_custom_tbl,

700:
701:
702:
703: -- here's the delegated call to the old PL/SQL routine
704: lns_custom_pub.createcustomschedule(ddp_custom_tbl,
705: p_loan_id,
706: p_init_msg_list,
707: p_commit,
708: x_return_status,

Line 799: ddp_custom_tbl lns_custom_pub.custom_tbl;

795: , x_invalid_installment_num out nocopy NUMBER
796: )
797:
798: as
799: ddp_custom_tbl lns_custom_pub.custom_tbl;
800: ddindx binary_integer; indx binary_integer;
801: begin
802:
803: -- copy data to the local IN or IN-OUT args, if any

Line 804: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p0_a0

800: ddindx binary_integer; indx binary_integer;
801: begin
802:
803: -- copy data to the local IN or IN-OUT args, if any
804: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p0_a0
805: , p0_a1
806: , p0_a2
807: , p0_a3
808: , p0_a4

Line 880: lns_custom_pub.updatecustomschedule(ddp_custom_tbl,

876:
877:
878:
879: -- here's the delegated call to the old PL/SQL routine
880: lns_custom_pub.updatecustomschedule(ddp_custom_tbl,
881: p_loan_id,
882: p_init_msg_list,
883: p_commit,
884: x_return_status,

Line 972: ddp_custom_rec lns_custom_pub.custom_sched_type;

968: , x_msg_data out nocopy VARCHAR2
969: )
970:
971: as
972: ddp_custom_rec lns_custom_pub.custom_sched_type;
973: ddindx binary_integer; indx binary_integer;
974: begin
975:
976: -- copy data to the local IN or IN-OUT args, if any

Line 1049: lns_custom_pub.createcustomsched(ddp_custom_rec,

1045:
1046:
1047:
1048: -- here's the delegated call to the old PL/SQL routine
1049: lns_custom_pub.createcustomsched(ddp_custom_rec,
1050: x_custom_sched_id,
1051: x_return_status,
1052: x_msg_count,
1053: x_msg_data);

Line 1134: ddp_custom_rec lns_custom_pub.custom_sched_type;

1130: , x_msg_data out nocopy VARCHAR2
1131: )
1132:
1133: as
1134: ddp_custom_rec lns_custom_pub.custom_sched_type;
1135: ddindx binary_integer; indx binary_integer;
1136: begin
1137:
1138: -- copy data to the local IN or IN-OUT args, if any

Line 1210: lns_custom_pub.updatecustomsched(ddp_custom_rec,

1206:
1207:
1208:
1209: -- here's the delegated call to the old PL/SQL routine
1210: lns_custom_pub.updatecustomsched(ddp_custom_rec,
1211: x_return_status,
1212: x_msg_count,
1213: x_msg_data);
1214:

Line 1296: ddp_cust_tbl lns_custom_pub.custom_tbl;

1292: , x_msg_data out nocopy VARCHAR2
1293: )
1294:
1295: as
1296: ddp_cust_tbl lns_custom_pub.custom_tbl;
1297: ddp_create_flag boolean;
1298: ddindx binary_integer; indx binary_integer;
1299: begin
1300:

Line 1302: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_cust_tbl, p0_a0

1298: ddindx binary_integer; indx binary_integer;
1299: begin
1300:
1301: -- copy data to the local IN or IN-OUT args, if any
1302: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_cust_tbl, p0_a0
1303: , p0_a1
1304: , p0_a2
1305: , p0_a3
1306: , p0_a4

Line 1383: lns_custom_pub.validatecustomtable(ddp_cust_tbl,

1379:
1380:
1381:
1382: -- here's the delegated call to the old PL/SQL routine
1383: lns_custom_pub.validatecustomtable(ddp_cust_tbl,
1384: p_loan_id,
1385: ddp_create_flag,
1386: x_installment,
1387: x_return_status,

Line 1472: ddp_custom_rec lns_custom_pub.custom_sched_type;

1468: , x_msg_data out nocopy VARCHAR2
1469: )
1470:
1471: as
1472: ddp_custom_rec lns_custom_pub.custom_sched_type;
1473: ddindx binary_integer; indx binary_integer;
1474: begin
1475:
1476: -- copy data to the local IN or IN-OUT args, if any

Line 1548: lns_custom_pub.validatecustomrow(ddp_custom_rec,

1544:
1545:
1546:
1547: -- here's the delegated call to the old PL/SQL routine
1548: lns_custom_pub.validatecustomrow(ddp_custom_rec,
1549: x_return_status,
1550: x_msg_count,
1551: x_msg_data);
1552:

Line 1640: ddp_custom_set_rec lns_custom_pub.custom_settings_type;

1636: , x_msg_data out nocopy VARCHAR2
1637: )
1638:
1639: as
1640: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
1641: ddp_custom_tbl lns_custom_pub.custom_tbl;
1642: ddindx binary_integer; indx binary_integer;
1643: begin
1644:

Line 1641: ddp_custom_tbl lns_custom_pub.custom_tbl;

1637: )
1638:
1639: as
1640: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
1641: ddp_custom_tbl lns_custom_pub.custom_tbl;
1642: ddindx binary_integer; indx binary_integer;
1643: begin
1644:
1645: -- copy data to the local IN or IN-OUT args, if any

Line 1656: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p8_a0

1652:
1653: ddp_custom_set_rec.amort_method := p7_a0;
1654: ddp_custom_set_rec.description := p7_a1;
1655:
1656: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p8_a0
1657: , p8_a1
1658: , p8_a2
1659: , p8_a3
1660: , p8_a4

Line 1728: lns_custom_pub.recalccustomschedule(p_api_version,

1724:
1725:
1726:
1727: -- here's the delegated call to the old PL/SQL routine
1728: lns_custom_pub.recalccustomschedule(p_api_version,
1729: p_init_msg_list,
1730: p_commit,
1731: p_validation_level,
1732: p_loan_id,

Line 1752: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p8_a0

1748:
1749: p7_a0 := ddp_custom_set_rec.amort_method;
1750: p7_a1 := ddp_custom_set_rec.description;
1751:
1752: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p8_a0
1753: , p8_a1
1754: , p8_a2
1755: , p8_a3
1756: , p8_a4

Line 1904: ddx_custom_set_rec lns_custom_pub.custom_settings_type;

1900: , x_msg_data out nocopy VARCHAR2
1901: )
1902:
1903: as
1904: ddx_custom_set_rec lns_custom_pub.custom_settings_type;
1905: ddx_custom_tbl lns_custom_pub.custom_tbl;
1906: ddindx binary_integer; indx binary_integer;
1907: begin
1908:

Line 1905: ddx_custom_tbl lns_custom_pub.custom_tbl;

1901: )
1902:
1903: as
1904: ddx_custom_set_rec lns_custom_pub.custom_settings_type;
1905: ddx_custom_tbl lns_custom_pub.custom_tbl;
1906: ddindx binary_integer; indx binary_integer;
1907: begin
1908:
1909: -- copy data to the local IN or IN-OUT args, if any

Line 1922: lns_custom_pub.loadcustomschedule(p_api_version,

1918:
1919:
1920:
1921: -- here's the delegated call to the old PL/SQL routine
1922: lns_custom_pub.loadcustomschedule(p_api_version,
1923: p_init_msg_list,
1924: p_commit,
1925: p_validation_level,
1926: p_loan_id,

Line 1944: lns_custom_pub_w.rosetta_table_copy_out_p1(ddx_custom_tbl, p7_a0

1940:
1941: p6_a0 := ddx_custom_set_rec.amort_method;
1942: p6_a1 := ddx_custom_set_rec.description;
1943:
1944: lns_custom_pub_w.rosetta_table_copy_out_p1(ddx_custom_tbl, p7_a0
1945: , p7_a1
1946: , p7_a2
1947: , p7_a3
1948: , p7_a4

Line 2097: ddp_custom_set_rec lns_custom_pub.custom_settings_type;

2093: , x_msg_data out nocopy VARCHAR2
2094: )
2095:
2096: as
2097: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2098: ddp_custom_tbl lns_custom_pub.custom_tbl;
2099: ddindx binary_integer; indx binary_integer;
2100: begin
2101:

Line 2098: ddp_custom_tbl lns_custom_pub.custom_tbl;

2094: )
2095:
2096: as
2097: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2098: ddp_custom_tbl lns_custom_pub.custom_tbl;
2099: ddindx binary_integer; indx binary_integer;
2100: begin
2101:
2102: -- copy data to the local IN or IN-OUT args, if any

Line 2113: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p8_a0

2109:
2110: ddp_custom_set_rec.amort_method := p7_a0;
2111: ddp_custom_set_rec.description := p7_a1;
2112:
2113: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p8_a0
2114: , p8_a1
2115: , p8_a2
2116: , p8_a3
2117: , p8_a4

Line 2185: lns_custom_pub.savecustomschedule(p_api_version,

2181:
2182:
2183:
2184: -- here's the delegated call to the old PL/SQL routine
2185: lns_custom_pub.savecustomschedule(p_api_version,
2186: p_init_msg_list,
2187: p_commit,
2188: p_validation_level,
2189: p_loan_id,

Line 2209: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p8_a0

2205:
2206: p7_a0 := ddp_custom_set_rec.amort_method;
2207: p7_a1 := ddp_custom_set_rec.description;
2208:
2209: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p8_a0
2210: , p8_a1
2211: , p8_a2
2212: , p8_a3
2213: , p8_a4

Line 2363: ddp_custom_set_rec lns_custom_pub.custom_settings_type;

2359: , x_msg_data out nocopy VARCHAR2
2360: )
2361:
2362: as
2363: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2364: ddp_custom_tbl lns_custom_pub.custom_tbl;
2365: ddindx binary_integer; indx binary_integer;
2366: begin
2367:

Line 2364: ddp_custom_tbl lns_custom_pub.custom_tbl;

2360: )
2361:
2362: as
2363: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2364: ddp_custom_tbl lns_custom_pub.custom_tbl;
2365: ddindx binary_integer; indx binary_integer;
2366: begin
2367:
2368: -- copy data to the local IN or IN-OUT args, if any

Line 2380: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p9_a0

2376:
2377: ddp_custom_set_rec.amort_method := p8_a0;
2378: ddp_custom_set_rec.description := p8_a1;
2379:
2380: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p9_a0
2381: , p9_a1
2382: , p9_a2
2383: , p9_a3
2384: , p9_a4

Line 2452: lns_custom_pub.shiftcustomschedule(p_api_version,

2448:
2449:
2450:
2451: -- here's the delegated call to the old PL/SQL routine
2452: lns_custom_pub.shiftcustomschedule(p_api_version,
2453: p_init_msg_list,
2454: p_commit,
2455: p_validation_level,
2456: p_loan_id,

Line 2478: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p9_a0

2474:
2475: p8_a0 := ddp_custom_set_rec.amort_method;
2476: p8_a1 := ddp_custom_set_rec.description;
2477:
2478: lns_custom_pub_w.rosetta_table_copy_out_p1(ddp_custom_tbl, p9_a0
2479: , p9_a1
2480: , p9_a2
2481: , p9_a3
2482: , p9_a4

Line 2626: ddp_installment_rec lns_custom_pub.custom_sched_type;

2622: , x_msg_data out nocopy VARCHAR2
2623: )
2624:
2625: as
2626: ddp_installment_rec lns_custom_pub.custom_sched_type;
2627: ddindx binary_integer; indx binary_integer;
2628: begin
2629:
2630: -- copy data to the local IN or IN-OUT args, if any

Line 2706: lns_custom_pub.addmissinginstallment(p_api_version,

2702:
2703:
2704:
2705: -- here's the delegated call to the old PL/SQL routine
2706: lns_custom_pub.addmissinginstallment(p_api_version,
2707: p_init_msg_list,
2708: p_commit,
2709: p_validation_level,
2710: ddp_installment_rec,

Line 2803: ddp_custom_set_rec lns_custom_pub.custom_settings_type;

2799: , x_msg_data out nocopy VARCHAR2
2800: )
2801:
2802: as
2803: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2804: ddp_custom_tbl lns_custom_pub.custom_tbl;
2805: ddindx binary_integer; indx binary_integer;
2806: begin
2807:

Line 2804: ddp_custom_tbl lns_custom_pub.custom_tbl;

2800: )
2801:
2802: as
2803: ddp_custom_set_rec lns_custom_pub.custom_settings_type;
2804: ddp_custom_tbl lns_custom_pub.custom_tbl;
2805: ddindx binary_integer; indx binary_integer;
2806: begin
2807:
2808: -- copy data to the local IN or IN-OUT args, if any

Line 2816: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p5_a0

2812:
2813: ddp_custom_set_rec.amort_method := p4_a0;
2814: ddp_custom_set_rec.description := p4_a1;
2815:
2816: lns_custom_pub_w.rosetta_table_copy_in_p1(ddp_custom_tbl, p5_a0
2817: , p5_a1
2818: , p5_a2
2819: , p5_a3
2820: , p5_a4

Line 2888: lns_custom_pub.retaincustomschedule(p_api_version,

2884:
2885:
2886:
2887: -- here's the delegated call to the old PL/SQL routine
2888: lns_custom_pub.retaincustomschedule(p_api_version,
2889: p_init_msg_list,
2890: p_commit,
2891: p_validation_level,
2892: ddp_custom_set_rec,

Line 2987: ddx_custom_set_rec lns_custom_pub.custom_settings_type;

2983: , x_msg_data out nocopy VARCHAR2
2984: )
2985:
2986: as
2987: ddx_custom_set_rec lns_custom_pub.custom_settings_type;
2988: ddx_custom_tbl lns_custom_pub.custom_tbl;
2989: ddindx binary_integer; indx binary_integer;
2990: begin
2991:

Line 2988: ddx_custom_tbl lns_custom_pub.custom_tbl;

2984: )
2985:
2986: as
2987: ddx_custom_set_rec lns_custom_pub.custom_settings_type;
2988: ddx_custom_tbl lns_custom_pub.custom_tbl;
2989: ddindx binary_integer; indx binary_integer;
2990: begin
2991:
2992: -- copy data to the local IN or IN-OUT args, if any

Line 3003: lns_custom_pub.getretainedschedule(p_api_version,

2999:
3000:
3001:
3002: -- here's the delegated call to the old PL/SQL routine
3003: lns_custom_pub.getretainedschedule(p_api_version,
3004: p_init_msg_list,
3005: p_commit,
3006: p_validation_level,
3007: ddx_custom_set_rec,

Line 3021: lns_custom_pub_w.rosetta_table_copy_out_p1(ddx_custom_tbl, p5_a0

3017:
3018: p4_a0 := ddx_custom_set_rec.amort_method;
3019: p4_a1 := ddx_custom_set_rec.description;
3020:
3021: lns_custom_pub_w.rosetta_table_copy_out_p1(ddx_custom_tbl, p5_a0
3022: , p5_a1
3023: , p5_a2
3024: , p5_a3
3025: , p5_a4

Line 3093: end lns_custom_pub_w;

3089:
3090:
3091: end;
3092:
3093: end lns_custom_pub_w;