[Home] [Help]
35: -- None except the workflow item attributes
36: --Locks:
37: -- None
38: --Function:
39: -- 1. Get the supplier usernames associated with the po_headers_all.vendor_id
40: -- and get the role associated with that list
41: -- 2. Create AGREEMENT_AUTHORING_ENABLED process
42: -- 3. Set the item attributes for this process(set the supplier role in
43: -- FORWARD_TO_ROLE item attribute)
64: p_ou_name IN VARCHAR2,
65: p_buyer_user_id IN NUMBER)
66: IS
67: l_seq_for_item_key varchar2(10) := null;
68: l_item_type po_headers_all.wf_item_type%type := 'POAUTH';
69: l_item_key po_headers_all.wf_item_key%type := null;
70: l_supplier_user_name fnd_user.user_name%type;
71: l_progress NUMBER := 0;
72: -- bug 4733423: Modified the link to access edit blanket page
65: p_buyer_user_id IN NUMBER)
66: IS
67: l_seq_for_item_key varchar2(10) := null;
68: l_item_type po_headers_all.wf_item_type%type := 'POAUTH';
69: l_item_key po_headers_all.wf_item_key%type := null;
70: l_supplier_user_name fnd_user.user_name%type;
71: l_progress NUMBER := 0;
72: -- bug 4733423: Modified the link to access edit blanket page
73: l_edit_agreement_url varchar2(1000) :=
236:
237: d_mod CONSTANT VARCHAR2(100) := D_start_changes_discarded_wf;
238: d_position NUMBER;
239:
240: c_ITEM_TYPE CONSTANT po_headers_all.wf_item_type%type := 'POAUTH';
241: c_PROCESS CONSTANT VARCHAR2(30) := 'AGREEMENT_CHANGES_DISCARDED';
242:
243: l_seq_for_item_key NUMBER := NULL;
244: l_item_key po_headers_all.wf_item_key%type := null;
240: c_ITEM_TYPE CONSTANT po_headers_all.wf_item_type%type := 'POAUTH';
241: c_PROCESS CONSTANT VARCHAR2(30) := 'AGREEMENT_CHANGES_DISCARDED';
242:
243: l_seq_for_item_key NUMBER := NULL;
244: l_item_key po_headers_all.wf_item_key%type := null;
245:
246: l_buyer_user_name fnd_user.user_name%type;
247: l_buyer_display_name per_people_f.full_name%type;
248:
336: --Locks:
337: -- None
338: --Function:
339: -- For give po_header_id, this procedure
340: -- 1. Finds the supplier user names associated with po_headers_all.vendor_id
341: -- 2. Checks if there is already a role associated with this supplier list
342: -- 3. If not, then create an adhoc role for this supplier list
343: -- 4. If there is already a role for this supplier list, use it.
344: --Parameters:
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:
354: -- Workflow role for the supplier list associated with po_headers_all.vendor_id
355: --End of Comments
356: -------------------------------------------------------------------------------
357:
358: FUNCTION get_wf_role_for_suppliers ( p_document_id in number,
517: -- Workflow adhoc role name
518: -- x_wf_role_name_dsp
519: -- Workflow adhoc role display name
520: --RETURN:
521: -- Workflow role for the supplier list associated with po_headers_all.vendor_id
522: --End of Comments
523: -------------------------------------------------------------------------------
524: PROCEDURE get_wf_role_for_lock_owner
525: ( p_po_header_id IN NUMBER,
572: WHERE user_id = p_lock_owner_user_id;
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: