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.

[Home] [Help]

APPS.IGS_PS_VAL_COUSR dependencies on IGS_PS_OF_UNT_SET_RL

Line 68: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not

64: p_message_name OUT NOCOPY VARCHAR2 )
65: RETURN BOOLEAN AS
66: BEGIN
67: -- crsp_val_cousr_tree
68: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not
69: -- be created such that a IGS_PS_UNIT set is a parent/ancestor or child/descendant
70: -- of itself.
71: DECLARE
72: v_dummy VARCHAR2(1);

Line 84: p_tmp_sup_us_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,

80: cous.cal_type = p_cal_type AND
81: cous.unit_set_cd = cp_unit_set_cd AND
82: cous.us_version_number = cp_us_version_number;
83: FUNCTION crspl_val_tree_circle (
84: p_tmp_sup_us_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,
85: p_tmp_sup_us_ver_num
86: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE)
87: RETURN BOOLEAN
88: AS

Line 86: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE)

82: cous.us_version_number = cp_us_version_number;
83: FUNCTION crspl_val_tree_circle (
84: p_tmp_sup_us_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,
85: p_tmp_sup_us_ver_num
86: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE)
87: RETURN BOOLEAN
88: AS
89: BEGIN -- crspl_val_tree_circle
90: -- This validation function requires recursion.

Line 94: cp_sup_unit_set_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,

90: -- This validation function requires recursion.
91: DECLARE
92: v_circle_exists BOOLEAN DEFAULT FALSE;
93: CURSOR c_cousr (
94: cp_sup_unit_set_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,
95: cp_sup_us_version_number
96: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE) IS
97: SELECT cousr.sub_unit_set_cd,
98: cousr.sub_us_version_number

Line 96: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE) IS

92: v_circle_exists BOOLEAN DEFAULT FALSE;
93: CURSOR c_cousr (
94: cp_sup_unit_set_cd IGS_PS_OF_UNT_SET_RL.sup_unit_set_cd%TYPE,
95: cp_sup_us_version_number
96: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE) IS
97: SELECT cousr.sub_unit_set_cd,
98: cousr.sub_us_version_number
99: FROM IGS_PS_OF_UNT_SET_RL cousr
100: WHERE cousr.course_cd = p_course_cd AND

Line 99: FROM IGS_PS_OF_UNT_SET_RL cousr

95: cp_sup_us_version_number
96: IGS_PS_OF_UNT_SET_RL.sup_us_version_number%TYPE) IS
97: SELECT cousr.sub_unit_set_cd,
98: cousr.sub_us_version_number
99: FROM IGS_PS_OF_UNT_SET_RL cousr
100: WHERE cousr.course_cd = p_course_cd AND
101: cousr.crv_version_number = p_crv_version_number AND
102: cousr.cal_type = p_cal_type AND
103: cousr.sup_unit_set_cd = cp_sup_unit_set_cd AND

Line 169: -- 4. Validate the IGS_PS_OF_UNT_SET_RL tree to ensure the superior

165: p_sup_us_version_number = p_sub_us_version_number THEN
166: p_message_name := 'IGS_PS_INVALID_RELATION_SUP';
167: RETURN FALSE;
168: END IF;
169: -- 4. Validate the IGS_PS_OF_UNT_SET_RL tree to ensure the superior
170: -- IGS_PS_UNIT set of the relationship does not exist anywhere else in the
171: -- relationship tree (ie; a recursive loop). This must cater for branching
172: -- (ie; multiple dependants).
173: IF crspl_val_tree_circle (

Line 200: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not

196: p_message_name OUT NOCOPY VARCHAR2 )
197: RETURN BOOLEAN AS
198: BEGIN
199: -- crsp_val_cousr_sub
200: -- This module validates that a IGS_PS_OF_UNT_SET_RL record can not
201: -- be created with a IGS_PS_OFR_UNIT_SET as the superior when the
202: -- only_as_sub_ind for that IGS_PS_OFR_UNIT_SET is set to 'Y'.
203: BEGIN
204: -- set default vaule