APPS.IGS_AD_GEN_001 dependencies on IGS_PR_RU_APPL_ALL

Line 1755: -- Delete IGS_PR_RU_APPL_ALL records

1751: p_course_cd IGS_EN_STDNT_PS_ATT.course_cd%TYPE)
1752: RETURN BOOLEAN
1753: IS
1754: BEGIN -- admpl_upd_pr_rule_appl
1755: -- Delete IGS_PR_RU_APPL_ALL records
1756: DECLARE
1757: CURSOR c_pra IS
1758: SELECT progression_rule_cat,
1759: sequence_number

Line 1760: FROM IGS_PR_RU_APPL_ALL pra

1756: DECLARE
1757: CURSOR c_pra IS
1758: SELECT progression_rule_cat,
1759: sequence_number
1760: FROM IGS_PR_RU_APPL_ALL pra
1761: WHERE pra.sca_person_id = p_person_id AND
1762: pra.sca_course_cd = p_course_cd;
1763:
1764: CURSOR c_pra_del (

Line 1765: cp_progression_rule_cat IGS_PR_RU_APPL_ALL.progression_rule_cat%TYPE,

1761: WHERE pra.sca_person_id = p_person_id AND
1762: pra.sca_course_cd = p_course_cd;
1763:
1764: CURSOR c_pra_del (
1765: cp_progression_rule_cat IGS_PR_RU_APPL_ALL.progression_rule_cat%TYPE,
1766: cp_sequence_number IGS_PR_RU_APPL_ALL.sequence_number%TYPE) IS
1767: SELECT rowid,pra.*
1768: FROM IGS_PR_RU_APPL_ALL pra
1769: WHERE pra.progression_rule_cat = cp_progression_rule_cat AND

Line 1766: cp_sequence_number IGS_PR_RU_APPL_ALL.sequence_number%TYPE) IS

1762: pra.sca_course_cd = p_course_cd;
1763:
1764: CURSOR c_pra_del (
1765: cp_progression_rule_cat IGS_PR_RU_APPL_ALL.progression_rule_cat%TYPE,
1766: cp_sequence_number IGS_PR_RU_APPL_ALL.sequence_number%TYPE) IS
1767: SELECT rowid,pra.*
1768: FROM IGS_PR_RU_APPL_ALL pra
1769: WHERE pra.progression_rule_cat = cp_progression_rule_cat AND
1770: pra.sequence_number = cp_sequence_number

Line 1768: FROM IGS_PR_RU_APPL_ALL pra

1764: CURSOR c_pra_del (
1765: cp_progression_rule_cat IGS_PR_RU_APPL_ALL.progression_rule_cat%TYPE,
1766: cp_sequence_number IGS_PR_RU_APPL_ALL.sequence_number%TYPE) IS
1767: SELECT rowid,pra.*
1768: FROM IGS_PR_RU_APPL_ALL pra
1769: WHERE pra.progression_rule_cat = cp_progression_rule_cat AND
1770: pra.sequence_number = cp_sequence_number
1771: FOR UPDATE OF pra.LAST_UPDATE_DATE NOWAIT ;
1772:

Line 1780: -- Delete IGS_PR_RU_APPL_ALL records

1776: BEGIN
1777: v_error_flag := FALSE;
1778:
1779: FOR v_pra_rec IN c_pra LOOP
1780: -- Delete IGS_PR_RU_APPL_ALL records
1781: FOR v_pra_upd_exists IN c_pra_del(v_pra_rec.progression_rule_cat,
1782: v_pra_rec.sequence_number ) LOOP
1783: IGS_PR_RU_APPL_PKG.UPDATE_ROW (
1784: X_ROWID => v_pra_upd_exists.rowid,

Line 1825: l_entity_name := 'IGS_PR_RU_APPL_ALL';

1821: END IF;
1822: IF c_pra_del%ISOPEN THEN
1823: CLOSE c_pra_del;
1824: END IF;
1825: l_entity_name := 'IGS_PR_RU_APPL_ALL';
1826: RETURN FALSE;
1827: WHEN OTHERS THEN
1828: IF c_pra%ISOPEN THEN
1829: CLOSE c_pra;