DBA Data[Home] [Help]

APPS.IGS_EN_GEN_012 dependencies on IGS_EN_STDNT_PS_ATT_PKG

Line 6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2: /* $Header: IGSEN12B.pls 120.9 2006/04/13 01:52:36 smaddali ship $ */
3: /*-------------------------------------------------------------------------------------------------------------------------------------
4: --Change History:
5: --Who When What
6: --ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
7: call as a part of bug 3544927.
8: --npalanis 10-JUN-2003 Bug:2923413 igs_pe_typ_instances_pkgs call
9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt

Line 13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.

9: -- modified for the new employment category column added in the table
10: --pradhakr 16-Dec-2002 Changed the call to the update_row of igs_en_su_attempt
11: -- table to igs_en_sua_api.update_unit_attempt.
12: -- Changes wrt ENCR031 build. Bug#2643207
13: --nalkumar 05-OCT-2001 Modified the IGS_EN_STDNT_PS_ATT_PKG.UPDATE_ROW call.
14: -- Added four new parameters to call it as per the Bug# 2027984.
15: --Aiyer 10-Oct-2001 Added the column grading schema in all Tbh calls of IGS_EN_SU_ATTEMPT_PKG as a part of the bug 2037897.
16: --pradhakr 07-Dec-2001 Added a column deg_aud_detail_id in the TBH calls
17: -- of IGS_EN_SU_ATTEMPT_PKG as part of

Line 489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

485: || Purpose :
486: || Known limitations, enhancements or remarks :
487: || Change History :
488: || Who When What
489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
491: || call as a part of bug 3544927.
492: || smaddali 04-jul-03 Bug No: 3035523
493: || Added the logic for updating the version number in hesa program attempt details belonging to this program attempt

Line 490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

486: || Known limitations, enhancements or remarks :
487: || Change History :
488: || Who When What
489: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
490: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
491: || call as a part of bug 3544927.
492: || smaddali 04-jul-03 Bug No: 3035523
493: || Added the logic for updating the version number in hesa program attempt details belonging to this program attempt
494: || (reverse chronological order - newest change first)

Line 559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

555: -- Having gotten the lock, update the record.
556:
557: FOR c_IGS_EN_STDNT_PS_ATT_rec IN c_IGS_EN_STDNT_PS_ATT LOOP
558:
559: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
560: X_ROWID => c_IGS_EN_STDNT_PS_ATT_rec.ROWID,
561: X_PERSON_ID => c_IGS_EN_STDNT_PS_ATT_rec.PERSON_ID,
562: X_COURSE_CD => c_IGS_EN_STDNT_PS_ATT_rec.COURSE_CD,
563: X_ADVANCED_STANDING_IND => c_IGS_EN_STDNT_PS_ATT_rec.ADVANCED_STANDING_IND,

Line 827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

823: || Purpose :
824: || Known limitations, enhancements or remarks :
825: || Change History :
826: || Who When What
827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
829: || call as a part of bug 3544927.
830: || kkillams 21-03-2003 Added new parameter p_transf_course_cd to the function.
831: || Which will distigush the from where this function was called.

Line 828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

824: || Known limitations, enhancements or remarks :
825: || Change History :
826: || Who When What
827: || sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
828: || ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
829: || call as a part of bug 3544927.
830: || kkillams 21-03-2003 Added new parameter p_transf_course_cd to the function.
831: || Which will distigush the from where this function was called.
832: || Value will be passed if function is invoked from program transfer

Line 1461: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

1457: CLOSE c_prgs_in_career;
1458:
1459: END IF;
1460:
1461: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
1462: X_ROWID => c_si_en_stnd_ps_att_rec.ROWID,
1463: X_PERSON_ID => c_si_en_stnd_ps_att_rec.PERSON_ID,
1464: X_COURSE_CD => c_si_en_stnd_ps_att_rec.COURSE_CD,
1465: X_ADVANCED_STANDING_IND => c_si_en_stnd_ps_att_rec.ADVANCED_STANDING_IND,

Line 1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

1585: BEGIN
1586: /****************************************************************************
1587: History
1588: Who When Why
1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1591: call as a part of bug 3544927.
1592:
1593:

Line 1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

1586: /****************************************************************************
1587: History
1588: Who When Why
1589: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
1590: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
1591: call as a part of bug 3544927.
1592:
1593:
1594: *****************************************************************************/

Line 1848: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

1844: v_sca_crv_rec.person_id,
1845: v_sca_crv_rec.course_cd);
1846: FETCH c_sca INTO v_sca_exists;
1847: IF (c_sca%FOUND) THEN
1848: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
1849: X_ROWID => v_sca_exists.ROWID,
1850: X_PERSON_ID => v_sca_exists.PERSON_ID,
1851: X_COURSE_CD => v_sca_exists.COURSE_CD,
1852: X_ADVANCED_STANDING_IND => v_sca_exists.ADVANCED_STANDING_IND,

Line 2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

2137: v_person_id IGS_PE_PERSON.person_id%TYPE;
2138: /****************************************************************************
2139: History
2140: Who When Why
2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2143: call as a part of bug 3544927.
2144:
2145: *****************************************************************************/

Line 2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2138: /****************************************************************************
2139: History
2140: Who When Why
2141: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2142: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2143: call as a part of bug 3544927.
2144:
2145: *****************************************************************************/
2146: BEGIN

Line 2179: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

2175: BEGIN
2176: -- Having gotten the lock, update the record.
2177:
2178: FOR c_ps_att_rec IN c_ps_att LOOP
2179: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
2180: X_ROWID => c_ps_att_rec.ROWID,
2181: X_PERSON_ID => c_ps_att_rec.PERSON_ID,
2182: X_COURSE_CD => c_ps_att_rec.COURSE_CD,
2183: X_ADVANCED_STANDING_IND => c_ps_att_rec.ADVANCED_STANDING_IND,

Line 2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG

2554:
2555: /****************************************************************************
2556: History
2557: Who When Why
2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2560: call as a part of bug 3544927.
2561: *****************************************************************************/
2562: BEGIN -- enrpl_upd_get_status

Line 2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure

2555: /****************************************************************************
2556: History
2557: Who When Why
2558: sarakshi 19-Nov-2004 Enh#4000939, added column FUTURE_DATED_TRANS_FLAG in the update row call of IGS_EN_STDNT_PS_ATT_PKG
2559: ckasu 05-Apr-2004 Modified IGS_EN_STDNT_PS_ATT_Pkg.update_Row procedure
2560: call as a part of bug 3544927.
2561: *****************************************************************************/
2562: BEGIN -- enrpl_upd_get_status
2563:

Line 2613: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(

2609: FOR c_enps_att_rec IN c_enps_att LOOP
2610:
2611:
2612:
2613: Igs_En_Stdnt_Ps_Att_Pkg.UPDATE_ROW(
2614: X_ROWID => c_enps_att_rec.ROWID,
2615: X_PERSON_ID => c_enps_att_rec.PERSON_ID,
2616: X_COURSE_CD => c_enps_att_rec.COURSE_CD,
2617: X_ADVANCED_STANDING_IND => c_enps_att_rec.ADVANCED_STANDING_IND,