eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_ACCESS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 21


	select employee_person_id
	from as_salesforce
	where salesforce_id = p_salesforce_id;

Line: 80


   pvt_rec.last_update_date	:= pub_rec.last_update_date;

Line: 81


   pvt_rec.last_updated_by	:= pub_rec.last_updated_by;

Line: 84


   pvt_rec.last_update_login    := pub_rec.last_update_login;

Line: 221


PROCEDURE Update_SalesTeam
(       p_api_version_number              IN      NUMBER,
        p_init_msg_list                 IN      VARCHAR2
                                                DEFAULT  FND_API.G_FALSE,
        p_commit                        IN      VARCHAR2
                                                DEFAULT  FND_API.G_FALSE,
	p_validation_level		IN	NUMBER
						DEFAULT  FND_API.G_VALID_LEVEL_FULL,
        p_access_profile_rec	IN access_profile_rec_type,
	p_check_access_flag             IN      VARCHAR2,
	   p_admin_flag                    IN      VARCHAR2,
	   p_admin_group_id                IN      NUMBER,
	   p_identity_salesforce_id        IN      NUMBER,
        p_sales_team_rec                IN      SALES_TEAM_REC_TYPE,
        x_return_status                 OUT NOCOPY     VARCHAR2,
        x_msg_count                     OUT NOCOPY     NUMBER,
        x_msg_data                      OUT NOCOPY     VARCHAR2,
        x_access_id                     OUT NOCOPY     NUMBER
) is
  l_api_name            CONSTANT VARCHAR2(30) := 'Update_SalesTeam';

Line: 244


  l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Update_SalesTeam';

Line: 246


	SAVEPOINT UPDATE_SALESTEAM_PUB;

Line: 275


       AS_ACCESS_PVT.Update_SalesTeam
       (       p_api_version_number    =>  2.0,
	      p_commit                =>  p_commit,
            p_validation_level      =>  p_validation_level,
	    p_access_profile_rec	  =>  p_access_profile_rec,
            p_check_access_flag     =>  p_check_access_flag,
	       p_admin_flag            =>  p_admin_flag,
	       p_admin_group_id        =>  p_admin_group_id,
	       p_identity_salesforce_id => p_identity_salesforce_id,
            p_sales_team_rec        =>  l_pvt_sales_team_rec,
            x_return_status         =>  x_return_status,
            x_msg_count             =>  x_msg_count,
            x_msg_data              =>  x_msg_data,
            x_access_id             =>  x_access_id
       );

Line: 337


END Update_SalesTeam;

Line: 371


PROCEDURE Delete_SalesTeam
(       p_api_version_number          	IN      NUMBER,
        p_init_msg_list                 IN      VARCHAR2
                                                DEFAULT  FND_API.G_FALSE,
        p_commit                        IN      VARCHAR2
                                                DEFAULT  FND_API.G_FALSE,
	p_validation_level		IN	NUMBER
						DEFAULT  FND_API.G_VALID_LEVEL_FULL,
	p_access_profile_rec	IN access_profile_rec_type,
        p_check_access_flag             IN      VARCHAR2,
	   p_admin_flag                    IN      VARCHAR2,
	   p_admin_group_id                IN      NUMBER,
	   p_identity_salesforce_id        IN      NUMBER,
        p_sales_team_rec                IN      SALES_TEAM_REC_TYPE,
        x_return_status                 OUT NOCOPY     VARCHAR2,
        x_msg_count                     OUT NOCOPY     NUMBER,
        x_msg_data                      OUT NOCOPY     VARCHAR2
) is
 l_api_name            CONSTANT VARCHAR2(30) := 'Delete_SalesTeam';

Line: 393


 l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.Delete_SalesTeam';

Line: 396


	SAVEPOINT DELETE_SALESTEAM_PUB;

Line: 430


                   'Public API: Calling AS_ACCESS_PVT.delete_salesTeam');

Line: 436


       as_access_pvt.Delete_SalesTeam
		(P_Api_Version_Number         => 2.0,
		P_Init_Msg_List              => FND_API.G_FALSE,
		P_Commit                     => FND_API.G_FALSE,
		p_validation_level	     => P_Validation_Level,
		p_access_profile_rec	  =>  p_access_profile_rec,
		p_check_access_flag          => p_check_access_flag,
		 p_admin_flag                => p_admin_flag,
		p_admin_group_id             => p_admin_group_id,
		p_identity_salesforce_id     => p_identity_salesforce_id,
		p_sales_team_rec             => l_pvt_sales_team_rec,
		x_return_status              => x_return_status,
		x_msg_count                  => x_msg_count,
		x_msg_data                   => x_msg_data
		);

