115: BEGIN
116:
117:
118: IF (l_debug = 'Y') THEN
119: gmd_debug.log_initialize('StabStudyLot');
120: gmd_debug.put_line('Event Name ' || l_event_name );
121: gmd_debug.put_line('Event Key ' || l_event_key );
122:
123: END IF;
116:
117:
118: IF (l_debug = 'Y') THEN
119: gmd_debug.log_initialize('StabStudyLot');
120: gmd_debug.put_line('Event Name ' || l_event_name );
121: gmd_debug.put_line('Event Key ' || l_event_key );
122:
123: END IF;
124:
117:
118: IF (l_debug = 'Y') THEN
119: gmd_debug.log_initialize('StabStudyLot');
120: gmd_debug.put_line('Event Name ' || l_event_name );
121: gmd_debug.put_line('Event Key ' || l_event_key );
122:
123: END IF;
124:
125: open get_from_role ;
154: ||l_lot_no||'" REVISION="'||l_item_revision||'" SAMPLE_TYPE="I" SOURCE="I"';
155:
156:
157: IF (l_debug = 'Y') THEN
158: gmd_debug.put_line('Checking on approvers ');
159: END IF;
160:
161: /* Start the Workflow for the Given Combination */
162: ame_api.clearAllApprovals(applicationIdIn => l_application_id,
188: end if;
189: end if ;
190:
191: IF (l_debug = 'Y') THEN
192: gmd_debug.put_line('Approver ' || l_user);
193: END IF;
194:
195:
196: l_itemtype:='GMDQSLOT';
198:
199: l_workflow_process:='GMDQSLOT_SUB_PROCESS';
200:
201: IF (l_debug = 'Y') THEN
202: gmd_debug.put_line('Going to set workflow attributes ');
203: END IF;
204:
205: WF_ENGINE.CREATEPROCESS (itemtype => l_itemtype,
206: itemkey => l_itemkey,
279: /* start the Workflow process */
280: wf_log_pkg.string(6, 'Dummy','Starting Process');
281:
282: IF (l_debug = 'Y') THEN
283: gmd_debug.put_line('Completed workflow attributes ');
284: END IF;
285:
286:
287:
299:
300: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);
301:
302: IF (l_debug = 'Y') THEN
303: gmd_debug.put_line('Created workflow process ');
304: END IF;
305:
306:
307: close C1;