APPS.ARP_ADDS_MINUS99 dependencies on AR_LOCATION_COMBINATIONS

Line 75: CURSOR ar_location_combinations_s_c is

71: +-------------------------------------------------------------------------*/
72:
73:
74:
75: CURSOR ar_location_combinations_s_c is
76: select ar_location_combinations_s.nextval + arp_standard.sequence_offset
77: from dual;
78:
79:

Line 76: select ar_location_combinations_s.nextval + arp_standard.sequence_offset

72:
73:
74:
75: CURSOR ar_location_combinations_s_c is
76: select ar_location_combinations_s.nextval + arp_standard.sequence_offset
77: from dual;
78:
79:
80:

Line 1716: OPEN ar_location_combinations_s_c;

1712: IF PG_DEBUG = 'Y' THEN
1713: arp_util_tax.debug( '>> INS_LOCATION_COMBINATIONS' );
1714: END IF;
1715:
1716: OPEN ar_location_combinations_s_c;
1717: FETCH ar_location_combinations_s_c into location_id;
1718: CLOSE ar_location_combinations_s_c;
1719:
1720: insert into ar_location_combinations( LOCATION_ID,

Line 1717: FETCH ar_location_combinations_s_c into location_id;

1713: arp_util_tax.debug( '>> INS_LOCATION_COMBINATIONS' );
1714: END IF;
1715:
1716: OPEN ar_location_combinations_s_c;
1717: FETCH ar_location_combinations_s_c into location_id;
1718: CLOSE ar_location_combinations_s_c;
1719:
1720: insert into ar_location_combinations( LOCATION_ID,
1721: LOCATION_STRUCTURE_ID,

Line 1718: CLOSE ar_location_combinations_s_c;

1714: END IF;
1715:
1716: OPEN ar_location_combinations_s_c;
1717: FETCH ar_location_combinations_s_c into location_id;
1718: CLOSE ar_location_combinations_s_c;
1719:
1720: insert into ar_location_combinations( LOCATION_ID,
1721: LOCATION_STRUCTURE_ID,
1722: ENABLED_FLAG,

Line 1720: insert into ar_location_combinations( LOCATION_ID,

1716: OPEN ar_location_combinations_s_c;
1717: FETCH ar_location_combinations_s_c into location_id;
1718: CLOSE ar_location_combinations_s_c;
1719:
1720: insert into ar_location_combinations( LOCATION_ID,
1721: LOCATION_STRUCTURE_ID,
1722: ENABLED_FLAG,
1723: LAST_UPDATED_BY,
1724: LAST_UPDATE_DATE,

Line 1785: | AR_LOCATION_COMBINATIONS given each of the possible values for |

1781: | find_location_ccid |
1782: | |
1783: | DESCRIPTION |
1784: | This functions attempts to find the LOCATION_CCID from the table |
1785: | AR_LOCATION_COMBINATIONS given each of the possible values for |
1786: | segments in the LOCATION flexfield structure. |
1787: | If no such record exists, this record will, if each of the values |
1788: | exist, create a new record and return the LOCATION_CCID of the new |
1789: | record. |

Line 1898: from ar_location_combinations cc

1894: p_location_id_segment_8 in number,
1895: p_location_id_segment_9 in number,
1896: p_location_id_segment_10 in number ) IS
1897: select location_id
1898: from ar_location_combinations cc
1899: where location_structure_id = arp_standard.sysparm.location_structure_id
1900: and cc.LOCATION_ID_SEGMENT_1 = p_LOCATION_ID_SEGMENT_1
1901: and cc.LOCATION_ID_SEGMENT_2 = p_LOCATION_ID_SEGMENT_2
1902: and cc.LOCATION_ID_SEGMENT_3 = p_LOCATION_ID_SEGMENT_3;

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 |