[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_c_last_update_date DATE := FND_API.G_MISS_DATE,
p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
x_control_rec OUT NOCOPY ASO_Quote_Pub.Control_Rec_Type
)
IS
BEGIN
IF p_c_last_update_date <> ROSETTA_G_MISTAKE_DATE
AND p_c_last_update_date <> FND_API.G_MISS_DATE
AND p_c_last_update_date <> null THEN
x_control_rec.last_update_date := p_c_last_update_date;
p_c_last_update_date DATE := FND_API.G_MISS_DATE,
p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_deactivate_cart VARCHAR2 := FND_API.G_MISS_CHAR,
x_saveshare_control_rec OUT NOCOPY IBE_QUOTE_SAVESHARE_V2_PVT.saveshare_control_rec_type
) is
l_control_rec ASO_QUOTE_PUB.control_rec_type;
p_c_LAST_UPDATE_DATE => p_c_LAST_UPDATE_DATE
,p_c_auto_version_flag => p_c_auto_version_flag
,p_c_pricing_request_type => p_c_pricing_request_type
,p_c_header_pricing_event => p_c_header_pricing_event
,p_c_line_pricing_event => p_c_line_pricing_event
,p_c_CAL_TAX_FLAG => p_c_CAL_TAX_FLAG
,p_c_CAL_FREIGHT_CHARGE_FLAG => p_c_CAL_FREIGHT_CHARGE_FLAG
,x_control_rec => l_control_rec );
x_saveshare_control_rec.delete_source_cart := p_ssc_delete_source_cart;
p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL)
RETURN IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE IS
l_quote_access_tbl IBE_QUOTE_SAVESHARE_pvt.QUOTE_ACCESS_TBL_TYPE;
IF ((p_qsh_PROGRAM_UPDATE_DATE is not null ) and ((p_qsh_PROGRAM_UPDATE_DATE(i) is not null)
or (p_qsh_PROGRAM_UPDATE_DATE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
l_quote_access_tbl(i).PROGRAM_UPDATE_DATE := p_qsh_PROGRAM_UPDATE_DATE(i);
IF ((p_qsh_LAST_UPDATED_BY is not null ) and ((p_qsh_LAST_UPDATED_BY(i) is not null)
or (p_qsh_LAST_UPDATED_BY(i) <> ROSETTA_G_MISS_NUM))) THEN
l_quote_access_tbl(i).LAST_UPDATED_BY := p_qsh_LAST_UPDATED_BY(i);
IF ((p_qsh_LAST_UPDATE_DATE is not null ) and ((p_qsh_LAST_UPDATE_DATE(i) is not null)
or (p_qsh_LAST_UPDATE_DATE(i) <> ROSETTA_G_MISTAKE_DATE))) THEN
l_quote_access_tbl(i).LAST_UPDATE_DATE := p_qsh_LAST_UPDATE_DATE(i);
IF ((p_qsh_LAST_UPDATE_LOGIN is not null ) and ((p_qsh_LAST_UPDATE_LOGIN(i) is not null)
or (p_qsh_LAST_UPDATE_LOGIN(i) <> ROSETTA_G_MISS_NUM))) THEN
l_quote_access_tbl(i).LAST_UPDATE_LOGIN := p_qsh_LAST_UPDATE_LOGIN(i);
IF (p_qsh_UPDATE_PRIV_TYPE_CODE is not null ) THEN
l_quote_access_tbl(i).UPDATE_PRIVILEGE_TYPE_CODE := p_qsh_UPDATE_PRIV_TYPE_CODE(i);
p_last_updated_by IN jtf_number_table := NULL,
p_last_update_date IN jtf_date_table := NULL,
p_last_update_login IN jtf_number_table := NULL,
p_request_id IN jtf_number_table := NULL,
p_program_application_id IN jtf_number_table := NULL,
p_program_id IN jtf_number_table := NULL,
p_program_update_date IN jtf_date_table := NULL,
p_quote_header_id IN jtf_number_table := NULL,
p_quote_line_id IN jtf_number_table := NULL,
p_percent IN jtf_number_table := NULL,
p_resource_id IN jtf_number_table := NULL,
p_sales_credit_type IN jtf_varchar2_table_300 := NULL,
p_resource_group_id IN jtf_number_table := NULL,
p_employee_person_id IN jtf_number_table := NULL,
p_sales_credit_type_id IN jtf_number_table := NULL,
p_attribute_category IN jtf_varchar2_table_100 := NULL,
p_attribute1 IN jtf_varchar2_table_300 := NULL,
p_attribute2 IN jtf_varchar2_table_300 := NULL,
p_attribute3 IN jtf_varchar2_table_300 := NULL,
p_attribute4 IN jtf_varchar2_table_300 := NULL,
p_attribute5 IN jtf_varchar2_table_300 := NULL,
p_attribute6 IN jtf_varchar2_table_300 := NULL,
p_attribute7 IN jtf_varchar2_table_300 := NULL,
p_attribute8 IN jtf_varchar2_table_300 := NULL,
p_attribute9 IN jtf_varchar2_table_300 := NULL,
p_attribute10 IN jtf_varchar2_table_300 := NULL,
p_attribute11 IN jtf_varchar2_table_300 := NULL,
p_attribute12 IN jtf_varchar2_table_300 := NULL,
p_attribute13 IN jtf_varchar2_table_300 := NULL,
p_attribute14 IN jtf_varchar2_table_300 := NULL,
p_attribute15 IN jtf_varchar2_table_300 := NULL
)
RETURN ASO_Quote_Pub.Sales_Credit_Tbl_Type
IS
l_sales_credit_tbl ASO_Quote_Pub.Sales_Credit_Tbl_Type;
IF p_last_updated_by(i)= ROSETTA_G_MISS_NUM THEN
l_sales_credit_tbl(i).last_updated_by := FND_API.G_MISS_NUM;
l_sales_credit_tbl(i).last_updated_by := p_last_updated_by(i);
IF p_last_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_sales_credit_tbl(i).last_update_date := FND_API.G_MISS_DATE;
l_sales_credit_tbl(i).last_update_date := p_last_update_date(i);
IF p_last_update_login(i)= ROSETTA_G_MISS_NUM THEN
l_sales_credit_tbl(i).last_update_login := FND_API.G_MISS_NUM;
l_sales_credit_tbl(i).last_update_login := p_last_update_login(i);
IF p_program_update_date(i)= ROSETTA_G_MISTAKE_DATE THEN
l_sales_credit_tbl(i).program_update_date := FND_API.G_MISS_DATE;
l_sales_credit_tbl(i).program_update_date := p_program_update_date(i);
p_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_number IN NUMBER := FND_API.G_MISS_NUM,
p_quote_version IN NUMBER := FND_API.G_MISS_NUM,
p_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
p_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
p_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_total_tax IN NUMBER := FND_API.G_MISS_NUM,
p_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
p_surcharge IN NUMBER := FND_API.G_MISS_NUM,
p_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
p_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
p_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- p_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- bug 6873117 mgiridha added attribute 16-20
p_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_id IN NUMBER := FND_API.G_MISS_NUM,
p_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
p_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR
)
RETURN ASO_Quote_Pub.Qte_Header_Rec_Type
IS
l_qte_header ASO_Quote_Pub.Qte_Header_Rec_Type;
IF p_last_updated_by= ROSETTA_G_MISS_NUM THEN
l_qte_header.last_updated_by := FND_API.G_MISS_NUM;
l_qte_header.last_updated_by := p_last_updated_by;
IF p_last_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.last_update_date := FND_API.G_MISS_DATE;
l_qte_header.last_update_date := p_last_update_date;
IF p_last_update_login= ROSETTA_G_MISS_NUM THEN
l_qte_header.last_update_login := FND_API.G_MISS_NUM;
l_qte_header.last_update_login := p_last_update_login;
IF p_program_update_date= ROSETTA_G_MISTAKE_DATE THEN
l_qte_header.program_update_date := FND_API.G_MISS_DATE;
l_qte_header.program_update_date := p_program_update_date;
l_qte_line_tbl(i).operation_code := 'UPDATE';
p_c_last_update_date DATE := FND_API.G_MISS_DATE,
p_c_auto_version_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_pricing_request_type VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_header_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_line_pricing_event VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_tax_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_c_cal_freight_charge_flag VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_delete_source_cart VARCHAR2 := FND_API.G_TRUE ,
p_ssc_combinesameitem VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_operation_code VARCHAR2 := FND_API.G_MISS_CHAR,
p_ssc_deactivate_cart IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_header_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_creation_date IN DATE := FND_API.G_MISS_DATE,
p_q_created_by IN NUMBER := FND_API.G_MISS_NUM,
p_q_last_updated_by IN NUMBER := FND_API.G_MISS_NUM,
p_q_last_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_last_update_login IN NUMBER := FND_API.G_MISS_NUM,
p_q_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_application_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_program_update_date IN DATE := FND_API.G_MISS_DATE,
p_q_org_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_version IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_status_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_quote_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_expiration_date IN DATE := FND_API.G_MISS_DATE,
p_q_price_frozen_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_password IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_original_system_reference IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_cust_account_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_org_contact_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_party_type IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_person_middle_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_phone_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_price_list_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_currency_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_total_list_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_adjusted_percent IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_tax IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_shipping_charge IN NUMBER := FND_API.G_MISS_NUM,
p_q_surcharge IN NUMBER := FND_API.G_MISS_NUM,
p_q_total_quote_price IN NUMBER := FND_API.G_MISS_NUM,
p_q_payment_amount IN NUMBER := FND_API.G_MISS_NUM,
p_q_accounting_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_rate IN NUMBER := FND_API.G_MISS_NUM,
p_q_exchange_type_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_exchange_rate_date IN DATE := FND_API.G_MISS_DATE,
p_q_quote_category_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_quote_status IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_employee_person_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_sales_channel_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- p_q_salesrep_full_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute_category IN VARCHAR2 := FND_API.G_MISS_CHAR,
-- bug 6873117 added attribute 16-20
p_q_attribute1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute10 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute11 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute12 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute13 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute14 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute15 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute16 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute17 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute18 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute19 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute20 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute5 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute6 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute7 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute8 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_attribute9 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_qte_contract_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_ffm_request_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_address1 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address2 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address3 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_address4 IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_city IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_cont_mid_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_country IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_county IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_party_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_party_site_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_invoice_to_postal_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_province IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoice_to_state IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_invoicing_rule_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_marketing_source_code IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_marketing_source_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_orig_mktg_source_code_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_id IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_number IN NUMBER := FND_API.G_MISS_NUM,
p_q_order_type_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_ordered_date IN DATE := FND_API.G_MISS_DATE,
p_q_resource_id IN NUMBER := FND_API.G_MISS_NUM,
--p_q_save_type IN NUMBER := FND_API.G_MISS_NUM,
p_q_pricing_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_q_tax_status_indicator IN VARCHAR2 := FND_API.G_MISS_CHAR,
p_qsh_OPERATION_CODE JTF_VARCHAR2_TABLE_100 :=NULL,
p_qsh_QUOTE_SHAREE_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_REQUEST_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_PROGRAM_APPLICATION_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_PROGRAM_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_PROGRAM_UPDATE_DATE JTF_DATE_TABLE :=NULL,
p_qsh_OBJECT_VERSION_NUMBER JTF_NUMBER_TABLE :=NULL,
p_qsh_CREATED_BY JTF_NUMBER_TABLE :=NULL,
p_qsh_CREATION_DATE JTF_DATE_TABLE :=NULL,
p_qsh_LAST_UPDATED_BY JTF_NUMBER_TABLE :=NULL,
p_qsh_LAST_UPDATE_DATE JTF_DATE_TABLE :=NULL,
p_qsh_LAST_UPDATE_LOGIN JTF_NUMBER_TABLE :=NULL,
p_qsh_QUOTE_HEADER_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_QUOTE_SHAREE_NUMBER JTF_NUMBER_TABLE :=NULL,
p_qsh_UPDATE_PRIV_TYPE_CODE JTF_VARCHAR2_TABLE_2000 :=NULL,
p_qsh_SECURITY_GROUP_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_PARTY_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_CUST_ACCOUNT_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_START_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
p_qsh_END_DATE_ACTIVE JTF_DATE_TABLE :=NULL,
p_qsh_RECIPIENT_NAME JTF_VARCHAR2_TABLE_300 :=NULL,
p_qsh_CONTACT_POINT_ID JTF_NUMBER_TABLE :=NULL,
p_qsh_EMAIL_ADDRESS JTF_VARCHAR2_TABLE_2000 :=NULL,
p_qsh_NOTIFY_FLAG JTF_VARCHAR2_TABLE_100 :=NULL,
p_NOTES VARCHAR2 := FND_API.G_MISS_CHAR,
p_party_id NUMBER := FND_API.G_MISS_NUM,
P_CUST_ACCOUNT_ID NUMBER := FND_API.G_MISS_NUM,
P_RETRIEVAL_NUMBER NUMBER := FND_API.G_MISS_NUM,
p_minisite_id NUMBER := FND_API.G_MISS_NUM,
P_source_quote_header_id NUMBER := FND_API.G_MISS_NUM,
P_source_last_update_date DATE := FND_API.G_MISS_DATE,
p_URL VARCHAR2 := FND_API.G_MISS_CHAR,
x_return_status OUT NOCOPY VARCHAR2 ,
x_msg_count OUT NOCOPY NUMBER ,
x_msg_data OUT NOCOPY VARCHAR2 ) is
l_saveshare_control_rec IBE_QUOTE_SAVESHARE_V2_PVT.SAVESHARE_CONTROL_REC_TYPE;
p_c_last_update_date => p_c_last_update_date ,
p_c_auto_version_flag => p_c_auto_version_flag,
p_c_pricing_request_type => p_c_pricing_request_type,
p_c_header_pricing_event => p_c_header_pricing_event,
p_c_line_pricing_event => p_c_line_pricing_event,
p_c_cal_tax_flag => p_c_cal_tax_flag,
p_c_cal_freight_charge_flag => p_c_cal_freight_charge_flag ,
p_ssc_delete_source_cart => p_ssc_delete_source_cart,
p_ssc_combinesameitem => p_ssc_combinesameitem,
p_ssc_operation_code => p_ssc_operation_code,
p_ssc_deactivate_cart => p_ssc_deactivate_cart,
x_saveshare_control_rec => l_saveshare_control_rec) ;
p_last_update_date => p_q_last_update_date);*/
p_last_updated_by => p_q_last_updated_by ,
p_last_update_date => p_q_last_update_date ,
p_last_update_login => p_q_last_update_login ,
p_request_id => p_q_request_id ,
p_program_application_id => p_q_program_application_id ,
p_program_id => p_q_program_id ,
p_program_update_date => p_q_program_update_date ,
p_org_id => p_q_org_id ,
p_quote_name => p_q_quote_name ,
p_quote_number => p_q_quote_number ,
p_quote_version => p_q_quote_version ,
p_quote_status_id => p_q_quote_status_id ,
p_quote_source_code => p_q_quote_source_code ,
p_quote_expiration_date => p_q_quote_expiration_date ,
p_price_frozen_date => p_q_price_frozen_date ,
p_quote_password => p_q_quote_password ,
p_original_system_reference => p_q_original_system_reference ,
p_party_id => p_q_party_id ,
p_cust_account_id => p_q_cust_account_id ,
p_invoice_to_cust_account_id => p_q_invoice_to_cust_account_id,
p_org_contact_id => p_q_org_contact_id ,
p_party_name => p_q_party_name ,
p_party_type => p_q_party_type ,
p_person_first_name => p_q_person_first_name ,
p_person_last_name => p_q_person_last_name ,
p_person_middle_name => p_q_person_middle_name ,
p_phone_id => p_q_phone_id ,
p_price_list_id => p_q_price_list_id ,
p_price_list_name => p_q_price_list_name ,
p_currency_code => p_q_currency_code ,
p_total_list_price => p_q_total_list_price ,
p_total_adjusted_amount => p_q_total_adjusted_amount ,
p_total_adjusted_percent => p_q_total_adjusted_percent ,
p_total_tax => p_q_total_tax ,
p_total_shipping_charge => p_q_total_shipping_charge ,
p_surcharge => p_q_surcharge ,
p_total_quote_price => p_q_total_quote_price ,
p_payment_amount => p_q_payment_amount ,
p_accounting_rule_id => p_q_accounting_rule_id ,
p_exchange_rate => p_q_exchange_rate ,
p_exchange_type_code => p_q_exchange_type_code ,
p_exchange_rate_date => p_q_exchange_rate_date ,
p_quote_category_code => p_q_quote_category_code ,
p_quote_status_code => p_q_quote_status_code ,
p_quote_status => p_q_quote_status ,
p_employee_person_id => p_q_employee_person_id ,
p_sales_channel_code => p_q_sales_channel_code ,
-- p_salesrep_full_name => p_q_salesrep_full_name ,
p_attribute_category => p_q_attribute_category ,
-- bug 6873117 mgiridha added attribute 16-20
p_attribute1 => p_q_attribute1 ,
p_attribute10 => p_q_attribute10 ,
p_attribute11 => p_q_attribute11 ,
p_attribute12 => p_q_attribute12 ,
p_attribute13 => p_q_attribute13 ,
p_attribute14 => p_q_attribute14 ,
p_attribute15 => p_q_attribute15 ,
p_attribute16 => p_q_attribute16 ,
p_attribute17 => p_q_attribute17 ,
p_attribute18 => p_q_attribute18 ,
p_attribute19 => p_q_attribute19 ,
p_attribute2 => p_q_attribute2 ,
p_attribute20 => p_q_attribute20 ,
p_attribute3 => p_q_attribute3 ,
p_attribute4 => p_q_attribute4 ,
p_attribute5 => p_q_attribute5 ,
p_attribute6 => p_q_attribute6 ,
p_attribute7 => p_q_attribute7 ,
p_attribute8 => p_q_attribute8 ,
p_attribute9 => p_q_attribute9 ,
p_contract_id => p_q_contract_id ,
p_qte_contract_id => p_q_qte_contract_id ,
p_ffm_request_id => p_q_ffm_request_id ,
p_invoice_to_address1 => p_q_invoice_to_address1 ,
p_invoice_to_address2 => p_q_invoice_to_address2 ,
p_invoice_to_address3 => p_q_invoice_to_address3 ,
p_invoice_to_address4 => p_q_invoice_to_address4 ,
p_invoice_to_city => p_q_invoice_to_city ,
p_invoice_to_cont_first_name => p_q_invoice_to_cont_first_name,
p_invoice_to_cont_last_name => p_q_invoice_to_cont_last_name ,
p_invoice_to_cont_mid_name => p_q_invoice_to_cont_mid_name ,
p_invoice_to_country_code => p_q_invoice_to_country_code ,
p_invoice_to_country => p_q_invoice_to_country ,
p_invoice_to_county => p_q_invoice_to_county ,
p_invoice_to_party_id => p_q_invoice_to_party_id ,
p_invoice_to_party_name => p_q_invoice_to_party_name ,
p_invoice_to_party_site_id => p_q_invoice_to_party_site_id ,
p_invoice_to_postal_code => p_q_invoice_to_postal_code ,
p_invoice_to_province => p_q_invoice_to_province ,
p_invoice_to_state => p_q_invoice_to_state ,
p_invoicing_rule_id => p_q_invoicing_rule_id ,
p_marketing_source_code_id => p_q_marketing_source_code_id ,
p_marketing_source_code => p_q_marketing_source_code ,
p_marketing_source_name => p_q_marketing_source_name ,
p_orig_mktg_source_code_id => p_q_orig_mktg_source_code_id ,
p_order_type_id => p_q_order_type_id ,
p_order_id => p_q_order_id ,
p_order_number => p_q_order_number ,
p_order_type_name => p_q_order_type_name ,
p_ordered_date => p_q_ordered_date ,
p_resource_id => p_q_resource_id ,
p_pricing_status_indicator =>p_q_pricing_status_indicator ,
p_tax_status_indicator =>p_q_tax_status_indicator);
p_qsh_PROGRAM_UPDATE_DATE => p_qsh_PROGRAM_UPDATE_DATE ,
p_qsh_OBJECT_VERSION_NUMBER => p_qsh_OBJECT_VERSION_NUMBER ,
p_qsh_CREATED_BY => p_qsh_CREATED_BY ,
p_qsh_CREATION_DATE => p_qsh_CREATION_DATE ,
p_qsh_LAST_UPDATED_BY => p_qsh_LAST_UPDATED_BY ,
p_qsh_LAST_UPDATE_DATE => p_qsh_LAST_UPDATE_DATE ,
p_qsh_LAST_UPDATE_LOGIN => p_qsh_LAST_UPDATE_LOGIN ,
p_qsh_QUOTE_HEADER_ID => p_qsh_QUOTE_HEADER_ID ,
p_qsh_QUOTE_SHAREE_NUMBER => p_qsh_QUOTE_SHAREE_NUMBER ,
p_qsh_UPDATE_PRIV_TYPE_CODE => p_qsh_UPDATE_PRIV_TYPE_CODE ,
p_qsh_SECURITY_GROUP_ID => p_qsh_SECURITY_GROUP_ID ,
p_qsh_PARTY_ID => p_qsh_PARTY_ID ,
p_qsh_CUST_ACCOUNT_ID => p_qsh_CUST_ACCOUNT_ID ,
p_qsh_START_DATE_ACTIVE => p_qsh_START_DATE_ACTIVE ,
p_qsh_END_DATE_ACTIVE => p_qsh_END_DATE_ACTIVE ,
p_qsh_RECIPIENT_NAME => p_qsh_RECIPIENT_NAME ,
p_qsh_CONTACT_POINT_ID => p_qsh_CONTACT_POINT_ID ,
p_qsh_EMAIL_ADDRESS => p_qsh_EMAIL_ADDRESS ,
p_qsh_NOTIFY_FLAG => p_qsh_NOTIFY_FLAG );
P_source_last_update_date => P_source_last_update_date ,
p_minisite_id => p_minisite_id,
p_URL => p_URL,
p_notes => p_notes,
p_api_version => p_api_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data) ;