DBA Data[Home] [Help]

APPS.FND_AUDIT_UPDATE_PKG dependencies on FND_ORACLE_USERID

Line 18: owner in (select oracle_username from fnd_oracle_userid);

14: cursor l_get_owner_csr(c_tabname varchar2) is
15: select owner from
16: dba_tables where
17: table_name = c_tabname and
18: owner in (select oracle_username from fnd_oracle_userid);
19:
20: cursor l_get_tab_columns_csr(c_tabname varchar2, c_owner varchar2) is
21: select column_name from dba_tab_columns where
22: column_name <> 'ROW_KEY' and column_id > 7 and

Line 48: v_fnd_schema fnd_oracle_userid.oracle_username%TYPE;

44: v_updatetable varchar2(2000);
45: tcount number;
46: toldcount number;
47:
48: v_fnd_schema fnd_oracle_userid.oracle_username%TYPE;
49: v_ddl_sql varchar2(240);
50: app_short_name varchar2(51);
51:
52:

Line 83: fnd_oracle_userid fou,

79:
80: -- First get the FND schema name
81: SELECT fou.oracle_username into v_fnd_schema
82: FROM fnd_product_installations fpi,
83: fnd_oracle_userid fou,
84: fnd_application fa
85: WHERE fpi.application_id = fa.application_id
86: AND fpi.oracle_id = fou.oracle_id
87: AND fa.application_short_name = 'FND';