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 890: from irc_documents

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

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

917: If csr_doc_exists%found then
918: close csr_doc_exists;
919: --
920: -- Convert document
921: ctx_doc.filter(index_name => l_hr_username || '.IRC_DOCUMENTS_CTX',
922: textkey => l_rowid,
923: restab => clob_doc,
924: plaintext => true);
925: --

Line 928: update irc_documents

924: plaintext => true);
925: --
926: irc_ido_shd.g_api_dml := true; -- Set the api dml status
927: --
928: update irc_documents
929: set character_doc = clob_doc
930: where document_id = p_document_id;
931: --
932: irc_ido_shd.g_api_dml := false; -- Unset the api dml status

Line 978: from irc_documents

974: where oracle_id = 800;
975:
976: cursor csr_doc_exists is
977: select rowid
978: from irc_documents
979: where document_id = p_document_id;
980: cursor csr_doc_type is
981: select file_name
982: from irc_documents

Line 982: from irc_documents

978: from irc_documents
979: where document_id = p_document_id;
980: cursor csr_doc_type is
981: select file_name
982: from irc_documents
983: where document_id = p_document_id;
984:
985: l_rowid rowid;
986: l_schema_name varchar2(20) := null;

Line 988: l_file_name IRC_DOCUMENTS.FILE_NAME%type;

984:
985: l_rowid rowid;
986: l_schema_name varchar2(20) := null;
987: l_output_clob clob := null;
988: l_file_name IRC_DOCUMENTS.FILE_NAME%type;
989: l_type varchar2(10);
990: begin
991: --
992: fnd_msg_pub.delete_msg;

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

1001: if (get_schema_name%found) then
1002: close get_schema_name;
1003: -- Highlight the keywords if highlight string is null
1004: if (trim(p_highlight_string) is not null) then
1005: CTX_DOC.MARKUP (index_name => l_schema_name||'.IRC_DOCUMENTS_CTX' ,
1006: textkey => l_rowid,
1007: text_query => p_highlight_string,
1008: restab => l_output_clob,
1009: plaintext => FALSE,

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

1012: endtag => IRC_MARKUP_ENDTAG);
1013:
1014: -- IF keyword is null then generate html version without markup
1015: else
1016: ctx_doc.filter(index_name => l_schema_name||'.IRC_DOCUMENTS_CTX',
1017: textkey => l_rowid,
1018: restab => l_output_clob,
1019: plaintext => false);
1020: end if;