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_VALUES

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 240: | This function Returns a parent value in AR_LOCATION_VALUES for any |

236: | PUBLIC FUNCTION |
237: | find_missing_parent_in_loc |
238: | |
239: | DESCRIPTION |
240: | This function Returns a parent value in AR_LOCATION_VALUES for any |
241: | given segment of a location flexfield. This is required because it |
242: | is quite normal not to specifiy the county for any address within the |
243: | United states of America. |
244: | |

Line 286: from ar_location_values v2,

282: BEGIN
283:
284:
285: SELECT DISTINCT v1.location_segment_value into parent_value
286: from ar_location_values v2,
287: ar_location_values v1
288: WHERE v1.location_segment_id = v2.parent_segment_id
289: and v2.location_segment_value = rtrim(ltrim(upper(p_value)))
290: and v2.location_segment_qualifier = p_location_segment_qualifier

Line 287: ar_location_values v1

283:
284:
285: SELECT DISTINCT v1.location_segment_value into parent_value
286: from ar_location_values v2,
287: ar_location_values v1
288: WHERE v1.location_segment_id = v2.parent_segment_id
289: and v2.location_segment_value = rtrim(ltrim(upper(p_value)))
290: and v2.location_segment_qualifier = p_location_segment_qualifier
291: and v1.location_structure_id = arp_standard.sysparm.location_structure_id

Line 313: from ar_location_values v2,

309: if ( p_postal_code is not null )
310: then
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)))

Line 314: ar_location_values v1,

310: then
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

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 369: | new row in ar_location_values |

365: | OPTIONAL |
366: | |
367: | Descriptive Flexfield Attribute_category and Descriptive Flexfield |
368: | information, used if this calls inserts a |
369: | new row in ar_location_values |
370: | |
371: | Search_Precission If an existing locaion could not be found |
372: | and the supplied location is this number of |
373: | characters wide, then reattempt the search |

Line 427: | Check AR_LOCATION_VALUES for existing location_segment_id given |

423: | PRIVATE CURSOR |
424: | location_value_given_parent_c |
425: | |
426: | DESCRIPTION |
427: | Check AR_LOCATION_VALUES for existing location_segment_id given |
428: | parent_segment_id and location_segment_value. |
429: | |
430: | WARNING |
431: | DO NOT MODIFY THIS CURSOR ADDING ANY SELECT COLUMNS. |

Line 433: | only access from AR_LOCATION_VALUES_U2. |

429: | |
430: | WARNING |
431: | DO NOT MODIFY THIS CURSOR ADDING ANY SELECT COLUMNS. |
432: | The select does not perform any table accesses, utilising index |
433: | only access from AR_LOCATION_VALUES_U2. |
434: | |
435: | EXPLAIN PLAN |
436: | OPERATION OPTIONS OBJECT_NAME |
437: | ---------------------- --------------- ----------------------------- |

Line 438: | INDEX RANGE SCAN AR_LOCATION_VALUES_U2 |

434: | |
435: | EXPLAIN PLAN |
436: | OPERATION OPTIONS OBJECT_NAME |
437: | ---------------------- --------------- ----------------------------- |
438: | INDEX RANGE SCAN AR_LOCATION_VALUES_U2 |
439: | |
440: | MODIFICATION HISTORY |
441: | 22-Jan-93 Nigel Smith Created. |
442: +------------------------------------------------------------------------*/

Line 449: from ar_location_values

445: CURSOR location_value_given_parent_c( p_location_segment_qualifier in varchar2,
446: p_segment_value in varchar2,
447: p_parent_segment_id in number) is
448: select location_segment_id
449: from ar_location_values
450: where location_segment_qualifier = p_location_segment_qualifier
451: and location_structure_id = arp_standard.sysparm.location_structure_id
452: and parent_segment_id = p_parent_segment_id
453: and location_segment_value = rtrim(upper(p_segment_value), ' ');

Line 461: from ar_location_values

457: p_segment_value in varchar2,
458: p_parent_segment_id in number,
459: p_search_precission in number) is
460: select location_segment_id
461: from ar_location_values
462: where location_segment_qualifier = p_location_segment_qualifier
463: and location_structure_id = arp_standard.sysparm.location_structure_id
464: and parent_segment_id = p_parent_segment_id
465: and substr(location_segment_value,1,p_search_precission)

Line 474: from ar_location_values

470:
471: CURSOR location_value_no_parent_c( p_location_segment_qualifier in varchar2,
472: p_segment_value in varchar2 ) IS
473: select location_segment_id
474: from ar_location_values
475: where location_segment_qualifier = p_location_segment_qualifier
476: and location_structure_id = arp_standard.sysparm.location_structure_id
477: and location_segment_value = rtrim(upper(p_segment_value), ' ' );
478:

Line 568: -- first nn character in ar_location_values.location_segment_value

564: +-------------------------------------------------------------------------*/
565:
566: -- Check if the width of this location is equal to the search precission
567: -- if any was specificed, if so re-attempt this search using just the
568: -- first nn character in ar_location_values.location_segment_value
569: -- BUGFIX: INC: 27093
570:
571: /*** MB skip, we want to see if the character length of segment_value ***/
572: /*** >= search_precission ***/

Line 735: from ar_location_values

731: into location_segment_value,
732: location_segment_description,
733: location_segment_qualifier,
734: parent_segment_id
735: from ar_location_values
736: where location_segment_id = location_information.location_segment_id;
737:
738: end;
739:

Line 753: from ar_location_values v1

749: select location_segment_description,
750: parent_segment_id
751: into location_segment_description,
752: parent_segment_id
753: from ar_location_values v1
754: where v1.location_segment_qualifier = location_information.location_segment_qualifier
755: and v1.location_segment_value = ltrim(rtrim(upper(location_information.location_segment_value)))
756: and v1.location_structure_id = arp_standard.sysparm.location_structure_id;
757:

