DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINE_LOCATIONS_ALL

Line 1778: UPDATE PO_LINE_LOCATIONS_ALL poll

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

Line 1799: UPDATE PO_LINE_LOCATIONS_ALL poll

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

Line 1838: UPDATE PO_LINE_LOCATIONS_ALL poll

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

Line 1854: UPDATE PO_LINE_LOCATIONS_ALL poll

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