APPS.GMD_QMSMC dependencies on AME_UTIL

Line 25: Approver AME_UTIL.APPROVERRECORD;

21:
22: l_application_id number;
23: l_transaction_type varchar2(100);
24: l_user varchar2(32);
25: Approver AME_UTIL.APPROVERRECORD;
26: l_inventory_item_id number;
27: l_item_number varchar2(240);
28: l_item_desc varchar2(240);
29: l_lot_number varchar2(240);

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

1796:
1797: CLOSE get_user_name;
1798:
1799: ELSE
1800: OPEN get_user_name(ame_util.personidtouserid(approver.person_id)); /* 4576699 */
1801: FETCH get_user_name
1802: INTO l_user;
1803:
1804: IF (get_user_name%NOTFOUND) THEN

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

1986: aname => 'LOT_UOM2',
1987: avalue => l_trans_qty_uom2);
1988:
1989: /* As this a pure FYI notification we will set the approver to approve status */
1990: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
1991: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1992: transactionIdIn => l_event_key,
1993: approverIn => Approver,
1994: transactionTypeIn => l_transaction_type,

Line 1995: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

1991: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
1992: transactionIdIn => l_event_key,
1993: approverIn => Approver,
1994: transactionTypeIn => l_transaction_type,
1995: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
1996: END IF;
1997:
1998: P_resultout := 'COMPLETE:' || l_transaction_type;
1999:

Line 2040: Approver AME_UTIL.APPROVERRECORD;

2036: l_transaction_type varchar2(100) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2037: itemkey => P_itemkey,
2038: aname => 'AME_TRANS');
2039: l_user varchar2(32);
2040: Approver AME_UTIL.APPROVERRECORD;
2041: l_ITEM_NUMBER varchar2(240);
2042: l_item_desc varchar2(240);
2043: l_lot_number varchar2(240);
2044: l_parent_lot_number varchar2(240);

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

2105: ELSE
2106: select user_name
2107: into l_user
2108: from fnd_user
2109: where user_id = AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
2110: END IF;
2111:
2112: /* Set the User Attribute */
2113:

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

2116: aname => 'CURRENT_APPROVER',
2117: avalue => l_user);
2118:
2119: P_resultout := 'COMPLETE:Y';
2120: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
2121: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
2122: transactionIdIn => l_event_key,
2123: approverIn => Approver,
2124: transactionTypeIn => l_transaction_type,

Line 2125: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

2121: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
2122: transactionIdIn => l_event_key,
2123: approverIn => Approver,
2124: transactionTypeIn => l_transaction_type,
2125: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
2126: END IF;
2127:
2128: EXCEPTION
2129: WHEN OTHERS THEN

Line 2155: Approver AME_UTIL.APPROVERRECORD;

2151: l_event_key varchar2(240) := WF_ENGINE.GETITEMATTRTEXT(itemtype => p_itemtype,
2152: itemkey => P_itemkey,
2153: aname => 'EVENT_KEY');
2154:
2155: Approver AME_UTIL.APPROVERRECORD;
2156: L_WIP_SPEC GMD_SPEC_MATCH_GRP.WIP_SPEC_REC_TYPE;
2157: L_SAMPLING_EVENTS GMD_SAMPLING_EVENTS%ROWTYPE;
2158: l_sampling_events_out GMD_SAMPLING_EVENTS%ROWTYPE;
2159: l_event_spec_disp GMD_EVENT_SPEC_DISP%ROWTYPE;

Line 3010: AME_UTIL.PERSONIDTOUSERID(Approver.person_id);

3006: select user_name
3007: into l_user
3008: from fnd_user
3009: where user_id =
3010: AME_UTIL.PERSONIDTOUSERID(Approver.person_id);
3011: END IF;
3012:
3013: IF (l_debug = 'Y') THEN
3014: gmd_debug.put_line('Approver Found ');

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

3141: /* Bug #4576699 Moved this code before WF_ENGINE.STARTPROCESS so that
3142: CHECK_NEXT_APPROVER doesn't fetch records from the first approver to whom
3143: a notification is already sent */
3144:
3145: Approver.approval_status := AME_UTIL.APPROVEDSTATUS;
3146: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
3147: transactionIdIn => l_event_key,
3148: approverIn => Approver,
3149: transactionTypeIn => l_transaction_type,

Line 3150: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);

3146: AME_API.UPDATEAPPROVALSTATUS(applicationIdIn => l_application_id,
3147: transactionIdIn => l_event_key,
3148: approverIn => Approver,
3149: transactionTypeIn => l_transaction_type,
3150: forwardeeIn => AME_UTIL.EMPTYAPPROVERRECORD);
3151:
3152: /* start the Workflow process */
3153: --WF_LOG_PKG.STRING(6, 'Dummy','Starting Process');
3154: WF_ENGINE.STARTPROCESS(itemtype => l_itemtype,