APPS.IGS_PR_GEN_006 dependencies on IGS_PE_CRS_GRP_EXCL_PKG

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 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