APPS.IGS_DA_TRNS_IMP dependencies on IGS_PS_VER

Line 1912: write_message ('Before igs_ps_ver_pkg.get_pk_for_validation ');

1908: x_return_status BOOLEAN := TRUE;
1909: BEGIN
1910: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');
1911: x_return_status := TRUE;
1912: write_message ('Before igs_ps_ver_pkg.get_pk_for_validation ');
1913:
1914: IF NOT igs_ps_ver_pkg.get_pk_for_validation (x_course_cd => p_program_cd,
1915: x_version_number => p_version_number
1916: )

Line 1914: IF NOT igs_ps_ver_pkg.get_pk_for_validation (x_course_cd => p_program_cd,

1910: ecx_debug.push ('IGS_DA_TRNS_IMP.VALIDATE_ADV_STD_DB_CONS');
1911: x_return_status := TRUE;
1912: write_message ('Before igs_ps_ver_pkg.get_pk_for_validation ');
1913:
1914: IF NOT igs_ps_ver_pkg.get_pk_for_validation (x_course_cd => p_program_cd,
1915: x_version_number => p_version_number
1916: )
1917: THEN
1918: fnd_message.set_name ('IGS', 'IGS_AV_PRG_CD_NOT_EXISTS');

Line 2086: cp_course_cd igs_ps_ver.course_cd%TYPE,

2082: FROM igs_or_institution ins
2083: WHERE ins.institution_cd = cp_ins_cd;
2084:
2085: CURSOR cur_program_exempt_totals (
2086: cp_course_cd igs_ps_ver.course_cd%TYPE,
2087: cp_version_number igs_ps_ver.version_number%TYPE,
2088: cp_local_ind VARCHAR2
2089: )
2090: IS

Line 2087: cp_version_number igs_ps_ver.version_number%TYPE,

2083: WHERE ins.institution_cd = cp_ins_cd;
2084:
2085: CURSOR cur_program_exempt_totals (
2086: cp_course_cd igs_ps_ver.course_cd%TYPE,
2087: cp_version_number igs_ps_ver.version_number%TYPE,
2088: cp_local_ind VARCHAR2
2089: )
2090: IS
2091: SELECT DECODE (cp_local_ind,

Line 2095: FROM igs_ps_ver cv

2091: SELECT DECODE (cp_local_ind,
2092: 'N', NVL (cv.external_adv_stnd_limit, -1),
2093: NVL (cv.internal_adv_stnd_limit, -1)
2094: ) adv_stnd_limit
2095: FROM igs_ps_ver cv
2096: WHERE cv.course_cd = cp_course_cd
2097: AND cv.version_number = cp_version_number;
2098:
2099: rec_cur_program_exempt_totals cur_program_exempt_totals%ROWTYPE;

Line 2504: p_course_version IN igs_ps_ver.version_number%TYPE,

2500: END validate_unit;
2501:
2502: FUNCTION create_post_unit (
2503: p_person_id IN igs_pe_person.person_id%TYPE,
2504: p_course_version IN igs_ps_ver.version_number%TYPE,
2505: p_unit_details_id IN igs_ad_term_unitdtls.unit_details_id%TYPE,
2506: p_program_cd IN igs_av_lgcy_unt_int.program_cd%TYPE,
2507: p_unit_cd IN igs_av_lgcy_unt_int.unit_cd%TYPE, --- advstnd unit
2508: p_version_number IN igs_av_lgcy_unt_int.version_number%TYPE,