80: l_draft_owner_role PO_DRAFTS.owner_role%TYPE;
81: l_draft_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
82: l_org_id PO_HEADERS_ALL.org_id%TYPE;
83: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
84: l_buyer_user_name FND_USER.user_name%TYPE;
85: l_buyer_name_dsp VARCHAR2(1000);
86:
87: BEGIN
88: d_position := 0;
532: d_position NUMBER;
533:
534: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
535: l_draft_id PO_DRAFTS.draft_id%TYPE;
536: l_emp_id FND_USER.employee_id%TYPE;
537: l_buyer_user_name FND_USER.user_name%TYPE;
538:
539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;
540: l_lock_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
533:
534: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
535: l_draft_id PO_DRAFTS.draft_id%TYPE;
536: l_emp_id FND_USER.employee_id%TYPE;
537: l_buyer_user_name FND_USER.user_name%TYPE;
538:
539: l_lock_owner_role PO_DRAFTS.owner_role%TYPE;
540: l_lock_owner_user_id PO_DRAFTS.owner_user_id%TYPE;
541:
640: d_position NUMBER;
641:
642: l_agent_id PO_HEADERS_ALL.agent_id%TYPE;
643: l_manager_id NUMBER;
644: l_manager_user_name FND_USER.user_name%TYPE;
645: l_manager_name_dsp VARCHAR2(1000);
646: BEGIN
647: d_position := 0;
648: