DBA Data[Home] [Help]

APPS.PER_VACANCY_SWI dependencies on FND_ATTACHED_DOCUMENTS2_PKG

Line 807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

803: PRAGMA AUTONOMOUS_TRANSACTION;
804: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
805: begin
806: hr_utility.set_location(' Entering:' || l_proc,10);
807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);

Line 808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

804: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
805: begin
806: hr_utility.set_location(' Entering:' || l_proc,10);
807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
812:

Line 810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);

806: hr_utility.set_location(' Entering:' || l_proc,10);
807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
812:
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

Line 811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);

807: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
808: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
812:
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815: commit;

Line 813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

809:
810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
812:
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815: commit;
816: hr_utility.set_location(' Exiting:' || l_proc,20);
817: end;

Line 814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

810: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
811: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC_APPROVED',X_to_pk1_value=>p_vacancy_id);
812:
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815: commit;
816: hr_utility.set_location(' Exiting:' || l_proc,20);
817: end;
818: --

Line 828: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

824: PRAGMA AUTONOMOUS_TRANSACTION;
825: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
826: begin
827: hr_utility.set_location(' Entering:' || l_proc,10);
828: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
829: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
830: commit;
831: hr_utility.set_location(' Exiting:' || l_proc,20);
832: end;

Line 829: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

825: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
826: begin
827: hr_utility.set_location(' Entering:' || l_proc,10);
828: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
829: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
830: commit;
831: hr_utility.set_location(' Exiting:' || l_proc,20);
832: end;
833:

Line 844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

840: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
841: begin
842: hr_utility.set_location(' Entering:' || l_proc,10);
843:
844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
846:
847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);
848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);

Line 845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');

841: begin
842: hr_utility.set_location(' Entering:' || l_proc,10);
843:
844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
846:
847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);
848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);
849: commit;

Line 847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);

843:
844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
846:
847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);
848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);
849: commit;
850: hr_utility.set_location(' Exiting:' || l_proc,20);
851: end;

Line 848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);

844: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
845: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
846:
847: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_vacancy_id);
848: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_vacancy_id);
849: commit;
850: hr_utility.set_location(' Exiting:' || l_proc,20);
851: end;
852:

Line 863: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_to_vacancy_id);

859: l_proc varchar2(72) := g_package || 'copyAttachments';
860: begin
861: hr_utility.set_location(' Entering:' || l_proc,10);
862:
863: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_to_vacancy_id);
864: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_to_vacancy_id);
865: commit;
866: hr_utility.set_location(' Exiting:' || l_proc,20);
867: end;

Line 864: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_to_vacancy_id);

860: begin
861: hr_utility.set_location(' Entering:' || l_proc,10);
862:
863: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_INT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_INT_VAC',X_to_pk1_value=>p_to_vacancy_id);
864: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name =>'IRC_EXT_VAC_APPROVED',X_from_pk1_value => p_from_vacancy_id,X_to_entity_name=>'IRC_EXT_VAC',X_to_pk1_value=>p_to_vacancy_id);
865: commit;
866: hr_utility.set_location(' Exiting:' || l_proc,20);
867: end;
868: