DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_AD_INTERFACE_ALL

Line 301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;

297: WHERE a.interface_id = cp_interface_id
298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';

Line 302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;

298: AND a.status = '3';
299: l_interface_stat_rec c_stat_int%ROWTYPE ;
300:
301: l_imp_batch_id igs_ad_interface_all.batch_id%TYPE ;
302: l_interface_id igs_ad_interface_all.interface_id%TYPE ;
303: l_interface_stat_id igs_ad_stat_int_all.interface_stat_id%TYPE;
304: l_chk_per_present VARCHAR2(1) := 'Y';
305: l_col_ad_null VARCHAR2(1) := 'Y';
306: l_col_spa_null VARCHAR2(1) := 'Y';