APPS.IGS_PR_OU_UNIT_SET_PKG dependencies on IGS_PR_RU_OU

Line 77: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (

73: (new_references.pra_sequence_number IS NULL) OR
74: (new_references.pro_sequence_number IS NULL))) THEN
75: NULL;
76: ELSE
77: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (
78: new_references.progression_rule_cat,
79: new_references.pra_sequence_number,
80: new_references.pro_sequence_number
81: ) THEN

Line 142: PROCEDURE GET_FK_IGS_PR_RU_OU (

138: END IF;
139:
140: END Get_PK_For_Validation;
141:
142: PROCEDURE GET_FK_IGS_PR_RU_OU (
143: x_progression_rule_cat IN VARCHAR2,
144: x_pra_sequence_number IN NUMBER,
145: x_sequence_number IN NUMBER
146: ) AS

Line 170: END GET_FK_IGS_PR_RU_OU;

166: Return;
167: END IF;
168: Close cur_rowid;
169:
170: END GET_FK_IGS_PR_RU_OU;
171:
172: PROCEDURE GET_FK_IGS_EN_UNIT_SET (
173: x_unit_set_cd IN VARCHAR2,
174: x_version_number IN NUMBER

Line 210: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,

206: || Who When What
207: || (reverse chronological order - newest change first)
208: */
209: CURSOR c_parent (
210: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
211: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
212: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
213: SELECT 1
214: FROM IGS_PR_RU_OU pro

Line 211: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

207: || (reverse chronological order - newest change first)
208: */
209: CURSOR c_parent (
210: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
211: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
212: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
213: SELECT 1
214: FROM IGS_PR_RU_OU pro
215: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND

Line 212: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS

208: */
209: CURSOR c_parent (
210: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
211: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
212: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
213: SELECT 1
214: FROM IGS_PR_RU_OU pro
215: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
216: pro.pra_sequence_number = cp_pra_sequence_number AND

Line 214: FROM IGS_PR_RU_OU pro

210: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
211: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
212: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
213: SELECT 1
214: FROM IGS_PR_RU_OU pro
215: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
216: pro.pra_sequence_number = cp_pra_sequence_number AND
217: pro.sequence_number = cp_sequence_number AND
218: pro.logical_delete_dt is NULL;