1312: prior_len NUMBER := 0;
1313:
1314: /* Bug 2788683 start */
1315: l_user_name fnd_user.user_name%TYPE;
1316: l_vendor_name hz_parties.party_name%TYPE;
1317: l_party_name hz_parties.party_name%TYPE;
1318: /* Bug 2788683 end */
1319: l_supplier po_vendors.vendor_name%TYPE; --
1320: l_draft_id NUMBER;
1313:
1314: /* Bug 2788683 start */
1315: l_user_name fnd_user.user_name%TYPE;
1316: l_vendor_name hz_parties.party_name%TYPE;
1317: l_party_name hz_parties.party_name%TYPE;
1318: /* Bug 2788683 end */
1319: l_supplier po_vendors.vendor_name%TYPE; --
1320: l_draft_id NUMBER;
1321: l_doc_sub_type_code po_action_history.object_sub_type_code%TYPE; -- CLM Apprvl
1529: hp.party_name
1530: INTO l_user_name,
1531: l_party_name
1532: FROM fnd_user fu,
1533: hz_parties hp
1534: WHERE hp.party_id = fu.customer_id
1535: AND fu.user_id = l_created_by_tbl(i);
1536: EXCEPTION
1537: WHEN OTHERS THEN
1623: BEGIN --
1624: SELECT fu.user_name, hp.party_name
1625: INTO l_user_name, l_party_name
1626: FROM fnd_user fu,
1627: hz_parties hp
1628: WHERE hp.party_id = fu.customer_id
1629: AND fu.user_id = l_created_by_tbl(i);
1630: EXCEPTION
1631: WHEN OTHERS THEN