APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_STND_ALT_UNIT

Line 1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,

1250: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE ,
1251: p_unit_details_id IN IGS_AD_TERM_UNITDTLS.UNIT_DETAILS_ID%TYPE ,
1252: p_tst_rslt_dtls_id IN IGS_AD_TST_RSLT_DTLS.TST_RSLT_DTLS_ID%TYPE ,
1253: p_as_version_number IN IGS_AV_STND_UNIT_ALL.AS_VERSION_NUMBER%TYPE ,
1254: p_av_stnd_unit_lvl_id OUT NOCOPY IGS_AV_STND_ALT_UNIT.AV_STND_UNIT_ID%TYPE ,
1255: x_return_status OUT NOCOPY VARCHAR2
1256: )
1257: RETURN BOOLEAN
1258: /*===========================================================================+

Line 1332: IF igs_av_stnd_alt_unit_pkg.get_pk_for_validation(

1328: l_return_status := FALSE;
1329: ELSE
1330: -- av_stnd_unit_lvl_id found in table igs_av_stnd_unit_all
1331: -- check primary in table igs_av_std_alt_unit
1332: IF igs_av_stnd_alt_unit_pkg.get_pk_for_validation(
1333: x_av_stnd_unit_id => l_av_stnd_unit_lvl_id,
1334: x_alt_unit_cd => p_lgcy_adstunt_rec.alt_unit_cd,
1335: x_alt_version_number => p_lgcy_adstunt_rec.alt_version_number
1336: )THEN

Line 1988: mydebug('**** INSERT INTO IGS_AV_STND_ALT_UNIT ');

1984: p_lgcy_adstunt_rec => p_lgcy_adstunt_rec,
1985: p_av_stnd_unit_id => l_av_stnd_unit_lvl_id,
1986: p_s_adv_stnd_type => l_s_adv_stnd_type
1987: ) THEN
1988: mydebug('**** INSERT INTO IGS_AV_STND_ALT_UNIT ');
1989: INSERT INTO igs_av_stnd_alt_unit(
1990: last_update_login,
1991: created_by,
1992: creation_date,

Line 1989: INSERT INTO igs_av_stnd_alt_unit(

1985: p_av_stnd_unit_id => l_av_stnd_unit_lvl_id,
1986: p_s_adv_stnd_type => l_s_adv_stnd_type
1987: ) THEN
1988: mydebug('**** INSERT INTO IGS_AV_STND_ALT_UNIT ');
1989: INSERT INTO igs_av_stnd_alt_unit(
1990: last_update_login,
1991: created_by,
1992: creation_date,
1993: last_updated_by,