52:
53: IS
54: CURSOR Context_Cursor IS
55: SELECT Association_Type_Id
56: FROM XLE_ASSOCIATION_TYPES
57: WHERE CONTEXT = upper(p_context);
58: l_association_type_id NUMBER;
59: BEGIN
60:
229:
230: BEGIN
231: SELECT ASSOCIATION_TYPE_ID
232: INTO x_association_type_id
233: FROM XLE_ASSOCIATION_TYPES
234: WHERE CONTEXT = upper(p_context)
235: AND SUBJECT_TYPE_ID = p_subject_type
236: AND OBJECT_TYPE_ID = p_object_type;
237:
273:
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
322:
323: CURSOR Association_Type_Cursor
324: IS
325: SELECT *
326: FROM XLE_ASSOCIATION_TYPES
327: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
328:
329: CURSOR Association_Subject_Cursor
330: IS
341: WHERE ASSOCIATION_TYPE_ID = p_association_type_id
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:
504:
505: CURSOR Association_Type_Cursor
506: IS
507: SELECT *
508: FROM XLE_ASSOCIATION_TYPES
509: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
510:
511: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
512:
507: SELECT *
508: FROM XLE_ASSOCIATION_TYPES
509: WHERE ASSOCIATION_TYPE_ID = p_association_type_id;
510:
511: l_association_type_rec XLE_ASSOCIATION_TYPES%ROWTYPE;
512:
513: BEGIN
514:
515: OPEN Association_Type_Cursor;