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.ARP_STAX_MINUS99 dependencies on STANDARD

Line 103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset

99: start_date in date,
100: end_date in date) return number IS
101:
102: CURSOR ar_sales_tax_s_c is
103: select ar_sales_tax_s.nextval + arp_standard.sequence_offset
104: from dual;
105:
106: sales_tax_id NUMBER;
107:

Line 139: arp_standard.profile.user_id,

135: VALUES
136: (
137: sales_tax_id,
138: sysdate,
139: arp_standard.profile.user_id,
140: null,
141: arp_standard.profile.user_id,
142: sysdate,
143: location_id,

Line 141: arp_standard.profile.user_id,

137: sales_tax_id,
138: sysdate,
139: arp_standard.profile.user_id,
140: null,
141: arp_standard.profile.user_id,
142: sysdate,
143: location_id,
144: location_structure_id,
145: total_tax_rate,

Line 257: arp_standard.fnd_message( 'AR_TRIG_NOT_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );

253: END IF;
254:
255: if not transfer_rates_initialised
256: then
257: arp_standard.fnd_message( 'AR_TRIG_NOT_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );
258:
259: IF PG_DEBUG = 'Y' THEN
260: arp_util_tax.debug( '>> AR TRIGGER LOCATION RATES NOT INITIALIZED' );
261: END IF;

Line 504: arp_standard.fnd_message( 'AR_TRIG_ALREADY_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );

500: --PG_DEBUG := NVL(FND_PROFILE.value('TAX_DEBUG_FLAG'), 'N');
501: PG_DEBUG := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
502: if transfer_rates_initialised
503: then
504: arp_standard.fnd_message( 'AR_TRIG_ALREADY_INITIALISED', 'TRIGGER', 'LOCATION_RATES' );
505:
506: IF PG_DEBUG = 'Y' THEN
507: arp_util_tax.debug('AR_TRIGGER LOCATION RATES ALREADY EXIST');
508: END IF;

Line 752: last_updated_by = arp_standard.profile.user_id

748: -- is not shipped to customers )
749: --
750: UPDATE ar_sales_tax SET enabled_flag = 'N',
751: last_update_date = sysdate,
752: last_updated_by = arp_standard.profile.user_id
753: WHERE rowid = tax_rate_rec.rowid;
754: END IF;
755: CLOSE RateUsed;
756: END ;

Line 798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

794: start_date,
795: end_date,
796: enabled_flag)
797: select
798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
799: sysdate,
800: arp_standard.profile.user_id,
801: null,
802: arp_standard.profile.user_id,

Line 800: arp_standard.profile.user_id,

796: enabled_flag)
797: select
798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
799: sysdate,
800: arp_standard.profile.user_id,
801: null,
802: arp_standard.profile.user_id,
803: sysdate,
804: location_ccid,

Line 802: arp_standard.profile.user_id,

798: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
799: sysdate,
800: arp_standard.profile.user_id,
801: null,
802: arp_standard.profile.user_id,
803: sysdate,
804: location_ccid,
805: arp_standard.sysparm.location_structure_id,
806: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)

Line 805: arp_standard.sysparm.location_structure_id,

801: null,
802: arp_standard.profile.user_id,
803: sysdate,
804: location_ccid,
805: arp_standard.sysparm.location_structure_id,
806: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)
807: + decode( r3.override_rate2, null, nvl(r2.tax_rate,0), r3.override_rate2)
808: + decode( r3.override_rate3, null, nvl(r3.tax_rate,0), r3.override_rate3),
809: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1),

Line 879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

875: start_date,
876: end_date,
877: enabled_flag)
878: select
879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
880: sysdate,
881: arp_standard.profile.user_id,
882: null,
883: arp_standard.profile.user_id,

Line 881: arp_standard.profile.user_id,

877: enabled_flag)
878: select
879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
880: sysdate,
881: arp_standard.profile.user_id,
882: null,
883: arp_standard.profile.user_id,
884: sysdate,
885: location_ccid,

Line 883: arp_standard.profile.user_id,

879: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
880: sysdate,
881: arp_standard.profile.user_id,
882: null,
883: arp_standard.profile.user_id,
884: sysdate,
885: location_ccid,
886: arp_standard.sysparm.location_structure_id,
887: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)

Line 886: arp_standard.sysparm.location_structure_id,

