APPS.WF_LOAD dependencies on WF_MESSAGES

Line 737: from WF_MESSAGES_VL

733: x_level_error := 0;
734: begin
735: select PROTECT_LEVEL, CUSTOM_LEVEL
736: into protection_level, customization_level
737: from WF_MESSAGES_VL
738: where TYPE = x_type
739: and NAME = x_name;
740:
741: if ((wf_core.upload_mode <> 'FORCE') and

Line 754: Wf_Messages_Pkg.Update_Row(

750: return;
751: end if;
752:
753: -- Update existing row
754: Wf_Messages_Pkg.Update_Row(
755: x_type => x_type,
756: x_name => x_name,
757: x_protect_level => x_protect_level,
758: x_custom_level => x_custom_level,

Line 784: Wf_Messages_Pkg.Insert_Row(

780: return;
781: end if;
782:
783: -- Insert new row
784: Wf_Messages_Pkg.Insert_Row(
785: x_rowid => row_id,
786: x_type => x_type,
787: x_name => x_name,
788: x_protect_level => x_protect_level,

Line 2465: from WF_MESSAGES

2461: from WF_ACTIVITIES
2462: where ITEM_TYPE = x_name)
2463: and not exists
2464: (select 1
2465: from WF_MESSAGES
2466: where TYPE = x_name);
2467: exception
2468: when no_data_found then
2469: -- Bad row found. Raise exception back to loader.

Line 2597: from WF_MESSAGES

2593: -- Check protection level
2594: x_level_error := 0;
2595: select PROTECT_LEVEL, CUSTOM_LEVEL
2596: into protection_level, customization_level
2597: from WF_MESSAGES
2598: where TYPE = x_type
2599: and NAME = x_name;
2600:
2601: if ((wf_core.upload_mode <> 'FORCE') and

Line 2638: Wf_Messages_Pkg.Delete_Row(x_type => x_type, x_name => x_name);

2634: -- Bad row found. Raise exception back to loader.
2635: raise fk_violation;
2636: end;
2637:
2638: Wf_Messages_Pkg.Delete_Row(x_type => x_type, x_name => x_name);
2639:
2640: exception
2641: when NO_DATA_FOUND then
2642: null;

Line 2714: from WF_MESSAGES

2710: -- Check protection level
2711: x_level_error := 0;
2712: select PROTECT_LEVEL, CUSTOM_LEVEL
2713: into protection_level, customization_level
2714: from WF_MESSAGES
2715: where TYPE = x_message_type
2716: and NAME = x_message_name;
2717:
2718: if ((wf_core.upload_mode <> 'FORCE') and

Line 3021: from WF_MESSAGES_VL

3017: p_description,
3018: p_subject,
3019: p_body,
3020: p_html_body
3021: from WF_MESSAGES_VL
3022: where TYPE = p_type
3023: and NAME = p_name;
3024:
3025: exception

Line 3092: from WF_MESSAGES_VL

3088: cursor msgcur(itt in varchar2) is
3089: select PROTECT_LEVEL, CUSTOM_LEVEL, NAME, DISPLAY_NAME, DESCRIPTION,
3090: SUBJECT, BODY, DEFAULT_PRIORITY, READ_ROLE, WRITE_ROLE,
3091: HTML_BODY
3092: from WF_MESSAGES_VL
3093: where TYPE = itt
3094: order by TYPE, NAME;
3095:
3096: type t_msgTable is table of WF_MESSAGES.NAME%TYPE

Line 3096: type t_msgTable is table of WF_MESSAGES.NAME%TYPE

3092: from WF_MESSAGES_VL
3093: where TYPE = itt
3094: order by TYPE, NAME;
3095:
3096: type t_msgTable is table of WF_MESSAGES.NAME%TYPE
3097: index by binary_integer;
3098:
3099: v_msg t_msgTable;
3100:

Line 4375: from WF_MESSAGES

4371: p_names out NOCOPY t_nameTab
4372: )is
4373: cursor msgcur is
4374: select NAME
4375: from WF_MESSAGES
4376: where NAME like '%'||p_suffix
4377: and TYPE = p_item_type;
4378:
4379: i pls_integer;

Line 4733: 'WF_MESSAGES',

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',
4735: 'WF_MESSAGE_ATTRIBUTES',
4736: 'WF_MESSAGE_ATTRIBUTES_TL',
4737: 'WF_PROCESS_ACTIVITIES');

Line 4734: 'WF_MESSAGES_TL',

4730: 'WF_ITEM_TYPES_TL',
4731: 'WF_LOOKUPS_TL',
4732: 'WF_LOOKUP_TYPES_TL',
4733: 'WF_MESSAGES',
4734: 'WF_MESSAGES_TL',
4735: 'WF_MESSAGE_ATTRIBUTES',
4736: 'WF_MESSAGE_ATTRIBUTES_TL',
4737: 'WF_PROCESS_ACTIVITIES');
4738: begin