APPS.ASN_SALES_PVT SQL Statements

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

Line: 37

     /* Call Post Lead Update Process API */
     AS_SALES_LEADS_PUB.Lead_Process_After_Create(
          P_Api_Version_Number     => p_api_version_number
        , P_Init_Msg_List          => p_init_msg_list
        , p_Commit                 => p_commit
        , p_Validation_Level       => p_validation_level
        , P_Check_Access_Flag      => 'N'
        , p_Admin_Flag             => NULL
        , P_Admin_Group_Id         => NULL
        , P_Identity_Salesforce_Id => p_identity_salesforce_id
        , P_Salesgroup_id          => p_salesgroup_id
        , P_Sales_Lead_Id          => p_sales_lead_id
        , X_Return_Status          => x_return_status
        , X_Msg_Count              => x_msg_count
        , X_Msg_Data               => x_msg_data);

Line: 66

                      'After Create: Delete duplicate access records on auto conversion.');

Line: 79

   PROCEDURE Lead_Process_After_Update (
     P_Api_Version_Number     IN  NUMBER,
     P_Init_Msg_List          IN  VARCHAR2     := FND_API.G_FALSE,
     p_Commit                 IN  VARCHAR2     := FND_API.G_FALSE,
     p_Validation_Level       IN  NUMBER       := FND_API.G_VALID_LEVEL_FULL,
     P_Identity_Salesforce_Id IN  NUMBER,
     P_Salesgroup_id          IN  NUMBER,
     P_Sales_Lead_Id          IN  NUMBER,
     X_Return_Status          OUT NOCOPY VARCHAR2,
     X_Msg_Count              OUT NOCOPY NUMBER,
     X_Msg_Data               OUT NOCOPY VARCHAR2
   )
   IS
     G_PROC_NAME VARCHAR2(200) := 'asn.plsql.ASN_SALES_PVT.Lead_Process_After_Update';

Line: 109

                      'Calling AS_SALES_LEADS_PUB.Lead_Process_After_Update...');

Line: 112

     /* Call Post Lead Update Process API */
     AS_SALES_LEADS_PUB.Lead_Process_After_Update(
          P_Api_Version_Number     => p_api_version_number
        , P_Init_Msg_List          => p_init_msg_list
        , p_Commit                 => p_commit
        , p_Validation_Level       => p_validation_level
        , P_Check_Access_Flag      => 'N'
        , p_Admin_Flag             => NULL
        , P_Admin_Group_Id         => NULL
        , P_Identity_Salesforce_Id => p_identity_salesforce_id
        , P_Salesgroup_id          => p_salesgroup_id
        , P_Sales_Lead_Id          => p_sales_lead_id
        , X_Return_Status          => x_return_status
        , X_Msg_Count              => x_msg_count
        , X_Msg_Data               => x_msg_data);

Line: 132

                      'Returning from AS_SALES_LEADS_PUB.Lead_Process_After_Update' ||
                      ', To remove duplicate access records. ');

Line: 140

                      'After Update: Delete duplicate access records on auto conversion. ');

Line: 150

   END Lead_Process_After_Update;