APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_GE_REF_CD

Line 17: p_reference_code_id IN igs_ge_ref_cd.reference_code_id%TYPE

13:
14:
15: FUNCTION validate_ref_code (
16: p_av_stnd_unit_id IN igs_av_stnd_unit_all.av_stnd_unit_id%TYPE,
17: p_reference_code_id IN igs_ge_ref_cd.reference_code_id%TYPE
18: )
19: RETURN BOOLEAN
20: IS
21: CURSOR c_untref_cd

Line 300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE

296: p_auth_pers_id OUT NOCOPY igs_pe_person.person_id%TYPE,
297: p_unit_details_id OUT NOCOPY igs_ad_term_unitdtls.unit_details_id%TYPE,
298: p_tst_rslt_dtls_id OUT NOCOPY igs_ad_tst_rslt_dtls .tst_rslt_dtls_id%TYPE,
299: p_as_version_number OUT NOCOPY igs_en_stdnt_ps_att.version_number%TYPE,
300: p_reference_code_id OUT NOCOPY igs_ge_ref_cd.reference_code_id%TYPE
301: )RETURN BOOLEAN IS
302: /*===========================================================================+
303: | FUNCTION |
304: | derive_unit_data |

Line 378: CURSOR c_ref_id (p_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE , p_reference_cd igs_ge_ref_cd.reference_cd%TYPE) IS

374: SELECT nvl(achievable_credit_points ,enrolled_credit_points) credit_points
375: FROM igs_ps_unit_ver
376: WHERE unit_cd=cp_unit_cd and version_number = cp_version_number ;
377:
378: CURSOR c_ref_id (p_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE , p_reference_cd igs_ge_ref_cd.reference_cd%TYPE) IS
379: SELECT reference_code_id
380: FROM igs_ge_ref_cd
381: WHERE reference_cd_type = p_reference_cd_type
382: AND reference_cd = p_reference_cd;

Line 380: FROM igs_ge_ref_cd

376: WHERE unit_cd=cp_unit_cd and version_number = cp_version_number ;
377:
378: CURSOR c_ref_id (p_reference_cd_type igs_ge_ref_cd.reference_cd_type%TYPE , p_reference_cd igs_ge_ref_cd.reference_cd%TYPE) IS
379: SELECT reference_code_id
380: FROM igs_ge_ref_cd
381: WHERE reference_cd_type = p_reference_cd_type
382: AND reference_cd = p_reference_cd;
383:
384: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE :=null;

Line 384: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE :=null;

380: FROM igs_ge_ref_cd
381: WHERE reference_cd_type = p_reference_cd_type
382: AND reference_cd = p_reference_cd;
383:
384: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE :=null;
385:
386: l_count NUMBER := 0;
387: l_start_dt igs_ad_term_details.start_date%TYPE;
388: l_end_dt igs_ad_term_details.end_date%TYPE;

Line 1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;

1602: L_PROGRAM_ID igs_av_stnd_unit_all.program_id%TYPE ;
1603: L_PROGRAM_APPLICATION_ID igs_av_stnd_unit_all.program_application_id%TYPE;
1604: L_PROGRAM_UPDATE_DATE igs_av_stnd_unit_all.program_update_date%TYPE;
1605: duplicate_record_exists EXCEPTION;
1606: l_reference_code_id igs_ge_ref_cd.reference_code_id%TYPE;
1607: l_AVU_REFERENCE_CD_ID IGS_AV_UNT_REF_CDS.AVU_REFERENCE_CD_ID%TYPE;
1608:
1609: CURSOR c_unit_ref_id is
1610: select IGS_AV_UNT_REF_CDS_S.nextval from dual;