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.

[Home] [Help]

APPS.AR_LOCVS_PKG dependencies on AR_LOCATION_ACCOUNTS

Line 91: | ar_location_accounts_s_c |

87:
88:
89: /*-------------------------------------------------------------------------+
90: | PRIVATE CURSOR |
91: | ar_location_accounts_s_c |
92: | |
93: | DESCRIPTION |
94: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |
95: | RETURNS |

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

90: | PRIVATE CURSOR |
91: | ar_location_accounts_s_c |
92: | |
93: | DESCRIPTION |
94: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |
95: | RETURNS |
96: | Sequence ID + large constant used for debugging |
97: +-------------------------------------------------------------------------*/
98: CURSOR ar_location_accounts_s_c IS

Line 98: CURSOR ar_location_accounts_s_c IS

94: | Return the next value from the sequence AR_LOCATION_ACCOUNTS_S |
95: | RETURNS |
96: | Sequence ID + large constant used for debugging |
97: +-------------------------------------------------------------------------*/
98: CURSOR ar_location_accounts_s_c IS
99: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
100: from dual;
101:
102: /*------------------------------------------------------------------------+

Line 99: select ar_location_accounts_s.nextval + arp_standard.sequence_offset

95: | RETURNS |
96: | Sequence ID + large constant used for debugging |
97: +-------------------------------------------------------------------------*/
98: CURSOR ar_location_accounts_s_c IS
99: select ar_location_accounts_s.nextval + arp_standard.sequence_offset
100: from dual;
101:
102: /*------------------------------------------------------------------------+
103: | PRIVATE CURSOR |

Line 109: | AR_LOCATION_ACCOUNTS_ALL |

105: | |
106: | DESCRIPTION |
107: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
108: | to create one record per ORG_ID for a new location_id in |
109: | AR_LOCATION_ACCOUNTS_ALL |
110: | RETURNS |
111: | Returns distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
112: +-------------------------------------------------------------------------*/
113:

Line 259: Insert in AR_LOCATION_ACCOUNTS only if the TAX_ACCOUNT_CCID is not null

255: from dual;
256: */
257:
258: /* +----------------------------------------------------------------------------------
259: Insert in AR_LOCATION_ACCOUNTS only if the TAX_ACCOUNT_CCID is not null
260: we could have the segment qualifier without TAX_ACCOUNT in which case no
261: records should be inserted in to this table though we will have to insert
262: into AR_LOCATION_VALUES_OLD
263: +-----------------------------------------------------------------------------------*/

Line 268: arp_util_tax.debug(' Before inserting into AR_LOCATION_ACCOUNTS ');

