APPS.XLE_ASSOC_VALIDATIONS_PVT dependencies on XLE_ASSOCIATIONS

Line 188: FROM XLE_ASSOCIATIONS

184:
185: BEGIN
186: SELECT association_type_id, subject_id, object_id
187: INTO p_association_type_id, p_subject_id, p_object_id
188: FROM XLE_ASSOCIATIONS
189: WHERE ASSOCIATION_ID = p_association_id;
190:
191: EXCEPTION
192: WHEN NO_DATA_FOUND THEN

Line 332: FROM XLE_ASSOCIATIONS

328:
329: CURSOR Association_Subject_Cursor
330: IS
331: SELECT *
332: FROM XLE_ASSOCIATIONS
333: WHERE ASSOCIATION_TYPE_ID = p_association_type_id
334: AND SUBJECT_ID = p_subject_id
335: AND EFFECTIVE_TO IS NULL;
336:

Line 340: FROM XLE_ASSOCIATIONS

336:
337: CURSOR Association_Object_Cursor
338: IS
339: SELECT *
340: FROM XLE_ASSOCIATIONS
341: WHERE ASSOCIATION_TYPE_ID = p_association_type_id
342: AND OBJECT_ID = p_object_id
343: AND EFFECTIVE_TO IS NULL;
344:

Line 346: l_association_subject_rec XLE_ASSOCIATIONS%ROWTYPE;

342: AND OBJECT_ID = p_object_id
343: AND EFFECTIVE_TO IS NULL;
344:
345: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
346: l_association_subject_rec XLE_ASSOCIATIONS%ROWTYPE;
347: l_association_object_rec XLE_ASSOCIATIONS%ROWTYPE;
348:
349:
350: BEGIN

Line 347: l_association_object_rec XLE_ASSOCIATIONS%ROWTYPE;

343: AND EFFECTIVE_TO IS NULL;
344:
345: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
346: l_association_subject_rec XLE_ASSOCIATIONS%ROWTYPE;
347: l_association_object_rec XLE_ASSOCIATIONS%ROWTYPE;
348:
349:
350: BEGIN
351:

Line 427: FROM XLE_ASSOCIATIONS

423: IS
424: BEGIN
425: SELECT effective_from
426: INTO p_effective_from
427: FROM XLE_ASSOCIATIONS
428: WHERE ASSOCIATION_ID = p_association_id;
429:
430: EXCEPTION
431: WHEN NO_DATA_FOUND THEN

Line 580: FROM XLE_ASSOCIATIONS

576:
577: CURSOR Association_Cursor
578: IS
579: SELECT *
580: FROM XLE_ASSOCIATIONS
581: WHERE ASSOCIATION_TYPE_ID = p_association_type_id
582: AND SUBJECT_ID = p_subject_id
583: AND OBJECT_ID = p_object_id;
584:

Line 586: l_association_rec XLE_ASSOCIATIONS%ROWTYPE;

582: AND SUBJECT_ID = p_subject_id
583: AND OBJECT_ID = p_object_id;
584:
585:
586: l_association_rec XLE_ASSOCIATIONS%ROWTYPE;
587: l_effective_from DATE;
588: l_effective_to DATE;
589:
590: BEGIN

Line 760: FROM XLE_ASSOCIATIONS

756: BEGIN
757:
758: SELECT association_id
759: INTO x_association_id
760: FROM XLE_ASSOCIATIONS
761: WHERE association_type_id = p_association_type_id
762: AND subject_id = p_subject_id
763: AND object_id = p_object_id
764: AND effective_to IS NULL;