APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 237: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(

233: l_qte_line_dtl_rec.quote_line_id := x_qte_line_rec.quote_line_id;
234: x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
235: -- BC4J Fix
236: --x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID := NULL;
237: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(
238: px_QUOTE_LINE_DETAIL_ID => x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID,
239: p_CREATION_DATE => SYSDATE,
240: p_CREATED_BY => G_USER_ID,
241: p_LAST_UPDATE_DATE => SYSDATE,

Line 1235: aso_quote_line_details detail,

1231: detail.service_duration, detail.service_period,
1232: detail.service_coterminate_flag,
1233: qhd.cust_account_id, qhd.party_id
1234: FROM aso_quote_lines_all qln,
1235: aso_quote_line_details detail,
1236: aso_quote_headers_all qhd
1237: WHERE detail.quote_line_id = qln.quote_line_id
1238: AND qln.quote_line_id = p_qte_line_rec.quote_line_id
1239: AND qln.quote_header_id = qhd.quote_header_id;

Line 4737: from aso_quote_lines_all a, aso_quote_line_details b

4733: where quote_line_id = p_quote_line_id;
4734:
4735: cursor c_order_line_type_id(p_quote_line_id NUMBER) is
4736: select a.line_category_code, a.order_line_type_id, b.config_header_id, b.config_revision_num
4737: from aso_quote_lines_all a, aso_quote_line_details b
4738: where a.quote_line_id = b.quote_line_id
4739: and a.quote_line_id = p_quote_line_id;
4740:
4741: cursor c_item_type_code is

Line 4750: from aso_quote_line_details

4746: --New code for Bug # 2498942 fix
4747:
4748: cursor c_service_exist is
4749: select quote_line_id
4750: from aso_quote_line_details
4751: where service_ref_line_id = p_qte_line_rec.quote_line_id;
4752:
4753: --New Code for updating PBH
4754:

Line 4862: select service_ref_type_code from aso_quote_line_details

4858: FROM ASO_SHIPMENTS
4859: WHERE shipment_id = p_shipment_id;
4860:
4861: cursor c_service_ref_type_code(p_quote_line_detail_id number) is
4862: select service_ref_type_code from aso_quote_line_details
4863: where quote_line_detail_id = p_quote_line_detail_id;
4864:
4865: cursor get_payment_type_code( l_payment_id Number) is
4866: select payment_type_code

Line 6864: from aso_quote_line_details

6860: last_updated_by = fnd_global.user_id,
6861: last_update_login = fnd_global.conc_login_id
6862: where NVL(line_type_source_flag,'X') <> 'C'
6863: and quote_line_id in( select quote_line_id
6864: from aso_quote_line_details
6865: where ref_line_id is not null
6866: and ref_type_code = 'CONFIG'
6867: and config_header_id = l_config_header_id
6868: and config_revision_num = l_config_revision_num );

Line 6906: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(

6902: x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
6903: -- BC4J Fix
6904: --x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID := null;
6905:
6906: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(
6907: px_QUOTE_LINE_DETAIL_ID
6908: => x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID,
6909: p_CREATION_DATE => SYSDATE,
6910: p_CREATED_BY => G_USER_ID,

Line 7027: ASO_QUOTE_LINE_DETAILS_PKG.Update_Row(

7023: ELSIF l_qte_line_dtl_tbl(i).operation_code = 'UPDATE' THEN
7024:
7025: x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
7026:
7027: ASO_QUOTE_LINE_DETAILS_PKG.Update_Row(
7028: p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.QUOTE_LINE_DETAIL_ID,
7029: p_CREATION_DATE => l_qte_line_dtl_rec.creation_date,
7030: p_CREATED_BY => G_USER_ID,
7031: p_LAST_UPDATE_DATE => SYSDATE,

Line 7145: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(

7141: END IF;
7142:
7143: ELSIF l_qte_line_dtl_tbl(i).operation_code = 'DELETE' THEN
7144:
7145: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
7146: p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.quote_line_detail_id);
7147: END IF;
7148:
7149: END LOOP;

Line 9251: FROM aso_quote_lines_all qln, aso_quote_line_details dtl

9247: and source_transaction_table = 'ASO_QUOTE_LINES_ALL';
9248:
9249: CURSOR C_config IS
9250: SELECT qln.item_type_code, dtl.config_header_id, dtl.config_revision_num, dtl.ref_type_code
9251: FROM aso_quote_lines_all qln, aso_quote_line_details dtl
9252: WHERE qln.quote_line_id = p_qte_line_rec.quote_line_id
9253: AND qln.quote_line_id = dtl.quote_line_id;
9254:
9255: CURSOR C_Children(l_quote_line_id NUMBER) IS

Line 9257: FROM aso_quote_line_details

9253: AND qln.quote_line_id = dtl.quote_line_id;
9254:
9255: CURSOR C_Children(l_quote_line_id NUMBER) IS
9256: SELECT quote_line_id
9257: FROM aso_quote_line_details
9258: WHERE ref_line_id = l_quote_line_id
9259: AND ref_type_code = 'TOP_MODEL';
9260:
9261: cursor c_pricing_line_type_indicator is

Line 9892: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(

9888: END IF;
9889:
9890: -- delete quote line details
9891: BEGIN
9892: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
9893: p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
9894:
9895: EXCEPTION
9896:

Line 10266: ( select quote_line_id from aso_quote_line_details

10262: last_update_date = sysdate,
10263: last_updated_by = fnd_global.user_id,
10264: last_update_login = fnd_global.conc_login_id
10265: where quote_line_id IN
10266: ( select quote_line_id from aso_quote_line_details
10267: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );
10268:
10269: EXCEPTION
10270: WHEN OTHERS THEN