Line: 520


End delete_salesteam;

Line: 706


procedure has_updateCustomerAccess
(	p_api_version_number	IN NUMBER
	,p_init_msg_list        IN VARCHAR2	DEFAULT  FND_API.G_FALSE
	,p_validation_level	IN NUMBER	DEFAULT  FND_API.G_VALID_LEVEL_FULL
	,p_access_profile_rec	IN access_profile_rec_type
	,p_admin_flag		IN VARCHAR2
	,p_admin_group_id	IN NUMBER
	,p_person_id		IN NUMBER
	,p_customer_id		IN NUMBER
	,p_check_access_flag       IN VARCHAR2
	,p_identity_salesforce_id  IN NUMBER
	,p_partner_cont_party_id   IN NUMBER
	,x_return_status	OUT NOCOPY VARCHAR2
	,x_msg_count		OUT NOCOPY NUMBER
	,x_msg_data		OUT NOCOPY VARCHAR2
	,x_update_access_flag	OUT NOCOPY VARCHAR2
)is
l_api_name            CONSTANT VARCHAR2(30) := 'has_updateCustomerAccess';

Line: 726


l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateCustomerAccess';

Line: 759


                   'Public API: Calling as_access_pvt.has_updateCustomerAccess');

Line: 763


	as_access_pvt.has_updateCustomerAccess
	(p_api_version_number	=> 2.0
	,p_init_msg_list        => FND_API.G_FALSE
	,p_validation_level	=> p_validation_level
	,p_access_profile_rec	=> p_access_profile_rec
	,p_admin_flag		=> p_admin_flag
	,p_admin_group_id	=> p_admin_group_id
	,p_person_id		=> p_person_id
	,p_customer_id		=> p_customer_id
	,p_check_access_flag    => p_check_access_flag
	,p_identity_salesforce_id =>p_identity_salesforce_id
	,p_partner_cont_party_id  =>p_partner_cont_party_id
	,x_return_status	  =>x_return_status
	,x_msg_count		=> x_msg_count
	,x_msg_data		=> x_msg_data
	,x_update_access_flag	=> x_update_access_flag);

Line: 846


end  has_updateCustomerAccess;

Line: 848


procedure has_updateLeadAccess
(	p_api_version_number	IN NUMBER
	,p_init_msg_list        IN VARCHAR2	DEFAULT  FND_API.G_FALSE
	,p_validation_level	IN NUMBER	DEFAULT  FND_API.G_VALID_LEVEL_FULL
	,p_access_profile_rec	IN access_profile_rec_type
	,p_admin_flag		IN VARCHAR2
	,p_admin_group_id	IN NUMBER
	,p_person_id		IN NUMBER
	,p_sales_lead_id		IN NUMBER
	,p_check_access_flag       IN VARCHAR2
	,p_identity_salesforce_id  IN NUMBER
	,p_partner_cont_party_id   IN NUMBER
	,x_return_status	OUT NOCOPY VARCHAR2
	,x_msg_count		OUT NOCOPY NUMBER
	,x_msg_data		OUT NOCOPY VARCHAR2
	,x_update_access_flag	OUT NOCOPY VARCHAR2
) is
l_api_name            CONSTANT VARCHAR2(30) := 'has_updateLeadAccess';

Line: 868


l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateLeadAccess';

Line: 901


                   'Public API: Calling as_access_pvt.has_updateLeadAccess');

Line: 905


	as_access_pvt.has_updateLeadAccess
	(p_api_version_number	=> 2.0
	,p_init_msg_list        => FND_API.G_FALSE
	,p_validation_level	=> p_validation_level
	,p_access_profile_rec	=> p_access_profile_rec
	,p_admin_flag		=> p_admin_flag
	,p_admin_group_id	=> p_admin_group_id
	,p_person_id		=> p_person_id
	,p_sales_lead_id	=> p_sales_lead_id
	,p_check_access_flag    => p_check_access_flag
	,p_identity_salesforce_id =>p_identity_salesforce_id
	,p_partner_cont_party_id  =>p_partner_cont_party_id
	,x_return_status	  =>x_return_status
	,x_msg_count		=> x_msg_count
	,x_msg_data		=> x_msg_data
	,x_update_access_flag	=> x_update_access_flag);

Line: 987


end has_updateLeadAccess;

Line: 989


