132:
133: BEGIN
134:
135: IF (l_debug = 'Y') THEN
136: gmd_debug.log_initialize('Timepoint');
137: END IF;
138:
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line('Event Name ' || l_event_name);
136: gmd_debug.log_initialize('Timepoint');
137: END IF;
138:
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line('Event Name ' || l_event_name);
141: gmd_debug.put_line('Event Key ' || l_event_key);
142: END IF;
143:
144: open get_from_role ;
137: END IF;
138:
139: IF (l_debug = 'Y') THEN
140: gmd_debug.put_line('Event Name ' || l_event_name);
141: gmd_debug.put_line('Event Key ' || l_event_key);
142: END IF;
143:
144: open get_from_role ;
145: fetch get_from_role into l_from_role ;
178: l_form := 'GMDQSAMPLES_F:SAMPLING_EVENT_ID="'||l_sample_event_id||'"';
179:
180: /* Start the Workflow for the Given Combination */
181: IF (l_debug = 'Y') THEN
182: gmd_debug.put_line('Getting AME approver');
183: END IF;
184:
185: ame_api.clearAllApprovals(applicationIdIn => l_application_id,
186: transactionIdIn => l_event_key,
211: end if;
212:
213:
214: IF (l_debug = 'Y') THEN
215: gmd_debug.put_line('AME approver ' || l_user);
216: END IF;
217:
218: l_itemtype:='GMDQSTST';
219: l_itemkey:=l_event_key||'-'||to_char(sysdate,'dd/mm/yy hh:mi:ss');
309: /* start the Workflow process */
310: wf_log_pkg.string(6, 'Dummy','Starting Process');
311:
312: IF (l_debug = 'Y') THEN
313: gmd_debug.put_line('Finished Workflow atributes');
314: END IF;
315:
316:
317: /* As this a pure FYI notification we will set the approver to approve status */