APPS.ASO_QUOTE_HEADERS_PVT dependencies on ASO_TAX_DETAILS

Line 1189: ASO_TAX_DETAILS_PKG.Insert_Row(

1185: l_tax_detail_rec := x_tax_detail_tbl(i);
1186: -- BC4J Fix
1187: --x_tax_detail_tbl(i).TAX_DETAIL_ID := NULL;
1188: l_sysdate := sysdate;
1189: ASO_TAX_DETAILS_PKG.Insert_Row(
1190: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
1191: p_CREATION_DATE => SYSDATE,
1192: p_CREATED_BY => G_USER_ID,
1193: p_LAST_UPDATE_DATE => l_sysdate,

Line 2595: ASO_TAX_DETAILS_PKG.Insert_Row(

2591: l_tax_detail_rec := x_tax_detail_tbl(i);
2592: -- BC4J Fix
2593: --x_tax_detail_tbl(i).TAX_DETAIL_ID := NULL;
2594: x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2595: ASO_TAX_DETAILS_PKG.Insert_Row(
2596: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
2597: p_CREATION_DATE => SYSDATE,
2598: p_CREATED_BY => G_USER_ID,
2599: p_LAST_UPDATE_DATE => l_sysdate,

Line 2647: ASO_TAX_DETAILS_PKG.update_Row(

2643: ELSIF P_Tax_Detail_Tbl(i).operation_code = 'UPDATE' THEN
2644: l_sysdate := sysdate;
2645: l_tax_detail_rec := x_tax_detail_tbl(i);
2646: x_tax_detail_tbl(i).LAST_UPDATE_DATE := l_sysdate;
2647: ASO_TAX_DETAILS_PKG.update_Row(
2648: p_TAX_DETAIL_ID => l_tax_detail_rec.TAX_DETAIL_ID,
2649: p_CREATION_DATE => l_tax_detail_rec.creation_date,
2650: p_CREATED_BY => G_USER_ID,
2651: p_LAST_UPDATE_DATE => l_sysdate,

Line 2695: ASO_TAX_DETAILS_PKG.Delete_Row(

2691: p_OBJECT_VERSION_NUMBER => l_tax_detail_rec.OBJECT_VERSION_NUMBER,
2692: p_TAX_RATE_ID => l_tax_detail_rec.TAX_RATE_ID
2693: );
2694: ELSIF P_Tax_Detail_Tbl(i).operation_code = 'DELETE' THEN
2695: ASO_TAX_DETAILS_PKG.Delete_Row(
2696: p_TAX_DETAIL_ID => P_Tax_Detail_Tbl(i).TAX_DETAIL_ID);
2697: END IF;
2698: END LOOP;
2699:

Line 3466: FROM ASO_TAX_DETAILS

3462:
3463: CURSOR c_tax_line(p_quote_line_id NUMBER) IS
3464: SELECT nvl(sum(decode(tax_inclusive_flag, 'Y', 0,nvl(tax_amount,0))),0) tax_amt_for_qte_total,
3465: nvl(sum(nvl(tax_amount, 0)),0) tax_amount
3466: FROM ASO_TAX_DETAILS
3467: WHERE quote_header_id = p_qte_header_id
3468: and quote_line_id = p_quote_line_id;
3469:
3470: CURSOR c_tax IS

Line 3472: FROM ASO_TAX_DETAILS

3468: and quote_line_id = p_quote_line_id;
3469:
3470: CURSOR c_tax IS
3471: SELECT nvl(sum(nvl(tax_amount, 0)),0)
3472: FROM ASO_TAX_DETAILS
3473: WHERE quote_header_id = p_qte_header_id
3474: and quote_line_id is null;
3475:
3476: CURSOR c_tax_rec_cnt IS

Line 3478: from aso_tax_details

3474: and quote_line_id is null;
3475:
3476: CURSOR c_tax_rec_cnt IS
3477: select count(tax_detail_id)
3478: from aso_tax_details
3479: where quote_header_id = p_qte_header_id
3480: and tax_amount is not null;
3481:
3482:

Line 4037: FROM ASO_TAX_DETAILS

4033: and relationship_type_code = 'OPP_QUOTE';
4034:
4035: CURSOR c_tax_line(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
4036: select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
4037: FROM ASO_TAX_DETAILS
4038: WHERE quote_header_id = p_qte_header_id
4039: and quote_line_id = p_quote_line_id;
4040:
4041: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS

Line 6642: SELECT tax_detail_id FROM ASO_TAX_DETAILS

6638: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6639: AND quote_line_id IS NULL;
6640:
6641: CURSOR c_tax_rec IS
6642: SELECT tax_detail_id FROM ASO_TAX_DETAILS
6643: WHERE quote_header_id = P_Qte_Header_Rec.quote_header_id
6644: AND quote_line_id IS NULL
6645: AND ORIG_TAX_CODE IS NOT NULL;
6646:

Line 6837: FROM ASO_TAX_DETAILS

6833: WHERE quote_header_id = l_qte_hdr_id;
6834:
6835: CURSOR c_tax_line(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS
6836: select nvl(sum(nvl(tax_amount, 0)),0) tax_amount
6837: FROM ASO_TAX_DETAILS
6838: WHERE quote_header_id = p_qte_header_id
6839: and quote_line_id = p_quote_line_id;
6840:
6841: Cursor get_line_payment_term(p_qte_header_id NUMBER, p_quote_line_id NUMBER) IS

Line 10698: DELETE FROM ASO_TAX_DETAILS

10694:
10695: DELETE FROM ASO_SHIPMENTS
10696: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10697:
10698: DELETE FROM ASO_TAX_DETAILS
10699: WHERE QUOTE_HEADER_ID = p_qte_header_id;
10700:
10701: DELETE FROM ASO_SALES_CREDITS
10702: WHERE QUOTE_HEADER_ID = p_qte_header_id;