procedure has_updateOpportunityAccess
(	p_api_version_number	IN NUMBER
	,p_init_msg_list        IN VARCHAR2	DEFAULT  FND_API.G_FALSE
	,p_validation_level	IN NUMBER	DEFAULT  FND_API.G_VALID_LEVEL_FULL
	,p_access_profile_rec	IN access_profile_rec_type
	,p_admin_flag		IN VARCHAR2
	,p_admin_group_id	IN NUMBER
	,p_person_id		IN NUMBER
	,p_opportunity_id	IN NUMBER
	,p_check_access_flag       IN VARCHAR2
	,p_identity_salesforce_id  IN NUMBER
	,p_partner_cont_party_id   IN NUMBER
	,x_return_status	OUT NOCOPY VARCHAR2
	,x_msg_count		OUT NOCOPY NUMBER
	,x_msg_data		OUT NOCOPY VARCHAR2
	,x_update_access_flag	OUT NOCOPY VARCHAR2
) is
l_api_name            CONSTANT VARCHAR2(30) := 'has_updateOpportunityAccess';

Line: 1009


l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updateOpportunityAccess';

Line: 1043


                   'Public API: Calling as_access_pvt.has_updateOpportunityAccess');

Line: 1047


	as_access_pvt.has_updateOpportunityAccess
	(p_api_version_number	=> 2.0
	,p_init_msg_list        => FND_API.G_FALSE
	,p_validation_level	=> p_validation_level
	,p_access_profile_rec	=> p_access_profile_rec
	,p_admin_flag		=> p_admin_flag
	,p_admin_group_id	=> p_admin_group_id
	,p_person_id		=> p_person_id
	,p_opportunity_id	=> p_opportunity_id
	,p_check_access_flag    => p_check_access_flag
	,p_identity_salesforce_id =>p_identity_salesforce_id
	,p_partner_cont_party_id  =>p_partner_cont_party_id
	,x_return_status	  =>x_return_status
	,x_msg_count		=> x_msg_count
	,x_msg_data		=> x_msg_data
	,x_update_access_flag	=> x_update_access_flag);

Line: 1129


end has_updateOpportunityAccess;

Line: 1137


		select 'x'
		from hz_relationships
		where subject_id = p_person_party_id
		 and object_id = p_security_id
		 and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
		 AND   OBJECT_TABLE_NAME = 'HZ_PARTIES';

Line: 1145


		select 'x'
		from as_lead_contacts cont,
		     hz_relationships rel
		where cont.contact_party_id = rel.party_id
		  and rel.subject_id = p_person_party_id
		  and cont.lead_id = p_security_id
		and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
		 AND   OBJECT_TABLE_NAME = 'HZ_PARTIES';

Line: 1154


		select 'x'
		from as_sales_lead_contacts cont,
		     hz_relationships rel
		where cont.contact_party_id = rel.party_id
		  and rel.subject_id = p_person_party_id
		  and cont.sales_lead_id = p_security_id
		and SUBJECT_TABLE_NAME = 'HZ_PARTIES'
		 AND   OBJECT_TABLE_NAME = 'HZ_PARTIES';

Line: 1211


has_updatePersonAccess:
p_security_id is the id which has relationship to the p_person_party_id.
For example, to check access for contact person(1000) of opportunity (2222),
you need to pass in p_security_id = 2222, p_security_type = 'OPPORTUNITY'
and p_person_party_id = 1000
values allowed for p_security_id are org party_id, opportunity_id,sales_lead_id
and null.
p_security_type allowed are 'ORGANIZATION', 'OPPORTUNITY','LEAD' and null
p_person_party_id is person's party id. This id is required to check person's
update access. To check consumer access, you can pass in null for
p_security_id and p_security_type */
procedure has_updatePersonAccess
(	p_api_version_number	IN NUMBER
	,p_init_msg_list        IN VARCHAR2	DEFAULT  FND_API.G_FALSE
	,p_validation_level	IN NUMBER	DEFAULT  FND_API.G_VALID_LEVEL_FULL
	,p_access_profile_rec	IN access_profile_rec_type
	,p_admin_flag		IN VARCHAR2
	,p_admin_group_id	IN NUMBER
	,p_person_id		IN NUMBER
	,p_security_id		IN NUMBER
        ,p_security_type        IN VARCHAR2
        ,p_person_party_id      IN NUMBER
	,p_check_access_flag      IN VARCHAR2
	,p_identity_salesforce_id IN NUMBER
	,p_partner_cont_party_id  IN NUMBER
	,x_return_status	OUT NOCOPY VARCHAR2
	,x_msg_count		OUT NOCOPY NUMBER
	,x_msg_data		OUT NOCOPY VARCHAR2
	,x_update_access_flag	OUT NOCOPY VARCHAR2
) is
l_api_name            CONSTANT VARCHAR2(30) := 'has_updatePersonAccess';

