DBA Data[Home] [Help]

APPS.WF_CORE dependencies on FND_GLOBAL

Line 1046: if (FND_GLOBAL.user_name is null OR FND_GLOBAL.resp_id is null) then

1042: pos3 := instr(l_module, ':', 1, 3);
1043: l_module_type := substr(l_module, pos2+1, pos3-pos2-1);
1044: l_module_name := substr(l_module, pos3+1, length(l_module));
1045:
1046: if (FND_GLOBAL.user_name is null OR FND_GLOBAL.resp_id is null) then
1047: -- Context is not set
1048: l_application_name := 'fnd';
1049: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2, :3); END;';
1050: execute immediate sql_stm using p_module_type, p_action, l_application_name;

Line 1049: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2, :3); END;';

1045:
1046: if (FND_GLOBAL.user_name is null OR FND_GLOBAL.resp_id is null) then
1047: -- Context is not set
1048: l_application_name := 'fnd';
1049: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2, :3); END;';
1050: execute immediate sql_stm using p_module_type, p_action, l_application_name;
1051: elsif (l_module_type <> p_module_type OR l_module_name <> p_action) then
1052: -- Different application process or item type in session
1053: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2); END;';

Line 1053: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2); END;';

1049: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2, :3); END;';
1050: execute immediate sql_stm using p_module_type, p_action, l_application_name;
1051: elsif (l_module_type <> p_module_type OR l_module_name <> p_action) then
1052: -- Different application process or item type in session
1053: sql_stm := 'BEGIN FND_GLOBAL.TAG_DB_SESSION(:1, :2); END;';
1054: execute immediate sql_stm using p_module_type, p_action;
1055: end if;
1056: exception
1057: when others then