APPS.WF_LOAD dependencies on WF_ITEM_TYPES_VL

Line 37: from WF_ITEM_TYPES_VL

33: n_dname := x_display_name;
34: begin
35: select NAME, DISPLAY_NAME, NAME
36: into conflict_name, l_dname, l_name
37: from WF_ITEM_TYPES_VL
38: where DISPLAY_NAME = x_display_name
39: and NAME <> x_name;
40:
41: n_dname := substrb('@'||l_dname, 1, 80);

Line 48: from WF_ITEM_TYPES_VL

44: loop
45: begin
46: select NAME, DISPLAY_NAME
47: into conflict_name, l_dname
48: from WF_ITEM_TYPES_VL
49: where DISPLAY_NAME = n_dname
50: and NAME <> l_name;
51:
52: n_dname := substrb('@'||l_dname, 1, 80);

Line 92: from WF_ITEM_TYPES_VL

88: x_level_error := 0;
89: begin
90: select PROTECT_LEVEL, CUSTOM_LEVEL
91: into protection_level, customization_level
92: from WF_ITEM_TYPES_VL
93: where NAME = x_name;
94:
95: if ((wf_core.upload_mode <> 'FORCE') and
96: (protection_level < wf_core.session_level)) then

Line 2421: from WF_ITEM_TYPES_VL

2417: -- Check protection level
2418: x_level_error := 0;
2419: select PROTECT_LEVEL, CUSTOM_LEVEL, PERSISTENCE_TYPE
2420: into protection_level, customization_level, l_persistence_type
2421: from WF_ITEM_TYPES_VL
2422: where NAME = x_name;
2423:
2424: if ((wf_core.upload_mode <> 'FORCE') and
2425: (protection_level < wf_core.session_level)) then

Line 2545: from WF_ITEM_TYPES_VL

2541: -- Check protection level
2542: x_level_error := 0;
2543: select PROTECT_LEVEL, CUSTOM_LEVEL
2544: into protection_level, customization_level
2545: from WF_ITEM_TYPES_VL
2546: where NAME = x_item_type;
2547:
2548: if ((wf_core.upload_mode <> 'FORCE') and
2549: (protection_level < wf_core.session_level)) then

Line 3201: from WF_ITEM_TYPES_VL

3197: WF_SELECTOR, READ_ROLE, WRITE_ROLE, EXECUTE_ROLE,
3198: PERSISTENCE_TYPE,
3199: to_char(PERSISTENCE_DAYS) PERSISTENCE_DAYS
3200: into v_itt
3201: from WF_ITEM_TYPES_VL
3202: where NAME = p_item_type;
3203: exception
3204: when others then
3205: Wf_Core.Context('Wf_Load', 'Selecting ITEM_TYPE', p_item_type);

Line 3212: from WF_ITEM_TYPES_VL

3208:
3209: begin
3210: select DISPLAY_NAME
3211: into l_dname
3212: from WF_ITEM_TYPES_VL
3213: where NAME = p_destination_item_type;
3214: exception
3215: when NO_DATA_FOUND then
3216: l_dname := substr(v_itt.display_name||p_new_suffix,1,80);