APPS.XLE_ASSOCIATIONS_INFO dependencies on XLE_ASSOCIATIONS

Line 1: PACKAGE BODY XLE_ASSOCIATIONS_INFO AS

1: PACKAGE BODY XLE_ASSOCIATIONS_INFO AS
2: /* $Header: xleasinb.pls 120.2 2006/04/17 07:39:59 akonatha ship $ */
3:
4: /* =======================================================================
5: | Global Data Types

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'XLE_ASSOCIATIONS_INFO';

4: /* =======================================================================
5: | Global Data Types
6: * ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'XLE_ASSOCIATIONS_INFO';
9:
10: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
11: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
12: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;

Line 65: p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,

61: -- ***** Legal Association information parameters *****
62: p_context IN XLE_ASSOCIATION_TYPES.Context%TYPE,
63: p_object_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
64: p_subject_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
65: p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,
66: p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,
67: p_subject_id IN XLE_ASSOCIATIONS.Subject_Id%TYPE,
68: p_assocs OUT NOCOPY tab_assoc)
69:

Line 66: p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,

62: p_context IN XLE_ASSOCIATION_TYPES.Context%TYPE,
63: p_object_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
64: p_subject_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
65: p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,
66: p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,
67: p_subject_id IN XLE_ASSOCIATIONS.Subject_Id%TYPE,
68: p_assocs OUT NOCOPY tab_assoc)
69:
70:

Line 67: p_subject_id IN XLE_ASSOCIATIONS.Subject_Id%TYPE,

63: p_object_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
64: p_subject_type IN XLE_ASSOC_OBJECT_TYPES.Name%TYPE,
65: p_legal_entity_id IN XLE_ASSOCIATIONS.SUBJECT_PARENT_ID%TYPE,
66: p_object_id IN XLE_ASSOCIATIONS.Object_Id%TYPE,
67: p_subject_id IN XLE_ASSOCIATIONS.Subject_Id%TYPE,
68: p_assocs OUT NOCOPY tab_assoc)
69:
70:
71: IS

Line 74: l_subject_type_id XLE_ASSOCIATIONS.Subject_Id%TYPE;

70:
71: IS
72:
73: l_api_name CONSTANT VARCHAR2(40) := 'Get_Associations_Info';
74: l_subject_type_id XLE_ASSOCIATIONS.Subject_Id%TYPE;
75: l_object_type_id XLE_ASSOCIATIONS.Object_Id%TYPE;
76: l_init_msg_list VARCHAR2(40);
77: l_commit VARCHAR2(40);
78: x_association_type_id NUMBER;

Line 75: l_object_type_id XLE_ASSOCIATIONS.Object_Id%TYPE;

71: IS
72:
73: l_api_name CONSTANT VARCHAR2(40) := 'Get_Associations_Info';
74: l_subject_type_id XLE_ASSOCIATIONS.Subject_Id%TYPE;
75: l_object_type_id XLE_ASSOCIATIONS.Object_Id%TYPE;
76: l_init_msg_list VARCHAR2(40);
77: l_commit VARCHAR2(40);
78: x_association_type_id NUMBER;
79:

Line 129: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types

125:
126: select assoc.subject_id
127: BULK COLLECT
128: INTO p_assocs
129: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
130: where assoc.object_id = p_object_id
131: and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
132: and assoc.association_type_id = x_association_type_id
133: and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)

Line 149: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types

145:
146: select assoc.object_id
147: BULK COLLECT
148: INTO p_assocs
149: from XLE_ASSOCIATIONS assoc, XLE_ASSOCIATION_TYPES assoc_types
150: where assoc.subject_id = p_subject_id
151: and assoc_types.ASSOCIATION_TYPE_ID = assoc.ASSOCIATION_TYPE_ID
152: and assoc.association_type_id = x_association_type_id
153: and assoc.subject_parent_id = NVL(p_legal_entity_id,assoc.subject_parent_id)

Line 201: END XLE_ASSOCIATIONS_INFO;

197: p_data => x_msg_data );
198:
199: END Get_Associations_Info;
200:
201: END XLE_ASSOCIATIONS_INFO;
202: