[Home] [Help]
345: --IN:
346: -- p_document_id
347: -- po_header_id
348: -- p_document_type
349: -- Document type as expected by po_vendors_grp.get_external_userlist
350: -- 'PO_STANDARD', 'PA_BLANKET', 'PA_CONTRACT'
351: -- Eventhough currently this code is being called only with PA_CONTRACT,
352: -- we will use this as a generic utility method to get supplier role.
353: --RETURN:
361:
362: l_progress NUMBER;
363:
364: -- declare local variables to hold output of get_supplier_userlist call
365: l_supplier_user_tbl po_vendors_grp.external_user_tbl_type;
366: l_namelist varchar2(31990):=null;
367: l_namelist_for_sql varchar2(32000):=null;
368: l_num_users NUMBER := 0;
369: l_vendor_id NUMBER;
384: PO_LOG.proc_begin(d_mod,'p_document_type', p_document_type );
385: END IF;
386:
387: -- Get the supplier user name list for a give po_header_id
388: po_vendors_grp.get_external_userlist
389: (p_api_version => 1.0
390: ,p_init_msg_list => FND_API.G_FALSE
391: ,p_document_id => p_document_id
392: ,p_document_type => p_document_type
419: begin
420: -- Role display name is the Supplier name
421: select vendor_name
422: into l_role_display_name
423: from po_vendors
424: where vendor_id=l_vendor_id;
425: exception
426: when others then
427: l_role_display_name:=' ';
532:
533: d_mod CONSTANT VARCHAR2(100) := D_get_wf_role_for_lock_owner;
534: d_position NUMBER;
535:
536: l_vendor_name PO_VENDORS.vendor_name%TYPE;
537: l_emp_id FND_USER.employee_id%TYPE;
538: l_user_name FND_USER.user_name%TYPE;
539: l_expected_wf_role_name WF_USER_ROLES.role_name%TYPE;
540: l_user_table WF_DIRECTORY.UserTable; --Added as part of Bug 13059528 fix
573:
574: SELECT PV.vendor_name
575: INTO x_wf_role_name_dsp
576: FROM po_headers_all POH,
577: po_vendors PV
578: WHERE POH.po_header_id = p_po_header_id
579: AND POH.vendor_id = PV.vendor_id;
580:
581: l_expected_wf_role_name :=