[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select count(*) yes_shared_cart
from ibe_sh_quote_access
where quote_header_id = c_qte_hdr_id
and nvl(end_date_active,sysdate+1) > sysdate;
SELECT config_rev_nbr
FROM cz_config_details_v
WHERE config_hdr_id = p_config_hdr_id
AND config_rev_nbr = p_config_rev_nbr;
SELECT MAX(config_rev_nbr)
FROM cz_config_details_v
WHERE config_hdr_id = p_config_hdr_id;
SELECT l.QUOTE_LINE_ID
,l.CREATION_DATE
,l.CREATED_BY
,l.LAST_UPDATE_DATE
,l.LAST_UPDATED_BY
,l.LAST_UPDATE_LOGIN
,l.REQUEST_ID
,l.PROGRAM_APPLICATION_ID
,l.PROGRAM_ID
,l.PROGRAM_UPDATE_DATE
,l.QUOTE_HEADER_ID
,l.ORG_ID
,l.LINE_CATEGORY_CODE
,l.ITEM_TYPE_CODE
,l.LINE_NUMBER
,l.START_DATE_ACTIVE
,l.END_DATE_ACTIVE
,l.ORDER_LINE_TYPE_ID
,l.ORGANIZATION_ID
,l.INVENTORY_ITEM_ID
,l.QUANTITY
,l.UOM_CODE
,l.MARKETING_SOURCE_CODE_ID
,l.CURRENCY_CODE
,l.RELATED_ITEM_ID
,l.ITEM_RELATIONSHIP_TYPE
,l.ACCOUNTING_RULE_ID
,l.INVOICING_RULE_ID
,l.SPLIT_SHIPMENT_FLAG
,l.BACKORDER_FLAG
,l.agreement_id -- agreement
,l.commitment_id -- commitment
From aso_quote_lines l
Where l.QUOTE_HEADER_ID = l_QUOTE_HEADER_ID
Order by l.quote_line_id;
,l_qte_line_rec.LAST_UPDATE_DATE
,l_qte_line_rec.LAST_UPDATED_BY
,l_qte_line_rec.LAST_UPDATE_LOGIN
,l_qte_line_rec.REQUEST_ID
,l_qte_line_rec.PROGRAM_APPLICATION_ID
,l_qte_line_rec.PROGRAM_ID
,l_qte_line_rec.PROGRAM_UPDATE_DATE
,l_qte_line_rec.QUOTE_HEADER_ID
,l_qte_line_rec.ORG_ID
,l_qte_line_rec.LINE_CATEGORY_CODE
,l_qte_line_rec.ITEM_TYPE_CODE
,l_qte_line_rec.LINE_NUMBER
,l_qte_line_rec.START_DATE_ACTIVE
,l_qte_line_rec.END_DATE_ACTIVE
,l_qte_line_rec.ORDER_LINE_TYPE_ID
,l_qte_line_rec.ORGANIZATION_ID
,l_qte_line_rec.INVENTORY_ITEM_ID
,l_qte_line_rec.QUANTITY
,l_qte_line_rec.UOM_CODE
,l_qte_line_rec.MARKETING_SOURCE_CODE_ID
,l_qte_line_rec.CURRENCY_CODE
,l_qte_line_rec.RELATED_ITEM_ID
,l_qte_line_rec.ITEM_RELATIONSHIP_TYPE
,l_qte_line_rec.ACCOUNTING_RULE_ID
,l_qte_line_rec.INVOICING_RULE_ID
,l_qte_line_rec.SPLIT_SHIPMENT_FLAG
,l_qte_line_rec.BACKORDER_FLAG
,l_qte_line_rec.AGREEMENT_ID
,l_qte_line_rec.COMMITMENT_ID;
select quote_sharee_number
from ibe_sh_quote_access
where quote_sharee_id = (select max(quote_sharee_id)
from ibe_sh_quote_access I, hz_contact_points h
where i.contact_point_id = h.contact_point_id
and upper(h.owner_table_name) = 'IBE_SH_QUOTE_ACCESS'
and UPPER(h.email_address) = upper(p_emailaddress)
and quote_header_id = p_quote_header_id
and i.update_privilege_type_code = p_privilegeType);
l_quote_access_rec.update_privilege_type_code := p_privilegeType;
IBE_UTIL.DEBUG('l_qte_access_table(1).update_privilege_type_code: '|| l_qte_access_table(1).update_privilege_type_code);
,p_from_last_update_date IN DATE
,p_copy_only_header IN VARCHAR2 := FND_API.G_FALSE
,p_to_Control_Rec IN ASO_Quote_Pub.Control_Rec_Type
:= ASO_Quote_Pub.G_Miss_Control_Rec
,p_to_Qte_Header_Rec IN ASO_Quote_Pub.Qte_Header_Rec_Type
,p_to_hd_Shipment_rec IN ASO_Quote_Pub.Shipment_rec_Type
:= ASO_Quote_Pub.G_MISS_SHIPMENT_rec
,p_url IN VARCHAR2 := FND_API.G_MISS_CHAR
,p_sharee_email_address IN jtf_varchar2_table_2000 := NULL
,p_sharee_privilege_type IN jtf_varchar2_table_100 := NULL
,p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR
,p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM
,p_minisite_id IN NUMBER := FND_API.G_MISS_NUM
,p_validate_user IN VARCHAR2 := FND_API.G_FALSE
,x_to_quote_header_id OUT NOCOPY NUMBER
,x_to_last_update_date OUT NOCOPY DATE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'SAVEASANDSHARE';
SELECT order_type_id
FROM aso_quote_headers
WHERE quote_header_id = p_quote_header_id;
IBE_Quote_Misc_pvt.Validate_User_Update(
p_init_msg_list => p_init_msg_list
,p_quote_header_id => p_from_quote_header_id
,p_party_id => p_to_Qte_Header_Rec.party_id
,p_cust_account_id => p_to_Qte_Header_Rec.cust_account_id
,p_quote_retrieval_number => p_quote_retrieval_number
,p_validate_user => p_validate_user
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
,p_last_update_date => p_from_last_update_date
,p_copy_only_header => p_copy_only_header
--,P_New_Version =>
,P_Qte_Status_Id => l_quote_status_id -- default to null
,P_Qte_Number => l_quote_number -- default to null
,x_qte_header_id => l_to_qte_header_rec.quote_header_id
,x_Return_Status => x_Return_Status
,x_Msg_Count => x_Msg_Count
,x_Msg_Data => x_Msg_Data);
l_to_qte_header_rec.last_update_date
:= IBE_Quote_Misc_pvt.getQuotelastUpdateDate
(l_to_qte_header_rec.quote_header_id);
,x_last_update_date => x_to_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_rep_app_quote_header_id IN NUMBER := FND_API.G_MISS_NUM ,
p_new_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_url IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_sharee_email_address IN jtf_varchar2_table_2000 := NULL,
p_sharee_privilege_type IN jtf_varchar2_table_100 := NULL,
p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
p_comments IN VARCHAR2 := FND_API.G_MISS_CHAR ,
p_rep_app_invTo_partySiteId IN NUMBER := FND_API.G_MISS_NUM ,
p_Hd_Price_Attributes_Tbl IN ASO_Quote_Pub.Price_Attributes_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Attributes_Tbl,
p_Hd_Payment_Tbl IN ASO_Quote_Pub.Payment_Tbl_Type := ASO_Quote_Pub.G_MISS_PAYMENT_TBL,
p_Hd_Shipment_Tbl IN ASO_Quote_Pub.Shipment_Tbl_Type := ASO_Quote_Pub.G_MISS_SHIPMENT_TBL,
p_Hd_Freight_Charge_Tbl IN ASO_Quote_Pub.Freight_Charge_Tbl_Type := ASO_Quote_Pub.G_Miss_Freight_Charge_Tbl,
p_Hd_Tax_Detail_Tbl IN ASO_Quote_Pub.TAX_DETAIL_TBL_TYPE := ASO_Quote_Pub.G_Miss_Tax_Detail_Tbl,
p_Price_Adjustment_Tbl IN ASO_Quote_Pub.Price_Adj_Tbl_Type := ASO_Quote_Pub.G_Miss_Price_Adj_Tbl,
p_Price_Adj_Attr_Tbl IN ASO_Quote_Pub.Price_Adj_Attr_Tbl_Type := ASO_Quote_Pub.G_Miss_PRICE_ADJ_ATTR_Tbl,
p_Price_Adj_Rltship_Tbl IN ASO_Quote_Pub.Price_Adj_Rltship_Tbl_Type:= ASO_Quote_Pub.G_Miss_Price_Adj_Rltship_Tbl,
p_quote_retrieval_number IN NUMBER := FND_API.G_MISS_NUM,
p_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_validate_user IN VARCHAR2 := FND_API.G_FALSE,
p_minisite_id IN NUMBER := FND_API.G_MISS_NUM,
x_quote_header_id OUT NOCOPY NUMBER ,
x_last_update_date OUT NOCOPY DATE
)
is
l_api_name CONSTANT VARCHAR2(30) := 'APPENDTOREPLACESHARE';
l_last_update_date_tmp DATE;
select last_update_date, quote_number
from ASO_QUOTE_HEADERS
where quote_header_id = c_quote_header_id;
select last_update_date
from ASO_QUOTE_HEADERS
where quote_header_id = c_quote_header_id;
select quote_number
from ASO_QUOTE_HEADERS
where quote_header_id = c_quote_header_id;
/* Cursor to select the cart name used for "Replace Cart" functionality*/
CURSOR c_cart_name(p_quote_header_id number) is
SELECT quote_name, quote_number
FROM aso_quote_headers
WHERE quote_header_id =p_quote_header_id;
/* Cursor to select the quote owners used for "Replace Cart" functionality done by a recepient(sharee)*/
cursor c_check_cart_owner(p_quote_header_id number) is
select created_by from aso_quote_headers_all
where quote_header_id = p_quote_header_id;
IBE_Quote_Misc_pvt.Validate_User_Update(
p_init_msg_list => p_init_msg_list
,p_quote_header_id => p_original_quote_header_id
,p_party_id => p_party_id
,p_cust_account_id => p_cust_account_id
,p_quote_retrieval_number => p_quote_retrieval_number
,p_validate_user => p_validate_user
,p_last_update_date => p_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
/*IF (p_last_update_date is not null
and p_last_update_date <> fnd_api.g_miss_date) THEN
IBE_Quote_Misc_pvt.validateQuoteLastUpdateDate
( p_api_version_number => p_api_version_number
,p_quote_header_id => p_original_quote_header_id
,p_last_update_date => p_last_update_date
,X_Return_Status => x_return_status
,X_Msg_Count => x_msg_count
,X_Msg_Data => x_msg_data
);
l_to_qte_header_rec.last_update_date
, l_to_qte_header_rec.quote_number;
l_to_qte_header_rec.last_update_date;
,p_last_update_date => l_to_qte_header_rec.last_update_date
,P_Qte_Number => l_to_qte_header_rec.quote_number
,p_new_version => FND_API.G_TRUE
,x_qte_header_id => l_to_qte_header_rec.quote_header_id
,X_Return_Status => x_Return_Status
,X_Msg_Count => x_Msg_Count
,X_Msg_Data => x_Msg_Data);
l_to_qte_header_rec.last_update_date
:= IBE_Quote_Misc_pvt.getQuotelastUpdateDate
(l_to_qte_header_rec.quote_header_id);
l_to_qte_header_rec.last_update_date
:= IBE_Quote_Misc_pvt.getQuotelastUpdateDate
(l_to_qte_header_rec.quote_header_id);
/*Delete lines from the cart created in the above call to copy quote*/
IBE_Quote_Save_pvt.deletealllines(
P_Api_Version_Number => p_api_version_number
,p_Init_Msg_List => fnd_api.g_false
,p_Commit => fnd_api.g_false
,p_Quote_Header_Id => l_to_qte_header_rec.quote_header_id
,p_last_update_date => l_to_qte_header_rec.last_update_date
,x_quote_header_id => l_quote_header_id_tmp
,x_last_update_date => l_last_update_date_tmp
,X_Return_Status => x_return_status
,X_Msg_Count => x_msg_count
,X_Msg_Data => x_msg_data);
l_to_qte_header_rec.last_update_date := l_last_update_date_tmp;
,x_last_update_date => x_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
l_contact_lastupdatedate DATE := fnd_api.g_miss_date;
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_increaseversion IN VARCHAR2 := FND_API.G_FALSE ,
x_quote_header_id OUT NOCOPY NUMBER ,
x_last_update_date OUT NOCOPY DATE
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'ActivateQuote';
l_last_update_date_tmp DATE;
select party_id, cust_account_id, quote_header_id
from aso_quote_headers_all
where quote_header_id = c_quote_header_id;
IBE_Quote_Misc_pvt.Validate_User_Update(
p_init_msg_list => p_init_msg_list
,p_quote_header_id => p_quote_header_id
,p_validate_user => FND_API.G_TRUE
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data );
l_qte_header_rec.last_update_date := p_last_update_date;
IF l_qte_header_rec.last_update_date IS NULL
OR l_qte_header_rec.last_update_date = FND_API.G_MISS_DATE THEN
l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);
,P_Last_Update_Date => l_qte_header_rec.last_update_date
,X_Qte_Header_Id => l_quote_header_id_tmp
,X_Return_Status => x_return_status
,X_Msg_Count => x_msg_count
,X_Msg_Data => x_msg_data);
l_qte_header_rec.last_update_date := IBE_Quote_Misc_pvt.GetQuoteLastUpdateDate(l_qte_header_rec.quote_header_id);
,x_last_update_date => x_last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
x_last_update_date OUT NOCOPY DATE ,
x_privilege_type_code OUT NOCOPY VARCHAR2
)
is
l_api_name CONSTANT VARCHAR2(30) := 'Retrievesharequote';
,x_last_update_date => l_qte_header_rec.last_update_date
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
ibe_util.debug('call IBE_Quote_Save_pvt.updatequoteforshare');
IBE_UTIL.DEBUG('call IBE_Quote_Save_pvt.updatequoteforsharee at'
|| to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
IBE_Quote_Save_pvt.UpdateQuoteForSharee
( p_api_version_number => p_api_version_number
,p_init_msg_list => FND_API.G_FALSE
,p_commit => FND_API.G_FALSE
,p_sharee_party_id => p_sharee_party_id
,p_sharee_cust_account_id => p_sharee_cust_account_id
,p_control_rec => p_control_rec
,p_qte_header_rec => l_qte_header_rec
,x_qte_header_rec => l_qte_header_rec_tmp
,x_qte_line_tbl => lx_qte_line_tbl
,X_Return_Status => X_Return_Status
,X_Msg_Count => X_Msg_Count
,X_Msg_Data => X_Msg_Data
);
IBE_UTIL.DEBUG('done IBE_Quote_Save_pvt.updatequoteforsharee at'
|| to_char(sysdate, 'mm/dd/yyyy:hh24:MI:SS'));
x_last_update_date := l_qte_header_rec.last_update_date;
p_last_update_date IN VARCHAR2 := FND_API.G_FALSE ,
p_mode IN VARCHAR2 := 'MERGE' ,
p_combinesameitem IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_id IN NUMBER ,
p_cust_account_id IN NUMBER ,
p_quote_source_code IN VARCHAR2 := 'IStore Account' ,
p_minisite_id IN NUMBER := FND_API.G_MISS_NUM ,
p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_price_list_id IN NUMBER := FND_API.G_MISS_NUM ,
p_control_rec IN ASO_Quote_Pub.Control_Rec_Type := ASO_Quote_Pub.G_MISS_Control_Rec,
x_quote_header_id OUT NOCOPY NUMBER ,
x_last_update_date OUT NOCOPY DATE ,
x_retrieval_number OUT NOCOPY NUMBER
)
IS
l_api_name CONSTANT VARCHAR2(30) := 'MergeActiveQuote';
select quote_header_id,
last_update_date,
quote_name,
party_id,
cust_account_id,
currency_code
from aso_quote_headers
where quote_header_id = p_quote_header_id;
select quote_header_id,last_update_date
from aso_quote_headers
where party_id = p_party_id
and cust_account_id = p_cust_account_id
and quote_name = 'IBEACTIVECART'
and quote_source_code = p_quote_source_code
and trunc(quote_expiration_date) >= trunc(sysdate) --QUOTE EXPIRATION CHECK.
and order_id is null;
select quote_sharee_number
from ibe_sh_quote_access
where quote_header_id = c_quote_header_id
and party_id = c_party_id
and cust_account_id = c_cust_account_id;
select resource_id, publish_flag
from aso_quote_headers
where quote_header_id = c_quote_header_id;
l_last_update_date_tmp DATE;
select minisite_id
from aso_quote_lines
where QUOTE_HEADER_ID = l_quote_header_id
order by quote_line_id;
,l_in_qte_header_rec.last_update_date
,l_in_qte_header_rec.quote_name
,l_in_qte_header_rec.party_id
,l_in_qte_header_rec.cust_account_id
,l_currency_code;
,l_db_qte_header_rec.last_update_date
,l_db_qte_header_rec.quote_name
,l_db_qte_header_rec.party_id
,l_db_qte_header_rec.cust_account_id
,l_currency_code;
,x_last_update_date => x_last_update_date
,x_Return_Status => x_Return_Status
,x_Msg_Count => x_Msg_Count
,x_Msg_Data => x_Msg_Data);
,p_last_update_date => l_in_qte_header_rec.last_update_date
,P_REP_App_Quote_Header_id => l_db_qte_header_rec.quote_header_id
,p_currency_code => p_currency_code
,p_price_list_id => p_price_list_id
,p_control_rec => p_control_rec
,p_combinesameitem => p_combinesameitem
,p_mode => 'APPENDTO'
,p_rep_app_invTo_partySiteId => l_db_qte_header_rec.invoice_to_party_site_id
,p_hd_price_attributes_tbl => lx_Hd_Price_Attributes_Tbl
,p_hd_payment_tbl => lx_Hd_Payment_Tbl
,p_hd_shipment_tbl => lx_Hd_Shipment_Tbl
,p_hd_freight_charge_tbl => lx_Hd_Freight_Charge_Tbl
,p_hd_tax_detail_tbl => lx_Hd_Tax_Detail_Tbl
,p_price_adjustment_tbl => lx_Price_Adjustment_Tbl
,p_price_adj_attr_tbl => lx_Price_Adj_Attr_Tbl
,p_price_adj_rltship_tbl => lx_Price_Adj_Rltship_Tbl
,X_Quote_Header_Id => l_quote_header_id_tmp
,x_last_update_date => l_last_update_date_tmp
,X_Return_Status => x_return_status
,X_Msg_Count => x_msg_count
,X_Msg_Data => x_msg_data);
l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
IBE_Quote_Save_pvt.Delete
( p_api_version_number => p_api_version_number
,p_init_msg_list => FND_API.G_false
,p_commit => FND_API.G_false
,p_quote_header_id => l_in_qte_header_rec.quote_header_id
,p_last_update_date => l_in_qte_header_rec.last_update_date
,p_expunge_flag => FND_API.G_true
,X_Return_Status => x_Return_Status
,X_Msg_Count => x_Msg_Count
,X_Msg_Data => x_Msg_Data);
IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: done merge: +delete');
x_last_update_date := l_db_qte_header_rec.last_update_date;
l_default_save_qte_hdr_rec.last_update_date := l_db_qte_header_rec.last_update_date;
x_last_update_date => l_last_update_date_tmp ,
x_return_status => x_return_status ,
x_msg_count => x_msg_count ,
x_msg_data => x_msg_data);
l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
IBE_Quote_Save_pvt.Delete
( p_api_version_number => p_api_version_number
,p_init_msg_list => FND_API.G_false
,p_commit => FND_API.G_false
,p_quote_header_id => l_in_qte_header_rec.quote_header_id
,p_last_update_date => l_in_qte_header_rec.last_update_date
,p_expunge_flag => FND_API.g_true --added expunge_flag param
,X_Return_Status => x_Return_Status
,X_Msg_Count => x_Msg_Count
,X_Msg_Data => x_Msg_Data
);
x_last_update_date := l_db_qte_header_rec.last_update_date;
IBE_UTIL.DEBUG('IBE_QUOTE_SAVESHARE_pvt.MERGE_QUOTE: remove: after delete');
x_last_update_date := l_in_qte_header_rec.last_update_date;
,x_last_update_date => x_last_update_date
,X_Return_Status => x_Return_Status
,X_Msg_Count => x_Msg_Count
,X_Msg_Data => x_Msg_Data
);
,x_last_update_date => l_last_update_date_tmp
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
x_last_update_date := l_db_qte_header_rec.last_update_date;
,x_last_update_date => x_last_update_date
,x_Return_Status => x_Return_Status
,x_Msg_Count => x_Msg_Count
,x_Msg_Data => x_Msg_Data);
x_last_update_date => l_last_update_date_tmp ,
x_return_status => x_return_status ,
x_msg_count => x_msg_count ,
x_msg_data => x_msg_data );
l_in_qte_header_rec.last_update_date := l_last_update_date_tmp;
x_last_update_date := l_in_qte_header_rec.last_update_date;
IBE_UTIL.DEBUG('MergeActiveQutoe:x_last_update_date: '||x_last_update_date);
l_default_save_qte_hdr_rec.last_update_date := l_db_qte_header_rec.last_update_date;
x_last_update_date => l_last_update_date_tmp ,
x_return_status => x_return_status ,
x_msg_count => x_msg_count ,
x_msg_data => x_msg_data);
l_db_qte_header_rec.last_update_date := l_last_update_date_tmp;
,x_last_update_date => x_last_update_date
,x_Return_Status => x_Return_Status
,x_Msg_Count => x_Msg_Count
,x_Msg_Data => x_Msg_Data);
x_last_update_date => l_last_update_date_tmp ,
x_return_status => x_return_status ,
x_msg_count => x_msg_count ,
x_msg_data => x_msg_data );
select quote_password, quote_number, quote_version
from aso_quote_headers
where quote_header_id = qte_header_id;