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 2298: from aso_tax_details

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

Line 3038: 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');

3034:
3035: if p_qte_line_id is not null THEN
3036: IF aso_debug_pub.g_debug_flag ='Y' THEN
3037: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3038: 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');
3039: END IF;
3040: Delete from
3041: ASO_TAX_DETAILS
3042: where

Line 3041: ASO_TAX_DETAILS

3037: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3038: 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');
3039: END IF;
3040: Delete from
3041: ASO_TAX_DETAILS
3042: where
3043: QUOTE_HEADER_ID=p_qte_header_id
3044: and
3045: QUOTE_LINE_ID=p_qte_line_id;

Line 3049: 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');

3045: QUOTE_LINE_ID=p_qte_line_id;
3046: ELSE
3047: IF aso_debug_pub.g_debug_flag ='Y' THEN
3048: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3049: 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');
3050: END IF;
3051: Delete from ASO_TAX_DETAILS
3052: where QUOTE_HEADER_ID=p_qte_header_id
3053: and QUOTE_LINE_ID is not null;

Line 3051: Delete from ASO_TAX_DETAILS

3047: IF aso_debug_pub.g_debug_flag ='Y' THEN
3048: aso_debug_pub.add('ASO_TAX_INT : CALCULATE_TAX_WITH_GTT: AFTER THE TAX ENGINE CALL :RETURN SUCCESSFUL ', 1, 'Y');
3049: 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');
3050: END IF;
3051: Delete from ASO_TAX_DETAILS
3052: where QUOTE_HEADER_ID=p_qte_header_id
3053: and QUOTE_LINE_ID is not null;
3054: END IF;
3055:

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

3053: and QUOTE_LINE_ID is not null;
3054: END IF;
3055:
3056:
3057: --Inserting the values from output temporary table into the ASO_TAX_DETAILS table.
3058:
3059:
3060: insert into Aso_tax_details
3061: (

Line 3060: insert into Aso_tax_details

3056:
3057: --Inserting the values from output temporary table into the ASO_TAX_DETAILS table.
3058:
3059:
3060: insert into Aso_tax_details
3061: (
3062: TAX_DETAIL_ID,CREATION_DATE,CREATED_BY,LAST_UPDATE_DATE,LAST_UPDATED_BY,
3063: LAST_UPDATE_LOGIN,PROGRAM_APPLICATION_ID,PROGRAM_UPDATE_DATE,
3064: QUOTE_HEADER_ID,QUOTE_LINE_ID,QUOTE_SHIPMENT_ID,TAX_CODE,TAX_RATE,

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

3066: TAX_INCLUSIVE_FLAG,OBJECT_VERSION_NUMBER,TAX_RATE_ID,
3067: TAX_EXEMPT_FLAG --Added by anrajan on 05/10/2005
3068: )
3069: select
3070: ASO_TAX_DETAILS_S.nextval,SYSDATE,G_USER_ID,SYSDATE,G_USER_ID,
3071: G_LOGIN_ID,APPLICATION_ID,sysdate,
3072: a.TRX_ID,a.TRX_LINE_ID,b.SHIPMENT_ID,a.TAX_RATE_CODE,a.TAX_RATE,
3073: a.TAX_DETERMINE_DATE,a.TAX_AMT,a.EXEMPT_CERTIFICATE_NUMBER,a.EXEMPT_REASON_CODE,
3074: a.TAX_AMT_INCLUDED_FLAG,a.OBJECT_VERSION_NUMBER,a.TAX_RATE_ID,

Line 3171: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3167: p_qte_line_id NUMBER,
3168: p_shipment_id NUMBER) RETURN NUMBER
3169: IS
3170: CURSOR c_tax1 IS
3171: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3172: WHERE quote_shipment_id = p_shipment_id;
3173: CURSOR c_tax2 IS
3174: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3175: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL

Line 3174: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3170: CURSOR c_tax1 IS
3171: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3172: WHERE quote_shipment_id = p_shipment_id;
3173: CURSOR c_tax2 IS
3174: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3175: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL
3176: and quote_shipment_id = p_shipment_id;
3177: CURSOR c_tax3 IS
3178: SELECT tax_detail_id FROM ASO_TAX_DETAILS

Line 3178: SELECT tax_detail_id FROM ASO_TAX_DETAILS

3174: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3175: WHERE quote_header_id = p_qte_header_id and quote_line_id is NULL
3176: and quote_shipment_id = p_shipment_id;
3177: CURSOR c_tax3 IS
3178: SELECT tax_detail_id FROM ASO_TAX_DETAILS
3179: WHERE quote_header_id = p_qte_header_id and quote_shipment_id = p_shipment_id
3180: and quote_line_id = p_qte_line_id ;
3181: l_tax_detail_id NUMBER;
3182: BEGIN

Line 3215: SELECT tax_code FROM ASO_TAX_DETAILS

