68:
69: IF ( X_AGREEMENT_TEMPLATE_ID IS NULL) THEN
70: Select PN_VAR_TEMPLATES_S.nextval
71: into X_AGREEMENT_TEMPLATE_ID
72: FROM DUAL;
73: END IF;
74:
75: insert into PN_VAR_TEMPLATES_ALL (
76: AGREEMENT_TEMPLATE_ID,
682: l_dummy NUMBER;
683: BEGIN
684: SELECT 1
685: INTO l_dummy
686: FROM DUAL
687: WHERE NOT EXISTS (SELECT 1
688: FROM pn_var_templates_all
689: WHERE agreement_template = x_name
690: AND ((x_template_id IS NULL)