DBA Data[Home] [Help]

APPS.AS_ACCESS_PUB dependencies on AS_ACCESS_PVT

Line 45: pvt_rec OUT NOCOPY AS_ACCESS_PVT.SALES_TEAM_REC_TYPE) IS

41: end;
42: */
43:
44: Procedure Convert_Pub_Sales_Team_To_Pvt(pub_rec IN AS_ACCESS_PUB.SALES_TEAM_REC_TYPE,
45: pvt_rec OUT NOCOPY AS_ACCESS_PVT.SALES_TEAM_REC_TYPE) IS
46: Begin
47:
48: pvt_rec.access_id := pub_rec.access_id;
49: pvt_rec.freeze_flag := pub_rec.freeze_flag;

Line 116: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;

112: x_access_id OUT NOCOPY NUMBER
113: ) is
114: l_api_name CONSTANT VARCHAR2(30) := 'Create_SalesTeam';
115: l_api_version_number CONSTANT NUMBER := 2.0;
116: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;
117: l_sales_team_rec sales_team_rec_type;
118: l_access_id number;
119: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Create_SalesTeam';
120: BEGIN

Line 152: AS_ACCESS_PVT.Create_SalesTeam

148: -- get_person_id(l_sales_team_rec.salesforce_id, l_pvt_sales_team_rec.person_id);
149:
150:
151:
152: AS_ACCESS_PVT.Create_SalesTeam
153: ( p_api_version_number => 2.0,
154: p_commit => p_commit,
155: p_validation_level => p_validation_level,
156: p_access_profile_rec => p_access_profile_rec,

Line 242: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;

238: x_access_id OUT NOCOPY NUMBER
239: ) is
240: l_api_name CONSTANT VARCHAR2(30) := 'Update_SalesTeam';
241: l_api_version_number CONSTANT NUMBER := 2.0;
242: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;
243: l_access_id number;
244: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Update_SalesTeam';
245: BEGIN
246: SAVEPOINT UPDATE_SALESTEAM_PUB;

Line 275: AS_ACCESS_PVT.Update_SalesTeam

271:
272: Convert_Pub_Sales_Team_To_Pvt(p_sales_team_rec, l_pvt_sales_team_rec);
273: -- get_person_id(p_sales_team_rec.salesforce_id, l_pvt_sales_team_rec.person_id);
274:
275: AS_ACCESS_PVT.Update_SalesTeam
276: ( p_api_version_number => 2.0,
277: p_commit => p_commit,
278: p_validation_level => p_validation_level,
279: p_access_profile_rec => p_access_profile_rec,

Line 391: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;

387: x_msg_data OUT NOCOPY VARCHAR2
388: ) is
389: l_api_name CONSTANT VARCHAR2(30) := 'Delete_SalesTeam';
390: l_api_version_number CONSTANT NUMBER := 2.0;
391: l_pvt_sales_team_rec AS_ACCESS_PVT.Sales_Team_Rec_Type;
392: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
393: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Delete_SalesTeam';
394:
395: begin

Line 430: 'Public API: Calling AS_ACCESS_PVT.delete_salesTeam');

426: --
427:
428: IF l_debug THEN
429: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
430: 'Public API: Calling AS_ACCESS_PVT.delete_salesTeam');
431: END IF;
432: Convert_Pub_Sales_Team_To_Pvt(p_sales_team_rec, l_pvt_sales_team_rec);
433:
434:

Line 436: as_access_pvt.Delete_SalesTeam

432: Convert_Pub_Sales_Team_To_Pvt(p_sales_team_rec, l_pvt_sales_team_rec);
433:
434:
435:
436: as_access_pvt.Delete_SalesTeam
437: (P_Api_Version_Number => 2.0,
438: P_Init_Msg_List => FND_API.G_FALSE,
439: P_Commit => FND_API.G_FALSE,
440: p_validation_level => P_Validation_Level,

Line 617: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');

613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: IF l_debug THEN
616: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
617: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
618: END IF;
619:
620:
621: as_access_pvt.has_viewCustomerAccess

Line 621: as_access_pvt.has_viewCustomerAccess

617: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
618: END IF;
619:
620:
621: as_access_pvt.has_viewCustomerAccess
622: (p_api_version_number => 2.0
623: ,p_init_msg_list => FND_API.G_FALSE
624: ,p_validation_level => p_validation_level
625: ,p_access_profile_rec => p_access_profile_rec

Line 759: 'Public API: Calling as_access_pvt.has_updateCustomerAccess');

755:
756:
757: IF l_debug THEN
758: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
759: 'Public API: Calling as_access_pvt.has_updateCustomerAccess');
760: END IF;
761:
762:
763: as_access_pvt.has_updateCustomerAccess

Line 763: as_access_pvt.has_updateCustomerAccess

759: 'Public API: Calling as_access_pvt.has_updateCustomerAccess');
760: END IF;
761:
762:
763: as_access_pvt.has_updateCustomerAccess
764: (p_api_version_number => 2.0
765: ,p_init_msg_list => FND_API.G_FALSE
766: ,p_validation_level => p_validation_level
767: ,p_access_profile_rec => p_access_profile_rec

Line 901: 'Public API: Calling as_access_pvt.has_updateLeadAccess');

