105:
106: -- Validation of the Manadatory Input Parameters
107:
108:
109: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_context',p_context);
110: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_object_type',p_object_type);
111: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_subject_type',p_subject_type);
112:
113:
106: -- Validation of the Manadatory Input Parameters
107:
108:
109: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_context',p_context);
110: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_object_type',p_object_type);
111: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_subject_type',p_subject_type);
112:
113:
114: -- Validating parameter combinations
107:
108:
109: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_context',p_context);
110: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_object_type',p_object_type);
111: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_subject_type',p_subject_type);
112:
113:
114: -- Validating parameter combinations
115:
112:
113:
114: -- Validating parameter combinations
115:
116: XLE_ASSOC_VALIDATIONS_PVT.Default_Association_Type(p_context,p_subject_type,p_object_type,x_association_type_id);
117:
118:
119: IF (p_subject_id is NULL)
120: THEN
118:
119: IF (p_subject_id is NULL)
120: THEN
121:
122: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_object_id',p_object_id);
123: XLE_ASSOC_VALIDATIONS_PVT.Validate_Object(p_object_type, p_object_id, 'Object Type', 'Object_Id', l_object_type_id);
124:
125:
126: select assoc.subject_id
119: IF (p_subject_id is NULL)
120: THEN
121:
122: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_object_id',p_object_id);
123: XLE_ASSOC_VALIDATIONS_PVT.Validate_Object(p_object_type, p_object_id, 'Object Type', 'Object_Id', l_object_type_id);
124:
125:
126: select assoc.subject_id
127: BULK COLLECT
139:
140: IF (p_object_id is NULL)
141: THEN
142:
143: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_subject_id',p_subject_id);
144: XLE_ASSOC_VALIDATIONS_PVT.Validate_Object(p_subject_type, p_subject_id, 'Subject Type','Subject_Id',l_subject_type_id);
145:
146: select assoc.object_id
147: BULK COLLECT
140: IF (p_object_id is NULL)
141: THEN
142:
143: XLE_ASSOC_VALIDATIONS_PVT.Validate_Mandatory('p_subject_id',p_subject_id);
144: XLE_ASSOC_VALIDATIONS_PVT.Validate_Object(p_subject_type, p_subject_id, 'Subject Type','Subject_Id',l_subject_type_id);
145:
146: select assoc.object_id
147: BULK COLLECT
148: INTO p_assocs