APPS.AR_LOCVS_PKG dependencies on AR_LOCATION_ACCOUNTS_ALL

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 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 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 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 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 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 ');