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_PENDING_DATA_API dependencies on IRC_DOCUMENTS

Line 771: l_document_id irc_documents.document_id%type;

767: l_resume_file_name irc_pending_data.resume_file_name%type;
768: l_resume_description irc_pending_data.resume_description%type;
769: l_resume_mime_type irc_pending_data.resume_mime_type%type;
770: l_resume irc_pending_data.resume%type;
771: l_document_id irc_documents.document_id%type;
772: l_new_doc_id irc_documents.document_id%type;
773: l_doc_person_id irc_documents.person_id%type;
774: l_doc_party_id irc_documents.party_id%type;
775: l_end_date date := null;

Line 772: l_new_doc_id irc_documents.document_id%type;

768: l_resume_description irc_pending_data.resume_description%type;
769: l_resume_mime_type irc_pending_data.resume_mime_type%type;
770: l_resume irc_pending_data.resume%type;
771: l_document_id irc_documents.document_id%type;
772: l_new_doc_id irc_documents.document_id%type;
773: l_doc_person_id irc_documents.person_id%type;
774: l_doc_party_id irc_documents.party_id%type;
775: l_end_date date := null;
776: l_assignment_id irc_documents.assignment_id%type;

Line 773: l_doc_person_id irc_documents.person_id%type;

769: l_resume_mime_type irc_pending_data.resume_mime_type%type;
770: l_resume irc_pending_data.resume%type;
771: l_document_id irc_documents.document_id%type;
772: l_new_doc_id irc_documents.document_id%type;
773: l_doc_person_id irc_documents.person_id%type;
774: l_doc_party_id irc_documents.party_id%type;
775: l_end_date date := null;
776: l_assignment_id irc_documents.assignment_id%type;
777: l_doc_ovn number;

Line 774: l_doc_party_id irc_documents.party_id%type;

770: l_resume irc_pending_data.resume%type;
771: l_document_id irc_documents.document_id%type;
772: l_new_doc_id irc_documents.document_id%type;
773: l_doc_person_id irc_documents.person_id%type;
774: l_doc_party_id irc_documents.party_id%type;
775: l_end_date date := null;
776: l_assignment_id irc_documents.assignment_id%type;
777: l_doc_ovn number;
778: l_source_type irc_pending_data.source_type%type;

Line 776: l_assignment_id irc_documents.assignment_id%type;

772: l_new_doc_id irc_documents.document_id%type;
773: l_doc_person_id irc_documents.person_id%type;
774: l_doc_party_id irc_documents.party_id%type;
775: l_end_date date := null;
776: l_assignment_id irc_documents.assignment_id%type;
777: l_doc_ovn number;
778: l_source_type irc_pending_data.source_type%type;
779: l_job_post_source_name irc_pending_data.job_post_source_name%type;
780:

Line 846: from irc_pending_data ipd, irc_documents ido

842: ,ido.object_version_number
843: ,ido.person_id
844: ,ido.party_id
845: ,ido.assignment_id
846: from irc_pending_data ipd, irc_documents ido
847: where ipd.person_id = ido.person_id(+)
848: and ipd.resume_file_name = ido.file_name(+)
849: and ido.type(+) = 'RESUME'
850: and ido.end_date(+) is null

Line 1176: update irc_documents set binary_doc=l_resume

1172: end if;
1173: end if;
1174: hr_utility.set_location(l_proc, 65);
1175: if l_new_doc_id is not null then
1176: update irc_documents set binary_doc=l_resume
1177: where document_id = l_new_doc_id;
1178: irc_document_api.process_document(l_new_doc_id);
1179: end if;
1180: --