APPS.WF_MAINTENANCE dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 202: from wf_item_attribute_values wiav, wf_item_attributes wia

198: and WI.END_DATE IS NULL));
199:
200: cursor cRoleAttributes (l_oldname varchar2) is
201: select wiav.rowid
202: from wf_item_attribute_values wiav, wf_item_attributes wia
203: where wia.type = 'ROLE'
204: and wia.item_type = wiav.item_type
205: and wia.name = wiav.name
206: and wiav.text_value = l_oldname;

Line 210: from wf_item_attribute_values wiav, wf_item_attributes wia

206: and wiav.text_value = l_oldname;
207:
208: cursor cRoleAttributes2 (l_oldname varchar2) is
209: select wiav.rowid
210: from wf_item_attribute_values wiav, wf_item_attributes wia
211: where wia.type = 'ROLE'
212: and wia.item_type = wiav.item_type
213: and wia.name = wiav.name
214: and wiav.text_value = l_oldname

Line 399: update WF_ITEM_ATTRIBUTE_VALUES

395: exit;
396: end if;
397:
398: forall i in rowIdTbl.first..rowIdTbl.last
399: update WF_ITEM_ATTRIBUTE_VALUES
400: set TEXT_VALUE = l_newname
401: where rowid = rowIdTbl(i);
402: commit;
403:

Line 527: update WF_ITEM_ATTRIBUTE_VALUES

523: exit;
524: end if;
525:
526: forall i in rowIdTbl.first..rowIdTbl.last
527: update WF_ITEM_ATTRIBUTE_VALUES
528: set TEXT_VALUE = l_newname
529: where rowid = rowIdTbl(i);
530: commit;
531:

Line 2194: -- Determine rows to change in WF_ITEM_ATTRIBUTE_VALUES. Can be any role.

2190: end if;
2191: l_wfcount_tab.TABLE_NAME := 'WF_COMMENTS';
2192: pipe ROW (l_wfcount_tab);
2193:
2194: -- Determine rows to change in WF_ITEM_ATTRIBUTE_VALUES. Can be any role.
2195: if (l_pvalue is null or l_pvalue = 'Y') then
2196: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2197: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA
2198: where WIA.type = 'ROLE'

Line 2197: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA

2193:
2194: -- Determine rows to change in WF_ITEM_ATTRIBUTE_VALUES. Can be any role.
2195: if (l_pvalue is null or l_pvalue = 'Y') then
2196: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2197: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA
2198: where WIA.type = 'ROLE'
2199: and WIA.ITEM_TYPE = WIAV.ITEM_TYPE
2200: and WIA.NAME = WIAV.NAME
2201: and WIAV.TEXT_VALUE = p_name;

Line 2204: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA

2200: and WIA.NAME = WIAV.NAME
2201: and WIAV.TEXT_VALUE = p_name;
2202: else
2203: select nvl(count(1), 0) into l_wfcount_tab.REC_CNT
2204: from WF_ITEM_ATTRIBUTE_VALUES WIAV, WF_ITEM_ATTRIBUTES WIA
2205: where WIA.type = 'ROLE'
2206: and WIA.ITEM_TYPE = WIAV.ITEM_TYPE
2207: and WIA.NAME = WIAV.NAME
2208: and WIAV.TEXT_VALUE = p_name

Line 2215: l_wfcount_tab.TABLE_NAME := 'WF_ITEM_ATTRIBUTE_VALUES';

2211: where WI.ITEM_TYPE=WIAV.ITEM_TYPE
2212: and WI.ITEM_KEY=WIAV.ITEM_KEY
2213: and WI.END_DATE is null);
2214: end if;
2215: l_wfcount_tab.TABLE_NAME := 'WF_ITEM_ATTRIBUTE_VALUES';
2216: pipe ROW (l_wfcount_tab);
2217:
2218: -- Now check what happens with the WFDS tables:
2219: WF_DIRECTORY.assignPartition(l_roleInfoTAB(1).ORIG_SYSTEM, l_partitionID, l_partitionName);