APPS.AS_ISSUE_LISTING_IDFR_PKG dependencies on AS_ISSUE_LISTING_IDFR_S

Line 40: CURSOR C1 IS SELECT AS_ISSUE_LISTING_IDFR_S.nextval FROM sys.dual;

36: p_attribute13 IN VARCHAR2,
37: p_attribute14 IN VARCHAR2,
38: p_attribute15 IN VARCHAR2) IS
39:
40: CURSOR C1 IS SELECT AS_ISSUE_LISTING_IDFR_S.nextval FROM sys.dual;
41:
42: CURSOR C2 IS SELECT ROWID FROM as_issue_listing_idfr
43: WHERE issue_listing_idfr_id = p_issue_listing_idfr_id;
44:

Line 157: UPDATE AS_ISSUE_LISTING_IDFR SET

153: p_attribute15 IN VARCHAR2) IS
154:
155: BEGIN
156:
157: UPDATE AS_ISSUE_LISTING_IDFR SET
158: exchange_id = DECODE(p_exchange_id, FND_API.G_MISS_NUM, exchange_id, p_exchange_id),
159: issue_id = DECODE(p_issue_id, FND_API.G_MISS_NUM, issue_id, p_issue_id),
160: scheme = DECODE(p_scheme, FND_API.G_MISS_CHAR, scheme, p_scheme),
161: value = DECODE(p_value, FND_API.G_MISS_CHAR, value, p_value),