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_ADDS_MINUS99 dependencies on AR_LOCATION_RATES

Line 211: | ar_location_rates_s_c |

207:
208:
209: /*-------------------------------------------------------------------------+
210: | PRIVATE CURSOR |
211: | ar_location_rates_s_c |
212: | |
213: | DESCRIPTION |
214: | Return the next value from the sequence AR_LOCATION_RATES_S |
215: | |

Line 214: | Return the next value from the sequence AR_LOCATION_RATES_S |

210: | PRIVATE CURSOR |
211: | ar_location_rates_s_c |
212: | |
213: | DESCRIPTION |
214: | Return the next value from the sequence AR_LOCATION_RATES_S |
215: | |
216: | REQUIRES |
217: | |
218: | RETURNS |

Line 230: CURSOR ar_location_rates_s_c IS

226: | |
227: +-------------------------------------------------------------------------*/
228:
229:
230: CURSOR ar_location_rates_s_c IS
231: select ar_location_rates_s.nextval + arp_standard.sequence_offset
232: from dual;
233:
234:

Line 231: select ar_location_rates_s.nextval + arp_standard.sequence_offset

227: +-------------------------------------------------------------------------*/
228:
229:
230: CURSOR ar_location_rates_s_c IS
231: select ar_location_rates_s.nextval + arp_standard.sequence_offset
232: from dual;
233:
234:
235: /*-------------------------------------------------------------------------+

Line 315: ar_location_rates r1

311:
312: SELECT DISTINCT v1.location_segment_value into parent_value
313: from ar_location_values v2,
314: ar_location_values v1,
315: ar_location_rates r1
316: WHERE v1.location_segment_id = v2.parent_segment_id
317: and v2.location_segment_value = ltrim(rtrim(upper(p_value)))
318: and v2.location_segment_qualifier = p_location_segment_qualifier
319: and v2.location_segment_id = r1.location_segment_id

Line 1264: | This function generates a new record in the table: AR_LOCATION_RATES |

1260: | PUBLIC FUNCTION |
1261: | ins_location_rates |
1262: | |
1263: | DESCRIPTION |
1264: | This function generates a new record in the table: AR_LOCATION_RATES |
1265: | and returns the LOCATION_RATE_ID of this new record |
1266: | |
1267: | REQUIRES |
1268: | |

Line 1375: OPEN ar_location_rates_s_c;

1371: END IF;
1372:
1373: end if;
1374:
1375: OPEN ar_location_rates_s_c;
1376: FETCH ar_location_rates_s_c into location_rate_id;
1377: CLOSE ar_location_rates_s_c;
1378:
1379: insert into ar_location_rates( location_rate_id,

Line 1376: FETCH ar_location_rates_s_c into location_rate_id;

1372:
1373: end if;
1374:
1375: OPEN ar_location_rates_s_c;
1376: FETCH ar_location_rates_s_c into location_rate_id;
1377: CLOSE ar_location_rates_s_c;
1378:
1379: insert into ar_location_rates( location_rate_id,
1380: location_segment_id,

Line 1377: CLOSE ar_location_rates_s_c;

1373: end if;
1374:
1375: OPEN ar_location_rates_s_c;
1376: FETCH ar_location_rates_s_c into location_rate_id;
1377: CLOSE ar_location_rates_s_c;
1378:
1379: insert into ar_location_rates( location_rate_id,
1380: location_segment_id,
1381: from_postal_code,

Line 1379: insert into ar_location_rates( location_rate_id,

1375: OPEN ar_location_rates_s_c;
1376: FETCH ar_location_rates_s_c into location_rate_id;
1377: CLOSE ar_location_rates_s_c;
1378:
1379: insert into ar_location_rates( location_rate_id,
1380: location_segment_id,
1381: from_postal_code,
1382: to_postal_code,
1383: start_date,

Line 1562: insert into ar_location_rates( location_rate_id,

1558: arp_util_tax.debug('End date is null');
1559: END IF;
1560: end if;
1561:
1562: insert into ar_location_rates( location_rate_id,
1563: location_segment_id,
1564: from_postal_code,
1565: to_postal_code,
1566: start_date,

Line 1605: VALUES ( ar_location_rates_s.nextval + arp_standard.sequence_offset,

1601: override_rate7,
1602: override_rate8,
1603: override_rate9,
1604: override_rate10 )
1605: VALUES ( ar_location_rates_s.nextval + arp_standard.sequence_offset,
1606: location_segment_id,
1607: from_postal_code,
1608: to_postal_code,
1609: start_date,

Line 1855: from ar_location_rates r1,

1851: and tax.enabled_flag = 'Y'
1852: and not exists (
1853: select
1854: 'x'
1855: from ar_location_rates r1,
1856: ar_location_rates r2,
1857: ar_location_rates r3
1858: where r1.location_segment_id = p_location_id_segment_1
1859: and r2.location_segment_id = p_location_id_segment_2

Line 1856: ar_location_rates r2,

1852: and not exists (
1853: select
1854: 'x'
1855: from ar_location_rates r1,
1856: ar_location_rates r2,
1857: ar_location_rates r3
1858: where r1.location_segment_id = p_location_id_segment_1
1859: and r2.location_segment_id = p_location_id_segment_2
1860: and r3.location_segment_id = p_location_id_segment_3

Line 1857: ar_location_rates r3

1853: select
1854: 'x'
1855: from ar_location_rates r1,
1856: ar_location_rates r2,
1857: ar_location_rates r3
1858: where r1.location_segment_id = p_location_id_segment_1
1859: and r2.location_segment_id = p_location_id_segment_2
1860: and r3.location_segment_id = p_location_id_segment_3
1861: and greatest( r1.from_postal_code,

Line 2235: | in the table AR_LOCATION_RATES. |

2231: | DESCRIPTION |
2232: | |
2233: | Return the default values for the columns:- |
2234: | start_date, end_date, from_postal_code and to_postal_code |
2235: | in the table AR_LOCATION_RATES. |
2236: | |
2237: | MODIFIES |
2238: | from_postal_code |
2239: | to_postal_code |