APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_TAX_DETAILS

Line 1193: ASO_TAX_DETAILS_PKG.Insert_Row(

1189: l_tax_detail_rec := x_tax_detail_tbl(i);
1190: -- BC4J Fix
1191: --x_tax_detail_tbl(i).TAX_DETAIL_ID := NULL;
1192: l_sysdate := sysdate;
1193: ASO_TAX_DETAILS_PKG.Insert_Row(
1194: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
1195: p_CREATION_DATE => SYSDATE,
1196: p_CREATED_BY => G_USER_ID,
1197: p_LAST_UPDATE_DATE => l_sysdate,

Line 2654: ASO_TAX_DETAILS_PKG.Insert_Row(

2650: l_tax_detail_rec := x_tax_detail_tbl(i);
2651: -- BC4J Fix
2652: --x_tax_detail_tbl(i).TAX_DETAIL_ID := NULL;
2653: x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2654: ASO_TAX_DETAILS_PKG.Insert_Row(
2655: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
2656: p_CREATION_DATE => SYSDATE,
2657: p_CREATED_BY => G_USER_ID,
2658: p_LAST_UPDATE_DATE => l_sysdate,

Line 2706: ASO_TAX_DETAILS_PKG.update_Row(

2702: ELSIF P_Tax_Detail_Tbl(i).operation_code = 'UPDATE' THEN
2703: l_sysdate := sysdate;
2704: l_tax_detail_rec := x_tax_detail_tbl(i);
2705: x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2706: ASO_TAX_DETAILS_PKG.update_Row(
2707: p_TAX_DETAIL_ID => l_tax_detail_rec.TAX_DETAIL_ID,
2708: p_CREATION_DATE => l_tax_detail_rec.creation_date,
2709: p_CREATED_BY => G_USER_ID,
2710: p_LAST_UPDATE_DATE => l_sysdate,

Line 2754: ASO_TAX_DETAILS_PKG.Delete_Row(

2750: p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
2751: p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
2752: );
2753: ELSIF P_Tax_Detail_Tbl(i).operation_code = 'DELETE' THEN
2754: ASO_TAX_DETAILS_PKG.Delete_Row(
2755: p_TAX_DETAIL_ID => P_Tax_Detail_Tbl(i).TAX_DETAIL_ID);
2756: END IF;
2757: END LOOP;
2758:

Line 3528: FROM ASO_TAX_DETAILS

3524:
3525: CURSOR c_tax_line(p_quote_line_id NUMBER) IS
3526: SELECT round(nvl(sum(decode(tax_inclusive_flag, 'Y', 0,nvl(tax_amount,0))),0),l_precision) tax_amt_for_qte_total,
3527: round(nvl(sum(nvl(tax_amount, 0)),0),l_precision) tax_amount
3528: FROM ASO_TAX_DETAILS
3529: WHERE quote_header_id = p_qte_header_id
3530: and quote_line_id = p_quote_line_id;
3531:
3532: CURSOR c_tax IS

Line 3534: FROM ASO_TAX_DETAILS

3530: and quote_line_id = p_quote_line_id;
3531:
3532: CURSOR c_tax IS
3533: SELECT round(nvl(sum(nvl(tax_amount, 0)),0),l_precision)
3534: FROM ASO_TAX_DETAILS
3535: WHERE quote_header_id = p_qte_header_id
3536: and quote_line_id is null;
3537:
3538: CURSOR c_tax_rec_cnt IS

Line 3540: from aso_tax_details

3536: and quote_line_id is null;
3537:
3538: CURSOR c_tax_rec_cnt IS
3539: select count(tax_detail_id)
3540: from aso_tax_details
3541: where quote_header_id = p_qte_header_id
3542: and tax_amount is not null;
3543:
3544:

Line 4120: FROM ASO_TAX_DETAILS

4116: and relationship_type_code = 'OPP_QUOTE';
4117:
4118: CURSOR c_tax_line(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
4119: select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
4120: FROM ASO_TAX_DETAILS
4121: WHERE quote_header_id = p_qte_header_id
4122: and quote_line_id = p_quote_line_id;
4123:
4124: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS

Line 6781: SELECT tax_detail_id FROM ASO_TAX_DETAILS

6777: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6778: AND quote_line_id IS NULL;
6779:
6780: CURSOR c_tax_rec IS
6781: SELECT tax_detail_id FROM ASO_TAX_DETAILS
6782: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6783: AND quote_line_id IS NULL
6784: AND ORIG_TAX_CODE IS NOT NULL;
6785:

Line 6977: FROM ASO_TAX_DETAILS

6973: WHERE quote_header_id = l_qte_hdr_id;
6974:
6975: CURSOR c_tax_line(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
6976: select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
6977: FROM ASO_TAX_DETAILS
6978: WHERE quote_header_id = p_qte_header_id
6979: and quote_line_id = p_quote_line_id;
6980:
6981: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS

Line 11769: DELETE FROM ASO_TAX_DETAILS

11765:
11766: DELETE FROM ASO_SHIPMENTS
11767: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11768:
11769: DELETE FROM ASO_TAX_DETAILS
11770: WHERE QUOTE_HEADER_ID = p_qte_header_id;
11771:
11772: DELETE FROM ASO_SALES_CREDITS
11773: WHERE QUOTE_HEADER_ID = p_qte_header_id;