DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 908: from WF_MESSAGE_ATTRIBUTES_VL

904: begin
905: -- l_name will be the old data to update
906: select MESSAGE_TYPE||':'||MESSAGE_NAME||':'||NAME, DISPLAY_NAME, NAME
907: into conflict_name, l_dname, l_name
908: from WF_MESSAGE_ATTRIBUTES_VL
909: where DISPLAY_NAME = n_dname
910: and MESSAGE_TYPE = x_message_type
911: and MESSAGE_NAME = x_message_name
912: and NAME <> x_name;

Line 921: from WF_MESSAGE_ATTRIBUTES_VL

917: loop
918: begin
919: select MESSAGE_TYPE||':'||MESSAGE_NAME||':'||NAME, DISPLAY_NAME
920: into conflict_name, l_dname
921: from WF_MESSAGE_ATTRIBUTES_VL
922: where DISPLAY_NAME = n_dname
923: and MESSAGE_TYPE = x_message_type
924: and MESSAGE_NAME = x_message_name
925: and NAME <> l_name;

Line 980: from WF_MESSAGE_ATTRIBUTES_VL

976: x_level_error := 0;
977: begin
978: select PROTECT_LEVEL, CUSTOM_LEVEL, SEQUENCE
979: into protection_level, customization_level, old_sequence
980: from WF_MESSAGE_ATTRIBUTES_VL
981: where MESSAGE_TYPE = x_message_type
982: and MESSAGE_NAME = x_message_name
983: and NAME = x_name;
984:

Line 2664: from WF_MESSAGE_ATTRIBUTES_VL

2660: -- Check protection level
2661: x_level_error := 0;
2662: select PROTECT_LEVEL, CUSTOM_LEVEL
2663: into protection_level, customization_level
2664: from WF_MESSAGE_ATTRIBUTES_VL
2665: where MESSAGE_TYPE = x_message_type
2666: and MESSAGE_NAME = x_message_name
2667: and NAME = x_name;
2668:

Line 3106: from WF_MESSAGE_ATTRIBUTES_VL

3102: TYPE, SUBTYPE, FORMAT, TEXT_DEFAULT,
3103: to_char(NUMBER_DEFAULT) NUMBER_DEFAULT,
3104: to_char(DATE_DEFAULT, 'YYYY/MM/DD HH24:MI:SS') DATE_DEFAULT,
3105: VALUE_TYPE, ATTACH, SEQUENCE
3106: from WF_MESSAGE_ATTRIBUTES_VL
3107: where MESSAGE_TYPE = itt and MESSAGE_NAME = msg
3108: order by SEQUENCE;
3109:
3110: cursor actcur(itt in varchar2) is