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_PR_RU_APPL

Line 729: gv_err_ins_pra VARCHAR2(255); -- IGS_PR_RU_APPL

725: gcst_ret_message_num CONSTANT VARCHAR2(30) := 'IGS_PS_FAIL_COPY_PRGVER_DETAI';
726: gv_other_detail VARCHAR2(255);
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

Line 736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;

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
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra
738: -- Copy a IGS_PR_RU_APPL structure. This is used when parent object
739: -- such as course versions are rolled over and need new generations of these
740: -- structures.

Line 738: -- Copy a IGS_PR_RU_APPL structure. This is used when parent object

734: gv_err_ins_popu VARCHAR2(255); -- IGS_PR_OU_UNIT
735: gv_err_ins_popf VARCHAR2(255); -- IGS_PR_OU_FND
736: gv_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;
737: BEGIN -- IGS_PR_ins_copy_pra
738: -- Copy a IGS_PR_RU_APPL structure. This is used when parent object
739: -- such as course versions are rolled over and need new generations of these
740: -- structures.
741: -- The routine also makes new copies of rules which are defined as one-off
742: -- within the progression rule application.

Line 746: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,

742: -- within the progression rule application.
743: DECLARE
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,

Line 747: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,

743: DECLARE
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)

Line 749: p_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,

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
753: BEGIN -- prgpl_ins_poc

Line 968: p_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,

964: App_Exception.Raise_Exception;
965: END prgpl_ins_poc_pous_popu;
966:
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,

Line 969: p_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,

965: END prgpl_ins_poc_pous_popu;
966:
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,

Line 974: p_new_course_cd IGS_PR_RU_APPL.crv_course_cd%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,
978: p_new_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,

Line 975: p_new_version_number IGS_PR_RU_APPL.crv_version_number%TYPE,

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,
978: p_new_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
979: p_new_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,

Line 976: p_new_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%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,
978: p_new_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
979: p_new_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
980: p_new_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,

Line 977: p_new_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%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,
978: p_new_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
979: p_new_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
980: p_new_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
981: p_call_again BOOLEAN,

Line 996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;

992: v_error_ins_pra BOOLEAN;
993: v_error_ins_pro BOOLEAN;
994: v_call_again BOOLEAN;
995: v_new_rule_num IGS_RU_RULE.sequence_number%TYPE;
996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;
997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;

Line 997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;

993: v_error_ins_pro BOOLEAN;
994: v_call_again BOOLEAN;
995: v_new_rule_num IGS_RU_RULE.sequence_number%TYPE;
996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;
997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;

Line 998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;

994: v_call_again BOOLEAN;
995: v_new_rule_num IGS_RU_RULE.sequence_number%TYPE;
996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;
997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;

Line 999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;

995: v_new_rule_num IGS_RU_RULE.sequence_number%TYPE;
996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;
997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;

Line 1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;

996: v_pra_s_relation_type IGS_PR_RU_APPL.s_relation_type%TYPE;
997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;

Line 1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;

997: v_pra_progression_rule_cd IGS_PR_RU_APPL.progression_rule_cd%TYPE;
998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;

Line 1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;

998: v_pra_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%TYPE;
999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;

Line 1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;

999: v_pra_attendance_type IGS_PR_RU_APPL.attendance_type%TYPE;
1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat

Line 1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;

1000: v_pra_ou_org_unit_cd IGS_PR_RU_APPL.ou_org_unit_cd%TYPE;
1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;

Line 1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;

1001: v_pra_ou_start_dt IGS_PR_RU_APPL.ou_start_dt%TYPE;
1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number

Line 1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;

1002: v_pra_course_type IGS_PR_RU_APPL.course_type%TYPE;
1003: v_pra_crv_course_cd IGS_PR_RU_APPL.crv_course_cd%TYPE;
1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;

Line 1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;

1004: v_pra_crv_version_number IGS_PR_RU_APPL.crv_version_number%TYPE;
1005: v_pra_sca_person_id IGS_PR_RU_APPL.sca_person_id%TYPE;
1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;

Line 1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;

1006: v_pra_sca_course_cd IGS_PR_RU_APPL.sca_course_cd%TYPE;
1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_sequence_number%TYPE;

Line 1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;

