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

Line 731: gv_err_ins_pro VARCHAR2(255); -- IGS_PR_RU_OU

727: gv_err_inserting VARCHAR2(255);
728: gv_err_ins_rule VARCHAR2(255); -- creating progression rule
729: gv_err_ins_pra VARCHAR2(255); -- IGS_PR_RU_APPL
730: gv_err_ins_prrc VARCHAR2(255); -- IGS_PR_RU_CA_TYPE
731: gv_err_ins_pro VARCHAR2(255); -- IGS_PR_RU_OU
732: gv_err_ins_poc VARCHAR2(255); -- IGS_PR_OU_RS
733: gv_err_ins_pous VARCHAR2(255); -- IGS_PR_OU_UNIT_SET
734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND

Line 748: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,

744: v_call_again BOOLEAN;
745: PROCEDURE prgpl_ins_poc_pous_popu(
746: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
747: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
748: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
749: p_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS

Line 750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,

746: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
747: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
748: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
749: p_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS
753: BEGIN -- prgpl_ins_poc
754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET

Line 971: IGS_PR_RU_OU.progression_rule_cat%TYPE,

967: FUNCTION prgpl_ins_copy_pra(
968: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
969: p_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
970: p_prev_progression_rule_cat
971: IGS_PR_RU_OU.progression_rule_cat%TYPE,
972: p_prev_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
973: p_prev_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
974: p_new_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE,
975: p_new_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,

Line 972: p_prev_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

968: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
969: p_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
970: p_prev_progression_rule_cat
971: IGS_PR_RU_OU.progression_rule_cat%TYPE,
972: p_prev_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
973: p_prev_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
974: p_new_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE,
975: p_new_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
976: p_new_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE,

Line 973: p_prev_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,

969: p_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
970: p_prev_progression_rule_cat
971: IGS_PR_RU_OU.progression_rule_cat%TYPE,
972: p_prev_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
973: p_prev_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
974: p_new_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE,
975: p_new_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,
976: p_new_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE,
977: p_new_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE,

Line 1019: v_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE;

1015: v_pra_message IGS_PR_RU_APPL.message%TYPE;
1016: v_pra_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE;
1017: v_s_rule_call_cd IGS_PR_RU_CAT.s_rule_call_cd%TYPE;
1018: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
1019: v_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE;
1020: v_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
1021: v_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE;
1022: v_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
1023: CURSOR c_pra IS

Line 1085: FROM IGS_PR_RU_OU pro

1081: pro.encmb_course_group_cd,
1082: pro.restricted_enrolment_cp,
1083: pro.restricted_attendance_type,
1084: pro.comments
1085: FROM IGS_PR_RU_OU pro
1086: WHERE pro.progression_rule_cat = p_progression_rule_cat AND
1087: pro.pra_sequence_number = p_sequence_number AND
1088: -- anilk, bug#2784198
1089: pro.logical_delete_dt IS NULL;

Line 1092: IGS_PR_RU_OU.progression_rule_cat%TYPE,

1088: -- anilk, bug#2784198
1089: pro.logical_delete_dt IS NULL;
1090: CURSOR c_pra_check_pro (
1091: cp_pro_progression_rule_cat
1092: IGS_PR_RU_OU.progression_rule_cat%TYPE,
1093: cp_pro_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
1094: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
1095: SELECT pra.progression_rule_cat,
1096: pra.sequence_number

Line 1093: cp_pro_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

1089: pro.logical_delete_dt IS NULL;
1090: CURSOR c_pra_check_pro (
1091: cp_pro_progression_rule_cat
1092: IGS_PR_RU_OU.progression_rule_cat%TYPE,
1093: cp_pro_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
1094: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
1095: SELECT pra.progression_rule_cat,
1096: pra.sequence_number
1097: FROM IGS_PR_RU_APPL pra

Line 1094: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS

1090: CURSOR c_pra_check_pro (
1091: cp_pro_progression_rule_cat
1092: IGS_PR_RU_OU.progression_rule_cat%TYPE,
1093: cp_pro_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
1094: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
1095: SELECT pra.progression_rule_cat,
1096: pra.sequence_number
1097: FROM IGS_PR_RU_APPL pra
1098: WHERE pra.pro_progression_rule_cat = cp_pro_progression_rule_cat AND

Line 1280: IGS_PR_RU_OU_pkg.INSERT_ROW (

1276: lv_rowid VARCHAR2(25);
1277: l_org_id NUMBER(15);
1278: BEGIN
1279: l_org_id := igs_ge_gen_003.get_org_id;
1280: IGS_PR_RU_OU_pkg.INSERT_ROW (
1281: X_ROWID =>lv_rowid,
1282: X_PROGRESSION_RULE_CAT=> p_progression_rule_cat,
1283: X_PRA_SEQUENCE_NUMBER=> gv_new_pra_sequence_number,
1284: X_SEQUENCE_NUMBER =>v_new_pro_sequence_number,

Line 1305: gv_err_ins_pro := 'IGS_PR_RU_OU ';

1301: END;
1302: EXCEPTION
1303: WHEN OTHERS THEN
1304: v_error_ins_pro := TRUE;
1305: gv_err_ins_pro := 'IGS_PR_RU_OU ';
1306: IF (SQLCODE >= gcst_max_error_range AND
1307: SQLCODE <= gcst_min_error_range) THEN
1308: p_message_name := gcst_ret_message_num;
1309: ELSE

Line 1371: gv_err_ins_pro := 'IGS_PR_RU_OU ';

1367: ELSE
1368: -- Records cannot be inserted because a new IGS_PR_RU_APPL
1369: -- record was not created.
1370: gv_err_ins_prrc := 'IGS_PR_RU_CA_TYPE ';
1371: gv_err_ins_pro := 'IGS_PR_RU_OU ';
1372: gv_err_ins_poc := 'IGS_PR_OU_RS ';
1373: gv_err_ins_pous := 'IGS_PR_OU_UNIT_SET ';
1374: gv_err_ins_popu := 'IGS_PR_OU_UNIT ';
1375: gv_err_ins_popf := 'IGS_PR_OU_FND';