APPS.WF_LOAD dependencies on WF_ITEM_TYPES

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

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

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

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

Line 138: Wf_Item_Types_Pkg.Insert_Row(

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

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

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

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

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

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

Line 4729: 'WF_ITEM_TYPES',

4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',
4732: 'WF_LOOKUP_TYPES_TL',
4733: 'WF_MESSAGES',

Line 4730: 'WF_ITEM_TYPES_TL',

4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',
4729: 'WF_ITEM_TYPES',
4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',
4732: 'WF_LOOKUP_TYPES_TL',
4733: 'WF_MESSAGES',
4734: 'WF_MESSAGES_TL',