1007: v_pra_pro_progression_rule_cat
1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_sequence_number%TYPE;
1015: v_pra_message IGS_PR_RU_APPL.message%TYPE;

Line 1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;

1008: IGS_PR_RU_APPL.pro_progression_rule_cat%TYPE;
1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;

1009: v_pra_pro_pra_sequence_number
1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_sequence_number%TYPE;

1010: IGS_PR_RU_APPL.pro_pra_sequence_number%TYPE;
1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1015: v_pra_message IGS_PR_RU_APPL.message%TYPE;

1011: v_pra_pro_sequence_number IGS_PR_RU_APPL.pro_sequence_number%TYPE;
1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1016: v_pra_reference_cd IGS_PR_RU_APPL.reference_cd%TYPE;

1012: v_pra_spo_person_id IGS_PR_RU_APPL.spo_person_id%TYPE;
1013: v_pra_spo_course_cd IGS_PR_RU_APPL.spo_course_cd%TYPE;
1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1018: v_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE;

1014: v_pra_spo_sequence_number IGS_PR_RU_APPL.spo_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;

Line 1020: v_rul_sequence_number IGS_PR_RU_APPL.rul_sequence_number%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
1024: SELECT pra.s_relation_type,

Line 1021: v_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%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
1024: SELECT pra.s_relation_type,
1025: pra.progression_rule_cd,

Line 1022: v_sequence_number IGS_PR_RU_APPL.sequence_number%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
1024: SELECT pra.s_relation_type,
1025: pra.progression_rule_cd,
1026: pra.rul_sequence_number,

Line 1043: FROM IGS_PR_RU_APPL pra

1039: pra.spo_course_cd,
1040: pra.spo_sequence_number,
1041: pra.message,
1042: pra.reference_cd
1043: FROM IGS_PR_RU_APPL pra
1044: WHERE pra.progression_rule_cat = p_progression_rule_cat AND
1045: pra.sequence_number = p_sequence_number AND
1046: pra.logical_delete_dt IS NULL;
1047: CURSOR c_prgc IS

Line 1059: -- Retrieve child of old IGS_PR_RU_APPL record

1055: --gjha Changed the sequence fromPRA to PRO.
1056:
1057: SELECT IGS_PR_PRO_SEQUENCE_NO_S.NEXTVAL
1058: FROM dual;
1059: -- Retrieve child of old IGS_PR_RU_APPL record
1060: CURSOR c_prrc IS
1061: SELECT prrc.prg_cal_type,
1062: prrc.start_sequence_number,
1063: prrc.end_sequence_number,

Line 1069: -- Retrieve child of old IGS_PR_RU_APPL record

1065: prrc.num_of_applications
1066: FROM IGS_PR_RU_CA_TYPE prrc
1067: WHERE prrc.progression_rule_cat = p_progression_rule_cat AND
1068: prrc.pra_sequence_number = p_sequence_number;
1069: -- Retrieve child of old IGS_PR_RU_APPL record
1070: CURSOR c_pro IS
1071: SELECT pro.sequence_number,
1072: pro.number_of_failures,
1073: pro.progression_outcome_type,

Line 1097: FROM IGS_PR_RU_APPL pra

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
1099: pra.pro_pra_sequence_number = cp_pro_pra_sequence_number AND
1100: pra.pro_sequence_number = cp_pro_sequence_number;
1101: BEGIN

Line 1205: IGS_PR_RU_APPL_PKG.INSERT_ROW (

1201: lv_rowid VARCHAR2(25);
1202: l_org_id NUMBER(15);
1203: BEGIN
1204: l_org_id := igs_ge_gen_003.get_org_id;
1205: IGS_PR_RU_APPL_PKG.INSERT_ROW (
1206: X_ROWID =>LV_ROWID,
1207: X_PROGRESSION_RULE_CAT =>p_progression_rule_cat,
1208: X_SEQUENCE_NUMBER =>gv_new_pra_sequence_number,
1209: X_S_RELATION_TYPE =>v_pra_s_relation_type,

Line 1368: -- Records cannot be inserted because a new IGS_PR_RU_APPL

1364: CLOSE c_pra_check_pro;
1365: END IF;
1366: END LOOP;
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 ';