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_PENDING_DATA

Line 1: Package Body IRC_PENDING_DATA_API as

1: Package Body IRC_PENDING_DATA_API as
2: /* $Header: iripdapi.pkb 120.15 2008/01/21 14:58:20 gaukumar noship $ */
3: --
4: -- Package Variables
5: --

Line 6: g_package varchar2(33) := 'IRC_PENDING_DATA_API.';

2: /* $Header: iripdapi.pkb 120.15 2008/01/21 14:58:20 gaukumar noship $ */
3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := 'IRC_PENDING_DATA_API.';
7: --
8: -- ----------------------------------------------------------------------------
9: -- |-----------------------< CREATE_PENDING_DATA >-----------------------|
10: -- ----------------------------------------------------------------------------

Line 107: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_b

103: --
104: -- Call Before Process User Hook
105: --
106: begin
107: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_b
108: (p_email_address => p_email_address
109: ,p_last_name => p_last_name
110: ,p_vacancy_id => p_vacancy_id
111: ,p_first_name => p_first_name

Line 259: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_a

255: --
256: -- Call After Process User Hook
257: --
258: begin
259: IRC_PENDING_DATA_BK1.CREATE_PENDING_DATA_a
260: (p_email_address => p_email_address
261: ,p_last_name => p_last_name
262: ,p_vacancy_id => p_vacancy_id
263: ,p_first_name => p_first_name

Line 450: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_b

446: --
447: -- Call Before Process User Hook
448: --
449: begin
450: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_b
451: (p_email_address => p_email_address
452: ,p_last_name => p_last_name
453: ,p_vacancy_id => p_vacancy_id
454: ,p_first_name => p_first_name

Line 576: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_a

572: );
573: -- Call After Process User Hook
574: --
575: begin
576: IRC_PENDING_DATA_BK2.UPDATE_PENDING_DATA_a
577: (p_email_address => p_email_address
578: ,p_last_name => p_last_name
579: ,p_vacancy_id => p_vacancy_id
580: ,p_first_name => p_first_name

Line 691: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_b

687: --
688: -- Call Before Process User Hook
689: --
690: begin
691: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_b
692: (p_pending_data_id => p_pending_data_id
693: );
694: exception
695: when hr_api.cannot_find_prog_unit then

Line 709: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_a

705: --
706: -- Call After Process User Hook
707: --
708: begin
709: IRC_PENDING_DATA_BK3.DELETE_PENDING_DATA_a
710: (p_pending_data_id => p_pending_data_id
711: );
712: exception
713: when hr_api.cannot_find_prog_unit then

Line 767: l_resume_file_name irc_pending_data.resume_file_name%type;

763: l_irc_resp_id fnd_responsibility.responsibility_id%type;
764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;
766:
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;

Line 768: l_resume_description irc_pending_data.resume_description%type;

764: l_irc_resp_appl_id fnd_responsibility.application_id%type;
765: l_reg_bg_id number;
766:
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;

Line 769: l_resume_mime_type irc_pending_data.resume_mime_type%type;

765: l_reg_bg_id number;
766:
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;

Line 770: l_resume irc_pending_data.resume%type;

766:
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;

Line 778: l_source_type irc_pending_data.source_type%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:
781: l_applicant_person_id per_all_people_f.person_id%type;
782: l_applicant_assg_id per_all_assignments_f.assignment_id%type;

Line 779: l_job_post_source_name irc_pending_data.job_post_source_name%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:
781: l_applicant_person_id per_all_people_f.person_id%type;
782: l_applicant_assg_id per_all_assignments_f.assignment_id%type;
783: l_appl_ovn per_all_people_f.object_version_number%type;

Line 799: l_allow_access irc_pending_data.allow_access%type;

795: l_applicant_number per_all_people_f.applicant_number%type;
796: l_err_msg varchar2(4000);
797: l_msg varchar2(4000);
798: l_err_num number;
799: l_allow_access irc_pending_data.allow_access%type;
800: l_password irc_pending_data.user_password%type;
801: l_num number;
802: l_person_type varchar2(30);
803: l_irc_profile varchar2(30);

Line 800: l_password irc_pending_data.user_password%type;

796: l_err_msg varchar2(4000);
797: l_msg varchar2(4000);
798: l_err_num number;
799: l_allow_access irc_pending_data.allow_access%type;
800: l_password irc_pending_data.user_password%type;
801: l_num number;
802: l_person_type varchar2(30);
803: l_irc_profile varchar2(30);
804: l_new_user_id number;

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 918: from irc_pending_data ipd, fnd_user usr

914: ,ipd.user_guid
915: ,ipd.visitor_resp_key
916: ,ipd.visitor_resp_appl_id
917: ,ipd.security_group_key
918: from irc_pending_data ipd, fnd_user usr
919: where upper(ipd.email_address) = usr.user_name(+)
920: and ipd.processed is null
921: order by ipd.creation_date asc;
922: --

Line 1099: update irc_pending_data

1095: --
1096: -- update pending data row to have the person_id
1097: --
1098: hr_utility.set_location(l_proc,40);
1099: update irc_pending_data
1100: set person_id = l_person_id
1101: ,last_update_date = trunc(sysdate)
1102: where pending_data_id = l_data.pending_data_id;
1103: commit;

Line 1104: Fnd_file.put_line(FND_FILE.LOG,'Updated irc_pending_data with person_id:'||l_person_id);

1100: set person_id = l_person_id
1101: ,last_update_date = trunc(sysdate)
1102: where pending_data_id = l_data.pending_data_id;
1103: commit;
1104: Fnd_file.put_line(FND_FILE.LOG,'Updated irc_pending_data with person_id:'||l_person_id);
1105: --
1106: -- create/update documents for users who have uploaded their resumes
1107: --
1108: hr_utility.set_location(l_proc, 45);

Line 1322: update irc_pending_data

1318: hr_utility.set_location(l_proc, 90);
1319: --
1320: -- Update the processed status to 'A'
1321: --
1322: update irc_pending_data
1323: set processed='A'
1324: ,last_update_date = trunc(sysdate)
1325: where pending_data_id = l_data.pending_data_id;
1326: commit;

Line 1337: update irc_pending_data ipd

1333: end if;
1334: l_err_num := SQLCODE;
1335: l_err_msg := SUBSTR(SQLERRM, 1, 4000);
1336: l_msg := SUBSTR(l_err_msg,(INSTR(l_err_msg,':')+1),4000);
1337: update irc_pending_data ipd
1338: set ipd.processed='F'
1339: ,ipd.error_message=l_msg
1340: ,ipd.last_update_date=trunc(sysdate)
1341: where ipd.pending_data_id=l_data.pending_data_id;

Line 1361: from irc_pending_data ipd

1357: ,ipd.processed
1358: ,ipd.error_message
1359: ,ipd.resume_file_name
1360: ,pav.name
1361: from irc_pending_data ipd
1362: ,per_all_vacancies pav
1363: where ipd.vacancy_id = pav.vacancy_id(+)
1364: and ipd.processed in ('A','R','E','F')
1365: order by ipd.email_address, ipd.creation_date desc;

Line 1369: from irc_pending_data ipd

1365: order by ipd.email_address, ipd.creation_date desc;
1366: --
1367: cursor csr_is_new_user(p_email_address in varchar2) is
1368: select ipd.user_password
1369: from irc_pending_data ipd
1370: where ipd.email_address = p_email_address
1371: and ipd.user_password is not null;
1372: --
1373: cursor csr_posting_title(p_posting_content_id in number) is

Line 1391: l_curr_email irc_pending_data.email_address%type;

1387: table of irc_posting_contents_vl.job_title%type
1388: index by binary_integer;
1389: --
1390: l_resume varchar2(30);
1391: l_curr_email irc_pending_data.email_address%type;
1392: l_msg_html varchar2(32000);
1393: l_msg_text varchar2(32000);
1394: l_new_user_text varchar2(240);
1395: l_success_vacancies_list vacancies_table;

Line 1402: l_password irc_pending_data.user_password%type;

1398: l_failed_vac_comments_list comments_table;
1399: l_success_postings_list postings_table;
1400: l_failed_postings_list postings_table;
1401: l_notif_id number;
1402: l_password irc_pending_data.user_password%type;
1403: l_decrypted_password irc_pending_data.user_password%type;
1404: l_display_name varchar2(300); -- vacancy name plus postings title
1405: l_proc varchar2(72) := g_package||'SEND_NOTIFICATIONS';
1406:

Line 1403: l_decrypted_password irc_pending_data.user_password%type;

1399: l_success_postings_list postings_table;
1400: l_failed_postings_list postings_table;
1401: l_notif_id number;
1402: l_password irc_pending_data.user_password%type;
1403: l_decrypted_password irc_pending_data.user_password%type;
1404: l_display_name varchar2(300); -- vacancy name plus postings title
1405: l_proc varchar2(72) := g_package||'SEND_NOTIFICATIONS';
1406:
1407: vac_rows number;

Line 1630: update irc_pending_data

1626: l_curr_email := l_applied_data.email_address;
1627: --
1628: --update processed to S for the current row
1629: --
1630: update irc_pending_data
1631: set processed='S'
1632: ,last_update_date=trunc(sysdate)
1633: where pending_data_id=l_applied_data.pending_data_id;
1634: Fnd_file.put_line(FND_FILE.LOG,'Updated the processed flag to S');

Line 1791: end IRC_PENDING_DATA_API;

1787: end if;
1788: hr_utility.set_location('Leaving '||l_proc, 80);
1789: end send_notifications;
1790: --
1791: end IRC_PENDING_DATA_API;