[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'X'
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_header_id = x_qte_header_id;
SELECT ASO_QUOTE_NUMBER_S.NEXTVAL
FROM sys.DUAL;
SELECT quote_status_id
FROM ASO_QUOTE_STATUSES_B
WHERE status_code = c_status_code;
SELECT quote_number
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = X_qte_number;
SELECT quote_status_id, quote_header_id, quote_version
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_number = qte_numb
AND max_version_flag = 'Y';
SELECT 'X'
FROM ASO_QUOTE_STATUSES_B
WHERE quote_status_id = qte_status_id
AND status_code NOT IN ('ORDER SUBMITTED'
, 'APPROVAL PENDING'
, 'FINANCING PENDING'
);
SELECT Quote_Number
FROM ASO_QUOTE_HEADERS_ALL
WHERE Quote_Header_Id = qte_hdr_id;
SELECT last_update_date
FROM aso_quote_headers_all
WHERE quote_header_id = qte_hdr_id;
Select assistance_requested
FROM aso_quote_headers_all
WHERE quote_header_id = l_qte_hdr_id;
Select jtf_note_id
FROM jtf_notes_vl
WHERE note_type = 'QOT_SALES_ASSIST'
AND source_object_id = l_qte_hdr_id;
UPDATE ASO_QUOTE_HEADERS_ALL
SET Max_Version_Flag = 'N'
,last_update_date =sysdate
,last_updated_by = G_USER_ID
,last_update_login = G_LOGIN_ID
WHERE Quote_Header_Id = l_qte_header_id;
IF P_Copy_Quote_Header_Rec.price_updated_date <> FND_API.G_MISS_DATE THEN
l_qte_header_rec.price_updated_date := P_Copy_Quote_Header_Rec.price_updated_date;
IF P_Copy_Quote_Header_Rec.tax_updated_date <> FND_API.G_MISS_DATE THEN
l_qte_header_rec.tax_updated_date := P_Copy_Quote_Header_Rec.tax_updated_date;
FETCH C_Get_Last_Upd_Date INTO l_upd_qte_header_rec.last_update_date;
aso_debug_pub.ADD ( 'Copy_Quote - Before Update_Qte: x_qte_header_id '||x_qte_header_id , 1 , 'N' );
aso_quote_pub.update_quote (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_control_rec => l_control_rec,
p_qte_header_rec => l_upd_qte_header_rec,
p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
p_line_attr_ext_tbl => aso_quote_pub.g_miss_Line_Attribs_Ext_TBL,
p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_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_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
x_qte_header_rec => x_qte_header_rec,
x_qte_line_tbl => x_qte_line_tbl,
x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
x_hd_payment_tbl => x_hd_payment_tbl,
x_hd_shipment_tbl => x_hd_shipment_tbl,
x_hd_freight_charge_tbl => x_hd_freight_charge_tbl,
x_hd_tax_detail_tbl => x_hd_tax_detail_tbl,
x_line_attr_ext_tbl => x_line_attr_ext_tbl,
x_line_rltship_tbl => x_line_rltship_tbl,
x_price_adjustment_tbl => x_price_adjustment_tbl,
x_price_adj_attr_tbl => x_price_adj_attr_tbl,
x_price_adj_rltship_tbl => x_price_adj_rltship_tbl,
x_ln_price_attributes_tbl => x_ln_price_attributes_tbl,
x_ln_payment_tbl => x_ln_payment_tbl,
x_ln_shipment_tbl => x_ln_shipment_tbl,
x_ln_freight_charge_tbl => x_ln_freight_charge_tbl,
x_ln_tax_detail_tbl => x_ln_tax_detail_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
aso_debug_pub.ADD ( 'Copy_Quote - After Update_Quote (Reprice/tax): l_return_status '||
l_return_status , 1 ,'N' );
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_note_context_type_id => x_qte_header_id ,
p_note_context_type => 'ASO_QUOTE' ,
x_note_context_id => lx_jtf_note_context_id
);
SELECT RESOURCE_ID,
RESOURCE_GRP_ID,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
KEEP_FLAG,
UPDATE_ACCESS_FLAG,
CREATED_BY_TAP_FLAG,
TERRITORY_ID,
TERRITORY_SOURCE_FLAG,
ROLE_ID,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ATTRIBUTE16,
ATTRIBUTE17,
ATTRIBUTE18,
ATTRIBUTE19,
ATTRIBUTE20,
OBJECT_VERSION_NUMBER
FROM ASO_QUOTE_ACCESSES
WHERE QUOTE_NUMBER = l_qte_num;
SELECT Quote_Number
FROM ASO_QUOTE_HEADERS_ALL
WHERE QUote_Header_Id = l_hdr_id;
l_qte_header_rec.price_updated_date := NULL;
l_qte_header_rec.tax_updated_date := NULL;
ASO_QUOTE_HEADERS_PVT.Insert_Rows (
p_qte_header_rec => l_qte_header_rec
, p_Price_Attributes_Tbl => l_price_attr_tbl
, P_Price_Adjustment_Tbl => l_price_adj_tbl
, P_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl
, P_Payment_Tbl => l_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_hd_Attr_Ext_Tbl => l_Line_Attr_Ext_Tbl
, P_Sales_Credit_Tbl => l_sales_credit_tbl
, P_Quote_Party_Tbl => l_Quote_Party_Tbl
, P_qte_access_Tbl => l_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 => lx_hd_Price_Adj_Tbl
, x_Price_Adj_Attr_Tbl => l_price_adj_attr_tbl_out
, x_Payment_Tbl => l_payment_tbl_out
, x_Shipment_Rec => l_shipment_rec
, x_Freight_Charge_Tbl => l_freight_charge_tbl_out
, x_Tax_Detail_Tbl => l_tax_detail_tbl_out
, x_hd_Attr_Ext_Tbl => x_hd_Attr_Ext_Tbl
, x_sales_credit_tbl => x_sales_credit_tbl
, x_quote_party_tbl => x_quote_party_tbl
, x_qte_access_Tbl => x_qte_access_tbl
, X_Return_Status => l_return_status
, X_Msg_Count => x_msg_count
, X_Msg_Data => x_msg_data
);
aso_debug_pub.ADD ( 'Copy_Rows - After insert_rows - status: ' || l_return_status , 1 , 'Y' );
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
ASO_QUOTE_ACCESSES_PKG.Insert_Row(
px_ACCESS_ID => l_sequence,
p_QUOTE_NUMBER => l_qte_header_rec.Quote_Number,
p_RESOURCE_ID => C_Sales_Team_Rec.Resource_Id,
p_RESOURCE_GRP_ID => C_Sales_Team_Rec.Resource_Grp_Id,
p_CREATED_BY => G_USER_ID,
p_CREATION_DATE => SYSDATE,
p_LAST_UPDATED_BY => G_USER_ID,
p_LAST_UPDATE_LOGIN => G_LOGIN_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_REQUEST_ID => C_Sales_Team_Rec.Request_Id,
p_PROGRAM_APPLICATION_ID => C_Sales_Team_Rec.Program_Application_Id,
p_PROGRAM_ID => C_Sales_Team_Rec.Program_Id,
p_PROGRAM_UPDATE_DATE => C_Sales_Team_Rec.Program_Update_Date,
p_KEEP_FLAG => C_Sales_Team_Rec.Keep_Flag,
p_UPDATE_ACCESS_FLAG => C_Sales_Team_Rec.Update_Access_Flag,
p_CREATED_BY_TAP_FLAG => C_Sales_Team_Rec.Created_By_Tap_Flag,
p_TERRITORY_ID => C_Sales_Team_Rec.Territory_Id,
p_TERRITORY_SOURCE_FLAG => C_Sales_Team_Rec.Territory_Source_Flag,
p_ROLE_ID => C_Sales_Team_Rec.Role_Id,
p_ATTRIBUTE_CATEGORY => C_Sales_Team_Rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => C_Sales_Team_Rec.ATTRIBUTE1,
p_ATTRIBUTE2 => C_Sales_Team_Rec.ATTRIBUTE2,
p_ATTRIBUTE3 => C_Sales_Team_Rec.ATTRIBUTE3,
p_ATTRIBUTE4 => C_Sales_Team_Rec.ATTRIBUTE4,
p_ATTRIBUTE5 => C_Sales_Team_Rec.ATTRIBUTE5,
p_ATTRIBUTE6 => C_Sales_Team_Rec.ATTRIBUTE6,
p_ATTRIBUTE7 => C_Sales_Team_Rec.ATTRIBUTE7,
p_ATTRIBUTE8 => C_Sales_Team_Rec.ATTRIBUTE8,
p_ATTRIBUTE9 => C_Sales_Team_Rec.ATTRIBUTE9,
p_ATTRIBUTE10 => C_Sales_Team_Rec.ATTRIBUTE10,
p_ATTRIBUTE11 => C_Sales_Team_Rec.ATTRIBUTE11,
p_ATTRIBUTE12 => C_Sales_Team_Rec.ATTRIBUTE12,
p_ATTRIBUTE13 => C_Sales_Team_Rec.ATTRIBUTE13,
p_ATTRIBUTE14 => C_Sales_Team_Rec.ATTRIBUTE14,
p_ATTRIBUTE15 => C_Sales_Team_Rec.ATTRIBUTE15,
p_ATTRIBUTE16 => C_Sales_Team_Rec.ATTRIBUTE16,
p_ATTRIBUTE17 => C_Sales_Team_Rec.ATTRIBUTE17,
p_ATTRIBUTE18 => C_Sales_Team_Rec.ATTRIBUTE18,
p_ATTRIBUTE19 => C_Sales_Team_Rec.ATTRIBUTE19,
p_ATTRIBUTE20 => C_Sales_Team_Rec.ATTRIBUTE20,
p_Object_Version_Number => C_Sales_Team_Rec.OBJECT_VERSION_NUMBER
);
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 apr.ADJ_RELATIONSHIP_ID, apr.CREATION_DATE, apr.CREATED_BY
, apr.LAST_UPDATE_DATE, apr.LAST_UPDATED_BY
, apr.LAST_UPDATE_LOGIN, apr.PROGRAM_APPLICATION_ID
, apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
, apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
, apr.RLTD_PRICE_ADJ_ID , apr.OBJECT_VERSION_NUMBER
FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
, ASO_PRICE_ADJUSTMENTS apa
WHERE apr.price_adjustment_id = apa.price_adjustment_id
AND apa.quote_header_id = x_quote_header_id
AND EXISTS ( SELECT 'x'
FROM aso_quote_lines_all aql
WHERE aql.quote_header_id = x_quote_header_id
AND apr.quote_line_id = aql.quote_line_id );
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;
SELECT apr.ADJ_RELATIONSHIP_ID, apr.CREATION_DATE, apr.CREATED_BY
, apr.LAST_UPDATE_DATE, apr.LAST_UPDATED_BY
, apr.LAST_UPDATE_LOGIN, apr.PROGRAM_APPLICATION_ID
, apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
, apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
, apr.RLTD_PRICE_ADJ_ID
, apr.OBJECT_VERSION_NUMBER
FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
, ASO_PRICE_ADJUSTMENTS apa
WHERE apr.price_adjustment_id = apa.price_adjustment_id
AND apr.quote_line_id = x_quote_line_id
AND apa.quote_line_id = x_quote_line_id
AND apa.modifier_line_type_code <> 'PRG';
l_last_update_date DATE;
Select
LAST_UPDATE_DATE
From ASO_QUOTE_HEADERS_ALL
Where QUOTE_HEADER_ID = c_QUOTE_HEADER_ID;
Select Max(Line_number)
From ASO_QUOTE_LINES_ALL
WHERE quote_header_id = c_QUOTE_HEADER_ID;
Fetch C_Get_quote into l_LAST_UPDATE_DATE;
FND_MESSAGE.Set_Name('ASO', 'ASO_API_MISSING_UPDATE_TARGET');
If (l_last_update_date is NULL or
l_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('ASO', 'ASO_API_MISSING_COLUMN');
FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
If (l_last_update_date <> p_qte_header_rec.last_update_date) Then
IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
FND_MESSAGE.Set_Name('ASO', 'ASO_API_RECORD_CHANGED');
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_Rows - 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;
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
aso_debug_pub.ADD ( 'Copy_Rows - After insert_quote_line_rows - status: ' || l_return_status , 1 , 'Y' );
ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => P_Init_Msg_List,
P_Commit => P_Commit,
P_OLD_QUOTE_LINE_ID => L_QTE_LINE_ID,
P_NEW_QUOTE_LINE_ID => lx_qte_line_rec.quote_line_id,
X_Return_Status => l_return_status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data );
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_PRICE_RLTSHIPS_PKG.Insert_Row (
px_ADJ_RELATIONSHIP_ID => lx_price_adj_rltship_id
, p_creation_date => SYSDATE
, p_CREATED_BY => G_USER_ID
, p_LAST_UPDATE_DATE => SYSDATE
, p_LAST_UPDATED_BY => G_USER_ID
, p_LAST_UPDATE_LOGIN => G_LOGIN_ID
, p_PROGRAM_APPLICATION_ID => price_adj_rltship_rec.PROGRAM_APPLICATION_ID
, p_PROGRAM_ID => price_adj_rltship_rec.PROGRAM_ID
, p_PROGRAM_UPDATE_DATE => price_adj_rltship_rec.PROGRAM_UPDATE_DATE
, p_REQUEST_ID => price_adj_rltship_rec.REQUEST_ID
, p_QUOTE_LINE_ID => l_line_index_link_tbl ( price_adj_rltship_rec.quote_line_id )
, p_PRICE_ADJUSTMENT_ID => l_price_index_link_tbl ( price_adj_rltship_rec.price_adjustment_id )
, p_RLTD_PRICE_ADJ_ID => l_price_index_link_tbl ( price_adj_rltship_rec.rltd_price_adj_id )
, p_QUOTE_SHIPMENT_ID => l_ship_id
, p_OBJECT_VERSION_NUMBER => price_adj_rltship_rec.OBJECT_VERSION_NUMBER
);
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
);
ASO_PRICE_RLTSHIPS_PKG.Insert_Row (
px_ADJ_RELATIONSHIP_ID => lx_price_adj_rltship_id
, p_creation_date => SYSDATE
, p_CREATED_BY => G_USER_ID
, p_LAST_UPDATE_DATE => SYSDATE
, p_LAST_UPDATED_BY => G_USER_ID
, p_LAST_UPDATE_LOGIN => G_LOGIN_ID
, p_PROGRAM_APPLICATION_ID => price_adj_rltship_rec.PROGRAM_APPLICATION_ID
, p_PROGRAM_ID => price_adj_rltship_rec.PROGRAM_ID
, p_PROGRAM_UPDATE_DATE => price_adj_rltship_rec.PROGRAM_UPDATE_DATE
, p_REQUEST_ID => price_adj_rltship_rec.REQUEST_ID
, p_QUOTE_LINE_ID => l_line_index_link_tbl ( price_adj_rltship_rec.quote_line_id )
, p_PRICE_ADJUSTMENT_ID => l_price_index_link_tbl ( price_adj_rltship_rec.price_adjustment_id )
, p_RLTD_PRICE_ADJ_ID => l_price_index_link_tbl ( price_adj_rltship_rec.rltd_price_adj_id )
, p_QUOTE_SHIPMENT_ID => l_ship_id
, p_OBJECT_VERSION_NUMBER => price_adj_rltship_rec.OBJECT_VERSION_NUMBER
);
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
);
aso_debug_pub.ADD ( 'Calling Update Quote to re-price the quote ', 1 , 'N' );
l_Qte_Header_Rec.last_update_date := l_last_update_date;
l_Qte_Header_Rec.price_updated_date := P_Qte_Header_Rec.price_updated_date;
l_Qte_Header_Rec.tax_updated_date := P_Qte_Header_Rec.tax_updated_date;
aso_quote_pub.update_quote (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_control_rec => p_control_rec,
p_qte_header_rec => l_Qte_Header_Rec,
p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
p_qte_line_tbl => aso_quote_pub.g_miss_qte_line_tbl,
p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_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_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
x_qte_header_rec => x_qte_header_rec,
x_qte_line_tbl => x_qte_line_tbl,
x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
x_hd_payment_tbl => x_hd_payment_tbl,
x_hd_shipment_tbl => x_hd_shipment_tbl,
x_hd_freight_charge_tbl => x_hd_freight_charge_tbl,
x_hd_tax_detail_tbl => x_hd_tax_detail_tbl,
x_line_attr_ext_tbl => x_line_attr_ext_tbl,
x_line_rltship_tbl => x_line_rltship_tbl,
x_price_adjustment_tbl => x_price_adjustment_tbl,
x_price_adj_attr_tbl => x_price_adj_attr_tbl,
x_price_adj_rltship_tbl => x_price_adj_rltship_tbl,
x_ln_price_attributes_tbl => x_ln_price_attributes_tbl,
x_ln_payment_tbl => x_ln_payment_tbl,
x_ln_shipment_tbl => x_ln_shipment_tbl,
x_ln_freight_charge_tbl => x_ln_freight_charge_tbl,
x_ln_tax_detail_tbl => x_ln_tax_detail_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
aso_debug_pub.ADD ( ' Return Status from Update Quote = '||l_return_status, 1 , 'N' );
aso_debug_pub.ADD ( ' After Calling Update Quote ', 1 , 'N' );
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 - 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 );
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_OLD_QUOTE_LINE_ID => qte_line_id,
P_NEW_QUOTE_LINE_ID => lx_qte_line_rec.quote_line_id,
X_Return_Status => l_return_status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data );
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_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 );
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => FND_API.G_FALSE,
P_Commit => FND_API.G_FALSE,
P_OLD_QUOTE_LINE_ID => qte_line_id,
P_NEW_QUOTE_LINE_ID => lx_qte_line_rec.quote_line_id,
X_Return_Status => l_return_status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data );
SELECT End_Date
FROM GL_PERIODS_V
WHERE Period_Type = l_Def_Per
AND Period_Set_Name = l_Def_Cal
AND SYSDATE BETWEEN Start_Date AND End_Date;
SELECT template_instance_id, template_id
FROM aso_sup_tmpl_instance
WHERE owner_table_name = 'ASO_QUOTE_HEADERS'
AND owner_table_id = qte_header_id;
SELECT sect_comp_map_id, VALUE, value_type_qualifier, response_id
FROM aso_sup_instance_value
WHERE template_instance_id = temp_instance_id;
aso_debug_pub.ADD ( 'Inserting a row into tmpl_instance table' , 1 , 'N' );
ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
PX_ROWID => l_template_instance_rowid
, PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
, P_created_by => FND_GLOBAL.USER_ID
, P_creation_date => SYSDATE
, P_last_updated_by => FND_GLOBAL.USER_ID
, P_last_update_date => SYSDATE
, P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
, P_TEMPLATE_ID => template_val.template_id
, P_Owner_Table_Name => 'ASO_QUOTE_HEADERS'
, P_Owner_Table_Id => p_new_quote_header_id
, P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
);
aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
PX_ROWID => l_sup_instance_rowid
, PX_INSTANCE_VALUE_ID => l_instance_value_id
, P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id
, P_Template_Instance_ID => l_new_template_instance_id
, p_value => inst_val.VALUE
, p_value_type_qualifier => inst_val.value_type_qualifier
, p_response_id => inst_val.response_id
, P_created_by => FND_GLOBAL.USER_ID
, P_last_updated_by => FND_GLOBAL.USER_ID
, P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
, P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
);
SELECT request_id, program_application_id, program_id, program_update_date,
quote_object_type_code, quote_object_id, object_type_code, object_id,
relationship_type_code, reciprocal_flag
FROM ASO_QUOTE_RELATED_OBJECTS
WHERE relationship_type_code = 'OPP_QUOTE'
AND quote_object_id = qte_hdr;
l_related_obj_rec.program_id, l_related_obj_rec.program_update_date,
l_related_obj_rec.quote_object_type_code, l_related_obj_rec.quote_object_id,
l_related_obj_rec.object_type_code, l_related_obj_rec.object_id,
l_related_obj_rec.relationship_type_code, l_related_obj_rec.reciprocal_flag;
aso_debug_pub.ADD ( 'Copy_Opp_Quote: before insert rel object ', 1 , 'N' );
aso_debug_pub.ADD ( 'Copy_Opp_Quote: after insert_rel_object:x_return_status: ' || x_return_status, 1 , 'N' );
SELECT 'X'
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_header_id = x_qte_header_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 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 apr.ADJ_RELATIONSHIP_ID, apr.CREATION_DATE, apr.CREATED_BY
, apr.LAST_UPDATE_DATE, apr.LAST_UPDATED_BY
, apr.LAST_UPDATE_LOGIN, apr.PROGRAM_APPLICATION_ID
, apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
, apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
, apr.RLTD_PRICE_ADJ_ID, apr.OBJECT_VERSION_NUMBER
FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
, ASO_PRICE_ADJUSTMENTS apa
WHERE apr.price_adjustment_id = apa.price_adjustment_id
AND apr.quote_line_id = x_quote_line_id
AND apa.quote_line_id = x_quote_line_id
AND apa.modifier_line_type_code <> 'PRG';
SELECT shipment_id
FROM ASO_SHIPMENTS
WHERE quote_line_id = lc_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;
SELECT last_update_date
FROM aso_quote_headers_all
WHERE quote_header_id = c_quote_header_id;
Select Max(Line_number)
From ASO_QUOTE_LINES_ALL
WHERE quote_header_id = c_QUOTE_HEADER_ID;
TYPE inserted_qte_line_Rec_Type IS RECORD
(
quote_line_id NUMBER:= FND_API.G_MISS_NUM,
quantity NUMBER := FND_API.G_MISS_NUM
);
TYPE inserted_qte_line_Tbl_Type IS TABLE OF inserted_qte_line_Rec_Type INDEX BY BINARY_INTEGER;
G_MISS_inserted_qte_line_Rec inserted_qte_line_Rec_Type;
G_MISS_inserted_qte_line_tbl inserted_qte_line_tbl_type;
l_inserted_qte_line_tbl inserted_qte_line_Tbl_Type := G_MISS_inserted_qte_line_tbl;
aso_debug_pub.ADD ( 'Split_Model_Line - Before insert_quote_line_rows: ' ||
P_Original_Qte_Line_Rec.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_detail_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_detail_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 ( 'Split_Model_Line - 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;
l_inserted_qte_line_tbl(i).quote_line_id := lx_qte_line_rec.quote_line_id;
l_inserted_qte_line_tbl(i).quantity := l_qty_qte_line_tbl(i).quantity;
FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_SPLITLINE AFTER_INSERT' , TRUE );
ASO_COPY_QUOTE_PVT.INSERT_SALES_SUPP_DATA
(
P_Api_Version_Number => 1.0,
P_Init_Msg_List => P_Init_Msg_List,
P_Commit => P_Commit,
P_OLD_QUOTE_LINE_ID => P_Original_Qte_Line_Rec.quote_line_id,
P_NEW_QUOTE_LINE_ID => lx_qte_line_rec.quote_line_id,
X_Return_Status => l_return_status,
X_Msg_Count => X_Msg_Count,
X_Msg_Data => X_Msg_Data );
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_PRICE_RLTSHIPS_PKG.Insert_Row (
px_ADJ_RELATIONSHIP_ID => lx_price_adj_rltship_id
, p_creation_date => SYSDATE
, p_CREATED_BY => G_USER_ID
, p_LAST_UPDATE_DATE => SYSDATE
, p_LAST_UPDATED_BY => G_USER_ID
, p_LAST_UPDATE_LOGIN => G_LOGIN_ID
, p_PROGRAM_APPLICATION_ID => price_adj_rltship_rec.PROGRAM_APPLICATION_ID
, p_PROGRAM_ID => price_adj_rltship_rec.PROGRAM_ID
, p_PROGRAM_UPDATE_DATE => price_adj_rltship_rec.PROGRAM_UPDATE_DATE
, p_REQUEST_ID => price_adj_rltship_rec.REQUEST_ID
, p_QUOTE_LINE_ID => l_line_index_link_tbl ( price_adj_rltship_rec.quote_line_id )
, p_PRICE_ADJUSTMENT_ID => l_price_index_link_tbl ( price_adj_rltship_rec.price_adjustment_id )
, p_RLTD_PRICE_ADJ_ID => l_price_index_link_tbl ( price_adj_rltship_rec.rltd_price_adj_id )
, p_QUOTE_SHIPMENT_ID => l_ship_id
, p_OBJECT_VERSION_NUMBER => price_adj_rltship_rec.OBJECT_VERSION_NUMBER
);
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
);
aso_debug_pub.ADD ( ' Getting the last update date of the quote before updating the quote ', 1 , 'N' );
FETCH get_latest_date INTO l_quote_header_rec.last_update_date;
l_control_rec.last_update_date := l_quote_header_rec.last_update_date;
FOR i in 1..l_inserted_qte_line_tbl.count LOOP
l_qte_line_tbl(i).quote_header_id := P_Qte_Header_Rec.quote_header_id;
l_qte_line_tbl(i).quantity := l_inserted_qte_line_tbl(i).quantity;
l_qte_line_tbl(i).quote_line_id := l_inserted_qte_line_tbl(i).quote_line_id;
l_qte_line_tbl(i).operation_code := 'UPDATE';
aso_debug_pub.ADD ( 'New Qte Line '|| to_char(l_inserted_qte_line_tbl(i).quote_line_id), 1 , 'N' );
aso_debug_pub.ADD ( 'New Qty '|| to_char(l_inserted_qte_line_tbl(i).quantity), 1 , 'N' );
aso_debug_pub.ADD ( ' Setting the qty and op code for orig line to be updated ', 1 , 'N' );
l_qte_line_tbl(l_total_lines + 1).operation_code := 'UPDATE';
aso_debug_pub.ADD ( 'No Of Qte Lines before update qty = '|| to_char(l_qte_line_tbl.count), 1 , 'N' );
aso_debug_pub.ADD ( ' Calling Update Quote to update all lines ', 1 , 'N' );
aso_quote_pub.update_quote (
p_api_version_number => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_control_rec => p_control_rec,
p_qte_header_rec => l_quote_header_rec,
p_hd_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_hd_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_hd_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_hd_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_hd_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
p_qte_line_tbl => l_qte_line_tbl,
p_qte_line_dtl_tbl => aso_quote_pub.g_miss_qte_line_dtl_tbl,
p_line_attr_ext_tbl => aso_quote_pub.G_MISS_Line_Attribs_Ext_TBL,
p_line_rltship_tbl => aso_quote_pub.g_miss_line_rltship_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_price_adj_rltship_tbl => aso_quote_pub.g_miss_price_adj_rltship_tbl,
p_ln_price_attributes_tbl => aso_quote_pub.g_miss_price_attributes_tbl,
p_ln_payment_tbl => aso_quote_pub.g_miss_payment_tbl,
p_ln_shipment_tbl => aso_quote_pub.g_miss_shipment_tbl,
p_ln_freight_charge_tbl => aso_quote_pub.g_miss_freight_charge_tbl,
p_ln_tax_detail_tbl => aso_quote_pub.g_miss_tax_detail_tbl,
x_qte_header_rec => x_qte_header_rec,
x_qte_line_tbl => x_qte_line_tbl,
x_qte_line_dtl_tbl => x_qte_line_dtl_tbl,
x_hd_price_attributes_tbl => x_hd_price_attributes_tbl,
x_hd_payment_tbl => x_hd_payment_tbl,
x_hd_shipment_tbl => x_hd_shipment_tbl,
x_hd_freight_charge_tbl => x_hd_freight_charge_tbl,
x_hd_tax_detail_tbl => x_hd_tax_detail_tbl,
x_line_attr_ext_tbl => x_line_attr_ext_tbl,
x_line_rltship_tbl => x_line_rltship_tbl,
x_price_adjustment_tbl => x_price_adjustment_tbl,
x_price_adj_attr_tbl => x_price_adj_attr_tbl,
x_price_adj_rltship_tbl => x_price_adj_rltship_tbl,
x_ln_price_attributes_tbl => x_ln_price_attributes_tbl,
x_ln_payment_tbl => x_ln_payment_tbl,
x_ln_shipment_tbl => x_ln_shipment_tbl,
x_ln_freight_charge_tbl => x_ln_freight_charge_tbl,
x_ln_tax_detail_tbl => x_ln_tax_detail_tbl,
x_return_status => l_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data
);
aso_debug_pub.ADD ( ' Return Status from Update Quote = '||l_return_status, 1 , 'N' );
aso_debug_pub.ADD ( ' After Calling Update Quote to update all lines ', 1 , 'N' );
PROCEDURE INSERT_SALES_SUPP_DATA
(
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_OLD_QUOTE_LINE_ID IN NUMBER,
P_NEW_QUOTE_LINE_ID IN NUMBER,
X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Count OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2 ) IS
CURSOR get_template_id (
qte_line_id NUMBER
) IS
SELECT template_instance_id, template_id
FROM aso_sup_tmpl_instance
WHERE owner_table_name = 'ASO_QUOTE_LINES'
AND owner_table_id = qte_line_id;
SELECT sect_comp_map_id, VALUE, value_type_qualifier, response_id
FROM aso_sup_instance_value
WHERE template_instance_id = temp_instance_id;
l_api_name VARCHAR2 ( 150 ) := 'INSERT_SALES_SUPP_DATA';
SAVEPOINT INSERT_SALES_SUPP_DATA_PVT;
aso_debug_pub.ADD ('INSERT_SALES_SUPP_DATA: Begin' , 1, 'N' );
aso_debug_pub.ADD ( 'Inserting a row into tmpl_instance table' , 1 , 'N' );
ASO_SUP_TMPL_INSTANCE_PKG.INSERT_ROW (
PX_ROWID => l_template_instance_rowid
, PX_TEMPLATE_INSTANCE_ID => l_new_template_instance_id
, P_created_by => FND_GLOBAL.USER_ID
, P_creation_date => SYSDATE
, P_last_updated_by => FND_GLOBAL.USER_ID
, P_last_update_date => SYSDATE
, P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
, P_TEMPLATE_ID => template_val.template_id
, P_Owner_Table_Name => 'ASO_QUOTE_LINES'
, P_Owner_Table_Id => P_NEW_QUOTE_LINE_ID
, P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
);
aso_debug_pub.ADD ( 'Inserting a row into instance_value table' , 1 , 'N' );
ASO_SUP_INSTANCE_VALUE_PKG.INSERT_ROW (
PX_ROWID => l_sup_instance_rowid
, PX_INSTANCE_VALUE_ID => l_instance_value_id
, P_SECT_COMP_MAP_ID => inst_val.sect_comp_map_id
, P_Template_Instance_ID => l_new_template_instance_id
, p_value => inst_val.VALUE
, p_value_type_qualifier => inst_val.value_type_qualifier
, p_response_id => inst_val.response_id
, P_created_by => FND_GLOBAL.USER_ID
, P_last_updated_by => FND_GLOBAL.USER_ID
, P_last_update_login => FND_GLOBAL.CONC_LOGIN_ID
, P_OBJECT_VERSION_NUMBER => FND_API.G_MISS_NUM
);
aso_debug_pub.ADD ( 'INSERT_SALES_SUPP_DATA: ' || l_api_name || 'end' , 1 , 'N' );
END INSERT_SALES_SUPP_DATA;
select a.party_id, a.instr_assignment_id
from iby_fndcpt_payer_assgn_instr_v a, IBY_TRXN_EXTENSIONS_V b
where a.instr_assignment_id = b.instr_assignment_id
and b.trxn_extension_id = p_trxn_extension_id;
SELECT ASO_PAYMENTS_S.nextval FROM sys.dual;
ASO_PAYMENTS_PKG.Insert_Row(
px_PAYMENT_ID => l_payment_rec.PAYMENT_ID,
p_CREATION_DATE => SYSDATE,
p_CREATED_BY => fnd_global.USER_ID,
p_LAST_UPDATE_DATE => SYSDATE,
p_LAST_UPDATED_BY => fnd_global.USER_ID,
p_LAST_UPDATE_LOGIN => FND_GLOBAL.CONC_LOGIN_ID,
p_REQUEST_ID => l_payment_rec.REQUEST_ID,
p_PROGRAM_APPLICATION_ID => l_payment_rec.PROGRAM_APPLICATION_ID,
p_PROGRAM_ID => l_payment_rec.PROGRAM_ID,
p_PROGRAM_UPDATE_DATE => l_payment_rec.PROGRAM_UPDATE_DATE,
p_QUOTE_HEADER_ID => l_payment_rec.QUOTE_HEADER_ID,
p_QUOTE_LINE_ID => l_payment_rec.QUOTE_LINE_ID,
p_QUOTE_SHIPMENT_ID => l_payment_rec.QUOTE_SHIPMENT_ID ,
p_PAYMENT_TYPE_CODE => l_payment_rec.PAYMENT_TYPE_CODE,
p_PAYMENT_REF_NUMBER => l_payment_ref_number,
p_PAYMENT_OPTION => l_payment_rec.PAYMENT_OPTION,
p_PAYMENT_TERM_ID => l_payment_rec.PAYMENT_TERM_ID,
p_CREDIT_CARD_CODE => null,
p_CREDIT_CARD_HOLDER_NAME => null,
p_CREDIT_CARD_EXPIRATION_DATE => null,
p_CREDIT_CARD_APPROVAL_CODE => null,
p_CREDIT_CARD_APPROVAL_DATE => null,
p_PAYMENT_AMOUNT => l_payment_rec.PAYMENT_AMOUNT,
p_ATTRIBUTE_CATEGORY => l_payment_rec.ATTRIBUTE_CATEGORY,
p_ATTRIBUTE1 => l_payment_rec.ATTRIBUTE1,
p_ATTRIBUTE2 => l_payment_rec.ATTRIBUTE2,
p_ATTRIBUTE3 => l_payment_rec.ATTRIBUTE3,
p_ATTRIBUTE4 => l_payment_rec.ATTRIBUTE4,
p_ATTRIBUTE5 => l_payment_rec.ATTRIBUTE5,
p_ATTRIBUTE6 => l_payment_rec.ATTRIBUTE6,
p_ATTRIBUTE7 => l_payment_rec.ATTRIBUTE7,
p_ATTRIBUTE8 => l_payment_rec.ATTRIBUTE8,
p_ATTRIBUTE9 => l_payment_rec.ATTRIBUTE9,
p_ATTRIBUTE10 => l_payment_rec.ATTRIBUTE10,
p_ATTRIBUTE11 => l_payment_rec.ATTRIBUTE11,
p_ATTRIBUTE12 => l_payment_rec.ATTRIBUTE12,
p_ATTRIBUTE13 => l_payment_rec.ATTRIBUTE13,
p_ATTRIBUTE14 => l_payment_rec.ATTRIBUTE14,
p_ATTRIBUTE15 => l_payment_rec.ATTRIBUTE15,
p_ATTRIBUTE16 => l_payment_rec.ATTRIBUTE16,
p_ATTRIBUTE17 => l_payment_rec.ATTRIBUTE17,
p_ATTRIBUTE18 => l_payment_rec.ATTRIBUTE18,
p_ATTRIBUTE19 => l_payment_rec.ATTRIBUTE19,
p_ATTRIBUTE20 => l_payment_rec.ATTRIBUTE20,
p_CUST_PO_NUMBER => l_payment_rec.CUST_PO_NUMBER,
p_PAYMENT_TERM_ID_FROM => l_payment_rec.PAYMENT_TERM_ID_FROM,
p_OBJECT_VERSION_NUMBER => l_payment_rec.OBJECT_VERSION_NUMBER,
p_CUST_PO_LINE_NUMBER => l_payment_rec.CUST_PO_LINE_NUMBER,
p_trxn_extension_id => l_payment_rec.trxn_extension_id
);