160:
161: FUNCTION getSitesEnabledFlagForContract(p_header_id in number) RETURN VARCHAR2 IS
162:
163: CURSOR C IS SELECT enable_all_sites
164: FROM po_headers_all WHERE po_header_id = p_header_id;
165: l_enable_all_sites PO_HEADERS_ALL.ENABLE_ALL_SITES%TYPE;
166:
167: BEGIN
168: OPEN C;
161: FUNCTION getSitesEnabledFlagForContract(p_header_id in number) RETURN VARCHAR2 IS
162:
163: CURSOR C IS SELECT enable_all_sites
164: FROM po_headers_all WHERE po_header_id = p_header_id;
165: l_enable_all_sites PO_HEADERS_ALL.ENABLE_ALL_SITES%TYPE;
166:
167: BEGIN
168: OPEN C;
169: LOOP