DBA Data[Home] [Help]

APPS.OKL_FUNDING_PVT_W dependencies on OKL_FUNDING_PVT

Line 1: package body okl_funding_pvt_w as

1: package body okl_funding_pvt_w as
2: /* $Header: OKLEFUNB.pls 120.4 2007/11/20 08:27:11 dcshanmu noship $ */
3: rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4: rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5: rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');

Line 44: ddx_fnd_rec okl_funding_pvt.fnd_rec_type;

40: , p6_a9 out nocopy NUMBER
41: )
42:
43: as
44: ddx_fnd_rec okl_funding_pvt.fnd_rec_type;
45: ddindx binary_integer; indx binary_integer;
46: begin
47:
48: -- copy data to the local IN or IN-OUT args, if any

Line 57: okl_funding_pvt.get_fund_summary(p_api_version,

53:
54:
55:
56: -- here's the delegated call to the old PL/SQL routine
57: okl_funding_pvt.get_fund_summary(p_api_version,
58: p_init_msg_list,
59: x_return_status,
60: x_msg_count,
61: x_msg_data,

Line 240: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;

236: , p5_a73 DATE := fnd_api.g_miss_date
237: )
238:
239: as
240: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;
241: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;
242: ddindx binary_integer; indx binary_integer;
243: begin
244:

Line 241: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;

237: )
238:
239: as
240: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;
241: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;
242: ddindx binary_integer; indx binary_integer;
243: begin
244:
245: -- copy data to the local IN or IN-OUT args, if any

Line 328: okl_funding_pvt.create_funding_header(p_api_version,

324: ddp_tapv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
325:
326:
327: -- here's the delegated call to the old PL/SQL routine
328: okl_funding_pvt.create_funding_header(p_api_version,
329: p_init_msg_list,
330: x_return_status,
331: x_msg_count,
332: x_msg_data,

Line 575: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;

571: , p5_a73 DATE := fnd_api.g_miss_date
572: )
573:
574: as
575: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;
576: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:

Line 576: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;

572: )
573:
574: as
575: ddp_tapv_rec okl_funding_pvt.tapv_rec_type;
576: ddx_tapv_rec okl_funding_pvt.tapv_rec_type;
577: ddindx binary_integer; indx binary_integer;
578: begin
579:
580: -- copy data to the local IN or IN-OUT args, if any

Line 663: okl_funding_pvt.update_funding_header(p_api_version,

659: ddp_tapv_rec.transaction_date := rosetta_g_miss_date_in_map(p5_a73);
660:
661:
662: -- here's the delegated call to the old PL/SQL routine
663: okl_funding_pvt.update_funding_header(p_api_version,
664: p_init_msg_list,
665: x_return_status,
666: x_msg_count,
667: x_msg_data,

Line 870: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;

866: , p6_a53 out nocopy JTF_NUMBER_TABLE
867: )
868:
869: as
870: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
871: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;
872: ddindx binary_integer; indx binary_integer;
873: begin
874:

Line 871: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;

867: )
868:
869: as
870: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
871: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;
872: ddindx binary_integer; indx binary_integer;
873: begin
874:
875: -- copy data to the local IN or IN-OUT args, if any

Line 939: okl_funding_pvt.create_funding_lines(p_api_version,

935: );
936:
937:
938: -- here's the delegated call to the old PL/SQL routine
939: okl_funding_pvt.create_funding_lines(p_api_version,
940: p_init_msg_list,
941: x_return_status,
942: x_msg_count,
943: x_msg_data,

Line 1076: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;

1072: , p8_a53 out nocopy JTF_NUMBER_TABLE
1073: )
1074:
1075: as
1076: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1077: ddindx binary_integer; indx binary_integer;
1078: begin
1079:
1080: -- copy data to the local IN or IN-OUT args, if any

Line 1091: okl_funding_pvt.create_funding_lines(p_api_version,

1087:
1088:
1089:
1090: -- here's the delegated call to the old PL/SQL routine
1091: okl_funding_pvt.create_funding_lines(p_api_version,
1092: p_init_msg_list,
1093: x_return_status,
1094: x_msg_count,
1095: x_msg_data,

Line 1283: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;

1279: , p6_a53 out nocopy JTF_NUMBER_TABLE
1280: )
1281:
1282: as
1283: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1284: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1285: ddindx binary_integer; indx binary_integer;
1286: begin
1287:

Line 1284: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;

1280: )
1281:
1282: as
1283: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1284: ddx_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1285: ddindx binary_integer; indx binary_integer;
1286: begin
1287:
1288: -- copy data to the local IN or IN-OUT args, if any