Line: 1245


l_module CONSTANT VARCHAR2(255) := 'as.plsql.acpub.has_updatePersonAccess';

Line: 1281


      x_update_access_flag := 'N';

Line: 1292


		x_update_access_flag := 'N';

Line: 1296


			as_access_pvt.has_updateCustomerAccess
			(p_api_version_number	=> 2.0
			,p_init_msg_list        => FND_API.G_FALSE
			,p_validation_level	=> p_validation_level
			,p_access_profile_rec	=> p_access_profile_rec
			,p_admin_flag		=> p_admin_flag
			,p_admin_group_id	=> p_admin_group_id
			,p_person_id		=> p_person_id
			,p_customer_id   	=> p_security_id
			,p_check_access_flag    => p_check_access_flag
			,p_identity_salesforce_id =>p_identity_salesforce_id
			,p_partner_cont_party_id  =>p_partner_cont_party_id
			,x_return_status	  =>x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,x_update_access_flag	=> x_update_access_flag);

Line: 1320


			as_access_pvt.has_updateOpportunityAccess
			(p_api_version_number	=> 2.0
			,p_init_msg_list        => FND_API.G_FALSE
			,p_validation_level	=> p_validation_level
			,p_access_profile_rec	=> p_access_profile_rec
			,p_admin_flag		=> p_admin_flag
			,p_admin_group_id	=> p_admin_group_id
			,p_person_id		=> p_person_id
			,p_opportunity_id   	=> p_security_id
			,p_check_access_flag    => p_check_access_flag
			,p_identity_salesforce_id =>p_identity_salesforce_id
			,p_partner_cont_party_id  =>p_partner_cont_party_id
			,x_return_status	  =>x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,x_update_access_flag	=> x_update_access_flag);

Line: 1344


			as_access_pvt.has_updateLeadAccess
			(p_api_version_number	=> 2.0
			,p_init_msg_list        => FND_API.G_FALSE
			,p_validation_level	=> p_validation_level
			,p_access_profile_rec	=> p_access_profile_rec
			,p_admin_flag		=> p_admin_flag
			,p_admin_group_id	=> p_admin_group_id
			,p_person_id		=> p_person_id
			,p_sales_lead_id   	=> p_security_id
			,p_check_access_flag    => p_check_access_flag
			,p_identity_salesforce_id =>p_identity_salesforce_id
			,p_partner_cont_party_id  =>p_partner_cont_party_id
			,x_return_status	  =>x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,x_update_access_flag	=> x_update_access_flag);

Line: 1368


			as_access_pvt.has_updateCustomerAccess
			(p_api_version_number	=> 2.0
			,p_init_msg_list        => FND_API.G_FALSE
			,p_validation_level	=> p_validation_level
			,p_access_profile_rec	=> p_access_profile_rec
			,p_admin_flag		=> p_admin_flag
			,p_admin_group_id	=> p_admin_group_id
			,p_person_id		=> p_person_id
			,p_customer_id   	=> p_person_party_id
			,p_check_access_flag    => p_check_access_flag
			,p_identity_salesforce_id =>p_identity_salesforce_id
			,p_partner_cont_party_id  =>p_partner_cont_party_id
			,x_return_status	  =>x_return_status
			,x_msg_count		=> x_msg_count
			,x_msg_data		=> x_msg_data
			,x_update_access_flag	=> x_update_access_flag);

Line: 1451


end has_updatePersonAccess;

Line: 1973


three values: 'N'(no access), 'R'(read only access) and 'F'(read/update access)
*/

procedure has_organizationAccess
(	p_api_version_number	IN NUMBER
	,p_init_msg_list        IN VARCHAR2	DEFAULT  FND_API.G_FALSE
	,p_validation_level	IN NUMBER	DEFAULT  FND_API.G_VALID_LEVEL_FULL
	,p_access_profile_rec	IN access_profile_rec_type
	,p_admin_flag		IN VARCHAR2
	,p_admin_group_id	IN NUMBER
	,p_person_id		IN NUMBER
	,p_customer_id		IN NUMBER
	,p_check_access_flag      IN VARCHAR2
	,p_identity_salesforce_id IN NUMBER
	,p_partner_cont_party_id  IN NUMBER
	,x_return_status	OUT NOCOPY VARCHAR2
	,x_msg_count		OUT NOCOPY NUMBER
	,x_msg_data		OUT NOCOPY VARCHAR2
	,x_access_privilege	OUT NOCOPY VARCHAR2
) is
l_api_name            CONSTANT VARCHAR2(30) := 'has_organizationAccess';

