APPS.ARP_TAX_RATE_UPD dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 50: -- Check the value in ar_system_parameters_all table and determine the work otherwise EXIT

46: if l_num_workers is null then
47: l_num_workers :=4;
48: end if;
49:
50: -- Check the value in ar_system_parameters_all table and determine the work otherwise EXIT
51: BEGIN
52: select count(*) into ln_cnt from ar_system_parameters_all
53: where TAX_DATABASE_VIEW_SET in ('_V','_A')
54: and nvl(global_attribute17,'XXXXXX') not in ('EFF_RATE_ENH','EFF_RATE_RUN');

Line 52: select count(*) into ln_cnt from ar_system_parameters_all

48: end if;
49:
50: -- Check the value in ar_system_parameters_all table and determine the work otherwise EXIT
51: BEGIN
52: select count(*) into ln_cnt from ar_system_parameters_all
53: where TAX_DATABASE_VIEW_SET in ('_V','_A')
54: and nvl(global_attribute17,'XXXXXX') not in ('EFF_RATE_ENH','EFF_RATE_RUN');
55: fnd_file.put_line( fnd_file.log,'Running Tax Rate update program in '||ln_cnt|| ' operating units.');
56: EXCEPTION

Line 75: update ar_system_parameters_all p

71: enabled => 'N');
72: END IF;
73: -- Mark the global_attribute17 that the Program is running...
74: BEGIN
75: update ar_system_parameters_all p
76: set global_attribute17='EFF_RATE_RUN'
77: where TAX_DATABASE_VIEW_SET in ('_V','_A');
78: EXCEPTION
79: when others then

Line 149: --Update the global_attribute17 of ar_system_parameters_all table

145:
146: COMMIT;
147:
148: END LOOP ; /* end of WHILE loop */
149: --Update the global_attribute17 of ar_system_parameters_all table
150: begin
151: update ar_system_parameters_all set global_attribute17='EFF_RATE_ENH'
152: where TAX_DATABASE_VIEW_SET in ('_V','_A')
153: and global_attribute17 = 'EFF_RATE_RUN';

Line 151: update ar_system_parameters_all set global_attribute17='EFF_RATE_ENH'

147:
148: END LOOP ; /* end of WHILE loop */
149: --Update the global_attribute17 of ar_system_parameters_all table
150: begin
151: update ar_system_parameters_all set global_attribute17='EFF_RATE_ENH'
152: where TAX_DATABASE_VIEW_SET in ('_V','_A')
153: and global_attribute17 = 'EFF_RATE_RUN';
154: exception
155: when others then