Line 764: from ar_location_values v1

760: THEN
761: BEGIN
762: select max(location_segment_description), max(parent_segment_id)
763: into location_segment_description, parent_segment_id
764: from ar_location_values v1
765: where v1.location_segment_qualifier = location_information.location_segment_qualifier
766: and v1.location_structure_id = arp_standard.sysparm.location_structure_id
767: and v1.location_segment_value = ltrim(rtrim(location_information.location_segment_value));
768: END;

Line 859: | This function generates a new record in the table: AR_LOCATION_VALUES |

855: | PUBLIC FUNCTION |
856: | ins_location_values |
857: | |
858: | DESCRIPTION |
859: | This function generates a new record in the table: AR_LOCATION_VALUES |
860: | and returns the LOCATION_SEGMENT_ID of this new record |
861: | |
862: | REQUIRES |
863: | location_segment_qualifier Value set name used of this segment |

Line 906: location_segment_value ar_location_values.location_segment_value%TYPE;

902:
903: location_id number;
904: l_organization_id number;
905: location_value_account_id number;
906: location_segment_value ar_location_values.location_segment_value%TYPE;
907: location_segment_user_value ar_location_values.location_segment_user_value%TYPE;
908: location_segment_description ar_location_values.location_segment_description%TYPE;
909:
910: BEGIN

Line 907: location_segment_user_value ar_location_values.location_segment_user_value%TYPE;

903: location_id number;
904: l_organization_id number;
905: location_value_account_id number;
906: location_segment_value ar_location_values.location_segment_value%TYPE;
907: location_segment_user_value ar_location_values.location_segment_user_value%TYPE;
908: location_segment_description ar_location_values.location_segment_description%TYPE;
909:
910: BEGIN
911: IF PG_DEBUG = 'Y' THEN

Line 908: location_segment_description ar_location_values.location_segment_description%TYPE;

904: l_organization_id number;
905: location_value_account_id number;
906: location_segment_value ar_location_values.location_segment_value%TYPE;
907: location_segment_user_value ar_location_values.location_segment_user_value%TYPE;
908: location_segment_description ar_location_values.location_segment_description%TYPE;
909:
910: BEGIN
911: IF PG_DEBUG = 'Y' THEN
912: arp_util_tax.debug( '>> INS_LOCATION_VALUES( ' ||

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,

Line 926: insert into ar_location_values( location_structure_id,

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,
929: location_segment_value,
930: location_segment_user_value,

Line 1018: | location_segment_id Foreign Key to AR_LOCATION_VALUES |

1014: | Organizations. |
1015: | |
1016: | REQUIRES |
1017: | location_segment_qualifier Value set name used of this segment |
1018: | location_segment_id Foreign Key to AR_LOCATION_VALUES |
1019: | |
1020: | EXCEPTIONS RAISED |
1021: | |
1022: | MODIFICATION HISTORY |

Line 1822: from ar_location_values v1,

1818:
1819: select v1.location_segment_id,
1820: v2.location_segment_id,
1821: v3.location_segment_id
1822: from ar_location_values v1,
1823: ar_location_values v2,
1824: ar_location_values v3
1825: where v1.location_segment_value = upper(param.STATE)
1826: and v2.location_segment_value = upper(param.COUNTY)

Line 1823: ar_location_values v2,

1819: select v1.location_segment_id,
1820: v2.location_segment_id,
1821: v3.location_segment_id
1822: from ar_location_values v1,
1823: ar_location_values v2,
1824: ar_location_values v3
1825: where v1.location_segment_value = upper(param.STATE)
1826: and v2.location_segment_value = upper(param.COUNTY)
1827: and v3.location_segment_value = upper(param.CITY)

Line 1824: ar_location_values v3

1820: v2.location_segment_id,
1821: v3.location_segment_id
1822: from ar_location_values v1,
1823: ar_location_values v2,
1824: ar_location_values v3
1825: where v1.location_segment_value = upper(param.STATE)
1826: and v2.location_segment_value = upper(param.COUNTY)
1827: and v3.location_segment_value = upper(param.CITY)
1828: and v2.parent_segment_id = v1.location_segment_id

Line 1972: | CALLED BY TRIGGER AR_LOCATION_VALUES_BRIU |

1968: /*-------------------------------------------------------------------------+
1969: | PUBLIC FUNCTION |
1970: | TERR_SHORT_NAME |
1971: | |
1972: | CALLED BY TRIGGER AR_LOCATION_VALUES_BRIU |
1973: | |
1974: | DESCRIPTION |
1975: | |
1976: | Given a territory code, this function returns the description for that |

Line 2048: | the tables: AR_LOCATION_VALUES and AR_LOCATION_COMBINATIONS |

2044: | Location_ID column to the Code Combinations ID applicable to this |
2045: | address. |
2046: | |
2047: | In order to do this, it may be necessary to insert new items into |
2048: | the tables: AR_LOCATION_VALUES and AR_LOCATION_COMBINATIONS |
2049: | |
2050: | REQUIRES |
2051: | City City column of RA_ADDRESSES |
2052: | State State column of RA_ADDRESSES |

Line 2270: | trigger, AR_LOCATION_VALUES_BRIU has access to this information for |

2266: BEGIN
2267:
2268: /*---------------------------------------------------------------------------+
2269: | Initialise Sales Tax Location Flexfield qualifiers so that the database |
2270: | trigger, AR_LOCATION_VALUES_BRIU has access to this information for |
2271: | validation purposes. |
2272: *---------------------------------------------------------------------------*/
2273:
2274: ARP_ADDS_MINUS99.first_segment_qualifier := 'STATE';