DBA Data[Home] [Help]

APPS.AS_ACCESS_PUB_W dependencies on AS_ACCESS_PUB

Line 1: package body as_access_pub_w as

1: package body as_access_pub_w as
2: /* $Header: asxwacsb.pls 120.1 2005/07/29 05:37 appldev ship $ */
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 as_access_pub.sales_team_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 as_access_pub.sales_team_tbl_type, a0 JTF_NUMBER_TABLE
23: , a1 JTF_DATE_TABLE
24: , a2 JTF_NUMBER_TABLE
25: , a3 JTF_DATE_TABLE
26: , a4 JTF_NUMBER_TABLE

Line 159: procedure rosetta_table_copy_out_p2(t as_access_pub.sales_team_tbl_type, a0 out nocopy JTF_NUMBER_TABLE

155: end loop;
156: end if;
157: end if;
158: end rosetta_table_copy_in_p2;
159: procedure rosetta_table_copy_out_p2(t as_access_pub.sales_team_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
160: , a1 out nocopy JTF_DATE_TABLE
161: , a2 out nocopy JTF_NUMBER_TABLE
162: , a3 out nocopy JTF_DATE_TABLE
163: , a4 out nocopy JTF_NUMBER_TABLE

Line 558: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

554: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
555: )
556:
557: as
558: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
559: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
560: ddindx binary_integer; indx binary_integer;
561: begin
562:

Line 559: ddp_sales_team_rec as_access_pub.sales_team_rec_type;

555: )
556:
557: as
558: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
559: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
560: ddindx binary_integer; indx binary_integer;
561: begin
562:
563: -- copy data to the local IN or IN-OUT args, if any

Line 644: as_access_pub.create_salesteam(p_api_version_number,

640:
641:
642:
643: -- here's the delegated call to the old PL/SQL routine
644: as_access_pub.create_salesteam(p_api_version_number,
645: p_init_msg_list,
646: p_commit,
647: p_validation_level,
648: ddp_access_profile_rec,

Line 755: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

751: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
752: )
753:
754: as
755: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
756: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
757: ddindx binary_integer; indx binary_integer;
758: begin
759:

Line 756: ddp_sales_team_rec as_access_pub.sales_team_rec_type;

752: )
753:
754: as
755: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
756: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
757: ddindx binary_integer; indx binary_integer;
758: begin
759:
760: -- copy data to the local IN or IN-OUT args, if any

Line 841: as_access_pub.update_salesteam(p_api_version_number,

837:
838:
839:
840: -- here's the delegated call to the old PL/SQL routine
841: as_access_pub.update_salesteam(p_api_version_number,
842: p_init_msg_list,
843: p_commit,
844: p_validation_level,
845: ddp_access_profile_rec,

Line 951: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

947: , p9_a59 VARCHAR2 := fnd_api.g_miss_char
948: )
949:
950: as
951: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
952: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:

Line 952: ddp_sales_team_rec as_access_pub.sales_team_rec_type;

948: )
949:
950: as
951: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
952: ddp_sales_team_rec as_access_pub.sales_team_rec_type;
953: ddindx binary_integer; indx binary_integer;
954: begin
955:
956: -- copy data to the local IN or IN-OUT args, if any

