eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PR_OU_PS_PKG dependencies on IGS_PR_RU_OU

Line 89: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (

85: (new_references.pra_sequence_number IS NULL) OR
86: (new_references.pro_sequence_number IS NULL))) THEN
87: NULL;
88: ELSE
89: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (
90: new_references.progression_rule_cat,
91: new_references.pra_sequence_number,
92: new_references.pro_sequence_number
93: ) THEN

Line 158: PROCEDURE GET_FK_IGS_PR_RU_OU (

154: Close cur_rowid;
155:
156: END GET_FK_IGS_PS_COURSE;
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

Line 186: END GET_FK_IGS_PR_RU_OU;

182: Return;
183: END IF;
184: Close cur_rowid;
185:
186: END GET_FK_IGS_PR_RU_OU;
187:
188: PROCEDURE BeforeInsertUpdate( p_action VARCHAR2 ) AS
189: /*
190: || Created By : anilk

Line 198: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,

194: || Who When What
195: || (reverse chronological order - newest change first)
196: */
197: CURSOR c_parent (
198: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
199: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
200: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
201: SELECT 1
202: FROM IGS_PR_RU_OU pro

Line 199: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

195: || (reverse chronological order - newest change first)
196: */
197: CURSOR c_parent (
198: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
199: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
200: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
201: SELECT 1
202: FROM IGS_PR_RU_OU pro
203: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND

Line 200: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS

196: */
197: CURSOR c_parent (
198: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
199: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
200: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
201: SELECT 1
202: FROM IGS_PR_RU_OU pro
203: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
204: pro.pra_sequence_number = cp_pra_sequence_number AND

Line 202: FROM IGS_PR_RU_OU pro

198: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
199: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
200: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
201: SELECT 1
202: FROM IGS_PR_RU_OU pro
203: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
204: pro.pra_sequence_number = cp_pra_sequence_number AND
205: pro.sequence_number = cp_sequence_number AND
206: pro.logical_delete_dt is NULL;