APPS.ICX_CAT_DOWNLOAD_FILES_PVT dependencies on ICX_POR_TEMPLATE_FILES

Line 9: DELETE FROM icx_por_template_files;

5: IS
6: l_err_loc PLS_INTEGER;
7: BEGIN
8: l_err_loc := 100;
9: DELETE FROM icx_por_template_files;
10:
11: l_err_loc := 200;
12: INSERT INTO icx_por_template_files
13: (filename, usage, template_type, description)

Line 12: INSERT INTO icx_por_template_files

8: l_err_loc := 100;
9: DELETE FROM icx_por_template_files;
10:
11: l_err_loc := 200;
12: INSERT INTO icx_por_template_files
13: (filename, usage, template_type, description)
14: SELECT 'Readme_Spreadsheet.htm', 'TXT', 'ALL', 'Instructions for TXT upload.'
15: FROM dual;
16:

Line 18: INSERT INTO icx_por_template_files

14: SELECT 'Readme_Spreadsheet.htm', 'TXT', 'ALL', 'Instructions for TXT upload.'
15: FROM dual;
16:
17: l_err_loc := 300;
18: INSERT INTO icx_por_template_files
19: (filename, usage, template_type, description)
20: SELECT 'Readme_XML.htm', 'XML', 'ALL', 'Instructions for XML upload.'
21: FROM dual;
22:

Line 24: INSERT INTO icx_por_template_files

20: SELECT 'Readme_XML.htm', 'XML', 'ALL', 'Instructions for XML upload.'
21: FROM dual;
22:
23: l_err_loc := 400;
24: INSERT INTO icx_por_template_files
25: (filename, usage, template_type, description)
26: SELECT 'Readme_cXML.htm', 'CXML', 'ALL', 'Instructions for cXML upload.'
27: FROM dual;
28:

Line 30: INSERT INTO icx_por_template_files

26: SELECT 'Readme_cXML.htm', 'CXML', 'ALL', 'Instructions for cXML upload.'
27: FROM dual;
28:
29: l_err_loc := 500;
30: INSERT INTO icx_por_template_files
31: (filename, usage, template_type, description)
32: SELECT 'Readme_CIF.htm', 'CIF', 'ALL', 'Instructions for CIF upload.'
33: FROM dual;
34:

Line 36: INSERT INTO icx_por_template_files

32: SELECT 'Readme_CIF.htm', 'CIF', 'ALL', 'Instructions for CIF upload.'
33: FROM dual;
34:
35: l_err_loc := 600;
36: INSERT INTO icx_por_template_files
37: (filename, usage, template_type, description)
38: SELECT 'Readme_Schema.htm', 'SCHEMA', 'ALL', 'Instructions for schema upload.'
39: FROM dual;
40:

Line 42: INSERT INTO icx_por_template_files

38: SELECT 'Readme_Schema.htm', 'SCHEMA', 'ALL', 'Instructions for schema upload.'
39: FROM dual;
40:
41: l_err_loc := 700;
42: INSERT INTO icx_por_template_files
43: (filename, usage, template_type, description)
44: SELECT 'Readme_Converter.htm', 'CONVERTER', 'ALL', 'Instructions for converter.'
45: FROM dual;
46: