DBA Data[Home] [Help]

APPS.AS_OPPORTUNITY_PUB dependencies on AS_ACCESS_PUB

Line 4686: p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,

4682: ( p_api_version_number IN NUMBER,
4683: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4684: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
4685: p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
4686: p_sales_team_tbl IN AS_ACCESS_PUB.SALES_TEAM_TBL_TYPE,
4687: p_check_access_flag IN VARCHAR2,
4688: p_admin_flag IN VARCHAR2,
4689: p_admin_group_id IN NUMBER,
4690: p_identity_salesforce_id IN NUMBER,

Line 4728: l_sales_team_rec AS_ACCESS_PUB.Sales_Team_Rec_Type;

4724: l_sales_group_id NUMBER;
4725: l_person_name VARCHAR2(65);
4726: l_api_name CONSTANT VARCHAR2(30) := 'Delete_SalesTeams';
4727: l_api_version_number CONSTANT NUMBER := 2.0;
4728: l_sales_team_rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
4729: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4730: l_line_count CONSTANT NUMBER := p_sales_team_tbl.count;
4731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_SalesTeams';

Line 4729: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;

4725: l_person_name VARCHAR2(65);
4726: l_api_name CONSTANT VARCHAR2(30) := 'Delete_SalesTeams';
4727: l_api_version_number CONSTANT NUMBER := 2.0;
4728: l_sales_team_rec AS_ACCESS_PUB.Sales_Team_Rec_Type;
4729: l_access_profile_rec AS_ACCESS_PUB.Access_Profile_Rec_Type;
4730: l_line_count CONSTANT NUMBER := p_sales_team_tbl.count;
4731: l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
4732: l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_SalesTeams';
4733: BEGIN

Line 4776: -- AS_ACCESS_PUB.Delete_SalesTeam handles single records.

4772: --
4773: -- API body
4774: --
4775:
4776: -- AS_ACCESS_PUB.Delete_SalesTeam handles single records.
4777: -- This procedure needs to be able to handle tables.
4778: FOR l_curr_row IN 1..l_line_count LOOP
4779:
4780: -- Check whether the Sales Person has Sales Credit

Line 4806: -- Call the AS_ACCESS_PUB.Delete_SalesTeam API

4802: OPEN C_SalesCredit_Exist (l_salesforce_id,l_lead_id, l_sales_group_id);
4803: FETCH C_SalesCredit_Exist INTO l_sales_credit_id;
4804:
4805: IF C_SalesCredit_Exist%NOTFOUND THEN
4806: -- Call the AS_ACCESS_PUB.Delete_SalesTeam API
4807: AS_ACCESS_PUB.Delete_SalesTeam(
4808: p_api_version_number => l_api_version_number,
4809: p_init_msg_list => FND_API.G_FALSE,
4810: p_commit => p_commit,

Line 4807: AS_ACCESS_PUB.Delete_SalesTeam(

4803: FETCH C_SalesCredit_Exist INTO l_sales_credit_id;
4804:
4805: IF C_SalesCredit_Exist%NOTFOUND THEN
4806: -- Call the AS_ACCESS_PUB.Delete_SalesTeam API
4807: AS_ACCESS_PUB.Delete_SalesTeam(
4808: p_api_version_number => l_api_version_number,
4809: p_init_msg_list => FND_API.G_FALSE,
4810: p_commit => p_commit,
4811: p_validation_level => p_validation_level,

Line 5115: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type

5111:
5112:
5113: PROCEDURE Get_Access_Profiles(
5114: p_profile_tbl IN AS_UTILITY_PUB.Profile_Tbl_Type,
5115: x_access_profile_rec OUT NOCOPY AS_ACCESS_PUB.Access_Profile_Rec_Type
5116: )
5117:
5118: IS
5119: