29: where NAME = x_name
30: and TYPE = x_type
31: and LANGUAGE = userenv('LANG');
32:
33: if ((wf_core.upload_mode <> 'FORCE') and
34: (protection_level < wf_core.session_level)) then
35: x_level_error := 1;
36: return;
37: end if;
30: and TYPE = x_type
31: and LANGUAGE = userenv('LANG');
32:
33: if ((wf_core.upload_mode <> 'FORCE') and
34: (protection_level < wf_core.session_level)) then
35: x_level_error := 1;
36: return;
37: end if;
38:
35: x_level_error := 1;
36: return;
37: end if;
38:
39: if ((wf_core.upload_mode = 'UPGRADE') and
40: (customization_level > wf_core.session_level)) then
41: x_level_error := 2;
42: return;
43: end if;
36: return;
37: end if;
38:
39: if ((wf_core.upload_mode = 'UPGRADE') and
40: (customization_level > wf_core.session_level)) then
41: x_level_error := 2;
42: return;
43: end if;
44:
54:
55: exception
56: when no_data_found then
57: -- Check protection level for new row
58: if ((wf_core.upload_mode <> 'FORCE') and
59: (x_protect_level < wf_core.session_level)) then
60: x_level_error := 1;
61: return;
62: end if;
55: exception
56: when no_data_found then
57: -- Check protection level for new row
58: if ((wf_core.upload_mode <> 'FORCE') and
59: (x_protect_level < wf_core.session_level)) then
60: x_level_error := 1;
61: return;
62: end if;
63:
60: x_level_error := 1;
61: return;
62: end if;
63:
64: if ((wf_core.upload_mode = 'UPGRADE') and
65: (x_custom_level > wf_core.session_level)) then
66: x_level_error := 2;
67: return;
68: end if;
61: return;
62: end if;
63:
64: if ((wf_core.upload_mode = 'UPGRADE') and
65: (x_custom_level > wf_core.session_level)) then
66: x_level_error := 2;
67: return;
68: end if;
69:
80: end;
81:
82: exception
83: when others then
84: Wf_Core.Context('WF_RESOURCE_LOAD', 'Upload_Resource', x_name, x_type);
85: raise;
86: end UPLOAD_RESOURCE;
87:
88: end WF_RESOURCE_LOAD;