eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.IGS_EN_GEN_011 dependencies on IGS_AD_PS_APPL_INST

Line 54: --samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all

50: -- pradhakr 15-Dec-2002 Changed the call to the update_row and update_row of
51: -- igs_en_su_attempt table to igs_en_sua_api.update_unit_attempt
52: -- and igs_en_sua_api.create_unit_attempt. Changes wrt ENCR031 build.
53: -- Bug#2643207
54: --samaresh 02-DEC-2001 Bug # 2097333 : Impact of addition of the waitlist_status field to igs_ad_ps_appl_inst_all
55: -- To the function Enrp_Upd_Acai_Accept
56: --pradhakr 12/07/2001 Added one parameter p_dcnt_reason_cd in
57: -- the procedure Enrp_prc_sua_enr_ds as part
58: -- of Enrollment build (Bug # 1832130 )

Line 79: -- new columns being added to IGS_AD_PS_APPL_INST

75: -- to table handler procedure calls as part of CCR - ENCR022.
76: --Nishikant 30-jan-2002 Added the column session_id in the Tbh calls of IGS_EN_SU_ATTEMPT_PKG
77: -- as a part of the bug 2172380.
78: --cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
79: -- new columns being added to IGS_AD_PS_APPL_INST
80: --cdcruz 21-feb-2002 Bug 2231567 Message cleanup activity
81: --nshee 29-Aug-2002 Bug 2395510 added 6 columns in IGS_AD_PS_APPL_INST as part of deferments build
82: --mesriniv 18-sep-2002 Added a new parameter waitlist_manual_ind in TBH calls of IGS_EN_SU_ATTEMPT
83: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release

Line 81: --nshee 29-Aug-2002 Bug 2395510 added 6 columns in IGS_AD_PS_APPL_INST as part of deferments build

77: -- as a part of the bug 2172380.
78: --cdcruz 18-feb-2002 Bug 2217104 Admit to future term Enhancement,updated tbh call for
79: -- new columns being added to IGS_AD_PS_APPL_INST
80: --cdcruz 21-feb-2002 Bug 2231567 Message cleanup activity
81: --nshee 29-Aug-2002 Bug 2395510 added 6 columns in IGS_AD_PS_APPL_INST as part of deferments build
82: --mesriniv 18-sep-2002 Added a new parameter waitlist_manual_ind in TBH calls of IGS_EN_SU_ATTEMPT
83: -- for Bug 2554109 MINI Waitlist Build for Jan 03 Release
84: --pkpatel 3-OCT-2002 Bug No: 2600842
85: -- Added the parameter x_auth_resp_id in the call to IGS_PE_PERS_ENCUMB_PKG.UPDATE_ROW in the procedure Enrp_Set_Pen_Expry

Line 5828: ---IGS_AD_PS_APPL_INST_APLINST_V view replaced with IGS_AD_PS_APPL_INST in the c_acaiv and c_acaiv_1 cursor

5824: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
5825: cst_pending CONSTANT VARCHAR2(10) := 'PENDING';
5826: cst_deferral CONSTANT VARCHAR2(10) := 'DEFERRAL';
5827: cst_accepted CONSTANT VARCHAR2(10) := 'ACCEPTED';
5828: ---IGS_AD_PS_APPL_INST_APLINST_V view replaced with IGS_AD_PS_APPL_INST in the c_acaiv and c_acaiv_1 cursor
5829: --due to performance issues w.r.t. 2376233 by kkillams
5830: CURSOR c_acaiv IS
5831: SELECT acaiv.person_id,
5832: acaiv.admission_appl_number,

Line 5836: FROM IGS_AD_PS_APPL_INST acaiv

5832: acaiv.admission_appl_number,
5833: acaiv.nominated_course_cd,
5834: acaiv.sequence_number,
5835: acaiv.adm_offer_resp_status
5836: FROM IGS_AD_PS_APPL_INST acaiv
5837: WHERE acaiv.person_id = p_person_id AND
5838: acaiv.admission_appl_number = p_adm_admission_appl_number AND
5839: acaiv.nominated_course_cd = p_adm_nominated_course_cd AND
5840: acaiv.sequence_number = p_adm_sequence_number AND

Line 5855: FROM IGS_AD_PS_APPL_INST acaiv

5851: acaiv.admission_appl_number,
5852: acaiv.nominated_course_cd,
5853: acaiv.sequence_number,
5854: acaiv.adm_offer_resp_status
5855: FROM IGS_AD_PS_APPL_INST acaiv
5856: WHERE acaiv.person_id = p_person_id AND
5857: acaiv.course_cd = p_course_cd AND
5858: IGS_EN_GEN_002.enrp_get_acai_offer(
5859: acaiv.adm_outcome_status,

Line 5873: FROM IGS_AD_PS_APPL_INST acai

5869: IGS_EN_STDNT_PS_ATT.adm_admission_appl_number%TYPE,
5870: cp_nominated_course_cd IGS_EN_STDNT_PS_ATT.adm_nominated_course_cd%TYPE,
5871: cp_sequence_number IGS_EN_STDNT_PS_ATT.adm_sequence_number%TYPE) IS
5872: SELECT rowid,acai.*
5873: FROM IGS_AD_PS_APPL_INST acai
5874: WHERE acai.person_id = cp_person_id AND
5875: acai.admission_appl_number = cp_admission_appl_number AND
5876: acai.nominated_course_cd = cp_nominated_course_cd AND
5877: acai.sequence_number = cp_sequence_number

Line 5917: -- Select IGS_AD_PS_APPL_INST record for update

5913:
5914: RETURN TRUE;
5915: END IF;
5916:
5917: -- Select IGS_AD_PS_APPL_INST record for update
5918: BEGIN
5919: OPEN c_acai_upd(
5920: v_acaiv_rec.person_id,
5921: v_acaiv_rec.admission_appl_number,

Line 5931: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW(

5927: v_accepted_status := IGS_AD_GEN_009.admp_get_sys_aors(
5928: cst_accepted);
5929:
5930: IF v_accepted_status IS NOT NULL THEN
5931: IGS_AD_PS_APPL_INST_PKG.UPDATE_ROW(
5932: X_ROWID => v_acai_exists.ROWID ,
5933: X_PERSON_ID => v_acai_exists.PERSON_ID ,
5934: X_ADMISSION_APPL_NUMBER => v_acai_exists.ADMISSION_APPL_NUMBER ,
5935: X_NOMINATED_COURSE_CD => v_acai_exists.NOMINATED_COURSE_CD ,

Line 6022: X_ENTRY_STATUS => v_acai_exists.ENTRY_STATUS, -- BUG Enh No : 1905651 . Added three columns in teh table IGS_AD_PS_APPL_INST_ALL

6018: X_SS_APPLICATION_ID => v_acai_exists.SS_APPLICATION_ID,
6019: X_SS_PWD => v_acai_exists.SS_PWD,
6020: X_AUTHORIZED_DT => v_acai_exists.AUTHORIZED_DT, -- BUG Enh No : 1891835 Added two columns
6021: X_AUTHORIZING_PERS_ID => v_acai_exists.AUTHORIZING_PERS_ID, -- BUG Enh No : 1891835 Added two columns
6022: X_ENTRY_STATUS => v_acai_exists.ENTRY_STATUS, -- BUG Enh No : 1905651 . Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6023: X_ENTRY_LEVEL => v_acai_exists.ENTRY_LEVEL,-- BUG Enh No :1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6024: X_SCH_APL_TO_ID => v_acai_exists.SCH_APL_TO_ID, -- BUG Enh No : 1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6025: X_FUT_ACAD_CAL_TYPE => v_acai_exists.FUTURE_ACAD_CAL_TYPE, -- Bug # 2217104
6026: X_FUT_ACAD_CI_SEQUENCE_NUMBER => v_acai_exists.FUTURE_ACAD_CI_SEQUENCE_NUMBER,-- Bug # 2217104

Line 6023: X_ENTRY_LEVEL => v_acai_exists.ENTRY_LEVEL,-- BUG Enh No :1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL

6019: X_SS_PWD => v_acai_exists.SS_PWD,
6020: X_AUTHORIZED_DT => v_acai_exists.AUTHORIZED_DT, -- BUG Enh No : 1891835 Added two columns
6021: X_AUTHORIZING_PERS_ID => v_acai_exists.AUTHORIZING_PERS_ID, -- BUG Enh No : 1891835 Added two columns
6022: X_ENTRY_STATUS => v_acai_exists.ENTRY_STATUS, -- BUG Enh No : 1905651 . Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6023: X_ENTRY_LEVEL => v_acai_exists.ENTRY_LEVEL,-- BUG Enh No :1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6024: X_SCH_APL_TO_ID => v_acai_exists.SCH_APL_TO_ID, -- BUG Enh No : 1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6025: X_FUT_ACAD_CAL_TYPE => v_acai_exists.FUTURE_ACAD_CAL_TYPE, -- Bug # 2217104
6026: X_FUT_ACAD_CI_SEQUENCE_NUMBER => v_acai_exists.FUTURE_ACAD_CI_SEQUENCE_NUMBER,-- Bug # 2217104
6027: X_FUT_ADM_CAL_TYPE => v_acai_exists.FUTURE_ADM_CAL_TYPE, -- Bug # 2217104

Line 6024: X_SCH_APL_TO_ID => v_acai_exists.SCH_APL_TO_ID, -- BUG Enh No : 1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL

6020: X_AUTHORIZED_DT => v_acai_exists.AUTHORIZED_DT, -- BUG Enh No : 1891835 Added two columns
6021: X_AUTHORIZING_PERS_ID => v_acai_exists.AUTHORIZING_PERS_ID, -- BUG Enh No : 1891835 Added two columns
6022: X_ENTRY_STATUS => v_acai_exists.ENTRY_STATUS, -- BUG Enh No : 1905651 . Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6023: X_ENTRY_LEVEL => v_acai_exists.ENTRY_LEVEL,-- BUG Enh No :1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6024: X_SCH_APL_TO_ID => v_acai_exists.SCH_APL_TO_ID, -- BUG Enh No : 1905651 Added three columns in teh table IGS_AD_PS_APPL_INST_ALL
6025: X_FUT_ACAD_CAL_TYPE => v_acai_exists.FUTURE_ACAD_CAL_TYPE, -- Bug # 2217104
6026: X_FUT_ACAD_CI_SEQUENCE_NUMBER => v_acai_exists.FUTURE_ACAD_CI_SEQUENCE_NUMBER,-- Bug # 2217104
6027: X_FUT_ADM_CAL_TYPE => v_acai_exists.FUTURE_ADM_CAL_TYPE, -- Bug # 2217104
6028: X_FUT_ADM_CI_SEQUENCE_NUMBER => v_acai_exists.FUTURE_ADM_CI_SEQUENCE_NUMBER, -- Bug # 2217104