[Home] [Help]
1513: newseq in number)
1514: is
1515: begin
1516: -- Move attr being updated to a placeholder out of the way.
1517: update WF_ACTIVITY_ATTRIBUTES set
1518: SEQUENCE = -1
1519: where ACTIVITY_ITEM_TYPE = acttype
1520: and ACTIVITY_NAME = actname
1521: and ACTIVITY_VERSION = actver
1523:
1524: if (oldseq < newseq) then
1525: -- Move attrs DOWN in sequence to make room at higher position
1526: for i in (oldseq + 1) .. newseq loop
1527: update WF_ACTIVITY_ATTRIBUTES set
1528: SEQUENCE = SEQUENCE - 1
1529: where ACTIVITY_ITEM_TYPE = acttype
1530: and ACTIVITY_NAME = actname
1531: and ACTIVITY_VERSION = actver
1533: end loop;
1534: elsif (oldseq > newseq) then
1535: -- Move attrs UP in sequence to make room at lower position
1536: for i in reverse newseq .. (oldseq - 1) loop
1537: update WF_ACTIVITY_ATTRIBUTES set
1538: SEQUENCE = SEQUENCE + 1
1539: where ACTIVITY_ITEM_TYPE = acttype
1540: and ACTIVITY_NAME = actname
1541: and ACTIVITY_VERSION = actver
1543: end loop;
1544: end if;
1545:
1546: -- Move attr being updated into new sequence position
1547: update WF_ACTIVITY_ATTRIBUTES set
1548: SEQUENCE = newseq
1549: where ACTIVITY_ITEM_TYPE = acttype
1550: and ACTIVITY_NAME = actname
1551: and ACTIVITY_VERSION = actver
1602: x_level_error := 0;
1603: begin
1604: select PROTECT_LEVEL, CUSTOM_LEVEL, SEQUENCE
1605: into protection_level, customization_level, old_sequence
1606: from WF_ACTIVITY_ATTRIBUTES_VL
1607: where ACTIVITY_ITEM_TYPE = x_activity_item_type
1608: and ACTIVITY_NAME = x_activity_name
1609: and ACTIVITY_VERSION = x_activity_version
1610: and NAME = x_name;
1631: newseq => x_sequence);
1632: end if;
1633:
1634: -- Update existing row
1635: Wf_Activity_Attributes_Pkg.Update_Row(
1636: x_activity_item_type => x_activity_item_type,
1637: x_activity_name => x_activity_name,
1638: x_activity_version => x_activity_version,
1639: x_name => x_name,
1669: -- Resequence attrs so that everything below the attr being
1670: -- inserted is shoved out of the way.
1671: select nvl(max(SEQUENCE), -1)+1
1672: into old_sequence
1673: from WF_ACTIVITY_ATTRIBUTES
1674: where ACTIVITY_ITEM_TYPE = x_activity_item_type
1675: and ACTIVITY_NAME = x_activity_name
1676: and ACTIVITY_VERSION = x_activity_version;
1677:
1684: newseq => x_sequence);
1685: end if;
1686:
1687: -- Insert new row
1688: Wf_Activity_Attributes_Pkg.Insert_Row(
1689: x_rowid => row_id,
1690: x_activity_item_type => x_activity_item_type,
1691: x_activity_name => x_activity_name,
1692: x_activity_version => x_activity_version,
2031: begin
2032: select WAA.TYPE
2033: into l_type
2034: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,
2035: WF_ACTIVITY_ATTRIBUTES WAA
2036: where WPA.INSTANCE_ID = x_process_activity_id
2037: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2038: and WPA.ACTIVITY_NAME = WA.NAME
2039: and x_effective_date >= WA.BEGIN_DATE
3135: TYPE, SUBTYPE, FORMAT, TEXT_DEFAULT,
3136: to_char(NUMBER_DEFAULT) NUMBER_DEFAULT,
3137: to_char(DATE_DEFAULT, 'YYYY/MM/DD HH24:MI:SS') DATE_DEFAULT,
3138: VALUE_TYPE, SEQUENCE
3139: from WF_ACTIVITY_ATTRIBUTES_VL
3140: where ACTIVITY_ITEM_TYPE = itt
3141: and ACTIVITY_NAME = actname
3142: and ACTIVITY_VERSION = ver
3143: order by SEQUENCE;
4719: l_tem_tab_name varchar2(50);
4720: TYPE TableName is VARRAY(17) OF VARCHAR2(50);
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',
4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4720: TYPE TableName is VARRAY(17) OF VARCHAR2(50);
4721: WFTable TableName:=TableName ('WF_ACTIVITIES',
4722: 'WF_ACTIVITIES_TL',
4723: 'WF_ACTIVITY_ATTRIBUTES',
4724: 'WF_ACTIVITY_ATTRIBUTES_TL',
4725: 'WF_ACTIVITY_ATTR_VALUES',
4726: 'WF_ACTIVITY_TRANSITIONS',
4727: 'WF_ITEM_ATTRIBUTES',
4728: 'WF_ITEM_ATTRIBUTES_TL',