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_PR_GEN_006 dependencies on IGS_PE_CRS_GRP_EXCL

Line 2680: FROM igs_pe_crs_grp_excl pcge

2676: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2677: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2678: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
2679: SELECT pcge.*, pcge.ROWID
2680: FROM igs_pe_crs_grp_excl pcge
2681: WHERE pcge.person_id = p_person_id AND
2682: pcge.encumbrance_type = cp_encumbrance_type AND
2683: pcge.pen_start_dt = cp_pen_start_dt AND
2684: pcge.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 2690: TYPE t_pcge_table IS TABLE OF igs_pe_crs_grp_excl.course_group_cd%TYPE

2686: pcge.pee_sequence_number = cp_pee_sequence_number AND
2687: (pcge.expiry_dt IS NULL OR
2688: pcge.expiry_dt > gcst_sysdate)
2689: FOR UPDATE NOWAIT;
2690: TYPE t_pcge_table IS TABLE OF igs_pe_crs_grp_excl.course_group_cd%TYPE
2691: INDEX BY BINARY_INTEGER;
2692:
2693: v_pcge_table t_pcge_table;
2694: v_pcge_index BINARY_INTEGER;

Line 2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,

2698: cp_pen_start_dt IGS_PE_PERSENC_EFFCT.pen_start_dt%TYPE,
2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS
2704: SELECT pcge.*, pcge.ROWID
2705: FROM igs_pe_crs_grp_excl pcge
2706: WHERE pcge.person_id = p_person_id AND

Line 2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS

2699: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
2700: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS
2704: SELECT pcge.*, pcge.ROWID
2705: FROM igs_pe_crs_grp_excl pcge
2706: WHERE pcge.person_id = p_person_id AND
2707: pcge.encumbrance_type = cp_encumbrance_type AND

Line 2705: FROM igs_pe_crs_grp_excl pcge

2701: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE,
2702: cp_course_group_cd igs_pe_crs_grp_excl.course_group_cd%TYPE,
2703: cp_pcge_start_dt igs_pe_crs_grp_excl.pcge_start_dt%TYPE) IS
2704: SELECT pcge.*, pcge.ROWID
2705: FROM igs_pe_crs_grp_excl pcge
2706: WHERE pcge.person_id = p_person_id AND
2707: pcge.encumbrance_type = cp_encumbrance_type AND
2708: pcge.pen_start_dt = cp_pen_start_dt AND
2709: pcge.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3059: FROM igs_pe_crs_grp_excl pcge

3055: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3056: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3057: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3058: SELECT pcge.*, pcge.ROWID
3059: FROM igs_pe_crs_grp_excl pcge
3060: WHERE pcge.person_id = p_person_id AND
3061: pcge.encumbrance_type = cp_encumbrance_type AND
3062: pcge.pen_start_dt = cp_pen_start_dt AND
3063: pcge.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3181: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(

3177: v_pen_rec.start_dt,
3178: v_pee_rec.s_encmb_effect_type,
3179: v_pee_rec.pee_start_dt,
3180: v_pee_rec.sequence_number) LOOP
3181: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(
3182: X_ROWID => v_pcge_rec.ROWID,
3183: X_PERSON_ID => v_pcge_rec.PERSON_ID,
3184: X_ENCUMBRANCE_TYPE => v_pcge_rec.ENCUMBRANCE_TYPE,
3185: X_PEN_START_DT => v_pcge_rec.PEN_START_DT,

Line 3459: FROM igs_pe_crs_grp_excl pcge

3455: cp_s_encmb_effect_type IGS_PE_PERSENC_EFFCT.s_encmb_effect_type%TYPE,
3456: cp_pee_start_dt IGS_PE_PERSENC_EFFCT.pee_start_dt%TYPE,
3457: cp_pee_sequence_number IGS_PE_PERSENC_EFFCT.sequence_number%TYPE) IS
3458: SELECT pcge.*, pcge.ROWID
3459: FROM igs_pe_crs_grp_excl pcge
3460: WHERE pcge.person_id = p_person_id AND
3461: pcge.encumbrance_type = cp_encumbrance_type AND
3462: pcge.pen_start_dt = cp_pen_start_dt AND
3463: pcge.s_encmb_effect_type = cp_s_encmb_effect_type AND

Line 3568: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(

3564: v_pee_rec.pen_start_dt,
3565: v_pee_rec.s_encmb_effect_type,
3566: v_pee_rec.pee_start_dt,
3567: v_pee_rec.sequence_number) LOOP
3568: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(
3569: X_ROWID => v_pcge_rec.ROWID,
3570: X_PERSON_ID => v_pcge_rec.PERSON_ID,
3571: X_ENCUMBRANCE_TYPE => v_pcge_rec.ENCUMBRANCE_TYPE,
3572: X_PEN_START_DT => v_pcge_rec.PEN_START_DT,

Line 4078: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(

4074: -- Add pcge.course_cd to pcge PL/SQL table
4075: v_pcge_index := v_pcge_index + 1;
4076: v_pcge_table(v_pcge_index) := v_pcge_rec.course_group_cd;
4077: IF v_pcge_rec.course_group_cd <> v_spo_rec.encmb_course_group_cd THEN
4078: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(
4079: X_ROWID => v_pcge_rec.ROWID,
4080: X_PERSON_ID => v_pcge_rec.PERSON_ID,
4081: X_ENCUMBRANCE_TYPE => v_pcge_rec.ENCUMBRANCE_TYPE,
4082: X_PEN_START_DT => v_pcge_rec.PEN_START_DT,

Line 4113: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(

4109: v_spo_rec.encmb_course_group_cd,
4110: gcst_sysdate);
4111: FETCH c_pcge_dup INTO v_pcge_dup_rec;
4112: IF c_pcge_dup%FOUND THEN
4113: igs_pe_crs_grp_excl_pkg.UPDATE_ROW(
4114: X_ROWID => v_pcge_dup_rec.ROWID,
4115: X_PERSON_ID => v_pcge_dup_rec.PERSON_ID,
4116: X_ENCUMBRANCE_TYPE => v_pcge_dup_rec.ENCUMBRANCE_TYPE,
4117: X_PEN_START_DT => v_pcge_dup_rec.PEN_START_DT,

Line 4132: igs_pe_crs_grp_excl_pkg.INSERT_ROW(

4128: CLOSE c_pcge_dup;
4129: DECLARE
4130: lv_rowid VARCHAR2(25);
4131: BEGIN
4132: igs_pe_crs_grp_excl_pkg.INSERT_ROW(
4133: X_ROWID => lv_rowid,
4134: X_PERSON_ID => P_PERSON_ID,
4135: X_ENCUMBRANCE_TYPE => v_pee_rec.ENCUMBRANCE_TYPE,
4136: X_PEN_START_DT => v_pee_rec.PEN_START_DT,

Line 4723: igs_pe_crs_grp_excl_pkg.INSERT_ROW (

4719: ELSIF v_etde_table(v_index1).s_encmb_effect_type = cst_exc_crs_gp THEN
4720: DECLARE
4721: lv_rowid VARCHAR2(25);
4722: BEGIN
4723: igs_pe_crs_grp_excl_pkg.INSERT_ROW (
4724: X_ROWID =>lv_rowid,
4725: X_PERSON_ID =>p_person_id,
4726: X_ENCUMBRANCE_TYPE=> v_spo_rec.encumbrance_type,
4727: X_PEN_START_DT =>gcst_sysdatetime, --gjha Changed it from sysdatetime --Modified by Prajeesh to sysdatetime