APPS.EDR_ISIGN_TEMPLATE_PKG dependencies on EDR_FILES_B

Line 43: edr_files_b

39: status , fnd_document_id, file_id
40: INTO
41: l_status , l_fnd_document_id, l_file_id_template
42: FROM
43: edr_files_b
44: WHERE
45: file_name = p_style_sheet
46: AND
47: version_label = p_style_sheet_ver

Line 97: -- to file_id in ISIGN edr_files_b table.

93: END GET_XSLFO_TEMPLATE;
94:
95: -- EDR_ISIGN_TEMPLATE_PKG.GET_TEMPLATE procedure is called from TemplateManager Class
96: -- to get the handle of RTF Template Blob. It passes unique p_event_key which is equal
97: -- to file_id in ISIGN edr_files_b table.
98: --
99: -- P_EVENT_KEY - File Id for the ISIGN EDR_FILES_B Table repository
100: -- X_TEMPALTE_TYPE - Return template type as string e.g. RTF, XSL, PDF
101: -- X_TEMPLATE_BLOB - Return Template contents in BLOB

Line 99: -- P_EVENT_KEY - File Id for the ISIGN EDR_FILES_B Table repository

95: -- EDR_ISIGN_TEMPLATE_PKG.GET_TEMPLATE procedure is called from TemplateManager Class
96: -- to get the handle of RTF Template Blob. It passes unique p_event_key which is equal
97: -- to file_id in ISIGN edr_files_b table.
98: --
99: -- P_EVENT_KEY - File Id for the ISIGN EDR_FILES_B Table repository
100: -- X_TEMPALTE_TYPE - Return template type as string e.g. RTF, XSL, PDF
101: -- X_TEMPLATE_BLOB - Return Template contents in BLOB
102: -- X_TEMPLATE_FILE_NAME - Return Template File Name as String
103:

Line 120: fnd_lobs fl, fnd_documents_vl fdt, edr_files_b isign_files

116: --Bug : 3499311 : Start - Specified number format in call TO_NUMBER
117: select fl.file_data, isign_files.ORIGINAL_FILE_NAME, isign_files.FILE_NAME
118: into l_file_data, l_file_name, l_display_name
119: from
120: fnd_lobs fl, fnd_documents_vl fdt, edr_files_b isign_files
121: where
122: isign_files.file_id = to_number(p_event_key,'999999999999.999999')
123: and fdt.document_id = isign_files.fnd_document_id
124: and fl.file_id = fdt.media_id;