Line 1036: as_access_pub.delete_salesteam(p_api_version_number,

1032:
1033:
1034:
1035: -- here's the delegated call to the old PL/SQL routine
1036: as_access_pub.delete_salesteam(p_api_version_number,
1037: p_init_msg_list,
1038: p_commit,
1039: p_validation_level,
1040: ddp_access_profile_rec,

Line 1077: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1073: , p1_a4 VARCHAR2 := fnd_api.g_miss_char
1074: )
1075:
1076: as
1077: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1078: ddindx binary_integer; indx binary_integer;
1079: begin
1080:
1081: -- copy data to the local IN or IN-OUT args, if any

Line 1093: as_access_pub.validate_accessprofiles(p_init_msg_list,

1089:
1090:
1091:
1092: -- here's the delegated call to the old PL/SQL routine
1093: as_access_pub.validate_accessprofiles(p_init_msg_list,
1094: ddp_access_profile_rec,
1095: x_return_status,
1096: x_msg_count,
1097: x_msg_data);

Line 1128: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1124: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1125: )
1126:
1127: as
1128: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1129: ddindx binary_integer; indx binary_integer;
1130: begin
1131:
1132: -- copy data to the local IN or IN-OUT args, if any

Line 1154: as_access_pub.has_viewcustomeraccess(p_api_version_number,

1150:
1151:
1152:
1153: -- here's the delegated call to the old PL/SQL routine
1154: as_access_pub.has_viewcustomeraccess(p_api_version_number,
1155: p_init_msg_list,
1156: p_validation_level,
1157: ddp_access_profile_rec,
1158: p_admin_flag,

Line 1209: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1205: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1206: )
1207:
1208: as
1209: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1210: ddindx binary_integer; indx binary_integer;
1211: begin
1212:
1213: -- copy data to the local IN or IN-OUT args, if any

Line 1235: as_access_pub.has_updatecustomeraccess(p_api_version_number,

1231:
1232:
1233:
1234: -- here's the delegated call to the old PL/SQL routine
1235: as_access_pub.has_updatecustomeraccess(p_api_version_number,
1236: p_init_msg_list,
1237: p_validation_level,
1238: ddp_access_profile_rec,
1239: p_admin_flag,

Line 1290: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1286: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1287: )
1288:
1289: as
1290: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1291: ddindx binary_integer; indx binary_integer;
1292: begin
1293:
1294: -- copy data to the local IN or IN-OUT args, if any

Line 1316: as_access_pub.has_updateleadaccess(p_api_version_number,

1312:
1313:
1314:
1315: -- here's the delegated call to the old PL/SQL routine
1316: as_access_pub.has_updateleadaccess(p_api_version_number,
1317: p_init_msg_list,
1318: p_validation_level,
1319: ddp_access_profile_rec,
1320: p_admin_flag,

Line 1371: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1367: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1368: )
1369:
1370: as
1371: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1372: ddindx binary_integer; indx binary_integer;
1373: begin
1374:
1375: -- copy data to the local IN or IN-OUT args, if any

Line 1397: as_access_pub.has_updateopportunityaccess(p_api_version_number,

1393:
1394:
1395:
1396: -- here's the delegated call to the old PL/SQL routine
1397: as_access_pub.has_updateopportunityaccess(p_api_version_number,
1398: p_init_msg_list,
1399: p_validation_level,
1400: ddp_access_profile_rec,
1401: p_admin_flag,

Line 1454: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1450: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1451: )
1452:
1453: as
1454: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1455: ddindx binary_integer; indx binary_integer;
1456: begin
1457:
1458: -- copy data to the local IN or IN-OUT args, if any

Line 1482: as_access_pub.has_updatepersonaccess(p_api_version_number,

1478:
1479:
1480:
1481: -- here's the delegated call to the old PL/SQL routine
1482: as_access_pub.has_updatepersonaccess(p_api_version_number,
1483: p_init_msg_list,
1484: p_validation_level,
1485: ddp_access_profile_rec,
1486: p_admin_flag,

Line 1543: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1539: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1540: )
1541:
1542: as
1543: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1544: ddindx binary_integer; indx binary_integer;
1545: begin
1546:
1547: -- copy data to the local IN or IN-OUT args, if any

Line 1571: as_access_pub.has_viewpersonaccess(p_api_version_number,

1567:
1568:
1569:
1570: -- here's the delegated call to the old PL/SQL routine
1571: as_access_pub.has_viewpersonaccess(p_api_version_number,
1572: p_init_msg_list,
1573: p_validation_level,
1574: ddp_access_profile_rec,
1575: p_admin_flag,

Line 1630: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1626: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1627: )
1628:
1629: as
1630: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1631: ddindx binary_integer; indx binary_integer;
1632: begin
1633:
1634: -- copy data to the local IN or IN-OUT args, if any

Line 1656: as_access_pub.has_viewleadaccess(p_api_version_number,

1652:
1653:
1654:
1655: -- here's the delegated call to the old PL/SQL routine
1656: as_access_pub.has_viewleadaccess(p_api_version_number,
1657: p_init_msg_list,
1658: p_validation_level,
1659: ddp_access_profile_rec,
1660: p_admin_flag,

Line 1711: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1707: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1708: )
1709:
1710: as
1711: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1712: ddindx binary_integer; indx binary_integer;
1713: begin
1714:
1715: -- copy data to the local IN or IN-OUT args, if any

Line 1737: as_access_pub.has_viewopportunityaccess(p_api_version_number,

1733:
1734:
1735:
1736: -- here's the delegated call to the old PL/SQL routine
1737: as_access_pub.has_viewopportunityaccess(p_api_version_number,
1738: p_init_msg_list,
1739: p_validation_level,
1740: ddp_access_profile_rec,
1741: p_admin_flag,

Line 1792: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1788: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1789: )
1790:
1791: as
1792: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1793: ddindx binary_integer; indx binary_integer;
1794: begin
1795:
1796: -- copy data to the local IN or IN-OUT args, if any

Line 1818: as_access_pub.has_organizationaccess(p_api_version_number,

1814:
1815:
1816:
1817: -- here's the delegated call to the old PL/SQL routine
1818: as_access_pub.has_organizationaccess(p_api_version_number,
1819: p_init_msg_list,
1820: p_validation_level,
1821: ddp_access_profile_rec,
1822: p_admin_flag,

Line 1875: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1871: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1872: )
1873:
1874: as
1875: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1876: ddindx binary_integer; indx binary_integer;
1877: begin
1878:
1879: -- copy data to the local IN or IN-OUT args, if any

Line 1903: as_access_pub.has_personaccess(p_api_version_number,

1899:
1900:
1901:
1902: -- here's the delegated call to the old PL/SQL routine
1903: as_access_pub.has_personaccess(p_api_version_number,
1904: p_init_msg_list,
1905: p_validation_level,
1906: ddp_access_profile_rec,
1907: p_admin_flag,

Line 1962: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

1958: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
1959: )
1960:
1961: as
1962: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
1963: ddindx binary_integer; indx binary_integer;
1964: begin
1965:
1966: -- copy data to the local IN or IN-OUT args, if any

Line 1988: as_access_pub.has_leadaccess(p_api_version_number,

1984:
1985:
1986:
1987: -- here's the delegated call to the old PL/SQL routine
1988: as_access_pub.has_leadaccess(p_api_version_number,
1989: p_init_msg_list,
1990: p_validation_level,
1991: ddp_access_profile_rec,
1992: p_admin_flag,

Line 2043: ddp_access_profile_rec as_access_pub.access_profile_rec_type;

2039: , p3_a4 VARCHAR2 := fnd_api.g_miss_char
2040: )
2041:
2042: as
2043: ddp_access_profile_rec as_access_pub.access_profile_rec_type;
2044: ddindx binary_integer; indx binary_integer;
2045: begin
2046:
2047: -- copy data to the local IN or IN-OUT args, if any

Line 2069: as_access_pub.has_opportunityaccess(p_api_version_number,

2065:
2066:
2067:
2068: -- here's the delegated call to the old PL/SQL routine
2069: as_access_pub.has_opportunityaccess(p_api_version_number,
2070: p_init_msg_list,
2071: p_validation_level,
2072: ddp_access_profile_rec,
2073: p_admin_flag,

Line 2102: end as_access_pub_w;

2098:
2099:
2100: end;
2101:
2102: end as_access_pub_w;