APPS.XLE_ASSOC_VALIDATIONS_PVT dependencies on XLE_ASSOC_OBJECT_TYPES

Line 86: -- IN : p_object_type (Defined in XLE_ASSOC_OBJECT_TYPES)

82: -- DESCRIPTION
83: -- Check whether the Object Type and ID are valid
84: --
85: -- ARGUMENTS :
86: -- IN : p_object_type (Defined in XLE_ASSOC_OBJECT_TYPES)
87: -- p_object_id
88: -- p_param1_name (Object Type Parameter Name - Used in Error Message)
89: -- p_param2_name (Object Id Parameter Name - Used in Error Message)
90: --

Line 108: l_OBJECT_type_rec XLE_ASSOC_OBJECT_TYPES%ROWTYPE;

104: p_param2_name IN VARCHAR2,
105: x_OBJECT_type_id OUT NOCOPY NUMBER )
106: IS
107: l_select_statement VARCHAR2(1000);
108: l_OBJECT_type_rec XLE_ASSOC_OBJECT_TYPES%ROWTYPE;
109: l_cursor INTEGER;
110: l_dummy INTEGER;
111:
112: CURSOR OBJECT_Type_Cursor IS

Line 114: FROM XLE_ASSOC_OBJECT_TYPES

110: l_dummy INTEGER;
111:
112: CURSOR OBJECT_Type_Cursor IS
113: SELECT *
114: FROM XLE_ASSOC_OBJECT_TYPES
115: WHERE name = upper(p_object_type);
116:
117: BEGIN
118:

Line 278: XLE_ASSOC_OBJECT_TYPES ST,

274: BEGIN
275: SELECT AT.ASSOCIATION_TYPE_ID
276: INTO x_association_type_id
277: FROM XLE_ASSOCIATION_TYPES AT,
278: XLE_ASSOC_OBJECT_TYPES ST,
279: XLE_ASSOC_OBJECT_TYPES OT
280: WHERE AT.CONTEXT = p_context
281: AND AT.SUBJECT_TYPE_ID = ST.object_type_id
282: AND ST.NAME = upper (P_SUBJECT_TYPE)

Line 279: XLE_ASSOC_OBJECT_TYPES OT

275: SELECT AT.ASSOCIATION_TYPE_ID
276: INTO x_association_type_id
277: FROM XLE_ASSOCIATION_TYPES AT,
278: XLE_ASSOC_OBJECT_TYPES ST,
279: XLE_ASSOC_OBJECT_TYPES OT
280: WHERE AT.CONTEXT = p_context
281: AND AT.SUBJECT_TYPE_ID = ST.object_type_id
282: AND ST.NAME = upper (P_SUBJECT_TYPE)
283: AND AT.OBJECT_TYPE_ID = OT.object_type_id