APPS.WF_LOAD dependencies on WF_ACTIVITY_ATTRIBUTES

Line 1516: update WF_ACTIVITY_ATTRIBUTES set

1512: newseq in number)
1513: is
1514: begin
1515: -- Move attr being updated to a placeholder out of the way.
1516: update WF_ACTIVITY_ATTRIBUTES set
1517: SEQUENCE = -1
1518: where ACTIVITY_ITEM_TYPE = acttype
1519: and ACTIVITY_NAME = actname
1520: and ACTIVITY_VERSION = actver

Line 1526: update WF_ACTIVITY_ATTRIBUTES set

1522:
1523: if (oldseq < newseq) then
1524: -- Move attrs DOWN in sequence to make room at higher position
1525: for i in (oldseq + 1) .. newseq loop
1526: update WF_ACTIVITY_ATTRIBUTES set
1527: SEQUENCE = SEQUENCE - 1
1528: where ACTIVITY_ITEM_TYPE = acttype
1529: and ACTIVITY_NAME = actname
1530: and ACTIVITY_VERSION = actver

Line 1536: update WF_ACTIVITY_ATTRIBUTES set

1532: end loop;
1533: elsif (oldseq > newseq) then
1534: -- Move attrs UP in sequence to make room at lower position
1535: for i in reverse newseq .. (oldseq - 1) loop
1536: update WF_ACTIVITY_ATTRIBUTES set
1537: SEQUENCE = SEQUENCE + 1
1538: where ACTIVITY_ITEM_TYPE = acttype
1539: and ACTIVITY_NAME = actname
1540: and ACTIVITY_VERSION = actver

Line 1546: update WF_ACTIVITY_ATTRIBUTES set

1542: end loop;
1543: end if;
1544:
1545: -- Move attr being updated into new sequence position
1546: update WF_ACTIVITY_ATTRIBUTES set
1547: SEQUENCE = newseq
1548: where ACTIVITY_ITEM_TYPE = acttype
1549: and ACTIVITY_NAME = actname
1550: and ACTIVITY_VERSION = actver

Line 1605: from WF_ACTIVITY_ATTRIBUTES_VL

1601: x_level_error := 0;
1602: begin
1603: select PROTECT_LEVEL, CUSTOM_LEVEL, SEQUENCE
1604: into protection_level, customization_level, old_sequence
1605: from WF_ACTIVITY_ATTRIBUTES_VL
1606: where ACTIVITY_ITEM_TYPE = x_activity_item_type
1607: and ACTIVITY_NAME = x_activity_name
1608: and ACTIVITY_VERSION = x_activity_version
1609: and NAME = x_name;

Line 1634: Wf_Activity_Attributes_Pkg.Update_Row(

1630: newseq => x_sequence);
1631: end if;
1632:
1633: -- Update existing row
1634: Wf_Activity_Attributes_Pkg.Update_Row(
1635: x_activity_item_type => x_activity_item_type,
1636: x_activity_name => x_activity_name,
1637: x_activity_version => x_activity_version,
1638: x_name => x_name,

Line 1672: from WF_ACTIVITY_ATTRIBUTES

1668: -- Resequence attrs so that everything below the attr being
1669: -- inserted is shoved out of the way.
1670: select nvl(max(SEQUENCE), -1)+1
1671: into old_sequence
1672: from WF_ACTIVITY_ATTRIBUTES
1673: where ACTIVITY_ITEM_TYPE = x_activity_item_type
1674: and ACTIVITY_NAME = x_activity_name
1675: and ACTIVITY_VERSION = x_activity_version;
1676:

Line 1687: Wf_Activity_Attributes_Pkg.Insert_Row(

1683: newseq => x_sequence);
1684: end if;
1685:
1686: -- Insert new row
1687: Wf_Activity_Attributes_Pkg.Insert_Row(
1688: x_rowid => row_id,
1689: x_activity_item_type => x_activity_item_type,
1690: x_activity_name => x_activity_name,
1691: x_activity_version => x_activity_version,

Line 2034: WF_ACTIVITY_ATTRIBUTES WAA

2030: begin
2031: select WAA.TYPE
2032: into l_type
2033: from WF_PROCESS_ACTIVITIES WPA, WF_ACTIVITIES WA,
2034: WF_ACTIVITY_ATTRIBUTES WAA
2035: where WPA.INSTANCE_ID = x_process_activity_id
2036: and WPA.ACTIVITY_ITEM_TYPE = WA.ITEM_TYPE
2037: and WPA.ACTIVITY_NAME = WA.NAME
2038: and x_effective_date >= WA.BEGIN_DATE

Line 3138: from WF_ACTIVITY_ATTRIBUTES_VL

3134: TYPE, SUBTYPE, FORMAT, TEXT_DEFAULT,
3135: to_char(NUMBER_DEFAULT) NUMBER_DEFAULT,
3136: to_char(DATE_DEFAULT, 'YYYY/MM/DD HH24:MI:SS') DATE_DEFAULT,
3137: VALUE_TYPE, SEQUENCE
3138: from WF_ACTIVITY_ATTRIBUTES_VL
3139: where ACTIVITY_ITEM_TYPE = itt
3140: and ACTIVITY_NAME = actname
3141: and ACTIVITY_VERSION = ver
3142: order by SEQUENCE;