APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on FND_DOCUMENTS_LONG_TEXT

Line 2494: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS

2490: --Name: create_attachment
2491: --Pre-reqs:
2492: -- None
2493: --Modifies:
2494: -- FND_DOCUMENTS, FND_DOCUMENTS_LONG_TEXT, FND_ATTACHED_DOCUMENTS
2495: --Locks:
2496: -- None.
2497: --Function:
2498: -- This procedure creates a long text attachment at the header level of the

Line 2606: -- SQL What: Insert long text into FND_DOCUMENTS_LONG_TEXT

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
2609: INSERT INTO FND_DOCUMENTS_LONG_TEXT
2610: (

Line 2609: INSERT INTO FND_DOCUMENTS_LONG_TEXT

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
2609: INSERT INTO FND_DOCUMENTS_LONG_TEXT
2610: (
2611: media_id
2612: , long_text
2613: )

Line 2621: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows inserted in FND_DOCUMENTS_LONG_TEXT='||SQL%rowcount); END IF;

2617: , l_long_text
2618: );
2619:
2620: l_progress := '050';
2621: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows inserted in FND_DOCUMENTS_LONG_TEXT='||SQL%rowcount); END IF;
2622:
2623: -- SQL What: Get maximum sequence number for the CPA header attachments
2624: -- SQL Why : To get the next sequence number for the new attachment
2625: -- SQL Join: pk1_value, entity_name