897:
898:
899: IF l_debug THEN
900: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
901: 'Public API: Calling as_access_pvt.has_updateLeadAccess');
902: END IF;
903:
904:
905: as_access_pvt.has_updateLeadAccess

Line 905: as_access_pvt.has_updateLeadAccess

901: 'Public API: Calling as_access_pvt.has_updateLeadAccess');
902: END IF;
903:
904:
905: as_access_pvt.has_updateLeadAccess
906: (p_api_version_number => 2.0
907: ,p_init_msg_list => FND_API.G_FALSE
908: ,p_validation_level => p_validation_level
909: ,p_access_profile_rec => p_access_profile_rec

Line 1043: 'Public API: Calling as_access_pvt.has_updateOpportunityAccess');

1039:
1040:
1041: IF l_debug THEN
1042: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1043: 'Public API: Calling as_access_pvt.has_updateOpportunityAccess');
1044: END IF;
1045:
1046:
1047: as_access_pvt.has_updateOpportunityAccess

Line 1047: as_access_pvt.has_updateOpportunityAccess

1043: 'Public API: Calling as_access_pvt.has_updateOpportunityAccess');
1044: END IF;
1045:
1046:
1047: as_access_pvt.has_updateOpportunityAccess
1048: (p_api_version_number => 2.0
1049: ,p_init_msg_list => FND_API.G_FALSE
1050: ,p_validation_level => p_validation_level
1051: ,p_access_profile_rec => p_access_profile_rec

Line 1296: as_access_pvt.has_updateCustomerAccess

1292: x_update_access_flag := 'N';
1293: else
1294: if p_security_type = 'ORGANIZATION'
1295: then
1296: as_access_pvt.has_updateCustomerAccess
1297: (p_api_version_number => 2.0
1298: ,p_init_msg_list => FND_API.G_FALSE
1299: ,p_validation_level => p_validation_level
1300: ,p_access_profile_rec => p_access_profile_rec

Line 1320: as_access_pvt.has_updateOpportunityAccess

1316: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1317: end if;
1318: elsif p_security_type = 'OPPORTUNITY'
1319: then
1320: as_access_pvt.has_updateOpportunityAccess
1321: (p_api_version_number => 2.0
1322: ,p_init_msg_list => FND_API.G_FALSE
1323: ,p_validation_level => p_validation_level
1324: ,p_access_profile_rec => p_access_profile_rec

Line 1344: as_access_pvt.has_updateLeadAccess

1340: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1341: end if;
1342: elsif p_security_type = 'LEAD'
1343: then
1344: as_access_pvt.has_updateLeadAccess
1345: (p_api_version_number => 2.0
1346: ,p_init_msg_list => FND_API.G_FALSE
1347: ,p_validation_level => p_validation_level
1348: ,p_access_profile_rec => p_access_profile_rec

Line 1368: as_access_pvt.has_updateCustomerAccess

1364: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1365: end if;
1366: elsif p_security_type is null and p_security_id is null
1367: then
1368: as_access_pvt.has_updateCustomerAccess
1369: (p_api_version_number => 2.0
1370: ,p_init_msg_list => FND_API.G_FALSE
1371: ,p_validation_level => p_validation_level
1372: ,p_access_profile_rec => p_access_profile_rec

Line 1528: as_access_pvt.has_viewCustomerAccess

1524: x_view_access_flag := 'N';
1525: else
1526: if p_security_type = 'ORGANIZATION'
1527: then
1528: as_access_pvt.has_viewCustomerAccess
1529: (p_api_version_number => 2.0
1530: ,p_init_msg_list => FND_API.G_FALSE
1531: ,p_validation_level => p_validation_level
1532: ,p_access_profile_rec => p_access_profile_rec

Line 1552: as_access_pvt.has_viewOpportunityAccess

1548: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1549: end if;
1550: elsif p_security_type = 'OPPORTUNITY'
1551: then
1552: as_access_pvt.has_viewOpportunityAccess
1553: (p_api_version_number => 2.0
1554: ,p_init_msg_list => FND_API.G_FALSE
1555: ,p_validation_level => p_validation_level
1556: ,p_access_profile_rec => p_access_profile_rec

Line 1576: as_access_pvt.has_viewLeadAccess

1572: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1573: end if;
1574: elsif p_security_type = 'LEAD'
1575: then
1576: as_access_pvt.has_viewLeadAccess
1577: (p_api_version_number => 2.0
1578: ,p_init_msg_list => FND_API.G_FALSE
1579: ,p_validation_level => p_validation_level
1580: ,p_access_profile_rec => p_access_profile_rec

Line 1600: as_access_pvt.has_viewCustomerAccess

1596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
1597: end if;
1598: elsif p_security_type is null and p_security_id is null
1599: then
1600: as_access_pvt.has_viewCustomerAccess
1601: (p_api_version_number => 2.0
1602: ,p_init_msg_list => FND_API.G_FALSE
1603: ,p_validation_level => p_validation_level
1604: ,p_access_profile_rec => p_access_profile_rec

Line 1739: 'Public API: Calling as_access_pvt.has_viewLeadAccess');

1735:
1736:
1737: IF l_debug THEN
1738: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1739: 'Public API: Calling as_access_pvt.has_viewLeadAccess');
1740: END IF;
1741:
1742:
1743: as_access_pvt.has_viewLeadAccess

Line 1743: as_access_pvt.has_viewLeadAccess

1739: 'Public API: Calling as_access_pvt.has_viewLeadAccess');
1740: END IF;
1741:
1742:
1743: as_access_pvt.has_viewLeadAccess
1744: (p_api_version_number => 2.0
1745: ,p_init_msg_list => FND_API.G_FALSE
1746: ,p_validation_level => p_validation_level
1747: ,p_access_profile_rec => p_access_profile_rec

Line 1882: 'Public API: Calling as_access_pvt.has_viewOpportunityAccess');

1878:
1879:
1880: IF l_debug THEN
1881: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
1882: 'Public API: Calling as_access_pvt.has_viewOpportunityAccess');
1883: END IF;
1884:
1885:
1886: as_access_pvt.has_viewOpportunityAccess

Line 1886: as_access_pvt.has_viewOpportunityAccess

1882: 'Public API: Calling as_access_pvt.has_viewOpportunityAccess');
1883: END IF;
1884:
1885:
1886: as_access_pvt.has_viewOpportunityAccess
1887: (p_api_version_number => 2.0
1888: ,p_init_msg_list => FND_API.G_FALSE
1889: ,p_validation_level => p_validation_level
1890: ,p_access_profile_rec => p_access_profile_rec

Line 2030: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');

2026: x_return_status := FND_API.G_RET_STS_SUCCESS;
2027:
2028: IF l_debug THEN
2029: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2030: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2031: END IF;
2032:
2033: x_access_privilege := 'N';
2034: as_access_pvt.has_viewCustomerAccess

Line 2034: as_access_pvt.has_viewCustomerAccess

2030: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2031: END IF;
2032:
2033: x_access_privilege := 'N';
2034: as_access_pvt.has_viewCustomerAccess
2035: (p_api_version_number => 2.0
2036: ,p_init_msg_list => FND_API.G_FALSE
2037: ,p_validation_level => p_validation_level
2038: ,p_access_profile_rec => p_access_profile_rec

Line 2060: as_access_pvt.has_updateCustomerAccess

2056:
2057: if l_view_access_flag = 'Y'
2058: then
2059: x_access_privilege := 'R';
2060: as_access_pvt.has_updateCustomerAccess
2061: (p_api_version_number => 2.0
2062: ,p_init_msg_list => FND_API.G_FALSE
2063: ,p_validation_level => p_validation_level
2064: ,p_access_profile_rec => p_access_profile_rec

Line 2204: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');

2200: x_return_status := FND_API.G_RET_STS_SUCCESS;
2201:
2202: IF l_debug THEN
2203: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2204: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2205: END IF;
2206:
2207: x_access_privilege := 'N';
2208: as_access_pvt.has_viewOpportunityAccess

Line 2208: as_access_pvt.has_viewOpportunityAccess

2204: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2205: END IF;
2206:
2207: x_access_privilege := 'N';
2208: as_access_pvt.has_viewOpportunityAccess
2209: (p_api_version_number => 2.0
2210: ,p_init_msg_list => FND_API.G_FALSE
2211: ,p_validation_level => p_validation_level
2212: ,p_access_profile_rec => p_access_profile_rec

Line 2234: as_access_pvt.has_updateOpportunityAccess

2230:
2231: if l_view_access_flag = 'Y'
2232: then
2233: x_access_privilege := 'R';
2234: as_access_pvt.has_updateOpportunityAccess
2235: (p_api_version_number => 2.0
2236: ,p_init_msg_list => FND_API.G_FALSE
2237: ,p_validation_level => p_validation_level
2238: ,p_access_profile_rec => p_access_profile_rec

Line 2378: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');

2374: x_return_status := FND_API.G_RET_STS_SUCCESS;
2375:
2376: IF l_debug THEN
2377: AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
2378: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2379: END IF;
2380:
2381: x_access_privilege := 'N';
2382: as_access_pvt.has_viewLeadAccess

Line 2382: as_access_pvt.has_viewLeadAccess

2378: 'Public API: Calling as_access_pvt.has_viewCustomerAccess');
2379: END IF;
2380:
2381: x_access_privilege := 'N';
2382: as_access_pvt.has_viewLeadAccess
2383: (p_api_version_number => 2.0
2384: ,p_init_msg_list => FND_API.G_FALSE
2385: ,p_validation_level => p_validation_level
2386: ,p_access_profile_rec => p_access_profile_rec

Line 2408: as_access_pvt.has_updateLeadAccess

2404:
2405: if l_view_access_flag = 'Y'
2406: then
2407: x_access_privilege := 'R';
2408: as_access_pvt.has_updateLeadAccess
2409: (p_api_version_number => 2.0
2410: ,p_init_msg_list => FND_API.G_FALSE
2411: ,p_validation_level => p_validation_level
2412: ,p_access_profile_rec => p_access_profile_rec