DBA Data[Home] [Help]

APPS.AS_SALES_LEAD_OPP_PKG dependencies on DUAL

Line 49: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_S.nextval FROM sys.dual;

45: p_ATTRIBUTE15 VARCHAR2)
46: -- p_SECURITY_GROUP_ID NUMBER)
47:
48: IS
49: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_S.nextval FROM sys.dual;
50: BEGIN
51: If (px_LEAD_OPPORTUNITY_ID IS NULL) OR (px_LEAD_OPPORTUNITY_ID = FND_API.G_MISS_NUM) then
52: OPEN C2;
53: FETCH C2 INTO px_LEAD_OPPORTUNITY_ID;

Line 406: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_LINES_S.nextval FROM sys.dual;

402: p_ATTRIBUTE15 VARCHAR2)
403: -- p_SECURITY_GROUP_ID NUMBER)
404:
405: IS
406: CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_LINES_S.nextval FROM sys.dual;
407: BEGIN
408: If (px_LEAD_OPP_LINE_ID IS NULL) OR (px_LEAD_OPP_LINE_ID = FND_API.G_MISS_NUM
409: ) then
410: OPEN C2;