The following lines contain the word 'select', 'insert', 'update' or 'delete':
select category
from jtf_rs_resource_extns
where resource_id = p_salesForce_id;
If (l_opp_rec.deleted_flag IS NULL or
l_opp_rec.deleted_flag = FND_API.G_MISS_CHAR ) AND
p_mode = AS_UTILITY_PVT.G_CREATE
then
l_opp_rec.deleted_flag := 'N';
select meaning
from as_statuses_vl
where STATUS_CODE = c_status_code;
SELECT name
from as_sales_stages_all_vl
where sales_stage_id = c_sales_stage_id;
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
p_last_update_date => SYSDATE,
p_last_updated_by => FND_GLOBAL.USER_ID,
p_creation_date => SYSDATE,
p_created_by => FND_GLOBAL.USER_ID,
p_last_update_login => FND_GLOBAL.LOGIN_ID
);
select TASK_TEMPLATE_GROUP_ID
from as_sales_meth_stage_map
where SALES_METHODOLOGY_ID = c_sales_methodology_id
and SALES_STAGE_ID = c_sales_stage_id;
PROCEDURE Update_Competitor_Products(
p_LEAD_ID IN NUMBER,
p_STATUS_CODE IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2)
IS
CURSOR c_WIN_LOSS_INDICATOR(c_STATUS_CODE VARCHAR2) IS
select WIN_LOSS_INDICATOR
from as_statuses_b
where status_code = c_STATUS_CODE;
UPDATE AS_LEAD_COMP_PRODUCTS
SET object_version_number = nvl(object_version_number,0) + 1, WIN_LOSS_STATUS = 'LOST'
WHERE LEAD_ID = p_LEAD_ID;
END Update_Competitor_Products;
select 'Y'
from as_lead_competitors
where lead_id = p_lead_id
and competitor_id = p_competitor_id;
l_Competitor_rec.last_update_date := SYSDATE;
l_Competitor_rec.last_updated_by := FND_GLOBAL.USER_ID;
l_Competitor_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
select lead_id, salesforce_id, sales_group_id
from as_accesses_all
where access_id = p_access_id;
UPDATE AS_ACCESSES_ALL
SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y'
WHERE ACCESS_ID = p_access_id;
UPDATE AS_LEADS_ALL
SET object_version_number = nvl(object_version_number,0) + 1, owner_salesforce_id = acr.salesforce_id,
owner_sales_group_id = acr.sales_group_id
WHERE lead_id = acr.lead_id;
select employee_person_id
from as_salesforce_v
where salesforce_id = c_salesforce_id;
SELECT group_id
FROM JTF_RS_GROUP_MEMBERS
WHERE resource_id = p_resource_id
ORDER BY GROUP_ID;
select party_site_id
from hz_party_sites
where party_id = p_customer_id
and IDENTIFYING_ADDRESS_FLAG = 'Y';
(l_Header_Rec.deleted_flag IS NULL) or
(l_Header_Rec.deleted_flag = FND_API.G_MISS_CHAR) or
(l_Header_Rec.auto_assignment_type IS NULL) or -- acng, bug 2044908
(l_Header_Rec.auto_assignment_type = FND_API.G_MISS_CHAR) or
(l_Header_Rec.prm_assignment_type IS NULL) or -- acng, bug 2044908
(l_Header_Rec.prm_assignment_type = FND_API.G_MISS_CHAR) or
(l_Header_Rec.freeze_flag IS NULL) or -- solin, bug 1554330
(l_Header_Rec.freeze_flag = FND_API.G_MISS_CHAR) -- solin, bug 1554330
THEN
IF l_debug THEN
AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
'Calling Set_opp_default_values');
AS_LEADS_PKG.Insert_Row(
px_LEAD_ID => l_LEAD_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => FND_GLOBAL.USER_ID,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_REQUEST_ID => l_Header_Rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_Header_Rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_Header_Rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_Header_Rec.PROGRAM_UPDATE_DATE,
p_LEAD_NUMBER => l_Header_Rec.LEAD_NUMBER,
p_STATUS => l_Header_Rec.STATUS_CODE,
p_CUSTOMER_ID => l_Header_Rec.CUSTOMER_ID,
p_ADDRESS_ID => l_Header_Rec.ADDRESS_ID,
p_SALES_STAGE_ID => l_header_rec.SALES_STAGE_ID,
p_INITIATING_CONTACT_ID => l_header_rec.INITIATING_CONTACT_ID,
p_CHANNEL_CODE => l_header_rec.CHANNEL_CODE,
p_TOTAL_AMOUNT => l_header_rec.TOTAL_AMOUNT,
p_CURRENCY_CODE => l_header_rec.CURRENCY_CODE,
p_DECISION_DATE => l_header_rec.DECISION_DATE,
p_WIN_PROBABILITY => l_header_rec.WIN_PROBABILITY,
p_CLOSE_REASON => l_header_rec.CLOSE_REASON,
p_CLOSE_COMPETITOR_CODE => l_header_rec.CLOSE_COMPETITOR_CODE,
p_CLOSE_COMPETITOR => l_header_rec.CLOSE_COMPETITOR,
p_CLOSE_COMMENT => l_header_rec.CLOSE_COMMENT,
p_DESCRIPTION => l_header_rec.DESCRIPTION,
p_RANK => l_header_rec.RANK,
p_SOURCE_PROMOTION_ID => l_header_rec.SOURCE_PROMOTION_ID,
p_END_USER_CUSTOMER_ID => l_header_rec.END_USER_CUSTOMER_ID,
p_END_USER_ADDRESS_ID => l_header_rec.END_USER_ADDRESS_ID,
p_OWNER_SALESFORCE_ID => l_header_rec.OWNER_SALESFORCE_ID,
p_OWNER_SALES_GROUP_ID => l_header_rec.OWNER_SALES_GROUP_ID,
--p_OWNER_ASSIGN_DATE => l_header_rec.OWNER_ASSIGN_DATE,
p_ORG_ID => l_header_rec.ORG_ID,
p_NO_OPP_ALLOWED_FLAG => l_header_rec.NO_OPP_ALLOWED_FLAG,
p_DELETE_ALLOWED_FLAG => l_header_rec.DELETE_ALLOWED_FLAG,
p_ATTRIBUTE_CATEGORY => l_header_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_header_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_header_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_header_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_header_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_header_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_header_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_header_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_header_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_header_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_header_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_header_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_header_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_header_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_header_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_header_rec.ATTRIBUTE15,
p_PARENT_PROJECT => l_header_rec.PARENT_PROJECT,
p_LEAD_SOURCE_CODE => l_header_rec.LEAD_SOURCE_CODE,
p_ORIG_SYSTEM_REFERENCE => l_header_rec.ORIG_SYSTEM_REFERENCE,
p_CLOSE_COMPETITOR_ID => l_header_rec.CLOSE_COMPETITOR_ID,
p_END_USER_CUSTOMER_NAME => l_header_rec.END_USER_CUSTOMER_NAME,
p_PRICE_LIST_ID => l_header_rec.PRICE_LIST_ID,
p_DELETED_FLAG => l_header_rec.DELETED_FLAG,
p_AUTO_ASSIGNMENT_TYPE => l_header_rec.AUTO_ASSIGNMENT_TYPE,
p_PRM_ASSIGNMENT_TYPE => l_header_rec.PRM_ASSIGNMENT_TYPE,
p_CUSTOMER_BUDGET => l_header_rec.CUSTOMER_BUDGET,
p_METHODOLOGY_CODE => l_header_rec.METHODOLOGY_CODE,
p_SALES_METHODOLOGY_ID => l_header_rec.SALES_METHODOLOGY_ID,
p_ORIGINAL_LEAD_ID => l_header_rec.ORIGINAL_LEAD_ID,
p_DECISION_TIMEFRAME_CODE => l_header_rec.DECISION_TIMEFRAME_CODE,
p_INC_PARTNER_RESOURCE_ID=>l_header_rec.INCUMBENT_PARTNER_RESOURCE_ID,
p_INC_PARTNER_PARTY_ID => l_header_rec.INCUMBENT_PARTNER_PARTY_ID,
p_OFFER_ID => l_header_rec.OFFER_ID,
p_VEHICLE_RESPONSE_CODE => l_header_rec.VEHICLE_RESPONSE_CODE,
p_BUDGET_STATUS_CODE => l_header_rec.BUDGET_STATUS_CODE,
p_FOLLOWUP_DATE => l_header_rec.FOLLOWUP_DATE,
p_PRM_EXEC_SPONSOR_FLAG => l_header_rec.PRM_EXEC_SPONSOR_FLAG,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG=>l_header_rec.PRM_PRJ_LEAD_IN_PLACE_FLAG,
p_PRM_IND_CLASSIFICATION_CODE =>
l_header_rec.PRM_IND_CLASSIFICATION_CODE,
p_PRM_LEAD_TYPE => l_header_rec.PRM_LEAD_TYPE,
p_FREEZE_FLAG => l_header_rec.FREEZE_FLAG,
p_PRM_REFERRAL_CODE => l_header_rec.PRM_REFERRAL_CODE,
p_TOT_REVENUE_OPP_FORECAST_AMT => l_header_rec.TOTAL_REVENUE_OPP_FORECAST_AMT); -- Added for ASNB
l_Sales_Team_Rec.last_update_date := SYSDATE;
l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
Update_Competitor_Products(
p_LEAD_ID => l_lead_id,
p_STATUS_CODE => l_header_rec.STATUS_CODE,
x_return_status => x_return_status);
AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Update competitor Products fail');
PROCEDURE Update_opp_header(
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_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
Cursor C_Get_opp_header(c_LEAD_ID Number) IS
Select LAST_UPDATE_DATE, DELETED_FLAG,
WIN_PROBABILITY, nvl(TOTAL_REVENUE_OPP_FORECAST_AMT, 0), STATUS,
SALES_STAGE_ID, DECISION_DATE, LEAD_NUMBER, FREEZE_FLAG,
sales_methodology_id, sales_stage_id, customer_id, address_id,
owner_salesforce_id, owner_sales_group_id
FROM AS_LEADS_ALL
WHERE LEAD_ID = c_LEAD_ID
For Update NOWAIT;
select close_reason
from as_leads_all
where lead_id = p_lead_id;
select 'Y'
from as_leads_all
where lead_id = p_lead_id
and close_competitor_id is not null;
select 'Y'
from as_leads_all ld,
as_statuses_b st
where ld.status = st.status_code
and ld.lead_id = p_lead_id
and (( p_status_profile = 'BOTH' and
( st.OPP_OPEN_STATUS_FLAG <> 'Y' or st.FORECAST_ROLLUP_FLAG = 'Y')) OR
( p_status_profile = 'CLOSED' and st.OPP_OPEN_STATUS_FLAG <> 'Y') OR
( p_status_profile = 'FORECASTED' and st.OPP_OPEN_STATUS_FLAG <> 'Y') );
select employee_person_id
from as_salesforce_v
where salesforce_id = c_salesforce_id;
Select sales_credit_id, credit_type_id,credit_amount
From as_sales_credits
Where lead_id = p_lead_id;
Select status.win_loss_indicator,
status.forecast_rollup_flag
From as_statuses_vl status
Where status.status_code = p_status_code;
l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_header';
l_deleted_flag VARCHAR2(1);
l_last_update_date DATE;
l_update_count NUMBER;
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Update_opp_header';
SAVEPOINT UPDATE_OPP_HEADER_PVT;
AS_CALLOUT_PKG.Update_opp_header_BU(
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_identity_salesforce_id => p_identity_salesforce_id,
P_Header_Rec => l_Header_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail
-- relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
Fetch C_Get_opp_header into l_last_update_date, l_deleted_flag,
l_win_prob, l_old_tot_rev_opp_forecast_amt, l_status,
l_sales_stage_id, l_decision_date, l_lead_number, l_freeze_flag,
l_old_sales_methodology_id, l_old_sales_stage_id,
l_customer_id, l_address_id,
l_owner_salesforce_id, l_owner_sales_group_id;
IF (UPPER(l_deleted_flag) = 'Y')
THEN
AS_UTILITY_PVT.Set_Message(
p_module => l_module,
p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
p_msg_name => 'API_DELETED_OPP_HEADER');
l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
p_msg_name => 'API_MISSING_OPP_HEADER_UPDATE');
If (l_Header_rec.last_update_date is NULL or
l_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
-- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
p_msg_name => 'API_MISSING_LAST_UPDATE_DATE');
If (l_Header_rec.last_update_date <> l_last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
-- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
p_mode => AS_UTILITY_PVT.G_UPDATE,
p_opp_rec => l_Header_Rec1,
x_opp_rec => l_Header_Rec );
p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
P_Header_Rec => l_Header_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
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_Header_Rec.lead_id,
p_check_access_flag => 'Y',
p_identity_salesforce_id => p_identity_salesforce_id,
p_partner_cont_party_id => NULL,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_update_access_flag => l_access_flag);
'API_NO_UPDATE_PRIVILEGE');
,x_update_access_flag => l_access_flag
);
'Private API: Calling update table handler');
AS_LEADS_PKG.Update_Row(
p_LEAD_ID => l_Header_rec.LEAD_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => FND_API.G_MISS_DATE,
p_CREATED_BY => FND_API.G_MISS_NUM,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_REQUEST_ID => l_Header_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_Header_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_Header_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_Header_rec.PROGRAM_UPDATE_DATE,
p_LEAD_NUMBER => FND_API.G_MISS_CHAR, -- l_Header_rec.LEAD_NUMBER,
p_STATUS => l_HEADER_REC.STATUS_CODE,
p_CUSTOMER_ID => l_Header_rec.CUSTOMER_ID,
p_ADDRESS_ID => l_Header_rec.ADDRESS_ID,
p_SALES_STAGE_ID => l_Header_rec.SALES_STAGE_ID,
p_INITIATING_CONTACT_ID => l_Header_rec.INITIATING_CONTACT_ID,
p_CHANNEL_CODE => l_Header_rec.CHANNEL_CODE,
p_TOTAL_AMOUNT => l_Header_rec.TOTAL_AMOUNT,
p_CURRENCY_CODE => l_Header_rec.CURRENCY_CODE,
p_DECISION_DATE => l_Header_rec.DECISION_DATE,
p_WIN_PROBABILITY => l_Header_rec.WIN_PROBABILITY,
p_CLOSE_REASON => l_Header_rec.CLOSE_REASON,
p_CLOSE_COMPETITOR_CODE => l_Header_rec.CLOSE_COMPETITOR_CODE,
p_CLOSE_COMPETITOR => l_Header_rec.CLOSE_COMPETITOR,
p_CLOSE_COMMENT => l_Header_rec.CLOSE_COMMENT,
p_DESCRIPTION => l_Header_rec.DESCRIPTION,
p_RANK => l_Header_rec.RANK,
p_SOURCE_PROMOTION_ID => l_Header_rec.SOURCE_PROMOTION_ID,
p_END_USER_CUSTOMER_ID => l_Header_rec.END_USER_CUSTOMER_ID,
p_END_USER_ADDRESS_ID => l_Header_rec.END_USER_ADDRESS_ID,
p_OWNER_SALESFORCE_ID => l_header_rec.OWNER_SALESFORCE_ID,
p_OWNER_SALES_GROUP_ID => l_header_rec.OWNER_SALES_GROUP_ID,
--p_OWNER_ASSIGN_DATE => l_header_rec.OWNER_ASSIGN_DATE,
p_ORG_ID => l_Header_rec.ORG_ID,
p_NO_OPP_ALLOWED_FLAG => l_Header_rec.NO_OPP_ALLOWED_FLAG,
p_DELETE_ALLOWED_FLAG => l_Header_rec.DELETE_ALLOWED_FLAG,
p_ATTRIBUTE_CATEGORY => l_Header_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_Header_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_Header_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_Header_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_Header_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_Header_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_Header_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_Header_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_Header_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_Header_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_Header_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_Header_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_Header_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_Header_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_Header_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_Header_rec.ATTRIBUTE15,
p_PARENT_PROJECT => l_Header_rec.PARENT_PROJECT,
p_LEAD_SOURCE_CODE => l_Header_rec.LEAD_SOURCE_CODE,
p_ORIG_SYSTEM_REFERENCE => l_Header_rec.ORIG_SYSTEM_REFERENCE,
p_CLOSE_COMPETITOR_ID => l_Header_rec.CLOSE_COMPETITOR_ID,
p_END_USER_CUSTOMER_NAME => l_Header_rec.END_USER_CUSTOMER_NAME,
p_PRICE_LIST_ID => l_Header_rec.PRICE_LIST_ID,
p_DELETED_FLAG => l_Header_rec.DELETED_FLAG,
p_AUTO_ASSIGNMENT_TYPE => l_Header_rec.AUTO_ASSIGNMENT_TYPE,
p_PRM_ASSIGNMENT_TYPE => l_Header_rec.PRM_ASSIGNMENT_TYPE,
p_CUSTOMER_BUDGET => l_Header_rec.CUSTOMER_BUDGET,
p_METHODOLOGY_CODE => l_Header_rec.METHODOLOGY_CODE,
p_SALES_METHODOLOGY_ID => l_header_rec.SALES_METHODOLOGY_ID,
p_ORIGINAL_LEAD_ID => l_Header_rec.ORIGINAL_LEAD_ID,
p_DECISION_TIMEFRAME_CODE => l_Header_rec.DECISION_TIMEFRAME_CODE,
p_INC_PARTNER_RESOURCE_ID=>l_Header_rec.INCUMBENT_PARTNER_RESOURCE_ID,
p_INC_PARTNER_PARTY_ID => l_Header_rec.INCUMBENT_PARTNER_PARTY_ID,
p_OFFER_ID => l_Header_rec.OFFER_ID,
p_VEHICLE_RESPONSE_CODE => l_Header_rec.VEHICLE_RESPONSE_CODE,
p_BUDGET_STATUS_CODE => l_Header_rec.BUDGET_STATUS_CODE,
p_FOLLOWUP_DATE => l_Header_rec.FOLLOWUP_DATE,
p_PRM_EXEC_SPONSOR_FLAG => l_Header_rec.PRM_EXEC_SPONSOR_FLAG,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG=>l_Header_rec.PRM_PRJ_LEAD_IN_PLACE_FLAG,
p_PRM_IND_CLASSIFICATION_CODE =>
l_Header_rec.PRM_IND_CLASSIFICATION_CODE,
p_PRM_LEAD_TYPE => l_Header_rec.PRM_LEAD_TYPE,
p_FREEZE_FLAG => l_Header_rec.FREEZE_FLAG,
p_PRM_REFERRAL_CODE => l_Header_rec.PRM_REFERRAL_CODE);
UPDATE AS_LEAD_LINES_ALL
SET object_version_number = nvl(object_version_number,0) + 1, FORECAST_DATE = l_Header_rec.DECISION_DATE
--last_update_date = SYSDATE,
--last_updated_by = FND_GLOBAL.USER_ID,
--last_update_login = FND_GLOBAL.CONC_LOGIN_ID
WHERE lead_id = l_Header_rec.lead_id
AND rolling_forecast_flag = 'Y';
Select lead.win_probability, status.win_loss_indicator,
status.forecast_rollup_flag
Into l_win_probability, l_win_loss_indicator,
l_forecast_rollup_flag
From as_leads_all lead, as_statuses_vl status
Where lead_id = l_Header_rec.LEAD_ID
And lead.status = status.status_code(+);
l_win_loss_indicator, l_forecast_rollup_flag, 0, 'ON-UPDATE',
l_opp_worst_forecast_amount, l_opp_forecast_amount,
l_opp_best_forecast_amount)
THEN
l_tot_rev_opp_forecast_amt := 0;
curr_rec_sc_amt.credit_amount, 'ON-UPDATE',
l_opp_worst_forecast_amount, l_opp_forecast_amount,
l_opp_best_forecast_amount);
Update as_sales_credits
Set object_version_number = nvl(object_version_number, 0) + 1,
opp_worst_forecast_amount = l_opp_worst_forecast_amount,
opp_forecast_amount = l_opp_forecast_amount,
opp_best_forecast_amount = l_opp_best_forecast_amount
Where sales_credit_id = curr_rec_sc_amt.sales_credit_id;
UPDATE AS_LEADS_ALL
SET TOTAL_REVENUE_OPP_FORECAST_AMT = nvl(l_tot_rev_opp_forecast_amt,0)
WHERE lead_id = l_Header_rec.lead_id;
l_update_count := 0;
Select count(*) into l_count from as_sales_credits
where lead_id = l_Header_rec.LEAD_ID and
credit_type_id = l_forecast_credit_type_id;
Update as_sales_credits set opp_forecast_amount = l_opp_forecast_amount
where lead_id = l_Header_rec.LEAD_ID AND
credit_type_id = l_forecast_credit_type_id;
l_update_count := SQL%ROWCOUNT;
Update as_sales_credits
Set opp_forecast_amount =
nvl(l_tot_rev_opp_forecast_amt, 0) * (nvl(opp_forecast_amount, 0)/l_old_tot_rev_opp_forecast_amt)
where lead_id = l_Header_rec.LEAD_ID AND
credit_type_id = l_forecast_credit_type_id;
l_update_count := SQL%ROWCOUNT;
IF l_update_count = 0 THEN
l_tot_rev_opp_forecast_amt := NULL;
UPDATE AS_LEADS_ALL
SET TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_rev_opp_forecast_amt
WHERE lead_id = l_Header_rec.lead_id;
update as_accesses_all
set object_version_number = nvl(object_version_number,0) + 1, owner_flag = null,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.CONC_LOGIN_ID
where lead_id = l_Header_rec.lead_id;
update as_accesses_all
set object_version_number = nvl(object_version_number,0) + 1, owner_flag = 'Y',
freeze_flag = 'Y',
team_leader_flag = 'Y', -- Fix for bug# 4196657
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.CONC_LOGIN_ID
where access_id in
( select min(access_id)
from as_accesses_all
where lead_id = l_Header_rec.lead_id
and sales_group_id = l_header_rec.owner_sales_group_id
and salesforce_id = l_header_rec.owner_salesforce_id );
l_Sales_Team_Rec.last_update_date := SYSDATE;
l_Sales_Team_Rec.last_updated_by := FND_GLOBAL.USER_ID;
l_Sales_Team_Rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
UPDATE AS_ACCESSES_ALL
SET object_version_number = nvl(object_version_number,0) + 1, OWNER_FLAG = 'Y'
WHERE access_id = l_access_id;
update as_accesses_all
set object_version_number = nvl(object_version_number,0) + 1, owner_flag = null,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
last_update_login = FND_GLOBAL.CONC_LOGIN_ID
where lead_id = l_Header_rec.lead_id;
p_msg_name => 'API_NO_UPDATE_SALES_METHODOLOGY');
Update_Competitor_Products(
p_LEAD_ID => l_header_rec.LEAD_ID,
p_STATUS_CODE => l_header_rec.STATUS_CODE,
x_return_status => x_return_status);
'Update competitor Products fail');
AS_CALLOUT_PKG.Update_opp_header_AU(
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_identity_salesforce_id => p_identity_salesforce_id,
P_Header_Rec => l_Header_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail
-- relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Update_opp_header;
PROCEDURE Delete_opp_header(
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_lead_id IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
Cursor C_Get_opp_header(c_LEAD_ID Number) IS
Select LAST_UPDATE_DATE, FREEZE_FLAG
FROM AS_LEADS
WHERE LEAD_ID = c_LEAD_ID
For Update NOWAIT;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_header';
l_last_update_date DATE;
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Delete_opp_header';
SAVEPOINT DELETE_OPP_HEADER_PVT;
AS_CALLOUT_PKG.Delete_opp_header_BU(
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_identity_salesforce_id => p_identity_salesforce_id,
P_Header_Rec => p_Header_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail
-- relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Open Cursor to Select');
Fetch C_Get_opp_header into l_last_update_date, l_freeze_flag;
p_msg_name => 'API_MISSING_OPP_HEADER_UPDATE');
If (p_Header_rec.last_update_date is NULL or
p_Header_rec.last_update_date = FND_API.G_MISS_Date ) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
-- FND_MESSAGE.Set_Name('AS', 'API_MISSING_ID');
p_msg_name => 'API_MISSING_LAST_UPDATE_DATE');
If (p_Header_rec.last_update_date <> l_last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
THEN
-- FND_MESSAGE.Set_Name('AS', 'API_RECORD_CHANGED');
p_validation_mode => AS_UTILITY_PVT.G_UPDATE,
P_Header_Rec => p_Header_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
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 => P_lead_id,
p_check_access_flag => 'Y',
p_identity_salesforce_id => p_identity_salesforce_id,
p_partner_cont_party_id => NULL,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_update_access_flag => l_access_flag);
'API_NO_UPDATE_PRIVILEGE');
l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
'Private API: Calling update table handler');
AS_LEADS_PKG.Update_Row(
p_LEAD_ID => p_LEAD_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => FND_GLOBAL.USER_ID,
p_CREATION_DATE => FND_API.G_MISS_DATE,
p_CREATED_BY => FND_API.G_MISS_NUM,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_REQUEST_ID => FND_API.G_MISS_NUM,
p_PROGRAM_APPLICATION_ID => FND_API.G_MISS_NUM,
p_PROGRAM_ID => FND_API.G_MISS_NUM,
p_PROGRAM_UPDATE_DATE => FND_API.G_MISS_DATE,
p_LEAD_NUMBER => FND_API.G_MISS_CHAR,
p_STATUS => FND_API.G_MISS_CHAR,
p_CUSTOMER_ID => FND_API.G_MISS_NUM,
p_ADDRESS_ID => FND_API.G_MISS_NUM,
p_SALES_STAGE_ID => FND_API.G_MISS_NUM,
p_INITIATING_CONTACT_ID => FND_API.G_MISS_NUM,
p_CHANNEL_CODE => FND_API.G_MISS_CHAR,
p_TOTAL_AMOUNT => FND_API.G_MISS_NUM,
p_CURRENCY_CODE => FND_API.G_MISS_CHAR,
p_DECISION_DATE => FND_API.G_MISS_DATE,
p_WIN_PROBABILITY => FND_API.G_MISS_NUM,
p_CLOSE_REASON => FND_API.G_MISS_CHAR,
p_CLOSE_COMPETITOR_CODE => FND_API.G_MISS_CHAR,
p_CLOSE_COMPETITOR => FND_API.G_MISS_CHAR,
p_CLOSE_COMMENT => FND_API.G_MISS_CHAR,
p_DESCRIPTION => FND_API.G_MISS_CHAR,
p_RANK => FND_API.G_MISS_CHAR,
p_SOURCE_PROMOTION_ID => FND_API.G_MISS_NUM,
p_END_USER_CUSTOMER_ID => FND_API.G_MISS_NUM,
p_END_USER_ADDRESS_ID => FND_API.G_MISS_NUM,
p_OWNER_SALESFORCE_ID => FND_API.G_MISS_NUM,
p_OWNER_SALES_GROUP_ID => FND_API.G_MISS_NUM,
--p_OWNER_ASSIGN_DATE => FND_API.G_MISS_DATE,
p_ORG_ID => FND_API.G_MISS_NUM,
p_NO_OPP_ALLOWED_FLAG => FND_API.G_MISS_CHAR,
p_DELETE_ALLOWED_FLAG => FND_API.G_MISS_CHAR,
p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
p_PARENT_PROJECT => FND_API.G_MISS_CHAR,
p_LEAD_SOURCE_CODE => FND_API.G_MISS_CHAR,
p_ORIG_SYSTEM_REFERENCE => FND_API.G_MISS_CHAR,
p_CLOSE_COMPETITOR_ID => FND_API.G_MISS_NUM,
p_END_USER_CUSTOMER_NAME => FND_API.G_MISS_CHAR,
p_PRICE_LIST_ID => FND_API.G_MISS_NUM,
p_DELETED_FLAG => 'Y',
p_AUTO_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
p_PRM_ASSIGNMENT_TYPE => FND_API.G_MISS_CHAR,
p_CUSTOMER_BUDGET => FND_API.G_MISS_NUM,
p_METHODOLOGY_CODE => FND_API.G_MISS_CHAR,
p_SALES_METHODOLOGY_ID => FND_API.G_MISS_NUM,
p_ORIGINAL_LEAD_ID => FND_API.G_MISS_NUM,
p_DECISION_TIMEFRAME_CODE => FND_API.G_MISS_CHAR,
p_INC_PARTNER_RESOURCE_ID=>FND_API.G_MISS_NUM,
p_INC_PARTNER_PARTY_ID => FND_API.G_MISS_NUM,
p_OFFER_ID => FND_API.G_MISS_NUM,
p_VEHICLE_RESPONSE_CODE => FND_API.G_MISS_CHAR,
p_BUDGET_STATUS_CODE => FND_API.G_MISS_CHAR,
p_FOLLOWUP_DATE => FND_API.G_MISS_DATE,
p_PRM_EXEC_SPONSOR_FLAG => FND_API.G_MISS_CHAR,
p_PRM_PRJ_LEAD_IN_PLACE_FLAG=>FND_API.G_MISS_CHAR,
p_PRM_IND_CLASSIFICATION_CODE =>
FND_API.G_MISS_CHAR,
p_PRM_LEAD_TYPE => FND_API.G_MISS_CHAR,
p_FREEZE_FLAG => FND_API.G_MISS_CHAR,
p_PRM_REFERRAL_CODE => FND_API.G_MISS_CHAR);
AS_CALLOUT_PKG.Delete_opp_header_AU(
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_identity_salesforce_id => p_identity_salesforce_id,
P_Header_Rec => P_Header_Rec,
-- Hint: Add detail tables as parameter lists if it's master-detail
-- relationship.
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
End Delete_opp_header;
SELECT 'X'
FROM as_leads
WHERE lead_id = c_Lead_Id;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- validate NOT NULL column
IF (p_LEAD_ID is NULL) or (p_LEAD_ID = FND_API.G_MISS_NUM)
THEN
-- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
-- 'Private API: Violate NOT NULL constraint(LEAD_ID)');
SELECT 'X'
FROM as_leads
WHERE lead_number = c_lead_number;
SELECT 'X'
FROM as_statuses_b
WHERE status_code = c_status
and enabled_flag = 'Y'
and opp_flag = 'Y';
SELECT 'X'
FROM hr_operating_units hr
WHERE hr.organization_id= P_ORG_ID
and mo_global.check_access(hr.organization_id) = 'Y';
SELECT 'X'
FROM as_sales_stages_all_b
WHERE sales_stage_id = c_sales_stage_id
-- ffang 091200 for bug 1403865
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
and enabled_flag = 'Y';
SELECT 'X'
FROM OE_LOOKUPS
WHERE lookup_code = c_channel_code
AND lookup_type = 'SALES_CHANNEL'
AND nvl(start_date_active, sysdate) <= sysdate
AND nvl(end_date_active, sysdate) >= sysdate
AND enabled_flag = 'Y';
SELECT 'X'
FROM fnd_currencies
WHERE currency_code = c_currency_code
-- ffang 091200 for bug 1403865
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
and enabled_flag = 'Y';
SELECT 'X'
FROM as_forecast_prob
WHERE probability_value = c_Win_Prob
-- ffang 091200 for bug 1403865
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate
and enabled_flag = 'Y';
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_CLOSE_REASON;
SELECT 'X'
FROM ams_source_codes
WHERE source_code_id = c_Source_Code_ID
-- and active_flag = 'Y'
and ARC_SOURCE_CODE_FOR <> 'OFFR';
PROCEDURE Validate_DELETE_ALLOWED_FLAG (
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Validation_mode IN VARCHAR2,
P_DELETE_ALLOWED_FLAG IN VARCHAR2,
X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_DELETE_ALLOWED_FLAG';
IF (p_DELETE_ALLOWED_FLAG is NOT NULL) and
(p_DELETE_ALLOWED_FLAG <> FND_API.G_MISS_CHAR)
THEN
IF (UPPER(p_DELETE_ALLOWED_FLAG) <> 'Y') and
(UPPER(p_DELETE_ALLOWED_FLAG) <> 'N')
THEN
-- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
-- 'Private API: DELETE_ALLOWED_FLAG is invalid');
p_token1_value => p_DELETE_ALLOWED_FLAG );
END Validate_DELETE_ALLOWED_FLAG;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_LEAD_SOURCE_CODE
and enabled_flag = 'Y';
SELECT 'X'
FROM qp_price_lists_v
WHERE price_list_id = c_Price_List_Id
and currency_code = c_Currency_Code
and nvl(start_date_active, sysdate) <= sysdate
and nvl(end_date_active, sysdate) >= sysdate;
PROCEDURE Validate_DELETED_FLAG (
P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
P_Validation_mode IN VARCHAR2,
P_DELETED_FLAG IN VARCHAR2,
X_Item_Property_Rec OUT NOCOPY AS_UTILITY_PUB.ITEM_PROPERTY_REC_TYPE,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_debug BOOLEAN := FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldhpv.Validate_DELETED_FLAG';
IF (p_DELETED_FLAG is NOT NULL) and
(p_DELETED_FLAG <> FND_API.G_MISS_CHAR)
THEN
IF (p_DELETED_FLAG <> 'Y') and (p_DELETED_FLAG <> 'N')
THEN
-- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
-- 'Private API: DELETED_FLAG is invalid');
p_msg_name => 'API_INVALID_DELETED_FLAG',
p_token1 => 'VALUE',
p_token1_value => p_DELETED_FLAG );
END Validate_DELETED_FLAG;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_METHODOLOGY_CODE
and enabled_flag = 'Y';
SELECT 'X'
FROM as_leads_all
WHERE lead_id = c_original_lead_id;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_DECISION_TIMEFRAME_CODE
and enabled_flag = 'Y';
SELECT 'X'
FROM ams_source_codes
WHERE source_code_id = c_offer_id
and ARC_SOURCE_CODE_FOR = 'OFFR';
SELECT 'X'
FROM fnd_lookup_values
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code
and enabled_flag = 'Y'
and (end_date_active > SYSDATE OR end_date_active IS NULL);
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code;
select STATUS
from hz_parties
where party_id = p_customer_id;
SELECT 'X'
FROM as_sf_ptr_v
WHERE partner_customer_id = c_inc_parn_party_id;
p_validation_mode = AS_UTILITY_PVT.G_UPDATE THEN
NULL;
SELECT 'X'
FROM jtf_rs_groups_b grp
WHERE NVL(GRP.end_date_active,SYSDATE) >= SYSDATE
AND grp.group_id = p_SALESGROUP_ID ;
SELECT 'X'
FROM jtf_rs_group_members GRPMEM
WHERE resource_id = p_SALESREP_ID
AND group_id = p_SALESGROUP_ID
AND delete_flag = 'N'
AND EXISTS
(SELECT 'X'
FROM jtf_rs_role_relations REL
WHERE role_resource_type = 'RS_GROUP_MEMBER'
AND delete_flag = 'N'
AND sysdate between REL.start_date_active and nvl(REL.end_date_active,sysdate)
AND REL.role_resource_id = GRPMEM.group_member_id
AND role_id IN (SELECT role_id FROM jtf_rs_roles_b WHERE role_type_code IN ('SALES','TELESALES','FIELDSALES','PRM')));
SELECT 'X'
FROM jtf_rs_resource_extns res,
jtf_rs_role_relations rrel,
jtf_rs_roles_b role
WHERE sysdate between res.start_date_active and nvl(res.end_date_active,sysdate)
AND sysdate between rrel.start_date_active and nvl(rrel.end_date_active,sysdate)
AND res.resource_id = rrel.role_resource_id
AND rrel.role_resource_type = 'RS_INDIVIDUAL'
AND rrel.role_id = role.role_id
AND role.role_type_code IN ('SALES', 'TELESALES', 'FIELDSALES', 'PRM')
AND role.admin_flag = 'N'
AND res.resource_id = p_SALESREP_ID
AND res.category = 'EMPLOYEE';
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code;
SELECT 'X'
FROM as_sf_ptr_v
WHERE SALESFORCE_ID = c_INC_PARTNER_RESOURCE_ID;
SELECT 'X'
FROM as_lookups
WHERE lookup_type = c_lookup_type
and lookup_code = c_Lookup_Code;
SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)
FROM as_sales_stages_all_b
WHERE sales_stage_id = c_Sales_Stage_Id;
SELECT nvl(min_win_probability, 0), nvl(max_win_probability, 100)
FROM as_sales_meth_stage_map
WHERE sales_methodology_id = c_SALES_METHODOLOGY_ID
AND sales_stage_id = c_SALES_STAGE_ID;
SELECT opp_open_status_flag
FROM as_statuses_b
WHERE STATUS_CODE = c_STATUS_CODE
and opp_flag = 'Y'
and ENABLED_FLAG = 'Y';
'Validate_DELETE_ALLOWED_FLAG');
Validate_DELETE_ALLOWED_FLAG(
p_init_msg_list => FND_API.G_FALSE,
p_validation_mode => p_validation_mode,
p_DELETE_ALLOWED_FLAG => P_Header_Rec.DELETE_ALLOWED_FLAG,
x_item_property_rec => l_item_property_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
'Validate_DELETED_FLAG');
Validate_DELETED_FLAG(
p_init_msg_list => FND_API.G_FALSE,
p_validation_mode => p_validation_mode,
p_DELETED_FLAG => P_Header_Rec.DELETED_FLAG,
x_item_property_rec => l_item_property_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);