85: -- RETURN;
86: -- END IF;
87:
88: IF pr_old.inactive_date IS NULL AND pr_new.inactive_date IS NOT NULL THEN
89: UPDATE JAI_CMN_VENDOR_SITES
90: SET inactive_flag = 'Y'
91: WHERE vendor_site_id = pr_new.vendor_site_id;
92: ELSIF pr_old.inactive_date IS NOT NULL AND pr_new.inactive_date IS NULL THEN
93: UPDATE JAI_CMN_VENDOR_SITES
89: UPDATE JAI_CMN_VENDOR_SITES
90: SET inactive_flag = 'Y'
91: WHERE vendor_site_id = pr_new.vendor_site_id;
92: ELSIF pr_old.inactive_date IS NOT NULL AND pr_new.inactive_date IS NULL THEN
93: UPDATE JAI_CMN_VENDOR_SITES
94: SET inactive_flag = ''
95: WHERE vendor_site_id = pr_new.vendor_site_id;
96: END IF;
97: END ARU_T1 ;