APPS.JAI_PO_V_TRIGGER_PKG dependencies on JAI_CMN_VENDOR_SITES

Line 70: UPDATE JAI_CMN_VENDOR_SITES

66: -- return;
67: -- end if;
68:
69: IF pr_old.end_date_active IS NULL AND pr_new.end_date_active IS NOT NULL THEN
70: UPDATE JAI_CMN_VENDOR_SITES
71: SET inactive_flag = 'Y'
72: WHERE vendor_id = pr_new.vendor_id
73: AND vendor_site_id = 0 ;
74: ELSIF pr_old.end_date_active IS NOT NULL AND pr_new.end_date_active IS NULL THEN

Line 75: UPDATE JAI_CMN_VENDOR_SITES

71: SET inactive_flag = 'Y'
72: WHERE vendor_id = pr_new.vendor_id
73: AND vendor_site_id = 0 ;
74: ELSIF pr_old.end_date_active IS NOT NULL AND pr_new.end_date_active IS NULL THEN
75: UPDATE JAI_CMN_VENDOR_SITES
76: SET inactive_flag = ''
77: WHERE vendor_id = pr_new.vendor_id
78: AND vendor_site_id = 0 ;
79: END IF;