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_PR_GEN_004 dependencies on IGS_PR_RU_OU

Line 3670: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,

3666: PROCEDURE prgpl_add_stdnt_prg_outcomes (
3667: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
3668: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3669: p_original_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3670: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
3671: p_apply_automatically_ind IGS_PR_RU_OU.apply_automatically_ind%TYPE,
3672: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
3673: p_rule_check_dt DATE,
3674: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,

Line 3671: p_apply_automatically_ind IGS_PR_RU_OU.apply_automatically_ind%TYPE,

3667: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
3668: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3669: p_original_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
3670: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
3671: p_apply_automatically_ind IGS_PR_RU_OU.apply_automatically_ind%TYPE,
3672: p_sca_version_number IGS_EN_STDNT_PS_ATT.version_number%TYPE,
3673: p_rule_check_dt DATE,
3674: p_progression_outcome_type IGS_PR_STDNT_PR_OU.progression_outcome_type%TYPE,
3675: p_duration IGS_PR_STDNT_PR_OU.duration%TYPE,

Line 4114: cp_consecutive_failures IGS_PR_RU_OU.number_of_failures%TYPE)

4110: v_repeat_found BOOLEAN DEFAULT FALSE;
4111: v_spo_added BOOLEAN DEFAULT FALSE;
4112: CURSOR c_praov (
4113: cp_consecrpt VARCHAR2,
4114: cp_consecutive_failures IGS_PR_RU_OU.number_of_failures%TYPE)
4115: IS
4116: SELECT praov.sequence_number,
4117: praov.number_of_failures,
4118: praov.progression_outcome_type,

Line 4397: FROM IGS_PR_RU_OU pro

4393: CURSOR c_pro (
4394: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4395: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS
4396: SELECT pro.*
4397: FROM IGS_PR_RU_OU pro
4398: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
4399: pro.pra_sequence_number = cp_pra_sequence_number
4400: FOR UPDATE NOWAIT;
4401: CURSOR c_poc (

Line 4404: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

4400: FOR UPDATE NOWAIT;
4401: CURSOR c_poc (
4402: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4403: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4404: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4405: SELECT poc.progression_rule_cat, poc.ROWID
4406: FROM IGS_PR_OU_PS poc
4407: WHERE poc.progression_rule_cat = cp_progression_rule_cat AND
4408: poc.pra_sequence_number = cp_pra_sequence_number AND

Line 4416: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

4412:
4413: CURSOR c_pous (
4414: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4415: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4416: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4417: SELECT pous.ROWID
4418: FROM IGS_PR_OU_UNIT_SET pous
4419: WHERE pous.progression_rule_cat = cp_progression_rule_cat AND
4420: pous.pra_sequence_number = cp_pra_sequence_number AND

Line 4427: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

4423:
4424: CURSOR c_poa (
4425: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4426: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4427: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4428: SELECT poa.ROWID
4429: FROM IGS_PR_OU_AWD poa
4430: WHERE poa.progression_rule_cat = cp_progression_rule_cat AND
4431: poa.pra_sequence_number = cp_pra_sequence_number AND

Line 4438: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

4434:
4435: CURSOR c_popu (
4436: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4437: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4438: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4439: SELECT popu.ROWID
4440: FROM IGS_PR_OU_UNIT popu
4441: WHERE popu.progression_rule_cat = cp_progression_rule_cat AND
4442: popu.pra_sequence_number = cp_pra_sequence_number AND

Line 4459: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

4455:
4456: CURSOR c_pfnd (
4457: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4458: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4459: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4460: SELECT pfnd.ROWID
4461: FROM IGS_PR_OU_FND pfnd
4462: WHERE pfnd.progression_rule_cat = cp_progression_rule_cat AND
4463: pfnd.pra_sequence_number = cp_pra_sequence_number AND

Line 4585: -- Delete from IGS_PR_RU_OU

4581: IGS_PR_RU_CA_TYPE_PKG.DELETE_ROW(
4582: v_prct_rec.ROWID
4583: );
4584: END LOOP;
4585: -- Delete from IGS_PR_RU_OU
4586: FOR v_pro_rec IN c_pro (
4587: v_pra_rec.progression_rule_cat,
4588: v_pra_rec.sequence_number) LOOP
4589:

Line 4641: IGS_PR_RU_OU_PKG.UPDATE_ROW(

4637: -- End of new code added as per the FA110 PR Enh. Bug# 2658550.
4638: --
4639:
4640: -- anilk, bug#2784198
4641: IGS_PR_RU_OU_PKG.UPDATE_ROW(
4642: X_ROWID => v_pro_rec.ROW_ID ,
4643: X_PROGRESSION_RULE_CAT => v_pro_rec.PROGRESSION_RULE_CAT ,
4644: X_PRA_SEQUENCE_NUMBER => v_pro_rec.PRA_SEQUENCE_NUMBER,
4645: X_SEQUENCE_NUMBER => v_pro_rec.SEQUENCE_NUMBER,