Line 1352: okl_funding_pvt.update_funding_lines(p_api_version,

1348: );
1349:
1350:
1351: -- here's the delegated call to the old PL/SQL routine
1352: okl_funding_pvt.update_funding_lines(p_api_version,
1353: p_init_msg_list,
1354: x_return_status,
1355: x_msg_count,
1356: x_msg_data,

Line 1486: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;

1482: , p5_a53 JTF_NUMBER_TABLE
1483: )
1484:
1485: as
1486: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1487: ddindx binary_integer; indx binary_integer;
1488: begin
1489:
1490: -- copy data to the local IN or IN-OUT args, if any

Line 1553: okl_funding_pvt.sync_header_amount(p_api_version,

1549: , p5_a53
1550: );
1551:
1552: -- here's the delegated call to the old PL/SQL routine
1553: okl_funding_pvt.sync_header_amount(p_api_version,
1554: p_init_msg_list,
1555: x_return_status,
1556: x_msg_count,
1557: x_msg_data,

Line 1585: ddrosetta_retval := okl_funding_pvt.get_chr_exp_canbe_funded_amt(p_contract_id,

1581:
1582: ddp_due_date := rosetta_g_miss_date_in_map(p_due_date);
1583:
1584: -- here's the delegated call to the old PL/SQL routine
1585: ddrosetta_retval := okl_funding_pvt.get_chr_exp_canbe_funded_amt(p_contract_id,
1586: p_vendor_site_id,
1587: ddp_due_date);
1588:
1589: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1611: ddrosetta_retval := okl_funding_pvt.get_chr_exp_canbe_funded_amt(p_contract_id,

1607:
1608: ddp_due_date := rosetta_g_miss_date_in_map(p_due_date);
1609:
1610: -- here's the delegated call to the old PL/SQL routine
1611: ddrosetta_retval := okl_funding_pvt.get_chr_exp_canbe_funded_amt(p_contract_id,
1612: ddp_due_date);
1613:
1614: -- copy data back from the local variables to OUT or IN-OUT args, if any
1615:

Line 1677: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;

1673: , p0_a53 JTF_NUMBER_TABLE
1674: ) return varchar2
1675:
1676: as
1677: ddp_tplv_tbl okl_funding_pvt.tplv_tbl_type;
1678: ddindx binary_integer; indx binary_integer;
1679: ddrosetta_retval varchar2(4000);
1680: begin
1681:

Line 1740: ddrosetta_retval := okl_funding_pvt.is_kle_id_unique(ddp_tplv_tbl);

1736: , p0_a53
1737: );
1738:
1739: -- here's the delegated call to the old PL/SQL routine
1740: ddrosetta_retval := okl_funding_pvt.is_kle_id_unique(ddp_tplv_tbl);
1741:
1742: -- copy data back from the local variables to OUT or IN-OUT args, if any
1743:
1744: return ddrosetta_retval;

Line 1775: okl_funding_pvt.contract_fee_canbe_funded(p_api_version,

1771:
1772: ddp_effective_date := rosetta_g_miss_date_in_map(p_effective_date);
1773:
1774: -- here's the delegated call to the old PL/SQL routine
1775: okl_funding_pvt.contract_fee_canbe_funded(p_api_version,
1776: p_init_msg_list,
1777: x_return_status,
1778: x_msg_count,
1779: x_msg_data,

Line 1813: ddrosetta_retval := okl_funding_pvt.get_chr_fee_canbe_funded_amt(p_contract_id,

1809:
1810: ddp_effective_date := rosetta_g_miss_date_in_map(p_effective_date);
1811:
1812: -- here's the delegated call to the old PL/SQL routine
1813: ddrosetta_retval := okl_funding_pvt.get_chr_fee_canbe_funded_amt(p_contract_id,
1814: p_fee_line_id,
1815: ddp_effective_date);
1816:
1817: -- copy data back from the local variables to OUT or IN-OUT args, if any

Line 1847: okl_funding_pvt.is_contract_fully_funded(p_api_version,

1843:
1844:
1845:
1846: -- here's the delegated call to the old PL/SQL routine
1847: okl_funding_pvt.is_contract_fully_funded(p_api_version,
1848: p_init_msg_list,
1849: x_return_status,
1850: x_msg_count,
1851: x_msg_data,

Line 1882: ddrosetta_retval := okl_funding_pvt.is_contract_fully_funded(p_contract_id);

1878:
1879: -- copy data to the local IN or IN-OUT args, if any
1880:
1881: -- here's the delegated call to the old PL/SQL routine
1882: ddrosetta_retval := okl_funding_pvt.is_contract_fully_funded(p_contract_id);
1883:
1884: -- copy data back from the local variables to OUT or IN-OUT args, if any
1885: if ddrosetta_retval is null
1886: then ddrosetta_retval_bool := null;

Line 1893: end okl_funding_pvt_w;

1889: else ddrosetta_retval_bool := 0;
1890: end if;
1891: end;
1892:
1893: end okl_funding_pvt_w;