APPS.IGS_PR_OU_UNIT_PKG dependencies on IGS_PR_RU_OU

Line 79: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (

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

Line 137: PROCEDURE GET_FK_IGS_PR_RU_OU (

133: END IF;
134:
135: END Get_PK_For_Validation;
136:
137: PROCEDURE GET_FK_IGS_PR_RU_OU (
138: x_progression_rule_cat IN VARCHAR2,
139: x_pra_sequence_number IN NUMBER,
140: x_sequence_number IN NUMBER
141: ) AS

Line 165: END GET_FK_IGS_PR_RU_OU;

161: Return;
162: END IF;
163: Close cur_rowid;
164:
165: END GET_FK_IGS_PR_RU_OU;
166:
167: PROCEDURE GET_FK_IGS_PS_UNIT (
168: x_unit_cd IN VARCHAR2
169: ) AS

Line 203: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,

199: || Who When What
200: || (reverse chronological order - newest change first)
201: */
202: CURSOR c_parent (
203: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
204: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
205: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
206: SELECT 1
207: FROM IGS_PR_RU_OU pro

Line 204: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

200: || (reverse chronological order - newest change first)
201: */
202: CURSOR c_parent (
203: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
204: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
205: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
206: SELECT 1
207: FROM IGS_PR_RU_OU pro
208: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND

Line 205: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS

201: */
202: CURSOR c_parent (
203: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
204: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
205: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
206: SELECT 1
207: FROM IGS_PR_RU_OU pro
208: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
209: pro.pra_sequence_number = cp_pra_sequence_number AND

Line 207: FROM IGS_PR_RU_OU pro

203: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
204: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
205: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
206: SELECT 1
207: FROM IGS_PR_RU_OU pro
208: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
209: pro.pra_sequence_number = cp_pra_sequence_number AND
210: pro.sequence_number = cp_sequence_number AND
211: pro.logical_delete_dt is NULL;