APPS.DOM_ASSOCIATIONS_UTIL dependencies on DOM_RELATIONSHIPS

Line 36: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD

32: l_doc_number := NULL;
33:
34: BEGIN
35: SELECT doc_number INTO l_doc_number
36: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
37: WHERE
38: from_entity_name = p_from_entity_name
39: AND from_pk1_value = p_from_pk1_value
40: AND from_pk2_value = p_from_pk2_value

Line 59: INSERT INTO DOM_RELATIONSHIPS (

55: FND_MESSAGE.Set_Token('DOC_NUMBER', l_doc_number);
56: FND_MSG_PUB.Add;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58: ELSE
59: INSERT INTO DOM_RELATIONSHIPS (
60: association_id ,
61: from_entity_name ,
62: from_pk1_value ,
63: from_pk2_value ,

Line 132: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD

128: l_doc_number := NULL;
129:
130: BEGIN
131: SELECT doc_number INTO l_doc_number
132: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
133: WHERE
134: from_entity_name = p_from_entity_name
135: AND from_pk1_value = p_from_pk1_value
136: AND from_pk2_value = p_from_pk2_value

Line 160: DELETE FROM DOM_RELATIONSHIPS

156: x_return_status := FND_API.G_RET_STS_ERROR;
157: ELSE
158:
159:
160: DELETE FROM DOM_RELATIONSHIPS
161: WHERE
162: from_entity_name = p_from_entity_name
163: AND from_pk1_value = p_from_pk1_value
164: AND from_pk2_value = p_from_pk2_value

Line 203: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD

199: l_doc_number := NULL;
200:
201: BEGIN
202: SELECT doc_number INTO l_doc_number
203: FROM DOM_RELATIONSHIPS DR, DOM_DOCUMENTS_VL DD
204: WHERE
205: from_entity_name = p_from_entity_name
206: AND from_pk1_value = p_from_pk1_value
207: AND from_pk2_value = p_from_pk2_value

Line 233: UPDATE DOM_RELATIONSHIPS

229: FND_MSG_PUB.Add;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: ELSE
232:
233: UPDATE DOM_RELATIONSHIPS
234: SET
235: to_pk2_value = p_to_pk2_value
236: WHERE
237: from_entity_name = decode(p_from_entity_name,'MTL_ITEM_REVISIONS','EGO_ITEM_REVISION',decode(p_from_entity_name,'MTL__SYSTEM_ITEMS','EGO_ITEM',p_from_entity_name))