DBA Data[Home] [Help]

APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT_ALL

Line 1817: p_sup_unit_version_number and pass these values in the insert statements for IGS_EN_SU_ATTEMPT_ALL as part

1813: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_gen_007.enrp_get_sua_status function
1814: w.r.t. bug number 2829262
1815: rvangala 01-OCT-2003 Added core_indicator value in the INSERT statements, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
1816: ptandon 17-OCT-2003 Modified call to validate_sua to take into consideration two new OUT parameters p_sup_unit_cd and
1817: p_sup_unit_version_number and pass these values in the insert statements for IGS_EN_SU_ATTEMPT_ALL as part
1818: of Placements build. Enh Bug# 3052438.
1819: ------------------------------------------------------------------*/
1820:
1821: --

Line 2266: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2262: --
2263: -- If transfer is not applicable, insert values passed to the API . derived from source Unit Attempt.
2264: IF p_sua_dtls_rec.transfer_dt IS NULL THEN
2265:
2266: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2267: person_id,
2268: course_cd,
2269: unit_cd,
2270: version_number,

Line 2432: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (

2428: );
2429: l_stat_sua_status := l_unit_attempt_status;
2430: ELSE
2431: -- If transfer is applicable, insert values derived from source Unit Attempt.
2432: INSERT INTO IGS_EN_SU_ATTEMPT_ALL (
2433: person_id,
2434: course_cd,
2435: unit_cd,
2436: version_number,