[Home] [Help]
179: | |
180: | DESCRIPTION |
181: | Used to select distinct ORG_ID from AR_SYSTEM_PARAMETERS_ALL |
182: | to create one record per ORG_ID for a new location_id in |
183: | AR_LOCATION_ACCOUNTS_ALL |
184: | |
185: | REQUIRES |
186: | |
187: | RETURNS |
195: | |
196: +-------------------------------------------------------------------------*/
197:
198: -- Organization Ids -3113 and -3114 are seeded in ar_system_parameters
199: -- and we do not want to create records in ar_location_accounts_all table
200: -- for these org_id's. Hence we do not select them in the cursor.
201:
202: CURSOR organization_id_c is
203: select nvl(org_id, -99), location_structure_id
987: attribute13,
988: attribute14,
989: attribute15 );
990:
991: -- Insert accounting information into ar_location_accounts_all
992: -- One record will be inserted for each Org_id.
993:
994: ins_location_accounts
995: ( location_id,
1076: arp_util_tax.debug( '>> INS_LOCATION_ACCOUNTS( ' ||
1077: location_segment_qualifier ||', '||
1078: to_char(Location_segment_id)||' ) ');
1079: END IF;
1080: -- Records will be inserted into AR_LOCATION_ACCOUNTS_ALL only if
1081: -- the segment has qualifier 'Tax Account' enabled.
1082:
1083: if location_segment_qualifier = 'STATE'
1084: then
1114: fetch organization_id_c bulk collect into
1115: org_id_tab, loc_structure_id_tab;
1116: close organization_id_c ;
1117:
1118: -- Insert records into ar_location_accounts_all
1119: for I in 1..org_id_tab.last loop
1120:
1121: location_tax_account := NULL;
1122: l_INTERIM_TAX_CCID := NULL;
1180:
1181: end loop;
1182:
1183: forall I in 1.. organization_id_tab.last
1184: insert into ar_location_accounts_all
1185: ( location_value_account_id,
1186: location_segment_id,
1187: tax_account_ccid,
1188: interim_tax_ccid,