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 869: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;

865: select rowid
866: from irc_documents
867: where document_id = p_document_id;
868: --
869: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;
870: cursor csr_user is
871: select oracle_username
872: from fnd_oracle_userid
873: where oracle_id = 800;

Line 872: from fnd_oracle_userid

868: --
869: l_hr_username fnd_oracle_userid.oracle_username%TYPE :=null;
870: cursor csr_user is
871: select oracle_username
872: from fnd_oracle_userid
873: where oracle_id = 800;
874: --
875: l_rowid rowid;
876: --

Line 949: from fnd_oracle_userid

945: function get_html_preview
946: (p_document_id in number,p_highlight_string in varchar2 default null) return clob is
947: cursor get_schema_name is
948: select oracle_username
949: from fnd_oracle_userid
950: where oracle_id = 800;
951:
952: cursor csr_doc_exists is
953: select rowid