Line: 1996


l_update_access_flag varchar2(1);

Line: 2060


		as_access_pvt.has_updateCustomerAccess
		(p_api_version_number	=> 2.0
		,p_init_msg_list        => FND_API.G_FALSE
		,p_validation_level	=> p_validation_level
		,p_access_profile_rec	=> p_access_profile_rec
		,p_admin_flag		=> p_admin_flag
		,p_admin_group_id	=> p_admin_group_id
		,p_person_id		=> p_person_id
		,p_customer_id		=> p_customer_id
		,p_check_access_flag    => p_check_access_flag
		,p_identity_salesforce_id =>p_identity_salesforce_id
		,p_partner_cont_party_id  =>p_partner_cont_party_id
		,x_return_status	  =>x_return_status
		,x_msg_count		=> x_msg_count
		,x_msg_data		=> x_msg_data
		,x_update_access_flag	=> l_update_access_flag);

Line: 2083


		if l_update_access_flag = 'Y'
		then
			x_access_privilege := 'F';

Line: 2170


l_update_access_flag varchar2(1);

Line: 2234


		as_access_pvt.has_updateOpportunityAccess
		(p_api_version_number	=> 2.0
		,p_init_msg_list        => FND_API.G_FALSE
		,p_validation_level	=> p_validation_level
		,p_access_profile_rec	=> p_access_profile_rec
		,p_admin_flag		=> p_admin_flag
		,p_admin_group_id	=> p_admin_group_id
		,p_person_id		=> p_person_id
		,p_opportunity_id	=> p_opportunity_id
		,p_check_access_flag    => p_check_access_flag
		,p_identity_salesforce_id =>p_identity_salesforce_id
		,p_partner_cont_party_id  =>p_partner_cont_party_id
		,x_return_status	  =>x_return_status
		,x_msg_count		=> x_msg_count
		,x_msg_data		=> x_msg_data
		,x_update_access_flag	=> l_update_access_flag);

Line: 2257


		if l_update_access_flag = 'Y'
		then
			x_access_privilege := 'F';

Line: 2344


l_update_access_flag varchar2(1);

Line: 2408


		as_access_pvt.has_updateLeadAccess
		(p_api_version_number	=> 2.0
		,p_init_msg_list        => FND_API.G_FALSE
		,p_validation_level	=> p_validation_level
		,p_access_profile_rec	=> p_access_profile_rec
		,p_admin_flag		=> p_admin_flag
		,p_admin_group_id	=> p_admin_group_id
		,p_person_id		=> p_person_id
		,p_sales_lead_id	=> p_sales_lead_id
		,p_check_access_flag    => p_check_access_flag
		,p_identity_salesforce_id =>p_identity_salesforce_id
		,p_partner_cont_party_id  =>p_partner_cont_party_id
		,x_return_status	  =>x_return_status
		,x_msg_count		=> x_msg_count
		,x_msg_data		=> x_msg_data
		,x_update_access_flag	=> l_update_access_flag);

Line: 2431


		if l_update_access_flag = 'Y'
		then
			x_access_privilege := 'F';

Line: 2520


l_update_access_flag varchar2(1);

Line: 2581


		as_access_pub.has_updatePersonAccess
		(p_api_version_number	=> 2.0
		,p_init_msg_list        => FND_API.G_FALSE
		,p_validation_level	=> p_validation_level
		,p_access_profile_rec	=> p_access_profile_rec
		,p_admin_flag		=> p_admin_flag
		,p_admin_group_id	=> p_admin_group_id
		,p_person_id		=> p_person_id
		,p_security_id		=> p_security_id
		,p_security_type        => p_security_type
		,p_person_party_id      => p_person_party_id
		,p_check_access_flag    => p_check_access_flag
		,p_identity_salesforce_id =>p_identity_salesforce_id
		,p_partner_cont_party_id  =>p_partner_cont_party_id
		,x_return_status	  =>x_return_status
		,x_msg_count		=> x_msg_count
		,x_msg_data		=> x_msg_data
		,x_update_access_flag	=> l_update_access_flag);

Line: 2606


		if l_update_access_flag = 'Y'
		then
			x_access_privilege := 'F';