APPS.IGS_AD_IMP_001 dependencies on IGS_AD_INTERFACE_ALL

Line 58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS

54:
55: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
56: END logerrormessage;
57:
58: PROCEDURE print_stats(p_interface_run_id IN igs_ad_interface_all.interface_run_id%TYPE) AS
59: /*****************************************************************
60: Created By : asbala
61: Creation date : 9/23/2003
62: Purpose : This function is to print the statistics from igs_ad_imp_stats.

Line 719: UPDATE igs_ad_interface_all

715: RETURN;
716: END IF;
717: END IF;
718: -- Update the interface_run_id for IGS_AD_INTERFACE records with status in 1,2,4 for Bug - 2377123
719: UPDATE igs_ad_interface_all
720: SET interface_run_id = l_interface_run_id
721: WHERE batch_id = p_batch_id
722: AND source_type_id = p_source_type_id
723: AND status IN ('1','2','4');

Line 727: UPDATE igs_ad_interface_all int1

723: AND status IN ('1','2','4');
724: COMMIT;
725:
726: -- Update the interface records if the interface ids are duplicate (within the batch and across the batch)
727: UPDATE igs_ad_interface_all int1
728: SET status ='3',
729: error_code = 'E712'
730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all
731: WHERE interface_id = int1.interface_id

Line 730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all

726: -- Update the interface records if the interface ids are duplicate (within the batch and across the batch)
727: UPDATE igs_ad_interface_all int1
728: SET status ='3',
729: error_code = 'E712'
730: WHERE EXISTS ( SELECT 1 FROM igs_ad_interface_all
731: WHERE interface_id = int1.interface_id
732: AND rowid <> int1.rowid )
733: AND interface_run_id = l_interface_run_id;
734: COMMIT;

Line 741: tabname => 'IGS_AD_INTERFACE_ALL',

737: l_return := fnd_installation.get_app_info('IGS', l_status, l_industry, l_schema);
738:
739: -- Gather statistics of interface tables
740: FND_STATS.GATHER_TABLE_STATS(ownname => l_schema,
741: tabname => 'IGS_AD_INTERFACE_ALL',
742: cascade => TRUE);
743:
744: -------------------------------------------------------
745: -- disable HZ security policy before starting the import.

Line 777: DELETE FROM igs_ad_interface_all

773:
774: igs_ad_imp_015.del_cmpld_ad_records (p_source_type_id => p_source_type_id,
775: p_batch_id => p_batch_id,
776: p_interface_run_id => l_interface_run_id);
777: DELETE FROM igs_ad_interface_all
778: WHERE status = '1'
779: AND record_status ='1'
780: AND interface_run_id = l_interface_run_id;
781:

Line 782: UPDATE igs_ad_interface_all

778: WHERE status = '1'
779: AND record_status ='1'
780: AND interface_run_id = l_interface_run_id;
781:
782: UPDATE igs_ad_interface_all
783: SET record_status = '3'
784: WHERE interface_run_id = l_interface_run_id
785: AND status <> '1';
786: COMMIT;