APPS.ARP_ADDS_MINUS99 dependencies on AR_LOCATION_VALUES_S

Line 84: | ar_location_values_s_c |

80:
81:
82: /*-------------------------------------------------------------------------+
83: | PRIVATE CURSOR |
84: | ar_location_values_s_c |
85: | |
86: | DESCRIPTION |
87: | Return the next value from the sequence AR_LOCATION_VALUES_S |
88: | |

Line 87: | Return the next value from the sequence AR_LOCATION_VALUES_S |

83: | PRIVATE CURSOR |
84: | ar_location_values_s_c |
85: | |
86: | DESCRIPTION |
87: | Return the next value from the sequence AR_LOCATION_VALUES_S |
88: | |
89: | REQUIRES |
90: | |
91: | RETURNS |

Line 103: CURSOR ar_location_values_s_c IS

99: | |
100: +-------------------------------------------------------------------------*/
101:
102:
103: CURSOR ar_location_values_s_c IS
104: select ar_location_values_s.nextval + arp_standard.sequence_offset
105: from dual;
106:
107:

Line 104: select ar_location_values_s.nextval + arp_standard.sequence_offset

100: +-------------------------------------------------------------------------*/
101:
102:
103: CURSOR ar_location_values_s_c IS
104: select ar_location_values_s.nextval + arp_standard.sequence_offset
105: from dual;
106:
107:
108:

Line 357: | AR_LOCATION_VALUES_S.nextval |

353: | location flexfield segment. |
354: | |
355: | If the given value cannot be found in the table, it is inserted |
356: | and the new location_segment_id is returned from the sequence |
357: | AR_LOCATION_VALUES_S.nextval |
358: | |
359: | REQUIRES |
360: | |
361: | location_segment_qualifier Value set name used of this segment,eg City|

Line 922: OPEN ar_location_values_s_c;

918: location_segment_value := ltrim(rtrim(upper( segment_value )));
919: location_segment_user_value := ltrim(rtrim( segment_value ));
920: location_segment_description := initcap( segment_description );
921:
922: OPEN ar_location_values_s_c;
923: FETCH ar_location_values_s_c into location_id;
924: CLOSE ar_location_values_s_c;
925:
926: insert into ar_location_values( location_structure_id,

Line 923: FETCH ar_location_values_s_c into location_id;

919: location_segment_user_value := ltrim(rtrim( segment_value ));
920: location_segment_description := initcap( segment_description );
921:
922: OPEN ar_location_values_s_c;
923: FETCH ar_location_values_s_c into location_id;
924: CLOSE ar_location_values_s_c;
925:
926: insert into ar_location_values( location_structure_id,
927: location_segment_qualifier,

Line 924: CLOSE ar_location_values_s_c;

920: location_segment_description := initcap( segment_description );
921:
922: OPEN ar_location_values_s_c;
923: FETCH ar_location_values_s_c into location_id;
924: CLOSE ar_location_values_s_c;
925:
926: insert into ar_location_values( location_structure_id,
927: location_segment_qualifier,
928: location_segment_id,