1023:
1024: -- API body
1025:
1026: -- delete existing association first
1027: DELETE FROM JTF_IH_RESULT_REASONS
1028: WHERE RESULT_ID = P_RESULT_ID AND REASON_ID = P_REASON_ID;
1029:
1030: if P_ACTION = 'ADD' then
1031: -- insert new association
1028: WHERE RESULT_ID = P_RESULT_ID AND REASON_ID = P_REASON_ID;
1029:
1030: if P_ACTION = 'ADD' then
1031: -- insert new association
1032: INSERT INTO JTF_IH_RESULT_REASONS
1033: (
1034: RESULT_ID,
1035: REASON_ID,
1036: OBJECT_VERSION_NUMBER,