882: null,
883: arp_standard.profile.user_id,
884: sysdate,
885: location_ccid,
886: arp_standard.sysparm.location_structure_id,
887: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)
888: + decode( r3.override_rate2, null, nvl(r2.tax_rate,0), r3.override_rate2)
889: + decode( r3.override_rate3, null, nvl(r3.tax_rate,0), r3.override_rate3),
890: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1),

Line 945: last_updated_by = arp_standard.profile.user_id,

941: END IF;
942:
943: update ar_location_combinations
944: set last_update_date = sysdate ,
945: last_updated_by = arp_standard.profile.user_id,
946: program_id = arp_standard.profile.program_id,
947: program_application_id = arp_standard.profile.program_application_id
948: where location_id in ( select loc_assign.loc_id
949: from hz_party_sites party_site,

Line 946: program_id = arp_standard.profile.program_id,

942:
943: update ar_location_combinations
944: set last_update_date = sysdate ,
945: last_updated_by = arp_standard.profile.user_id,
946: program_id = arp_standard.profile.program_id,
947: program_application_id = arp_standard.profile.program_application_id
948: where location_id in ( select loc_assign.loc_id
949: from hz_party_sites party_site,
950: hz_loc_assignments loc_assign,

Line 947: program_application_id = arp_standard.profile.program_application_id

943: update ar_location_combinations
944: set last_update_date = sysdate ,
945: last_updated_by = arp_standard.profile.user_id,
946: program_id = arp_standard.profile.program_id,
947: program_application_id = arp_standard.profile.program_application_id
948: where location_id in ( select loc_assign.loc_id
949: from hz_party_sites party_site,
950: hz_loc_assignments loc_assign,
951: hz_locations loc,

Line 1016: last_updated_by = arp_standard.profile.user_id

1012: -- is not shipped to customers )
1013: --
1014: UPDATE ar_sales_tax SET enabled_flag = 'N',
1015: last_update_date = sysdate,
1016: last_updated_by = arp_standard.profile.user_id
1017: WHERE rowid = tax.rowid;
1018: END IF;
1019: CLOSE PurgeRateUsed;
1020: END ;

Line 1121: where p.application_id = arp_standard.application_id

1117:
1118: cursor sel_date( trx_date in date ) is
1119: select p.start_date, p.end_date
1120: from gl_period_statuses p, gl_sets_of_books g
1121: where p.application_id = arp_standard.application_id
1122: and p.set_of_books_id = arp_standard.sysparm.set_of_books_id
1123: and trunc(trx_date) between p.start_date and p.end_date
1124: and g.set_of_books_id = p.set_of_books_id
1125: and g.accounted_period_type = p.period_type;

Line 1122: and p.set_of_books_id = arp_standard.sysparm.set_of_books_id

1118: cursor sel_date( trx_date in date ) is
1119: select p.start_date, p.end_date
1120: from gl_period_statuses p, gl_sets_of_books g
1121: where p.application_id = arp_standard.application_id
1122: and p.set_of_books_id = arp_standard.sysparm.set_of_books_id
1123: and trunc(trx_date) between p.start_date and p.end_date
1124: and g.set_of_books_id = p.set_of_books_id
1125: and g.accounted_period_type = p.period_type;
1126:

Line 1142: arp_standard.fnd_message( 'AR_TW_NO_PERIOD_DEFINED','DATE',to_char(trx_date));

1138:
1139: if sel_date%notfound
1140: then
1141: close sel_date;
1142: arp_standard.fnd_message( 'AR_TW_NO_PERIOD_DEFINED','DATE',to_char(trx_date));
1143: IF PG_DEBUG = 'Y' THEN
1144: arp_util_tax.debug('AR ACCOUNTING PERIOD IS NOT DEFINED');
1145: END IF;
1146:

Line 1335: * Standard Tax rules can only search for Exemptions that are marked as

1331: and x.customer_id = customer
1332: and s.site_use_id = site
1333: and x.tax_code = taxcode
1334: /*
1335: * Standard Tax rules can only search for Exemptions that are marked as
1336: * PRIMARY. All other exemptions are ignored.
1337: *
1338: */
1339: AND (( tax_exempt_flag = 'S' and x.status = 'PRIMARY' )

Line 1445: arp_standard.fnd_message( 'AR_NO_REASON_FOR_EXEMPTION' );

1441: end loop;
1442:
1443: if l_tax_exempt_reason_code is null and tax_exempt_flag = 'E'
1444: then
1445: arp_standard.fnd_message( 'AR_NO_REASON_FOR_EXEMPTION' );
1446: IF PG_DEBUG = 'Y' THEN
1447: arp_util_tax.debug('NO REASON FOR EXEMPTION ');
1448: END IF;
1449:

Line 1452: if arp_standard.sysparm.tax_use_customer_exempt_flag = 'Y' and

1448: END IF;
1449:
1450: end if;
1451:
1452: if arp_standard.sysparm.tax_use_customer_exempt_flag = 'Y' and
1453: tax_exempt_flag <> 'R' then
1454:
1455: /* Standard Tax Rules May have a customer Exemption */
1456: if tax_exempt_flag = 'S' then

Line 1455: /* Standard Tax Rules May have a customer Exemption */

1451:
1452: if arp_standard.sysparm.tax_use_customer_exempt_flag = 'Y' and
1453: tax_exempt_flag <> 'R' then
1454:
1455: /* Standard Tax Rules May have a customer Exemption */
1456: if tax_exempt_flag = 'S' then
1457:
1458: OPEN chk_customer_exemption( bill_to_customer_id );
1459: FETCH chk_customer_exemption into dummy;

Line 1595: arp_standard.fnd_message( 'AR_STAX_NO_LOCATION_ID', 'SITE_USE_ID', ship_to_site_id );

1591: l_location_id_segment(10);
1592:
1593: if sel_location_ids%NOTFOUND then
1594: CLOSE sel_location_ids;
1595: arp_standard.fnd_message( 'AR_STAX_NO_LOCATION_ID', 'SITE_USE_ID', ship_to_site_id );
1596: IF PG_DEBUG = 'Y' THEN
1597: arp_util_tax.debug('AR STAX NO LOCATION ID');
1598: END IF;
1599: end if;

Line 1618: arp_standard.fnd_message( 'AR_STAX_NOT_INSTALLED' );

1614: /* arp_flex.expand can raise error message if the sales tax location flexfield */
1615: /* has been reconfigured without then rerunning the pl/sql flexfield precompiler */
1616: /*********************************************************************************/
1617: WHEN OTHERS THEN
1618: arp_standard.fnd_message( 'AR_STAX_NOT_INSTALLED' );
1619: IF PG_DEBUG = 'Y' THEN
1620: arp_util_tax.debug('STAX NOT INSTALLED');
1621: END IF;
1622:

Line 1676: arp_standard.profile.user_id,

1672: )
1673: values
1674: (
1675: l_exemption_id,
1676: arp_standard.profile.user_id,
1677: sysdate,
1678: 'CUSTOMER',
1679: 'Y',
1680: arp_standard.profile.user_id,

Line 1680: arp_standard.profile.user_id,

1676: arp_standard.profile.user_id,
1677: sysdate,
1678: 'CUSTOMER',
1679: 'Y',
1680: arp_standard.profile.user_id,
1681: sysdate,
1682: 100.00,
1683: l_period_start_date,
1684: tax_code,

Line 1687: arp_standard.application_id,

1683: l_period_start_date,
1684: tax_code,
1685: bill_to_customer_id,
1686: null,
1687: arp_standard.application_id,
1688: arp_standard.profile.program_id,
1689: sysdate,
1690: arp_standard.profile.request_id,
1691: l_tax_exempt_number,

Line 1688: arp_standard.profile.program_id,

1684: tax_code,
1685: bill_to_customer_id,
1686: null,
1687: arp_standard.application_id,
1688: arp_standard.profile.program_id,
1689: sysdate,
1690: arp_standard.profile.request_id,
1691: l_tax_exempt_number,
1692: l_tax_exempt_reason_code,

Line 1690: arp_standard.profile.request_id,

1686: null,
1687: arp_standard.application_id,
1688: arp_standard.profile.program_id,
1689: sysdate,
1690: arp_standard.profile.request_id,
1691: l_tax_exempt_number,
1692: l_tax_exempt_reason_code,
1693: 'UNAPPROVED',
1694: arp_standard.sysparm.location_structure_id,

Line 1694: arp_standard.sysparm.location_structure_id,

1690: arp_standard.profile.request_id,
1691: l_tax_exempt_number,
1692: l_tax_exempt_reason_code,
1693: 'UNAPPROVED',
1694: arp_standard.sysparm.location_structure_id,
1695: l_location_id_segment(1),
1696: l_location_id_segment(2),
1697: l_location_id_segment(3),
1698: l_location_id_segment(4),

Line 1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||

1783:
1784:
1785: else
1786: IF PG_DEBUG = 'Y' THEN
1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||
1788: arp_standard.sysparm.tax_use_customer_exempt_flag );
1789: END IF;
1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag
1791:

Line 1788: arp_standard.sysparm.tax_use_customer_exempt_flag );

1784:
1785: else
1786: IF PG_DEBUG = 'Y' THEN
1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||
1788: arp_standard.sysparm.tax_use_customer_exempt_flag );
1789: END IF;
1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag
1791:
1792:

