1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37
| FUNCTION ajouterresiliationcontact (
p_expuid IN resiliation_contact.expuid%TYPE,
p_id_civilite IN resiliation_contact.id_civilite%TYPE,
p_nom IN resiliation_contact.nom%TYPE,
p_prenom IN resiliation_contact.prenom%TYPE,
p_numero_telephone IN resiliation_contact.numero_telephone%TYPE,
p_id_choix_resiliation IN resiliation_contact.id_choix_resiliation%TYPE,
p_date_demande IN resiliation_contact.date_demande%TYPE,
p_type_date_appel IN resiliation_contact.type_date_appel%TYPE,
p_date_appel IN resiliation_contact.date_appel%TYPE,
p_jour_appel IN resiliation_contact.jour_appel%TYPE,
p_heure_appel IN resiliation_contact.heure_appel%TYPE
)
RETURN resiliation_contact.id_contact%TYPE
IS
l_id_contact resiliation_contact.id_contact%TYPE;
BEGIN
SELECT s_resil_contact.NEXTVAL
INTO l_id_contact
FROM DUAL;
INSERT INTO resiliation_contact
(id_contact, expuid, id_civilite, nom, prenom,
numero_telephone, id_choix_resiliation,
date_demande, type_date_appel, date_appel,
jour_appel, heure_appel
)
VALUES (l_id_contact, p_expuid, p_id_civilite, p_nom, p_prenom,
p_numero_telephone, p_id_choix_resiliation,
p_date_demande, p_type_date_appel, p_date_appel,
p_jour_appel, p_heure_appel
);
COMMIT;
RETURN l_id_contact;
END; |
Partager