264:
265:
266: if X_TAX_ACCOUNT_CCID is not null then
267: IF PG_DEBUG = 'Y' THEN
268: arp_util_tax.debug(' Before inserting into AR_LOCATION_ACCOUNTS ');
269: END IF;
270: insert into AR_LOCATION_ACCOUNTS_ALL (
271: LOCATION_VALUE_ACCOUNT_ID,
272: LOCATION_SEGMENT_ID,

Line 270: insert into AR_LOCATION_ACCOUNTS_ALL (

266: if X_TAX_ACCOUNT_CCID is not null then
267: IF PG_DEBUG = 'Y' THEN
268: arp_util_tax.debug(' Before inserting into AR_LOCATION_ACCOUNTS ');
269: END IF;
270: insert into AR_LOCATION_ACCOUNTS_ALL (
271: LOCATION_VALUE_ACCOUNT_ID,
272: LOCATION_SEGMENT_ID,
273: TAX_ACCOUNT_CCID,
274: INTERIM_TAX_CCID,

Line 318: arp_util_tax.debug(' After inserting into AR_LOCATION_ACCOUNTS ');

314: X_PROGRAM_ID,
315: X_PROGRAM_UPDATE_DATE,
316: X_ORG_ID);
317: IF PG_DEBUG = 'Y' THEN
318: arp_util_tax.debug(' After inserting into AR_LOCATION_ACCOUNTS ');
319: END IF;
320:
321: org_id_tab.delete;
322: loc_structure_id_tab.delete;

Line 353: | We insert new records in AR_LOCATION_ACCOUNTS_ALL table |

349: org_id_tab, loc_structure_id_tab;
350: close organization_id_c ;
351:
352: /*-------------------------------------------------------------------------+
353: | We insert new records in AR_LOCATION_ACCOUNTS_ALL table |
354: | One record is created for each ORG_ID |
355: | so that Accounting information in this table is Organization |
356: | independent and so that location structure can be shared across |
357: | Organizations. |

Line 361: -- Insert records into ar_location_accounts_all

357: | Organizations. |
358: +-------------------------------------------------------------------------*/
359:
360:
361: -- Insert records into ar_location_accounts_all
362: for I in 1..org_id_tab.last loop
363:
364: location_tax_account := NULL;
365: l_INTERIM_TAX_CCID := NULL;

Line 394: OPEN ar_location_accounts_s_c;

390: end if;
391: CLOSE ar_location_tax_account_c;
392:
393:
394: OPEN ar_location_accounts_s_c;
395: FETCH ar_location_accounts_s_c into
396: l_location_value_account_id;
397: CLOSE ar_location_accounts_s_c;
398:

Line 395: FETCH ar_location_accounts_s_c into

391: CLOSE ar_location_tax_account_c;
392:
393:
394: OPEN ar_location_accounts_s_c;
395: FETCH ar_location_accounts_s_c into
396: l_location_value_account_id;
397: CLOSE ar_location_accounts_s_c;
398:
399: location_account_id_tab(i) := l_location_value_account_id;

Line 397: CLOSE ar_location_accounts_s_c;

393:
394: OPEN ar_location_accounts_s_c;
395: FETCH ar_location_accounts_s_c into
396: l_location_value_account_id;
397: CLOSE ar_location_accounts_s_c;
398:
399: location_account_id_tab(i) := l_location_value_account_id;
400: location_segment_id_tab(i) := x_location_segment_id;
401: tax_account_ccid_tab(i) := location_tax_account;

Line 429: arp_util_tax.debug('Before inserting into AR_LOCATION_ACCOUNTS ('||to_char(organization_id_tab(i))||')' );

425:
426: if organization_id_tab(i) <> X_ORG_ID then
427:
428: IF PG_DEBUG = 'Y' THEN
429: arp_util_tax.debug('Before inserting into AR_LOCATION_ACCOUNTS ('||to_char(organization_id_tab(i))||')' );
430: END IF;
431: insert into ar_location_accounts_all
432: ( location_value_account_id,
433: location_segment_id,

Line 431: insert into ar_location_accounts_all

427:
428: IF PG_DEBUG = 'Y' THEN
429: arp_util_tax.debug('Before inserting into AR_LOCATION_ACCOUNTS ('||to_char(organization_id_tab(i))||')' );
430: END IF;
431: insert into ar_location_accounts_all
432: ( location_value_account_id,
433: location_segment_id,
434: tax_account_ccid,
435: interim_tax_ccid,

Line 478: arp_util_tax.debug('After inserting into AR_LOCATION_ACCOUNTS ');

474: program_update_date_tab(i),
475: last_update_login_tab(i),
476: organization_id_tab(i) );
477: IF PG_DEBUG = 'Y' THEN
478: arp_util_tax.debug('After inserting into AR_LOCATION_ACCOUNTS ');
479: END IF;
480: end if;
481: end loop;
482: end if;

Line 611: FROM AR_LOCATION_ACCOUNTS

607: REQUEST_ID,
608: PROGRAM_APPLICATION_ID,
609: PROGRAM_ID,
610: PROGRAM_UPDATE_DATE
611: FROM AR_LOCATION_ACCOUNTS
612: WHERE LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID
613: FOR UPDATE OF LOCATION_VALUE_ACCOUNT_ID NOWAIT;
614:
615: acctinfo c1%rowtype;

Line 691: -- in AR_LOCATION_ACCOUNTS only for one out of State/County/CITY

687: if (c1%notfound) then
688: close c1;
689: -- fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
690: -- Bugfix 1712826: Do not raise exception, because there will be a row
691: -- in AR_LOCATION_ACCOUNTS only for one out of State/County/CITY
692: -- app_exception.raise_exception;
693: IF PG_DEBUG = 'Y' THEN
694: arp_util_tax.debug(' No record found for AR_LOCATION_ACCOUNTS ');
695: END IF;

Line 694: arp_util_tax.debug(' No record found for AR_LOCATION_ACCOUNTS ');

690: -- Bugfix 1712826: Do not raise exception, because there will be a row
691: -- in AR_LOCATION_ACCOUNTS only for one out of State/County/CITY
692: -- app_exception.raise_exception;
693: IF PG_DEBUG = 'Y' THEN
694: arp_util_tax.debug(' No record found for AR_LOCATION_ACCOUNTS ');
695: END IF;
696: else
697: close c1;
698: if ( (acctinfo.LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID)

Line 854: arp_util_tax.debug(' Before updating AR_LOCATION_ACCOUNTS ');

850: end if;
851: */
852: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
853: IF PG_DEBUG = 'Y' THEN
854: arp_util_tax.debug(' Before updating AR_LOCATION_ACCOUNTS ');
855: END IF;
856: UPDATE AR_LOCATION_ACCOUNTS_ALL set
857: LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID,
858: LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID,

Line 856: UPDATE AR_LOCATION_ACCOUNTS_ALL set

852: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
853: IF PG_DEBUG = 'Y' THEN
854: arp_util_tax.debug(' Before updating AR_LOCATION_ACCOUNTS ');
855: END IF;
856: UPDATE AR_LOCATION_ACCOUNTS_ALL set
857: LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID,
858: LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID,
859: TAX_ACCOUNT_CCID = X_TAX_ACCOUNT_CCID,
860: INTERIM_TAX_CCID = X_INTERIM_TAX_CCID,

Line 882: arp_util_tax.debug(' After updating AR_LOCATION_ACCOUNTS ');

878: PROGRAM_UPDATE_DATE = X_PROGRAM_UPDATE_DATE
879: WHERE LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;
880:
881: IF PG_DEBUG = 'Y' THEN
882: arp_util_tax.debug(' After updating AR_LOCATION_ACCOUNTS ');
883: END IF;
884: end if;
885: /*
886: if (sql%notfound) then

Line 888: arp_util_tax.debug('updating AR_LOCATION_ACCOUNTS: No Data Found!! ');

884: end if;
885: /*
886: if (sql%notfound) then
887: IF PG_DEBUG = 'Y' THEN
888: arp_util_tax.debug('updating AR_LOCATION_ACCOUNTS: No Data Found!! ');
889: END IF;
890: raise no_data_found;
891: end if;
892: */

Line 910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');

906: arp_util_tax.debug(' AR_LOCVS_PKG.delete_row(+) ');
907: END IF;
908: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
909: IF PG_DEBUG = 'Y' THEN
910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');
911: END IF;
912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL
913: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
914: AND LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;

Line 912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL

908: if X_LOCATION_VALUE_ACCOUNT_ID is not null then
909: IF PG_DEBUG = 'Y' THEN
910: arp_util_tax.debug(' Before deleting AR_LOCATION_ACCOUNTS ');
911: END IF;
912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL
913: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
914: AND LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;
915: IF PG_DEBUG = 'Y' THEN
916: arp_util_tax.debug(' After deleting AR_LOCATION_ACCOUNTS ');

Line 916: arp_util_tax.debug(' After deleting AR_LOCATION_ACCOUNTS ');

912: DELETE FROM AR_LOCATION_ACCOUNTS_ALL
913: WHERE LOCATION_SEGMENT_ID = X_LOCATION_SEGMENT_ID
914: AND LOCATION_VALUE_ACCOUNT_ID = X_LOCATION_VALUE_ACCOUNT_ID;
915: IF PG_DEBUG = 'Y' THEN
916: arp_util_tax.debug(' After deleting AR_LOCATION_ACCOUNTS ');
917: END IF;
918: end if;
919:
920: if (sql%notfound) then