816: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC',
817: X_from_pk1_value => p_vacancy_id,
818: X_to_entity_name => 'IRC_INT_VAC_APPROVED',
819: X_to_pk1_value => p_vacancy_id,
820: X_created_by => fnd_global.user_id,
821: X_last_update_login=> fnd_global.login_id
822: );
823: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC',
824: X_from_pk1_value => p_vacancy_id,
817: X_from_pk1_value => p_vacancy_id,
818: X_to_entity_name => 'IRC_INT_VAC_APPROVED',
819: X_to_pk1_value => p_vacancy_id,
820: X_created_by => fnd_global.user_id,
821: X_last_update_login=> fnd_global.login_id
822: );
823: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC',
824: X_from_pk1_value => p_vacancy_id,
825: X_to_entity_name => 'IRC_EXT_VAC_APPROVED',
823: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC',
824: X_from_pk1_value => p_vacancy_id,
825: X_to_entity_name => 'IRC_EXT_VAC_APPROVED',
826: X_to_pk1_value => p_vacancy_id,
827: X_created_by => fnd_global.user_id,
828: X_last_update_login=> fnd_global.login_id
829: );
830:
831: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
824: X_from_pk1_value => p_vacancy_id,
825: X_to_entity_name => 'IRC_EXT_VAC_APPROVED',
826: X_to_pk1_value => p_vacancy_id,
827: X_created_by => fnd_global.user_id,
828: X_last_update_login=> fnd_global.login_id
829: );
830:
831: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
832: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
865: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',
866: X_from_pk1_value => p_vacancy_id,
867: X_to_entity_name => 'IRC_INT_VAC',
868: X_to_pk1_value => p_vacancy_id,
869: X_created_by => fnd_global.user_id,
870: X_last_update_login=> fnd_global.login_id
871: );
872: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
873: X_from_pk1_value => p_vacancy_id,
866: X_from_pk1_value => p_vacancy_id,
867: X_to_entity_name => 'IRC_INT_VAC',
868: X_to_pk1_value => p_vacancy_id,
869: X_created_by => fnd_global.user_id,
870: X_last_update_login=> fnd_global.login_id
871: );
872: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
873: X_from_pk1_value => p_vacancy_id,
874: X_to_entity_name => 'IRC_EXT_VAC',
872: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
873: X_from_pk1_value => p_vacancy_id,
874: X_to_entity_name => 'IRC_EXT_VAC',
875: X_to_pk1_value => p_vacancy_id,
876: X_created_by => fnd_global.user_id,
877: X_last_update_login=> fnd_global.login_id
878: );
879: commit;
880: hr_utility.set_location(' Exiting:' || l_proc,20);
873: X_from_pk1_value => p_vacancy_id,
874: X_to_entity_name => 'IRC_EXT_VAC',
875: X_to_pk1_value => p_vacancy_id,
876: X_created_by => fnd_global.user_id,
877: X_last_update_login=> fnd_global.login_id
878: );
879: commit;
880: hr_utility.set_location(' Exiting:' || l_proc,20);
881: end;
893: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',
894: X_from_pk1_value => p_from_vacancy_id,
895: X_to_entity_name => 'IRC_INT_VAC',
896: X_to_pk1_value => p_to_vacancy_id,
897: X_created_by => fnd_global.user_id,
898: X_last_update_login=> fnd_global.login_id
899: );
900: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
901: X_from_pk1_value => p_from_vacancy_id,
894: X_from_pk1_value => p_from_vacancy_id,
895: X_to_entity_name => 'IRC_INT_VAC',
896: X_to_pk1_value => p_to_vacancy_id,
897: X_created_by => fnd_global.user_id,
898: X_last_update_login=> fnd_global.login_id
899: );
900: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
901: X_from_pk1_value => p_from_vacancy_id,
902: X_to_entity_name => 'IRC_EXT_VAC',
900: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',
901: X_from_pk1_value => p_from_vacancy_id,
902: X_to_entity_name => 'IRC_EXT_VAC',
903: X_to_pk1_value => p_to_vacancy_id,
904: X_created_by => fnd_global.user_id,
905: X_last_update_login=> fnd_global.login_id
906: );
907: commit;
908: hr_utility.set_location(' Exiting:' || l_proc,20);
901: X_from_pk1_value => p_from_vacancy_id,
902: X_to_entity_name => 'IRC_EXT_VAC',
903: X_to_pk1_value => p_to_vacancy_id,
904: X_created_by => fnd_global.user_id,
905: X_last_update_login=> fnd_global.login_id
906: );
907: commit;
908: hr_utility.set_location(' Exiting:' || l_proc,20);
909: end;