DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_ASSET_PVT_W dependencies on OKL_LEASE_QUOTE_ASSET_PVT

Line 1: package body okl_lease_quote_asset_pvt_w as

1: package body okl_lease_quote_asset_pvt_w as
2: /* $Header: OKLEQUAB.pls 120.15.12010000.2 2010/04/30 15:26:38 rpillay ship $ */
3: procedure rosetta_table_copy_in_p26(t out nocopy okl_lease_quote_asset_pvt.asset_component_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p26(t out nocopy okl_lease_quote_asset_pvt.asset_component_tbl_type, a0 JTF_NUMBER_TABLE

1: package body okl_lease_quote_asset_pvt_w as
2: /* $Header: OKLEQUAB.pls 120.15.12010000.2 2010/04/30 15:26:38 rpillay ship $ */
3: procedure rosetta_table_copy_in_p26(t out nocopy okl_lease_quote_asset_pvt.asset_component_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE

Line 50: procedure rosetta_table_copy_out_p26(t okl_lease_quote_asset_pvt.asset_component_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

46: end loop;
47: end if;
48: end if;
49: end rosetta_table_copy_in_p26;
50: procedure rosetta_table_copy_out_p26(t okl_lease_quote_asset_pvt.asset_component_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
51: , a1 out nocopy JTF_NUMBER_TABLE
52: , a2 out nocopy JTF_NUMBER_TABLE
53: , a3 out nocopy JTF_NUMBER_TABLE
54: , a4 out nocopy JTF_NUMBER_TABLE

Line 144: procedure rosetta_table_copy_in_p28(t out nocopy okl_lease_quote_asset_pvt.asset_adjustment_tbl_type, a0 JTF_NUMBER_TABLE

140: end if;
141: end if;
142: end rosetta_table_copy_out_p26;
143:
144: procedure rosetta_table_copy_in_p28(t out nocopy okl_lease_quote_asset_pvt.asset_adjustment_tbl_type, a0 JTF_NUMBER_TABLE
145: , a1 JTF_NUMBER_TABLE
146: , a2 JTF_VARCHAR2_TABLE_100
147: , a3 JTF_NUMBER_TABLE
148: , a4 JTF_VARCHAR2_TABLE_100

Line 199: procedure rosetta_table_copy_out_p28(t okl_lease_quote_asset_pvt.asset_adjustment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

195: end loop;
196: end if;
197: end if;
198: end rosetta_table_copy_in_p28;
199: procedure rosetta_table_copy_out_p28(t okl_lease_quote_asset_pvt.asset_adjustment_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
200: , a1 out nocopy JTF_NUMBER_TABLE
201: , a2 out nocopy JTF_VARCHAR2_TABLE_100
202: , a3 out nocopy JTF_NUMBER_TABLE
203: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 398: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;

394: , x_msg_data out nocopy VARCHAR2
395: )
396:
397: as
398: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
399: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
400: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
401: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
402: ddindx binary_integer; indx binary_integer;

Line 399: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;

395: )
396:
397: as
398: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
399: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
400: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
401: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
402: ddindx binary_integer; indx binary_integer;
403: begin

Line 400: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;

396:
397: as
398: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
399: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
400: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
401: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
402: ddindx binary_integer; indx binary_integer;
403: begin
404:

Line 401: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;

397: as
398: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
399: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
400: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
401: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
402: ddindx binary_integer; indx binary_integer;
403: begin
404:
405: -- copy data to the local IN or IN-OUT args, if any

Line 447: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0

443: ddp_asset_rec.short_description := p3_a34;
444: ddp_asset_rec.description := p3_a35;
445: ddp_asset_rec.comments := p3_a36;
446:
447: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0
448: , p4_a1
449: , p4_a2
450: , p4_a3
451: , p4_a4

Line 495: okl_lease_quote_asset_pvt.create_asset(p_api_version,

491:
492:
493:
494: -- here's the delegated call to the old PL/SQL routine
495: okl_lease_quote_asset_pvt.create_asset(p_api_version,
496: p_init_msg_list,
497: p_transaction_control,
498: ddp_asset_rec,
499: ddp_component_tbl,

Line 604: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;

600: , x_msg_data out nocopy VARCHAR2
601: )
602:
603: as
604: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
605: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
606: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
607: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
608: ddindx binary_integer; indx binary_integer;

Line 605: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;

601: )
602:
603: as
604: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
605: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
606: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
607: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
608: ddindx binary_integer; indx binary_integer;
609: begin

Line 606: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;

602:
603: as
604: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
605: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
606: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
607: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
608: ddindx binary_integer; indx binary_integer;
609: begin
610:

Line 607: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;

603: as
604: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
605: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
606: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
607: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
608: ddindx binary_integer; indx binary_integer;
609: begin
610:
611: -- copy data to the local IN or IN-OUT args, if any

Line 654: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p5_a0

650: ddp_asset_rec.short_description := p4_a34;
651: ddp_asset_rec.description := p4_a35;
652: ddp_asset_rec.comments := p4_a36;
653:
654: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p5_a0
655: , p5_a1
656: , p5_a2
657: , p5_a3
658: , p5_a4

Line 702: okl_lease_quote_asset_pvt.duplicate_asset(p_api_version,

698:
699:
700:
701: -- here's the delegated call to the old PL/SQL routine
702: okl_lease_quote_asset_pvt.duplicate_asset(p_api_version,
703: p_init_msg_list,
704: p_transaction_control,
705: p_source_asset_id,
706: ddp_asset_rec,

Line 812: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;

808: , x_msg_data out nocopy VARCHAR2
809: )
810:
811: as
812: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
813: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
814: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
815: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
816: ddindx binary_integer; indx binary_integer;

Line 813: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;

809: )
810:
811: as
812: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
813: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
814: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
815: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin

Line 814: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;

810:
811: as
812: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
813: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
814: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
815: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:

Line 815: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;

811: as
812: ddp_asset_rec okl_lease_quote_asset_pvt.asset_rec_type;
813: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
814: ddp_cf_hdr_rec okl_lease_quote_asset_pvt.cashflow_hdr_rec_type;
815: ddp_cf_level_tbl okl_lease_quote_asset_pvt.cashflow_level_tbl_type;
816: ddindx binary_integer; indx binary_integer;
817: begin
818:
819: -- copy data to the local IN or IN-OUT args, if any

Line 861: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0

857: ddp_asset_rec.short_description := p3_a34;
858: ddp_asset_rec.description := p3_a35;
859: ddp_asset_rec.comments := p3_a36;
860:
861: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0
862: , p4_a1
863: , p4_a2
864: , p4_a3
865: , p4_a4

Line 909: okl_lease_quote_asset_pvt.update_asset(p_api_version,

905:
906:
907:
908: -- here's the delegated call to the old PL/SQL routine
909: okl_lease_quote_asset_pvt.update_asset(p_api_version,
910: p_init_msg_list,
911: p_transaction_control,
912: ddp_asset_rec,
913: ddp_component_tbl,

Line 960: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

956: , x_msg_data out nocopy VARCHAR2
957: )
958:
959: as
960: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
961: ddindx binary_integer; indx binary_integer;
962: begin
963:
964: -- copy data to the local IN or IN-OUT args, if any

Line 968: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0

964: -- copy data to the local IN or IN-OUT args, if any
965:
966:
967:
968: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0
969: , p3_a1
970: , p3_a2
971: , p3_a3
972: , p3_a4

Line 993: okl_lease_quote_asset_pvt.create_adjustment(p_api_version,

989:
990:
991:
992: -- here's the delegated call to the old PL/SQL routine
993: okl_lease_quote_asset_pvt.create_adjustment(p_api_version,
994: p_init_msg_list,
995: p_transaction_control,
996: ddp_asset_adj_tbl,
997: x_return_status,

Line 1038: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

1034: , x_msg_data out nocopy VARCHAR2
1035: )
1036:
1037: as
1038: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1039: ddindx binary_integer; indx binary_integer;
1040: begin
1041:
1042: -- copy data to the local IN or IN-OUT args, if any

Line 1046: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0

1042: -- copy data to the local IN or IN-OUT args, if any
1043:
1044:
1045:
1046: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0
1047: , p3_a1
1048: , p3_a2
1049: , p3_a3
1050: , p3_a4

Line 1071: okl_lease_quote_asset_pvt.update_adjustment(p_api_version,

1067:
1068:
1069:
1070: -- here's the delegated call to the old PL/SQL routine
1071: okl_lease_quote_asset_pvt.update_adjustment(p_api_version,
1072: p_init_msg_list,
1073: p_transaction_control,
1074: ddp_asset_adj_tbl,
1075: x_return_status,

Line 1168: ddp_asset_tbl okl_lease_quote_asset_pvt.asset_tbl_type;

1164: , x_msg_data out nocopy VARCHAR2
1165: )
1166:
1167: as
1168: ddp_asset_tbl okl_lease_quote_asset_pvt.asset_tbl_type;
1169: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
1170: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin

Line 1169: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;

1165: )
1166:
1167: as
1168: ddp_asset_tbl okl_lease_quote_asset_pvt.asset_tbl_type;
1169: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
1170: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:

Line 1170: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

1166:
1167: as
1168: ddp_asset_tbl okl_lease_quote_asset_pvt.asset_tbl_type;
1169: ddp_component_tbl okl_lease_quote_asset_pvt.asset_component_tbl_type;
1170: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin
1173:
1174: -- copy data to the local IN or IN-OUT args, if any

Line 1217: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0

1213: , p3_a35
1214: , p3_a36
1215: );
1216:
1217: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p26(ddp_component_tbl, p4_a0
1218: , p4_a1
1219: , p4_a2
1220: , p4_a3
1221: , p4_a4

Line 1234: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p5_a0

1230: , p4_a13
1231: , p4_a14
1232: );
1233:
1234: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p5_a0
1235: , p5_a1
1236: , p5_a2
1237: , p5_a3
1238: , p5_a4

Line 1259: okl_lease_quote_asset_pvt.create_assets_with_adjustments(p_api_version,

1255:
1256:
1257:
1258: -- here's the delegated call to the old PL/SQL routine
1259: okl_lease_quote_asset_pvt.create_assets_with_adjustments(p_api_version,
1260: p_init_msg_list,
1261: p_transaction_control,
1262: ddp_asset_tbl,
1263: ddp_component_tbl,

Line 1327: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

1323: , x_msg_data out nocopy VARCHAR2
1324: )
1325:
1326: as
1327: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1328: ddx_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1329: ddindx binary_integer; indx binary_integer;
1330: begin
1331:

Line 1328: ddx_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;

1324: )
1325:
1326: as
1327: ddp_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1328: ddx_asset_adj_tbl okl_lease_quote_asset_pvt.asset_adjustment_tbl_type;
1329: ddindx binary_integer; indx binary_integer;
1330: begin
1331:
1332: -- copy data to the local IN or IN-OUT args, if any

Line 1336: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0

1332: -- copy data to the local IN or IN-OUT args, if any
1333:
1334:
1335:
1336: okl_lease_quote_asset_pvt_w.rosetta_table_copy_in_p28(ddp_asset_adj_tbl, p3_a0
1337: , p3_a1
1338: , p3_a2
1339: , p3_a3
1340: , p3_a4

Line 1362: okl_lease_quote_asset_pvt.process_link_assets(p_api_version,

1358:
1359:
1360:
1361: -- here's the delegated call to the old PL/SQL routine
1362: okl_lease_quote_asset_pvt.process_link_assets(p_api_version,
1363: p_init_msg_list,
1364: p_transaction_control,
1365: ddp_asset_adj_tbl,
1366: ddx_asset_adj_tbl,

Line 1376: okl_lease_quote_asset_pvt_w.rosetta_table_copy_out_p28(ddx_asset_adj_tbl, p4_a0

1372:
1373:
1374:
1375:
1376: okl_lease_quote_asset_pvt_w.rosetta_table_copy_out_p28(ddx_asset_adj_tbl, p4_a0
1377: , p4_a1
1378: , p4_a2
1379: , p4_a3
1380: , p4_a4

Line 1401: end okl_lease_quote_asset_pvt_w;

1397:
1398:
1399: end;
1400:
1401: end okl_lease_quote_asset_pvt_w;