APPS.AS_ISSUE_RELATIONSHIP_PKG dependencies on AS_ISSUE_RELATIONSHIPS

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 37: CURSOR C2 IS SELECT ROWID FROM as_issue_relationships

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
41: OPEN C1;

Line 45: INSERT INTO AS_ISSUE_RELATIONSHIPS ( issue_relationship_id ,

41: OPEN C1;
42: FETCH C1 INTO p_issue_relationship_id;
43: CLOSE C1;
44: END IF;
45: INSERT INTO AS_ISSUE_RELATIONSHIPS ( issue_relationship_id ,
46: subject_id,
47: object_id,
48: issue_relationship_type,
49: directional_flag,

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

Line 177: DELETE FROM AS_ISSUE_RELATIONSHIPS

173: END UPDATE_ROW;
174:
175: PROCEDURE DELETE_ROW (p_issue_relationship_id IN NUMBER ) IS
176: BEGIN
177: DELETE FROM AS_ISSUE_RELATIONSHIPS
178: WHERE ISSUE_RELATIONSHIP_ID = P_ISSUE_RELATIONSHIP_ID;
179: IF (SQL%NOTFOUND) THEN
180: RAISE NO_DATA_FOUND;
181: END IF;