APPS.IRC_DOCUMENT_API dependencies on FND_ORACLE_USERID

Line 17: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;

13: -- ----------------------------------------------------------------------------
14: Procedure synchronize_index(p_mode in varchar2)
15: is
16: l_proc varchar2(72) := g_package||'synchronize_index';
17: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
18: cursor csr_user is
19: select oracle_username
20: from fnd_oracle_userid
21: where oracle_id = 800;

Line 20: from fnd_oracle_userid

16: l_proc varchar2(72) := g_package||'synchronize_index';
17: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null ;
18: cursor csr_user is
19: select oracle_username
20: from fnd_oracle_userid
21: where oracle_id = 800;
22: begin
23: hr_utility.set_location('Entering:'|| l_proc, 10);
24: open csr_user;

Line 893: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;

889: select rowid
890: from irc_documents
891: where document_id = p_document_id;
892: --
893: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;
894: cursor csr_user is
895: select oracle_username
896: from fnd_oracle_userid
897: where oracle_id = 800;

Line 896: from fnd_oracle_userid

892: --
893: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;
894: cursor csr_user is
895: select oracle_username
896: from fnd_oracle_userid
897: where oracle_id = 800;
898: --
899: l_rowid rowid;
900: --

Line 973: from fnd_oracle_userid

969: function get_html_preview
970: (p_document_id in number,p_highlight_string in varchar2 default null) return clob is
971: cursor get_schema_name is
972: select oracle_username
973: from fnd_oracle_userid
974: where oracle_id = 800;
975:
976: cursor csr_doc_exists is
977: select rowid