DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_LINE_LOCATIONS_ALL

Line 2075: UPDATE PO_LINE_LOCATIONS_ALL poll

2071: END IF;
2072:
2073: d_progress := 90;
2074:
2075: UPDATE PO_LINE_LOCATIONS_ALL poll
2076: SET poll.approved_flag = 'Y'
2077: , poll.approved_date = SYSDATE
2078: , poll.last_update_date = SYSDATE
2079: , poll.last_updated_by = p_user_id

Line 2104: UPDATE PO_LINE_LOCATIONS_ALL poll

2100: THEN
2101:
2102: d_progress := 100;
2103:
2104: UPDATE PO_LINE_LOCATIONS_ALL poll
2105: SET poll.approved_flag = 'R'
2106: , poll.last_update_date = SYSDATE
2107: , poll.last_updated_by = p_user_id
2108: , poll.last_update_login = p_login_id

Line 2143: UPDATE PO_LINE_LOCATIONS_ALL poll

2139: THEN
2140:
2141: d_progress := 120;
2142:
2143: UPDATE PO_LINE_LOCATIONS_ALL poll
2144: SET poll.approved_flag = 'Y'
2145: , poll.approved_date = SYSDATE
2146: , poll.last_update_date = SYSDATE
2147: , poll.last_updated_by = p_user_id

Line 2159: UPDATE PO_LINE_LOCATIONS_ALL poll

2155: THEN
2156:
2157: d_progress := 130;
2158:
2159: UPDATE PO_LINE_LOCATIONS_ALL poll
2160: SET poll.approved_flag = 'R'
2161: , poll.last_update_date = SYSDATE
2162: , poll.last_updated_by = p_user_id
2163: , poll.last_update_login = p_login_id