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 6746: from aso_quote_line_details

6742: last_updated_by = fnd_global.user_id,
6743: last_update_login = fnd_global.conc_login_id
6744: where NVL(line_type_source_flag,'X') <> 'C'
6745: and quote_line_id in( select quote_line_id
6746: from aso_quote_line_details
6747: where ref_line_id is not null
6748: and ref_type_code = 'CONFIG'
6749: and config_header_id = l_config_header_id
6750: and config_revision_num = l_config_revision_num );

Line 6788: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(

6784: x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
6785: -- BC4J Fix
6786: --x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID := null;
6787:
6788: ASO_QUOTE_LINE_DETAILS_PKG.Insert_Row(
6789: px_QUOTE_LINE_DETAIL_ID
6790: => x_qte_line_dtl_tbl(i).QUOTE_LINE_DETAIL_ID,
6791: p_CREATION_DATE => SYSDATE,
6792: p_CREATED_BY => G_USER_ID,

Line 6909: ASO_QUOTE_LINE_DETAILS_PKG.Update_Row(

6905: ELSIF l_qte_line_dtl_tbl(i).operation_code = 'UPDATE' THEN
6906:
6907: x_qte_line_dtl_tbl(i) := l_qte_line_dtl_rec;
6908:
6909: ASO_QUOTE_LINE_DETAILS_PKG.Update_Row(
6910: p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.QUOTE_LINE_DETAIL_ID,
6911: p_CREATION_DATE => l_qte_line_dtl_rec.creation_date,
6912: p_CREATED_BY => G_USER_ID,
6913: p_LAST_UPDATE_DATE => SYSDATE,

Line 7027: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(

7023: END IF;
7024:
7025: ELSIF l_qte_line_dtl_tbl(i).operation_code = 'DELETE' THEN
7026:
7027: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
7028: p_QUOTE_LINE_DETAIL_ID => l_qte_line_dtl_rec.quote_line_detail_id);
7029: END IF;
7030:
7031: END LOOP;

Line 9133: FROM aso_quote_lines_all qln, aso_quote_line_details dtl

9129: and source_transaction_table = 'ASO_QUOTE_LINES_ALL';
9130:
9131: CURSOR C_config IS
9132: SELECT qln.item_type_code, dtl.config_header_id, dtl.config_revision_num, dtl.ref_type_code
9133: FROM aso_quote_lines_all qln, aso_quote_line_details dtl
9134: WHERE qln.quote_line_id = p_qte_line_rec.quote_line_id
9135: AND qln.quote_line_id = dtl.quote_line_id;
9136:
9137: CURSOR C_Children(l_quote_line_id NUMBER) IS

Line 9139: FROM aso_quote_line_details

9135: AND qln.quote_line_id = dtl.quote_line_id;
9136:
9137: CURSOR C_Children(l_quote_line_id NUMBER) IS
9138: SELECT quote_line_id
9139: FROM aso_quote_line_details
9140: WHERE ref_line_id = l_quote_line_id
9141: AND ref_type_code = 'TOP_MODEL';
9142:
9143: cursor c_pricing_line_type_indicator is

Line 9774: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(

9770: END IF;
9771:
9772: -- delete quote line details
9773: BEGIN
9774: ASO_QUOTE_LINE_DETAILS_PKG.Delete_Row(
9775: p_QUOTE_LINE_ID => p_qte_line_rec.quote_line_id);
9776:
9777: EXCEPTION
9778:

Line 10148: ( select quote_line_id from aso_quote_line_details

10144: last_update_date = sysdate,
10145: last_updated_by = fnd_global.user_id,
10146: last_update_login = fnd_global.conc_login_id
10147: where quote_line_id IN
10148: ( select quote_line_id from aso_quote_line_details
10149: where service_ref_type_code = 'QUOTE' and service_ref_line_id = l_qte_line_rec.quote_line_id );
10150:
10151: EXCEPTION
10152: WHEN OTHERS THEN