[Home] [Help]
170: --Locks:
171: -- None.
172: --Function:
173: -- This procedure is built as a wrapper over procedure get_external_userlist
174: -- in the new group API po_vendors_grp.
175: -- This procedure is called by Contracts API to determine the supplier users
176: -- to send notifications to, when deliverables undergo a status change
177: -- (example: it is overdue).
178: --Parameters:
200: --x_supplier_userlist
201: -- PL/SQL table of supplier user names
202: --Notes:
203: -- SAHEGDE 07/18/2003
204: -- This procedure calls get_external_userlist in PO_VENDORS_GRP to
205: -- retrieve supplier user names as VARCHAR2 as well as PL/SQL table, besides
206: -- other OUT parameters. Going forward, signature of the get_external_userlist
207: -- might change to return only PL/SQL table. The callout then will need to
208: -- accomodate this change. This however will not change the GRP API signature.
251: -- parse the contracts document type to type lookup
252: l_document_type := SUBSTR(p_document_type, 1, 2);
253:
254:
255: po_vendors_grp.get_external_userlist
256: (p_api_version => 1.0 --bug4028805
257: ,p_document_id => p_document_id
258: ,p_document_type => l_document_type
259: ,p_external_contact_id => p_external_contact_id
301: --Locks:
302: -- None.
303: --Function:
304: -- This procedure is built as a wrapper over procedure get_external_userlist
305: -- in the new group API po_vendors_grp.
306: -- This procedure is called by Contracts team to determine the supplier users
307: -- to send notifications to, when deliverables undergo a status change
308: -- (example: it is overdue) and supplier user is not specified on the deliverable.
309: --Parameters:
381:
382: -- parse the contracts document type to type lookup
383: l_document_type := SUBSTR(p_document_type, 1, 2);
384:
385: PO_VENDORS_GRP.get_external_userlist
386: (p_api_version => 1.0 --bug4028805
387: ,p_init_msg_list => FND_API.G_FALSE
388: ,p_document_id => p_document_id
389: ,p_document_type => l_document_type