DBA Data[Home] [Help]

APPS.ASN_METHODOLOGY_PVT dependencies on AS_RELATIONSHIPS

Line 47: FROM AS_RELATIONSHIPS

43: p_object_id NUMBER,
44: p_related_object_type_code VARCHAR2,
45: p_relationship_type VARCHAR2) IS
46: SELECT 1
47: FROM AS_RELATIONSHIPS
48: WHERE object_type_code = p_object_type_code
49: AND object_id = p_object_id
50: AND relationship_type_code = p_relationship_type
51: AND related_object_type_code = p_related_object_type_code

Line 208: insert into as_relationships

204: l_meth_stage_data.sales_stage_id,
205: 'N');
206:
207: -- Create relationship between the object and the sales stage instance
208: insert into as_relationships
209: (RELATIONSHIP_ID,
210: LAST_UPDATE_DATE,
211: LAST_UPDATED_BY,
212: CREATION_DATE,

Line 222: (as_relationships_s.nextval,

218: RELATED_OBJECT_TYPE_CODE,
219: RELATED_OBJECT_ID,
220: RELATIONSHIP_TYPE_CODE)
221: values
222: (as_relationships_s.nextval,
223: SYSDATE,
224: G_USER_ID,
225: SYSDATE,
226: G_USER_ID,