APPS.XLE_ASSOCIATION_PKG dependencies on XLE_ASSOCIATIONS

Line 45: INSERT INTO xle_associations (

41: BEGIN
42:
43:
44:
45: INSERT INTO xle_associations (
46: association_id
47: ,association_type_id
48: ,subject_id
49: ,subject_parent_id

Line 82: xle_associations_s.NEXTVAL

78: ,created_by
79: ,last_update_login
80: )
81: VALUES (
82: xle_associations_s.NEXTVAL
83: ,DECODE(p_association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id)
84: ,DECODE(p_subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id)
85: ,DECODE(p_subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id)
86: ,DECODE(p_object_id, FND_API.G_MISS_NUM, NULL, p_object_id)

Line 159: UPDATE xle_associations SET

155: p_last_update_login IN NUMBER DEFAULT NULL
156: )
157: IS
158: BEGIN
159: UPDATE xle_associations SET
160: association_type_id = DECODE(p_association_type_id, NULL, association_type_id, FND_API.G_MISS_NUM, NULL, p_association_type_id),
161: subject_id = DECODE(p_subject_id, NULL, subject_id, FND_API.G_MISS_NUM, NULL, p_subject_id),
162: subject_parent_id = DECODE(p_subject_parent_id, NULL, subject_parent_id, FND_API.G_MISS_NUM, NULL, p_subject_parent_id),
163: object_id = DECODE(p_object_id, NULL, object_id, FND_API.G_MISS_NUM, NULL, p_object_id),

Line 201: DELETE FROM xle_associations

197: END Update_Row;
198:
199: PROCEDURE Delete_Row(p_association_id IN NUMBER) IS
200: BEGIN
201: DELETE FROM xle_associations
202: WHERE association_id = p_association_id;
203:
204: IF (sql%notfound) THEN
205: RAISE no_data_found;

Line 216: SELECT * FROM xle_associations

212: p_association_id IN NUMBER,
213: p_object_version_number IN NUMBER
214: ) IS
215: CURSOR C IS
216: SELECT * FROM xle_associations
217: WHERE association_id = p_association_id
218: FOR UPDATE OF association_id NOWAIT;
219: Recinfo C%ROWTYPE;
220: BEGIN