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.

APPS.IGS_EN_GEN_011 dependencies on IGS_PE_FUND_EXCL

Line 86: -- Added the expiry date synchronization logic for table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry

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
86: -- Added the expiry date synchronization logic for table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry
87: --ssawhney 09-10-2002 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
88: -- Added the expiry date synchronization logic for new table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry
89: --kkillams 03-10-2002 1)Three New p_unit_loc_cd, p_unit_class,p_reason parameters are added to Enrp_Prc_Sua_Blk_E_D procedure.
90: -- 2)Three New p_enforce_val,p_enroll_method,p_reason parameters are added to Enrp_Prc_Sua_Blk_Trn procedure.

Line 88: -- Added the expiry date synchronization logic for new table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry

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
86: -- Added the expiry date synchronization logic for table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry
87: --ssawhney 09-10-2002 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
88: -- Added the expiry date synchronization logic for new table IGS_PE_FUND_EXCL in the procedure Enrp_Set_Pee_Expry
89: --kkillams 03-10-2002 1)Three New p_unit_loc_cd, p_unit_class,p_reason parameters are added to Enrp_Prc_Sua_Blk_E_D procedure.
90: -- 2)Three New p_enforce_val,p_enroll_method,p_reason parameters are added to Enrp_Prc_Sua_Blk_Trn procedure.
91: -- w.r.t. build Drop Trasfer workflow notification(Bug no: 2599925)
92: --svenkata 28-10-2002 Added new parameters to the call of fn eval_min_cp . Enrollment Eligibility and Valdns build - Bug# 2616692.

Line 5459: || Added logic for the new table IGS_PE_FUND_EXCL

5455: || Known limitations, enhancements or remarks :
5456: || Change History :
5457: || Who When What
5458: || pkpatel 3-OCT-2002 Bug No: 2600842
5459: || Added logic for the new table IGS_PE_FUND_EXCL
5460: || (reverse chronological order - newest change first)
5461: */
5462: BEGIN -- enrp_set_pee_expry
5463: -- Set the expiry date for all cild records of the nominated pee

Line 5512: SELECT rowid,igs_pe_fund_excl.*

5508: expiry_dt > p_expiry_dt)
5509: FOR UPDATE OF expiry_dt NOWAIT;
5510:
5511: CURSOR fund_exclusion_cur IS
5512: SELECT rowid,igs_pe_fund_excl.*
5513: FROM igs_pe_fund_excl
5514: WHERE
5515: person_id = p_person_id AND
5516: encumbrance_type = p_encumbrance_type AND

Line 5513: FROM igs_pe_fund_excl

5509: FOR UPDATE OF expiry_dt NOWAIT;
5510:
5511: CURSOR fund_exclusion_cur IS
5512: SELECT rowid,igs_pe_fund_excl.*
5513: FROM igs_pe_fund_excl
5514: WHERE
5515: person_id = p_person_id AND
5516: encumbrance_type = p_encumbrance_type AND
5517: pen_start_dt = p_pen_start_dt AND

Line 5649: IGS_PE_FUND_EXCL_PKG.UPDATE_ROW(

5645: INTO l_dcd_date
5646: FROM DUAL;
5647:
5648:
5649: IGS_PE_FUND_EXCL_PKG.UPDATE_ROW(
5650: X_ROWID => fund_exclusion_rec.ROWID ,
5651: X_FUND_EXCL_ID => fund_exclusion_rec.FUND_EXCL_ID,
5652: X_PERSON_ID => fund_exclusion_rec.PERSON_ID ,
5653: X_ENCUMBRANCE_TYPE => fund_exclusion_rec.ENCUMBRANCE_TYPE ,