DBA Data[Home] [Help]

APPS.GMD_QMSED dependencies on AME_UTIL

Line 30: Approver ame_util.approverRecord;

26:
27: l_application_id number;
28: l_transaction_type varchar2(100);
29: l_user varchar2(32);
30: Approver ame_util.approverRecord;
31: l_item_no varchar2(240);
32: l_item_desc varchar2(240);
33: l_lot_no varchar2(240);
34: l_sample_no varchar2(240);

Line 403: where user_id=ame_util.personidtouserid (approver.person_id);

399: and exists (select 1 from per_all_people where person_id = Approver.person_id);*/
400:
401: -- RLNAGARA B5714223 Replaced the above query with the below query.
402: select user_name into l_user from fnd_user
403: where user_id=ame_util.personidtouserid (approver.person_id);
404:
405: end if;
406:
407: /* Set the User Attribute */

Line 474: Approver.approval_status := ame_util.approvedStatus;

470: avalue =>l_transaction_type );
471:
472: P_resultout:='COMPLETE:'||l_transaction_type;
473: /* As this a pure FYI notification we will set the approer to approve status */
474: Approver.approval_status := ame_util.approvedStatus;
475: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
476: transactionIdIn => l_event_key,
477: approverIn => Approver,
478: transactionTypeIn => l_transaction_type,

Line 479: forwardeeIn => ame_util.emptyApproverRecord);

475: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
476: transactionIdIn => l_event_key,
477: approverIn => Approver,
478: transactionTypeIn => l_transaction_type,
479: forwardeeIn => ame_util.emptyApproverRecord);
480:
481:
482: EXCEPTION
483: WHEN OTHERS THEN

Line 515: Approver ame_util.approverRecord;

511: itemtype=>p_itemtype,
512: itemkey=>P_itemkey,
513: aname=>'AME_TRANS');
514: l_user varchar2(32);
515: Approver ame_util.approverRecord;
516: l_item_no varchar2(240);
517: l_item_desc varchar2(240);
518: l_lot_no varchar2(240);
519: l_sublot_no varchar2(240);

Line 568: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);

564:
565: --Rewritten the above query as part of fix Bug No.7656325
566:
567: select user_name into l_user from fnd_user
568: where user_id=ame_util.PERSONIDTOUSERID(Approver.person_id);
569:
570: end if;
571:
572: /* Set the User Attribute */

Line 578: Approver.approval_status := ame_util.approvedStatus;

574: WF_ENGINE.SETITEMATTRTEXT(itemtype => p_itemtype,itemkey => p_itemkey,
575: aname => 'CURRENT_APPROVER',
576: avalue => l_user);
577: P_resultout:='COMPLETE:Y';
578: Approver.approval_status := ame_util.approvedStatus;
579: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
580: transactionIdIn => l_event_key,
581: approverIn => Approver,
582: transactionTypeIn => l_transaction_type,

Line 583: forwardeeIn => ame_util.emptyApproverRecord);

579: ame_api.updateApprovalStatus(applicationIdIn => l_application_id,
580: transactionIdIn => l_event_key,
581: approverIn => Approver,
582: transactionTypeIn => l_transaction_type,
583: forwardeeIn => ame_util.emptyApproverRecord);
584: end if;
585: EXCEPTION
586: WHEN OTHERS THEN
587: WF_CORE.CONTEXT ('GMD_QMSED','CHECK_NEXT_APPROVER',p_itemtype,p_itemkey,'Initial' );