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_TAX_INTERFACE dependencies on AR_TAX_INTERFACE

Line 73: | update STATUS column of AR_TAX_INTERFACE with |

69: | ELIMINATE_OVERLAPPED_RANGE |
70: | |
71: | DESCRIPTION |
72: | This function looks for records which are overlapped each other and |
73: | update STATUS column of AR_TAX_INTERFACE with |
74: | IGNORED-NARROWER-ZIP for the record which zip range is narrower than |
75: | the the other. |
76: | |
77: | MODIFICATION HISTORY |

Line 106: ar_tax_interface ci,

102: ci.location_id,
103: ci.location_value,
104: ci.status
105: from
106: ar_tax_interface ci,
107: ar_tax_interface co,
108: ar_tax_interface st
109: where ci.interface_line_id in (
110: select

Line 107: ar_tax_interface co,

103: ci.location_value,
104: ci.status
105: from
106: ar_tax_interface ci,
107: ar_tax_interface co,
108: ar_tax_interface st
109: where ci.interface_line_id in (
110: select
111: distinct t1.interface_line_id

Line 108: ar_tax_interface st

104: ci.status
105: from
106: ar_tax_interface ci,
107: ar_tax_interface co,
108: ar_tax_interface st
109: where ci.interface_line_id in (
110: select
111: distinct t1.interface_line_id
112: from

Line 113: ar_tax_interface t1,

109: where ci.interface_line_id in (
110: select
111: distinct t1.interface_line_id
112: from
113: ar_tax_interface t1,
114: ar_tax_interface t2
115: where t1.location_value = t2.location_value
116: and t1.segment_qualifier = 'CITY'
117: and t1.parent_location_id = t2.parent_location_id

Line 114: ar_tax_interface t2

110: select
111: distinct t1.interface_line_id
112: from
113: ar_tax_interface t1,
114: ar_tax_interface t2
115: where t1.location_value = t2.location_value
116: and t1.segment_qualifier = 'CITY'
117: and t1.parent_location_id = t2.parent_location_id
118: and t1.interface_line_id <> t2.interface_line_id

Line 168: ar_tax_interface

164: tax_rate,
165: parent_location_id,
166: location_value
167: from
168: ar_tax_interface
169: where interface_line_id <> p_interface_line_id
170: and segment_qualifier = p_segment_qualifier
171: and parent_location_id = p_parent_location_id
172: and location_value = p_location_value

Line 343: arp_util_tax.debug('in ar_tax_interface table, will be updated with IGNORED-NARROWER-ZIP');

339:
340: dis_in_clause := substrb(in_clause, start_pos, end_pos);
341: if pg_debug='Y' then
342: arp_util_tax.debug('STATUS column of records with following interface_line_id');
343: arp_util_tax.debug('in ar_tax_interface table, will be updated with IGNORED-NARROWER-ZIP');
344: end if;
345:
346: while dis_in_clause is not null loop
347: prog_loc := 6;

Line 364: sqlstmt := 'update ar_tax_interface set status =' ||''''||

360: -- Prepareing Dynamic SQL to update overlapped records.
361: --
362: l_cursor := dbms_sql.open_cursor;
363: prog_loc := 7;
364: sqlstmt := 'update ar_tax_interface set status =' ||''''||
365: 'IGNORED-NARROWER-ZIP'||''''||' where interface_line_id in ('||in_clause||')';
366: if pg_debug='Y' then
367: arp_util_tax.debug('Update statement is <><><><><><>');
368: arp_util_tax.debug(substrb(sqlstmt, 1, 250));

Line 382: select count(*) into sel_count from ar_tax_interface where status = 'IGNORED-NARROWER-ZIP';

378:
379: end if;
380: prog_loc := 10;
381:
382: select count(*) into sel_count from ar_tax_interface where status = 'IGNORED-NARROWER-ZIP';
383: if pg_debug='Y' then
384: arp_util_tax.debug('ARP_TAX_INTERFACE.ELIMINATE_OVERLAPPED_RANGE('||': '||
385: to_char(sel_count)||' :'||to_char(sysdate, 'YYYY-MON-DD: HH:MI:SS')||')-');
386: end if;

Line 634: from ar_tax_interface i

630: override_rate7,
631: override_rate8,
632: override_rate9,
633: override_rate10
634: from ar_tax_interface i
635: where i.rate_type = 'SALES'
636: start with parent_location_id is null
637: and i.location_value like nvl(senior_segment,'%')
638: and i.rate_type = 'SALES'

Line 710: action AR_TAX_INTERFACE.STATUS%TYPE;

706: location_end_date TAB_DATE_TYPE;
707: location_rate TAB_RATE_TYPE;
708: new_location BOOLEAN := FALSE;
709: rate_id NUMBER;
710: action AR_TAX_INTERFACE.STATUS%TYPE;
711: this_location NUMBER(15);
712: error_code number;
713: error_text varchar2(4096);
714:

Line 717: /* Update STATUS column of AR_TAX_INTERFACE with NARROWER-ZIP-RANGE for the */

713: error_text varchar2(4096);
714:
715: begin
716:
717: /*** Update STATUS column of AR_TAX_INTERFACE with NARROWER-ZIP-RANGE for the ***/
718: /*** records which are narrower than the other. ***/
719: ELIMINATE_OVERLAPPED_RANGE(senior_segment,
720: default_start_date);
721: current_level := 0;

Line 1411: UPDATE AR_TAX_INTERFACE

1407: END; /* EXCEPTION HANDLER BLOCK */
1408:
1409: END; /* EXCEPTION PROTECTED BLOCK */
1410:
1411: UPDATE AR_TAX_INTERFACE
1412: SET STATUS = action,
1413: /*** MB conversion substr to substrb ***/
1414: ERROR_MESSAGE = substrb(error_text,1,240),
1415: LOCATION_SEGMENT_ID = this_location,

Line 1436: from ar_tax_interface

1432: max_error_count in number default 1000
1433: ) is
1434: cursor sel_segments_null( senior_segment in varchar2 ) is
1435: select distinct location_value
1436: from ar_tax_interface
1437: where parent_location_id is null
1438: and rate_type = 'SALES'
1439: and location_value like nvl(senior_segment,location_value)
1440: order by location_value;

Line 1444: from ar_tax_interface

1440: order by location_value;
1441:
1442: cursor sel_segments( senior_segment in varchar2 ) is
1443: select distinct location_value
1444: from ar_tax_interface
1445: where parent_location_id is null
1446: and rate_type = 'SALES'
1447: and location_value like senior_segment
1448: order by location_value;

Line 1536: from ar_tax_interface;

1532: BEGIN
1533: /*** MB skip, we want the character length ***/
1534: select max(lengthb(location_value))
1535: into max_location_width
1536: from ar_tax_interface;
1537: EXCEPTION
1538: WHEN NO_DATA_FOUND
1539: THEN max_location_width := null;
1540: END;