3211: p_qte_line_id NUMBER,
3212: p_shipment_id NUMBER) RETURN VARCHAR2
3213: IS
3214: CURSOR c_tax1 IS
3215: SELECT tax_code FROM ASO_TAX_DETAILS
3216: WHERE quote_shipment_id = p_shipment_id ;
3217: CURSOR c_tax2 IS
3218: SELECT tax_code FROM ASO_TAX_DETAILS
3219: WHERE quote_line_id = p_qte_line_id ;

Line 3218: SELECT tax_code FROM ASO_TAX_DETAILS

3214: CURSOR c_tax1 IS
3215: SELECT tax_code FROM ASO_TAX_DETAILS
3216: WHERE quote_shipment_id = p_shipment_id ;
3217: CURSOR c_tax2 IS
3218: SELECT tax_code FROM ASO_TAX_DETAILS
3219: WHERE quote_line_id = p_qte_line_id ;
3220: CURSOR c_tax3 IS
3221: SELECT tax_code FROM ASO_TAX_DETAILS
3222: WHERE quote_header_id = p_qte_header_id ;

Line 3221: SELECT tax_code FROM ASO_TAX_DETAILS

3217: CURSOR c_tax2 IS
3218: SELECT tax_code FROM ASO_TAX_DETAILS
3219: WHERE quote_line_id = p_qte_line_id ;
3220: CURSOR c_tax3 IS
3221: SELECT tax_code FROM ASO_TAX_DETAILS
3222: WHERE quote_header_id = p_qte_header_id ;
3223: l_orig_tax_code VARCHAR2(240);
3224: BEGIN
3225: OPEN c_tax1;

Line 3255: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3251: p_qte_line_id NUMBER,
3252: p_shipment_id NUMBER) RETURN VARCHAR2
3253: IS
3254: CURSOR c_tax1 IS
3255: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3256: WHERE quote_shipment_id = p_shipment_id ;
3257: CURSOR c_tax2 IS
3258: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3259: WHERE quote_line_id = p_qte_line_id ;

Line 3258: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3254: CURSOR c_tax1 IS
3255: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3256: WHERE quote_shipment_id = p_shipment_id ;
3257: CURSOR c_tax2 IS
3258: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3259: WHERE quote_line_id = p_qte_line_id ;
3260: CURSOR c_tax3 IS
3261: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3262: WHERE quote_header_id = p_qte_header_id ;

Line 3261: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS

3257: CURSOR c_tax2 IS
3258: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3259: WHERE quote_line_id = p_qte_line_id ;
3260: CURSOR c_tax3 IS
3261: SELECT tax_exempt_flag FROM ASO_TAX_DETAILS
3262: WHERE quote_header_id = p_qte_header_id ;
3263: l_tax_exempt_flag VARCHAR2(1);
3264: BEGIN
3265: OPEN c_tax1;

Line 3295: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3291: p_qte_line_id NUMBER,
3292: p_shipment_id NUMBER) RETURN VARCHAR2
3293: IS
3294: CURSOR c_tax1 IS
3295: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3296: WHERE quote_shipment_id = p_shipment_id ;
3297: CURSOR c_tax2 IS
3298: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3299: WHERE quote_line_id = p_qte_line_id ;

Line 3298: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3294: CURSOR c_tax1 IS
3295: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3296: WHERE quote_shipment_id = p_shipment_id ;
3297: CURSOR c_tax2 IS
3298: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3299: WHERE quote_line_id = p_qte_line_id ;
3300: CURSOR c_tax3 IS
3301: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3302: WHERE quote_header_id = p_qte_header_id ;

Line 3301: SELECT tax_exempt_number FROM ASO_TAX_DETAILS

3297: CURSOR c_tax2 IS
3298: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3299: WHERE quote_line_id = p_qte_line_id ;
3300: CURSOR c_tax3 IS
3301: SELECT tax_exempt_number FROM ASO_TAX_DETAILS
3302: WHERE quote_header_id = p_qte_header_id ;
3303: l_tax_exempt_number VARCHAR2(80);
3304: BEGIN
3305: OPEN c_tax1;

Line 3335: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3331: p_qte_line_id NUMBER,
3332: p_shipment_id NUMBER) RETURN VARCHAR2
3333: IS
3334: CURSOR c_tax1 IS
3335: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3336: WHERE quote_shipment_id = p_shipment_id ;
3337: CURSOR c_tax2 IS
3338: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3339: WHERE quote_line_id = p_qte_line_id ;

Line 3338: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3334: CURSOR c_tax1 IS
3335: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3336: WHERE quote_shipment_id = p_shipment_id ;
3337: CURSOR c_tax2 IS
3338: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3339: WHERE quote_line_id = p_qte_line_id ;
3340: CURSOR c_tax3 IS
3341: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3342: WHERE quote_header_id = p_qte_header_id ;

Line 3341: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS

3337: CURSOR c_tax2 IS
3338: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3339: WHERE quote_line_id = p_qte_line_id ;
3340: CURSOR c_tax3 IS
3341: SELECT tax_exempt_reason_code FROM ASO_TAX_DETAILS
3342: WHERE quote_header_id = p_qte_header_id ;
3343: l_tax_exempt_reason_code VARCHAR2(80);
3344: BEGIN
3345: OPEN c_tax1;