APPS.HR_PROCESS_PERSON_SS dependencies on IRC_DOCUMENTS

Line 1484: -- ---------------------------- < attch_irc_documents> ------------------------------

1480:
1481: /*Added following procedure as a part of ER#9879782 Starts*/
1482:
1483: -- ---------------------------------------------------------------------------
1484: -- ---------------------------- < attch_irc_documents> ------------------------------
1485: -- ---------------------------------------------------------------------------
1486: -- Purpose: This procedure will perform will create the attachements with
1487: -- the documents uploaded in iRecruitment for an Applicant.
1488: -- ---------------

Line 1489: PROCEDURE attch_irc_documents

1485: -- ---------------------------------------------------------------------------
1486: -- Purpose: This procedure will perform will create the attachements with
1487: -- the documents uploaded in iRecruitment for an Applicant.
1488: -- ---------------
1489: PROCEDURE attch_irc_documents
1490: (p_transaction_id IN number) IS
1491: l_error_msg varchar2(2000);
1492: l_return_status varchar2(10);
1493: l_blob blob;

Line 1515: FROM irc_documents doc

1511: , doc.mime_type
1512: , doc.file_name
1513: , doc.description
1514: , hrl.meaning
1515: FROM irc_documents doc
1516: , hr_lookups hrl
1517: WHERE hrl.lookup_type = 'IRC_DOCUMENT_TYPE'
1518: AND doc.type = hrl.lookup_code
1519: AND doc.end_date IS NULL

Line 1618: END attch_irc_documents;

1614: END LOOP;
1615: hr_utility.set_location('Closing Cursor: resume_doc', 70);
1616: CLOSE resume_doc;
1617: hr_utility.set_location('Entering: '||l_proc, 10);
1618: END attch_irc_documents;
1619:
1620: /*Added following procedure as a part of ER#9879782 Ends*/
1621:
1622: -- ---------------------------------------------------------------------------

Line 2604: attch_irc_documents (l_transaction_id);

2600: /*Added following code as a part of ER#9879782 Starts*/
2601: IF (l_current_applicant_flag = 'Y')
2602: AND fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
2603: THEN
2604: attch_irc_documents (l_transaction_id);
2605: END IF;
2606: /*Added following code as a part of ER#9879782 Ends*/
2607:
2608: END IF;