DBA Data[Home] [Help]

APPS.PO_WF_FUN dependencies on FND_ORACLE_USERID

Line 32: l_apps_schema_name fnd_oracle_userid.oracle_username%type; --bug4025028

28: x_text varchar2(300);
29: x_temp varchar2(300) :=x_item_type;
30: x_item_type_name varchar2(200);
31: x_function_name varchar2(200);
32: l_apps_schema_name fnd_oracle_userid.oracle_username%type; --bug4025028
33:
34: BEGIN
35:
36: if (x_item_type like 'ALL') then

Line 45: FROM fnd_oracle_userid

41: -- This value would be used in queries below instead of using hardcoded 'APPS'
42: BEGIN
43: SELECT oracle_username
44: INTO l_apps_schema_name
45: FROM fnd_oracle_userid
46: WHERE read_only_flag = 'U';
47: EXCEPTION
48: WHEN OTHERS THEN
49: RAISE;