DBA Data[Home] [Help]

APPS.IGS_EN_CAREER_MODEL dependencies on IGS_EN_STDNT_PS_ATT_PKG

Line 3: -- sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG in the procedure SCA_TBH_AFTER_DML

1: PACKAGE BODY IGS_EN_CAREER_MODEL AS
2: /* $Header: IGSEN86B.pls 120.0 2005/06/02 00:47:32 appldev noship $ */
3: -- sarakshi 16-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG in the procedure SCA_TBH_AFTER_DML
4: -- svenkata 7-JAN-2002 Bug No. 2172405 Standard Flex Field columns have been added
5: -- to table handler procedure calls as part of CCR - ENCR022.
6: -- smaddali 25-feb-2002 Bug# 2233348 ENCR018 ccr. modified procedure
7: -- before_tbh because a utp case failed in IGSEN022

Line 458: --donot allow calls to before dml and after dml of this package from igs_en_stdnt_ps_att_pkg

454: OPEN c_course_type(c_course_cd, c_version_number ) ;
455: FETCH c_course_type INTO v_course_type;
456: CLOSE c_course_type;
457:
458: --donot allow calls to before dml and after dml of this package from igs_en_stdnt_ps_att_pkg
459: -- this is to prevent recursion of the update row call below
460: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;
461: -- update all the records other than the current record if needed
462: FOR v_sca_upd_rec IN c_sca_upd(v_course_type ,c_person_id, c_course_cd)

Line 460: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;

456: CLOSE c_course_type;
457:
458: --donot allow calls to before dml and after dml of this package from igs_en_stdnt_ps_att_pkg
459: -- this is to prevent recursion of the update row call below
460: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := TRUE ;
461: -- update all the records other than the current record if needed
462: FOR v_sca_upd_rec IN c_sca_upd(v_course_type ,c_person_id, c_course_cd)
463: LOOP
464:

Line 574: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(

570: */
571:
572: IF v_update THEN -- update the record only if some thing has changed.
573:
574: IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW(
575: X_ROWID => v_sca_upd_rec.row_id,
576: X_PERSON_ID => v_sca_upd_rec.PERSON_ID,
577: X_COURSE_CD => v_sca_upd_rec.COURSE_CD,
578: X_ADVANCED_STANDING_IND => v_sca_upd_rec.ADVANCED_STANDING_IND,

Line 655: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire

651: END IF;
652:
653: END LOOP;
654:
655: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
656: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
657:
658: END SCA_TBH_AFTER_DML;
659:

Line 656: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;

652:
653: END LOOP;
654:
655: --allow calls before dml and after dml to this package from igs_en_stdnt_ps_att_pkg to fire
656: IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml := FALSE ;
657:
658: END SCA_TBH_AFTER_DML;
659:
660: