APPS.WF_MAINTENANCE dependencies on WF_MAINTENANCE

Line 1: package body WF_MAINTENANCE as

1: package body WF_MAINTENANCE as
2: /* $Header: wfmtn9b.pls 120.20.12020000.2 2012/07/13 20:42:04 alsosa ship $ */
3:
4: g_CommitCounter NUMBER := 0;
5: g_docommit BOOLEAN := FALSE;

Line 236: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_maintenance.propagateChangedName',

232: l_newname := upper(substrb(NewName,1,320));
233: l_oldname := upper(substrb(OldName,1,320));
234:
235: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then
236: wf_log_pkg.string(wf_log_pkg.level_procedure, 'wf.plsql.wf_maintenance.propagateChangedName',
237: 'Changing old user '||l_oldname||' to new '||l_newname);
238: end if;
239:
240: g_docommit := docommit;

Line 284: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

280: -- available, continue to update all records as always.
281: if (l_pvalue is null or l_pvalue = 'Y') then
282:
283: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
284: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
285: 'Updating all WF data');
286: end if;
287:
288: open cItems(l_oldname);

Line 412: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

408:
409: else -- End profile = 'Y'
410:
411: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
412: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
413: 'Updating only Active WF data');
414: end if;
415:
416: open cItems2(l_oldname);

Line 624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

620: l_wa := cWorklistAccess%ROWCOUNT;
621: CLOSE cWorklistAccess;
622:
623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr

Line 627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',

623: if (wf_log_pkg.level_statement >= fnd_log.g_current_runtime_level) then
624: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
625: 'Updated Records: WF_ITEMS:'||l_items||', WF_IAS:'||l_ias||', WF_IASH:'
626: ||l_iash||', WF_NTFS:'||l_ntfs||', WF_COMMENTS:'||l_coms);
627: wf_log_pkg.string(wf_log_pkg.level_statement, 'wf.plsql.wf_maintenance.propagateChangedName',
628: 'Updated Records: WF_PROC_ACTS:'||l_pas||', WF_ROUTING_RULES:'||l_rr
629: ||', WF_ROUTING_RULE_ATTRS:' ||l_rra||', WF_ITEM_ATTR_VALUES:'||l_ra
630: ||', WORKLIST_ACCESS:'||l_wa);
631: end if;

Line 635: WF_CORE.Context('WF_MAINTENANCE', 'PropagateChangedName', OldName, NewName);

631: end if;
632:
633: exception
634: when others then
635: WF_CORE.Context('WF_MAINTENANCE', 'PropagateChangedName', OldName, NewName);
636: raise;
637: end PropagateChangedName;
638:
639: -- procedure PerformCommit (private)

Line 651: if (g_commitCounter >= WF_MAINTENANCE.g_CommitFrequency) then

647: IS
648: BEGIN
649: if (g_docommit) then
650: g_commitCounter := g_commitCounter +1;
651: if (g_commitCounter >= WF_MAINTENANCE.g_CommitFrequency) then
652: commit;
653: g_commitCounter := 0;
654: end if;
655: end if;

Line 1088: l_modulePkg varchar2(240) := 'WF_MAINTENANCE.ValidateUserRoles';

1084: )
1085: );
1086:
1087:
1088: l_modulePkg varchar2(240) := 'WF_MAINTENANCE.ValidateUserRoles';
1089:
1090: begin
1091: -- Log only
1092: -- BINDVAR_SCAN_IGNORE[2]

Line 1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);

1100: end if;
1101:
1102: -- Acquire a session lock to ensure that only one instance of the program is
1103: -- running at a time.
1104: dbms_lock.allocate_unique('WF_MAINTENANCE.ValidateUserRoles',l_lockhandle);
1105:
1106: if (dbms_lock.request(lockhandle=>l_lockhandle,
1107: lockmode=>dbms_lock.x_mode,
1108: timeout=>0) <> 0) then

Line 2280: end WF_MAINTENANCE;

2276: when others then
2277: return;
2278: end GetUsernameChangeCounts;
2279:
2280: end WF_MAINTENANCE;