Line 100: CURSOR C2 IS SELECT AS_LEADS_S.nextval FROM sys.dual;
96: p_PRM_REFERRAL_CODE VARCHAR2,
97: p_TOT_REVENUE_OPP_FORECAST_AMT NUMBER) -- Added for ASNB
98:
99: IS 100: CURSOR C2 IS SELECT AS_LEADS_S.nextval FROM sys.dual; 101: BEGIN
102: If (px_LEAD_ID IS NULL) OR (px_LEAD_ID = FND_API.G_MISS_NUM) then
103: OPEN C2;
104: FETCH C2 INTO px_LEAD_ID;