APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_AV_STND_UNIT_S

Line 799: CURSOR c_igs_av_stnd_unit_seq IS

795: +===========================================================================*/
796: x_return_status BOOLEAN := TRUE;
797: l_c_tmp_msg VARCHAR2(30);
798: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
799: CURSOR c_igs_av_stnd_unit_seq IS
800: select igs_av_stnd_unit_s.nextval from dual ;
801:
802: BEGIN
803:

Line 800: select igs_av_stnd_unit_s.nextval from dual ;

796: x_return_status BOOLEAN := TRUE;
797: l_c_tmp_msg VARCHAR2(30);
798: l_av_stnd_unit_lvl_id igs_av_stnd_unit_all.av_stnd_unit_id%TYPE;
799: CURSOR c_igs_av_stnd_unit_seq IS
800: select igs_av_stnd_unit_s.nextval from dual ;
801:
802: BEGIN
803:
804: OPEN c_igs_av_stnd_unit_seq ;

Line 804: OPEN c_igs_av_stnd_unit_seq ;

800: select igs_av_stnd_unit_s.nextval from dual ;
801:
802: BEGIN
803:
804: OPEN c_igs_av_stnd_unit_seq ;
805: FETCH c_igs_av_stnd_unit_seq INTO l_av_stnd_unit_lvl_id;
806: CLOSE c_igs_av_stnd_unit_seq;
807:
808: mydebug('***** Got l_av_stnd_unit_lvl_id=' ||l_av_stnd_unit_lvl_id);

Line 805: FETCH c_igs_av_stnd_unit_seq INTO l_av_stnd_unit_lvl_id;

801:
802: BEGIN
803:
804: OPEN c_igs_av_stnd_unit_seq ;
805: FETCH c_igs_av_stnd_unit_seq INTO l_av_stnd_unit_lvl_id;
806: CLOSE c_igs_av_stnd_unit_seq;
807:
808: mydebug('***** Got l_av_stnd_unit_lvl_id=' ||l_av_stnd_unit_lvl_id);
809: -- Primary key validation

Line 806: CLOSE c_igs_av_stnd_unit_seq;

802: BEGIN
803:
804: OPEN c_igs_av_stnd_unit_seq ;
805: FETCH c_igs_av_stnd_unit_seq INTO l_av_stnd_unit_lvl_id;
806: CLOSE c_igs_av_stnd_unit_seq;
807:
808: mydebug('***** Got l_av_stnd_unit_lvl_id=' ||l_av_stnd_unit_lvl_id);
809: -- Primary key validation
810: IF igs_av_stnd_unit_pkg.get_pk_for_validation(x_av_stnd_unit_id => l_av_stnd_unit_lvl_id) THEN