1 PACKAGE XLE_ASSOCIATIONS_INFO AS
2 /* $Header: xleasins.pls 120.2 2005/09/22 06:07:16 rbasker ship $ */
3
4 TYPE Tab_Assoc IS TABLE OF XLE_ASSOCIATIONS.SUBJECT_ID%TYPE;
5
6 PROCEDURE Get_Associations_Info(
7
8 -- ***** Standard API parameters *****
9 p_init_msg_list IN VARCHAR2,
10 p_commit IN VARCHAR2,
11 x_return_status OUT NOCOPY VARCHAR2,
12 x_msg_count OUT NOCOPY NUMBER,
13 x_msg_data OUT NOCOPY VARCHAR2,
14
15
16 -- ***** Legal Association information parameters *****
17 p_context IN XLE_ASSOCIATION_TYPES.Context%TYPE,
18 p_object_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
19 p_subject_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
20 p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,
21 p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,
22 p_subject_id IN XLE_ASSOCIATIONS. Subject_Id%TYPE,
23 p_assocs OUT NOCOPY Tab_assoc);
24
25
26 END XLE_ASSOCIATIONS_INFO;
27