DBA Data[Home] [Help]

APPS.ARP_ADDS_MINUS99 dependencies on AR_LOCATION_COMBINATIONS_S

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,