eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_LOAD dependencies on WF_MESSAGE_ATTRIBUTES

Line 825: update WF_MESSAGE_ATTRIBUTES set

821: newseq in number)
822: is
823: begin
824: -- Move attr being updated to a placeholder out of the way.
825: update WF_MESSAGE_ATTRIBUTES set
826: SEQUENCE = -1
827: where MESSAGE_TYPE = msgtype
828: and MESSAGE_NAME = msgname
829: and SEQUENCE = oldseq;

Line 834: update WF_MESSAGE_ATTRIBUTES set

830:
831: if (oldseq < newseq) then
832: -- Move attrs DOWN in sequence to make room at higher position
833: for i in (oldseq + 1) .. newseq loop
834: update WF_MESSAGE_ATTRIBUTES set
835: SEQUENCE = SEQUENCE - 1
836: where MESSAGE_TYPE = msgtype
837: and MESSAGE_NAME = msgname
838: and SEQUENCE = i;

Line 843: update WF_MESSAGE_ATTRIBUTES set

839: end loop;
840: elsif (oldseq > newseq) then
841: -- Move attrs UP in sequence to make room at lower position
842: for i in reverse newseq .. (oldseq - 1) loop
843: update WF_MESSAGE_ATTRIBUTES set
844: SEQUENCE = SEQUENCE + 1
845: where MESSAGE_TYPE = msgtype
846: and MESSAGE_NAME = msgname
847: and SEQUENCE = i;

Line 852: update WF_MESSAGE_ATTRIBUTES set

848: end loop;
849: end if;
850:
851: -- Move attr being updated into new sequence position
852: update WF_MESSAGE_ATTRIBUTES set
853: SEQUENCE = newseq
854: where MESSAGE_TYPE = msgtype
855: and MESSAGE_NAME = msgname
856: and SEQUENCE = -1;

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 946: -- update WF_MESSAGE_ATTRIBUTES_TL

942:
943: -- ### No need to do this
944: -- update the old data with the new display name
945: -- begin
946: -- update WF_MESSAGE_ATTRIBUTES_TL
947: -- set display_name = n_dname
948: -- where MESSAGE_TYPE = x_message_type
949: -- and MESSAGE_NAME = x_message_name
950: -- 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 1006: Wf_Message_Attributes_Pkg.Update_Row(

1002: oldseq => old_sequence,
1003: newseq => x_sequence);
1004: end if;
1005:
1006: Wf_Message_Attributes_Pkg.Update_Row(
1007: x_message_type => x_message_type,
1008: x_message_name => x_message_name,
1009: x_name => x_name,
1010: x_sequence => x_sequence,

Line 1030: from WF_MESSAGE_ATTRIBUTES

1026: -- Resequence attrs so that everything below the attr being
1027: -- inserted is shoved out of the way.
1028: select nvl(max(SEQUENCE), -1)+1
1029: into old_sequence
1030: from WF_MESSAGE_ATTRIBUTES
1031: where MESSAGE_TYPE = x_message_type
1032: and MESSAGE_NAME = x_message_name;
1033:
1034: if (old_sequence <> x_sequence) then

Line 1042: Wf_Message_Attributes_Pkg.Insert_Row(

1038: oldseq => old_sequence,
1039: newseq => x_sequence);
1040: end if;
1041:
1042: Wf_Message_Attributes_Pkg.Insert_Row(
1043: x_rowid => row_id,
1044: x_message_type => x_message_type,
1045: x_message_name => x_message_name,
1046: x_name => x_name,

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 2681: Wf_Message_Attributes_Pkg.Delete_Row(

2677: x_level_error := 2;
2678: return;
2679: end if;
2680:
2681: Wf_Message_Attributes_Pkg.Delete_Row(
2682: x_message_type => x_message_type,
2683: x_message_name => x_message_name,
2684: x_name => x_name);
2685:

Line 2729: delete from WF_MESSAGE_ATTRIBUTES_TL

2725: x_level_error := 2;
2726: return;
2727: end if;
2728:
2729: delete from WF_MESSAGE_ATTRIBUTES_TL
2730: where MESSAGE_TYPE = x_message_type
2731: and MESSAGE_NAME = x_message_name;
2732:
2733: delete from WF_MESSAGE_ATTRIBUTES

Line 2733: delete from WF_MESSAGE_ATTRIBUTES

2729: delete from WF_MESSAGE_ATTRIBUTES_TL
2730: where MESSAGE_TYPE = x_message_type
2731: and MESSAGE_NAME = x_message_name;
2732:
2733: delete from WF_MESSAGE_ATTRIBUTES
2734: where MESSAGE_TYPE = x_message_type
2735: and MESSAGE_NAME = x_message_name;
2736:
2737: exception

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