Line 1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag

1786: IF PG_DEBUG = 'Y' THEN
1787: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.SYSPARM.TAX_USE_CUSTOMER_EXEMPT_FLAG = ' ||
1788: arp_standard.sysparm.tax_use_customer_exempt_flag );
1789: END IF;
1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag
1791:
1792:
1793: if arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'
1794: and l_exemption_type is null THEN

Line 1793: if arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'

1789: END IF;
1790: end if; -- arp_standard.sysparm.tax_use_customer_exempt_flag
1791:
1792:
1793: if arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'
1794: and l_exemption_type is null THEN
1795:
1796: OPEN sel_item_exemption( inventory_item_id,
1797: tax_code, trx_date );

Line 1826: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.TAX_USE_PRODUCT_EXEMPT_FLAG = ' ||

1822: --
1823: -- Product Exmeptions must be turned off in the system parameters form
1824: --
1825: IF PG_DEBUG = 'Y' THEN
1826: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.TAX_USE_PRODUCT_EXEMPT_FLAG = ' ||
1827: arp_standard.sysparm.TAX_USE_PRODUCT_EXEMPT_FLAG );
1828: END IF;
1829: END IF;
1830:

Line 1827: arp_standard.sysparm.TAX_USE_PRODUCT_EXEMPT_FLAG );

