[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT ASO_QUOTE_NUMBER_S.NEXTVAL
FROM sys.DUAL;
select org_id,quote_name||':'||quote_number||':'||quote_version qte_name,currency_code,price_list_id,order_type_id,quote_category_code
from aso_Quote_headers_all
where quote_header_id=l_quote_header_Id;
SELECT quote_status_id
FROM ASO_QUOTE_STATUSES_B
WHERE status_code = c_status_code;
l_qte_header_rec.price_updated_date := NULL;
l_qte_header_rec.tax_updated_date := NULL;
P_UPDATE_QUOTE =>'T',
P_CONFIG_EFFECTIVE_DATE => sysdate,
P_CONFIG_model_lookup_DATE => sysdate,
X_Config_tbl => lx_config_tbl,
X_Return_Status => l_return_status,
X_Msg_Count => x_msg_count,
X_Msg_Data => x_msg_data
);
ASO_QUOTE_HEADERS_PVT.Insert_Rows (
p_qte_header_rec => P_Qte_Header_Rec
, p_Price_Attributes_Tbl => aso_quote_pub.G_Miss_Price_Attributes_Tbl
, P_Price_Adjustment_Tbl => aso_quote_pub.G_MISS_Price_Adj_TBL
, P_Price_Adj_Attr_Tbl => aso_quote_pub.G_MISS_PRICE_ADJ_ATTR_TBL
, P_Payment_Tbl => aso_quote_pub.G_MISS_PAYMENT_TBL
, P_Shipment_Tbl => aso_quote_pub.G_MISS_Shipment_TBL
, P_Freight_Charge_Tbl => aso_quote_pub.G_Miss_Freight_Charge_Tbl
, P_Tax_Detail_Tbl => aso_quote_pub.G_Miss_Tax_Detail_Tbl
, P_hd_Attr_Ext_Tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL
, P_Sales_Credit_Tbl => aso_quote_pub.G_MISS_Sales_Credit_Tbl
, P_Quote_Party_Tbl => aso_quote_pub.G_MISS_Quote_Party_Tbl
, P_qte_access_Tbl => aso_quote_pub.G_MISS_QTE_ACCESS_TBL
, x_qte_header_rec => l_qte_header_rec_out
, x_Price_Attributes_Tbl => l_price_attr_tbl_out
, x_Price_Adjustment_Tbl => l_hd_Price_Adj_Tbl_out
, x_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl_out
, x_Payment_Tbl => l_payment_tbl_out
, x_Shipment_Rec => l_shipment_rec_out
, x_Freight_Charge_Tbl => l_freight_charge_tbl_out
, x_Tax_Detail_Tbl => l_tax_detail_tbl_out
, x_hd_Attr_Ext_Tbl => l_hd_Attr_Ext_Tbl_out
, x_sales_credit_tbl => l_sales_credit_tbl_out
, x_quote_party_tbl => l_quote_party_tbl_out
, x_qte_access_Tbl => l_qte_access_tbl_out
, X_Return_Status => l_return_status
, X_Msg_Count => x_msg_count
, X_Msg_Data => x_msg_data
);
aso_debug_pub.ADD ( 'Copy_Template - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
SELECT LINE_RELATIONSHIP_ID, CREATION_DATE, CREATED_BY
, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
, PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
, RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
FROM ASO_LINE_RELATIONSHIPS
WHERE quote_line_id IN ( SELECT quote_line_id
FROM aso_quote_lines_all
WHERE quote_header_id = x_quote_header_id )
AND relationship_type_code <> 'SERVICE';
SELECT serviceable_product_flag, service_item_flag
FROM MTL_SYSTEM_ITEMS_VL
WHERE inventory_item_id = l_inv_item_id
AND organization_id = l_organization_id;
SELECT shipment_id
FROM ASO_SHIPMENTS
WHERE quote_line_id = lc_line_id;
SELECT 'X'
FROM ASO_QUOTE_LINES_ALL
WHERE quote_header_id = x_qte_header_id
AND quote_line_id = x_qte_line_id;
SELECT LINE_RELATIONSHIP_ID, CREATION_DATE, CREATED_BY
, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN
, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID
, PROGRAM_UPDATE_DATE, QUOTE_LINE_ID, RELATED_QUOTE_LINE_ID
, RELATIONSHIP_TYPE_CODE, RECIPROCAL_FLAG, OBJECT_VERSION_NUMBER
FROM ASO_LINE_RELATIONSHIPS
WHERE relationship_type_code <> 'SERVICE'
CONNECT BY PRIOR related_quote_line_id = quote_line_id
START WITH quote_line_id = x_quote_line_id;
l_last_update_date DATE;
aso_debug_pub.ADD ( 'Copy_Line_Rows - Before insert_quote_line_rows: ' || l_qte_line_id , 1 , 'Y' );
ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
p_control_rec => l_control_rec
, P_qte_Line_Rec => l_qte_line_tbl ( i )
, P_qte_line_dtl_tbl => l_qte_line_dtl_tbl
, P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
, P_price_attributes_tbl => l_price_attr_tbl
, P_Price_Adj_Tbl => l_price_adj_tbl
, P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
, P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
, P_Shipment_Tbl => l_shipment_tbl
, P_Freight_Charge_Tbl => l_freight_charge_tbl
, P_Tax_Detail_Tbl => l_tax_detail_tbl
, P_Sales_Credit_Tbl => l_sales_credit_tbl
, P_Quote_Party_Tbl => l_quote_party_tbl
, x_qte_Line_Rec => lx_qte_line_rec
, x_qte_line_dtl_tbl => l_qte_line_dtl_tbl_out
, x_Line_Attribs_Ext_Tbl => l_line_attr_Ext_Tbl_out
, x_price_attributes_tbl => l_price_attr_tbl_out
, x_Price_Adj_Tbl => lx_ln_price_adj_tbl
, x_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl_out
, x_Payment_Tbl => l_payment_tbl_out
, x_Shipment_Tbl => l_shipment_tbl_out
, x_Freight_Charge_Tbl => l_freight_charge_tbl_out
, x_Tax_Detail_Tbl => l_tax_detail_tbl_out
, x_Sales_Credit_Tbl => l_sales_credit_tbl_out
, x_Quote_Party_Tbl => l_quote_party_tbl_out
, x_Return_Status => l_return_status
, x_Msg_Count => x_msg_count
, x_Msg_Data => x_msg_data
);
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
aso_debug_pub.ADD ( 'Copy_Template - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
update aso_quote_line_details
set top_model_line_id = lx_qte_line_rec.quote_line_id,
ato_line_id = decode(l_ato_model,fnd_api.g_true,lx_qte_line_rec.quote_line_id,null)
where quote_line_id = lx_qte_line_rec.quote_line_id;
UPDATE aso_quote_line_details
SET config_item_id = l_new_item_id_tbl(i)
,last_update_date = SYSDATE
,last_updated_by =G_USER_ID
,last_update_login = G_LOGIN_ID
WHERE config_header_id = l_config_hdr_id
AND config_revision_num = l_config_rev_nbr
AND config_item_id = l_orig_item_id_tbl(i);
ASO_LINE_RELATIONSHIPS_PKG.Insert_Row (
px_LINE_RELATIONSHIP_ID => lx_LINE_RELATIONSHIP_ID
, p_CREATION_DATE => SYSDATE
, p_CREATED_BY => G_USER_ID
, p_LAST_UPDATED_BY => G_USER_ID
, p_LAST_UPDATE_DATE => SYSDATE
, p_LAST_UPDATE_LOGIN => G_LOGIN_ID
, p_REQUEST_ID => line_rel_rec.REQUEST_ID
, p_PROGRAM_APPLICATION_ID => line_rel_rec.PROGRAM_APPLICATION_ID
, p_PROGRAM_ID => line_rel_rec.PROGRAM_ID
, p_PROGRAM_UPDATE_DATE => line_rel_rec.PROGRAM_UPDATE_DATE
, p_QUOTE_LINE_ID => l_line_index_link_tbl ( line_rel_rec.quote_line_id )
, p_RELATED_QUOTE_LINE_ID => l_line_index_link_tbl ( line_rel_rec.related_quote_line_id )
, p_RECIPROCAL_FLAG => line_rel_rec.RECIPROCAL_FLAG
, P_RELATIONSHIP_TYPE_CODE => line_rel_rec.RELATIONSHIP_TYPE_CODE
, p_OBJECT_VERSION_NUMBER => line_rel_rec.OBJECT_VERSION_NUMBER
);
SELECT related_quote_line_id
FROM aso_line_relationships
WHERE quote_line_id = qte_ln_id
AND relationship_type_code = 'SERVICE';
SELECT line_number
FROM aso_quote_lines_all
WHERE quote_line_id = x_qte_line_id ;
aso_debug_pub.ADD ( 'Copy_Tmpl_Service - Before insert_quote_line_rows: ' || p_qte_line_id , 1 , 'Y' );
ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
p_control_rec => l_control_rec
, P_qte_Line_Rec => l_qte_line_rec
, P_qte_line_dtl_tbl => l_qte_line_dtl_tbl
, P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
, P_price_attributes_tbl => l_price_attr_tbl
, P_Price_Adj_Tbl => l_price_adj_tbl
, P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
, P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
, P_Shipment_Tbl => l_shipment_tbl
, P_Freight_Charge_Tbl => l_freight_charge_tbl
, P_Tax_Detail_Tbl => l_tax_detail_tbl
, P_Sales_Credit_Tbl => l_sales_credit_tbl
, P_Quote_Party_Tbl => l_quote_party_tbl
, x_qte_Line_Rec => lx_qte_line_rec
, x_qte_line_dtl_tbl => l_qte_line_dtl_tbl_out
, x_Line_Attribs_Ext_Tbl => l_line_attr_Ext_Tbl_out
, x_price_attributes_tbl => l_price_attr_tbl_out
, x_Price_Adj_Tbl => lx_ln_price_adj_tbl
, x_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl_out
, x_Payment_Tbl => l_payment_tbl_out
, x_Shipment_Tbl => l_shipment_tbl_out
, x_Freight_Charge_Tbl => l_freight_charge_tbl_out
, x_Tax_Detail_Tbl => l_tax_detail_tbl_out
, X_Sales_Credit_Tbl => l_sales_credit_tbl_out
, X_Quote_Party_Tbl => l_quote_party_tbl_out
, X_Return_Status => l_return_status
, X_Msg_Count => x_msg_count
, X_Msg_Data => x_msg_data
);
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
FROM ASO_Quote_Line_Details
, ASO_Quote_Lines_all
WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
AND ASO_quote_line_details.ref_type_code = 'CONFIG'
AND ASO_quote_line_details.ref_line_id is not null
AND aso_quote_lines_all.quote_header_id = qte_hdr_id
ORDER BY aso_quote_line_details.bom_sort_order;
SELECT serviceable_product_flag
FROM MTL_SYSTEM_ITEMS_VL
WHERE inventory_item_id = l_inv_item_id
AND organization_id = l_organization_id;
SELECT line_number
FROM aso_quote_lines_all
WHERE quote_line_id = x_qte_line_id ;
SELECT ASO_Quote_Line_Details.QUOTE_LINE_ID
FROM ASO_Quote_Line_Details
, ASO_Quote_Lines_all
WHERE ASO_Quote_Line_Details.config_header_id = config_hdr_id
AND ASO_Quote_Line_Details.config_revision_num = config_rev_number
AND ASO_quote_line_details.quote_line_id = ASO_Quote_Lines_all.quote_line_id
AND ASO_Quote_Lines_all.item_type_code = 'MDL'
AND aso_quote_lines_all.quote_header_id = qte_hdr_id;
aso_debug_pub.ADD ( 'Copy_Config_Tmpl - Before insert_quote_line_rows: ' || l_quote_line_id , 1 , 'Y' );
ASO_QUOTE_LINES_PVT.Insert_Quote_Line_Rows (
p_control_rec => l_control_rec
, P_qte_Line_Rec => l_qte_line_rec
, P_qte_line_dtl_tbl => l_qte_line_dtl_tbl
, P_Line_Attribs_Ext_Tbl => l_line_attr_ext_tbl
, P_price_attributes_tbl => l_price_attr_tbl
, P_Price_Adj_Tbl => l_price_adj_tbl
, P_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl
, P_Payment_Tbl => ASO_QUOTE_PUB.g_miss_payment_tbl
, P_Shipment_Tbl => l_shipment_tbl
, P_Freight_Charge_Tbl => l_freight_charge_tbl
, P_Tax_Detail_Tbl => l_tax_detail_tbl
, P_Sales_Credit_Tbl => l_sales_credit_tbl
, P_Quote_Party_Tbl => l_quote_party_tbl
, x_qte_Line_Rec => lx_qte_line_rec
, x_qte_line_dtl_tbl => l_qte_line_dtl_tbl_out
, x_Line_Attribs_Ext_Tbl => l_line_attr_Ext_Tbl_out
, x_price_attributes_tbl => l_price_attr_tbl_out
, x_Price_Adj_Tbl => lx_ln_price_adj_tbl
, x_Price_Adj_Attr_Tbl => l_Price_Adj_Attr_Tbl_out
, x_Payment_Tbl => l_payment_tbl_out
, x_Shipment_Tbl => l_shipment_tbl_out
, x_Freight_Charge_Tbl => l_freight_charge_tbl_out
, x_Tax_Detail_Tbl => l_tax_detail_tbl_out
, X_Sales_Credit_Tbl => l_sales_credit_tbl_out
, X_Quote_Party_Tbl => l_quote_party_tbl_out
, X_Return_Status => x_return_status
, X_Msg_Count => x_msg_count
, X_Msg_Data => x_msg_data
);
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );