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_OPPORTUNITY_PUB SQL Statements

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

Line: 255


PROCEDURE Update_Opp_header
(   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_header_rec               	IN     AS_OPPORTUNITY_PUB.Header_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_partner_cont_party_id	IN     NUMBER,
    p_profile_tbl	    	IN     AS_UTILITY_PUB.Profile_Tbl_Type
				       DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_return_status         	OUT NOCOPY    VARCHAR2,
    x_msg_count             	OUT NOCOPY    NUMBER,
    x_msg_data              	OUT NOCOPY    VARCHAR2,
    x_lead_id               	OUT NOCOPY    NUMBER)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Update_opp_header';

Line: 279


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_header';

Line: 282


      SAVEPOINT UPDATE_OPP_HEADER_PUB;

Line: 334


      IF(JTF_USR_HKS.Ok_to_execute('AS_OPPORTUNITY_PUB', 'Update_Opp_Header','B','V'))
      THEN
          AS_OPPORTUNITY_VUHK.Update_opp_header_Pre(
    	    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_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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    	    P_Profile_Tbl                => P_Profile_tbl,
    	    P_Header_Rec  		 => l_Header_Rec ,
    	    X_Return_Status              => x_return_status,
    	    X_Msg_Count                  => x_msg_count,
    	    X_Msg_Data                   => x_msg_data);

Line: 356


		   'Update_opp_header_Pre fail');

Line: 370


      AS_OPP_header_PVT.Update_opp_header(
    	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_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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    	P_Profile_Tbl                => P_Profile_tbl,
    	P_Header_Rec  		 => l_Header_Rec ,
    	X_Return_Status              => x_return_status,
    	X_Msg_Count                  => x_msg_count,
    	X_Msg_Data                   => x_msg_data);

Line: 399


      IF(JTF_USR_HKS.Ok_to_execute('AS_OPPORTUNITY_PUB', 'Update_Opp_Header','A','V'))
      THEN
          AS_OPPORTUNITY_VUHK.Update_opp_header_Post(
    	    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_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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    	    P_Profile_Tbl                => P_Profile_tbl,
    	    P_Header_Rec  		 => l_Header_Rec ,
    	    X_Return_Status              => x_return_status,
    	    X_Msg_Count                  => x_msg_count,
    	    X_Msg_Data                   => x_msg_data);

Line: 421


		   'Update_opp_header_Post fail');

Line: 496


End Update_opp_header;

Line: 506


PROCEDURE Delete_Opp_Header
(   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_header_rec               	IN     AS_OPPORTUNITY_PUB.Header_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_partner_cont_party_id	IN     NUMBER,
    p_profile_tbl	    	IN     AS_UTILITY_PUB.Profile_Tbl_Type
				       DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_return_status         	OUT NOCOPY    VARCHAR2,
    x_msg_count             	OUT NOCOPY    NUMBER,
    x_msg_data              	OUT NOCOPY    VARCHAR2,
    x_lead_id               	OUT NOCOPY    NUMBER)
IS
l_api_name                CONSTANT VARCHAR2(30) := 'Delete_opp_Header';

Line: 528


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Header';

Line: 531


      SAVEPOINT DELETE_OPP_HEADER_PUB;

Line: 581


      AS_OPP_header_PVT.Delete_opp_header(
    	P_Api_Version_Number         => 2.0,
    	P_Init_Msg_List              => FND_API.G_FALSE,
    	P_Commit                     => p_commit,
    	P_Validation_Level           => P_Validation_Level,
    	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_Partner_Cont_Party_Id	     => p_partner_cont_party_id,
    	P_Profile_Tbl                => P_Profile_tbl,
    	P_Lead_Id  		     => l_Header_Rec.lead_id ,
    	X_Return_Status              => x_return_status,
    	X_Msg_Count                  => x_msg_count,
    	X_Msg_Data                   => x_msg_data);

Line: 665


End Delete_Opp_Header;

Line: 858


PROCEDURE Update_Opp_Lines
(   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_identity_salesforce_id 	IN    NUMBER DEFAULT  NULL,
    p_line_tbl       		IN    AS_OPPORTUNITY_PUB.Line_Tbl_Type,
    p_header_rec               	IN    AS_OPPORTUNITY_PUB.Header_Rec_Type,
    p_check_access_flag	    	IN    VARCHAR2,
    p_admin_flag	    	IN    VARCHAR2,
    p_admin_group_id	    	IN    NUMBER,
    p_partner_cont_party_id	IN    NUMBER,
    p_profile_tbl	    	IN    AS_UTILITY_PUB.Profile_Tbl_Type
				      DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_line_out_tbl		OUT NOCOPY   Line_Out_Tbl_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) := 'Update_opp_lines';

