2574: , x_long_text => l_long_text -- IN/OUT
2575: );
2576:
2577: l_progress := '030';
2578: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling FND_DOCUMENTS_PKG.insert_row()'); END IF;
2579: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Parameter: userenv(LANG)='||userenv('LANG')); END IF;
2580:
2581: -- Insert into FND_DOCUMENTS
2582: FND_DOCUMENTS_PKG.insert_row
2578: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Calling FND_DOCUMENTS_PKG.insert_row()'); END IF;
2579: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Parameter: userenv(LANG)='||userenv('LANG')); END IF;
2580:
2581: -- Insert into FND_DOCUMENTS
2582: FND_DOCUMENTS_PKG.insert_row
2583: (
2584: x_rowid => l_rowid -- IN/OUT
2585: , x_document_id => l_document_id -- IN/OUT
2586: , x_creation_date => sysdate
2600: , x_media_id => l_media_id -- IN/OUT
2601: );
2602:
2603: l_progress := '040';
2604: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'FND_DOCUMENTS_PKG.insert_row() returns media_id='||l_media_id||', document_id='||l_document_id||', row_id='||l_rowid); END IF;
2605:
2606: -- SQL What: Insert long text into FND_DOCUMENTS_LONG_TEXT
2607: -- SQL Why : This long text will be attached to the CPA
2608: -- SQL Join: none