DBA Data[Home] [Help]

APPS.HR_UTIL_MISC_SS dependencies on PER_FND_ATTACHMENT_PKG

Line 1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))

1722: IF l_person_id = p_dest_pk1_value
1723: and fnd_profile.value('PER_UPLOAD_IREC_DOC') = 'Y'
1724: THEN
1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);
1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))
1727: THEN
1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1729:
1730: /*start - added for bug 14277455*/

Line 1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);

1724: THEN
1725: hr_utility.set_location('Entering: IF l_person_id <> null ', 10);
1726: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id ))
1727: THEN
1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1729:
1730: /*start - added for bug 14277455*/
1731: per_fnd_attachment_pkg.update_on_link_table(l_irc_doc_id,l_person_id, attached_documents_rec);
1732: /*end - added for bug 14277455*/

Line 1731: per_fnd_attachment_pkg.update_on_link_table(l_irc_doc_id,l_person_id, attached_documents_rec);

1727: THEN
1728: hr_utility.set_location('Entering: IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1729:
1730: /*start - added for bug 14277455*/
1731: per_fnd_attachment_pkg.update_on_link_table(l_irc_doc_id,l_person_id, attached_documents_rec);
1732: /*end - added for bug 14277455*/
1733:
1734:
1735: ELSE

Line 1736: hr_utility.set_location('Entering: ELSE OF IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);

1732: /*end - added for bug 14277455*/
1733:
1734:
1735: ELSE
1736: hr_utility.set_location('Entering: ELSE OF IF(per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irc_doc_id )) ', 20);
1737: update_attachment
1738: (p_entity_name=>p_dest_entity_name
1739: ,p_pk1_value=> p_dest_pk1_value
1740: ,p_rowid=>l_rowid);

Line 2067: IF NOT per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irec_doc_id ) THEN

2063: OPEN csr_apl_hire_txn_vals(step_row.TRANSACTION_STEP_ID);
2064: LOOP
2065: FETCH csr_apl_hire_txn_vals into l_irec_doc_id,l_fnd_doc_id;
2066: EXIT WHEN csr_apl_hire_txn_vals%NOTFOUND;
2067: IF NOT per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irec_doc_id ) THEN
2068: per_fnd_attachment_pkg.dml_on_link_table (
2069: p_entity_name=>'SSHR',
2070: p_sub_entity_name=>'IRC_ATTCH',
2071: p_person_id=>l_person_id,

Line 2068: per_fnd_attachment_pkg.dml_on_link_table (

2064: LOOP
2065: FETCH csr_apl_hire_txn_vals into l_irec_doc_id,l_fnd_doc_id;
2066: EXIT WHEN csr_apl_hire_txn_vals%NOTFOUND;
2067: IF NOT per_fnd_attachment_pkg.is_iRec_doc_exist (l_person_id , l_irec_doc_id ) THEN
2068: per_fnd_attachment_pkg.dml_on_link_table (
2069: p_entity_name=>'SSHR',
2070: p_sub_entity_name=>'IRC_ATTCH',
2071: p_person_id=>l_person_id,
2072: p_doc_upload_date=> l_doc_upload_date,