DBA Data[Home] [Help]

APPS.OKL_AM_PARTIES_PVT_W dependencies on OKL_AM_PARTIES_PVT

Line 1: package body okl_am_parties_pvt_w as

1: package body okl_am_parties_pvt_w as
2: /* $Header: OKLEAMPB.pls 115.10 2002/12/13 19:30:18 gkadarka 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:

Line 22: procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE

18: if n=b then return a; end if;
19: return n;
20: end;
21:
22: procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_NUMBER_TABLE
24: , a2 JTF_VARCHAR2_TABLE_100
25: , a3 JTF_NUMBER_TABLE
26: , a4 JTF_VARCHAR2_TABLE_100

Line 111: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

107: end loop;
108: end if;
109: end if;
110: end rosetta_table_copy_in_p2;
111: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
112: , a1 out nocopy JTF_NUMBER_TABLE
113: , a2 out nocopy JTF_VARCHAR2_TABLE_100
114: , a3 out nocopy JTF_NUMBER_TABLE
115: , a4 out nocopy JTF_VARCHAR2_TABLE_100

Line 310: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100

306: end if;
307: end if;
308: end rosetta_table_copy_out_p2;
309:
310: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100
311: , a1 JTF_VARCHAR2_TABLE_100
312: , a2 JTF_VARCHAR2_TABLE_200
313: , a3 JTF_VARCHAR2_TABLE_400
314: , a4 JTF_VARCHAR2_TABLE_2000

Line 367: procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100

363: end loop;
364: end if;
365: end if;
366: end rosetta_table_copy_in_p3;
367: procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
368: , a1 out nocopy JTF_VARCHAR2_TABLE_100
369: , a2 out nocopy JTF_VARCHAR2_TABLE_200
370: , a3 out nocopy JTF_VARCHAR2_TABLE_400
371: , a4 out nocopy JTF_VARCHAR2_TABLE_2000

Line 631: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;

627: , p5_a79 DATE := fnd_api.g_miss_date
628: )
629:
630: as
631: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
632: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
633: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
634: ddindx binary_integer; indx binary_integer;
635: begin

Line 632: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;

628: )
629:
630: as
631: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
632: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
633: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
634: ddindx binary_integer; indx binary_integer;
635: begin
636:

Line 633: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

629:
630: as
631: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
632: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
633: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
634: ddindx binary_integer; indx binary_integer;
635: begin
636:
637: -- copy data to the local IN or IN-OUT args, if any

Line 728: okl_am_parties_pvt.fetch_rule_quote_parties(p_api_version,

724:
725:
726:
727: -- here's the delegated call to the old PL/SQL routine
728: okl_am_parties_pvt.fetch_rule_quote_parties(p_api_version,
729: p_init_msg_list,
730: x_msg_count,
731: x_msg_data,
732: x_return_status,

Line 767: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p7_a0

763: , p6_a18
764: , p6_a19
765: );
766:
767: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p7_a0
768: , p7_a1
769: , p7_a2
770: , p7_a3
771: , p7_a4

Line 912: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;

908: , p0_a79 DATE := fnd_api.g_miss_date
909: )
910:
911: as
912: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
913: ddp_validate_only boolean;
914: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
915: ddindx binary_integer; indx binary_integer;
916: begin

Line 914: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;

910:
911: as
912: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
913: ddp_validate_only boolean;
914: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
915: ddindx binary_integer; indx binary_integer;
916: begin
917:
918: -- copy data to the local IN or IN-OUT args, if any

Line 1010: okl_am_parties_pvt.create_partner_as_recipient(ddp_qtev_rec,

1006:
1007:
1008:
1009: -- here's the delegated call to the old PL/SQL routine
1010: okl_am_parties_pvt.create_partner_as_recipient(ddp_qtev_rec,
1011: ddp_validate_only,
1012: ddx_qpyv_tbl,
1013: x_return_status);
1014:

Line 1167: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;

1163: , p0_a79 DATE := fnd_api.g_miss_date
1164: )
1165:
1166: as
1167: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
1168: ddp_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
1169: ddp_validate_only boolean;
1170: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
1171: ddindx binary_integer; indx binary_integer;

Line 1168: ddp_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;

1164: )
1165:
1166: as
1167: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
1168: ddp_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
1169: ddp_validate_only boolean;
1170: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
1171: ddindx binary_integer; indx binary_integer;
1172: begin

Line 1170: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;

1166: as
1167: ddp_qtev_rec okl_am_parties_pvt.qtev_rec_type;
1168: ddp_qpyv_tbl okl_am_parties_pvt.qpyv_tbl_type;
1169: ddp_validate_only boolean;
1170: ddx_qpyv_tbl okl_am_parties_pvt.qpyv_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 1288: okl_am_parties_pvt.create_quote_parties(ddp_qtev_rec,

1284:
1285:
1286:
1287: -- here's the delegated call to the old PL/SQL routine
1288: okl_am_parties_pvt.create_quote_parties(ddp_qtev_rec,
1289: ddp_qpyv_tbl,
1290: ddp_validate_only,
1291: ddx_qpyv_tbl,
1292: x_return_status);

Line 1348: ddx_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;

1344: , x_return_status out nocopy VARCHAR2
1345: )
1346:
1347: as
1348: ddx_party_object_tbl okl_am_parties_pvt.party_object_tbl_type;
1349: ddindx binary_integer; indx binary_integer;
1350: begin
1351:
1352: -- copy data to the local IN or IN-OUT args, if any

Line 1358: okl_am_parties_pvt.get_party_details(p_id_code,

1354:
1355:
1356:
1357: -- here's the delegated call to the old PL/SQL routine
1358: okl_am_parties_pvt.get_party_details(p_id_code,
1359: p_id_value,
1360: ddx_party_object_tbl,
1361: x_return_status);
1362:

Line 1366: okl_am_parties_pvt_w.rosetta_table_copy_out_p3(ddx_party_object_tbl, p2_a0

1362:
1363: -- copy data back from the local variables to OUT or IN-OUT args, if any
1364:
1365:
1366: okl_am_parties_pvt_w.rosetta_table_copy_out_p3(ddx_party_object_tbl, p2_a0
1367: , p2_a1
1368: , p2_a2
1369: , p2_a3
1370: , p2_a4

Line 1471: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

1467: , p5_a35 DATE := fnd_api.g_miss_date
1468: )
1469:
1470: as
1471: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1472: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
1473: ddindx binary_integer; indx binary_integer;
1474: begin
1475:

Line 1472: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

1468: )
1469:
1470: as
1471: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1472: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_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 1522: okl_am_parties_pvt.get_quote_parties(p_api_version,

1518:
1519:
1520:
1521: -- here's the delegated call to the old PL/SQL routine
1522: okl_am_parties_pvt.get_quote_parties(p_api_version,
1523: p_init_msg_list,
1524: x_msg_count,
1525: x_msg_data,
1526: x_return_status,

Line 1538: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0

1534:
1535:
1536:
1537:
1538: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0
1539: , p6_a1
1540: , p6_a2
1541: , p6_a3
1542: , p6_a4

Line 1659: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

1655: , p5_a35 DATE := fnd_api.g_miss_date
1656: )
1657:
1658: as
1659: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1660: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
1661: ddindx binary_integer; indx binary_integer;
1662: begin
1663:

Line 1660: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

1656: )
1657:
1658: as
1659: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1660: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
1661: ddindx binary_integer; indx binary_integer;
1662: begin
1663:
1664: -- copy data to the local IN or IN-OUT args, if any

Line 1710: okl_am_parties_pvt.get_quote_party_contacts(p_api_version,

1706:
1707:
1708:
1709: -- here's the delegated call to the old PL/SQL routine
1710: okl_am_parties_pvt.get_quote_party_contacts(p_api_version,
1711: p_init_msg_list,
1712: x_msg_count,
1713: x_msg_data,
1714: x_return_status,

Line 1726: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0

1722:
1723:
1724:
1725:
1726: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0
1727: , p6_a1
1728: , p6_a2
1729: , p6_a3
1730: , p6_a4

Line 1847: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;

1843: , p5_a35 DATE := fnd_api.g_miss_date
1844: )
1845:
1846: as
1847: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1848: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
1849: ddindx binary_integer; indx binary_integer;
1850: begin
1851:

Line 1848: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;

1844: )
1845:
1846: as
1847: ddp_q_party_uv_rec okl_am_parties_pvt.q_party_uv_rec_type;
1848: ddx_q_party_uv_tbl okl_am_parties_pvt.q_party_uv_tbl_type;
1849: ddindx binary_integer; indx binary_integer;
1850: begin
1851:
1852: -- copy data to the local IN or IN-OUT args, if any

Line 1898: okl_am_parties_pvt.get_quote_contact_points(p_api_version,

1894:
1895:
1896:
1897: -- here's the delegated call to the old PL/SQL routine
1898: okl_am_parties_pvt.get_quote_contact_points(p_api_version,
1899: p_init_msg_list,
1900: x_msg_count,
1901: x_msg_data,
1902: x_return_status,

Line 1914: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0

1910:
1911:
1912:
1913:
1914: okl_am_parties_pvt_w.rosetta_table_copy_out_p2(ddx_q_party_uv_tbl, p6_a0
1915: , p6_a1
1916: , p6_a2
1917: , p6_a3
1918: , p6_a4

Line 1954: end okl_am_parties_pvt_w;

1950: );
1951:
1952: end;
1953:
1954: end okl_am_parties_pvt_w;