APPS.PO_REQAPPROVAL_INIT1 dependencies on PO_VENDORS_GRP

Line 3725: l_supplier_user_tbl po_vendors_grp.external_user_tbl_type;

3721: x_role_with_resp IN OUT NOCOPY VARCHAR2)
3722: IS
3723: /*CONERMS FPJ START*/
3724: -- declare local variables to hold output of get_supplier_userlist call
3725: l_supplier_user_tbl po_vendors_grp.external_user_tbl_type;
3726: l_namelist VARCHAR2(31990):=NULL;
3727: l_namelist_for_sql VARCHAR2(32000):=NULL;
3728: l_num_users NUMBER := 0;
3729: l_vendor_id NUMBER;

Line 3752: -- called po_vendors_grp.get_external_userlist. This procedure now makes a

3748: l_num_users := 0;
3749: l_step := '0';
3750: /* CONTERMS FPJ START */
3751: -- The code to create the user list has been sliced into another procedure
3752: -- called po_vendors_grp.get_external_userlist. This procedure now makes a
3753: -- call to it to retrieve, comma and space delimited userlist, and number
3754: -- of users, supplier list in a table and vendor id.
3755: /*po_doc_utl_pvt.get_supplier_userlist(p_document_id => p_document_id
3756: ,p_document_type => p_document_type

Line 3764: po_vendors_grp.get_external_userlist (

3760: ,x_supplier_userlist_for_sql => l_namelist_for_sql
3761: ,x_num_users => l_num_users
3762: ,x_vendor_id => l_vendor_id);*/
3763:
3764: po_vendors_grp.get_external_userlist (
3765: p_api_version => 1.0 , p_init_msg_list => FND_API.G_FALSE , p_document_id => p_document_id ,
3766: p_document_type => p_document_type , x_return_status => l_return_status , x_msg_count => l_msg_count ,
3767: x_msg_data => l_msg_data , x_external_user_tbl => l_supplier_user_tbl , x_supplier_userlist => l_namelist ,
3768: x_supplier_userlist_for_sql => l_namelist_for_sql , x_num_users => l_num_users , x_vendor_id => l_vendor_id);