APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_CAREER_MODEL

Line 652: igs_en_career_model.enrp_get_sec_sca_status( new_references.person_id ,

648: OPEN c_course_type;
649: FETCH c_course_type INTO v_course_type;
650: CLOSE c_course_type;
651: new_references.course_attempt_status :=
652: igs_en_career_model.enrp_get_sec_sca_status( new_references.person_id ,
653: new_references.course_cd ,
654: new_references.course_attempt_status,
655: new_references.primary_program_type ,
656: new_references.primary_prog_type_source,

Line 2878: -- call the before dml of igs_en_career_model package only if the global variable skip_before_after_dml

2874: ELSIF (p_action = 'VALIDATE_DELETE') THEN
2875: Check_Child_Existance;
2876: END IF;
2877:
2878: -- call the before dml of igs_en_career_model package only if the global variable skip_before_after_dml
2879: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package
2880: -- to avoid calling before and after dml procedures during recursion of UPDATE_ROW call in the career package
2881: -- donot remove this condition ( included in career_impcat dld)
2882: IF (p_action in ('INSERT','UPDATE')) AND (NOT IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml) THEN

Line 2879: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package

2875: Check_Child_Existance;
2876: END IF;
2877:
2878: -- call the before dml of igs_en_career_model package only if the global variable skip_before_after_dml
2879: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package
2880: -- to avoid calling before and after dml procedures during recursion of UPDATE_ROW call in the career package
2881: -- donot remove this condition ( included in career_impcat dld)
2882: IF (p_action in ('INSERT','UPDATE')) AND (NOT IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml) THEN
2883:

Line 2885: IGS_EN_CAREER_MODEL.SCA_TBH_BEFORE_DML(

2881: -- donot remove this condition ( included in career_impcat dld)
2882: IF (p_action in ('INSERT','UPDATE')) AND (NOT IGS_EN_STDNT_PS_ATT_PKG.skip_before_after_dml) THEN
2883:
2884:
2885: IGS_EN_CAREER_MODEL.SCA_TBH_BEFORE_DML(
2886: p_person_id => new_references.person_id,
2887: p_course_cd => new_references.course_cd,
2888: p_version_number => new_references.version_number,
2889: p_old_course_attempt_status => old_references.course_attempt_status ,

Line 2961: -- call the after dml of igs_en_career_model package only if the global variable skip_before_after_dml

2957: END IF;
2958:
2959: END IF;
2960:
2961: -- call the after dml of igs_en_career_model package only if the global variable skip_before_after_dml
2962: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package
2963: -- to avoid calling before and after dml procedures during recursion of UPDATE_ROW call in the career package
2964: -- donot remove this condition ( included in career_impcat dld)
2965: IF (p_action in ('INSERT','UPDATE')) AND (NOT p_skip_before_after_dml) THEN

Line 2962: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package

2958:
2959: END IF;
2960:
2961: -- call the after dml of igs_en_career_model package only if the global variable skip_before_after_dml
2962: -- is false . This variable will be made true in the after dml procedure of igs_en_career_model package
2963: -- to avoid calling before and after dml procedures during recursion of UPDATE_ROW call in the career package
2964: -- donot remove this condition ( included in career_impcat dld)
2965: IF (p_action in ('INSERT','UPDATE')) AND (NOT p_skip_before_after_dml) THEN
2966:

Line 2967: IGS_EN_CAREER_MODEL.SCA_TBH_AFTER_DML(

2963: -- to avoid calling before and after dml procedures during recursion of UPDATE_ROW call in the career package
2964: -- donot remove this condition ( included in career_impcat dld)
2965: IF (p_action in ('INSERT','UPDATE')) AND (NOT p_skip_before_after_dml) THEN
2966:
2967: IGS_EN_CAREER_MODEL.SCA_TBH_AFTER_DML(
2968: p_person_id => p_new_references.person_id,
2969: p_course_cd => p_new_references.course_cd,
2970: p_version_number => p_new_references.version_number,
2971: p_old_course_attempt_status => p_old_references.course_attempt_status ,

Line 3335: /* Please don't add any code after the call to IGS_EN_CAREER_MODEL.SCA_TBH_AFTER_DML as this procedure */

3331:
3332:
3333: /**********************************************************************************************************/
3334:
3335: /* Please don't add any code after the call to IGS_EN_CAREER_MODEL.SCA_TBH_AFTER_DML as this procedure */
3336: /* recursively calls update_row resetting the package variable new_references which might result in some */
3337: /* unexpected behaviour. So, add any new code before this call. */
3338:
3339: /**********************************************************************************************************/