100: ((new_references.progression_rule_cat IS NULL) OR
101: (new_references.pra_sequence_number IS NULL) OR
102: (new_references.pro_sequence_number IS NULL))) THEN
103: NULL;
104: ELSIF NOT igs_pr_ru_ou_pkg.get_pk_for_validation (
105: new_references.progression_rule_cat,
106: new_references.pra_sequence_number,
107: new_references.pro_sequence_number
108: ) THEN
154:
155: END get_pk_for_validation;
156:
157:
158: PROCEDURE get_fk_igs_pr_ru_ou (
159: x_progression_rule_cat IN VARCHAR2,
160: x_pra_sequence_number IN NUMBER,
161: x_sequence_number IN NUMBER
162: ) AS
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;
193:
194: END get_fk_igs_pr_ru_ou;
195:
196: PROCEDURE BeforeInsertUpdate( p_action VARCHAR2 ) AS
197: /*
198: || Created By : anilk
202: || Who When What
203: || (reverse chronological order - newest change first)
204: */
205: CURSOR c_parent (
206: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
207: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
208: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
209: SELECT 1
210: FROM IGS_PR_RU_OU pro
203: || (reverse chronological order - newest change first)
204: */
205: CURSOR c_parent (
206: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
207: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
208: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
209: SELECT 1
210: FROM IGS_PR_RU_OU pro
211: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
204: */
205: CURSOR c_parent (
206: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
207: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
208: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
209: SELECT 1
210: FROM IGS_PR_RU_OU pro
211: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
212: pro.pra_sequence_number = cp_pra_sequence_number AND
206: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
207: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
208: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
209: SELECT 1
210: FROM IGS_PR_RU_OU pro
211: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
212: pro.pra_sequence_number = cp_pra_sequence_number AND
213: pro.sequence_number = cp_sequence_number AND
214: pro.logical_delete_dt is NULL;