DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_RESOURCES

Line 2973: from WF_RESOURCES

2969:
2970: begin
2971: select to_date(text, WF_CORE.canonical_date_mask)
2972: into l_UpdateTime
2973: from WF_RESOURCES
2974: where TYPE='WFTKN'
2975: and NAME = 'WFDS_HIERARCHY_UPD'
2976: and LANGUAGE = 'US';
2977:

Line 3006: update WF_RESOURCES

3002: PRAGMA AUTONOMOUS_TRANSACTION;
3003:
3004: begin
3005: g_trustTimeStamp := sysdate;
3006: update WF_RESOURCES
3007: set text = to_char(g_trustTimeStamp, WF_CORE.canonical_date_mask)
3008: where name = 'WFDS_HIERARCHY_UPD';
3009:
3010: if (sql%rowcount = 0) then

Line 3012: insert into WF_RESOURCES (TYPE,

3008: where name = 'WFDS_HIERARCHY_UPD';
3009:
3010: if (sql%rowcount = 0) then
3011: begin
3012: insert into WF_RESOURCES (TYPE,
3013: NAME,
3014: LANGUAGE,
3015: SOURCE_LANG,
3016: ID,