APPS.SSP_SMP_RATE_UPLD dependencies on AD_ZD

Line 45: if ad_zd.get_edition('PATCH') is not null then

41:
42: /* When Patching is in progress goto sleep mode until patching is complete. */
43: loop
44: hr_utility.set_location(g_package||'Inside while loop',10);
45: if ad_zd.get_edition('PATCH') is not null then
46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);
49: end if;

Line 47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);

43: loop
44: hr_utility.set_location(g_package||'Inside while loop',10);
45: if ad_zd.get_edition('PATCH') is not null then
46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);
49: end if;
50: exit when ad_zd.get_edition('PATCH') is null;
51: end loop;

Line 50: exit when ad_zd.get_edition('PATCH') is null;

46: -- an online patch is in progress, goto sleep
47: hr_utility.set_location(g_package||'upd_abs_rates :AD_ZD'||ad_zd.get_edition('PATCH'),10);
48: dbms_lock.sleep(10);
49: end if;
50: exit when ad_zd.get_edition('PATCH') is null;
51: end loop;
52:
53: ssp_smp_support_pkg.update_ssp_smp_entries (p_update_error => l_ssp_update_error,p_job_err => l_job_err);
54: if l_ssp_update_error