DBA Data[Home] [Help]

APPS.WF_ROLE_HIERARCHY dependencies on WF_RESOURCES

Line 2933: from WF_RESOURCES

2929:
2930: begin
2931: select to_date(text, WF_CORE.canonical_date_mask)
2932: into l_UpdateTime
2933: from WF_RESOURCES
2934: where TYPE='WFTKN'
2935: and NAME = 'WFDS_HIERARCHY_UPD'
2936: and LANGUAGE = 'US';
2937:

Line 2966: update WF_RESOURCES

2962: PRAGMA AUTONOMOUS_TRANSACTION;
2963:
2964: begin
2965: g_trustTimeStamp := sysdate;
2966: update WF_RESOURCES
2967: set text = to_char(g_trustTimeStamp, WF_CORE.canonical_date_mask)
2968: where name = 'WFDS_HIERARCHY_UPD';
2969:
2970: if (sql%rowcount = 0) then

Line 2972: insert into WF_RESOURCES (TYPE,

2968: where name = 'WFDS_HIERARCHY_UPD';
2969:
2970: if (sql%rowcount = 0) then
2971: begin
2972: insert into WF_RESOURCES (TYPE,
2973: NAME,
2974: LANGUAGE,
2975: SOURCE_LANG,
2976: ID,