DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_HESA_TO_OSS_PKG dependencies on IGS_HE_AD_DTL_ALL_PKG

Line 568: igs_he_ad_dtl_all_pkg.insert_row(

564: IF l_count = 0 THEN
565:
566: FOR lv_ad_appl_inst IN cur_ad_appl_inst(all_appl_rec.oss_person_id) LOOP
567: l_rowid := NULL ;
568: igs_he_ad_dtl_all_pkg.insert_row(
569: x_rowid => l_rowid,
570: x_org_id => NULL,
571: x_hesa_ad_dtl_id => l_count,
572: x_person_id => all_appl_rec.oss_person_id,

Line 587: igs_he_ad_dtl_all_pkg.update_row (

583:
584: ELSE
585:
586: FOR had_rec IN get_had_details(all_appl_rec.oss_person_id) LOOP
587: igs_he_ad_dtl_all_pkg.update_row (
588: x_mode => 'R',
589: x_rowid => had_rec.ROWID,
590: x_org_id => had_rec.org_id,
591: x_hesa_ad_dtl_id => had_rec.hesa_ad_dtl_id,