APPS.ECX_XSLT_UTILS dependencies on ECX_FILES

Line 29: from ecx_files

25: then
26: begin
27: select id, creation_date, version
28: into i_id, i_creation_date, i_new_version
29: from ecx_files
30: where application_code = i_application_code
31: and version = (select max(version)
32: from ecx_files
33: where application_code = i_application_code

Line 32: from ecx_files

28: into i_id, i_creation_date, i_new_version
29: from ecx_files
30: where application_code = i_application_code
31: and version = (select max(version)
32: from ecx_files
33: where application_code = i_application_code
34: and name = i_filename
35: and type = FILE_TYPE)
36: and name = i_filename

Line 50: from ecx_files

46: -- and use this in the insert
47: begin
48: select id, creation_date
49: into i_id, i_creation_date
50: from ecx_files
51: where application_code = i_application_code
52: and version = i_version
53: and name = i_filename
54: and type = FILE_TYPE;

Line 67: update ecx_files

63:
64: if (i_id is not null AND i_creation_date is not null)
65: then
66: -- update the entry with the latest data
67: update ecx_files
68: set last_update_date = sysdate,
69: payload = i_payload
70: where id = i_id;
71: else

Line 72: -- insert into ecx_files

68: set last_update_date = sysdate,
69: payload = i_payload
70: where id = i_id;
71: else
72: -- insert into ecx_files
73: insert into ecx_files
74: (
75: id,
76: type,

Line 73: insert into ecx_files

69: payload = i_payload
70: where id = i_id;
71: else
72: -- insert into ecx_files
73: insert into ecx_files
74: (
75: id,
76: type,
77: name,

Line 89: ecx_files_s.nextval,

85: payload
86: )
87: values
88: (
89: ecx_files_s.nextval,
90: FILE_TYPE,
91: i_filename,
92: i_new_version,
93: i_application_code,

Line 126: delete from ecx_files

122: begin
123: -- if version is null, delete the max version entry that matches the details
124: if (i_version is null)
125: then
126: delete from ecx_files
127: where application_code = i_application_code
128: and version = (select max(version)
129: from ecx_files
130: where application_code = i_application_code

Line 129: from ecx_files

125: then
126: delete from ecx_files
127: where application_code = i_application_code
128: and version = (select max(version)
129: from ecx_files
130: where application_code = i_application_code
131: and name = i_filename
132: and type = FILE_TYPE)
133: and name = i_filename

Line 136: delete from ecx_files

132: and type = FILE_TYPE)
133: and name = i_filename
134: and type = FILE_TYPE;
135: else
136: delete from ecx_files
137: where application_code = i_application_code
138: and (i_version is null or version = i_version)
139: and name = i_filename
140: and type = FILE_TYPE;