128: THEN
129: UPDATE po_headers_all
130: SET clm_closeout_status = NULL,
131: last_update_date = SYSDATE,
132: last_updated_by = FND_GLOBAL.USER_ID,
133: last_update_login = FND_GLOBAL.LOGIN_ID
134: WHERE po_header_id = p_doc_header_id;
135:
136: d_pos := 25;
129: UPDATE po_headers_all
130: SET clm_closeout_status = NULL,
131: last_update_date = SYSDATE,
132: last_updated_by = FND_GLOBAL.USER_ID,
133: last_update_login = FND_GLOBAL.LOGIN_ID
134: WHERE po_header_id = p_doc_header_id;
135:
136: d_pos := 25;
137:
139: SET closeout_date = NULL,
140: incloseout = NULL,
141: is_reopened = 'Y',
142: last_update_date = SYSDATE,
143: last_updated_by = FND_GLOBAL.USER_ID,
144: last_update_login = FND_GLOBAL.LOGIN_ID
145: WHERE reference_doc_id = p_doc_header_id
146: AND closeout_doc_type = po_closeout_pvt.g_CLOSEOUT_TYPE_INDIVIDUAL;
147:
140: incloseout = NULL,
141: is_reopened = 'Y',
142: last_update_date = SYSDATE,
143: last_updated_by = FND_GLOBAL.USER_ID,
144: last_update_login = FND_GLOBAL.LOGIN_ID
145: WHERE reference_doc_id = p_doc_header_id
146: AND closeout_doc_type = po_closeout_pvt.g_CLOSEOUT_TYPE_INDIVIDUAL;
147:
148: d_pos := 30;