APPS.PO_DOCUMENT_UPGRADE_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 107: l_table_name varchar2(30) := 'PO_LINE_LOCATIONS_ALL';

103: IS
104:
105: l_worker_id number;
106: l_product varchar2(30) := 'PO';
107: l_table_name varchar2(30) := 'PO_LINE_LOCATIONS_ALL';
108: l_update_name varchar2(30) := 'poxucpll.sql';
109: l_status varchar2(30);
110: l_industry varchar2(30);
111: l_retstatus boolean;

Line 120: l_userid po_line_locations_all.last_updated_by%TYPE;

116: l_start_rowid rowid;
117: l_end_rowid rowid;
118: l_rows_processed number;
119:
120: l_userid po_line_locations_all.last_updated_by%TYPE;
121: l_loginid po_line_locations_all.last_update_login%TYPE;
122:
123: BEGIN
124:

Line 121: l_loginid po_line_locations_all.last_update_login%TYPE;

117: l_end_rowid rowid;
118: l_rows_processed number;
119:
120: l_userid po_line_locations_all.last_updated_by%TYPE;
121: l_loginid po_line_locations_all.last_update_login%TYPE;
122:
123: BEGIN
124:
125: --

Line 185: UPDATE /*+ ROWID (poll) */ po_line_locations_all poll

181: --
182: --
183: -----------------------------------------------------
184:
185: UPDATE /*+ ROWID (poll) */ po_line_locations_all poll
186: SET poll.closed_for_receiving_date =
187: ( select nvl(max(RT.transaction_date),
188: decode(poll.closed_code,
189: 'FINALLY CLOSED',poll.closed_date,