APPS.IGS_DA_TRNS_IMP dependencies on IGS_PS_UNIT_VER

Line 1786: FROM igs_ps_unit_ver

1782: IS
1783: SELECT NVL (achievable_credit_points,
1784: enrolled_credit_points
1785: ) credit_points
1786: FROM igs_ps_unit_ver
1787: WHERE unit_cd = cp_unit_cd AND version_number = cp_version_number;
1788:
1789: l_count NUMBER := 0;
1790: l_start_dt igs_ad_term_details.start_date%TYPE;

Line 2259: write_message ( 'igs_ps_unit_ver_pkg.get_pk_for_validation'

2255: )
2256: );
2257: END IF;
2258:
2259: write_message ( 'igs_ps_unit_ver_pkg.get_pk_for_validation'
2260: || p_unit_cd
2261: || ' '
2262: || p_version_number
2263: );

Line 2265: -- Foreign Key with Table IGS_PS_UNIT_VER

2261: || ' '
2262: || p_version_number
2263: );
2264:
2265: -- Foreign Key with Table IGS_PS_UNIT_VER
2266: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (x_unit_cd => p_unit_cd,
2267: x_version_number => p_version_number
2268: )
2269: THEN

Line 2266: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (x_unit_cd => p_unit_cd,

2262: || p_version_number
2263: );
2264:
2265: -- Foreign Key with Table IGS_PS_UNIT_VER
2266: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (x_unit_cd => p_unit_cd,
2267: x_version_number => p_version_number
2268: )
2269: THEN
2270: fnd_message.set_name ('IGS', 'IGS_AV_ADV_STUNT_UNIT_EXISTS');

Line 2273: write_message ('validate_std_unt_db_cons IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION '

2269: THEN
2270: fnd_message.set_name ('IGS', 'IGS_AV_ADV_STUNT_UNIT_EXISTS');
2271: fnd_msg_pub.ADD;
2272: x_return_status := FALSE;
2273: write_message ('validate_std_unt_db_cons IGS_PS_UNIT_VER_PKG.GET_PK_FOR_VALIDATION '
2274: );
2275: notify_error (p_batch_id,
2276: p_person_id,
2277: p_program_cd,

Line 2669: FROM igs_ps_unit_ver_all OUTER

2665:
2666: CURSOR c_unit_ver
2667: IS
2668: SELECT version_number
2669: FROM igs_ps_unit_ver_all OUTER
2670: WHERE unit_cd = l_unit_cd
2671: AND unit_status = 'ACTIVE'
2672: AND version_number =
2673: (SELECT MAX (version_number)

Line 2674: FROM igs_ps_unit_ver_all inn

2670: WHERE unit_cd = l_unit_cd
2671: AND unit_status = 'ACTIVE'
2672: AND version_number =
2673: (SELECT MAX (version_number)
2674: FROM igs_ps_unit_ver_all inn
2675: WHERE OUTER.unit_cd = inn.unit_cd
2676: AND inn.unit_status = 'ACTIVE');
2677:
2678: CURSOR c_present_inst