Line 47: CURSOR C2 IS SELECT AS_LEAD_ORDERS_S.nextval FROM sys.dual;
43: -- p_SECURITY_GROUP_ID NUMBER
44: )
45:
46: IS 47: CURSOR C2 IS SELECT AS_LEAD_ORDERS_S.nextval FROM sys.dual; 48: BEGIN
49: If (px_LEAD_ORDER_ID IS NULL) OR (px_LEAD_ORDER_ID = FND_API.G_MISS_NUM) then
50: OPEN C2;
51: FETCH C2 INTO px_LEAD_ORDER_ID;