APPS.IGS_AV_UNT_LGCY_PUB dependencies on IGS_PS_VER

Line 495: p_version_number IN igs_ps_ver_all.version_number%TYPE,

491:
492:
493: FUNCTION validate_unit_basis(
494: p_person_id IN igs_pe_person.person_id%TYPE,
495: p_version_number IN igs_ps_ver_all.version_number%TYPE,
496: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
497: )RETURN BOOLEAN IS
498: /*===========================================================================+
499: | FUNCTION |

Line 540: p_version_number IN igs_ps_ver_all.version_number%TYPE,

536: RETURN l_b_return_val;
537: END validate_unit_basis;
538:
539: FUNCTION validate_adv_std_db_cons(
540: p_version_number IN igs_ps_ver_all.version_number%TYPE,
541: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
542: )RETURN BOOLEAN IS
543: /*===========================================================================+
544: | FUNCTION |

Line 567: mydebug('Before igs_ps_ver_pkg.get_pk_for_validation ' );

563: +===========================================================================*/
564: x_return_status BOOLEAN :=TRUE;
565: BEGIN
566: x_return_status := TRUE;
567: mydebug('Before igs_ps_ver_pkg.get_pk_for_validation ' );
568: IF NOT igs_ps_ver_pkg.get_pk_for_validation
569: (
570: x_course_cd => p_lgcy_adstunt_rec.program_cd,
571: x_version_number => p_version_number

Line 568: IF NOT igs_ps_ver_pkg.get_pk_for_validation

564: x_return_status BOOLEAN :=TRUE;
565: BEGIN
566: x_return_status := TRUE;
567: mydebug('Before igs_ps_ver_pkg.get_pk_for_validation ' );
568: IF NOT igs_ps_ver_pkg.get_pk_for_validation
569: (
570: x_course_cd => p_lgcy_adstunt_rec.program_cd,
571: x_version_number => p_version_number
572: ) THEN

Line 583: p_version_number IN igs_ps_ver_all.version_number%TYPE,

579: END validate_adv_std_db_cons;
580:
581: FUNCTION validate_adv_stnd(
582: p_person_id IN igs_pe_person.person_id%TYPE,
583: p_version_number IN igs_ps_ver_all.version_number%TYPE,
584: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
585: )RETURN BOOLEAN IS
586: /*===========================================================================+
587: | FUNCTION |

Line 679: cp_course_cd igs_ps_ver.course_cd%type,

675: SELECT ins.local_institution_ind
676: FROM igs_or_institution ins
677: WHERE ins.institution_cd = cp_ins_cd;
678: CURSOR cur_program_exempt_totals (
679: cp_course_cd igs_ps_ver.course_cd%type,
680: cp_version_number igs_ps_ver.version_number%type,
681: cp_local_ind VARCHAR2) IS
682: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
683: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit

Line 680: cp_version_number igs_ps_ver.version_number%type,

676: FROM igs_or_institution ins
677: WHERE ins.institution_cd = cp_ins_cd;
678: CURSOR cur_program_exempt_totals (
679: cp_course_cd igs_ps_ver.course_cd%type,
680: cp_version_number igs_ps_ver.version_number%type,
681: cp_local_ind VARCHAR2) IS
682: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
683: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
684: FROM igs_ps_ver cv

Line 684: FROM igs_ps_ver cv

680: cp_version_number igs_ps_ver.version_number%type,
681: cp_local_ind VARCHAR2) IS
682: SELECT DECODE (cp_local_ind, 'N', NVL (cv.external_adv_stnd_limit, -1),
683: NVL (cv.internal_adv_stnd_limit, -1)) adv_stnd_limit
684: FROM igs_ps_ver cv
685: WHERE cv.course_cd = cp_course_cd
686: AND cv.version_number = cp_version_number;
687: rec_cur_program_exempt_totals cur_program_exempt_totals%ROWTYPE;
688: rec_local_inst_ind c_local_inst_ind%ROWTYPE;

Line 1167: p_course_version IN igs_ps_ver.version_number%type,

1163:
1164:
1165: FUNCTION create_post_unit(
1166: p_person_id IN igs_pe_person.person_id%type,
1167: p_course_version IN igs_ps_ver.version_number%type,
1168: p_unit_details_id IN igs_ad_term_unitdtls. unit_details_id%type,
1169: p_tst_rslt_dtls_id IN igs_ad_tst_rslt_dtls.tst_rslt_dtls_id%type,
1170: p_lgcy_adstunt_rec IN lgcy_adstunt_rec_type
1171: )RETURN BOOLEAN IS