APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_TCH_RESP

Line 1626: smvk 20-Dec-2002 Removed the IGS_PS_TCH_RESP_PKG.check_constraints for org_unit_cd,

1622: Change History (in reverse chronological order)
1623: Who When What
1624: smvk 12-Dec-2002 Added a boolean parameter to the function call igs_ps_val_tr.crsp_val_tr_perc.
1625: As a part of the Bug # 2696207
1626: smvk 20-Dec-2002 Removed the IGS_PS_TCH_RESP_PKG.check_constraints for org_unit_cd,
1627: as the org unit code can have value in mixed case. Bug # 2487149.
1628: ********************************************************************************************** */
1629:
1630: l_d_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;

Line 1632: CURSOR c_org(cp_org_unit_cd igs_ps_tch_resp.org_unit_cd%TYPE) IS

1628: ********************************************************************************************** */
1629:
1630: l_d_ou_start_dt igs_ps_unit_ver_all.owner_ou_start_dt%TYPE;
1631: l_c_message_name VARCHAR2 (30);
1632: CURSOR c_org(cp_org_unit_cd igs_ps_tch_resp.org_unit_cd%TYPE) IS
1633: SELECT 'X'
1634: FROM igs_or_inst_org_base_v a, igs_or_status b
1635: WHERE a.party_number = cp_org_unit_cd
1636: AND a.org_status = b.org_status

Line 1685: IF igs_ps_tch_resp_pkg.get_pk_for_validation (

1681: PROCEDURE validate_db_cons ( p_teach_resp_rec IN OUT NOCOPY igs_ps_generic_pub.unit_tr_rec_type ) AS
1682: BEGIN
1683:
1684: /* Validate PK Constraints */
1685: IF igs_ps_tch_resp_pkg.get_pk_for_validation (
1686: x_unit_cd => p_teach_resp_rec.unit_cd,
1687: x_version_number => p_teach_resp_rec.version_number,
1688: x_org_unit_cd => p_teach_resp_rec.org_unit_cd,
1689: x_ou_start_dt => l_d_ou_start_dt ) THEN

Line 1697: igs_ps_tch_resp_pkg.check_constraints ( 'UNIT_CD', p_teach_resp_rec.unit_cd );

1693: END IF;
1694:
1695: /* Validate Check Constraints */
1696: BEGIN
1697: igs_ps_tch_resp_pkg.check_constraints ( 'UNIT_CD', p_teach_resp_rec.unit_cd );
1698: EXCEPTION
1699: WHEN OTHERS THEN
1700: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_UPPER_CASE', 'UNIT_CD', 'LEGACY_TOKENS', TRUE);
1701: p_teach_resp_rec.status := 'E';

Line 1705: igs_ps_tch_resp_pkg.check_constraints ( 'PERCENTAGE', p_teach_resp_rec.percentage );

1701: p_teach_resp_rec.status := 'E';
1702: END;
1703:
1704: BEGIN
1705: igs_ps_tch_resp_pkg.check_constraints ( 'PERCENTAGE', p_teach_resp_rec.percentage );
1706: EXCEPTION
1707: WHEN OTHERS THEN
1708: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_PER_0_100', null, null, TRUE);
1709: p_teach_resp_rec.status := 'E';

Line 1807: INSERT INTO igs_ps_tch_resp

1803: END IF;
1804:
1805: IF p_tab_teach_resp(I).status = 'S' THEN
1806: /* Insert the Record */
1807: INSERT INTO igs_ps_tch_resp
1808: (unit_cd,
1809: version_number,
1810: org_unit_cd,
1811: ou_start_dt,