APPS.IGS_PR_OU_FND_PKG dependencies on IGS_PR_RU_OU

Line 92: ELSIF NOT igs_pr_ru_ou_pkg.get_pk_for_validation (

88: ((new_references.progression_rule_cat IS NULL) OR
89: (new_references.pra_sequence_number IS NULL) OR
90: (new_references.pro_sequence_number IS NULL))) THEN
91: NULL;
92: ELSIF NOT igs_pr_ru_ou_pkg.get_pk_for_validation (
93: new_references.progression_rule_cat,
94: new_references.pra_sequence_number,
95: new_references.pro_sequence_number
96: ) THEN

Line 152: PROCEDURE get_fk_igs_pr_ru_ou (

148: END IF;
149: END get_pk_for_validation;
150:
151:
152: PROCEDURE get_fk_igs_pr_ru_ou (
153: x_progression_rule_cat IN VARCHAR2,
154: x_pra_sequence_number IN NUMBER,
155: x_sequence_number IN NUMBER
156: ) AS

Line 188: END get_fk_igs_pr_ru_ou;

184: RETURN;
185: END IF;
186: CLOSE cur_rowid;
187:
188: END get_fk_igs_pr_ru_ou;
189:
190:
191: PROCEDURE get_fk_igf_aw_fund_cat (
192: x_fund_code IN VARCHAR2

Line 235: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,

231: || Who When What
232: || (reverse chronological order - newest change first)
233: */
234: CURSOR c_parent (
235: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
236: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
237: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
238: SELECT 1
239: FROM IGS_PR_RU_OU pro

Line 236: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

232: || (reverse chronological order - newest change first)
233: */
234: CURSOR c_parent (
235: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
236: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
237: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
238: SELECT 1
239: FROM IGS_PR_RU_OU pro
240: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND

Line 237: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS

233: */
234: CURSOR c_parent (
235: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
236: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
237: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
238: SELECT 1
239: FROM IGS_PR_RU_OU pro
240: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
241: pro.pra_sequence_number = cp_pra_sequence_number AND

Line 239: FROM IGS_PR_RU_OU pro

235: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
236: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
237: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
238: SELECT 1
239: FROM IGS_PR_RU_OU pro
240: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
241: pro.pra_sequence_number = cp_pra_sequence_number AND
242: pro.sequence_number = cp_sequence_number AND
243: pro.logical_delete_dt is NULL;