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

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

Line: 39


	SELECT lead_id
	FROM	as_lead_lines_all
	WHERE lead_line_id = p_lead_line_id;

Line: 53


l_update_access_flag       VARCHAR2(1);

Line: 159


 	AS_ACCESS_PUB.has_updateOpportunityAccess
	     (   p_api_version_number 	=> 2.0
		,p_init_msg_list     	=> p_init_msg_list
		,p_validation_level  	=> p_validation_level
		,p_access_profile_rec   => l_access_profile_rec
		,p_admin_flag	     	=> p_admin_flag
		,p_admin_group_id 	=> p_admin_group_id
		,p_person_id		=> l_identity_sales_member_rec.employee_person_id
		,p_opportunity_id	=> l_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: 180


			'Private API5: has_updateOpportunityAccess fail');

Line: 186


    	IF (l_update_access_flag <> 'Y') THEN
     	    IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
       		FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

Line: 197


			'Private API6: has_updateOpportunityAccess succeed');

Line: 230


     AS_LEAD_DECISION_FACTORS_PKG.Insert_Row(
          --px_SECURITY_GROUP_ID  => x_SECURITY_GROUP_ID,
          p_ATTRIBUTE15  => l_Decision_Factor_rec.ATTRIBUTE15,
          p_ATTRIBUTE14  => l_Decision_Factor_rec.ATTRIBUTE14,
          p_ATTRIBUTE13  => l_Decision_Factor_rec.ATTRIBUTE13,
          p_ATTRIBUTE12  => l_Decision_Factor_rec.ATTRIBUTE12,
          p_ATTRIBUTE11  => l_Decision_Factor_rec.ATTRIBUTE11,
          p_ATTRIBUTE10  => l_Decision_Factor_rec.ATTRIBUTE10,
          p_ATTRIBUTE9  => l_Decision_Factor_rec.ATTRIBUTE9,
          p_ATTRIBUTE8  => l_Decision_Factor_rec.ATTRIBUTE8,
          p_ATTRIBUTE7  => l_Decision_Factor_rec.ATTRIBUTE7,
          p_ATTRIBUTE6  => l_Decision_Factor_rec.ATTRIBUTE6,
          p_ATTRIBUTE5  => l_Decision_Factor_rec.ATTRIBUTE5,
          p_ATTRIBUTE4  => l_Decision_Factor_rec.ATTRIBUTE4,
          p_ATTRIBUTE3  => l_Decision_Factor_rec.ATTRIBUTE3,
          p_ATTRIBUTE2  => l_Decision_Factor_rec.ATTRIBUTE2,
          p_ATTRIBUTE1  => l_Decision_Factor_rec.ATTRIBUTE1,
          p_ATTRIBUTE_CATEGORY  => l_Decision_Factor_rec.ATTRIBUTE_CATEGORY,
          p_PROGRAM_UPDATE_DATE  => l_Decision_Factor_rec.PROGRAM_UPDATE_DATE,
          p_PROGRAM_ID  => l_Decision_Factor_rec.PROGRAM_ID,
          p_PROGRAM_APPLICATION_ID  => l_Decision_Factor_rec.PROGRAM_APPLICATION_ID,
          p_REQUEST_ID  => l_Decision_Factor_rec.REQUEST_ID,
          p_DECISION_RANK  => l_Decision_Factor_rec.DECISION_RANK,
          p_DECISION_PRIORITY_CODE  => l_Decision_Factor_rec.DECISION_PRIORITY_CODE,
          p_DECISION_FACTOR_CODE  => l_Decision_Factor_rec.DECISION_FACTOR_CODE,
          px_LEAD_DECISION_FACTOR_ID  => l_Decision_Factor_rec.LEAD_DECISION_FACTOR_ID,
          p_LEAD_LINE_ID  => l_Decision_Factor_rec.LEAD_LINE_ID,
          p_CREATE_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_CREATION_DATE  => SYSDATE);

Line: 362


PROCEDURE Update_decision_factors(
    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_Check_Access_Flag       IN   VARCHAR2    := FND_API.G_FALSE,
    P_Admin_Flag              IN   VARCHAR2    := FND_API.G_FALSE,
    P_Admin_Group_Id          IN   NUMBER,
    P_Identity_Salesforce_Id  IN   NUMBER,
    P_profile_tbl             IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_Partner_Cont_Party_id   IN   NUMBER      := FND_API.G_MISS_NUM,
    P_decision_factor_Tbl          IN   As_Opportunity_Pub.Decision_Factor_Tbl_Type,
    X_decision_factor_out_tbl      OUT NOCOPY  as_opportunity_pub.decision_factor_out_tbl_type,
    X_Return_Status           OUT NOCOPY  VARCHAR2,
    X_Msg_Count               OUT NOCOPY  NUMBER,
    X_Msg_Data                OUT NOCOPY  VARCHAR2
)

 IS
