APPS.WF_LOAD dependencies on WF_MESSAGES

Line 736: from WF_MESSAGES_VL

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

Line 753: Wf_Messages_Pkg.Update_Row(

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

Line 783: Wf_Messages_Pkg.Insert_Row(

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

Line 2464: from WF_MESSAGES

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

Line 2596: from WF_MESSAGES

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

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

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

Line 2713: from WF_MESSAGES

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

Line 3020: from WF_MESSAGES_VL

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

Line 3091: from WF_MESSAGES_VL

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

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

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

Line 4374: from WF_MESSAGES

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