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_ACCOUNTS_S

Line 153: | ar_location_accounts_s_c |

149:
150:
151: /*-------------------------------------------------------------------------+
152: | PRIVATE CURSOR |
153: | ar_location_accounts_s_c |
154: | |
155: | DESCRIPTION |
156: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |
157: | |

Line 156: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |

152: | PRIVATE CURSOR |
153: | ar_location_accounts_s_c |
154: | |
155: | DESCRIPTION |
156: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |
157: | |
158: | REQUIRES |
159: | |
160: | RETURNS |

Line 170: CURSOR ar_location_accounts_s_c IS

166: | 19-Jun-00 NIPATEL Created for Location Flexfield Sharing project. |
167: | |
168: +-------------------------------------------------------------------------*/
169:
170: CURSOR ar_location_accounts_s_c IS
171: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
172: from dual;
173:
174:

Line 171: select ar_location_accounts_s.nextval + arp_standard.sequence_offset

167: | |
168: +-------------------------------------------------------------------------*/
169:
170: CURSOR ar_location_accounts_s_c IS
171: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
172: from dual;
173:
174:
175:

Line 1152: OPEN ar_location_accounts_s_c;

1148: end if;
1149: CLOSE ar_location_tax_account_c;
1150:
1151:
1152: OPEN ar_location_accounts_s_c;
1153: FETCH ar_location_accounts_s_c into
1154: l_location_value_account_id;
1155: CLOSE ar_location_accounts_s_c;
1156:

Line 1153: FETCH ar_location_accounts_s_c into

1149: CLOSE ar_location_tax_account_c;
1150:
1151:
1152: OPEN ar_location_accounts_s_c;
1153: FETCH ar_location_accounts_s_c into
1154: l_location_value_account_id;
1155: CLOSE ar_location_accounts_s_c;
1156:
1157: location_account_id_tab(i) := l_location_value_account_id;

Line 1155: CLOSE ar_location_accounts_s_c;

1151:
1152: OPEN ar_location_accounts_s_c;
1153: FETCH ar_location_accounts_s_c into
1154: l_location_value_account_id;
1155: CLOSE ar_location_accounts_s_c;
1156:
1157: location_account_id_tab(i) := l_location_value_account_id;
1158: location_segment_id_tab(i) := location_segment_id;
1159: tax_account_ccid_tab(i) := location_tax_account;

Line 1252: if ar_location_accounts_s_c%isopen then

1248: if ar_location_tax_account_c%isopen then
1249: close ar_location_tax_account_c;
1250: end if;
1251:
1252: if ar_location_accounts_s_c%isopen then
1253: close ar_location_accounts_s_c;
1254: end if;
1255:
1256: End ins_location_accounts;

Line 1253: close ar_location_accounts_s_c;

1249: close ar_location_tax_account_c;
1250: end if;
1251:
1252: if ar_location_accounts_s_c%isopen then
1253: close ar_location_accounts_s_c;
1254: end if;
1255:
1256: End ins_location_accounts;
1257: