1735: END;
1736: IF(p_party_site_id IS NOT NULL) THEN
1737: SELECT status
1738: INTO l_party_site_status
1739: FROM HZ_PARTY_SITES
1740: WHERE party_site_id = p_party_site_id;
1741:
1742: IF l_party_site_status = 'I' THEN
1743: RAISE L_INVALID_PARTY_SITE;
1758: l_rec.Org_Type:=NULL;
1759: BEGIN
1760: SELECT status
1761: INTO l_party_site_status
1762: FROM HZ_PARTY_SITES
1763: WHERE party_site_id = p_party_site_id;
1764: EXCEPTION
1765: WHEN OTHERS THEN
1766: RAISE L_INVALID_PARTY_SITE;