APPS.WF_LOAD dependencies on WF_ITEM_TYPES

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 70: -- update WF_ITEM_TYPES_TL

66:
67: -- ### Not needed any more
68: -- update the old data with the new display name
69: -- begin
70: -- update WF_ITEM_TYPES_TL
71: -- set display_name = n_dname
72: -- where NAME = l_name
73: -- and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
74: -- exception

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 108: Wf_Item_Types_Pkg.Update_Row(

104: return;
105: end if;
106:
107: -- Update existing row
108: Wf_Item_Types_Pkg.Update_Row(
109: x_name => x_name,
110: x_protect_level => x_protect_level,
111: x_custom_level => x_custom_level,
112: x_wf_selector => x_wf_selector,

Line 137: Wf_Item_Types_Pkg.Insert_Row(

133: return;
134: end if;
135:
136: -- Insert new row
137: Wf_Item_Types_Pkg.Insert_Row(
138: x_rowid => row_id,
139: x_name => x_name,
140: x_protect_level => x_protect_level,
141: x_custom_level => x_custom_level,

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 2472: Wf_Item_Types_Pkg.Delete_Row(x_name=>x_name);

2468: -- Bad row found. Raise exception back to loader.
2469: raise fk_violation;
2470: end;
2471:
2472: Wf_Item_Types_Pkg.Delete_Row(x_name=>x_name);
2473:
2474: exception
2475: when NO_DATA_FOUND then
2476: null;

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 2793: from WF_ITEM_TYPES

2789:
2790: -- Find out what persistence type it belongs
2791: select PERSISTENCE_TYPE
2792: into l_persistence_type
2793: from WF_ITEM_TYPES
2794: where NAME = x_item_type;
2795:
2796: Wf_Purge.persistence_type := l_persistence_type;
2797:

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);