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_CA_TYPE

Line 681: IGS_PR_RU_CA_TYPE prct

677: SELECT /*+INDEX(pra pra_spo_fk_i)*/
678: prct.*,
679: prct.ROWID
680: FROM IGS_PR_RU_APPL pra,
681: IGS_PR_RU_CA_TYPE prct
682: WHERE pra.progression_rule_cat = prct.progression_rule_cat AND
683: pra.sequence_number = prct.pra_sequence_number AND
684: pra.logical_delete_dt IS NULL AND
685: pra.s_relation_type = cst_sca AND

Line 2187: UPDATE IGS_PR_RU_CA_TYPE

2183: ELSE
2184: -- Set the start period to the next calendar instance
2185: -- to ensure it is not tested before it should be
2186: /*
2187: UPDATE IGS_PR_RU_CA_TYPE
2188: SET start_sequence_number = v_ci_sequence_number
2189: WHERE CURRENT OF c_pra_prct;
2190: CLOSE c_ci;
2191:

Line 2195: IGS_PR_RU_CA_TYPE_PKG.UPDATE_ROW(

2191:
2192: */
2193:
2194: Close c_ci;
2195: IGS_PR_RU_CA_TYPE_PKG.UPDATE_ROW(
2196: X_ROWID => v_pra_prct_rec.ROWID,
2197: X_PROGRESSION_RULE_CAT => v_pra_prct_rec.PROGRESSION_RULE_CAT,
2198: X_PRA_SEQUENCE_NUMBER => v_pra_prct_rec.PRA_SEQUENCE_NUMBER,
2199: X_PRG_CAL_TYPE => v_pra_prct_rec.PRG_CAL_TYPE,

Line 4389: FROM IGS_PR_RU_CA_TYPE prct

4385: CURSOR c_prct (
4386: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4387: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE) IS
4388: SELECT prct.ROWID
4389: FROM IGS_PR_RU_CA_TYPE prct
4390: WHERE prct.progression_rule_cat = cp_progression_rule_cat AND
4391: prct.pra_sequence_number = cp_pra_sequence_number
4392: FOR UPDATE NOWAIT;
4393: CURSOR c_pro (

Line 4581: IGS_PR_RU_CA_TYPE_PKG.DELETE_ROW(

4577: FOR v_pra_rec IN c_pra (v_spo_rec.sequence_number) LOOP
4578: FOR v_prct_rec IN c_prct (
4579: v_pra_rec.progression_rule_cat,
4580: v_pra_rec.sequence_number) LOOP
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

Line 5457: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5453: );
5454:
5455: CURSOR c_progression_rule_cat(cp_cal_type IGS_CA_INST.cal_type%TYPE) IS
5456: SELECT pra.progression_rule_cat, pra.s_relation_type
5457: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5458: WHERE pra.s_relation_type IN (cst_sca, cst_crv, cst_ou, cst_cty)
5459: AND pra.progression_rule_cat = prctv.progression_rule_cat
5460: AND pra.sequence_number = prctv.pra_sequence_number
5461: AND prctv.prg_cal_type = cp_cal_type

Line 5484: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5480: prctv.start_effective_period, prctv.num_of_applications,
5481: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5482: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5483: pra.course_type
5484: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5485: WHERE pra.s_relation_type = cst_sca
5486: AND pra.progression_rule_cat = cp_prg_rule_cat
5487: AND pra.logical_delete_dt IS NULL
5488: AND pra.sca_person_id = cp_person_id

Line 5506: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5502: prctv.start_effective_period, prctv.num_of_applications,
5503: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5504: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5505: pra.course_type
5506: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5507: WHERE pra.s_relation_type = cst_crv
5508: AND pra.progression_rule_cat = cp_prg_rule_cat
5509: AND pra.logical_delete_dt IS NULL
5510: AND pra.crv_course_cd = cp_course_cd

Line 5528: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv

5524: prctv.start_effective_period, prctv.num_of_applications,
5525: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5526: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5527: pra.course_type
5528: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv
5529: WHERE pra.s_relation_type = cst_ou
5530: AND pra.progression_rule_cat = cp_prg_rule_cat
5531: AND pra.logical_delete_dt IS NULL
5532: AND igs_pr_gen_001.prgp_get_crv_cmt (

Line 5548: igs_pr_ru_ca_type_v prctv1

5544: AND cow.version_number = cp_version_number
5545: AND cow.percentage = 100)
5546: OR NOT EXISTS ( SELECT 'x'
5547: FROM igs_pr_ru_appl pra1,
5548: igs_pr_ru_ca_type_v prctv1
5549: WHERE pra1.s_relation_type = 'OU'
5550: AND pra1.logical_delete_dt IS NULL
5551: AND pra1.progression_rule_cat =
5552: pra.progression_rule_cat

Line 5596: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv, igs_ps_ver crv

5592: prctv.start_effective_period, prctv.num_of_applications,
5593: pra.sca_person_id, pra.sca_course_cd, pra.crv_course_cd,
5594: pra.crv_version_number, pra.ou_org_unit_cd, pra.ou_start_dt,
5595: pra.course_type
5596: FROM igs_pr_ru_appl pra, igs_pr_ru_ca_type_v prctv, igs_ps_ver crv
5597: WHERE pra.s_relation_type = cst_cty
5598: AND pra.progression_rule_cat = cp_prg_rule_cat
5599: AND pra.logical_delete_dt IS NULL
5600: AND crv.course_type = pra.course_type