DBA Data[Home] [Help]

APPS.IGS_EN_STDNT_PS_ATT_PKG dependencies on IGS_EN_GEN_009

Line 464: IF IGS_EN_GEN_009.ENRP_INS_SCA_CAH(

460: (old_references.student_confirmed_ind = new_references.student_confirmed_ind)
461: THEN
462: -- Save the rowid so that candidature attendance history can be inserted
463: -- for change of attendance type
464: IF IGS_EN_GEN_009.ENRP_INS_SCA_CAH(
465: OLD_references.person_id,
466: OLD_references.course_cd,
467: OLD_references.student_confirmed_ind,
468: OLD_references.commencement_dt,

Line 1316: -- Added four new parameters to the function call IGS_EN_GEN_009.ENRP_INS_SCA_HIST

1312: -- FOR EACH ROW
1313:
1314: -- Modified By : jbegum
1315: -- Modified for : Enhancement Bug #1832130
1316: -- Added four new parameters to the function call IGS_EN_GEN_009.ENRP_INS_SCA_HIST
1317: -- new_references.last_date_of_attendance,
1318: -- old_references.last_date_of_attendance,
1319: -- new_references.dropped_by,
1320: -- old_references.dropped_by

Line 1333: IGS_EN_GEN_009.ENRP_INS_SCA_HIST(

1329:
1330:
1331: BEGIN
1332: -- create a history
1333: IGS_EN_GEN_009.ENRP_INS_SCA_HIST(
1334: old_references.person_id,
1335: old_references.course_cd,
1336: new_references.version_number,
1337: old_references.version_number,

Line 2994: -- to IGS_EN_GEN_009.ENRP_INS_AWARD_AIM Procedure

2990: -- who when what
2991: -- ayedubat 2nd MAY 2002 Added the call,AfterRowInsertUpdate4 while inserting a record as part of the bug fix:2344079
2992: --
2993: -- ayedubat 26th,Nov,2001 This procedure is modified to add a call
2994: -- to IGS_EN_GEN_009.ENRP_INS_AWARD_AIM Procedure
2995: --
2996: -- Prajeesh 11-Jun-2002 Added the Award Aim insert call in Both Insertrow and updaterow (2364445)
2997: -------------------------------------------------------------------------------
2998: -- Bug ID : 1818617

Line 3090: -- Call to the Procedure ENRP_INS_AWARD_AIM of the Package IGS_EN_GEN_009

3086: p_deleting => FALSE);
3087: --
3088: -- This Code is added as part of the 'UK AWARD AIMS' DLD.
3089: --
3090: -- Call to the Procedure ENRP_INS_AWARD_AIM of the Package IGS_EN_GEN_009
3091: -- to insert a record in Student Program Attempt Award Aim for each default Program Award found.
3092: IF NEW_REFERENCES.COMMENCEMENT_DT IS NOT NULL THEN
3093: IGS_EN_GEN_009.ENRP_INS_AWARD_AIM (
3094: p_person_id => NEW_REFERENCES.PERSON_ID,

Line 3093: IGS_EN_GEN_009.ENRP_INS_AWARD_AIM (

3089: --
3090: -- Call to the Procedure ENRP_INS_AWARD_AIM of the Package IGS_EN_GEN_009
3091: -- to insert a record in Student Program Attempt Award Aim for each default Program Award found.
3092: IF NEW_REFERENCES.COMMENCEMENT_DT IS NOT NULL THEN
3093: IGS_EN_GEN_009.ENRP_INS_AWARD_AIM (
3094: p_person_id => NEW_REFERENCES.PERSON_ID,
3095: p_course_cd => NEW_REFERENCES.COURSE_CD,
3096: p_version_number => NEW_REFERENCES.VERSION_NUMBER,
3097: p_start_dt =>nvl( NEW_REFERENCES.COMMENCEMENT_DT,sysdate)

Line 3121: IGS_EN_GEN_009.ENRP_INS_AWARD_AIM (

3117: p_updating => TRUE,
3118: p_deleting => FALSE);
3119:
3120: IF NEW_REFERENCES.COMMENCEMENT_DT IS NOT NULL THEN
3121: IGS_EN_GEN_009.ENRP_INS_AWARD_AIM (
3122: p_person_id => NEW_REFERENCES.PERSON_ID,
3123: p_course_cd => NEW_REFERENCES.COURSE_CD,
3124: p_version_number => NEW_REFERENCES.VERSION_NUMBER,
3125: p_start_dt =>nvl( NEW_REFERENCES.COMMENCEMENT_DT,sysdate)