eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_TAX_INT dependencies on ASO_TAX_DETAILS

Line 96: DELETE FROM aso_tax_details

92:
93: IF p_tax_control_rec.update_DB = 'Y' THEN
94:
95: IF p_tax_control_rec.tax_level = 'SHIPPING' THEN
96: DELETE FROM aso_tax_details
97: WHERE quote_shipment_id = p_tax_detail_rec.quote_shipment_id and
98: quote_line_id = p_tax_detail_rec.quote_line_id and
99: quote_header_id = p_tax_detail_rec.quote_header_id;
100: END IF;

Line 103: DELETE FROM aso_tax_details

99: quote_header_id = p_tax_detail_rec.quote_header_id;
100: END IF;
101:
102: IF p_tax_control_rec.tax_level = 'HEADER' THEN
103: DELETE FROM aso_tax_details
104: WHERE quote_header_id = p_tax_detail_rec.quote_header_id AND
105: quote_line_id = p_tax_detail_rec.quote_line_id;
106: END IF;
107: -- AND orig_tax_code IS NOT NULL;

Line 111: ASO_TAX_DETAILS_PKG.Insert_Row(

107: -- AND orig_tax_code IS NOT NULL;
108: FOR i IN 1..x_tax_detail_Tbl.count LOOP
109: l_tax_detail_rec := x_tax_detail_tbl(i);
110:
111: ASO_TAX_DETAILS_PKG.Insert_Row(
112: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
113: p_CREATION_DATE => SYSDATE,
114: p_CREATED_BY => G_USER_ID,
115: p_LAST_UPDATE_DATE => SYSDATE,

Line 240: aso_tax_details WHERE quote_header_id= qt_hdr_id

236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
237: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
238: CURSOR c_hd_tax(qt_hdr_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code
239: FROM
240: aso_tax_details WHERE quote_header_id= qt_hdr_id
241: and quote_shipment_id= q_ship_id and quote_line_id IS NULL;
242:
243: CURSOR c_tax_line(qt_hdr_id NUMBER,q_line_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code FROM
244: aso_tax_details WHERE quote_header_id= qt_hdr_id

Line 244: aso_tax_details WHERE quote_header_id= qt_hdr_id

240: aso_tax_details WHERE quote_header_id= qt_hdr_id
241: and quote_shipment_id= q_ship_id and quote_line_id IS NULL;
242:
243: CURSOR c_tax_line(qt_hdr_id NUMBER,q_line_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code FROM
244: aso_tax_details WHERE quote_header_id= qt_hdr_id
245: and quote_shipment_id= q_ship_id and quote_line_id = q_line_id;
246:
247: BEGIN
248: SAVEPOINT CALCULATE_TAX_PUB;

Line 309: ASO_TAX_DETAILS_PKG.Insert_Row(

305: OPEN c_tax_line(c_header_id,c_line_id,c_shipment_id);
306: FETCH c_tax_line into l_exempt_flag,l_exempt_number,l_exempt_reason_code;
307: IF c_tax_line%NOTFOUND THEN
308: -- Insert into tax details
309: ASO_TAX_DETAILS_PKG.Insert_Row(
310: px_TAX_DETAIL_ID => l_tax_detail_tbl(j).TAX_DETAIL_ID,
311: p_CREATION_DATE => SYSDATE,
312: p_CREATED_BY => G_USER_ID,
313: p_LAST_UPDATE_DATE => SYSDATE,

Line 368: UPDATE ASO_TAX_DETAILS

364: IF aso_debug_pub.g_debug_flag = 'Y' THEN
365: aso_debug_pub.add('Inside line tax detail before update ',1,'Y');
366: END IF;
367:
368: UPDATE ASO_TAX_DETAILS
369: SET tax_exempt_flag = l_hd_exempt_flag ,
370: tax_exempt_number = l_hd_exempt_number,
371: tax_exempt_reason_code = l_hd_exempt_reason_code,
372: last_update_date = sysdate,

Line 1126: delete from aso_tax_details

1122: end if;
1123:
1124: if l_tax_detail_tbl.count > 0 then
1125:
1126: delete from aso_tax_details
1127: where quote_header_id = l_tax_detail_tbl(1).quote_header_id
1128: and quote_line_id = l_tax_detail_tbl(1).quote_line_id ;
1129:
1130: end if;

Line 1769: delete from aso_tax_details

1765: end if;
1766:
1767: if l_tax_detail_tbl.count > 0 then
1768:
1769: delete from aso_tax_details
1770: where quote_header_id = l_tax_detail_tbl(1).quote_header_id
1771: and quote_line_id = l_tax_detail_tbl(1).quote_line_id ;
1772:
1773: end if;

Line 2060: DELETE FROM aso_tax_details

2056: aso_debug_pub.add('ASO_TAX_LINE: l_tax_detail_tbl(1).quote_line_id'||l_tax_detail_tbl(1).quote_line_id, 1, 'Y');
2057: aso_debug_pub.add('ASO_TAX_LINE: l_tax_detail_tbl(1).quote_header_id'||l_tax_detail_tbl(1).quote_header_id, 1, 'Y');
2058: END IF;
2059:
2060: DELETE FROM aso_tax_details
2061: WHERE quote_shipment_id = l_tax_detail_tbl(1).quote_shipment_id
2062: and quote_line_id = l_qte_line_tbl(i).quote_line_id
2063: and quote_header_id = l_tax_detail_tbl(1).quote_header_id;
2064:

Line 2073: DELETE FROM aso_tax_details

2069: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2070: aso_debug_pub.add('ASO_TAX_LINE: Deleting HEADER level tax records inside IF', 1, 'Y');
2071: END IF;
2072:
2073: DELETE FROM aso_tax_details
2074: WHERE quote_header_id = l_qte_line_tbl(i).quote_header_id
2075: and quote_line_id = l_qte_line_tbl(i).quote_line_id;
2076:
2077: END IF;

Line 2080: aso_debug_pub.add('Before calling aso_tax_details_pkg.insert_row in loop', 1, 'Y');

2076:
2077: END IF;
2078:
2079: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2080: aso_debug_pub.add('Before calling aso_tax_details_pkg.insert_row in loop', 1, 'Y');
2081: aso_debug_pub.add('x_tax_detail_Tbl.count: ' || x_tax_detail_Tbl.count, 1, 'Y');
2082: END IF;
2083:
2084: FOR i IN 1..x_tax_detail_Tbl.count LOOP

Line 2096: ASO_TAX_DETAILS_PKG.Insert_Row(

2092: aso_debug_pub.add('tax_rate: ' || x_tax_detail_tbl(i).tax_rate, 1, 'Y');
2093: aso_debug_pub.add('tax_amount: ' || x_tax_detail_tbl(i).tax_amount, 1, 'Y');
2094: END IF;
2095:
2096: ASO_TAX_DETAILS_PKG.Insert_Row(
2097: px_TAX_DETAIL_ID => x_tax_detail_tbl(i).TAX_DETAIL_ID,
2098: p_CREATION_DATE => SYSDATE,
2099: p_CREATED_BY => G_USER_ID,
2100: p_LAST_UPDATE_DATE => SYSDATE,

Line 2299: from aso_tax_details

2295: WHERE party_site_id=l_party_site_id;
2296:
2297: Cursor c_tax is
2298: select TAX_EXEMPT_FLAG,TAX_EXEMPT_NUMBER,TAX_EXEMPT_REASON_CODE
2299: from aso_tax_details
2300: WHERE QUOTE_LINE_ID is null
2301: AND quote_header_id=p_qte_header_id;
2302:
2303: Cursor c_cust_trx_type_id(l_trx_type_id NUMBER) is

Line 3136: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id||'; QUOTE LINE ID : '||p_qte_line_id , 1, 'Y');

3132:
3133: if p_qte_line_id is not null THEN
3134: IF aso_debug_pub.g_debug_flag ='Y' THEN
3135: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3136: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id||'; QUOTE LINE ID : '||p_qte_line_id , 1, 'Y');
3137: END IF;
3138: Delete from
3139: ASO_TAX_DETAILS
3140: where

Line 3139: ASO_TAX_DETAILS

3135: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3136: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id||'; QUOTE LINE ID : '||p_qte_line_id , 1, 'Y');
3137: END IF;
3138: Delete from
3139: ASO_TAX_DETAILS
3140: where
3141: QUOTE_HEADER_ID=p_qte_header_id
3142: and
3143: QUOTE_LINE_ID=p_qte_line_id;

Line 3147: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id,1, 'Y');

3143: QUOTE_LINE_ID=p_qte_line_id;
3144: ELSE
3145: IF aso_debug_pub.g_debug_flag ='Y' THEN
3146: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3147: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id,1, 'Y');
3148: END IF;
3149: Delete from ASO_TAX_DETAILS
3150: where QUOTE_HEADER_ID=p_qte_header_id
3151: and QUOTE_LINE_ID is not null;

Line 3149: Delete from ASO_TAX_DETAILS

3145: IF aso_debug_pub.g_debug_flag ='Y' THEN
3146: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3147: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :DELETING FROM ASO_TAX_DETAILS :QUOTE HEADER_ID : '||p_qte_header_id,1, 'Y');
3148: END IF;
3149: Delete from ASO_TAX_DETAILS
3150: where QUOTE_HEADER_ID=p_qte_header_id
3151: and QUOTE_LINE_ID is not null;
3152: END IF;
3153:

Line 3155: --Inserting the values from output temporary table into the ASO_TAX_DETAILS table.

3151: and QUOTE_LINE_ID is not null;
3152: END IF;
3153:
3154:
3155: --Inserting the values from output temporary table into the ASO_TAX_DETAILS table.
3156:
3157:
3158: insert into Aso_tax_details
3159: (

Line 3158: insert into Aso_tax_details

3154:
3155: --Inserting the values from output temporary table into the ASO_TAX_DETAILS table.
3156:
3157:
3158: insert into Aso_tax_details
3159: (
3160: TAX_DETAIL_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
3161: LAST_UPDATE_LOGIN,PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE,
3162: QUOTE_HEADER_ID,QUOTE_LINE_ID,QUOTE_SHIPMENT_ID,TAX_CODE,TAX_RATE,

Line 3168: ASO_TAX_DETAILS_S.nextval,SYSDATE,G_USER_ID,SYSDATE,G_USER_ID,

3164: TAX_INCLUSIVE_FLAG,OBJECT_VERSION_NUMBER,TAX_RATE_ID,
3165: TAX_EXEMPT_FLAG --Added by anrajan on 05/10/2005
3166: )
3167: select
3168: ASO_TAX_DETAILS_S.nextval,SYSDATE,G_USER_ID,SYSDATE,G_USER_ID,
3169: G_LOGIN_ID,APPLICATION_ID,sysdate,
3170: a.TRX_ID,a.TRX_LINE_ID,b.SHIPMENT_ID,a.TAX_RATE_CODE,a.TAX_RATE,
3171: a.TAX_DETERMINE_DATE,a.TAX_AMT,a.EXEMPT_CERTIFICATE_NUMBER,a.EXEMPT_REASON_CODE,
3172: a.TAX_AMT_INCLUDED_FLAG,a.OBJECT_VERSION_NUMBER,a.TAX_RATE_ID,

Line 3269: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3265: p_qte_line_id NUMBER,
3266: p_shipment_id NUMBER) RETURN NUMBER
3267: IS
3268: CURSOR c_tax1 IS
3269: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3270: WHERE quote_shipment_id = p_shipment_id;
3271: CURSOR c_tax2 IS
3272: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3273: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL

Line 3272: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3268: CURSOR c_tax1 IS
3269: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3270: WHERE quote_shipment_id = p_shipment_id;
3271: CURSOR c_tax2 IS
3272: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3273: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL
3274: and quote_shipment_id = p_shipment_id;
3275: CURSOR c_tax3 IS
3276: SELECT tax_detail_id FROM ASO_TAX_DETAILS

Line 3276: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3272: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3273: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL
3274: and quote_shipment_id = p_shipment_id;
3275: CURSOR c_tax3 IS
3276: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3277: WHERE quote_header_id = p_qte_header_id and quote_shipment_id = p_shipment_id
3278: and quote_line_id = p_qte_line_id ;
3279: l_tax_detail_id NUMBER;
3280: BEGIN

Line 3313: SELECT tax_code FROM ASO_TAX_DETAILS

3309: p_qte_line_id NUMBER,
3310: p_shipment_id NUMBER) RETURN VARCHAR2
3311: IS
3312: CURSOR c_tax1 IS
3313: SELECT tax_code FROM ASO_TAX_DETAILS
3314: WHERE quote_shipment_id = p_shipment_id ;
3315: CURSOR c_tax2 IS
3316: SELECT tax_code FROM ASO_TAX_DETAILS
3317: WHERE quote_line_id = p_qte_line_id ;

Line 3316: SELECT tax_code FROM ASO_TAX_DETAILS

3312: CURSOR c_tax1 IS
3313: SELECT tax_code FROM ASO_TAX_DETAILS
3314: WHERE quote_shipment_id = p_shipment_id ;
3315: CURSOR c_tax2 IS
3316: SELECT tax_code FROM ASO_TAX_DETAILS
3317: WHERE quote_line_id = p_qte_line_id ;
3318: CURSOR c_tax3 IS
3319: SELECT tax_code FROM ASO_TAX_DETAILS
3320: WHERE quote_header_id = p_qte_header_id ;

Line 3319: SELECT tax_code FROM ASO_TAX_DETAILS

3315: CURSOR c_tax2 IS
3316: SELECT tax_code FROM ASO_TAX_DETAILS
3317: WHERE quote_line_id = p_qte_line_id ;
3318: CURSOR c_tax3 IS
3319: SELECT tax_code FROM ASO_TAX_DETAILS
3320: WHERE quote_header_id = p_qte_header_id ;
3321: l_orig_tax_code VARCHAR2(240);
3322: BEGIN
3323: OPEN c_tax1;

Line 3353: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3349: p_qte_line_id NUMBER,
3350: p_shipment_id NUMBER) RETURN VARCHAR2
3351: IS
3352: CURSOR c_tax1 IS
3353: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3354: WHERE quote_shipment_id = p_shipment_id ;
3355: CURSOR c_tax2 IS
3356: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3357: WHERE quote_line_id = p_qte_line_id ;

Line 3356: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3352: CURSOR c_tax1 IS
3353: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3354: WHERE quote_shipment_id = p_shipment_id ;
3355: CURSOR c_tax2 IS
3356: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3357: WHERE quote_line_id = p_qte_line_id ;
3358: CURSOR c_tax3 IS
3359: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3360: WHERE quote_header_id = p_qte_header_id ;

Line 3359: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3355: CURSOR c_tax2 IS
3356: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3357: WHERE quote_line_id = p_qte_line_id ;
3358: CURSOR c_tax3 IS
3359: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3360: WHERE quote_header_id = p_qte_header_id ;
3361: l_tax_exempt_flag VARCHAR2(1);
3362: BEGIN
3363: OPEN c_tax1;

Line 3393: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3389: p_qte_line_id NUMBER,
3390: p_shipment_id NUMBER) RETURN VARCHAR2
3391: IS
3392: CURSOR c_tax1 IS
3393: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3394: WHERE quote_shipment_id = p_shipment_id ;
3395: CURSOR c_tax2 IS
3396: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3397: WHERE quote_line_id = p_qte_line_id ;

Line 3396: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3392: CURSOR c_tax1 IS
3393: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3394: WHERE quote_shipment_id = p_shipment_id ;
3395: CURSOR c_tax2 IS
3396: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3397: WHERE quote_line_id = p_qte_line_id ;
3398: CURSOR c_tax3 IS
3399: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3400: WHERE quote_header_id = p_qte_header_id ;

Line 3399: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3395: CURSOR c_tax2 IS
3396: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3397: WHERE quote_line_id = p_qte_line_id ;
3398: CURSOR c_tax3 IS
3399: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3400: WHERE quote_header_id = p_qte_header_id ;
3401: l_tax_exempt_number VARCHAR2(80);
3402: BEGIN
3403: OPEN c_tax1;

Line 3433: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3429: p_qte_line_id NUMBER,
3430: p_shipment_id NUMBER) RETURN VARCHAR2
3431: IS
3432: CURSOR c_tax1 IS
3433: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3434: WHERE quote_shipment_id = p_shipment_id ;
3435: CURSOR c_tax2 IS
3436: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3437: WHERE quote_line_id = p_qte_line_id ;

Line 3436: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3432: CURSOR c_tax1 IS
3433: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3434: WHERE quote_shipment_id = p_shipment_id ;
3435: CURSOR c_tax2 IS
3436: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3437: WHERE quote_line_id = p_qte_line_id ;
3438: CURSOR c_tax3 IS
3439: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3440: WHERE quote_header_id = p_qte_header_id ;

Line 3439: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3435: CURSOR c_tax2 IS
3436: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3437: WHERE quote_line_id = p_qte_line_id ;
3438: CURSOR c_tax3 IS
3439: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3440: WHERE quote_header_id = p_qte_header_id ;
3441: l_tax_exempt_reason_code VARCHAR2(80);
3442: BEGIN
3443: OPEN c_tax1;