DBA Data[Home] [Help]

APPS.IGS_RE_GEN_001 dependencies on IGS_PS_GEN_002

Line 8: -- RESP_CLC_MIN_SBMSN the signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got

4: -------------------------------------------------------------------------------------------
5: --Change History:
6: --Who When What
7: --Nishikant 11DEC2002 ENCR027 Build (Program Length Integration) . In the function RESP_CLC_MAX_SBMSN and
8: -- RESP_CLC_MIN_SBMSN the signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got
9: -- modified, which used to get the value for the variable v_crv_eftd.
10: --vvutukur 19_oct-2002 Enh#2608227.Modified functions resp_clc_max_sbmsn,resp_clc_min_sbmsn.
11: --prchandr 08-Jan-01 Enh Bug No: 2174101, As the Part of Change in IGSEN18B
12: -- Passing NULL as parameters to ENRP_CLC_SUA_EFTSU

Line 189: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got

185: || Known limitations, enhancements or remarks :
186: || Change History :
187: || Who When What
188: || (reverse chronological order - newest change first)
189: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got
190: || modified, which used to get the value for the variable v_crv_eftd
191: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
192: || call to igs_ps_gen_002.crsp_get_crv_eftd.
193: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to

Line 192: || call to igs_ps_gen_002.crsp_get_crv_eftd.

188: || (reverse chronological order - newest change first)
189: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got
190: || modified, which used to get the value for the variable v_crv_eftd
191: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
192: || call to igs_ps_gen_002.crsp_get_crv_eftd.
193: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to
194: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851
195: ----------------------------------------------------------------------------*/
196: gv_other_detail VARCHAR2(255);

Line 194: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851

190: || modified, which used to get the value for the variable v_crv_eftd
191: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
192: || call to igs_ps_gen_002.crsp_get_crv_eftd.
193: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to
194: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851
195: ----------------------------------------------------------------------------*/
196: gv_other_detail VARCHAR2(255);
197: BEGIN -- resp_clc_max_sbmsn
198: -- Calculate the minimum submission date of a student IGS_PS_COURSE attempt

Line 354: v_crv_eftd := igs_ps_gen_002.crsp_get_crv_eftd( p_person_id,

350: --v_crv_eftd will have a valid value if the EFTD calculated properly in the
351: --below function otherwise it will have a value zero
352: --passing p_acai_nominated_course_cd since sca_course_cd will be null when called
353: -- from admissions before prenerolment is triggered
354: v_crv_eftd := igs_ps_gen_002.crsp_get_crv_eftd( p_person_id,
355: nvl(p_sca_course_cd,p_acai_nominated_course_cd));
356:
357: IF v_crv_eftd <= 0 THEN
358: -- Cannot calculate date if the IGS_PS_COURSE version has no EFTD

Line 468: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got

464: || Known limitations, enhancements or remarks :
465: || Change History :
466: || Who When What
467: || (reverse chronological order - newest change first)
468: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got
469: || modified, which used to get the value for the variable v_crv_eftd
470: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
471: || call to igs_ps_gen_002.crsp_get_crv_eftd.
472: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to

Line 471: || call to igs_ps_gen_002.crsp_get_crv_eftd.

467: || (reverse chronological order - newest change first)
468: || Nishikant 11DEC2002 The signature of the function call igs_ps_gen_002.crsp_get_crv_eftd got
469: || modified, which used to get the value for the variable v_crv_eftd
470: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
471: || call to igs_ps_gen_002.crsp_get_crv_eftd.
472: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to
473: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851
474: ----------------------------------------------------------------------------*/
475: gv_other_detail VARCHAR2(255);

Line 473: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851

469: || modified, which used to get the value for the variable v_crv_eftd
470: || vvutukur 19-Oct-2002 Enh#2608227.Added cursor cur_coo_id to fetch coo_id of course and modified
471: || call to igs_ps_gen_002.crsp_get_crv_eftd.
472: || svanukur 28-jul-2004 implemented an nvl check to pass p_acai_nominated_course_cd in the call to
473: || igs_ps_gen_002.crsp_get_crv_eftd bug 3487851
474: ----------------------------------------------------------------------------*/
475: gv_other_detail VARCHAR2(255);
476: BEGIN -- resp_clc_min_sbmsn
477: -- Calculate the minimum submission date of a student IGS_PS_COURSE attempt

Line 649: v_crv_eftd := igs_ps_gen_002.crsp_get_crv_eftd( p_person_id,

645: --v_crv_eftd will have a valid value if the EFTD calculated properly in the
646: --below function otherwise it will have a value zero
647: --passing p_acai_nominated_course_cd since sca_course_cd will be null when called
648: -- from admissions before prenerolment is triggered.
649: v_crv_eftd := igs_ps_gen_002.crsp_get_crv_eftd( p_person_id,
650: nvl(p_sca_course_cd,p_acai_nominated_course_cd));
651:
652: IF v_crv_eftd <= 0 THEN
653: -- Cannot calculate date if the IGS_PS_COURSE version has no EFTD