103: RETURN;
104: ELSE
105: SELECT DISTINCT PARTY_ID, PARTY_TYPE
106: INTO party_id, party_type
107: FROM ECX_TP_HEADERS
108: WHERE PARTY_SITE_ID = l_party_site_id;
109:
110: IF SQL%NOTFOUND THEN
111: RETURN;
763: RETURN;
764: ELSE
765: SELECT DISTINCT PARTY_ID, PARTY_TYPE
766: INTO l_party_id, l_party_type
767: FROM ECX_TP_HEADERS
768: WHERE PARTY_SITE_ID = l_party_site_id;
769:
770: IF SQL%NOTFOUND THEN
771: --gmi_reservation_util.println('PAL ECX_TP_HEADERS - SQL%NOTFOUND ');
767: FROM ECX_TP_HEADERS
768: WHERE PARTY_SITE_ID = l_party_site_id;
769:
770: IF SQL%NOTFOUND THEN
771: --gmi_reservation_util.println('PAL ECX_TP_HEADERS - SQL%NOTFOUND ');
772:
773:
774: RETURN;
775: END IF;