APPS.GMS_AWARD_DELETE_PKG dependencies on GMS_REPORTS

Line 517: --For bug 2312564 : changed the order of execution of delete to avoid dnagling records in gms_Reports

513: OPEN notification_lock;
514: CLOSE notification_lock;
515: OPEN lock_installments;
516: CLOSE lock_installments;
517: --For bug 2312564 : changed the order of execution of delete to avoid dnagling records in gms_Reports
518: DELETE FROM gms_reports WHERE installment_id in (select installment_id from gms_installments WHERE award_id =p_award_id);
519: DELETE FROM gms_installments WHERE award_id=p_award_id;
520: DELETE FROM gms_default_reports WHERE award_id = p_award_id;
521: DELETE FROM gms_notifications WHERE award_id= p_award_id;

Line 518: DELETE FROM gms_reports WHERE installment_id in (select installment_id from gms_installments WHERE award_id =p_award_id);

514: CLOSE notification_lock;
515: OPEN lock_installments;
516: CLOSE lock_installments;
517: --For bug 2312564 : changed the order of execution of delete to avoid dnagling records in gms_Reports
518: DELETE FROM gms_reports WHERE installment_id in (select installment_id from gms_installments WHERE award_id =p_award_id);
519: DELETE FROM gms_installments WHERE award_id=p_award_id;
520: DELETE FROM gms_default_reports WHERE award_id = p_award_id;
521: DELETE FROM gms_notifications WHERE award_id= p_award_id;
522: DELETE FROM gms_awards_terms_conditions WHERE award_id=p_award_id;

Line 523: -- DELETE FROM gms_reports WHERE installment_id in (select installment_id

519: DELETE FROM gms_installments WHERE award_id=p_award_id;
520: DELETE FROM gms_default_reports WHERE award_id = p_award_id;
521: DELETE FROM gms_notifications WHERE award_id= p_award_id;
522: DELETE FROM gms_awards_terms_conditions WHERE award_id=p_award_id;
523: -- DELETE FROM gms_reports WHERE installment_id in (select installment_id
524: -- from gms_installments WHERE award_id =p_award_id);
525: DELETE FROM gms_personnel WHERE award_id =p_award_id;
526: DELETE FROM gms_reference_numbers WHERE award_id=p_award_id;
527: DELETE FROM gms_awards_contacts WHERE award_id=p_award_id;