APPS.WF_LOAD dependencies on WF_ITEM_TYPES_VL

Line 38: from WF_ITEM_TYPES_VL

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

Line 49: from WF_ITEM_TYPES_VL

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

Line 93: from WF_ITEM_TYPES_VL

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

Line 2422: from WF_ITEM_TYPES_VL

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

Line 2546: from WF_ITEM_TYPES_VL

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

Line 3202: from WF_ITEM_TYPES_VL

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

Line 3213: from WF_ITEM_TYPES_VL

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