APPS.JAI_PA_SETUP_DEF_PKG dependencies on JAI_PA_SETUP_VALUES

Line 11: from jai_pa_setup_values

7: is
8: cursor c_get_pa_count
9: is
10: select count(setup_value_id)
11: from jai_pa_setup_values
12: where org_id is not null;
13: l_count number;
14: begin
15: fnd_file.put_line(fnd_file.log, 'Updating org_id for existing setup');

Line 20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');

16: open c_get_pa_count;
17: fetch c_get_pa_count into l_count;
18: close c_get_pa_count;
19: if l_count > 0 then
20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');
21: fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');
22: return;
23: else
24: update jai_pa_setup_values

Line 24: update jai_pa_setup_values

20: fnd_file.put_line(fnd_file.log, 'Records exist in jai_pa_setup_values with org_id');
21: fnd_file.put_line(fnd_file.log, 'Cannot update. Exiting...');
22: return;
23: else
24: update jai_pa_setup_values
25: set org_id = p_org_id
26: where org_id is null;
27: fnd_file.put_line(fnd_file.log, 'Updated existing records with org_id...');
28: end if;