APPS.AS_ISSUE_GROUP_IDFR_PKG dependencies on AS_ISSUE_GROUP_IDFR_S

Line 34: CURSOR C1 IS SELECT AS_ISSUE_GROUP_IDFR_S.nextval FROM sys.dual;

30: p_attribute12 IN VARCHAR2,
31: p_attribute13 IN VARCHAR2,
32: p_attribute14 IN VARCHAR2,
33: p_attribute15 IN VARCHAR2 ) IS
34: CURSOR C1 IS SELECT AS_ISSUE_GROUP_IDFR_S.nextval FROM sys.dual;
35: CURSOR C2 IS SELECT ROWID FROM as_issue_group_idfr
36: WHERE issue_group_idfr_id = p_issue_group_idfr_id;
37: BEGIN
38: IF (p_issue_group_id IS NULL) OR (p_issue_group_id = FND_API.G_MISS_NUM) THEN

Line 131: UPDATE AS_ISSUE_GROUP_IDFR SET

127: p_attribute13 IN VARCHAR2,
128: p_attribute14 IN VARCHAR2,
129: p_attribute15 IN VARCHAR2) IS
130: BEGIN
131: UPDATE AS_ISSUE_GROUP_IDFR SET
132: ISSUE_GROUP_ID = DECODE(p_issue_group_id, FND_API.G_MISS_NUM, issue_group_id, p_issue_group_id),
133: SCHEME = DECODE(p_scheme , FND_API.G_MISS_CHAR, scheme, p_scheme ),
134: VALUE = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),
135: SEARCH_CODE = DECODE(p_search_code , FND_API.G_MISS_CHAR, search_code, p_search_code ),