Line 50: SELECT fun_net_agreements_s.NEXTVAL INTO l_agreement_id FROM DUAL;
46: l_agreement_id fun_net_agreements_all.agreement_id%TYPE;
47: BEGIN
48:
49: IF x_agreement_id IS NULL THEN 50: SELECT fun_net_agreements_s.NEXTVAL INTO l_agreement_id FROM DUAL; 51: x_agreement_id := l_agreement_id;
52: ELSE
53: l_agreement_id := x_agreement_id;
54: END IF;