66: X_LAST_UPDATED_BY in NUMBER,
67: X_LAST_UPDATE_LOGIN in NUMBER) IS
68:
69: begin
70: update po_doc_style_lines_b
71: set enabled_flag = X_ENABLED_FLAG
72: ,last_updated_by = X_LAST_UPDATED_BY
73: ,last_update_login = 0
74: ,last_update_date = X_LAST_UPDATE_DATE
104: X_LAST_UPDATE_LOGIN in NUMBER) IS
105: begin
106:
107:
108: insert into po_doc_style_lines_b (
109: style_id
110: ,document_subtype
111: ,enabled_flag
112: ,creation_date
222:
223: delete from po_doc_style_lines_tl T
224: where not exists
225: (select NULL
226: from po_doc_style_lines_b B
227: where B.STYLE_ID = T.STYLE_ID
228: and B.DOCUMENT_SUBTYPE = T.DOCUMENT_SUBTYPE);
229:
230: update po_doc_style_lines_tl T