DBA Data[Home] [Help]

APPS.IRC_OFFERS_SWI dependencies on FND_ATTACHED_DOCUMENTS2_PKG

Line 3152: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3148: PRAGMA AUTONOMOUS_TRANSACTION;
3149: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
3150: begin
3151: hr_utility.set_location(' Entering:' || l_proc,10);
3152: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3153: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3154:
3155: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER',
3156: X_from_pk1_value => p_applicant_assignment_id,

Line 3153: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3149: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenCommit';
3150: begin
3151: hr_utility.set_location(' Entering:' || l_proc,10);
3152: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3153: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3154:
3155: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER',
3156: X_from_pk1_value => p_applicant_assignment_id,
3157: X_to_entity_name => 'IRC_EXT_OFFER_APPROVED',

Line 3155: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER',

3151: hr_utility.set_location(' Entering:' || l_proc,10);
3152: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3153: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER_APPROVED',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3154:
3155: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER',
3156: X_from_pk1_value => p_applicant_assignment_id,
3157: X_to_entity_name => 'IRC_EXT_OFFER_APPROVED',
3158: X_to_pk1_value => p_applicant_assignment_id,
3159: X_created_by => fnd_global.user_id,

Line 3162: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER',

3158: X_to_pk1_value => p_applicant_assignment_id,
3159: X_created_by => fnd_global.user_id,
3160: X_last_update_login=> fnd_global.login_id
3161: );
3162: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER',
3163: X_from_pk1_value => p_applicant_assignment_id,
3164: X_to_entity_name => 'IRC_INT_OFFER_APPROVED',
3165: X_to_pk1_value => p_applicant_assignment_id,
3166: X_created_by => fnd_global.user_id,

Line 3170: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3166: X_created_by => fnd_global.user_id,
3167: X_last_update_login=> fnd_global.login_id
3168: );
3169:
3170: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3171: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3172: commit;
3173: hr_utility.set_location(' Exiting:' || l_proc,20);
3174: end;

Line 3171: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3167: X_last_update_login=> fnd_global.login_id
3168: );
3169:
3170: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3171: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3172: commit;
3173: hr_utility.set_location(' Exiting:' || l_proc,20);
3174: end;
3175: --

Line 3185: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3181: PRAGMA AUTONOMOUS_TRANSACTION;
3182: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
3183: begin
3184: hr_utility.set_location(' Entering:' || l_proc,10);
3185: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3186: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3187: commit;
3188: hr_utility.set_location(' Exiting:' || l_proc,20);
3189: end;

Line 3186: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3182: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenRejected';
3183: begin
3184: hr_utility.set_location(' Entering:' || l_proc,10);
3185: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3186: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3187: commit;
3188: hr_utility.set_location(' Exiting:' || l_proc,20);
3189: end;
3190:

Line 3201: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3197: l_proc varchar2(72) := g_package || 'handleAttachmentsWhenEdit';
3198: begin
3199: hr_utility.set_location(' Entering:' || l_proc,10);
3200:
3201: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3202: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3203:
3204: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER_APPROVED',
3205: X_from_pk1_value => p_applicant_assignment_id,

Line 3202: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');

3198: begin
3199: hr_utility.set_location(' Entering:' || l_proc,10);
3200:
3201: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3202: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3203:
3204: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER_APPROVED',
3205: X_from_pk1_value => p_applicant_assignment_id,
3206: X_to_entity_name => 'IRC_INT_OFFER',

Line 3204: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER_APPROVED',

3200:
3201: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_EXT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3202: fnd_attached_documents2_pkg.delete_attachments(X_entity_name=>'IRC_INT_OFFER',X_pk1_value=>p_applicant_assignment_id,X_delete_document_flag=>'Y');
3203:
3204: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_INT_OFFER_APPROVED',
3205: X_from_pk1_value => p_applicant_assignment_id,
3206: X_to_entity_name => 'IRC_INT_OFFER',
3207: X_to_pk1_value => p_applicant_assignment_id,
3208: X_created_by => fnd_global.user_id,

Line 3211: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER_APPROVED',

3207: X_to_pk1_value => p_applicant_assignment_id,
3208: X_created_by => fnd_global.user_id,
3209: X_last_update_login=> fnd_global.login_id
3210: );
3211: fnd_attached_documents2_pkg.copy_attachments(X_from_entity_name => 'IRC_EXT_OFFER_APPROVED',
3212: X_from_pk1_value => p_applicant_assignment_id,
3213: X_to_entity_name => 'IRC_EXT_OFFER',
3214: X_to_pk1_value => p_applicant_assignment_id,
3215: X_created_by => fnd_global.user_id,