CURSOR G_lead_id(p_lead_line_id NUMBER) IS
	SELECT lead_id
	FROM	as_lead_lines_all
	WHERE lead_line_id = p_lead_line_id;

Line: 389


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

Line: 401


l_update_access_flag  VARCHAR2(1);

Line: 404


l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Update_decision_factors';

Line: 408


      SAVEPOINT UPDATE_DECISION_FACTOR_PVT;

Line: 476


 	        AS_ACCESS_PUB.has_updateOpportunityAccess
	        (   p_api_version_number 	=> 2.0
		       ,p_init_msg_list     	=> p_init_msg_list
		       ,p_validation_level  	=> p_validation_level
		       ,p_access_profile_rec   => l_access_profile_rec
		       ,p_admin_flag	     	=> p_admin_flag
		       ,p_admin_group_id 	=> p_admin_group_id
		       ,p_person_id		=> l_identity_sales_member_rec.employee_person_id
		       ,p_opportunity_id	=> l_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: 497


			       'Private API11: has_updateOpportunityAccess fail');

Line: 504


    	   IF (l_update_access_flag <> 'Y') THEN
     	       IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
       		      FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

Line: 515


			'Private API12: has_updateOpportunityAccess succeed');

Line: 528


      AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API13: Calling update table handler');

Line: 539


          p_validation_mode  => AS_UTILITY_PVT.G_UPDATE,
          P_Decision_Factor_Rec  =>  l_Decision_Factor_Rec,
          x_return_status    => x_return_status,
          x_msg_count        => x_msg_count,
          x_msg_data         => x_msg_data);

Line: 551


        AS_LEAD_DECISION_FACTORS_PKG.Update_Row(
          p_ATTRIBUTE15  => l_Decision_Factor_rec.ATTRIBUTE15,
          p_ATTRIBUTE14  => l_Decision_Factor_rec.ATTRIBUTE14,
          p_ATTRIBUTE13  => l_Decision_Factor_rec.ATTRIBUTE13,
          p_ATTRIBUTE12  => l_Decision_Factor_rec.ATTRIBUTE12,
          p_ATTRIBUTE11  => l_Decision_Factor_rec.ATTRIBUTE11,
          p_ATTRIBUTE10  => l_Decision_Factor_rec.ATTRIBUTE10,
          p_ATTRIBUTE9  => l_Decision_Factor_rec.ATTRIBUTE9,
          p_ATTRIBUTE8  => l_Decision_Factor_rec.ATTRIBUTE8,
          p_ATTRIBUTE7  => l_Decision_Factor_rec.ATTRIBUTE7,
          p_ATTRIBUTE6  => l_Decision_Factor_rec.ATTRIBUTE6,
          p_ATTRIBUTE5  => l_Decision_Factor_rec.ATTRIBUTE5,
          p_ATTRIBUTE4  => l_Decision_Factor_rec.ATTRIBUTE4,
          p_ATTRIBUTE3  => l_Decision_Factor_rec.ATTRIBUTE3,
          p_ATTRIBUTE2  => l_Decision_Factor_rec.ATTRIBUTE2,
          p_ATTRIBUTE1  => l_Decision_Factor_rec.ATTRIBUTE1,
          p_ATTRIBUTE_CATEGORY  => l_Decision_Factor_rec.ATTRIBUTE_CATEGORY,
          p_PROGRAM_UPDATE_DATE  => l_Decision_Factor_rec.PROGRAM_UPDATE_DATE,
          p_PROGRAM_ID  => l_Decision_Factor_rec.PROGRAM_ID,
          p_PROGRAM_APPLICATION_ID  => l_Decision_Factor_rec.PROGRAM_APPLICATION_ID,
          p_REQUEST_ID  => l_Decision_Factor_rec.REQUEST_ID,
          p_DECISION_RANK  => l_Decision_Factor_rec.DECISION_RANK,
          p_DECISION_PRIORITY_CODE  => l_Decision_Factor_rec.DECISION_PRIORITY_CODE,
          p_DECISION_FACTOR_CODE  => l_Decision_Factor_rec.DECISION_FACTOR_CODE,
          p_LEAD_DECISION_FACTOR_ID  => l_Decision_Factor_rec.LEAD_DECISION_FACTOR_ID,
          p_LEAD_LINE_ID  => l_Decision_Factor_rec.LEAD_LINE_ID,
          p_CREATE_BY  => l_Decision_Factor_rec.CREATE_BY,
          p_LAST_UPDATED_BY  => FND_GLOBAL.USER_ID,
          p_LAST_UPDATE_DATE  => SYSDATE,
          p_LAST_UPDATE_LOGIN  => FND_GLOBAL.CONC_LOGIN_ID,
          p_CREATION_DATE  => l_Decision_Factor_rec.CREATION_DATE);

