eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_DOCUMENT_API dependencies on IRC_DOCUMENTS

Line 33: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1'

29: if p_mode = g_full_mode
30: then
31: hr_utility.set_location(l_proc, 20);
32: ad_ctx_ddl.optimize_index
33: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1'
34: ,optlevel=>'FULL'
35: ,maxtime=>null
36: ,token=>null);
37: elsif p_mode = g_online_mode

Line 41: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1');

37: elsif p_mode = g_online_mode
38: then
39: hr_utility.set_location(l_proc, 30);
40: ad_ctx_ddl.sync_index
41: (idx_name=>l_hr_username||'.IRC_DOCUMENTS_CTX1');
42: elsif p_mode = g_none_mode
43: then
44: hr_utility.set_location(l_proc, 35);
45: end if;

Line 216: l_new_doc_id irc_documents.document_id%type;

212: --
213: l_proc varchar2(72) := g_package||'CREATE_DOCUMENT';
214: l_effective_date date;
215: l_object_version_number number(9);
216: l_new_doc_id irc_documents.document_id%type;
217: l_party_id irc_documents.party_id%type;
218: l_assignment_id irc_documents.assignment_id%type;
219: l_person_id irc_documents.person_id%type;
220: l_end_date date;

Line 217: l_party_id irc_documents.party_id%type;

213: l_proc varchar2(72) := g_package||'CREATE_DOCUMENT';
214: l_effective_date date;
215: l_object_version_number number(9);
216: l_new_doc_id irc_documents.document_id%type;
217: l_party_id irc_documents.party_id%type;
218: l_assignment_id irc_documents.assignment_id%type;
219: l_person_id irc_documents.person_id%type;
220: l_end_date date;
221:

Line 218: l_assignment_id irc_documents.assignment_id%type;

214: l_effective_date date;
215: l_object_version_number number(9);
216: l_new_doc_id irc_documents.document_id%type;
217: l_party_id irc_documents.party_id%type;
218: l_assignment_id irc_documents.assignment_id%type;
219: l_person_id irc_documents.person_id%type;
220: l_end_date date;
221:
222:

Line 219: l_person_id irc_documents.person_id%type;

215: l_object_version_number number(9);
216: l_new_doc_id irc_documents.document_id%type;
217: l_party_id irc_documents.party_id%type;
218: l_assignment_id irc_documents.assignment_id%type;
219: l_person_id irc_documents.person_id%type;
220: l_end_date date;
221:
222:
223: --

Line 231: from irc_documents

227: select
228: party_id,
229: assignment_id,
230: person_id
231: from irc_documents
232: where document_id = p_document_id;
233:
234: l_doc_record csr_document_record%ROWTYPE;
235:

Line 385: l_end_date date; --to populate end_date in irc_documents table for internet applicants

381: l_object_version_number number(9);
382: --
383: l_job_appln number := 0;
384: --
385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;

Line 387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;

383: l_job_appln number := 0;
384: --
385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;

Line 388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;

384: --
385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;

Line 389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;

385: l_end_date date; --to populate end_date in irc_documents table for internet applicants
386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);

Line 390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;

386: --
387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);
394:

Line 391: l_new_doc_id irc_documents.document_id%type;

387: l_mime_type irc_documents.mime_type%type := HR_API.G_VARCHAR2;
388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);
394:
395:

Line 392: l_doc_id irc_documents.document_id%type;

388: l_type irc_documents.type%type := HR_API.G_VARCHAR2;
389: l_file_name irc_documents.file_name%type := HR_API.G_VARCHAR2;
390: l_description irc_documents.description%type := HR_API.G_VARCHAR2;
391: l_new_doc_id irc_documents.document_id%type;
392: l_doc_id irc_documents.document_id%type;
393: l_obj_version_number number(9);
394:
395:
396: begin

Line 496: select irc_documents_s.nextval

492:
493: --Select the Document id from the db sequence
494: --
495: begin
496: select irc_documents_s.nextval
497: into l_new_doc_id
498: from dual;
499: end;
500: --

Line 866: from irc_documents

862: --
863: -- Cursor to ensure row exists in table.
864: cursor csr_doc_exists(p_document_id number) is
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

Line 897: ctx_doc.filter(index_name => l_hr_username || '.IRC_DOCUMENTS_CTX',

893: If csr_doc_exists%found then
894: close csr_doc_exists;
895: --
896: -- Convert document
897: ctx_doc.filter(index_name => l_hr_username || '.IRC_DOCUMENTS_CTX',
898: textkey => l_rowid,
899: restab => clob_doc,
900: plaintext => true);
901: --

Line 904: update irc_documents

900: plaintext => true);
901: --
902: irc_ido_shd.g_api_dml := true; -- Set the api dml status
903: --
904: update irc_documents
905: set character_doc = clob_doc
906: where document_id = p_document_id;
907: --
908: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

Line 954: from irc_documents

950: where oracle_id = 800;
951:
952: cursor csr_doc_exists is
953: select rowid
954: from irc_documents
955: where document_id = p_document_id;
956: cursor csr_doc_type is
957: select file_name
958: from irc_documents

Line 958: from irc_documents

954: from irc_documents
955: where document_id = p_document_id;
956: cursor csr_doc_type is
957: select file_name
958: from irc_documents
959: where document_id = p_document_id;
960:
961: l_rowid rowid;
962: l_schema_name varchar2(20) := null;

Line 964: l_file_name IRC_DOCUMENTS.FILE_NAME%type;

960:
961: l_rowid rowid;
962: l_schema_name varchar2(20) := null;
963: l_output_clob clob := null;
964: l_file_name IRC_DOCUMENTS.FILE_NAME%type;
965: l_type varchar2(10);
966: begin
967: open csr_doc_exists;
968: fetch csr_doc_exists into l_rowid;

Line 978: CTX_DOC.MARKUP (index_name => l_schema_name||'.IRC_DOCUMENTS_CTX' ,

974: if (get_schema_name%found) then
975: close get_schema_name;
976: -- Highlight the keywords if highlight string is null
977: if (trim(p_highlight_string) is not null) then
978: CTX_DOC.MARKUP (index_name => l_schema_name||'.IRC_DOCUMENTS_CTX' ,
979: textkey => l_rowid,
980: text_query => p_highlight_string,
981: restab => l_output_clob,
982: plaintext => FALSE,

Line 989: ctx_doc.filter(index_name => l_schema_name||'.IRC_DOCUMENTS_CTX',

985: endtag => IRC_MARKUP_ENDTAG);
986:
987: -- IF keyword is null then generate html version without markup
988: else
989: ctx_doc.filter(index_name => l_schema_name||'.IRC_DOCUMENTS_CTX',
990: textkey => l_rowid,
991: restab => l_output_clob,
992: plaintext => false);
993: end if;