APPS.WF_LOAD dependencies on WF_MESSAGE_ATTRIBUTES

Line 826: update WF_MESSAGE_ATTRIBUTES set

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

Line 835: update WF_MESSAGE_ATTRIBUTES set

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

Line 844: update WF_MESSAGE_ATTRIBUTES set

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

Line 853: update WF_MESSAGE_ATTRIBUTES set

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

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

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

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

Line 1031: from WF_MESSAGE_ATTRIBUTES

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

Line 1043: Wf_Message_Attributes_Pkg.Insert_Row(

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

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

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

Line 2730: delete from WF_MESSAGE_ATTRIBUTES_TL

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

Line 2734: delete from WF_MESSAGE_ATTRIBUTES

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

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

Line 4735: 'WF_MESSAGE_ATTRIBUTES',

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
4739: for i in WFTable.FIRST..WFTable.LAST loop

Line 4736: 'WF_MESSAGE_ATTRIBUTES_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
4739: for i in WFTable.FIRST..WFTable.LAST loop
4740: l_tem_tab_name := WFTable(i);