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_HA_MIGRATION dependencies on WF_ITEMS

Line 12: -- Resets the Migration Flags on WF_ITEMS. Performs Commit.

8: -- Procedure
9: -- RESET_HA_FLAGS
10: --
11: -- Purpose
12: -- Resets the Migration Flags on WF_ITEMS. Performs Commit.
13: --
14: -- Arguments: None
15: --
16: Procedure RESET_HA_FLAGS(errbuf out nocopy varchar2, retcode out nocopy number)

Line 24: Update WF_ITEMS

20: Begin
21: errbuf := '';
22: retcode := 0;
23:
24: Update WF_ITEMS
25: Set HA_MIGRATION_FLAG = NULL
26: where HA_MIGRATION_FLAG is not null;
27:
28: Commit;

Line 43: -- Sets the Migration Flag on WF_ITEMS for a particular item.

39: -- Procedure
40: -- SET_HA_FLAG
41: --
42: -- Purpose
43: -- Sets the Migration Flag on WF_ITEMS for a particular item.
44: --
45: -- Arguments:
46: -- Item_Type, Item_Key
47: --

Line 53: Update WF_ITEMS

49:
50: is
51:
52: Begin
53: Update WF_ITEMS
54: Set HA_MIGRATION_FLAG = 'Y'
55: where HA_MIGRATION_FLAG is null
56: and ITEM_TYPE = x_ITEM_TYPE
57: and ITEM_KEY = x_ITEM_KEY;

Line 106: -- Shipped updated items from WF_ITEMS and associated tables to the

102: -- Procedure
103: -- Export Items
104: --
105: -- Purpose
106: -- Shipped updated items from WF_ITEMS and associated tables to the
107: -- maintanence system...continues until no more txns being processed on old
108: -- system, and no more backlog to process.
109: --
110: -- Arguments: None

Line 145: from WF_ITEMS

141: -- worried about not holding locks than about local efficiency
142: begin
143: select ITEM_TYPE, ITEM_KEY
144: into itype, ikey
145: from WF_ITEMS
146: where HA_MIGRATION_FLAG = 'Y'
147: and rownum <2
148: for update of HA_MIGRATION_FLAG;
149:

Line 158: update WF_ITEMS

154: end;
155:
156: if (kount = 1) then
157: /* clear the flag */
158: update WF_ITEMS
159: Set HA_MIGRATION_FLAG = NULL
160: where ITEM_TYPE = itype
161: and ITEM_KEY = ikey;
162:

Line 218: -- Shipped updated items from WF_ITEMS and associated tables to the

214: -- Procedure
215: -- FixSubscriptions
216: --
217: -- Purpose
218: -- Shipped updated items from WF_ITEMS and associated tables to the
219: -- maintanence system...continues until no more txns being processed on old
220: -- system, and no more backlog to process.
221: --
222: -- Arguments: