262: select application_id into l_application_id
263: from fnd_application where application_short_name='GMD';
264:
265: /* Check which event has been raised */
266: wf_log_pkg.string(6, 'Dummy','Entered UOM Conversion with event_key '||l_event_key);
267:
268: /* Check each UOM conversion which is recommended to send a notification */
269: OPEN C1;
270: LOOP
267:
268: /* Check each UOM conversion which is recommended to send a notification */
269: OPEN C1;
270: LOOP
271: wf_log_pkg.string(6, 'Dummy','Before Fetching the values. Inside the Loop');
272:
273:
274: IF (l_debug = 'Y') THEN
275: gmd_debug.put_line('Getting data from cursors ');
384: ame_api.clearAllApprovals(applicationIdIn => l_application_id,
385: transactionIdIn => l_event_key,
386: transactionTypeIn => l_transaction_type);
387:
388: wf_log_pkg.string(6, 'Dummy','Approvers Cleared');
389: ame_api.getNextApprover(applicationIdIn => l_application_id,
390: transactionIdIn => l_event_key,
391: transactionTypeIn => l_transaction_type,
392: nextApproverOut => Approver);
554: aname => 'AME_TRANS',
555: avalue =>l_transaction_type);
556:
557:
558: wf_log_pkg.string(6, 'Dummy','Setting Parent');
559:
560:
561: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
562: parent_itemtype => p_itemtype,
563: parent_itemkey=> p_itemkey,
564: parent_context=> NULL);
565:
566: /* start the Workflow process */
567: wf_log_pkg.string(6, 'Dummy','Starting Process');
568:
569: /* As this a pure FYI notification we will set the approver to approve status */
570: Approver.approval_status := ame_util.approvedStatus;
571: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
717: aname => 'AME_TRANS',
718: avalue =>l_transaction_type);
719:
720:
721: wf_log_pkg.string(6, 'Dummy','Setting Parent');
722:
723:
724: WF_ENGINE.SETITEMPARENT(itemtype =>l_itemtype,itemkey =>l_itemkey,
725: parent_itemtype => p_itemtype,
726: parent_itemkey=> p_itemkey,
727: parent_context=> NULL);
728:
729: /* start the Workflow process */
730: wf_log_pkg.string(6, 'Dummy','Starting Process');
731:
732: /* As this a pure FYI notification we will set the approver to approve status */
733: Approver.approval_status := ame_util.approvedStatus;
734: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,