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_RU_APPL_PKG dependencies on IGS_PR_RU_OU

Line 327: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (

323: (new_references.pro_pra_sequence_number IS NULL) OR
324: (new_references.pro_sequence_number IS NULL))) THEN
325: NULL;
326: ELSE
327: IF NOT IGS_PR_RU_OU_PKG.Get_PK_For_Validation (
328: new_references.pro_progression_rule_cat,
329: new_references.pro_pra_sequence_number,
330: new_references.pro_sequence_number
331: ) THEN

Line 428: IGS_PR_RU_OU_PKG.GET_FK_IGS_PR_RU_APPL (

424: old_references.progression_rule_cat,
425: old_references.sequence_number
426: );
427:
428: IGS_PR_RU_OU_PKG.GET_FK_IGS_PR_RU_APPL (
429: old_references.progression_rule_cat,
430: old_references.sequence_number
431: );
432:

Line 603: PROCEDURE GET_FK_IGS_PR_RU_OU (

599: Close cur_rowid;
600:
601: END GET_FK_IGS_PR_RU_CAT;
602:
603: PROCEDURE GET_FK_IGS_PR_RU_OU (
604: x_progression_rule_cat IN VARCHAR2,
605: x_pra_sequence_number IN NUMBER,
606: x_sequence_number IN NUMBER
607: ) AS

Line 632: END GET_FK_IGS_PR_RU_OU;

628: Return;
629: END IF;
630: Close cur_rowid;
631:
632: END GET_FK_IGS_PR_RU_OU;
633:
634: PROCEDURE GET_FK_IGS_PR_RULE (
635: x_progression_rule_cat IN VARCHAR2,
636: x_progression_rule_cd IN VARCHAR2

Line 733: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,

729: || Who When What
730: || (reverse chronological order - newest change first)
731: */
732: CURSOR c_parent (
733: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
734: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
735: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
736: SELECT 1
737: FROM IGS_PR_RU_OU pro

Line 734: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,

730: || (reverse chronological order - newest change first)
731: */
732: CURSOR c_parent (
733: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
734: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
735: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
736: SELECT 1
737: FROM IGS_PR_RU_OU pro
738: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND

Line 735: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS

731: */
732: CURSOR c_parent (
733: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
734: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
735: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
736: SELECT 1
737: FROM IGS_PR_RU_OU pro
738: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
739: pro.pra_sequence_number = cp_pra_sequence_number AND

Line 737: FROM IGS_PR_RU_OU pro

733: cp_progression_rule_cat IGS_PR_RU_OU.progression_rule_cat%TYPE,
734: cp_pra_sequence_number IGS_PR_RU_OU.pra_sequence_number%TYPE,
735: cp_sequence_number IGS_PR_RU_OU.sequence_number%TYPE ) IS
736: SELECT 1
737: FROM IGS_PR_RU_OU pro
738: WHERE pro.progression_rule_cat = cp_progression_rule_cat AND
739: pro.pra_sequence_number = cp_pra_sequence_number AND
740: pro.sequence_number = cp_sequence_number AND
741: pro.logical_delete_dt is NULL;