Line: 882


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Opp_Lines';

Line: 885


      SAVEPOINT UPDATE_OPP_LINES_PUB;

Line: 938


    AS_OPP_line_PVT.Update_opp_lines(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Line_Tbl  		 => l_line_tbl ,
    P_Header_Rec		 => l_header_rec,
    X_Line_Out_Tbl		 => x_line_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 1023


End Update_opp_lines;

Line: 1034


PROCEDURE Delete_Opp_Lines
(   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_identity_salesforce_id 	IN    NUMBER DEFAULT  NULL,
    p_line_tbl      		IN    AS_OPPORTUNITY_PUB.Line_Tbl_Type,
    p_header_rec               	IN    AS_OPPORTUNITY_PUB.Header_Rec_Type,
    p_check_access_flag     	IN    VARCHAR2,
    p_admin_flag	    	IN    VARCHAR2,
    p_admin_group_id	    	IN    NUMBER,
    p_partner_cont_party_id	IN    NUMBER,
    p_profile_tbl	    	IN    AS_UTILITY_PUB.Profile_Tbl_Type
				      DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_line_out_tbl		OUT NOCOPY   Line_Out_Tbl_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_opp_lines';

Line: 1058


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Opp_Lines';

Line: 1061


      SAVEPOINT DELETE_OPP_LINES_PUB;

Line: 1113


    AS_OPP_line_PVT.Delete_opp_lines(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_Check_Access_Flag          => p_check_access_flag,
    P_Admin_Flag                 =>  P_Admin_Flag ,
    P_Admin_Group_Id             => P_Admin_Group_Id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Identity_Salesforce_Id      => p_identity_salesforce_id,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Line_Tbl  		 => l_line_tbl ,
    P_Header_Rec		 => l_header_rec,
    X_Line_Out_Tbl		 => x_line_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 1198


End Delete_opp_lines;

Line: 1369


PROCEDURE Update_Sales_Credits
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_sales_credit_tbl      IN     AS_OPPORTUNITY_PUB.Sales_Credit_Tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_sales_credit_out_tbl  OUT NOCOPY    Sales_Credit_Out_Tbl_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) := 'Update_sales_credits';

Line: 1392


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Sales_Credits';

Line: 1395


      SAVEPOINT UPDATE_SALES_CREDITS_PUB;

Line: 1447


    AS_OPP_sales_credit_PVT.Update_sales_credits(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Sales_Credit_Tbl	         => l_sales_credit_tbl,
    X_Sales_Credit_Out_Tbl	 => x_sales_credit_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 1531


End Update_sales_credits;

Line: 1698


PROCEDURE Delete_Sales_Credits
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_sales_credit_tbl      IN     AS_OPPORTUNITY_PUB.Sales_Credit_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_sales_credit_out_tbl  OUT NOCOPY    Sales_Credit_Out_Tbl_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_sales_credits';

Line: 1721


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Sales_Credits';

Line: 1724


      SAVEPOINT DELETE_SALES_CREDITS_PUB;

Line: 1775


    AS_OPP_sales_credit_PVT.Delete_sales_credits(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_Check_Access_Flag          => p_check_access_flag,
    P_Admin_Flag                 => P_Admin_Flag,
    P_Admin_Group_Id             => P_Admin_Group_Id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Identity_Salesforce_Id     => p_identity_salesforce_id,
    P_Sales_Credit_Tbl	         => l_sales_credit_tbl,
    X_Sales_Credit_Out_Tbl	 => x_sales_credit_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 1859


End Delete_sales_credits;

Line: 1862


PROCEDURE Update_Orders
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_lead_order_tbl        IN     AS_OPPORTUNITY_PUB.Order_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_order_out_tbl	    OUT NOCOPY    Order_Out_Tbl_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) := 'Update_orders';

Line: 1885


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Orders';

Line: 1888


      SAVEPOINT UPDATE_ORDERS_PUB;

Line: 1941


    /*AS_OPP_order_PVT.Update_orders(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Order_Tbl	                 => l_order_tbl,
    X_Lead_Order_Out_Tbl	 => x_order_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 2027


End Update_orders;

Line: 2030


PROCEDURE Delete_Orders
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_lead_order_tbl        IN     AS_OPPORTUNITY_PUB.Order_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_order_out_tbl	    OUT NOCOPY    Order_Out_Tbl_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_orders';

Line: 2053


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Orders';

Line: 2056


      SAVEPOINT DELETE_ORDERS_PUB;

Line: 2107


/*    AS_OPP_order_PVT.Delete_orders(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Profile_Tbl                => P_Profile_tbl,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Order_Tbl	                 => l_order_tbl,
    X_Lead_Order_Out_Tbl	 => x_order_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 2191


End Delete_orders;

Line: 2361


PROCEDURE Update_Competitors
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_competitor_tbl        IN     AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_competitor_out_tbl    OUT NOCOPY    Competitor_Out_Tbl_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) := 'Update_competitors';

Line: 2384


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitors';

Line: 2387


      SAVEPOINT UPDATE_COMPETITORS_PUB;

Line: 2440


    AS_OPP_competitor_pvt.Update_competitors(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Competitor_Tbl             => l_competitor_tbl,
    X_Competitor_Out_Tbl         => x_competitor_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 2523


End Update_competitors;

Line: 2526


PROCEDURE Delete_Competitors
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_competitor_tbl        IN     AS_OPPORTUNITY_PUB.Competitor_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_competitor_out_tbl    OUT NOCOPY    Competitor_Out_Tbl_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_competitors';

Line: 2549


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitors';

Line: 2552


      SAVEPOINT DELETE_COMPETITORS_PUB;

Line: 2604


    AS_OPP_competitor_pvt.Delete_competitors(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_Check_Access_Flag          => p_check_access_flag,
    P_Admin_Flag                 => P_Admin_Flag,
    P_Admin_Group_Id             => P_Admin_Group_Id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Identity_Salesforce_Id      => p_identity_salesforce_id,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Competitor_Tbl             => l_competitor_tbl,
    X_Competitor_Out_Tbl         => x_competitor_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 2687


End Delete_competitors;

Line: 2858


PROCEDURE Update_Competitor_Prods
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_competitor_prod_tbl        IN     AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_competitor_prod_out_tbl    OUT NOCOPY    Competitor_Prod_Out_Tbl_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) := 'Update_competitor_prods';

Line: 2881


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Competitor_Prods';

Line: 2884


      SAVEPOINT UPDATE_COMPETITOR_PRODS_PUB;

Line: 2936


    AS_competitor_prod_pvt.Update_competitor_prods(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Competitor_Prod_Tbl             => l_competitor_prod_tbl,
    X_Competitor_Prod_Out_Tbl         => x_competitor_prod_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 3019


End Update_competitor_prods;

Line: 3022


PROCEDURE Delete_Competitor_Prods
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_competitor_prod_tbl        IN     AS_OPPORTUNITY_PUB.Competitor_Prod_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_competitor_prod_out_tbl    OUT NOCOPY    Competitor_Prod_Out_Tbl_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_competitor_prods';

Line: 3045


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Competitor_Prods';

Line: 3048


      SAVEPOINT DELETE_COMPETITOR_PRODS_PUB;

Line: 3100


    AS_competitor_prod_pvt.Delete_competitor_prods(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_Check_Access_Flag          => p_check_access_flag,
    P_Admin_Flag                 => P_Admin_Flag,
    P_Admin_Group_Id             => P_Admin_Group_Id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Identity_Salesforce_Id      => p_identity_salesforce_id,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Competitor_Prod_Tbl             => l_competitor_prod_tbl,
    X_Competitor_Prod_Out_Tbl         => x_competitor_prod_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 3184


End Delete_competitor_prods;

Line: 3354


PROCEDURE Update_Decision_Factors
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_decision_factor_tbl        IN     AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_decision_factor_out_tbl    OUT NOCOPY    Decision_Factor_Out_Tbl_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) := 'Update_decision_factors';

Line: 3377


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Decision_Factors';

Line: 3380


      SAVEPOINT UPDATE_DECISION_FACTORS_PUB;

Line: 3431


    AS_decision_factor_pvt.Update_decision_factors(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Decision_Factor_Tbl             => l_decision_factor_tbl,
    X_Decision_Factor_Out_Tbl         => x_decision_factor_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 3515


End Update_decision_factors;

Line: 3518


PROCEDURE Delete_Decision_Factors
(   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_identity_salesforce_id IN    NUMBER   DEFAULT  NULL,
    p_decision_factor_tbl        IN     AS_OPPORTUNITY_PUB.Decision_Factor_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_decision_factor_out_tbl    OUT NOCOPY    Decision_Factor_Out_Tbl_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_decision_factors';

Line: 3541


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Decision_Factors';

Line: 3544


      SAVEPOINT DELETE_DECISION_FACTORS_PUB;

Line: 3596


    AS_decision_factor_pvt.Delete_decision_factors(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    P_Check_Access_Flag          => p_check_access_flag,
    P_Admin_Flag                 => P_Admin_Flag,
    P_Admin_Group_Id             => P_Admin_Group_Id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Identity_Salesforce_Id      => p_identity_salesforce_id,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Decision_Factor_Tbl             => l_decision_factor_tbl,
    X_Decision_Factor_Out_Tbl         => x_decision_factor_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 3680


End Delete_decision_factors;

Line: 3851


PROCEDURE Update_Contacts
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_contact_tbl           IN     AS_OPPORTUNITY_PUB.Contact_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_contact_out_tbl	    OUT NOCOPY    Contact_Out_Tbl_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) := 'Update_contacts';

Line: 3874


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Contacts';

Line: 3877


      SAVEPOINT UPDATE_CONTACTS_PUB;

Line: 3929


    AS_OPP_contact_PVT.Update_opp_contacts(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Contact_Tbl                => l_contact_tbl ,
    X_Contact_Out_Tbl		 => x_contact_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 4013


End Update_contacts;

Line: 4016


PROCEDURE Delete_Contacts
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_contact_tbl           IN     AS_OPPORTUNITY_PUB.Contact_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_contact_out_tbl	    OUT NOCOPY    Contact_Out_Tbl_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_contacts';

Line: 4039


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Contacts';

Line: 4043


      SAVEPOINT DELETE_CONTACTS_PUB;

Line: 4095


    AS_OPP_contact_PVT.Delete_opp_contacts(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Profile_Tbl                => P_Profile_tbl,
    P_Partner_Cont_Party_Id    => p_partner_cont_party_id,
    P_Contact_Tbl                => l_contact_tbl,
    X_Contact_Out_Tbl		 => x_contact_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 4179


End Delete_contacts;

Line: 4351


PROCEDURE Update_Obstacles
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_obstacle_tbl          IN     AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_obstacle_out_tbl	    OUT NOCOPY    Obstacle_Out_Tbl_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) := 'Update_obstacles';

Line: 4374


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Update_Obstacles';

Line: 4377


      SAVEPOINT UPDATE_OBSTACLES_PUB;

Line: 4428


    AS_OPP_obstacle_PVT.Update_obstacles(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level,
    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_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Profile_Tbl                => P_Profile_tbl,
    P_Obstacle_Tbl		 => l_obstacle_tbl,
    X_Lead_Obstacle_Out_Tbl	 => x_obstacle_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 4513


End Update_obstacles;

Line: 4516


PROCEDURE Delete_Obstacles
(   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_identity_salesforce_id IN    NUMBER DEFAULT  NULL,
    p_obstacle_tbl          IN     AS_OPPORTUNITY_PUB.Obstacle_tbl_Type,
    p_check_access_flag     IN 	   VARCHAR2,
    p_admin_flag	    IN 	   VARCHAR2,
    p_admin_group_id	    IN	   NUMBER,
    p_partner_cont_party_id   IN     NUMBER,
    p_profile_tbl	    IN     AS_UTILITY_PUB.Profile_Tbl_Type
				   DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
    x_obstacle_out_tbl	    OUT NOCOPY    Obstacle_Out_Tbl_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_obstacles';

Line: 4539


l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_Obstacles';

Line: 4542


      SAVEPOINT DELETE_OBSTACLES_PUB;

Line: 4595


    AS_OPP_obstacle_PVT.Delete_obstacles(
    P_Api_Version_Number         => 2.0,
    P_Init_Msg_List              => FND_API.G_FALSE,
    P_Commit                     => p_commit,
    P_Validation_Level           => P_Validation_Level ,
    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_Profile_Tbl                => P_Profile_tbl,
    P_Partner_Cont_Party_Id	 => p_partner_cont_party_id,
    P_Obstacle_Tbl		 => l_obstacle_tbl,
    X_Lead_Obstacle_Out_Tbl	 => x_obstacle_out_tbl,
    X_Return_Status              => x_return_status,
    X_Msg_Count                  => x_msg_count,
    X_Msg_Data                   => x_msg_data);

Line: 4679


End Delete_obstacles;

Line: 4681


PROCEDURE Delete_SalesTeams
(       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_sales_team_tbl                IN      AS_ACCESS_PUB.SALES_TEAM_TBL_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_partner_cont_party_id           IN      NUMBER,
     	p_profile_tbl	    		IN     	AS_UTILITY_PUB.Profile_Tbl_Type
				 		DEFAULT AS_UTILITY_PUB.G_MISS_PROFILE_TBL,
        x_return_status                 OUT NOCOPY     VARCHAR2,
        x_msg_count                     OUT NOCOPY     NUMBER,
        x_msg_data                      OUT NOCOPY     VARCHAR2
)
IS

  Cursor c_sales_team(p_access_id number) IS
	select lead_id, salesforce_id, sales_group_id
   	from as_accesses_all
	where access_id = p_access_id;

Line: 4709


    SELECT  sales_credit_id
    FROM    as_sales_credits
    WHERE   salesforce_id = X_SalesForceID
    AND     lead_id = X_LeadID
    AND     NVL(SALESGROUP_ID, -99) = NVL(X_salesGroupID, -99);

Line: 4717


    SELECT first_name||' '||last_name
    FROM per_people_f
    WHERE person_id = X_personID;

Line: 4726


  l_api_name                CONSTANT VARCHAR2(30) := 'Delete_SalesTeams';

Line: 4732


  l_module CONSTANT VARCHAR2(255) := 'as.plsql.oppb.Delete_SalesTeams';

Line: 4735


      SAVEPOINT DELETE_SALESTEAMS_PUB;

Line: 4776


	 -- AS_ACCESS_PUB.Delete_SalesTeam handles single records.
	 -- This procedure needs to be able to handle tables.
      FOR l_curr_row IN 1..l_line_count LOOP

	     -- Check whether the Sales Person has Sales Credit
	     BEGIN
	       l_sales_team_rec := p_sales_team_tbl(l_curr_row);

Line: 4806


			     -- Call the AS_ACCESS_PUB.Delete_SalesTeam API
			     AS_ACCESS_PUB.Delete_SalesTeam(
			         p_api_version_number     =>  l_api_version_number,
                        p_init_msg_list          =>  FND_API.G_FALSE,
                        p_commit                 =>  p_commit,
				    p_validation_level       =>  p_validation_level,
				    p_access_profile_rec     =>  l_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_sales_team_rec,
                        x_return_status          =>  x_return_status,
                        x_msg_count              =>  x_msg_count,
                        x_msg_data               =>  x_msg_data
                    );

Line: 4832


				--    FND_MESSAGE.Set_Name('AS', 'AS_DELETE_SALESTEAM_NOTALLOWED');

Line: 4839


                  			p_msg_name      => 'AS_DELETE_SALESTEAM_NOTALLOWED',
                      			p_token1        => 'SALESREP',
                      			p_token1_value  => l_person_name );

Line: 4932


END Delete_SalesTeams;

Line: 5140


	IF p_profile_tbl(l_curr).PROFILE_NAME = 'AS_MGR_UPDATE' THEN
	    x_access_profile_rec.mgr_update_profile_value := l_profile_value;

Line: 5144


	IF p_profile_tbl(l_curr).PROFILE_NAME = 'AS_ADMIN_UPDATE' THEN
	    x_access_profile_rec.admin_update_profile_value := l_profile_value;

Line: 5171


    IF x_access_profile_rec.mgr_update_profile_value IS NULL OR
       x_access_profile_rec.mgr_update_profile_value = FND_API.G_MISS_CHAR
    THEN
	x_access_profile_rec.mgr_update_profile_value
		:= FND_PROFILE.Value('AS_MGR_UPDATE');

Line: 5178


    IF x_access_profile_rec.admin_update_profile_value IS NULL OR
       x_access_profile_rec.admin_update_profile_value = FND_API.G_MISS_CHAR
    THEN
	x_access_profile_rec.admin_update_profile_value
		:= FND_PROFILE.Value('AS_ADMIN_UPDATE');