102:
103:
104: BEGIN
105:
106: /*SELECT po_wdol_evnt_s.NEXTVAL INTO l_event_key FROM dual;
107: l_event_key := 'WDOL'||l_event_key;
108: l_event_name := 'oracle.apps.po.integration.wagedetermination';
109: l_message := wf_event.test(l_event_name);
110:
155: END IF;
156:
157: SELECT fnd_attached_documents_s.nextval
158: INTO x_attached_document_id
159: FROM dual;
160:
161: open c_get_max_attach_seq;
162: fetch c_get_max_attach_seq into l_seq_num;
163: close c_get_max_attach_seq;
163: close c_get_max_attach_seq;
164:
165: l_seq_num := l_seq_num + 1;
166:
167: select decode(p_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
168:
169: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
170: X_attached_document_id => x_attached_document_id,
171: X_document_id => X_document_id,
358: END IF;
359:
360: SELECT fnd_attached_documents_s.nextval
361: INTO x_attached_document_id
362: FROM dual;
363:
364: open c_get_max_attach_seq;
365: fetch c_get_max_attach_seq into l_seq_num;
366: close c_get_max_attach_seq;
366: close c_get_max_attach_seq;
367:
368: l_seq_num := l_seq_num + 1;
369:
370: select decode(l_doc_type_class,'PO','PO_HEADERS','SOURCING','PON_AUCTION_HEADERS_ALL') into l_entity_name from dual;
371:
372:
373: fnd_attached_documents_pkg.insert_row(X_Rowid => x_row_id,
374: X_attached_document_id => x_attached_document_id,