APPS.IGS_AD_IMP_008 dependencies on IGS_AD_EMP_DTL_PKG

Line 3266: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes

3262: SET status = '3', error_code = l_error_code
3263: WHERE interface_relemp_id = p_relemp_rec.interface_relemp_id;
3264: ELSE
3265: BEGIN
3266: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3267: Igs_Ad_Emp_Dtl_Pkg.Insert_Row (
3268: X_ROWID => l_RowId,
3269: x_employment_history_id => l_Employment_History_Id,
3270: x_PERSON_ID => p_person_id,

Line 3267: Igs_Ad_Emp_Dtl_Pkg.Insert_Row (

3263: WHERE interface_relemp_id = p_relemp_rec.interface_relemp_id;
3264: ELSE
3265: BEGIN
3266: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3267: Igs_Ad_Emp_Dtl_Pkg.Insert_Row (
3268: X_ROWID => l_RowId,
3269: x_employment_history_id => l_Employment_History_Id,
3270: x_PERSON_ID => p_person_id,
3271: x_START_DT => P_RELEMP_REC.Start_Dt,

Line 3712: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes

3708: UPDATE igs_ad_relemp_int_all
3709: SET status = '3', error_code = l_error_code
3710: WHERE interface_relemp_id = relns_emp_dtls_rec.interface_relemp_id;
3711: ELSE
3712: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3713: Igs_Ad_Emp_Dtl_Pkg.Update_Row (
3714: x_rowid => chk_dup_rec.Row_Id,
3715: x_employment_history_id => chk_dup_rec.Employment_History_Id,
3716: x_person_id => NVL(p_rel_person_id,chk_dup_rec.person_id),

Line 3713: Igs_Ad_Emp_Dtl_Pkg.Update_Row (

3709: SET status = '3', error_code = l_error_code
3710: WHERE interface_relemp_id = relns_emp_dtls_rec.interface_relemp_id;
3711: ELSE
3712: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3713: Igs_Ad_Emp_Dtl_Pkg.Update_Row (
3714: x_rowid => chk_dup_rec.Row_Id,
3715: x_employment_history_id => chk_dup_rec.Employment_History_Id,
3716: x_person_id => NVL(p_rel_person_id,chk_dup_rec.person_id),
3717: x_start_dt => NVL(relns_emp_dtls_rec.start_dt,chk_dup_rec.start_dt),

Line 3790: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes

3786: UPDATE igs_ad_relemp_int_all
3787: SET status = '3', error_code = l_error_code
3788: WHERE interface_relemp_id = relns_emp_dtls_rec.interface_relemp_id;
3789: ELSE
3790: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3791: Igs_Ad_Emp_Dtl_Pkg.Update_Row (
3792: x_rowid => chk_dup_rec.Row_Id,
3793: x_employment_history_id => chk_dup_rec.Employment_History_Id,
3794: x_person_id => NVL(p_rel_person_id,chk_dup_rec.person_id),

Line 3791: Igs_Ad_Emp_Dtl_Pkg.Update_Row (

3787: SET status = '3', error_code = l_error_code
3788: WHERE interface_relemp_id = relns_emp_dtls_rec.interface_relemp_id;
3789: ELSE
3790: --Signature of Igs_Ad_Emp_Dtl_Pkg is changed to include HZ.K impact changes
3791: Igs_Ad_Emp_Dtl_Pkg.Update_Row (
3792: x_rowid => chk_dup_rec.Row_Id,
3793: x_employment_history_id => chk_dup_rec.Employment_History_Id,
3794: x_person_id => NVL(p_rel_person_id,chk_dup_rec.person_id),
3795: x_start_dt => NVL(relns_emp_dtls_rec.start_dt,chk_dup_rec.start_dt),