DBA Data[Home] [Help]

APPS.WF_LOAD dependencies on WF_MESSAGE_ATTRIBUTES_VL

Line 909: from WF_MESSAGE_ATTRIBUTES_VL

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

Line 922: from WF_MESSAGE_ATTRIBUTES_VL

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

Line 981: from WF_MESSAGE_ATTRIBUTES_VL

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

Line 2665: from WF_MESSAGE_ATTRIBUTES_VL

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

Line 3107: from WF_MESSAGE_ATTRIBUTES_VL

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