Line: 670


End Update_decision_factors;

Line: 675


PROCEDURE Delete_decision_factors(
    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_Check_Access_Flag       IN   VARCHAR2    := FND_API.G_FALSE,
    P_Admin_Flag              IN   VARCHAR2    := FND_API.G_FALSE,
    P_Admin_Group_Id          IN   NUMBER,
    P_identity_salesforce_id  IN   NUMBER      := NULL,
    P_profile_tbl             IN   AS_UTILITY_PUB.PROFILE_TBL_TYPE,
    P_Partner_Cont_Party_id   IN   NUMBER      := FND_API.G_MISS_NUM,
    P_decision_factor_Tbl          IN   As_Opportunity_Pub.Decision_Factor_Tbl_Type,
    X_decision_factor_out_tbl      OUT NOCOPY  as_opportunity_pub.decision_factor_out_tbl_type,
    X_Return_Status           OUT NOCOPY  VARCHAR2,
    X_Msg_Count               OUT NOCOPY  NUMBER,
    X_Msg_Data                OUT NOCOPY  VARCHAR2
    )
 IS
CURSOR G_lead_id(p_lead_line_id NUMBER) IS
	SELECT lead_id
	FROM	as_lead_lines_all
	WHERE lead_line_id = p_lead_line_id;

Line: 697


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

Line: 708


l_update_access_flag  VARCHAR2(1);

Line: 711


l_module CONSTANT VARCHAR2(255) := 'as.plsql.dfpv.Delete_decision_factors';

Line: 715


      SAVEPOINT DELETE_DECISION_FACTOR_PVT;

Line: 783


 	        AS_ACCESS_PUB.has_updateOpportunityAccess
	        (   p_api_version_number 	=> 2.0
		       ,p_init_msg_list     	=> p_init_msg_list
		       ,p_validation_level  	=> p_validation_level
		       ,p_access_profile_rec   => l_access_profile_rec
		       ,p_admin_flag	     	=> p_admin_flag
		       ,p_admin_group_id 	=> p_admin_group_id
		       ,p_person_id		=> l_identity_sales_member_rec.employee_person_id
		       ,p_opportunity_id	=> l_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: 804


			       'Private API17: has_updateOpportunityAccess fail');

Line: 811


    	   IF (l_update_access_flag <> 'Y') THEN
     	       IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
       		      FND_MESSAGE.Set_Name('AS', 'API_NO_UPDATE_PRIVILEGE');

Line: 822


			'Private API18: has_updateOpportunityAccess succeed');

Line: 832


      AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API19: Calling delete table handler');

Line: 839


          AS_LEAD_DECISION_FACTORS_PKG.Delete_Row(
             p_LEAD_DECISION_FACTOR_ID  => l_Decision_Factor_rec.LEAD_DECISION_FACTOR_ID);

Line: 903


End Delete_decision_factors;

Line: 935


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_REQUEST_ID <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 982


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_DECISION_RANK <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;

Line: 1011


     SELECT 'X'
     FROM  AS_LOOKUPS
     WHERE LOOKUP_TYPE = 'DECISION_PRIORITY_TYPE'
     AND  LOOKUP_CODE = c_Decision_Priority_Code;

Line: 1076


     SELECT 'X'
     FROM  AS_LOOKUPS
     WHERE LOOKUP_TYPE = 'DECISION_FACTOR_TYPE'
     AND  LOOKUP_CODE = c_Decision_Factor_Code;

Line: 1083


     SELECT 'X'
     FROM  AS_LEAD_DECISION_FACTORS
     WHERE LEAD_LINE_ID = c_Lead_Line_Id;

Line: 1099


     IF(p_validation_mode = AS_UTILITY_PVT.G_CREATE) OR (p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN

     --     OPEN  C_D_Decis_Factor_Code_Exists (P_LEAD_LINE_ID);

Line: 1189


     SELECT 'X'
     FROM  AS_LEAD_DECISION_FACTORS
     WHERE LEAD_DECISION_FACTOR_ID = c_Lead_DECISION_FACTOR_ID;

Line: 1236


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- validate NOT NULL column
          IF (P_LEAD_DECISION_FACTOR_ID is NULL) or (P_LEAD_DECISION_FACTOR_ID = FND_API.G_MISS_NUM)
          THEN
              IF l_debug THEN
              AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
                          'Private API25: Violate NOT NULL constraint(LEAD_DECISION_FACTOR_ID)');

Line: 1302


     SELECT 'X'
     FROM  AS_LEAD_LINES
     WHERE LEAD_LINE_ID = c_Lead_Line_Id;

Line: 1411


      ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
      THEN
          -- Hint: Validate data
          -- IF p_CREATE_BY <> G_MISS_CHAR
          -- verify if data is valid
          -- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;