The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Backupdate_Header(
p_lead_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2
)
IS
CURSOR C_line_total IS
SELECT sum(total_amount) line_total
FROM as_lead_lines
WHERE lead_id = p_lead_id;
SELECT nvl(sum(OPP_FORECAST_AMOUNT),0) credit_total
FROM as_sales_credits
WHERE lead_id = p_lead_id
AND credit_type_id = FND_PROFILE.VALUE('AS_FORECAST_CREDIT_TYPE_ID');
UPDATE as_leads_all
SET total_amount = nvl(l_line_total, 0),
TOTAL_REVENUE_OPP_FORECAST_AMT = l_tot_revenue_opp_forecast_amt, -- Added for ASNB
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
-- creation_Date = SYSDATE, -- solin, for bug 1579950
-- created_by = FND_GLOBAL.USER_ID, -- solin, for bug 1579950
last_update_login = FND_GLOBAL.CONC_LOGIN_ID
WHERE lead_id = p_lead_id;
END Backupdate_Header;
Update as_sales_credits
Set opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
opp_worst_forecast_amount),
opp_forecast_amount = nvl(l_opp_forecast_amount,
opp_forecast_amount),
opp_best_forecast_amount = nvl(l_opp_best_forecast_amount,
opp_best_forecast_amount)
where lead_line_id = p_lead_line_id AND
credit_type_id = l_forecast_credit_type_id;
SELECT sales_credit_id,
credit_amount,
credit_percent,
credit_type_id
FROM as_sales_credits
WHERE lead_line_id = c_lead_line_id;
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 = p_lead_id
And lead.status = status.status_code(+);
l_forecast_rollup_flag, l_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, credit_percent = l_credit_percent,
credit_amount = l_credit_amount,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
opp_worst_forecast_amount),
opp_forecast_amount = nvl(l_opp_forecast_amount,
opp_forecast_amount),
opp_best_forecast_amount = nvl(l_opp_best_forecast_amount,
opp_best_forecast_amount)
WHERE sales_credit_id = sc_rec.sales_credit_id;
l_forecast_rollup_flag, l_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, credit_percent = l_credit_percent,
credit_amount = l_credit_amount,
last_update_date = SYSDATE,
last_updated_by = FND_GLOBAL.USER_ID,
opp_worst_forecast_amount = nvl(l_opp_worst_forecast_amount,
opp_worst_forecast_amount),
opp_forecast_amount = nvl(l_opp_forecast_amount,
opp_forecast_amount),
opp_best_forecast_amount = nvl(l_opp_best_forecast_amount,
opp_best_forecast_amount)
WHERE sales_credit_id = sc_rec.sales_credit_id;
SELECT 'X'
FROM as_interest_types_b
WHERE Interest_Type_Id = X_Int_Type_Id;
SELECT 'X'
FROM As_Interest_Codes_B Pic
WHERE Pic.Interest_Type_Id = X_Int_Type_Id
and Pic.Interest_Code_Id = X_Int_Code_Id
and Pic.Parent_Interest_Code_Id Is Null;
SELECT 'X'
FROM As_Interest_Codes_B Sic
WHERE Sic.Interest_Type_Id = X_Int_Type_Id
And Sic.Interest_Code_Id = X_Sec_Int_Code_Id
And Sic.Parent_Interest_Code_Id = X_Int_Code_Id;
SELECT 'X'
FROM mtl_system_items
WHERE inventory_item_id = c_Inventory_Item_Id
and organization_id = c_Organization_Id;
select 'x'
from as_inv_item_lov_v
where interest_type_id = c_interest_type_id and
(primary_interest_code_id = c_primary_interest_code_id or
c_primary_interest_code_id is null) and
(secondary_interest_code_id = c_secondary_interest_code_id or
c_secondary_interest_code_id is null)and
inventory_item_id = c_inventory_item_id and
organization_id = c_organization_id;
select category_id,category_set_id from mtl_item_categories
where category_set_id=
(select category_set_id
from mtl_default_category_sets
where functional_area_id=G_FUNCTIONAL_AREA)
and organization_id=l_organization_id
and inventory_item_id=l_item_id;
select product_category_id, product_cat_set_id
from AS_INTEREST_TYPES_B
where interest_type_id = c_interest_type_id;
select product_category_id, product_cat_set_id
from AS_INTEREST_CODES_B
where interest_code_id = c_interest_code_id
and interest_type_id = c_interest_type_id;
select product_category_id, product_cat_set_id
from AS_INTEREST_CODES_B
where interest_code_id = c_sec_interest_code_id
and interest_type_id = c_interest_type_id
and parent_interest_code_id = c_pri_interest_code_id;
SELECT group_id
FROM JTF_RS_GROUP_MEMBERS
WHERE resource_id = p_resource_id
ORDER BY GROUP_ID;
SELECT FREEZE_FLAG
FROM AS_LEADS
WHERE LEAD_ID = c_LEAD_ID;
select decision_date
from as_leads_all
where lead_id = c_lead_id;
select org_id
from as_leads_all
where lead_id = p_lead_id;
SELECT SOURCE_PROMOTION_ID
FROM AS_OPPORTUNITIES_V
WHERE LEAD_ID = c_LEAD_ID;
SELECT OFFER_ID
FROM AS_OPPORTUNITIES_V
WHERE LEAD_ID = c_LEAD_ID;
select 'Y'
from as_fc_salesforce_v sf
where sf.sales_group_id = p_sales_group_id
and sf.salesforce_id = p_salesforce_id;
select gm1.group_id
from jtf_rs_group_members gm1,
jtf_rs_groups_vl gp1,
jtf_rs_groups_vl gp
where gm1.resource_id = c_resource_id
and gp1.group_id = gm1.group_id
and gp.group_name||'-iSD' = gp1.group_name
and gp.group_id = c_sales_group_id;
l_update_access_flag VARCHAR2(1);
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_line_tbl(1).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 );
'Private API: has_updateOpportunityAccess fail');
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');
'Private API: has_updateOpportunityAccess succeed');
l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
AS_LEAD_LINES_PKG.Insert_Row(
px_LEAD_LINE_ID => l_LEAD_LINE_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_Line_Rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_Line_Rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_Line_Rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_Line_Rec.PROGRAM_UPDATE_DATE,
p_LEAD_ID => l_Line_Rec.LEAD_ID,
p_INTEREST_TYPE_ID => l_Line_Rec.INTEREST_TYPE_ID,
p_PRIMARY_INTEREST_CODE_ID => l_Line_Rec.PRIMARY_INTEREST_CODE_ID,
p_SECONDARY_INTEREST_CODE_ID =>
l_Line_Rec.SECONDARY_INTEREST_CODE_ID,
p_INTEREST_STATUS_CODE => l_Line_Rec.INTEREST_STATUS_CODE,
p_INVENTORY_ITEM_ID => l_Line_Rec.INVENTORY_ITEM_ID,
p_ORGANIZATION_ID => l_Line_Rec.ORGANIZATION_ID,
p_UOM_CODE => l_Line_Rec.UOM_CODE,
p_QUANTITY => l_Line_Rec.QUANTITY,
p_TOTAL_AMOUNT => l_Line_Rec.TOTAL_AMOUNT,
p_SALES_STAGE_ID => l_Line_Rec.SALES_STAGE_ID,
p_WIN_PROBABILITY => l_Line_Rec.WIN_PROBABILITY,
p_DECISION_DATE => l_Line_Rec.DECISION_DATE,
p_ORG_ID => l_Line_Rec.ORG_ID,
p_ATTRIBUTE_CATEGORY => l_Line_Rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_Line_Rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_Line_Rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_Line_Rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_Line_Rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_Line_Rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_Line_Rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_Line_Rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_Line_Rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_Line_Rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_Line_Rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_Line_Rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_Line_Rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_Line_Rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_Line_Rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_Line_Rec.ATTRIBUTE15,
p_STATUS_CODE => l_Line_Rec.STATUS_CODE,
p_CHANNEL_CODE => l_Line_Rec.CHANNEL_CODE,
p_QUOTED_LINE_FLAG => l_Line_Rec.QUOTED_LINE_FLAG,
p_PRICE => l_Line_Rec.PRICE,
p_PRICE_VOLUME_MARGIN => l_Line_Rec.PRICE_VOLUME_MARGIN,
p_SHIP_DATE => l_Line_Rec.SHIP_DATE,
p_FORECAST_DATE => l_Line_Rec.FORECAST_DATE,
p_ROLLING_FORECAST_FLAG => l_Line_Rec.ROLLING_FORECAST_FLAG,
p_SOURCE_PROMOTION_ID => l_Line_Rec.SOURCE_PROMOTION_ID,
p_OFFER_ID => l_Line_Rec.OFFER_ID,
p_PRODUCT_CATEGORY_ID => l_Line_Rec.PRODUCT_CATEGORY_ID,
p_PRODUCT_CAT_SET_ID => l_Line_Rec.PRODUCT_CAT_SET_ID);
l_sales_credit_rec.last_update_date := SYSDATE;
l_sales_credit_rec.last_updated_by := FND_GLOBAL.USER_ID;
l_sales_credit_rec.last_update_login := FND_GLOBAL.CONC_LOGIN_ID;
Backupdate_Header(
p_lead_id => p_header_rec.lead_id,
x_return_status => x_return_status);
'Private API: Create_Opp_line: Backupdate_header fail' );
PROCEDURE Update_opp_lines(
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,
-- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
P_Partner_Cont_Party_id IN NUMBER,
P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
Cursor C_Get_opp_line(c_LEAD_LINE_ID Number) IS
Select LAST_UPDATE_DATE, TOTAL_AMOUNT
From AS_LEAD_LINES
WHERE LEAD_LINE_ID = c_LEAD_LINE_ID
For Update NOWAIT;
SELECT FREEZE_FLAG
FROM AS_LEADS
WHERE LEAD_ID = c_LEAD_ID;
select decision_date
from as_leads_all
where lead_id = c_lead_id;
l_api_name CONSTANT VARCHAR2(30) := 'Update_opp_lines';
l_last_update_date DATE;
l_update_access_flag VARCHAR2(1);
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Update_opp_lines';
SAVEPOINT UPDATE_OPP_LINES_PVT;
AS_CALLOUT_PKG.Update_opp_lines_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_Line_Rec => P_Line_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_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_line_tbl(1).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 );
'has_updateOpportunityAccess fail');
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');
l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
'Private API: - Open Cursor to Select');
Fetch C_Get_opp_line into l_last_update_date, l_line_amount_old;
FND_MESSAGE.Set_Name('AS', 'API_MISSING_UPDATE_TARGET');
If (l_Line_rec.last_update_date is NULL or
l_Line_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');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (l_Line_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_Line_Rec => l_Line_Rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
'Private API: Calling update table handler');
AS_LEAD_LINES_PKG.Update_Row(
p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_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_Line_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_Line_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_Line_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_Line_rec.PROGRAM_UPDATE_DATE,
p_LEAD_ID => l_Line_rec.LEAD_ID,
p_INTEREST_TYPE_ID => l_Line_rec.INTEREST_TYPE_ID,
p_PRIMARY_INTEREST_CODE_ID => l_Line_rec.PRIMARY_INTEREST_CODE_ID,
p_SECONDARY_INTEREST_CODE_ID =>
l_Line_rec.SECONDARY_INTEREST_CODE_ID,
p_INTEREST_STATUS_CODE => l_Line_rec.INTEREST_STATUS_CODE,
p_INVENTORY_ITEM_ID => l_Line_rec.INVENTORY_ITEM_ID,
p_ORGANIZATION_ID => l_Line_rec.ORGANIZATION_ID,
p_UOM_CODE => l_Line_rec.UOM_CODE,
p_QUANTITY => l_Line_rec.QUANTITY,
p_TOTAL_AMOUNT => l_Line_rec.TOTAL_AMOUNT,
p_SALES_STAGE_ID => l_Line_rec.SALES_STAGE_ID,
p_WIN_PROBABILITY => l_Line_rec.WIN_PROBABILITY,
p_DECISION_DATE => l_Line_rec.DECISION_DATE,
p_ORG_ID => l_Line_rec.ORG_ID,
p_ATTRIBUTE_CATEGORY => l_Line_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_Line_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_Line_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_Line_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_Line_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_Line_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_Line_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_Line_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_Line_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_Line_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_Line_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_Line_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_Line_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_Line_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_Line_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_Line_rec.ATTRIBUTE15,
p_STATUS_CODE => l_Line_rec.STATUS_CODE,
p_CHANNEL_CODE => l_Line_rec.CHANNEL_CODE,
p_QUOTED_LINE_FLAG => l_Line_rec.QUOTED_LINE_FLAG,
p_PRICE => l_Line_rec.PRICE,
p_PRICE_VOLUME_MARGIN => l_Line_rec.PRICE_VOLUME_MARGIN,
p_SHIP_DATE => l_Line_rec.SHIP_DATE,
p_FORECAST_DATE => l_Line_Rec.FORECAST_DATE,
p_ROLLING_FORECAST_FLAG => l_Line_Rec.ROLLING_FORECAST_FLAG,
p_SOURCE_PROMOTION_ID => l_Line_rec.SOURCE_PROMOTION_ID,
p_OFFER_ID => l_Line_rec.OFFER_ID,
p_PRODUCT_CATEGORY_ID => l_Line_Rec.PRODUCT_CATEGORY_ID,
p_PRODUCT_CAT_SET_ID => l_Line_Rec.PRODUCT_CAT_SET_ID);
Backupdate_Header(
p_lead_id => p_header_rec.lead_id,
x_return_status => x_return_status);
AS_CALLOUT_PKG.Update_opp_lines_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_Line_Rec => P_Line_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_lines;
PROCEDURE Delete_opp_lines(
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,
-- Suresh Mahalingam: Removed init to FND_API.G_MISS_NUM to fix GSCC warning
P_Partner_Cont_Party_id IN NUMBER,
P_Line_Tbl IN AS_OPPORTUNITY_PUB.Line_Tbl_Type,
P_Header_Rec IN AS_OPPORTUNITY_PUB.Header_Rec_Type,
X_LINE_OUT_TBL OUT NOCOPY AS_OPPORTUNITY_PUB.Line_out_Tbl_type,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
CURSOR C_sales_credits(c_lead_line_id NUMBER) IS
SELECT sales_credit_id
from as_sales_credits
WHERE lead_line_id = c_lead_line_id;
SELECT lead_decision_factor_id
from as_lead_decision_factors
WHERE lead_line_id = c_lead_line_id;
SELECT lead_competitor_prod_id
from as_lead_comp_products
WHERE lead_line_id = c_lead_line_id;
SELECT FREEZE_FLAG
FROM AS_LEADS
WHERE LEAD_ID = c_LEAD_ID;
l_api_name CONSTANT VARCHAR2(30) := 'Delete_opp_lines';
l_update_access_flag VARCHAR2(1);
l_module CONSTANT VARCHAR2(255) := 'as.plsql.ldlpv.Delete_opp_lines';
SAVEPOINT DELETE_OPP_LINES_PVT;
AS_CALLOUT_PKG.Delete_opp_lines_BD(
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_Line_Rec => P_Line_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_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_line_tbl(1).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 );
'has_updateOpportunityAccess fail');
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');
l_allow_flag := NVL(FND_PROFILE.VALUE('AS_ALLOW_UPDATE_FROZEN_OPP'),'Y');
'Private API: Calling delete table handler');
AS_LEAD_LINES_PKG.Delete_Row(
p_LEAD_LINE_ID => l_Line_rec.LEAD_LINE_ID);
AS_SALES_CREDITS_PKG.Delete_Row(
p_SALES_CREDIT_ID => sc_c.sales_credit_id );
AS_LEAD_DECISION_FACTORS_PKG.Delete_Row(
p_LEAD_DECISION_FACTOR_ID => df_c.lead_decision_factor_id );
AS_LEAD_COMP_PRODUCTS_PKG.Delete_Row(
p_LEAD_COMPETITOR_PROD_ID => cp_c.lead_competitor_prod_id );
Backupdate_Header(
p_lead_id => p_header_rec.lead_id,
x_return_status => x_return_status);
AS_CALLOUT_PKG.Delete_opp_lines_AD(
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_Line_Rec => P_Line_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_lines;
SELECT 'X'
FROM as_lead_lines
WHERE lead_line_id = c_Lead_Line_Id;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- validate NOT NULL column
IF (p_LEAD_LINE_ID is NULL) or (p_LEAD_LINE_ID = FND_API.G_MISS_NUM)
THEN
IF l_debug THEN
AS_UTILITY_PVT.Debug_Message(l_module, FND_MSG_PUB.G_MSG_LVL_ERROR,
'Private API: Violate NOT NULL constraint(LEAD_LINE_ID)');
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;
SELECT 'X'
FROM as_leads
WHERE lead_id = c_Lead_Id;
SELECT 'X'
FROM as_interest_types_all
WHERE interest_type_id = c_interest_type_id;
SELECT 'X'
FROM as_interest_codes_v
WHERE interest_code_id = c_primary_interest_code_id;
SELECT 'X'
FROM as_interest_codes_v
WHERE interest_code_id = C_S_INTEREST_code_id;
SELECT PRODUCT_CATEGORY_ID, PRODUCT_CAT_SET_ID
FROM AS_LEAD_LINES_ALL
WHERE LEAD_LINE_ID = l_lead_line_id;
SELECT 'X'
FROM ENI_PROD_DEN_HRCHY_PARENTS_V
WHERE Category_Id = X_Product_Category_Id
and Category_Set_Id = X_Product_Cat_Set_Id;
SELECT 'X'
FROM ENI_PROD_DEN_HRCHY_PARENTS_V
WHERE Category_Id = X_Product_Category_Id
and Category_Set_Id = X_Product_Cat_Set_Id
and Purchase_Interest = 'Y'
and ((Disable_Date is null) or (Disable_Date > SYSDATE));
SELECT 'X'
FROM mtl_system_items
WHERE inventory_item_id = c_inventory_item_id;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_ORGANIZATION_ID <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
SELECT 'X'
FROM mtl_units_of_measure
WHERE uom_code = c_uom_code;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_QUANTITY <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_TOTAL_AMOUNT <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRICE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_PRICE_VOLUME_MARGIN <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
ELSIF(p_validation_mode = AS_UTILITY_PVT.G_UPDATE)
THEN
-- Hint: Validate data
-- IF p_SHIP_DATE <> G_MISS_CHAR
-- verify if data is valid
-- if data is not valid : x_return_status := FND_API.G_RET_STS_ERROR;
SELECT 'X'
FROM as_lead_lines
WHERE lead_line_id = c_o_opportunity_line_id;
SELECT 'X'
FROM ams_p_source_codes_v
WHERE source_code_id = c_Source_Code_ID
--AND status in ('ACTIVE', 'ONHOLD', 'COMPLETED')
-- Fix for Bug 3093911 (Base Enh No: 2824485).
-- Condition changed to include One Off Events.
AND source_type <> 'OFFR';
SELECT 'X'
FROM ams_p_source_codes_v a
WHERE a.source_type = 'OFFR'
AND sysdate between nvl(a.start_date, sysdate-1)
and nvl(a.end_date, sysdate+1)
--AND a.status = 'ACTIVE'
AND a.source_code_id = c_OFFER_ID;
SELECT 'X'
FROM mtl_system_items
WHERE inventory_item_id = c_Inventory_Item_Id
and organization_id = c_Organization_Id;
select 'x'
FROM
MTL_ITEM_CATEGORIES MIC,
MTL_SYSTEM_ITEMS_VL ITEMS,
ENI_PROD_DEN_HRCHY_PARENTS_V P
WHERE
MIC.INVENTORY_ITEM_ID = ITEMS.INVENTORY_ITEM_ID AND
MIC.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID AND
MIC.CATEGORY_ID = P.CATEGORY_ID AND
MIC.CATEGORY_SET_ID = P.CATEGORY_SET_ID AND
P.LANGUAGE = userenv('LANG') AND
(P.DISABLE_DATE is null OR P.DISABLE_DATE > SYSDATE) AND
P.PURCHASE_INTEREST = 'Y' AND
MIC.CATEGORY_ID = c_product_category_id AND
MIC.CATEGORY_SET_ID = c_product_cat_set_id AND
MIC.INVENTORY_ITEM_ID = c_inventory_item_id AND
MIC.ORGANIZATION_ID = c_organization_id;