APPS.AS_ISSUE_RELATIONSHIP_PKG dependencies on AS_ISSUE_RELATIONSHIPS_S

Line 36: CURSOR C1 IS SELECT AS_ISSUE_RELATIONSHIPS_S.nextval FROM sys.dual;

32: p_attribute12 IN VARCHAR2,
33: p_attribute13 IN VARCHAR2,
34: p_attribute14 IN VARCHAR2,
35: p_attribute15 IN VARCHAR2) IS
36: CURSOR C1 IS SELECT AS_ISSUE_RELATIONSHIPS_S.nextval FROM sys.dual;
37: CURSOR C2 IS SELECT ROWID FROM as_issue_relationships
38: WHERE issue_relationship_id = p_issue_relationship_id;
39: BEGIN
40: IF (p_issue_relationship_id IS NULL) OR (p_issue_relationship_id = FND_API.G_MISS_NUM) THEN

Line 140: UPDATE AS_ISSUE_RELATIONSHIPS SET

136: p_attribute13 IN VARCHAR2,
137: p_attribute14 IN VARCHAR2,
138: p_attribute15 IN VARCHAR2) IS
139: BEGIN
140: UPDATE AS_ISSUE_RELATIONSHIPS SET
141: SUBJECT_ID = DECODE(p_subject_id, FND_API.G_MISS_NUM, SUBJECT_ID, p_subject_id),
142: OBJECT_ID = DECODE(p_object_id, FND_API.G_MISS_NUM, OBJECT_ID, p_object_id),
143: ISSUE_RELATIONSHIP_TYPE = DECODE(p_issue_relationship_type, FND_API.G_MISS_CHAR, ISSUE_RELATIONSHIP_TYPE, p_issue_relationship_type),
144: DIRECTIONAL_FLAG = DECODE(p_directional_flag, FND_API.G_MISS_CHAR, DIRECTIONAL_FLAG, p_directional_flag),