APPS.EAM_ACTIVITYSUPN_PUB dependencies on EAM_SUPPRESSION_RELATIONS

Line 16: This procedure inserts a record in the eam_suppression_relations table

12: /* g_sr_no number ; */
13:
14:
15: /*
16: This procedure inserts a record in the eam_suppression_relations table
17: Parameters :
18: IN : P_API_VERSION IN NUMBER ,
19: P_INIT_MSG_LIST IN VARCHAR2 := FND_API.G_FALSE ,
20: P_COMMIT IN VARCHAR2 := FND_API.G_FALSE ,

Line 194: INSERT INTO eam_suppression_relations

190:
191: /* End validation calls */
192:
193:
194: INSERT INTO eam_suppression_relations
195: (
196: parent_association_id ,
197: child_association_id ,
198: /* (ignored) day_tolerance ,

Line 449: eam_suppression_relations

445: /* validation calls finish */
446:
447:
448: UPDATE
449: eam_suppression_relations
450: SET
451: description = p_description ,
452: attribute_category = p_attribute_category ,
453: attribute1 = p_attribute1 ,

Line 569: FROM eam_suppression_relations

565: IS
566: l_status varchar2(10);
567: BEGIN
568: SELECT 'Exists' INTO l_status
569: FROM eam_suppression_relations
570: WHERE parent_association_id = p_parent_association_id
571: AND child_association_id = p_child_association_id;
572:
573: IF (l_status = 'Exists') THEN

Line 594: FROM eam_suppression_relations a, eam_suppression_relations b

590: l_status varchar2(10);
591: BEGIN
592:
593: SELECT count(*) INTO l_count
594: FROM eam_suppression_relations a, eam_suppression_relations b
595: WHERE a.parent_association_id = b.child_association_id
596: AND a.child_association_id = b.parent_association_id
597: AND a.parent_association_id = p_parent_association_id
598: AND a.child_association_id = p_child_association_id;