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.ARRX_SALES_TAX_REP dependencies on ARRX_SALES_TAX_REP

Line 1: PACKAGE BODY ARRX_SALES_TAX_REP as

1: PACKAGE BODY ARRX_SALES_TAX_REP as
2: /* $Header: ARRXSTB.pls 115.7 2002/11/15 03:13:08 anukumar ship $ */
3:
4: PROCEDURE INSERT_SALES_TAX_REPORT (
5: chart_of_accounts_id in number,

Line 1047: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(

1043: c_sold_to_county := to_char(null);
1044:
1045: if c_ship_to_customer_id is not null and c_ship_to_site_use_id is not null
1046: then
1047: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(
1048: fc_customer_id_in => c_ship_to_customer_id,
1049: fc_site_use_id => c_ship_to_site_use_id,
1050: fc_customer_trx_id => c_cust_trx_id,
1051: fc_customer_name => c_ship_to_cust_name,

Line 1066: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(

1062: fc_county => c_ship_to_county);
1063: end if;
1064: if c_bill_to_customer_id is not null and c_bill_to_site_use_id is not null
1065: then
1066: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(
1067: fc_customer_id_in => c_bill_to_customer_id,
1068: fc_site_use_id => c_bill_to_site_use_id,
1069: fc_customer_trx_id => c_cust_trx_id,
1070: fc_customer_name => c_bill_to_cust_name,

Line 1086: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(

1082: end if;
1083:
1084: if c_sold_to_customer_id is not null and c_sold_to_site_use_id is not null
1085: then
1086: ARRX_SALES_TAX_REP.GET_CUSTOMER_INFORMATION(
1087: fc_customer_id_in => c_sold_to_customer_id,
1088: fc_site_use_id => c_sold_to_site_use_id,
1089: fc_customer_trx_id => c_cust_trx_id,
1090: fc_customer_name => c_sold_to_cust_name,

Line 1105: ARRX_SALES_TAX_REP.GET_PRECISION_AND_MAU(

1101: fc_county => c_sold_to_county);
1102: end if;
1103:
1104: -- get minimum accountable unit and mau for invoice currency
1105: ARRX_SALES_TAX_REP.GET_PRECISION_AND_MAU(
1106: fc_currency => c_currency,
1107: fc_precision => c_precision,
1108: fc_mau => c_mau);
1109:

Line 1111: ARRX_SALES_TAX_REP.FETCH_TRX_ABS_TOTALS(

1107: fc_precision => c_precision,
1108: fc_mau => c_mau);
1109:
1110: if detail_level = 'RX_LINE' then
1111: ARRX_SALES_TAX_REP.FETCH_TRX_ABS_TOTALS(
1112: fc_cust_trx_id => c_cust_trx_id,
1113: fc_type_flag => c_type_flag,
1114: fc_inv_line_amount_abs => h_inv_line_amount_abs,
1115: fc_inv_freight_amount_abs => h_inv_freight_amount_abs,

Line 1211: c_comment := ARRX_SALES_TAX_REP.TRX_COMMENT_FLAG(c_type_flag, c_trx_id, detail_level,

1207: c_trx_id := nvl(c_tax_cust_trx_line_id, to_number(null));
1208: else
1209: c_trx_id := nvl(c_cust_trx_id,to_number(null));
1210: end if;
1211: c_comment := ARRX_SALES_TAX_REP.TRX_COMMENT_FLAG(c_type_flag, c_trx_id, detail_level,
1212: h_tax_amount, c_adj_line_amount, c_adj_freight_amount, c_adj_type,c_gl_flex);
1213:
1214: -- inventory item and and item description
1215: -- because invetory item does not exist for all rows, assigns null values first

Line 1220: h_item_description := ARRX_SALES_TAX_REP.GET_ITEM_DESCRIPTION(h_so_organization_id,c_inventory_item_id);

1216: h_item_description := to_char(null);
1217: h_inventory_item := to_char(null);
1218:
1219: if detail_level = 'RX_LINE' and c_inventory_item_id is not null then
1220: h_item_description := ARRX_SALES_TAX_REP.GET_ITEM_DESCRIPTION(h_so_organization_id,c_inventory_item_id);
1221: h_inventory_item := ARRX_SALES_TAX_REP.GET_ITEM(h_so_organization_id,c_inventory_item_id);
1222: end if;
1223:
1224: h_exchange_rate_type := to_char(null);

Line 1221: h_inventory_item := ARRX_SALES_TAX_REP.GET_ITEM(h_so_organization_id,c_inventory_item_id);

1217: h_inventory_item := to_char(null);
1218:
1219: if detail_level = 'RX_LINE' and c_inventory_item_id is not null then
1220: h_item_description := ARRX_SALES_TAX_REP.GET_ITEM_DESCRIPTION(h_so_organization_id,c_inventory_item_id);
1221: h_inventory_item := ARRX_SALES_TAX_REP.GET_ITEM(h_so_organization_id,c_inventory_item_id);
1222: end if;
1223:
1224: h_exchange_rate_type := to_char(null);
1225: if c_exchange_rate_type is not null then

Line 1226: h_exchange_rate_type := ARRX_SALES_TAX_REP.GET_CONVERSION_RATE_TYPE(c_exchange_rate_type);

1222: end if;
1223:
1224: h_exchange_rate_type := to_char(null);
1225: if c_exchange_rate_type is not null then
1226: h_exchange_rate_type := ARRX_SALES_TAX_REP.GET_CONVERSION_RATE_TYPE(c_exchange_rate_type);
1227: end if;
1228:
1229: -- ready for insert
1230: insert into ar_sales_tax_rep_itf

Line 1311: ARRX_SALES_TAX_REP.WRITE_LOG(

1307: DBMS_SQL.close_cursor(c);
1308:
1309: success := TRUE;
1310: if c_counter = 0 then
1311: ARRX_SALES_TAX_REP.WRITE_LOG(
1312: fc_which => 1,
1313: fc_text => 'No data found',
1314: fc_buffer => in_mesg);
1315: mesg := in_mesg;

Line 1317: ARRX_SALES_TAX_REP.WRITE_LOG(

1313: fc_text => 'No data found',
1314: fc_buffer => in_mesg);
1315: mesg := in_mesg;
1316: else
1317: ARRX_SALES_TAX_REP.WRITE_LOG(
1318: fc_which => 1,
1319: fc_text => 'Concurrent request completed successfully, '||to_char(c_counter)||' row(s) inserted.',
1320: fc_buffer => in_mesg);
1321: mesg := in_mesg;

Line 1327: ARRX_SALES_TAX_REP.WRITE_LOG(

1323:
1324:
1325: exception
1326: when no_data_found then
1327: ARRX_SALES_TAX_REP.WRITE_LOG(
1328: fc_which => 1,
1329: fc_text => 'No data found',
1330: fc_buffer => in_mesg);
1331: mesg := in_mesg;

Line 1339: ARRX_SALES_TAX_REP.WRITE_LOG(

1335: if dbms_sql.is_open(c) then
1336: dbms_sql.close_cursor(c);
1337: end if;
1338: success := FALSE;
1339: ARRX_SALES_TAX_REP.WRITE_LOG(
1340: fc_which => 1,
1341: fc_text => 'Concurrent request ended with error',
1342: fc_buffer => in_mesg);
1343: mesg := in_mesg;

Line 1376: ARRX_SALES_TAX_REP.insert_sales_tax_report (

1372: h_success boolean;
1373:
1374: BEGIN
1375:
1376: ARRX_SALES_TAX_REP.insert_sales_tax_report (
1377: chart_of_accounts_id => chart_of_accounts_id,
1378: trx_date_low => trx_date_low,
1379: trx_date_high => trx_date_high,
1380: gl_date_low => gl_date_low,

Line 1800: elsif ARRX_SALES_TAX_REP.GLTAX_IN_BALANCE(fc_trx_id,fc_detail_level) = 'N' then

1796: text := ' + Adjustment Transaction';
1797: end if;
1798: elsif fc_gl_flex = 'Y' then
1799: text := ' * Transaction not posted to Sales Tax Account *** Out NOCOPY of Balance ***';
1800: elsif ARRX_SALES_TAX_REP.GLTAX_IN_BALANCE(fc_trx_id,fc_detail_level) = 'N' then
1801: if fc_sum_tax_line_amount = 0 then
1802: text := ' * Transaction not posted to Sales Tax Account';
1803: else
1804: text := ' * Transaction not posted to Sales Tax Account *** Out NOCOPY of Balance ***';

Line 2194: ARRX_SALES_TAX_REP.WRITE_LOG(

2190: exit;
2191: end if;
2192: if l_tax_exemption_id is null and nvl(l_tax_rate,0) = 0 then
2193: l_exempt_percent := 100;
2194: ARRX_SALES_TAX_REP.WRITE_LOG(
2195: fc_which => 1,
2196: fc_text => '100 prosenttia',
2197: fc_buffer => in_mesg );
2198:

Line 2239: ARRX_SALES_TAX_REP.WRITE_LOG(

2235: end if;
2236: if get_tax_exemption_rate%ISOPEN then
2237: close get_tax_exemption_rate;
2238: end if;
2239: ARRX_SALES_TAX_REP.WRITE_LOG(
2240: fc_which => 1,
2241: fc_text => 'An error occured when getting exemption amount for invoice header',
2242: fc_buffer => in_mesg);
2243: raise;

Line 2275: end ARRX_SALES_TAX_REP;

2271: WHEN OTHERS then
2272: raise;
2273: END GET_PRECISION_AND_MAU;
2274:
2275: end ARRX_SALES_TAX_REP;