DBA Data[Home] [Help]

APPS.IGS_AD_LOCATION_REL_PKG dependencies on IGS_OR_VAL_LR

Line 72: IF IGS_OR_VAL_LR.assp_val_lr_lr (

68: IF p_inserting OR p_updating THEN
69: --
70: -- Cannot make a campus (s_location_type = 'CAMPUS') a child of
71: -- an exam centre (s_location_type = 'EXAM_CTR')
72: IF IGS_OR_VAL_LR.assp_val_lr_lr (
73: new_references.location_cd,
74: new_references.sub_location_cd,
75: v_message_name) = FALSE THEN
76: Fnd_Message.Set_Name('IGS',v_message_name);

Line 95: IF IGS_OR_VAL_LR.orgp_val_lr (new_references.location_cd,

91: v_rowid_saved BOOLEAN := FALSE;
92: BEGIN
93:
94: -- Validate location relationship.
95: IF IGS_OR_VAL_LR.orgp_val_lr (new_references.location_cd,
96: new_references.sub_location_cd,
97: v_message_name) = FALSE THEN
98: Fnd_Message.Set_Name('IGS',v_message_name);
99: IGS_GE_MSG_STACK.ADD;

Line 107: IF IGS_OR_VAL_LR.assp_val_lr_dfltslot (

103: -- Can only set default indicator when parent location is a campus and
104: -- child location is an exam location. This is not really a mutating
105: -- trigger but as depends on the result and is mutating then
106: -- handle as such.
107: IF IGS_OR_VAL_LR.assp_val_lr_dfltslot (
108: new_references.location_cd,
109: new_references.sub_location_cd,
110: new_references.dflt_ind,
111: v_message_name) = FALSE THEN

Line 120: --IGS_OR_VAL_LR.genp_set_rowid(l_rowid);

116:
117:
118: -- Validate IGS_AD_LOCATION relationship.
119: -- Save the rowid of the current row.
120: --IGS_OR_VAL_LR.genp_set_rowid(l_rowid);
121: --v_rowid_saved := TRUE; /* This line was commented becuase the variable v_rowid_saved is to be set true */
122: /* only if the record has been inserted into the pl/sql table */
123: -- Cannot call orgp_val_lr because trigger mayl be mutating.
124: