APPS.GMD_QMSMC dependencies on AME_UTIL

Line 29: Approver AME_UTIL.APPROVERRECORD;

25:
26: l_application_id number;
27: l_transaction_type varchar2(100);
28: l_user varchar2(32);
29: Approver AME_UTIL.APPROVERRECORD;
30: l_inventory_item_id number;
31: l_item_number varchar2(240);
32: l_item_desc varchar2(240);
33: l_lot_number varchar2(240);

Line 1616: OPEN get_user_name (ame_util.personidtouserid (approver.person_id)); /* 4576699 */

1612:
1613: CLOSE get_user_name;
1614:
1615: ELSE
1616: OPEN get_user_name (ame_util.personidtouserid (approver.person_id)); /* 4576699 */
1617: FETCH get_user_name INTO l_user;
1618:
1619: IF (get_user_name%NOTFOUND)
1620: THEN

Line 1760: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;

1756:
1757:
1758:
1759: /* As this a pure FYI notification we will set the approver to approve status */
1760: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
1761: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1762: transactionIdIn => l_event_key,
1763: approverIn => Approver,
1764: transactionTypeIn => l_transaction_type,

Line 1765: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

1761: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1762: transactionIdIn => l_event_key,
1763: approverIn => Approver,
1764: transactionTypeIn => l_transaction_type,
1765: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
1766: END IF;
1767:
1768: P_resultout:='COMPLETE:'||l_transaction_type;
1769:

Line 1820: Approver AME_UTIL.APPROVERRECORD;

1816: itemtype=>p_itemtype,
1817: itemkey=>P_itemkey,
1818: aname=>'AME_TRANS');
1819: l_user varchar2(32);
1820: Approver AME_UTIL.APPROVERRECORD;
1821: l_ITEM_NUMBER varchar2(240);
1822: l_item_desc varchar2(240);
1823: l_lot_number varchar2(240);
1824: l_parent_lot_number varchar2(240);

Line 1858: user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);

1854: where user_id=Approver.user_id;
1855: ELSE
1856: select user_name into l_user from fnd_user
1857: where
1858: user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
1859: END IF;
1860:
1861:
1862: /* Set the User Attribute */

Line 1869: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;

1865: aname => 'CURRENT_APPROVER',
1866: avalue => l_user);
1867:
1868: P_resultout:='COMPLETE:Y';
1869: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
1870: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1871: transactionIdIn => l_event_key,
1872: approverIn => Approver,
1873: transactionTypeIn => l_transaction_type,

Line 1874: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

1870: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1871: transactionIdIn => l_event_key,
1872: approverIn => Approver,
1873: transactionTypeIn => l_transaction_type,
1874: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
1875: END IF;
1876:
1877: EXCEPTION
1878: WHEN OTHERS THEN

Line 1902: Approver AME_UTIL.APPROVERRECORD;

1898: l_event_key varchar2(240):=WF_ENGINE.GETITEMATTRTEXT( itemtype => p_itemtype,
1899: itemkey => P_itemkey,
1900: aname => 'EVENT_KEY');
1901:
1902: Approver AME_UTIL.APPROVERRECORD;
1903: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
1904: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
1905: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
1906: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 2635: where user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);

2631: ELSE
2632: select user_name
2633: into l_user
2634: from fnd_user
2635: where user_id=AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
2636: END IF;
2637:
2638: IF (l_debug = 'Y') THEN
2639: gmd_debug.put_line('Approver Found ');

Line 2751: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;

2747: /* Bug #4576699 Moved this code before WF_ENGINE.STARTPROCESS so that
2748: CHECK_NEXT_APPROVER doesn't fetch records from the first approver to whom
2749: a notification is already sent */
2750:
2751: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
2752: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
2753: transactionIdIn => l_event_key,
2754: approverIn => Approver,
2755: transactionTypeIn => l_transaction_type,

Line 2756: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

2752: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
2753: transactionIdIn => l_event_key,
2754: approverIn => Approver,
2755: transactionTypeIn => l_transaction_type,
2756: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
2757:
2758: /* start the Workflow process */
2759: --WF_LOG_PKG.STRING(6, 'Dummy','Starting Process');
2760: WF_ENGINE.STARTPROCESS (itemtype => l_itemtype,itemkey => l_itemkey);