87:
88:
89: FUNCTION Scope_Update
90: ( p_subscription_guid in raw,
91: p_event in out NOCOPY wf_event_t
92: ) return VARCHAR2
93: IS
94: CURSOR c_new_org(c_cert_id NUMBER) IS
95: SELECT organization_id
224:
225:
226: FUNCTION Evaluation_Update
227: ( p_subscription_guid in raw,
228: p_event in out NOCOPY wf_event_t
229: ) return VARCHAR2
230: IS
231: CURSOR c_opinion_rec (c_opinion_log_id NUMBER) IS
232: SELECT opinion_id, object_name, audit_result_code,
1226: END Evaluation_Update;
1227:
1228: FUNCTION Certification_Update
1229: ( p_subscription_guid in raw,
1230: p_event in out NOCOPY wf_event_t
1231: ) return VARCHAR2
1232: IS
1233: CURSOR c_opinion_rec (c_opinion_log_id NUMBER) IS
1234: SELECT opinion_id, object_name, audit_result_code,