1774: END IF; -- l_pending_signature = 'Y'
1775:
1776: d_progress := 90;
1777:
1778: UPDATE PO_LINE_LOCATIONS_ALL poll
1779: SET poll.approved_flag = 'Y'
1780: , poll.approved_date = SYSDATE
1781: , poll.last_update_date = SYSDATE
1782: , poll.last_updated_by = p_user_id
1795: THEN
1796:
1797: d_progress := 100;
1798:
1799: UPDATE PO_LINE_LOCATIONS_ALL poll
1800: SET poll.approved_flag = 'R'
1801: , poll.last_update_date = SYSDATE
1802: , poll.last_updated_by = p_user_id
1803: , poll.last_update_login = p_login_id
1834: THEN
1835:
1836: d_progress := 120;
1837:
1838: UPDATE PO_LINE_LOCATIONS_ALL poll
1839: SET poll.approved_flag = 'Y'
1840: , poll.approved_date = SYSDATE
1841: , poll.last_update_date = SYSDATE
1842: , poll.last_updated_by = p_user_id
1850: THEN
1851:
1852: d_progress := 130;
1853:
1854: UPDATE PO_LINE_LOCATIONS_ALL poll
1855: SET poll.approved_flag = 'R'
1856: , poll.last_update_date = SYSDATE
1857: , poll.last_updated_by = p_user_id
1858: , poll.last_update_login = p_login_id