DBA Data[Home] [Help]

APPS.XLE_ASSOCIATION_PKG dependencies on XLE_ASSOCIATIONS_S

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),