APPS.ARP_ADDS_MINUS99 dependencies on AR_LOCATION_RATES_S

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 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 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,