DBA Data[Home] [Help]

APPS.PER_VACANCY_SWI dependencies on FND_ATTACHED_DOCUMENTS2_PKG

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

809: PRAGMA AUTONOMOUS_TRANSACTION;
810: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
811: begin
812: hr_utility.set_location(' Entering:' || l_proc,10);
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815:
816: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC',
817: X_from_pk1_value => p_vacancy_id,

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

810: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
811: begin
812: hr_utility.set_location(' Entering:' || l_proc,10);
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815:
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',

Line 816: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC',

812: hr_utility.set_location(' Entering:' || l_proc,10);
813: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
814: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC_APPROVED',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
815:
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,

Line 823: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC',

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',
826: X_to_pk1_value => p_vacancy_id,
827: X_created_by => fnd_global.user_id,

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

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');
833: commit;
834: hr_utility.set_location(' Exiting:' || l_proc,20);
835: end;

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

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');
833: commit;
834: hr_utility.set_location(' Exiting:' || l_proc,20);
835: end;
836: --

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

842: PRAGMA AUTONOMOUS_TRANSACTION;
843: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
844: begin
845: hr_utility.set_location(' Entering:' || l_proc,10);
846: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
847: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
848: commit;
849: hr_utility.set_location(' Exiting:' || l_proc,20);
850: end;

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

843: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
844: begin
845: hr_utility.set_location(' Entering:' || l_proc,10);
846: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
847: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
848: commit;
849: hr_utility.set_location(' Exiting:' || l_proc,20);
850: end;
851:

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

858: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
859: begin
860: hr_utility.set_location(' Entering:' || l_proc,10);
861:
862: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
863: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
864:
865: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',
866: X_from_pk1_value => p_vacancy_id,

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

859: begin
860: hr_utility.set_location(' Entering:' || l_proc,10);
861:
862: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
863: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
864:
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',

Line 865: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',

861:
862: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
863: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_VAC',X_pk1_value=>p_vacancy_id,X_delete_document_flag=>'Y');
864:
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,

Line 872: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',

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',
875: X_to_pk1_value => p_vacancy_id,
876: X_created_by => fnd_global.user_id,

Line 893: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_VAC_APPROVED',

889: l_proc varchar2(72) := g_package || 'copyAttachments';
890: begin
891: hr_utility.set_location(' Entering:' || l_proc,10);
892:
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,

Line 900: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_VAC_APPROVED',

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',
903: X_to_pk1_value => p_to_vacancy_id,
904: X_created_by => fnd_global.user_id,