APPS.IGS_PS_CREATE_GENERIC_PKG dependencies on IGS_EN_USEC_DISC_DL

Line 9647: IF igs_en_usec_disc_dl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,

9643: BEGIN
9644:
9645: IF p_insert_update = 'I' THEN
9646: -- Unique Key Validation
9647: IF igs_en_usec_disc_dl_pkg.get_uk_for_validation ( x_uoo_id => l_n_uoo_id,
9648: x_administrative_unit_status => p_usec_enr_dis_rec.administrative_unit_status ) THEN
9649: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_EXISTS', 'ENR_DISCONTINUATION', 'LEGACY_TOKENS', FALSE);
9650: p_usec_enr_dis_rec.status := 'W';
9651: RETURN;

Line 9686: FROM igs_en_usec_disc_dl

9682: FUNCTION check_insert_update ( p_usec_enr_dis_rec IN OUT NOCOPY igs_ps_generic_pub.usec_enr_dis_rec_type) RETURN VARCHAR2 IS
9683:
9684: CURSOR c_enr_disc IS
9685: SELECT 'X'
9686: FROM igs_en_usec_disc_dl
9687: WHERE uoo_id = l_n_uoo_id
9688: AND administrative_unit_status = p_usec_enr_dis_rec.administrative_unit_status;
9689:
9690: l_c_var VARCHAR2(1);

Line 9723: FROM igs_en_usec_disc_dl

9719: l_cur_disc_details cur_disc_details%ROWTYPE;
9720:
9721: CURSOR c_enr_disc IS
9722: SELECT *
9723: FROM igs_en_usec_disc_dl
9724: WHERE uoo_id = l_n_uoo_id
9725: AND administrative_unit_status = p_usec_enr_dis_rec.administrative_unit_status;
9726: l_c_enr_disc c_enr_disc%ROWTYPE;
9727:

Line 10003: INSERT INTO IGS_EN_USEC_DISC_DL(

9999:
10000: IF p_usec_enr_dis_tbl(I).status = 'S' THEN
10001:
10002: IF l_insert_update = 'I' THEN
10003: INSERT INTO IGS_EN_USEC_DISC_DL(
10004: usec_disc_dl_id ,
10005: non_std_disc_dl_stp_id ,
10006: administrative_unit_status,
10007: definition_code ,

Line 10023: igs_en_usec_disc_dl_s.NEXTVAL,

10019: last_updated_by,
10020: last_update_date,
10021: last_update_login )
10022: VALUES (
10023: igs_en_usec_disc_dl_s.NEXTVAL,
10024: l_n_non_std_disc_dl_stp_id,
10025: p_usec_enr_dis_tbl(I).administrative_unit_status,
10026: l_c_definition_code,
10027: l_c_org_unit_code,

Line 10050: UPDATE IGS_EN_USEC_DISC_DL SET

10046: p_usec_enr_dis_tbl(I).unit_class||' '||'Administrative_unit_status:'||p_usec_enr_dis_tbl(I).administrative_unit_status);
10047: END IF;
10048:
10049: ELSE
10050: UPDATE IGS_EN_USEC_DISC_DL SET
10051: non_std_disc_dl_stp_id = l_n_non_std_disc_dl_stp_id,
10052: definition_code = l_c_definition_code,
10053: org_unit_code = l_c_org_unit_code,
10054: formula_method = l_c_formula_method,