1823: -- Product Exmeptions must be turned off in the system parameters form
1824: --
1825: IF PG_DEBUG = 'Y' THEN
1826: arp_util_tax.debug( 'I: FIND_TAX_EXEMPTION_ID: ARP_STANDARD.TAX_USE_PRODUCT_EXEMPT_FLAG = ' ||
1827: arp_standard.sysparm.TAX_USE_PRODUCT_EXEMPT_FLAG );
1828: END IF;
1829: END IF;
1830:
1831: end if; --arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'

Line 1831: end if; --arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'

1827: arp_standard.sysparm.TAX_USE_PRODUCT_EXEMPT_FLAG );
1828: END IF;
1829: END IF;
1830:
1831: end if; --arp_standard.sysparm.tax_use_product_exempt_flag = 'Y'
1832:
1833: percent_exempt := l_percent_exempt;
1834: tax_exemption_id := l_exemption_id;
1835: reason_code := l_tax_exempt_reason_code;

Line 1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,

1917: start_date,
1918: end_date,
1919: enabled_flag)
1920: select
1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
1922: sysdate,
1923: arp_standard.profile.user_id,
1924: null,
1925: arp_standard.profile.user_id,

Line 1923: arp_standard.profile.user_id,

1919: enabled_flag)
1920: select
1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
1922: sysdate,
1923: arp_standard.profile.user_id,
1924: null,
1925: arp_standard.profile.user_id,
1926: sysdate,
1927: ccid.location_id,

Line 1925: arp_standard.profile.user_id,

1921: AR_SALES_TAX_S.NEXTVAL+arp_standard.sequence_offset,
1922: sysdate,
1923: arp_standard.profile.user_id,
1924: null,
1925: arp_standard.profile.user_id,
1926: sysdate,
1927: ccid.location_id,
1928: arp_standard.sysparm.location_structure_id,
1929: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)

Line 1928: arp_standard.sysparm.location_structure_id,

1924: null,
1925: arp_standard.profile.user_id,
1926: sysdate,
1927: ccid.location_id,
1928: arp_standard.sysparm.location_structure_id,
1929: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1)
1930: + decode( r3.override_rate2, null, nvl(r2.tax_rate,0), r3.override_rate2)
1931: + decode( r3.override_rate3, null, nvl(r3.tax_rate,0), r3.override_rate3),
1932: decode( r3.override_rate1, null, nvl(r1.tax_rate,0), r3.override_rate1),