APPS.GMA_EDITEXT_ATTACH_MIG dependencies on FND_ATTACHMENT_FUNCTIONS

Line 56: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;

52: AND t.sub_paracode = x_sub_paracode
53: AND t.language = l.language_code
54: ORDER BY installed_flag;
55:
56: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
57: l_attached_document_id fnd_documents.document_id%TYPE;
58: l_document_id fnd_documents.document_id%TYPE;
59: l_media_id NUMBER;
60: l_Cur_Paragraph Cur_Paragraph%rowtype;

Line 213: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;

209: p_table_name IN VARCHAR2 default null,
210: p_attachment_function_id OUT NOCOPY NUMBER
211: )
212: Is
213: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
214: l_api_name CONSTANT VARCHAR2(30) := 'Check_Fnd_Attachment_Defined' ;
215: l_api_version CONSTANT NUMBER := 1.0 ;
216: l_progress VARCHAR2(3) := '000';
217: l_long_message VARCHAR2(4000);

Line 223: FROM fnd_attachment_functions

219: Begin
220: -- Validating the attachment functionality for given form and table
221: SELECT attachment_function_id
222: into l_attachment_function_id
223: FROM fnd_attachment_functions
224: WHERE attachment_function_id
225: in(SELECT attachment_function_id
226: from fnd_attachment_blocks
227: WHERE attachment_blk_id

Line 791: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;

787:
788: l_new_attachment_id NUMBER;
789: l_row_id VARCHAR2(30);
790: l_current_date DATE := sysdate;
791: l_attachment_function_id fnd_attachment_functions.attachment_function_id%type;
792: l_attached_document_id fnd_documents.document_id%TYPE;
793: l_create_Attached_Doc boolean := true;
794: l_dummy fnd_documents.document_id%TYPE;
795: