DBA Data[Home] [Help]

APPS.WF_EVENT_SYNCHRONIZE_PKG dependencies on WF_RESOURCES

Line 1210: ** UpdateGUID- Update GUID in WF_RESOURCES table

1206: 'ERROR'); raise;*/
1207: end;
1208: ------------------------------------------------------------------------------
1209: /*
1210: ** UpdateGUID- Update GUID in WF_RESOURCES table
1211: ** returns varchar2
1212: ** Parameters:
1213: */
1214: procedure UpdateGUID (

Line 1226: update WF_RESOURCES

1222: select count(*)
1223: into l_count
1224: from WF_SYSTEMS;
1225: if (l_count = 0) then
1226: update WF_RESOURCES
1227: set text=g_guid
1228: where name='WF_SYSTEM_GUID';
1229: end if;
1230: end if;

Line 1862: WFTable TableName:=TableName ('WF_RESOURCES',

1858: l_package_name varchar2(30) := 'WF_EVENT_SYNCHRONIZE_PKG';
1859: l_module_name varchar2(30) := 'Prepare_Zero_Down_Time';
1860: l_tem_tab_name varchar2(50);
1861: TYPE TableName is VARRAY(8) OF VARCHAR2(50);
1862: WFTable TableName:=TableName ('WF_RESOURCES',
1863: 'WF_SYSTEMS',
1864: 'WF_AGENTS',
1865: 'WF_AGENT_GROUPS',
1866: 'WF_EVENTS',