APPS.PO_R12_CAT_UPG_FINAL_GRP dependencies on FND_ATTACHED_DOCUMENTS

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 2537: l_to_pk1_value FND_ATTACHED_DOCUMENTS.pk1_value%TYPE;

2533: l_media_id NUMBER;
2534: l_seq_num NUMBER;
2535: l_description VARCHAR2(200);
2536: l_long_text LONG;
2537: l_to_pk1_value FND_ATTACHED_DOCUMENTS.pk1_value%TYPE;
2538: l_to_entity_name FND_ATTACHED_DOCUMENTS.entity_name%TYPE;
2539:
2540: BEGIN
2541: l_progress := '010';

Line 2538: l_to_entity_name FND_ATTACHED_DOCUMENTS.entity_name%TYPE;

2534: l_seq_num NUMBER;
2535: l_description VARCHAR2(200);
2536: l_long_text LONG;
2537: l_to_pk1_value FND_ATTACHED_DOCUMENTS.pk1_value%TYPE;
2538: l_to_entity_name FND_ATTACHED_DOCUMENTS.entity_name%TYPE;
2539:
2540: BEGIN
2541: l_progress := '010';
2542: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'START'); END IF;

Line 2628: FROM FND_ATTACHED_DOCUMENTS

2624: -- SQL Why : To get the next sequence number for the new attachment
2625: -- SQL Join: pk1_value, entity_name
2626: SELECT max(seq_num)
2627: INTO l_seq_num
2628: FROM FND_ATTACHED_DOCUMENTS
2629: WHERE pk1_value = l_to_pk1_value
2630: AND entity_name = l_to_entity_name;
2631:
2632: l_seq_num := nvl(l_seq_num, 0) + 10;

Line 2637: -- SQL What: Insert document into FND_ATTACHED_DOCUMENTS

2633:
2634: l_progress := '060';
2635: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Next seq_num='||l_seq_num); END IF;
2636:
2637: -- SQL What: Insert document into FND_ATTACHED_DOCUMENTS
2638: -- SQL Why : This long text document will be attached to the CPA
2639: -- SQL Join: none
2640: INSERT INTO FND_ATTACHED_DOCUMENTS
2641: (

Line 2640: INSERT INTO FND_ATTACHED_DOCUMENTS

2636:
2637: -- SQL What: Insert document into FND_ATTACHED_DOCUMENTS
2638: -- SQL Why : This long text document will be attached to the CPA
2639: -- SQL Join: none
2640: INSERT INTO FND_ATTACHED_DOCUMENTS
2641: (
2642: attached_document_id
2643: , document_id
2644: , creation_date

Line 2657: FND_ATTACHED_DOCUMENTS_S.nextval

2653: , program_update_date
2654: )
2655: VALUES
2656: (
2657: FND_ATTACHED_DOCUMENTS_S.nextval
2658: , l_document_id
2659: , sysdate
2660: , FND_GLOBAL.user_id
2661: , sysdate

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

2668: , sysdate
2669: );
2670:
2671: l_progress := '070';
2672: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'Number of rows inserted in FND_ATTACHED_DOCUMENTS='||SQL%rowcount); END IF;
2673:
2674: IF g_debug THEN PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'END'); END IF;
2675: EXCEPTION
2676: WHEN OTHERS THEN